SAP table TVAP (Sales Document: Item Categories)

SAP table 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
MENG1 Order quantiy for each item is limited to 1 CHAR 1 0 MENG1
ALEKZ Create purchase order automatically CHAR 1 0 ALEKZ
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)
SVGNG Activity category for controlling of technical objects CHAR 4 0 SVGNG
PMS2 Order
PMS4 Service contract
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
SEGAL Exclusion/Inclusion indicator for declara. to authorities CHAR 2 0 T609A SEGAL
STDTE Determine date for bill of materials configuration CHAR 1 0 STDTE
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
UVEIB Doc. pricing procedure for incomplete export/import data CHAR 3 0 T609B UVEIB
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
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
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
FSH_SEADET Season Determination CHAR 1 0 FSH_SEADET
No Season/Delivery Program Processing
X Season/Delivery Program Processing
FSH_VASS_DETC VAS Determination Mode for Sales and Distribution CHAR 1 0 FSH_VASS_DETC
No Determination
1 Determination and No VAS Item Generation
2 Determination and VAS Item Generation on Save
3 Determination and Instant VAS Item Generation
FSH_AUTODELOC Automatic Deallocation for Sales Document Changes CHAR 1 0 FSH_AUTODELOC
ENH_REJ_LOGIC Enhanced Rejection Logic for Sales Order Item w/ Purchasing CHAR 1 0 ENHANCED_REJECTION_LOGIC
Not Activated
X Activated
AUTO_REJECTION Automatic Rejection of Third-Party Sales Order Items CHAR 1 0 AUTO_SO_ITEM_REJECTION_FROM_PO
Disable Automatic Rejection
A Enable Automatic Rejection
REASON_FOR_REJ Reason for Rejection of Sales Documents CHAR 2 0 TVAG ABGRU_VA
UPDATE_SO_ON_CONF_PO Update Sales Order Item Only From Confirmed PO Item CHAR 1 0 UPDATE_SO_ON_CONF_PO
SPDIPO Take Total Quantity Into Account in Delivery Status CHAR 1 0 SPDIPO
SPDTP Use Total Quantity for Order-Related Billing Status CHAR 1 0 SPDTP
AUTO_DEALLOC Unassign Automatically Items which are Already Assigned CHAR 1 0 ARUN_AUTO_DEALLOC
LVART Bill of services type CHAR 2 0 LVART
MILL_SE_KKNMT Indicator for characteristic transfer frm cust-mat-info-rcd CHAR 1 0 MILL_SE_KKNMT
RFM_COPY_SO_PO Copy item details for account assigned items CHAR 1 0 RFM_COPY_SO_PO
RFM_DIV_CANC Enable diversion due to cancellation of Sales Order Items CHAR 1 0 RFM_DIV_CANC
RFM_DEL_SEAS_CANC Delete season in PO delinked due to cancellation CHAR 1 0 RFM_DEL_SEAS_CANC
RFM_DIV_QTY_REDUCE Enable diversion due to Qty reduction of Sales Order Items CHAR 1 0 RFM_DIV_QTY_REDUCE
RFM_PSST_RULE_DEACT Deactivate PSST CHAR 1 0 RFM_PSST_DEACT_PSTYV
RFM_COPY_SEA Copy season information from SO to PO CHAR 1 0 RFM_COPY_SEA
RFM_NO_COPY_SEA Do not copy season information from SO to PO CHAR 1 0 RFM_NO_COPY_SEA

TVAP foreign key relationships

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