SAP VBREVR Revenue Recognition: Reference Document Lines Table
Overview
VBREVR is a standard SAP S/4HANA table that stores Revenue Recognition: Reference Document Lines data. There are total 22 fields in the VBREVR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBREVR belongs to Revenue recognition (SD-BIL-RR) module and is located in the package R/3 billing document appl. development: Revenue recognition (VFE).
In addition, following links provide an overview of foreign key relationships, if any, that link VBREVR to other SAP tables and standard CDS views available based on VBREVR table in S/4HANA 2020.
Techincal Settings of VBREVR
Below are technical details of the table VBREVR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBREVR Fields
The following table gives you an overview of the fields available in VBREVR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales Document | VBELN_VA | CHAR | 10 | |
| POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | |
| BDJPOPER | Posting year and posting period (YYYYMMM format) | RR_BDJPOPER | NUMC | 7 | |
| VBELN_N | Subsequent Sales and Distribution Document | VBELN_NACH | CHAR | 10 | |
| POSNR_N | Subsequent Item of an SD Document | POSNR_NACH | NUMC | 6 | |
| SAKRR | Clearing account for accrued revenues | RR_SAKRR | CHAR | 10 | |
| SAKRRK | Clearing account key (offsetting account) | RR_SAKRR_KEY | CHAR | 10 | |
| SAKRV | G/L Account Number | SAKNR | CHAR | 10 | |
| WRBTR | Amount in Document Currency | WRBTR_CS | CURR | 13 | |
| RVAMT | Revenue amount | RR_RVAMT | CURR | 19 | |
| WAERK | Currency Key | WAERS | TCURC | CUKY | 5 |
| RRSTA | Revenue determination status | RR_STATUS | CHAR | 1 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | |
| DMBTR | Amount in Local Currency | DMBTR_CS | CURR | 13 | |
| RVAMT_LC | Revenue Amount in First Local Currency | RR_RVAMT_LC | CURR | 19 | |
| HWAER | Local Currency | HWAER | TCURC | CUKY | 5 |
| KSTAT | Condition is used for statistics | KSTAT | CHAR | 1 | |
| KRUEK | Condition is Relevant for Accrual (e.g. Freight) | KRUEK | CHAR | 1 | |
| INVUPD | Billing Document has been Changed (VPRS Update) | RR_INVUPD | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBREVR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBREVR | HWAER | 1: CN | TCURC |
| VBREVR | MANDT | 1: CN | T000 |
| VBREVR | WAERK | 1: CN | TCURC |