SAP VTRDI Shipment Planning Index Table
Overview
VTRDI is a standard SAP S/4HANA table that stores Shipment Planning Index data. There are total 37 fields in the VTRDI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTRDI belongs to Transportation (LE-TRA) module and is located in the package SD R/3 transport processing (VTR).
In addition, following links provide an overview of foreign key relationships, if any, that link VTRDI to other SAP tables and standard CDS views available based on VTRDI table in S/4HANA 2020.
Techincal Settings of VTRDI
Below are technical details of the table VTRDI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTRDI Fields
The following table gives you an overview of the fields available in VTRDI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| TRSTA | Transportation Planning Status (Header) | TRSTA | CHAR | 1 | |
| VSTEL | Shipping Point / Receiving Point | VSTEL | TVST | CHAR | 4 |
| TDDAT | Transportation Planning Date | TDDAT_D | DATS | 8 | |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR | 10 |
| VBTYP | SD Document Category | VBTYPL | CHAR | 4 | |
| LSTEL | Loading Point | LSTEL | TVLA | CHAR | 2 |
| ROUTE | Route | ROUTE | TVRO | CHAR | 6 |
| TRAGR | Transportation Group | TRAGR | TTGR | CHAR | 4 |
| VSBED | Shipping Conditions | VSBED | TVSB | CHAR | 2 |
| LAND1 | Country/Region Key | LAND1 | T005 | CHAR | 3 |
| LZONE | Transportation zone to or from which the goods are delivered | LZONE | TZONE | CHAR | 10 |
| WADAT | Goods Issue Date | WADAT | DATS | 8 | |
| LDDAT | Loading Date | LDDAT | DATS | 8 | |
| LFDAT | Delivery Date | LFDAT_V | DATS | 8 | |
| KODAT | Picking Date | KODAT | DATS | 8 | |
| BTGEW | Total Weight | GSGEW | QUAN | 15 | |
| VOLUM | Volume | VOLUM_15 | QUAN | 15 | |
| GEWEI | Weight Unit | GEWEI | T006 | UNIT | 3 |
| VOLEH | Volume unit | VOLEH | T006 | UNIT | 3 |
| KUNNR | Ship-to party | KUNWE | KNA1 | CHAR | 10 |
| SPDNR | Forwarding Agent | SPDNR | LFA1 | CHAR | 10 |
| INCO1 | Incoterms (Part 1) | INCO1 | TINC | CHAR | 3 |
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | |
| LPRIO | Delivery Priority | LPRIO | TPRIO | NUMC | 2 |
| TRSPG | Shipment Blocking Reason | TRSPG | TTSG | CHAR | 2 |
| WBSTK | Goods Movement Status (All Items) | WBSTK | CHAR | 1 | |
| TRATY | Means-of-Transport Type | TRATY | TVTY | CHAR | 4 |
| TRMTYP | Means of Transport | TRMTYP | MARA | CHAR | 40 |
| VSART | Shipping Type | VSARTTR | T173 | CHAR | 2 |
| SDABW | Special Processing Indicator | SDABW | TVSAK | CHAR | 4 |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| FORCE_ID | Internal Key for Force Element | /ISDFPS/FORCE_ID | CHAR | 32 | |
| FORCE_CNT | Internal (Version) Counter | /ISDFPS/FORCE_CNT | NUMC | 6 | |
| RELOC_ID | Relocation ID | /ISDFPS/RELOC_ID | /ISDFPS/REL | CHAR | 10 |
| RELOC_SEQ_ID | Relocation Step ID | /ISDFPS/RELOC_SEQ_ID | /ISDFPS/RELSEQ | CHAR | 4 |
| SOURCE_LOGSYS | Logical system | LOGSYS | * | CHAR | 10 |
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 VTRDI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTRDI | GEWEI | 1: CN | T006 |
| VTRDI | INCO1 | 1: CN | TINC |
| VTRDI | KUNNR | 1: CN | KNA1 |
| VTRDI | LAND1 | 1: CN | T005 |
| VTRDI | LPRIO | 1: CN | TPRIO |
| VTRDI | LSTEL | 1: CN | TVLA |
| VTRDI | LZONE | 1: CN | TZONE |
| VTRDI | RELOC_ID | : | /ISDFPS/REL |
| VTRDI | RELOC_SEQ_ID | : | /ISDFPS/RELSEQ |
| VTRDI | ROUTE | 1: CN | TVRO |
| VTRDI | SDABW | : | TVSAK |
| VTRDI | SPDNR | 1: CN | LFA1 |
| VTRDI | TRAGR | 1: CN | TTGR |
| VTRDI | TRATY | : | TVTY |
| VTRDI | TRMTYP | : | MARA |
| VTRDI | TRSPG | 1: CN | TTSG |
| VTRDI | VOLEH | 1: CN | T006 |
| VTRDI | VSART | C: CN | T173 |
| VTRDI | VSBED | 1: CN | TVSB |
| VTRDI | VSTEL | 1: CN | TVST |