SAP Table VBREVAV
Revenue Recognition: Worklist
VBREVAV (Revenue Recognition: Worklist) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VBREVAV to other SAP tables.
Source: VBREVAV (Revenue Recognition: Worklist)
VBREVAV table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELKZ | Selection indicator for list screens | SELKZ_LIST | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
STATF | Processing status of documents in billing due list | STATF | CHAR | 4 | 0 | |||||||||||||||
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
VBELN | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||||||||||||||
POSNR | Sales Document Item | POSNR_VA | VBUP | NUMC | 6 | 0 | ||||||||||||||
SAKRR | Clearing account for accrued revenues | RR_SAKRR | CHAR | 10 | 0 | |||||||||||||||
SAKRRK | Clearing account key (offsetting account) | RR_SAKRR_KEY | CHAR | 10 | 0 | |||||||||||||||
ACC_VALUE | Total Accrual Value | RR_ACC_VALUE | CURR | 19 | 2 | |||||||||||||||
WRBTR | Amount in document currency | WRBTR | CURR | 13 | 2 | |||||||||||||||
RVAMT | Revenue amount | RR_RVAMT | CURR | 19 | 2 | |||||||||||||||
WAERK | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||||||||||
BDJPOPER | Posting year and posting period (YYYYMMM format) | RR_BDJPOPER | NUMC | 7 | 0 | |||||||||||||||
ACCPD | Accrual period | RR_ACCPD | DEC | 10 | 5 | |||||||||||||||
BUKRS | Company Code | BUKRS | T001 | CHAR | 4 | 0 | ||||||||||||||
KUNAG | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||||||||||||||
LAND1 | Country of Destination | LLAND | T005 | CHAR | 3 | 0 | ||||||||||||||
AUART | Sales Document Type | AUART | CHAR | 4 | 0 | |||||||||||||||
RRREL | Revenue recognition category | RR_RELTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
RRSTA | Revenue determination status | RR_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
DUKZ | Control indicator for revenue recognition | DUKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
VBELN_V | Preceding sales and distribution document | VBELN_VON | VBUK | CHAR | 10 | 0 | ||||||||||||||
POSNR_V | Preceding item of an SD document | POSNR_VON | VBUP | NUMC | 6 | 0 | ||||||||||||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||
ERZET | Entry time | ERZET | TIMS | 6 | 0 | |||||||||||||||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | 0 | |||||||||||||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | 0 | |||||||||||||||
BASE_DAT | Translation Date | WWERT_D | DATS | 8 | 0 | |||||||||||||||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | 0 | |||||||||||||||
ACC_VALUE_LC | Total Accrual Value in First Local Currency | RR_ACC_VALUE_LC | CURR | 19 | 2 | |||||||||||||||
DMBTR | Amount in Local Currency | DMBTR | CURR | 13 | 2 | |||||||||||||||
RVAMT_LC | Revenue Amount in First Local Currency | RR_RVAMT_LC | CURR | 19 | 2 | |||||||||||||||
HWAER | Local Currency | HWAER | TCURC | CUKY | 5 | 0 | ||||||||||||||
KSTAT | Condition is used for statistics | KSTAT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
KRUEK | Condition is Relevant for Accrual (e.g. Freight) | KRUEK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
SAMMG | Group | SAMMG | CHAR | 10 | 0 | |||||||||||||||
SELKZ_CHECK | Selection indicator for list screens | SELKZ_LIST | CHAR | 1 | 0 |
Possible values
|
VBREVAV foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
VBREVAV | BUKRS | VBREVAV | BUKRS | T001 | Company Codes | BUKRS |
VBREVAV | BUKRS | VBREVAV | MANDT | T001 | Company Codes | MANDT |
VBREVAV | HWAER | VBREVAV | MANDT | TCURC | Currency Codes | MANDT |
VBREVAV | HWAER | VBREVAV | HWAER | TCURC | Currency Codes | WAERS |
VBREVAV | KUNAG | VBREVAV | KUNAG | KNA1 | General Data in Customer Master | KUNNR |
VBREVAV | KUNAG | VBREVAV | MANDT | KNA1 | General Data in Customer Master | MANDT |
VBREVAV | LAND1 | VBREVAV | MANDT | T005 | Countries | MANDT |
VBREVAV | LAND1 | VBREVAV | LAND1 | T005 | Countries | LAND1 |
VBREVAV | MANDT | VBREVAV | MANDT | T000 | Clients | MANDT |
VBREVAV | POSNR | VBREVAV | VBELN | VBUP | Sales Document: Item Status | VBELN |
VBREVAV | POSNR | VBREVAV | POSNR | VBUP | Sales Document: Item Status | POSNR |
VBREVAV | POSNR | VBREVAV | MANDT | VBUP | Sales Document: Item Status | MANDT |
VBREVAV | POSNR_V | VBREVAV | POSNR_V | VBUP | Sales Document: Item Status | POSNR |
VBREVAV | POSNR_V | VBREVAV | VBELN_V | VBUP | Sales Document: Item Status | VBELN |
VBREVAV | POSNR_V | VBREVAV | MANDT | VBUP | Sales Document: Item Status | MANDT |
VBREVAV | VBELN | VBREVAV | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
VBREVAV | VBELN | VBREVAV | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
VBREVAV | VBELN_V | VBREVAV | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
VBREVAV | VBELN_V | VBREVAV | VBELN_V | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
VBREVAV | WAERK | VBREVAV | MANDT | TCURC | Currency Codes | MANDT |
VBREVAV | WAERK | VBREVAV | WAERK | TCURC | Currency Codes | WAERS |