SAP table VBREVEAV (Revenue Recognition: Worklist (New))

Field Description Data Type Length Decimals Checktable Data Element
STAPO Processing Status of Individual Revenue Lines CHAR 1 0 RR_STAT
MANDT Client CLNT 3 0 T000 MANDT
VBELN Sales Document CHAR 10 0 VBELN_VA
POSNR Sales Document Item NUMC 6 0 POSNR_VA
SAKRV G/L Account Number CHAR 10 0 SAKNR
BDJPOPER Posting year and posting period (YYYYMMM format) NUMC 7 0 RR_BDJPOPER
POPUPO Period sub-item NUMC 3 0 RR_POPUPO
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
WRBTR Period Revenues/Period Costs CURR 13 2 RR_WRBTR_PERREV
RVAMT Deferred Revenues/Costs CURR 19 2 RR_RVAMT_REAL_DR
WAERK Currency Key CUKY 5 0 TCURC WAERS
ACCPD Accrual period DEC 10 5 RR_ACCPD
VBTYP_N SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PRCTR Profit Center CHAR 10 0 PRCTR
SAKDR Account for Deferred Revenues/Costs CHAR 10 0 RR_SAKDR
SAKUR Account for Unbilled Receivables/Costs CHAR 10 0 RR_SAKUR
GSBER Business Area CHAR 4 0 TGSB GSBER
BUKRS Company Code CHAR 4 0 T001 BUKRS
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
SAMMG Group CHAR 10 0 SAMMG
REFFLD FI document reference number CHAR 10 0 RR_REFFLD
RRSTA Revenue determination status CHAR 1 0 RR_STATUS
KUNAG Sold-to Party CHAR 10 0 KUNAG
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
AUFNR Order Number CHAR 12 0 AUFK AUFNR
KOSTL Cost Center CHAR 10 0 KOSTL
KSTAT Condition is used for statistics CHAR 1 0 KSTAT
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
REVFIX Fixed Revenue Line Indicator CHAR 1 0 RR_REVFIX
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
M Migrated to Revenue Accounting
X Customer Reserve I
Y Customer Reserve II
Z Customer Reserve III
RVAMT_SAKUR Unbilled Receivables/Costs CURR 19 2 RR_RVAMT_REAL_UR
ACCOUNT_CHANGE Single-Character Flag CHAR 1 0 CHAR1
REVEVTYP Revenue Event Type CHAR 1 0 RR_REVEVTYP
Not Event-Related
A Incoming Invoice
B Acceptance Date
N Not POD-Relevant
P Proof of Delivery (POD)
X Customer-Specific Event: X
Y Customer-Specific Event: Y
Z Customer-Specific Event: Z
REVEVDOCN Revenue Event Document Number CHAR 10 0 RR_REVEVDOCN
REVEVDOCNI Item Number of Revenue Event NUMC 6 0 RR_REVEVDOCNI
REVEVDAT Revenue Event Date DATS 8 0 RR_REVEVDAT
REVPOBLCK Revenue Posting Block CHAR 1 0 RR_REVPOBLCK
ICON_POBLCK Text field CHAR 29 0 TEXT
DMBTR Period Revenues/Period Costs in Local Currency CURR 13 2 RR_DMBTR_PERREV
RVAMT_LC Deferred Revenues/Costs in Local Currency CURR 19 2 RR_RVAMT_REAL_DR_LC
HWAER Local Currency CUKY 5 0 TCURC HWAER
RVAMT_SAKUR_LC Unbilled Receivables/Costs in Local Currency CURR 19 2 RR_RVAMT_REAL_UR_LC
KRUEK Condition is Relevant for Accrual (e.g. Freight) CHAR 1 0 KRUEK
COSTREC Relevant for Cost Recognition CHAR 1 0 RR_COSTREC_FLAG

VBREVEAV foreign key relationships

Table Field Check Table Check Field
0 VBREVEAV AUFNR AUFK Order master data AUFNR
1 VBREVEAV BEMOT TBMOT Accounting indicators MANDT
1 VBREVEAV BEMOT TBMOT Accounting indicators BEMOT
0 VBREVEAV BUKRS T001 Company Codes BUKRS
1 VBREVEAV GSBER TGSB Business Areas MANDT
1 VBREVEAV GSBER TGSB Business Areas GSBER
0 VBREVEAV HWAER TCURC Currency Codes WAERS
1 VBREVEAV MANDT T000 Clients MANDT
0 VBREVEAV PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
0 VBREVEAV PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
1 VBREVEAV WAERK TCURC Currency Codes MANDT
1 VBREVEAV WAERK TCURC Currency Codes WAERS