- Home
- Resources
- SAP Tables
- VTDST - Status of deliveries within transportation planning
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.
Source: VTDST (Status of deliveries within transportation planning)
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |
Possible values
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 |