SAP table VBREVR (Revenue Recognition: Reference Document Lines)
SAP table VBREVR has 8 primary key fields being MANDT,VBELN,POSNR,BDJPOPER,VBELN_N,POSNR_N,SAKRR,SAKRRK.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| VBELN | Sales Document | CHAR | 10 | 0 | VBELN_VA | ||
| POSNR | Sales Document Item | NUMC | 6 | 0 | POSNR_VA | ||
| BDJPOPER | Posting year and posting period (YYYYMMM format) | NUMC | 7 | 0 | RR_BDJPOPER | ||
| VBELN_N | Subsequent Sales and Distribution Document | CHAR | 10 | 0 | VBELN_NACH | ||
| POSNR_N | Subsequent Item of an SD Document | NUMC | 6 | 0 | POSNR_NACH | ||
| SAKRR | Clearing account for accrued revenues | CHAR | 10 | 0 | RR_SAKRR | ||
| SAKRRK | Clearing account key (offsetting account) | CHAR | 10 | 0 | RR_SAKRR_KEY | ||
| SAKRV | G/L Account Number | CHAR | 10 | 0 | SAKNR | ||
| WRBTR | Amount in Document Currency | CURR | 13 | 2 | WRBTR_CS | ||
| RVAMT | Revenue amount | CURR | 19 | 2 | RR_RVAMT | ||
| WAERK | Currency Key | CUKY | 5 | 0 | TCURC | WAERS | |
| RRSTA | Revenue determination status | CHAR | 1 | 0 | RR_STATUS | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| ERZET | Entry time | TIMS | 6 | 0 | ERZET | ||
| BUDAT | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||
| DMBTR | Amount in Local Currency | CURR | 13 | 2 | DMBTR_CS | ||
| RVAMT_LC | Revenue Amount in First Local Currency | CURR | 19 | 2 | RR_RVAMT_LC | ||
| HWAER | Local Currency | CUKY | 5 | 0 | TCURC | HWAER | |
| KSTAT | Condition is used for statistics | CHAR | 1 | 0 | KSTAT | ||
| KRUEK | Condition is Relevant for Accrual (e.g. Freight) | CHAR | 1 | 0 | KRUEK | ||
| INVUPD | Billing Document has been Changed (VPRS Update) | CHAR | 1 | 0 | RR_INVUPD |
VBREVR foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 VBREVR | HWAER | TCURC | Currency Codes | MANDT |
| 0 VBREVR | HWAER | TCURC | Currency Codes | WAERS |
| 1 VBREVR | MANDT | T000 | Clients | MANDT |
| 0 VBREVR | WAERK | TCURC | Currency Codes | MANDT |
| 0 VBREVR | WAERK | TCURC | Currency Codes | WAERS |