SAP VTTS Stage of Shipment Table
Overview
VTTS is a standard SAP S/4HANA table that stores Stage of Shipment data. There are total 75 fields in the VTTS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTTS 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 VTTS to other SAP tables and standard CDS views available based on VTTS table in S/4HANA 2020.
Techincal Settings of VTTS
Below are technical details of the table VTTS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTTS Fields
The following table gives you an overview of the fields available in VTTS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| TKNUM | Shipment Number | TKNUM | VTTK | CHAR | 10 |
| TSNUM | Stage of transport number | TSNUM | NUMC | 4 | |
| TSTYP | Stage category | TSTYP | CHAR | 1 | |
| TSRFO | Stage of transport sequence | TSRFO | NUMC | 4 | |
| ELUPD | Change Indicator | ELUPD | CHAR | 1 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| AEZET | Time last change was made | AEZET | TIMS | 6 | |
| ROUTE | Route for shipment stage | ROUTES | TVRO | CHAR | 6 |
| VSART | Shipping type for shipment stage | VERSARTS | T173 | CHAR | 2 |
| INCO1 | Incoterms for printout | INCO1VTTS | TINC | CHAR | 3 |
| LAUFK | Leg indicator for shipment stage | LAUFS | CHAR | 1 | |
| ADRNA | Departure point: Address | ADRNA | * | CHAR | 10 |
| KNOTA | Departure Point | KNOTA | TVKN | CHAR | 10 |
| VSTEL | Shipping point at point of departure | VSTELA | TVST | CHAR | 4 |
| LSTEL | Point of departure: Loading point at shipping point | LSTELA | TVLA | CHAR | 2 |
| WERKA | Plant at point of departure | WERKSA | T001W | CHAR | 4 |
| LGORTA | Departure point: Storage location in plant | LGORTA | T001L | CHAR | 4 |
| KUNNA | Departure point: Customer | KUNNA | KNA1 | CHAR | 10 |
| LIFNA | Vendor number of departure point | LIFNA | LFA1 | CHAR | 10 |
| BELAD | Point of departure: Additional info (e.g. loading point) | BELAD | CHAR | 25 | |
| ADRNZ | Destination address | ADRNZ | * | CHAR | 10 |
| KNOTZ | Destination point | KNOTZ | TVKN | CHAR | 10 |
| VSTEZ | Shipping point at destination | VSTELZ | TVST | CHAR | 4 |
| LSTEZ | Destination: Loading point at shipping point | LSTELZ | TVLA | CHAR | 2 |
| WERKZ | Plant at destination point | WERKSZ | T001W | CHAR | 4 |
| LGORTZ | Destination: Storage location in plant | LGORTZ | T001L | CHAR | 4 |
| KUNNZ | Customer number for destination point | KUNNZ | KNA1 | CHAR | 10 |
| LIFNZ | Vendor number of destination point | LIFNZ | LFA1 | CHAR | 10 |
| ABLAD | Destination: Additional information (e.g. unloading point) | ABLADZ | CHAR | 25 | |
| DPTBG | Stage: Planned date for start of shipment | DPTBGS | DATS | 8 | |
| UPTBG | Stage: Planned shipment start time | UPTBGS | TIMS | 6 | |
| DATBG | Stage: Current date for start of shipment | DATBGS | DATS | 8 | |
| UATBG | Stage: Current shipment start time | UATBGS | TIMS | 6 | |
| DPTEN | Stage: Planned date for end of shipment | DPTENS | DATS | 8 | |
| UPTEN | Stage: Planned shipemnt end time | UPTENS | TIMS | 6 | |
| DATEN | Stage: Actual Date for End of Shipment | DATENDS | DATS | 8 | |
| UATEN | Stage: Actual shipment end time | UATENDS | TIMS | 6 | |
| TDLNR | Number of forwarding agent in the shipment stage | TDLNRS | LFA1 | CHAR | 10 |
| DISTZ | Distance | DISTZ | QUAN | 13 | |
| MEDST | Distance Unit of Measure | MEDST | * | UNIT | 3 |
| FAHZT | Travelling time only between two locations | FAHZT | QUAN | 5 | |
| GESZT | Total travelling time between two locations incl. breaks | GESZT | QUAN | 5 | |
| MEIZT | Unit of measure for travelling times | MEIZT | * | UNIT | 3 |
| LGNUMA | Point of departure: Warehouse number | LGNUMA | T300 | CHAR | 3 |
| TORA | Point of departure: Gate for warehouse number | LGTORA | T30B | CHAR | 3 |
| ADRKNZA | Point of departure: Origin indicator of address | ADRKNZA | CHAR | 1 | |
| KUNABLA | Point of departure: Customer's unloading point | KUNABLA | KNVA | CHAR | 25 |
| LGNUMZ | Destination: Warehouse number | LGNUMZ | T300 | CHAR | 3 |
| TORZ | Destination. Gate for warehouse number | LGTORZ | T30B | CHAR | 3 |
| ADRKNZZ | Destination: Origin indicator of address | ADRKNZZ | CHAR | 1 | |
| KUNABLZ | Destination: Customer's unloading point | KUNABLZ | KNVA | CHAR | 25 |
| GESZTD | Planned total time at stage level (in days) | AB_GESZTDP | DEC | 11 | |
| FAHZTD | Plan: Actual duration at stage level (in hours:minutes) | AB_EFFZTDP | DEC | 11 | |
| GESZTDA | Actual total time at stage of shipment (in days) | AB_GESZTDA | DEC | 11 | |
| FAHZTDA | Actual duration of shipment stage (in hours:minutes) | AB_EFFZTDA | DEC | 11 | |
| SDABW | Special Processing Indicator | SDABW | TVSAK | CHAR | 4 |
| FRKRL | Shipment costs relevance | FRKRL | CHAR | 1 | |
| SKALSM | Pricing procedure in stage of shipment | KALSM_TRAB | T683 | CHAR | 6 |
| FBSTA | Status of shipment costs calculation | FBSTA | CHAR | 1 | |
| ARSTA | Status of shipment costs settlement | ARSTA | CHAR | 1 | |
| STAFO | Update Group for statistics update | STAFO | * | CHAR | 6 |
| CONT_DG | Indicator: Section contains dangerous goods | ADGE_SCDG | CHAR | 1 | |
| WARZTD | Planned waiting time in shipment stage (in hrs:min) | AB_WARZTDP | DEC | 11 | |
| WARZTDA | Current waiting time in shipment stage (in hrs:min) | AB_WARZTDA | DEC | 11 | |
| ABLAND1 | Country of departure | ABLAND1 | T005 | CHAR | 3 |
| ABPSTLZ | Departure postal code | ABPSTLZ | CHAR | 10 | |
| ABORT01 | Point of departure | ABORT01 | CHAR | 35 | |
| EDLAND1 | Destination Country | EDLAND1 | T005 | CHAR | 3 |
| EDPSTLZ | Destination Postal Code | EDPSTLZ | CHAR | 10 | |
| EDORT01 | Destination | EDORT01 | CHAR | 35 |
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 VTTS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTTS | ABLAND1 | : | T005 |
| VTTS | EDLAND1 | : | T005 |
| VTTS | INCO1 | C: CN | TINC |
| VTTS | KNOTA | C: CN | TVKN |
| VTTS | KNOTZ | C: CN | TVKN |
| VTTS | KUNABLA | : | KNVA |
| VTTS | KUNABLZ | : | KNVA |
| VTTS | KUNNA | C: CN | KNA1 |
| VTTS | KUNNZ | C: CN | KNA1 |
| VTTS | LGNUMA | : | T300 |
| VTTS | LGNUMZ | : | T300 |
| VTTS | LGORTA | : | T001L |
| VTTS | LGORTZ | : | T001L |
| VTTS | LIFNA | C: CN | LFA1 |
| VTTS | LIFNZ | C: CN | LFA1 |
| VTTS | LSTEL | C: CN | TVLA |
| VTTS | LSTEZ | C: CN | TVLA |
| VTTS | MANDT | 1: CN | T000 |
| VTTS | ROUTE | C: CN | TVRO |
| VTTS | SDABW | : | TVSAK |
| VTTS | SKALSM | : | T683 |
| VTTS | TDLNR | C: C | LFA1 |
| VTTS | TKNUM | 1: CN | VTTK |
| VTTS | TORA | : | T30B |
| VTTS | TORZ | : | T30B |
| VTTS | VSART | C: CN | T173 |
| VTTS | VSTEL | C: CN | TVST |
| VTTS | VSTEZ | C: CN | TVST |
| VTTS | WERKA | : | T001W |
| VTTS | WERKZ | : | T001W |