SAP Table V_TVAP

Generated Table for View

V_TVAP (Generated Table for View) 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 V_TVAP to other SAP tables.

Source: V_TVAP (Generated Table for View)

V_TVAP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PSTYV Sales document item category PSTYV TVPT CHAR 4 0
FKREL Relevant for Billing FKREL CHAR 1 0
NULL 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)
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
PRSFD Carry out pricing PRSFD CHAR 1 0
NULL No pricing
X Pricing standard
A Pricing for empties
B Pricing for free goods (100% discount)
POSGR Screen sequence group for document header & item BIFGR TVHB CHAR 4 0
PARGR Partner Determination Procedure PARGR TVPG CHAR 4 0
PSGRP Application CAPID TC04 CHAR 4 0
STULI Material structure STULI CHAR 1 0
ASWPA Manual selection for BOM alternatives ASWPA CHAR 1 0
X Yes
NULL No
STRUM Structural scope of a material with bill of material STRUM CHAR 1 0
NULL 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)
EVRWR Determine cost EVRWR CHAR 1 0
X Yes
NULL No
KOWRR Statistical values KOWRR CHAR 1 0
NULL 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 FELDP TVHF CHAR 4 0
FAKSP Block FAKSP TVFS CHAR 2 0
SHELL Bill of material in foreground SHELL CHAR 1 0
A When creating
B When creating and changing
C Never
ERLRE Completion rule for quotation / contract ERLRE CHAR 1 0
NULL 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 TXN08 CHAR 8 0
DIAFM Dialog for short quantity DIAFM CHAR 1 0
X Yes
NULL No
KDERL Business data allowed at item level? KDERL CHAR 1 0
X Yes
NULL No
TXTGR Text determination procedure TXTGR TTXG CHAR 2 0
POSAR Item type POSAR CHAR 1 0
NULL 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 LFREL_AP CHAR 1 0
X Yes
NULL No
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ETERL Schedule lines allowed ETERL CHAR 1 0
X Yes
NULL No
GWREL Relevant for weight/volume GWREL CHAR 1 0
X Yes
NULL No
KOMPP Form delivery group and correlate BOM components KOMPP CHAR 1 0
NULL Do not form delivery groups
X Form delivery group with one delivery date
A Delivery group with correlated schedule lines
FEHGR Incompletion procedure for sales document FEHGR TVUV CHAR 2 0
SHKZG Returns Item SHKZG_VA CHAR 1 0
X Yes
NULL No
EQMAT Material block indicator EQMAT CHAR 1 0
X Yes
NULL No
STGAP Statistics group for the item category STGAP TVSF CHAR 2 0
KALSM Procedure for item output KALSMBP T683 CHAR 6 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
CMPNT ID: Item with active credit function / relevant for credit CMPNT CHAR 1 0
X Yes
NULL No
STRAT Form of configuration processing STRATCON T476 CHAR 2 0
STSMA Status Profile J_STSMA TJ20 CHAR 8 0
VTEXT Description BEZEI20 CHAR 20 0
ALEKZ Create purchase order automatically ALEKZ CHAR 1 0
X Yes
NULL No
SVGNG Activity category for controlling of technical objects SVGNG CHAR 4 0
PMS2 Order
PMS4 Service contract
MENG1 Order quantiy for each item is limited to 1 MENG1 CHAR 1 0
X Yes
NULL No
FPART Billing/Invoicing Plan Type FPART TFPLA CHAR 2 0
CHAUT Automatic batch determination CHAUT CHAR 1 0
X Yes
NULL No
EXCOP Carry out legal control for item category EXCOP CHAR 1 0
NULL 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 TYPFD CHAR 1 0
X Yes
NULL No
LTYPA Action when material variant determined during configuration LTYPA CHAR 1 0
1 Note (only in Append)
2 Replace configurable material (only in Append)
3 Note (Append and change)
4 Replace configurable material (Append and change)
LTYPV Run ATP check on material variants LTYPV CHAR 1 0
NULL No ATP check
1 Message appears when not completely available
2 Do not substitute if not completely available
WKMAT Value contract material WKMAT MARA CHAR 18 0
RKTIO Response on reaching release order value in value contract RKTIO CHAR 1 0
NULL 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? RDERL CHAR 1 0
X Yes
NULL No
EFFEC Indicator: Assign values for parameter effectivities EFFEC CHAR 1 0
X Yes
NULL No
FFPRF Dynamic Item Processor Profile AD01PROFNR AD01C_PROF CHAR 8 0
SCHEME_RMA Repair procedure: Procedure RMA_SCHEMA TVRMAS CHAR 4 0
SCHEME_VF Variant matching procedure: procedure VF_SCHEMA TVVFS CHAR 4 0
FAKTF Billing form FAKTF CHAR 2 0
01 Fixed rate
02 Costs
RRREL Revenue recognition category RR_RELTYP CHAR 1 0
NULL 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 RR_ACDATV CHAR 1 0
NULL 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) OIB_BOM CHAR 1 0
NULL 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) OIB_CST CHAR 1 0
X Yes
NULL No
OIUSEREXIT Number of the routine used for copying GRPNO NUMC 3 0
MILL_BATCH_REF MP Returns with Batch Reference MILL_BATCH_REF CHAR 1 0
X Yes
NULL No
MILL_BATCH_SEL_D Default Value for Indicator: Batch Selction Control MILL_BATCH_SEL_DEF CHAR 1 0
NULL Batch Selection Criteria from Configuration, Not Changeable
A Batch Selection Criteria Calculated, Changeable
B Batch Selection Criteria Calculated, Not Changeable
C BatchSelCrit from SalesOrd Defaults in Delivery from Config.
D Batch Sel.Crit.from Sales Ord., No Defaults in Delivery
RBACONTROL Control of Rules-Based ATP Check RBACONTROL CHAR 1 0
NULL 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

V_TVAP foreign key relationships

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