SAP table VBREVAV (Revenue Recognition: Worklist)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SELKZ | Selection indicator for list screens | CHAR | 1 | 0 | SELKZ_LIST | ||||||||||||||
| STATF | Processing status of documents in billing due list | CHAR | 4 | 0 | STATF | ||||||||||||||
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||
| VBELN | Sales Document | CHAR | 10 | 0 | * | VBELN_VA | |||||||||||||
| POSNR | Sales Document Item | NUMC | 6 | 0 | * | POSNR_VA | |||||||||||||
| SAKRR | Clearing account for accrued revenues | CHAR | 10 | 0 | * | RR_SAKRR | |||||||||||||
| SAKRRK | Clearing account key (offsetting account) | CHAR | 10 | 0 | * | RR_SAKRR_KEY | |||||||||||||
| ACC_VALUE | Total Accrual Value | CURR | 19 | 2 | RR_ACC_VALUE | ||||||||||||||
| 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 | |||||||||||||
| BDJPOPER | Posting year and posting period (YYYYMMM format) | NUMC | 7 | 0 | RR_BDJPOPER | ||||||||||||||
| ACCPD | Accrual period | DEC | 10 | 5 | RR_ACCPD | ||||||||||||||
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |||||||||||||
| KUNAG | Sold-to Party | CHAR | 10 | 0 | KNA1 | KUNAG | |||||||||||||
| LAND1 | Destination Country/Region | CHAR | 3 | 0 | T005 | LLAND | |||||||||||||
| AUART | Sales Document Type | CHAR | 4 | 0 | * | AUART | |||||||||||||
| RRREL | Revenue recognition category | CHAR | 1 | 0 | RR_RELTYP |
|
|||||||||||||
| RRSTA | Revenue determination status | CHAR | 1 | 0 | RR_STATUS | ||||||||||||||
| DUKZ | Control indicator for revenue recognition | CHAR | 1 | 0 | DUKZ | ||||||||||||||
| VBELN_V | Preceding sales and distribution document | CHAR | 10 | 0 | * | VBELN_VON | |||||||||||||
| POSNR_V | Preceding Item of an SD Document | NUMC | 6 | 0 | * | POSNR_VON | |||||||||||||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||||||||||||||
| ERZET | Entry time | TIMS | 6 | 0 | ERZET | ||||||||||||||
| PAOBJNR | Profitability Segment Number (CO-PA) | NUMC | 10 | 0 | RKEOBJNR | ||||||||||||||
| PRCTR | Profit Center | CHAR | 10 | 0 | PRCTR | ||||||||||||||
| BASE_DAT | Translation date | DATS | 8 | 0 | WWERT_D | ||||||||||||||
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | NUMC | 8 | 0 | * | PS_PSP_PNR | |||||||||||||
| ACC_VALUE_LC | Total Accrual Value in First Local Currency | CURR | 19 | 2 | RR_ACC_VALUE_LC | ||||||||||||||
| 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 | ||||||||||||||
| SAMMG | Group | CHAR | 10 | 0 | SAMMG | ||||||||||||||
| SELKZ_CHECK | Selection indicator for list screens | CHAR | 1 | 0 | SELKZ_LIST |
VBREVAV foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 VBREVAV | BUKRS | T001 | Company Codes | BUKRS |
| 1 VBREVAV | HWAER | TCURC | Currency Codes | MANDT |
| 1 VBREVAV | HWAER | TCURC | Currency Codes | WAERS |
| 0 VBREVAV | KUNAG | KNA1 | General Data in Customer Master | MANDT |
| 0 VBREVAV | KUNAG | KNA1 | General Data in Customer Master | KUNNR |
| 1 VBREVAV | LAND1 | T005 | Countries | MANDT |
| 1 VBREVAV | LAND1 | T005 | Countries | LAND1 |
| 0 VBREVAV | MANDT | T000 | Clients | MANDT |
| 1 VBREVAV | WAERK | TCURC | Currency Codes | MANDT |
| 1 VBREVAV | WAERK | TCURC | Currency Codes | WAERS |