1. Home
  2. Resources
  3. SAP Tables
  4. TVAP - Sales Document: Item Categories

SAP Table TVAP

Sales Document: Item Categories

TVAP (Sales Document: Item Categories) 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 TVAP to other SAP tables.

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
MENG1 Order quantiy for each item is limited to 1 MENG1 CHAR 1 0
X Yes
NULL No
ALEKZ Create purchase order automatically ALEKZ 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)
SVGNG Activity category for controlling of technical objects SVGNG CHAR 4 0
PMS2 Order
PMS4 Service contract
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
SEGAL Exclusion/Inclusion indicator for declara. to authorities SEGAL T609A CHAR 2 0
STDTE Determine date for bill of materials configuration STDTE CHAR 1 0
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
UVEIB Doc. pricing procedure for incomplete export/import data UVEIB T609B CHAR 3 0
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
REVSP Revenue Distribution Type RR_REVSP CHAR 1 0
NULL 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) RR_REVEVTYP_CUST CHAR 1 0
NULL Not Event-Related
A Incoming Invoice
B Acceptance Date
X Customer-Specific Event: X
Y Customer-Specific Event: Y
Z Customer-Specific Event: Z
N Not POD-Relevant
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
LVART Bill of services type LVART CHAR 2 0
ISM_SE_PLANNING IS-M: Planning Data ISMPLANNING CHAR 2 0
01 Delivery Schedule Object
02 No Planning Records
NULL Demand Records
MILL_SE_KKNMT Indicator for characteristic transfer frm cust-mat-info-rcd MILL_SE_KKNMT CHAR 1 0

TVAP foreign key relationships

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