/BEV1/RBWE SAP (Itemized Proof Rebate Settlement) Table details
Dictionary Type: Table
Description: Itemized Proof Rebate Settlement
Description: Itemized Proof Rebate Settlement
Table field list including key, data, relationships and ABAP select examples
/BEV1/RBWE is a standard SAP Table which is used to store Itemized Proof Rebate Settlement data and is available within R/3 SAP systems depending on the version and release level.
The /BEV1/RBWE table consists of various fields, each holding specific information or linking keys about Itemized Proof Rebate Settlement data available in SAP. These include KNUMH (Condition record number), KUNWE (Customer Numbers), MATNR (Material Number), VBELN (Billing Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP /BEV1/RBWE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KNUMH | Condition record number | KNUMH | CHAR | 10 | KNUMB | ||||
KUNWE | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
VBELN | Billing Document | VBELN_VF | CHAR | 10 | VBUK | ALPHA | VBELN | VF | |
POSNR | Billing item | POSNR_VF | NUMC | 6 | VBUP | POSNR | |||
BUTYP | Type Posting CO-PA/Rebate | /BEV1/RBBUTYP | CHAR | 1 | /BEV1/RBBUTYP | ||||
SIMKEY | Key Simulation Rebate/Allocation CO-PA | /BEV1/RBSIMKY | CHAR | 10 | CHAR010 | ||||
BONEM | Rebate recipient | BONEM | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VBE | |
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
KNUMA_BO | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | Assigned to domain | ALPHA | KNUMA | VMBO | |
KSCHL | Condition type | KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
VAKEY | Variable key 100 bytes | VAKEY | CHAR | 100 | VAKEY | ||||
KOPOS | Sequential number of the condition | KOPOS | NUMC | 2 | NUM02 | ||||
BOART | Agreement type | BOART | CHAR | 4 | Assigned to domain | BOART | VBA | ||
BOMAT | Material for rebate settlement | BOMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
KBETR | Rate (condition amount or percentage) where no scale exists | KBETR_KOND | CURR | 11(2) | WERTV6 | ||||
KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KUMZA | Numerator for converting condition units to base units | KUMZA | DEC | 5 | UMBSZ | ||||
KUMNE | Denominator for converting condition units to base units | KUMNE | DEC | 5 | UMBSN | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KRECH | Calculation type for condition | KRECH | CHAR | 1 | KRECH | ||||
KWAEH | Condition currency (for cumulation fields) | KWAEH | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
STFKZ | Scale Type | STFKZ | CHAR | 1 | STFKZ | ||||
KZBZG | Scale basis indicator | KZBZG | CHAR | 1 | KZBZG | ||||
KONMS | Condition scale unit of measure | KONMS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KONWS | Scale currency | KONWS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
KBRUE | Accrual Amount | KBRUE | CURR | 11(2) | WERTV6 | ||||
BEGAB | Valid-From Date | DATAB | DATS | 8 | DATUM | ||||
ENDAB | Valid To Date | DATBI | DATS | 8 | DATUM | ||||
FKDAT | Billing date for billing index and printout | FKDAT | DATS | 8 | DATUM | ||||
KWERT | Condition value | /BEV1/RBKWERT | CHAR | 19 | /BEV1/RBKWERT | ||||
ZBONBA | Rebate: Accumulated sales volume in local currency | MC_BONBA | CURR | 19(2) | WERTV10 | ||||
ZMENG | Target quantity in sales units | DZMENG | QUAN | 13(3) | MENG13 | ||||
KAWRT_A | Condition base value | KAWRT | CURR | 15(2) | WERTV8 | ||||
KMENG_A | Sales quantity | MC_UMMENGE | QUAN | 15(3) | MENGV15_3 | ||||
KSTBS_A | Scale base value of the condition | KSTBS | CURR | 15(2) | WERTV8 | ||||
RUWRT_A | Rebate: Accrued value in local currency | MC_RUWRT | CURR | 19(2) | WERTV10 | ||||
KWERT_A | Condition base value | KAWRT | CURR | 15(2) | WERTV8 | ||||
KBETS | Rate (condition amount or percentage) where no scale exists | KBETR_KOND | CURR | 11(2) | WERTV6 | ||||
KSTBS | Rebate: Accrued value in local currency | MC_RUWRT | CURR | 19(2) | WERTV10 | ||||
KSTBM | Condition scale quantity | KSTBM | QUAN | 15(3) | MENG15 | ||||
AUBEL | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
BELNR | Document number of line item in Profitability Analysis | RKE_BELNR | CHAR | 10 | ALPHA | BELNR | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
PERDE | Period | PERIODE | NUMC | 3 | NUM3 | GFP | |||
FKART | Billing Type | FKART | CHAR | 4 | TVFK | FKART | |||
HERKUNFT | Origin Rebate Basis/Rebate Planning | /BEV1/RBHRKFT | CHAR | 4 | CHAR4 | ||||
ABRKZ | Settlement Indicator | /BEV1/RBABRKZ | CHAR | 1 | /BEV1/RBABRKZ | ||||
MODUS | Mode | /BEV1/RBMODUS | CHAR | 1 | /BEV1/RBMODUS | ||||
STORKZ | Indicator Rebate Cancellation | /BEV1/RBSTORN | CHAR | 1 | /BEV1/RBSTORN | ||||
ARCHKZ | Status Archiving Log Table Rebate | /BEV1/RBARCH | CHAR | 1 | /BEV1/RBARCH | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEZET | Time last change was made | AEZET | TIMS | 6 | UZEIT | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM |
Key field | Non-key field |
How do I retrieve data from SAP table /BEV1/RBWE using ABAP code
The following ABAP code Example will allow you to do a basic selection on /BEV1/RBWE to SELECT all data from the tableDATA: WA_/BEV1/RBWE TYPE /BEV1/RBWE.
SELECT SINGLE *
FROM /BEV1/RBWE
INTO CORRESPONDING FIELDS OF WA_/BEV1/RBWE
WHERE...
How to access SAP table /BEV1/RBWE
Within an ECC or HANA version of SAP you can also view further information about /BEV1/RBWE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects