SAP VTDST Status of deliveries within transportation planning Table
Overview
VTDST is a standard SAP S/4HANA table that stores Status of deliveries within transportation planning data. There are total 22 fields in the VTDST table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTDST belongs to Transportation (LE-TRA) module and is located in the package Interfaces to external transport systems (VTRI).
In addition, following links provide an overview of foreign key relationships, if any, that link VTDST to other SAP tables and standard CDS views available based on VTDST table in S/4HANA 2020.
Techincal Settings of VTDST
Below are technical details of the table VTDST
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTDST Fields
The following table gives you an overview of the fields available in VTDST
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales and Distribution Document Number | VBELN | LIKP | CHAR | 10 |
| TPLST | Transportation planning point | TPLST | * | CHAR | 4 |
| STATE | Status of a delivery in transportation planning | VTDSTAT_D | NUMC | 2 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| AEZET | Time last change was made | AEZET | TIMS | 6 | |
| DTCON | Transition requirements for status sequence of deliveries | VTDTCON | NUMC | 2 | |
| LOCCL1 | Location category of generalized location | EDI_VTTRMT | CHAR | 2 | |
| LOCID1 | General location number | EDI_VTLCID | CHAR | 10 | |
| SUBID1 | Location addition for general location | EDI_VTLSID | CHAR | 35 | |
| ADRNR1 | Address | ADRNR | * | CHAR | 10 |
| LOCCL2 | Location category of generalized location | EDI_VTTRMT | CHAR | 2 | |
| LOCID2 | General location number | EDI_VTLCID | CHAR | 10 | |
| SUBID2 | Location addition for general location | EDI_VTLSID | CHAR | 35 | |
| ADRNR2 | Address | ADRNR | * | CHAR | 10 |
| DPTBG | Stage: Planned date for start of shipment | DPTBGS | DATS | 8 | |
| UPTBG | Stage: Planned shipment start time | UPTBGS | TIMS | 6 | |
| TZONBG | Time Zone | TZNZONE | * | CHAR | 6 |
| DPTEN | Stage: Planned date for end of shipment | DPTENS | DATS | 8 | |
| UPTEN | Stage: Planned shipemnt end time | UPTENS | TIMS | 6 | |
| TZONEN | Time Zone | TZNZONE | * | CHAR | 6 |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VTDST
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTDST | MANDT | : | T000 |
| VTDST | VBELN | : | LIKP |