SAP table VBREVE (Revenue Recognition: Revenue Recognition Lines)

SAP table VBREVE has 8 primary key fields being MANDT,VBELN,POSNR,SAKRV,BDJPOPER,POPUPO,VBELN_N,POSNR_N.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
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 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
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
REVVBTYP_SOURCE Document Category of Subsequent Document CHAR 4 0 VBTYPL_N
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
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
KRUEK Condition is Relevant for Accrual (e.g. Freight) CHAR 1 0 KRUEK
COSTREC Relevant for Cost Recognition CHAR 1 0 RR_COSTREC_FLAG

VBREVE foreign key relationships

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