SAP table TVLP (Deliveries: Item Categories)

SAP table TVLP 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 Delivery item category CHAR 4 0 TVPT PSTYV_VL
MATN0 Material Quantity 0 Allowed CHAR 1 0 MATN0
SPEMT Dummy function in length 1 CHAR 1 0 DUMMY
MATPR Dummy function in length 1 CHAR 1 0 DUMMY
MNG0P Quantity 0 CHAR 1 0 MNG0P
MINMG Minimum Quantity CHAR 1 0 MINMG
UEBPR Overdelivery CHAR 1 0 UEBPR
VERPR Switch off availability check for delivery item CHAR 1 0 LFVER
Check availability
X Do not check availability
Y Do not check avail. when reporting results of pick.request
KOMRL Relevant for Picking or Putaway CHAR 1 0 KOMRL
LGOZW Storage Location is Mandatory CHAR 1 0 LGOZW
BELGO Determine Storage Location CHAR 1 0 BELGO
POSGR Group of doc.items for screen sequence CHAR 4 0 POSGR
FELDP Field selection for item CHAR 4 0 FELDP
BILDP Dummy function in length 1 CHAR 1 0 DUMMY
TXN08 Number of the Standard Text CHAR 8 0 TXN08
PARGR Partner Determination Procedure CHAR 4 0 PARGR
ASWPL Dummy function in length 1 CHAR 1 0 DUMMY
TXTGR Text Determination Procedure CHAR 2 0 TXTGR
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
STGAP Statistics group for the item category CHAR 2 0 TVSF STGAP
CHPKZ No Batch Check CHAR 1 0 CHPKZ
KALSM Procedure for item output CHAR 6 0 T683 KALSMBP
PCKPF Packing Control CHAR 1 0 PCKPF
Can be packed
A Must be packed
B Cannot be packed
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)
TPREL Indicator: Relevance for transport of deliv. item categories CHAR 1 0 TPREL
CHHPV Pack accumulated batches / movement type item CHAR 1 0 CHHPV
RNDSG Rounding for Whole-Numbered Units of Measure CHAR 1 0 RNDSG
No rounding
+ Round up
- Round down
X Round to nearest whole number
FEHGR Incompleteness Procedure for Sales Document CHAR 2 0 TVUV FEHGR
SEGAL Exclusion/Inclusion indicator for declara. to authorities CHAR 2 0 T609A SEGAL
RULES Stock Determination Rule CHAR 4 0 T434R BF_RULES
BWART Mov. Type for Inbound Delivery CHAR 3 0 T156 BWART_LF
VBTYP SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
UVEIB Doc. pricing procedure for incomplete export/import data CHAR 3 0 T609B UVEIB
PODKZ Control of POD relevance for deliveries CHAR 1 0 PODKZS
Not POD relevant
V Copy POD relevance from preceding document
X Relevant for POD
LGOKZ Do Not Check Storage Location CHAR 1 0 LGOKZ
BACRE Batch Creation, Classification, Exp. Date Check in Inb. Dlv. CHAR 1 0 BACRE
No batch creation, classification, SLED check
1 Batch creation, no classification, SLED check
2 Batch creation, classification, no SLED check
3 Batch creation, classification, SLED check
PODAU Level of Automation of the POD for Inbound Deliveries CHAR 1 0 PODAU
Not Relevant
M Manual POD Processing
T Partly-Automated POD Processing
V Fully-Automated POD Processing
TDID Text ID CHAR 4 0 TDID
TDSPRAS Language Key LANG 1 0 SPRAS
NOPRE Indicator: Inbound Delivery Item Without Predecessor CHAR 1 0 BORGR_NOPRE
SPE_KIT_STRUC Kit-to-Order Structures CHAR 1 0 /SPE/DE_KIT_STRUC
FSH_VASS_DETC VAS Determination Mode in Deliveries CHAR 1 0 FSH_VASS_DETC_L
No Determination
1 Determination and No VAS Item Generation
STRUM Structural scope of a material with bill of material CHAR 1 0 LE_SHP_STRUM
Do not explode material structure
A Explode single-level bill of material
PSGRP Application CHAR 4 0 TC04 CAPID
KOMPP Form delivery group and correlate BOM components CHAR 1 0 LE_SHP_KOMPP
Do not form delivery groups
X Form delivery group with one delivery date
CHAUT_CRE Indicator for Automatic Batch Creation CHAR 1 0 CHAUT_CRE
Automatic Batch Creation disabled
X Automatic Batch Creation enabled
OIA_FFTYP Fulfillment indicator for exchange assignments CHAR 1 0 OIA_FFTYP
Not specified
E Exchange entitlement only
N No assignment possible
OIA_EXGASS Purchase assignment user exit NUMC 3 0 * OIA_EXGASS
OIA_BWART Movement Type (Inventory Management) CHAR 3 0 T156 BWARTWE

TVLP foreign key relationships

Table Field Check Table Check Field
0 TVLP BWART T156 Movement Type MANDT
0 TVLP BWART T156 Movement Type BWART
1 TVLP FEHGR TVUV Incompletion Control: Procedures MANDT
1 TVLP FEHGR TVUV Incompletion Control: Procedures FEHGR
0 TVLP KALSM T683 Pricing procedures KAPPL
0 TVLP KALSM T683 Pricing procedures KALSM
1 TVLP OIA_BWART T156 Movement Type MANDT
1 TVLP OIA_BWART T156 Movement Type BWART
0 TVLP PSGRP TC04 Applic-Specific Criteria for Alternative Determination MANDT
0 TVLP PSGRP TC04 Applic-Specific Criteria for Alternative Determination CAPID
1 TVLP PSTYV TVPT Sales Documents: Item categories MANDT
1 TVLP PSTYV TVPT Sales Documents: Item categories PSTYV
0 TVLP RULES T434R Stock determination rule MANDT
1 TVLP SEGAL T609A Foreign Trade: Declarations to Authorities - Exclusion Ind. SEGAL
0 TVLP STGAP TVSF SD: Statistics Groups for Document Types and Item Categories MANDT
1 TVLP UVEIB T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item KPEXI