SAP table TXI_TVAP (Sales Document: Item Categories)

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

TXI_TVAP foreign key relationships

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