SAP table V_TVAPR (Generated Table for View)

SAP table V_TVAPR has 2 primary key fields being MANDT,PSTYV.

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
PSTYV Sales document item category CHAR 4 0 TVPT PSTYV
RRREL Revenue recognition category CHAR 1 0 RR_RELTYP
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
ACDATV Proposed start date for accrual period CHAR 1 0 RR_ACDATV
Not relevant
A Proposal based on contract start date
B Proposal based on billing plan start date
REVSP Revenue Distribution Type CHAR 1 0 RR_REVSP
Total Value: Linear and Correction Value Undistributed
A Total Val.: Linear and Correction Value Linearly Distributed
B Total Value: Billing-Plan-Reld and Corr. Value Undistributed
C Total Val.: Bill.Plan-Reld and Corr. Val. Linearly Distribtd
REVEVTYP Revenue Event Type (Customizing) CHAR 1 0 RR_REVEVTYP_CUST
Not Event-Related
A Incoming Invoice
B Acceptance Date
N Not POD-Relevant
X Customer-Specific Event: X
Y Customer-Specific Event: Y
Z Customer-Specific Event: Z
VTEXT Description CHAR 20 0 BEZEI20

V_TVAPR foreign key relationships

Table Field Check Table Check Field
0 V_TVAPR MANDT T000 Clients MANDT
1 V_TVAPR PSTYV TVPT Sales Documents: Item categories MANDT
1 V_TVAPR PSTYV TVPT Sales Documents: Item categories PSTYV