SAP VTDSTC Condition of Deliveries for Freight Planning by Fwdng Agent Table
Overview
VTDSTC is a standard SAP S/4HANA table that stores Condition of Deliveries for Freight Planning by Fwdng Agent data. There are total 27 fields in the VTDSTC table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTDSTC 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 VTDSTC to other SAP tables and standard CDS views available based on VTDSTC table in S/4HANA 2020.
Techincal Settings of VTDSTC
Below are technical details of the table VTDSTC
- Buffering switched on
- Full buffering as specified by generic key
- Storage type is Column Store
List of VTDSTC Fields
The following table gives you an overview of the fields available in VTDSTC
| 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 |
| TDLNR | Number of forwarding agent | TDLNR | * | CHAR | 10 |
| STATE | Condition of Delivery in Freight Planning by Forwarding Agnt | VTDSTATC_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 | VTDTCONC | 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 |
| TPLST | Transportation planning point | TPLST | * | CHAR | 4 |
| SHTYP | Shipment type | SHTYP | * | CHAR | 4 |
| TXTID1 | Delivery Header Text ID for Freight Planning Transfer | VCFP_LFTX | * | CHAR | 4 |
| TXTID2 | Delivery Header Text ID for Freight Planning Transfer | VCFP_LFTX | * | CHAR | 4 |
| TXTID3 | Delivery Header Text ID for Freight Planning Transfer | VCFP_LFTX | * | CHAR | 4 |
| KSCHL | Condition type | KSCHL | * | CHAR | 4 |
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 VTDSTC
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTDSTC | MANDT | : | T000 |
| VTDSTC | VBELN | : | LIKP |