SAP table TVEP (Sales Document: Schedule Line Categories)

SAP table TVEP has 2 primary key fields being MANDT,ETTYP.

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 * MANDT
ETTYP Schedule line category CHAR 2 0 ETTYP
ASWET Sales order schedule line history CHAR 1 0 ASWET
LFREL Item is relevant for delivery CHAR 1 0 LFREL
BDART Requirement type CHAR 2 0 BDART
PLART Planning type CHAR 1 0 * PLART
ENTLG Schedule line type CHAR 1 0 ENTLG
EBANF Create purchase requisition CHAR 1 0 EBANF
BSART Order Type (Purchasing) CHAR 4 0 T161 BSART
BSTYP Purchasing Document Category CHAR 1 0 BSTYP
A Request for quotation
B Purchase requisition
C Central Contract
F Purchase order
I Info record
K Contract
L Scheduling agreement
N Central Request for Quotation
O Quotation
Q Service entry sheet
R Request for Quotation
S Simplified service entry sheet
T Central Quotation
W Source list
BWART Movement type (inventory management) CHAR 3 0 T156 BWART
AUBST Purchase requisition with delivery scheduling CHAR 1 0 AUBST
LIFSP Default Delivery Block CHAR 2 0 TVLS LIFSP
TXN08 Number of the Standard Text CHAR 8 0 TXN08
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
FEHGR Incompleteness Procedure for Sales Document CHAR 2 0 TVUV FEHGR
PSTYP Item category in purchasing document CHAR 1 0 T163 PSTYP
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
ATPPR Availability check for sales CHAR 1 0 VFPPR
BEDSD Transfer of requirements / Begin assembly order from SD CHAR 1 0 BEDSD
BWA1S Movement Type: One-Step Procedure CHAR 3 0 T156 BWA1S
QUOTA Product allocation active CHAR 1 0 QUOTA
MSR_BWART_FREE Movement Type for Goods Receipt into Free Available Stock CHAR 3 0 T156 MSR_MOVTYP_FREE
MSR_BWART_SPEC Movement Type for Goods Receipt into Specified Stock CHAR 3 0 T156 MSR_MOVTYP_SPECIFIED
SITBW Movement Type for Issuing Valuated Stock in Transit CHAR 3 0 T156 SITBW
SITKZ Specification for Issuing Valuated Stock in Transit CHAR 1 0 SITKZ
1 GI from Issuing Valuated SiT to Receiving Valuated SiT
2 GI from Issuing Valuated SiT to Receiving Plant
3 SO-Related GI from Issuing Valuated Stock in Transit
C Correction posting for issuing stock in transit
I Goods Receipt for Inbound Delivery from Receiving Val. SiT
N Not Relevant
R GI for return outbound delivery to Receiving Valuated SiT
X GI from Issuing Plant to Receiving Valuated Stock in Transit
BWA1B Movement Type for One-Step Stock Transfer with SC Stock CHAR 3 0 T156 BWA1B
MSR_BWART_RO Movement Type for Goods Movement into Repair Order Stock CHAR 3 0 T156 MSR_MOVTYP_RO
UPDSC Update Schedule Line from Purchase Order CHAR 1 0 UPDSC
UPDSC_EXT Update Schedule Lines from External Procurement CHAR 1 0 UPDSC_EXT
No Update
1 Only for Goods Receipt
2 For Goods Receipt and Shipping Notification
CAPEX External capacity planning CHAR 1 0 CAPEX

TVEP foreign key relationships

Table Field Check Table Check Field
0 TVEP BSART T161 Purchasing Document Types MANDT
1 TVEP BWA1B T156 Movement Type MANDT
1 TVEP BWA1B T156 Movement Type BWART
0 TVEP BWA1S T156 Movement Type MANDT
0 TVEP BWA1S T156 Movement Type BWART
1 TVEP BWART T156 Movement Type MANDT
1 TVEP BWART T156 Movement Type BWART
0 TVEP FEHGR TVUV Incompletion Control: Procedures MANDT
0 TVEP FEHGR TVUV Incompletion Control: Procedures FEHGR
1 TVEP KNTTP T163K Account Assignment Categories in Purchasing Document MANDT
1 TVEP KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
0 TVEP LIFSP TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 TVEP LIFSP TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 TVEP MSR_BWART_FREE T156 Movement Type MANDT
1 TVEP MSR_BWART_FREE T156 Movement Type BWART
0 TVEP MSR_BWART_RO T156 Movement Type MANDT
0 TVEP MSR_BWART_RO T156 Movement Type BWART
1 TVEP MSR_BWART_SPEC T156 Movement Type MANDT
1 TVEP MSR_BWART_SPEC T156 Movement Type BWART
0 TVEP PSTYP T163 Item Categories in Purchasing Document MANDT
0 TVEP PSTYP T163 Item Categories in Purchasing Document PSTYP
1 TVEP SITBW T156 Movement Type MANDT
1 TVEP SITBW T156 Movement Type BWART