SAP Table VBREVEAV

Revenue Recognition: Worklist (New)

VBREVEAV (Revenue Recognition: Worklist (New)) 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 VBREVEAV to other SAP tables.

Source: VBREVEAV (Revenue Recognition: Worklist (New))

VBREVEAV table fields

Field Data element Checktable Datatype Length Decimals
STAPO Processing Status of Individual Revenue Lines RR_STAT CHAR 1 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
SAKRV G/L Account Number SAKNR CHAR 10 0
BDJPOPER Posting year and posting period (YYYYMMM format) RR_BDJPOPER NUMC 7 0
POPUPO Period sub-item RR_POPUPO NUMC 3 0
VBELN_N Subsequent sales and distribution document VBELN_NACH VBUK CHAR 10 0
POSNR_N Subsequent item of an SD document POSNR_NACH VBUP NUMC 6 0
WRBTR Period Revenues/Period Costs RR_WRBTR_PERREV CURR 13 2
RVAMT Deferred Revenues/Costs RR_RVAMT_REAL_DR CURR 19 2
WAERK Currency Key WAERS TCURC CUKY 5 0
ACCPD Accrual period RR_ACCPD DEC 10 5
VBTYP_N Document category of subsequent document VBTYP_N CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRCTR Profit Center PRCTR CHAR 10 0
SAKDR Account for Deferred Revenues/Costs RR_SAKDR CHAR 10 0
SAKUR Account for Unbilled Receivables/Costs RR_SAKUR CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
BEMOT Accounting Indicator BEMOT TBMOT CHAR 2 0
SAMMG Group SAMMG CHAR 10 0
REFFLD FI document reference number RR_REFFLD CHAR 10 0
RRSTA Revenue determination status RR_STATUS CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
KUNAG Sold-to party KUNAG CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
VBELV Originating document VBELV VBUK CHAR 10 0
POSNV Originating item POSNV VBUP NUMC 6 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
KOSTL Cost Center KOSTL CHAR 10 0
KSTAT Condition is used for statistics KSTAT CHAR 1 0
X Yes
NULL No
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
REVFIX Fixed Revenue Line Indicator RR_REVFIX CHAR 1 0
NULL Revenue Line Is Not Fixed
A Revenue Line Is Reversed
B Revenue Reversal
C Revenue Correction
D Revenue Line Closed Manually (SAP-Internal)
E Legacy Data Transfer
X Customer Reserve I
Y Customer Reserve II
Z Customer Reserve III
RVAMT_SAKUR Unbilled Receivables/Costs RR_RVAMT_REAL_UR CURR 19 2
ACCOUNT_CHANGE Single-Character Indicator CHAR1 CHAR 1 0
REVEVTYP Revenue Event Type RR_REVEVTYP CHAR 1 0
NULL Not Event-Related
A Incoming Invoice
P Proof of Delivery (POD)
B Acceptance Date
X Customer-Specific Event: X
Y Customer-Specific Event: Y
Z Customer-Specific Event: Z
N Not POD-Relevant
REVEVDOCN Revenue Event Document Number RR_REVEVDOCN CHAR 10 0
REVEVDOCNI Item Number of Revenue Event RR_REVEVDOCNI NUMC 6 0
REVEVDAT Revenue Event Date RR_REVEVDAT DATS 8 0
REVPOBLCK Revenue Posting Block RR_REVPOBLCK CHAR 1 0
X Yes
NULL No
ICON_POBLCK Text field TEXT CHAR 29 0
DMBTR Period Revenues/Period Costs in Local Currency RR_DMBTR_PERREV CURR 13 2
RVAMT_LC Deferred Revenues/Costs in Local Currency RR_RVAMT_REAL_DR_LC CURR 19 2
HWAER Local Currency HWAER TCURC CUKY 5 0
RVAMT_SAKUR_LC Unbilled Receivables/Costs in Local Currency RR_RVAMT_REAL_UR_LC CURR 19 2
KRUEK Condition is Relevant for Accrual (e.g. Freight) KRUEK CHAR 1 0
X Yes
NULL No
COSTREC Relevant for Cost Recognition RR_COSTREC_FLAG CHAR 1 0
X Yes
NULL No

VBREVEAV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBREVEAV AUFNR VBREVEAV AUFNR AUFK Order master data AUFNR
VBREVEAV AUFNR VBREVEAV MANDT AUFK Order master data MANDT
VBREVEAV BEMOT VBREVEAV MANDT TBMOT Accounting indicators MANDT
VBREVEAV BEMOT VBREVEAV BEMOT TBMOT Accounting indicators BEMOT
VBREVEAV BUKRS VBREVEAV MANDT T001 Company Codes MANDT
VBREVEAV BUKRS VBREVEAV BUKRS T001 Company Codes BUKRS
VBREVEAV GSBER VBREVEAV MANDT TGSB Business Areas MANDT
VBREVEAV GSBER VBREVEAV GSBER TGSB Business Areas GSBER
VBREVEAV HWAER SYST MANDT TCURC Currency Codes MANDT
VBREVEAV HWAER VBREVEAV HWAER TCURC Currency Codes WAERS
VBREVEAV MANDT VBREVEAV MANDT T000 Clients MANDT
VBREVEAV POSNR VBREVEAV POSNR VBUP Sales Document: Item Status POSNR
VBREVEAV POSNR VBREVEAV VBELN VBUP Sales Document: Item Status VBELN
VBREVEAV POSNR VBREVEAV MANDT VBUP Sales Document: Item Status MANDT
VBREVEAV POSNR_N VBREVEAV VBELN_N VBUP Sales Document: Item Status VBELN
VBREVEAV POSNR_N VBREVEAV POSNR_N VBUP Sales Document: Item Status POSNR
VBREVEAV POSNR_N VBREVEAV MANDT VBUP Sales Document: Item Status MANDT
VBREVEAV POSNV VBREVEAV MANDT VBUP Sales Document: Item Status MANDT
VBREVEAV POSNV VBREVEAV VBELV VBUP Sales Document: Item Status VBELN
VBREVEAV POSNV VBREVEAV POSNV VBUP Sales Document: Item Status POSNR
VBREVEAV PS_PSP_PNR VBREVEAV PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
VBREVEAV PS_PSP_PNR VBREVEAV MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
VBREVEAV VBELN VBREVEAV VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBREVEAV VBELN VBREVEAV MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBREVEAV VBELN_N VBREVEAV VBELN_N VBUK Sales Document: Header Status and Administrative Data VBELN
VBREVEAV VBELN_N VBREVEAV MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBREVEAV VBELV VBREVEAV MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBREVEAV VBELV VBREVEAV VBELV VBUK Sales Document: Header Status and Administrative Data VBELN
VBREVEAV WAERK VBREVEAV WAERK TCURC Currency Codes WAERS
VBREVEAV WAERK VBREVEAV MANDT TCURC Currency Codes MANDT