SAP table V_TVAP (Generated Table for View)

SAP table V_TVAP 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
FKREL Relevant for Billing CHAR 1 0 FKREL
Not relevant for billing
A Delivery-related billing document
B Relevant for order-related billing - status acc.to order qty
C Relevant for ord.-related billing - status acc.to target qty
D Relevant for pro forma
F Order-related billing doc. - status according to invoice qty
G Order-related billing of the delivery quantity
H Delivery-related billing - no zero quantities
I Order-relevant billing - billing plan
J Relevant for deliveries across EU countries
K Delivery-related invoices for partial quantity
L Pro forma - no zero quantities
M Delivery-related invoices-no zero qtys (incl main batch itm)
N Pro forma - no zero quantities (including main batch items)
O Delivery-rel. invoices for partial quantity - No zero qtys
P Delivery-related invoices for CSFG - No batch split items
Q Delivery-related invoices for CRM
R Delivery-related invoices for CRM - No zero quantities
S IBS-DI: Order-Related Bill. Doc. with DP w/o Billing Plan
T Delivery-Related Invoices for CRM with IB in CRM
U Delivery-Rel. Invoices for CRM with IB in CRM - No Zero Qtys
V Delivery-Related ICB of Stock Transport Orders in CRM
W Delivery-Rel. ICB of StTransportOrders in CRM - No Zero Qtys
X Billing request related via an order related billing plan
Y Intercompany billing – delivery-related invoice
PRSFD Carry out pricing CHAR 1 0 PRSFD
No pricing
A Pricing for empties
B Pricing for free goods (100% discount)
X Pricing standard
POSGR Screen sequence group for document header & item CHAR 4 0 TVHB BIFGR
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
PSGRP Application CHAR 4 0 TC04 CAPID
STULI Material structure CHAR 1 0 STULI
ASWPA Manual selection for BOM alternatives CHAR 1 0 ASWPA
STRUM Structural scope of a material with bill of material CHAR 1 0 STRUM
Do not explode material structure
A Explode single-level bill of material
B Explode multi-level bill of material
C Configuration, no BOM explosion
D Configuration, poss. with BOM explosion
E Structure from Customer_Function (product selection)
PROPAGATE_PAOBJNR_BOM Propagate Profitability Segment to BOM (Sales Kit) Sub-Items CHAR 1 0 SD_SLS_PROPAGATE_PAOBJNR_BOM
Don't Propagate Profitability Sgmt
A Propagate Profitability Sgmt
EVRWR Determine cost CHAR 1 0 EVRWR
KOWRR Statistical Values CHAR 1 0 KOWRR
System will copy item to header totals
X No cumulation - Values cannot be used statistically
Y No cumulation - Values can be used statistically
FELDP Field selection for item CHAR 4 0 TVHF FELDP
FAKSP Billing Block CHAR 2 0 TVFS FAKSP
SHELL Bill of material in foreground CHAR 1 0 SHELL
A When creating
B When creating and changing
C Never
ERLRE Completion Rule for Quotation / Contract CHAR 1 0 ERLRE
Not relevant for completion
A Item is completed with the first reference
B Item is completed after full quantity has been referenced
C Item is completed after the target qty is fully referenced
D Item is referenced via contract release
E Item is completed after full target value is referenced
TXN08 Number of the Standard Text CHAR 8 0 TXN08
DIAFM Dialog for short quantity CHAR 1 0 DIAFM
KDERL Business data allowed at item level? CHAR 1 0 KDERL
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
POSAR Item Type CHAR 1 0 POSAR
Standard Item
A Value Item
B Text item
C Packing item (will be generated)
D Material not relevant
E Packaging Item (External)
LFREL Item Is Relevant for Delivery CHAR 1 0 LFREL_AP
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ETERL Schedule lines allowed CHAR 1 0 ETERL
GWREL Relevant for weight/volume CHAR 1 0 GWREL
KOMPP Form delivery group and correlate BOM components CHAR 1 0 KOMPP
Do not form delivery groups
A Delivery group with correlated schedule lines
X Form delivery group with one delivery date
FEHGR Incompleteness Procedure for Sales Document CHAR 2 0 TVUV FEHGR
SHKZG Returns Item CHAR 1 0 SHKZG_VA
EQMAT Material block indicator CHAR 1 0 EQMAT
STGAP Statistics group for the item category CHAR 2 0 TVSF STGAP
KALSM Procedure for item output CHAR 6 0 T683 KALSMBP
SOBKZ Special Stock Indicator CHAR 1 0 T148 SOBKZ
CMPNT ID: Item with active credit function / relevant for credit CHAR 1 0 CMPNT
STRAT Form of configuration processing CHAR 2 0 T476 STRATCON
STSMA Status Profile CHAR 8 0 TJ20 J_STSMA
VTEXT Description CHAR 20 0 BEZEI20
ALEKZ Create purchase order automatically CHAR 1 0 ALEKZ
SVGNG Activity category for controlling of technical objects CHAR 4 0 SVGNG
PMS2 Order
PMS4 Service contract
MENG1 Order quantiy for each item is limited to 1 CHAR 1 0 MENG1
FPART Billing/Invoicing Plan Type CHAR 2 0 TFPLA FPART
CHAUT Automatic batch determination CHAR 1 0 CHAUT
EXCOP Carry out legal control for item category CHAR 1 0 EXCOP
No check in export license area
A Check in dispatch area (within European Union)
B Check in export area (outside European Union)
C Check in dispatch and export area (incl. domestic market)
D Check in dispatch and export area (excl. domestic market)
TYPFD Carry out variant matching CHAR 1 0 TYPFD
LTYPA Action when material variant determined during configuration CHAR 1 0 LTYPA
1 Note (only in Append)
2 Replace configurable material (only in Append)
3 Note (Append and change)
4 Replace configurable material (Append and change)
V Material w/ Standard Product (Config. with Read/Write Auth.)
W Material w/ Standard Product (Config. w/o Write Auth.)
LTYPV Run ATP check on material variants CHAR 1 0 LTYPV
No ATP check
1 Message appears when not completely available
2 Do not substitute if not completely available
WKMAT Value contract material CHAR 40 0 MARA WKMAT
RKTIO Response on reaching release order value in value contract CHAR 1 0 RKTIO
No response if target value is exceeded
A Warning if target value is exceeded
B Error message if target value is exceeded
C First time target value is exceeded, permitted with warning
D As for 'A' but value contract is not blocked
RDERL Rounding permitted? CHAR 1 0 RDERL
EFFEC Indicator: Assign values for parameter effectivities CHAR 1 0 EFFEC
FFPRF Dynamic Item Processor Profile CHAR 8 0 AD01C_PROF AD01PROFNR
SCHEME_RMA Repair procedure: Procedure CHAR 4 0 TVRMAS RMA_SCHEMA
SCHEME_VF Variant matching procedure: procedure CHAR 4 0 TVVFS VF_SCHEMA
FAKTF Billing form CHAR 2 0 FAKTF
01 Fixed rate
02 Costs
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
OIBOM Use of item category as part of an Oil bill of material(BOM) CHAR 1 0 OIB_BOM
no Oil BoM
1 Oil BoM header quantity summing from components
2 Oil BoM header quantity entered manually
OIBCST Oil BoM cost.(X=..from BoM header;' '=..from BoM components) CHAR 1 0 OIB_CST
OIUSEREXIT Number of the Routine Used for Copying NUMC 3 0 GRPNO
MILL_BATCH_REF MP Returns with Batch Reference CHAR 1 0 MILL_BATCH_REF
MILL_BATCH_SEL_D Default Value for Indicator: Batch Selction Control CHAR 1 0 MILL_BATCH_SEL_DEF
RBACONTROL Control of Rules-Based ATP Check CHAR 1 0 RBACONTROL
Subitems Allowed, Plant Substitution in Item Not Allowed
C Subitems and Plant Substitution in Item Not Allowed
D Subitems Not Allowed, Plant Substitution in Item Allowed
E Subitems and Plant Substitution in Item Allowed
N Rules-Based ATP Check Not Allowed
AUTO_DEALLOC Unassign Automatically Items which are Already Assigned CHAR 1 0 ARUN_AUTO_DEALLOC

V_TVAP foreign key relationships

Table Field Check Table Check Field
0 V_TVAP FAKSP TVFS Billing: Reasons for Blocking FAKSP
1 V_TVAP FEHGR TVUV Incompletion Control: Procedures MANDT
1 V_TVAP FEHGR TVUV Incompletion Control: Procedures FEHGR
0 V_TVAP FELDP TVHF Sales Document: Field Selection Groups MANDT
0 V_TVAP FELDP TVHF Sales Document: Field Selection Groups OBJEKT
0 V_TVAP FELDP TVHF Sales Document: Field Selection Groups FAWGR
1 V_TVAP FFPRF AD01C_PROF DIP profile: Usage MANDT
1 V_TVAP FFPRF AD01C_PROF DIP profile: Usage PROFNR
0 V_TVAP FPART TFPLA Billing Plan Type FPART
1 V_TVAP KALSM T683 Pricing procedures KAPPL
1 V_TVAP KALSM T683 Pricing procedures KALSM
0 V_TVAP MANDT T000 Clients MANDT
1 V_TVAP PARGR TVPG Partner Function Groups PARGR
0 V_TVAP POSGR TVHB Sales Document: Screen Sequence Group MANDT
0 V_TVAP POSGR TVHB Sales Document: Screen Sequence Group OBJEKT
0 V_TVAP POSGR TVHB Sales Document: Screen Sequence Group BIFGR
1 V_TVAP PSGRP TC04 Applic-Specific Criteria for Alternative Determination MANDT
1 V_TVAP PSGRP TC04 Applic-Specific Criteria for Alternative Determination CAPID
0 V_TVAP PSTYV TVPT Sales Documents: Item categories MANDT
0 V_TVAP PSTYV TVPT Sales Documents: Item categories PSTYV
1 V_TVAP SCHEME_RMA TVRMAS Repairs Procedure: Procedures MANDT
1 V_TVAP SCHEME_RMA TVRMAS Repairs Procedure: Procedures SCHEME
0 V_TVAP SCHEME_VF TVVFS Variant Matching Procedure: Procedures MANDT
0 V_TVAP SCHEME_VF TVVFS Variant Matching Procedure: Procedures SCHEME
1 V_TVAP SOBKZ T148 Special Stock Indicator MANDT
1 V_TVAP SOBKZ T148 Special Stock Indicator SOBKZ
0 V_TVAP STGAP TVSF SD: Statistics Groups for Document Types and Item Categories MANDT
1 V_TVAP STRAT T476 Parameterization of the Configuration Editor MANDT
1 V_TVAP STRAT T476 Parameterization of the Configuration Editor SICHT
0 V_TVAP STSMA TJ20 Status profiles MANDT
0 V_TVAP STSMA TJ20 Status profiles STSMA
1 V_TVAP TXTGR TTXG Text Processing: Text ID Groups MANDT
0 V_TVAP WKMAT MARA General Material Data MANDT
0 V_TVAP WKMAT MARA General Material Data MATNR