SAP VBREVK Revenue Recognition: Control Lines Table
Overview
VBREVK is a standard SAP S/4HANA table that stores Revenue Recognition: Control Lines data. There are total 32 fields in the VBREVK table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBREVK 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 VBREVK to other SAP tables and standard CDS views available based on VBREVK table in S/4HANA 2020.
Techincal Settings of VBREVK
Below are technical details of the table VBREVK
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBREVK Fields
The following table gives you an overview of the fields available in VBREVK
| 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 | |
| SAKRR | Clearing account for accrued revenues | RR_SAKRR | CHAR | 10 | |
| SAKRRK | Clearing account key (offsetting account) | RR_SAKRR_KEY | CHAR | 10 | |
| ACC_VALUE | Total Accrual Value | RR_ACC_VALUE | CURR | 19 | |
| WRBTR | Amount in Document Currency | WRBTR_CS | CURR | 13 | |
| RVAMT | Revenue amount | RR_RVAMT | CURR | 19 | |
| WAERK | Currency Key | WAERS | TCURC | CUKY | 5 |
| BDJPOPER | Posting year and posting period (YYYYMMM format) | RR_BDJPOPER | NUMC | 7 | |
| ACCPD | Accrual period | RR_ACCPD | DEC | 10 | |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| KUNAG | Sold-To Party | KUNAG | KNA1 | CHAR | 10 |
| LAND1 | Destination Country/Region | LLAND | T005 | CHAR | 3 |
| AUART | Sales Document Type | AUART | CHAR | 4 | |
| RRREL | Revenue recognition category | RR_RELTYP | CHAR | 1 | |
| RRSTA | Revenue determination status | RR_STATUS | CHAR | 1 | |
| DUKZ | Control indicator for revenue recognition | DUKZ | CHAR | 1 | |
| VBELN_V | Preceding sales and distribution document | VBELN_VON | CHAR | 10 | |
| POSNR_V | Preceding Item of an SD Document | POSNR_VON | NUMC | 6 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | |
| PRCTR | Profit Center | PRCTR | CHAR | 10 | |
| BASE_DAT | Translation date | WWERT_D | DATS | 8 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | |
| ACC_VALUE_LC | Total Accrual Value in First Local Currency | RR_ACC_VALUE_LC | CURR | 19 | |
| 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 |
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 VBREVK
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBREVK | BUKRS | 1: CN | T001 |
| VBREVK | HWAER | 1: CN | TCURC |
| VBREVK | KUNAG | 1: CN | KNA1 |
| VBREVK | LAND1 | C: CN | T005 |
| VBREVK | MANDT | 1: CN | T000 |
| VBREVK | WAERK | 1: CN | TCURC |