RBEX SAP (Persistent Key Figures Header and Item) Table details
Dictionary Type: Table
Description: Persistent Key Figures Header and Item
Description: Persistent Key Figures Header and Item
Table field list including key, data, relationships and ABAP select examples
RBEX is a standard SAP Table which is used to store Persistent Key Figures Header and Item data and is available within R/3 SAP systems depending on the version and release level.
The RBEX table consists of various fields, each holding specific information or linking keys about Persistent Key Figures Header and Item data available in SAP. These include MANDT (Client), BELNR (Accounting Document Number), BUZEI (Document Item in Invoice Document), GJAHR (Fiscal Year).. 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: Can Be Enhanced (Deep)
SAP RBEX 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 | Assigned to domain | MANDT | |||
| BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
| BUZEI | Document Item in Invoice Document | RBLGP | NUMC | 6 | NUMC6 | ||||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| COBL_NR | Four Character Sequential Number for Coding Block | COBL_NR | NUMC | 4 | COBL_NR | ||||
| BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | UMBSZ | ||||
| BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | UMBSN | ||||
| NETWR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
| BSMNG | Quantity Ordered Against this Purchase Requisition | BSMNG | QUAN | 13(3) | MENG13 | ||||
| WEMNG | Quantity of Goods Received | WEMNG | QUAN | 13(3) | MENG13 | ||||
| REMNG | Quantity invoiced | REMNG | QUAN | 13(3) | MENG13 | ||||
| BPREM | Invoice receipt quantity in order price unit | BPREM | QUAN | 13(3) | MENG13 | ||||
| BPWEM | Goods Receipt Quantity in Purchase Order Price Unit | BPWEM | QUAN | 13(3) | MENG13 | ||||
| REEWR | Invoice Value Entered (in Local Currency) | REEWR | CURR | 13(2) | WRTV7 | ||||
| REFWR | Invoice value in foreign currency | REFWR | CURR | 13(2) | WRTV7 | ||||
| REWRT | Invoice value in local currency | REWRT | CURR | 13(2) | WRTV7 | ||||
| REWWR | Invoice Amount in Foreign Currency | REWWR | CURR | 13(2) | WERT7 | ||||
| WENWR | Accepted net value of service in foreign currency | WENWR | CURR | 13(2) | WERT7 | ||||
| WEWRT | Value of goods received in local currency | WEWRT | CURR | 13(2) | WERT7 | ||||
| WEWWR | Value of goods received in foreign currency | WEWWR | CURR | 13(2) | WERT7 | ||||
| NOQUANTITY | No quantity logic (document item without quantity) | NOQUANTITY | CHAR | 1 | XFELD | ||||
| PRDIFF | Price Difference in Local Currency | PRDIFF | CURR | 13(2) | WERTV7 | ||||
| DIFFN | Document Balance | RPDIFN | CURR | 13(2) | WERTV7 | ||||
| DIFFMW | Sales Tax Portion of the Invoice Verification Difference | DIFFMW | CURR | 13(2) | WERTV7 | ||||
| MRM_ZLSPR | Logistics payment block | MRM_ZLSPR | CHAR | 1 | MRM_ZLSPR | ||||
| DMBTR | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
| MATKL | Material Group | MATKL | CHAR | 9 | Assigned to domain | MATKL | MKL | S_WBWG |
| Key field | Non-key field |
How do I retrieve data from SAP table RBEX using ABAP code
The following ABAP code Example will allow you to do a basic selection on RBEX to SELECT all data from the tableDATA: WA_RBEX TYPE RBEX.
SELECT SINGLE *
FROM RBEX
INTO CORRESPONDING FIELDS OF WA_RBEX
WHERE...
How to access SAP table RBEX
Within an ECC or HANA version of SAP you can also view further information about RBEX 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