SAP Table VTDST

Status of deliveries within transportation planning

VTDST (Status of deliveries within transportation planning) 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 VTDST to other SAP tables.

VTDST table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELN Sales and Distribution Document Number VBELN LIKP CHAR 10 0
TPLST Transportation planning point TPLST CHAR 4 0
STATE Status of a delivery in transportation planning VTDSTAT_D NUMC 2 0
01 Delivery only exists in ERP system
02 Delivery transferred to ALE level
03 Delivery accepted by transportation planning system
00 Delivery does not exist in any system
05 Delivery refused by transportation planning system
06 Delivery deleted in ERP system
AEDAT Changed On AEDAT DATS 8 0
AEZET Time last change was made AEZET TIMS 6 0
DTCON Transition requirements for status sequence of deliveries VTDTCON NUMC 2 0
01 Delivery has been created
02 Delivery has been changed
03 Delivery has been deleted in ERP system
04 Delivery has been transferred to ALE layer
05 Delivery was not accepted by planning system
06 Delivery accepted by planning system
07 Deleted delivery has been deallocated from planning system
LOCCL1 Location category of generalized location EDI_VTTRMT CHAR 2 0
PL Plant
CU Customer
SU Vendor
OC One-time customer
NO Transport.connect.pt
SP Shipping point
CA Carrier
OS One-time vendor
LOCID1 General location number EDI_VTLCID CHAR 10 0
SUBID1 Location addition for general location EDI_VTLSID CHAR 35 0
ADRNR1 Address ADRNR CHAR 10 0
LOCCL2 Location category of generalized location EDI_VTTRMT CHAR 2 0
PL Plant
CU Customer
SU Vendor
OC One-time customer
NO Transport.connect.pt
SP Shipping point
CA Carrier
OS One-time vendor
LOCID2 General location number EDI_VTLCID CHAR 10 0
SUBID2 Location addition for general location EDI_VTLSID CHAR 35 0
ADRNR2 Address ADRNR CHAR 10 0
DPTBG Stage: Planned date for start of shipment DPTBGS DATS 8 0
UPTBG Stage: Planned shipment start time UPTBGS TIMS 6 0
TZONBG Time Zone TZNZONE CHAR 6 0
DPTEN Stage: Planned date for end of shipment DPTENS DATS 8 0
UPTEN Stage: Planned shipemnt end time UPTENS TIMS 6 0
TZONEN Time Zone TZNZONE CHAR 6 0

VTDST foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTDST MANDT VTDST MANDT T000 Clients MANDT
VTDST VBELN VTDST MANDT LIKP SD Document: Delivery Header Data MANDT
VTDST VBELN VTDST VBELN LIKP SD Document: Delivery Header Data VBELN