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
NULL Not selected
* Selected and processed
X Selected but not yet processed
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
NULL Standard revenue recognition
A Time-related revenue recognition
B Service-related revenue recognition
D Billing-related, time-related revenue recognition
E Billing-related, service-related revenue recognition (IS-M)
F Credit/Debit Memos with reference to predecessor
RRSTA Revenue determination status RR_STATUS CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
DUKZ Control indicator for revenue recognition DUKZ CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
KRUEK Condition is Relevant for Accrual (e.g. Freight) KRUEK CHAR 1 0
X Yes
NULL No
SAMMG Group SAMMG CHAR 10 0
SELKZ_CHECK Selection indicator for list screens SELKZ_LIST CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed

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