SAP VBREVE Revenue Recognition: Revenue Recognition Lines Table
Overview
VBREVE is a standard SAP S/4HANA table that stores Revenue Recognition: Revenue Recognition Lines data. There are total 45 fields in the VBREVE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBREVE 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 VBREVE to other SAP tables and standard CDS views available based on VBREVE table in S/4HANA 2020.
Techincal Settings of VBREVE
Below are technical details of the table VBREVE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBREVE Fields
The following table gives you an overview of the fields available in VBREVE
| 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 | |
| SAKRV | G/L Account Number | SAKNR | CHAR | 10 | |
| BDJPOPER | Posting year and posting period (YYYYMMM format) | RR_BDJPOPER | NUMC | 7 | |
| POPUPO | Period sub-item | RR_POPUPO | NUMC | 3 | |
| VBELN_N | Subsequent Sales and Distribution Document | VBELN_NACH | CHAR | 10 | |
| POSNR_N | Subsequent Item of an SD Document | POSNR_NACH | NUMC | 6 | |
| WRBTR | Amount in Document Currency | WRBTR_CS | CURR | 13 | |
| RVAMT | Revenue amount | RR_RVAMT | CURR | 19 | |
| WAERK | Currency Key | WAERS | TCURC | CUKY | 5 |
| ACCPD | Accrual period | RR_ACCPD | DEC | 10 | |
| VBTYP_N | SD Document Category | VBTYPL | CHAR | 4 | |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | |
| PRCTR | Profit Center | PRCTR | CHAR | 10 | |
| SAKDR | Account for Deferred Revenues/Costs | RR_SAKDR | CHAR | 10 | |
| SAKUR | Account for Unbilled Receivables/Costs | RR_SAKUR | CHAR | 10 | |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| BEMOT | Accounting Indicator | BEMOT | TBMOT | CHAR | 2 |
| SAMMG | Group | SAMMG | CHAR | 10 | |
| REFFLD | FI document reference number | RR_REFFLD | CHAR | 10 | |
| RRSTA | Revenue determination status | RR_STATUS | CHAR | 1 | |
| KUNAG | Sold-To Party | KUNAG | CHAR | 10 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| VBELV | Originating Document | VBELV | CHAR | 10 | |
| POSNV | Originating item | POSNV | NUMC | 6 | |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | |
| KSTAT | Condition is used for statistics | KSTAT | 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 | |
| REVFIX | Fixed Revenue Line Indicator | RR_REVFIX | CHAR | 1 | |
| REVVBTYP_SOURCE | Document Category of Subsequent Document | VBTYPL_N | CHAR | 4 | |
| REVEVTYP | Revenue Event Type | RR_REVEVTYP | CHAR | 1 | |
| REVEVDOCN | Revenue Event Document Number | RR_REVEVDOCN | CHAR | 10 | |
| REVEVDOCNI | Item Number of Revenue Event | RR_REVEVDOCNI | NUMC | 6 | |
| REVEVDAT | Revenue Event Date | RR_REVEVDAT | DATS | 8 | |
| REVPOBLCK | Revenue Posting Block | RR_REVPOBLCK | CHAR | 1 | |
| 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 |
| KRUEK | Condition is Relevant for Accrual (e.g. Freight) | KRUEK | CHAR | 1 | |
| COSTREC | Relevant for Cost Recognition | RR_COSTREC_FLAG | 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 VBREVE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBREVE | AUFNR | C: CN | AUFK |
| VBREVE | BEMOT | C: CN | TBMOT |
| VBREVE | BUKRS | : | T001 |
| VBREVE | GSBER | C: CN | TGSB |
| VBREVE | HWAER | 1: CN | TCURC |
| VBREVE | MANDT | 1: CN | T000 |
| VBREVE | PS_PSP_PNR | C: CN | PRPS |
| VBREVE | WAERK | 1: CN | TCURC |