1. Home
  2. Resources
  3. SAP Tables
  4. TVLP - Deliveries: Item Categories

SAP Table TVLP

Deliveries: Item Categories

TVLP (Deliveries: 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 TVLP to other SAP tables.

TVLP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PSTYV Delivery item category PSTYV_VL TVPT CHAR 4 0
MATN0 Material number zero allowed MATN0 CHAR 1 0
X Yes
NULL No
SPEMT Dummy function in length 1 DUMMY CHAR 1 0
MATPR Dummy function in length 1 DUMMY CHAR 1 0
MNG0P Checks for zero quantity MNG0P CHAR 1 0
NULL No dialog
A Note about the situation
B Dismiss situation with error message in create/change mode
C Dismiss situation with error message only in create mode
MINMG Check minimum quantity to be delivered MINMG CHAR 1 0
NULL No dialog
A Note about the situation
B Situation rejected with an error message
UEBPR Control for checking for overdelivery UEBPR CHAR 1 0
NULL No dialog
A Note about the situation
B Situation rejected with an error message
VERPR Switch off availability check for delivery item LFVER CHAR 1 0
NULL Check availability
X Do not check availability
Y Do not check avail. when reporting results of pick.request
KOMRL Relevant for picking or putaway KOMRL CHAR 1 0
X Yes
NULL No
LGOZW Storage location is absolutely necessary LGOZW CHAR 1 0
X Yes
NULL No
BELGO Determine storage location BELGO CHAR 1 0
X Yes
NULL No
POSGR Group of doc.items for screen sequence POSGR CHAR 4 0
FELDP Field selection for item FELDP CHAR 4 0
BILDP Dummy function in length 1 DUMMY CHAR 1 0
TXN08 Number of the standard text TXN08 CHAR 8 0
PARGR Partner Determination Procedure PARGR CHAR 4 0
ASWPL Dummy function in length 1 DUMMY CHAR 1 0
TXTGR Text determination procedure TXTGR CHAR 2 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
STGAP Statistics group for the item category STGAP TVSF CHAR 2 0
CHPKZ ID: No batch check CHPKZ CHAR 1 0
X Yes
NULL No
KALSM Procedure for item output KALSMBP T683 CHAR 6 0
PCKPF Packing control PCKPF CHAR 1 0
NULL Can be packed
A Must be packed
B Cannot be packed
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)
TPREL Indicator: Relevance for transport of deliv. item categories TPREL CHAR 1 0
X Yes
NULL No
CHHPV Pack accumulated batches / movement type item CHHPV CHAR 1 0
X Yes
NULL No
RNDSG Rounding indicator for whole-number units of measure RNDSG CHAR 1 0
NULL No rounding
X Round to nearest whole number
+ Round up
- Round down
FEHGR Incompletion procedure for sales document FEHGR TVUV CHAR 2 0
SEGAL Exclusion/Inclusion indicator for declara. to authorities SEGAL T609A CHAR 2 0
RULES Stock determination rule BF_RULES T434R CHAR 4 0
BWART Mov. Type for Inbound Delivery BWART_LF T156 CHAR 3 0
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
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
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
UVEIB Doc. pricing procedure for incomplete export/import data UVEIB T609B CHAR 3 0
PODKZ Control of POD relevance for deliveries PODKZS CHAR 1 0
NULL Not POD relevant
X Relevant for POD
V Copy POD relevance from preceding document
LGOKZ Indicator: Do Not Check Storage Location LGOKZ CHAR 1 0
X Yes
NULL No
BACRE Batch Creation, Classification, Exp. Date Check in Inb. Dlv. BACRE CHAR 1 0
NULL No batch installation, classification, SLED check
1 Batch installation, no classification, SLED check
2 Batch installation, classification, no SLED check
3 Batch installation, classification, SLED check
PODAU Level of Automation of the POD for Inbound Deliveries PODAU CHAR 1 0
NULL Not Relevant
V Fully-Automated POD Processing
T Partly-Automated POD Processing
M Manual POD Processing
TDID Text ID TDID CHAR 4 0
TDSPRAS Language Key SPRAS LANG 1 0
NOPRE Indicator: Inbound Delivery Item Without Predecessor BORGR_NOPRE CHAR 1 0
X Yes
NULL No
SPE_KIT_STRUC Kit-to-Order Structures /SPE/DE_KIT_STRUC CHAR 1 0
X Yes
NULL No
OIA_FFTYP Fulfillment indicator for exchange assignments OIA_FFTYP CHAR 1 0
E Exchange entitlement only
N No assignment possible
NULL Not specified
OIA_EXGASS Purchase assignment user exit OIA_EXGASS NUMC 3 0
OIA_BWART Movement Type (Inventory Management) BWARTWE T156 CHAR 3 0

TVLP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TVLP BWART TVLP BWART T156 Movement Type BWART
TVLP BWART TVLP MANDT T156 Movement Type MANDT
TVLP FEHGR TVLP MANDT TVUV Incompletion Control: Procedures MANDT
TVLP FEHGR TVLP FEHGR TVUV Incompletion Control: Procedures FEHGR
TVLP KALSM TVLP MANDT T683 Pricing procedures MANDT
TVLP KALSM 'B' T683 Pricing procedures KVEWE
TVLP KALSM 'V2' T683 Pricing procedures KAPPL
TVLP KALSM TVLP KALSM T683 Pricing procedures KALSM
TVLP MANDT TVLP MANDT T000 Clients MANDT
TVLP OIA_BWART SYST MANDT T156 Movement Type MANDT
TVLP OIA_BWART TVLP OIA_BWART T156 Movement Type BWART
TVLP PSTYV TVLP MANDT TVPT Sales documents: Item categories MANDT
TVLP PSTYV TVLP PSTYV TVPT Sales documents: Item categories PSTYV
TVLP RULES TVLP MANDT T434R Stock determination rule MANDT
TVLP RULES TVLP RULES T434R Stock determination rule RULES
TVLP SEGAL TVLP MANDT T609A Foreign Trade: Declarations to Authorities - Exclusion Ind. MANDT
TVLP SEGAL TVLP SEGAL T609A Foreign Trade: Declarations to Authorities - Exclusion Ind. SEGAL
TVLP STGAP TVLP MANDT TVSF SD: Statistics Groups for Document Types and Item Categories MANDT
TVLP STGAP TVLP STGAP TVSF SD: Statistics Groups for Document Types and Item Categories STGVB
TVLP UVEIB TVLP MANDT T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item MANDT
TVLP UVEIB 'B' T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item KPEXI
TVLP UVEIB TVLP UVEIB T609B FT: Incompleteness: Doc.Pric.Procedure - Header and Item UVEIB