SAP VTTK Shipment Header Table
Overview
VTTK is a standard SAP S/4HANA table that stores Shipment Header data. There are total 140 fields in the VTTK table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VTTK 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 VTTK to other SAP tables and standard CDS views available based on VTTK table in S/4HANA 2020.
Techincal Settings of VTTK
Below are technical details of the table VTTK
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VTTK Fields
The following table gives you an overview of the fields available in VTTK
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| TKNUM | Shipment Number | TKNUM | CHAR | 10 | |
| VBTYP | SD Document Category | VBTYPL | CHAR | 4 | |
| SHTYP | Shipment type | SHTYP | TVTK | CHAR | 4 |
| TPLST | Transportation planning point | TPLST | TTDS | CHAR | 4 |
| 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 | |
| STERM | Leg determination | STERM | CHAR | 1 | |
| ABFER | Shipment completion type | ABFER | CHAR | 1 | |
| ABWST | Processing control | ABWST | CHAR | 1 | |
| BFART | Service Level | BFART | CHAR | 1 | |
| VSART | Shipping Type | VSARTTR | T173 | CHAR | 2 |
| VSAVL | Shipping type of preliminary leg | VSAVL | T173 | CHAR | 2 |
| VSANL | Shipping type of subsequent leg | VSANL | T173 | CHAR | 2 |
| LAUFK | Leg Indicator | LAUFK | CHAR | 1 | |
| VSBED | Shipping Conditions | VSBED | TVSB | CHAR | 2 |
| ROUTE | Shipment route | ROUTR | TVRO | CHAR | 6 |
| SIGNI | Container ID | SIGNI | CHAR | 20 | |
| EXTI1 | External identification 1 | EXTI1 | CHAR | 20 | |
| EXTI2 | External identification 2 | EXTI2 | CHAR | 20 | |
| TPBEZ | Description of Shipment | TPBEZ | CHAR | 20 | |
| STDIS | Status of transportation planning | STDIS | CHAR | 1 | |
| DTDIS | Date of end of planning | DTDIS | DATS | 8 | |
| UZDIS | Scheduling end time | UZDIS | TIMS | 6 | |
| STREG | Status of check-in | STREG | CHAR | 1 | |
| DPREG | Planned date of check-in | DPREG | DATS | 8 | |
| UPREG | Planned check-in time | UPREG | TIMS | 6 | |
| DAREG | Actual date of check-in | DAREG | DATS | 8 | |
| UAREG | Current time of check-in | UAREG | TIMS | 6 | |
| STLBG | Status for start of loading | STLBG | CHAR | 1 | |
| DPLBG | Planned date for start of loading | DPLBG | DATS | 8 | |
| UPLBG | Planned loading start time | UPLBG | TIMS | 6 | |
| DALBG | Current date for start of loading | DALBG | DATS | 8 | |
| UALBG | Actual loading start time | UALBG | TIMS | 6 | |
| STLAD | Status for end of loading | STLAD | CHAR | 1 | |
| DPLEN | Planned date for end of loading | DPLEND | DATS | 8 | |
| UPLEN | Planned loading end time | UPLEND | TIMS | 6 | |
| DALEN | Actual date for end of loading | DALEND | DATS | 8 | |
| UALEN | Actual loading end time | UALEND | TIMS | 6 | |
| STABF | Status of shipment completion | STABF | CHAR | 1 | |
| DPABF | Planned date for shipment completion | DPABF | DATS | 8 | |
| UPABF | Planned time for processing | UPABF | TIMS | 6 | |
| DTABF | Current date of shipment completion | DTABF | DATS | 8 | |
| UZABF | Time of transportation processing | UZABF | TIMS | 6 | |
| STTBG | Status for start of shipment | STTBG | CHAR | 1 | |
| DPTBG | Planned date for start of shipment | DPTBG | DATS | 8 | |
| UPTBG | Planned transport start time | UPTBG | TIMS | 6 | |
| DATBG | Current date for start of shipment | DATBG | DATS | 8 | |
| UATBG | Actual transport start time | UATBG | TIMS | 6 | |
| STTEN | Status for end of shipment | STTEN | CHAR | 1 | |
| DPTEN | Planned date for end of shipment | DPTEN | DATS | 8 | |
| UPTEN | Planned transport end time | UPTEN | TIMS | 6 | |
| DATEN | Actual Date for End of Shipment | DATEND | DATS | 8 | |
| UATEN | Actual shipment end time | UATEND | TIMS | 6 | |
| STTRG | Overall transportation status | STTRG | CHAR | 1 | |
| TDLNR | Number of forwarding agent | TDLNR | LFA1 | CHAR | 10 |
| TERNR | Order Number | AUFNR | CHAR | 12 | |
| PKSTK | Shipment Contains Handling Units | PKSTK_VTTK | CHAR | 1 | |
| DTMEG | Unit of Weight for Transportation Planning | DTMEG | UNIT | 3 | |
| DTMEV | Volume Unit for Transportation Planning | DTMEV | UNIT | 3 | |
| 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 | |
| STAFO | Update Group for statistics update | STAFO | CHAR | 6 | |
| FBSTA | Status of shipment costs calculation | FBSTA | CHAR | 1 | |
| FBGST | Overall status of calculation of shipment costs for shipment | FBGST | CHAR | 1 | |
| ARSTA | Status of shipment costs settlement | ARSTA | CHAR | 1 | |
| ARGST | Total status of shipment costs settlement for shipment | ARGST | CHAR | 1 | |
| STERM_DONE | Leg determination complete | STERM_DONE | CHAR | 1 | |
| VSE_FRK | Handling Unit Data are Referred in Shipment Cost Document | VSE_FRK | CHAR | 1 | |
| KKALSM | Pricing procedure in shipment header | KALSM_KOPF | T683 | CHAR | 6 |
| SDABW | Special Processing Indicator | SDABW | TVSAK | CHAR | 4 |
| FRKRL | Shipment costs relevance | KFRKRL | CHAR | 1 | |
| GESZTD | Planned total time of transportation (in days) | KP_GESZTDP | DEC | 11 | |
| FAHZTD | Planned duration of transportation (in hours:minutes) | KP_EFFZTDP | DEC | 11 | |
| GESZTDA | Actual total time of shipment (in days) | KP_GESZTDA | DEC | 11 | |
| FAHZTDA | Actual time needed for transporation (in hours:minutes) | KP_EFFZTDA | DEC | 11 | |
| ROCPY_DONE | Route copied from delivery | ROCPY_DONE | CHAR | 1 | |
| HANDLE | Globally unique identifier (linked to time segment etc) | TSEGGUID | CHAR | 22 | |
| TSEGFL | Time segment exists | TSEGEXISTS | CHAR | 1 | |
| TSEGTP | Time segment event group shipment header | TSEGTPLVTT | CHAR | 10 | |
| ADD01 | Suppl. 1 | VTTK_ADD01 | VTADD01 | CHAR | 10 |
| ADD02 | Suppl. 2 | VTTK_ADD02 | VTADD02 | CHAR | 10 |
| ADD03 | Suppl. 3 | VTTK_ADD03 | VTADD03 | CHAR | 10 |
| ADD04 | Suppl. 4 | VTTK_ADD04 | VTADD04 | CHAR | 10 |
| TEXT1 | Addit.text 1 | VTTK_TEXT1 | CHAR | 40 | |
| TEXT2 | Addit.text 2 | VTTK_TEXT2 | CHAR | 40 | |
| TEXT3 | Addit.text 3 | VTTK_TEXT3 | CHAR | 40 | |
| TEXT4 | Addit.text 4 | VTTK_TEXT4 | CHAR | 40 | |
| PROLI | Dangerous Goods Management Profile in SD Documents | ADGE_PROLI | TDGC5 | CHAR | 3 |
| DGTLOCK | Block Indicator for Dangerous Goods | ADGE_TLOCK | CHAR | 1 | |
| DGMDDAT | Selection date dangerous goods master data | ADGE_MDDAT | DATS | 8 | |
| CONT_DG | Indicator: Document contains dangerous goods | ADGE_NCDG | CHAR | 1 | |
| WARZTD | Planned waiting time of shipment (in hours:minutes) | KP_WARZTDP | DEC | 11 | |
| WARZTDA | Current waiting time of shipment (in hours:minutes) | KP_WARZTDA | DEC | 11 | |
| AULWE | Route Schedule | AULWE | CHAR | 10 | |
| TNDRST | Tender Status | TNDRST | CHAR | 2 | |
| TNDRRC | Acceptance Condition/Rejection Reason | TNDRRC | CHAR | 2 | |
| TNDR_TEXT | Tendering Text | TNDR_TEXT | CHAR | 80 | |
| TNDRDAT | Date of tender status | TNDRDAT | DATS | 8 | |
| TNDRZET | Time of tender status | TNDRZET | TIMS | 6 | |
| TNDR_MAXP | Maximum Price for Shipment | TNDR_MAXP | CURR | 15 | |
| TNDR_MAXC | Currency of Maximum Price | TNDR_MAXC | TCURC | CUKY | 5 |
| TNDR_ACTP | Actual Shipment Costs for Shipment | TNDR_ACTP | CURR | 15 | |
| TNDR_ACTC | Currency of Actual Shipment Costs | TNDR_ACTC | TCURC | CUKY | 5 |
| TNDR_CARR | Forwarding Agent Who Accepted the Shipment | TNDR_CARR | CHAR | 10 | |
| TNDR_CRNM | Name of Carrier Who Accepted the Shipment | TNDR_CRNM | CHAR | 35 | |
| TNDR_TRKID | Forwarding Agent Tracking ID | TNDR_TRKID | CHAR | 35 | |
| TNDR_EXPD | Date on Which Offer Expires | TNDR_EXPD | DATS | 8 | |
| TNDR_EXPT | Time at Which Quotation Expires | TNDR_EXPT | TIMS | 6 | |
| TNDR_ERPD | Earliest Pickup Date | TNDR_ERPD | DATS | 8 | |
| TNDR_ERPT | Earliest Pickup Time | TNDR_ERPT | TIMS | 6 | |
| TNDR_LTPD | Latest Pickup Date | TNDR_LTPD | DATS | 8 | |
| TNDR_LTPT | Latest Pickup Time | TNDR_LTPT | TIMS | 6 | |
| TNDR_ERDD | Earliest Delivery Date | TNDR_ERDD | DATS | 8 | |
| TNDR_ERDT | Earliest Delivery Time | TNDR_ERDT | TIMS | 6 | |
| TNDR_LTDD | Latest Delivery Date | TNDR_LTDD | DATS | 8 | |
| TNDR_LTDT | Latest Delivery Time | TNDR_LTDT | TIMS | 6 | |
| TNDR_LDLG | Length of Loading Platform | TNDR_LDLG | QUAN | 13 | |
| TNDR_LDLU | Unit of Measure for Load Length | TNDR_LDLU | UNIT | 3 | |
| KZHULFR | Indicator: HUs Relevant for Delivery Item Generation | KZHULFR | CHAR | 1 | |
| ALLOWED_TWGT | Allowed total weight of shipment | ALLOWED_TWGT | QUAN | 8 | |
| VLSTK | Distribution Status (Decentralized Warehouse Processing) | VLSTK | CHAR | 1 | |
| VERURSYS | Shipment Distribution: Original System | TRA_VERURSYS | CHAR | 10 | |
| CM_IDENT | Identification Number for Continuous Moves | CMIDENTIFIER | CHAR | 12 | |
| CM_SEQUENCE | Sequence of Transports in Connecting Traffice | CMSEQUENCE | NUMC | 4 | |
| EXT_FREIGHT_ORD | External Freight Order ID | EXT_FREIGHT_ORDER | CHAR | 20 | |
| EXT_TM_SYS | Key Name of Business System | SLD_BSKEY | CHAR | 60 | |
| /BEV1/RPFAR1 | Driver 1 | /DSD/RP_DRIVER1 | KNA1 | CHAR | 10 |
| /BEV1/RPFAR2 | Driver 2 | /DSD/RP_DRIVER2 | KNA1 | CHAR | 10 |
| /BEV1/RPMOWA | Vehicle | /DSD/RP_TRUCK | * | CHAR | 18 |
| /BEV1/RPANHAE | Trailer | /DSD/RP_TRAIL | * | CHAR | 18 |
| /BEV1/RPFLGNR | Loading Sequence Number in the Tour | /DSD/RP_SEQUENCENR | NUMC | 5 | |
| /VSO/R_STATUS | Status of Vehicle Space Optimization | /VSO/M_VSO_STATUS | CHAR | 1 |
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 VTTK
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VTTK | /BEV1/RPFAR1 | : | KNA1 |
| VTTK | /BEV1/RPFAR2 | : | KNA1 |
| VTTK | ADD01 | : | VTADD01 |
| VTTK | ADD02 | : | VTADD02 |
| VTTK | ADD03 | : | VTADD03 |
| VTTK | ADD04 | : | VTADD04 |
| VTTK | KKALSM | : | T683 |
| VTTK | MANDT | 1: CN | T000 |
| VTTK | PROLI | : | TDGC5 |
| VTTK | ROUTE | C: CN | TVRO |
| VTTK | SDABW | : | TVSAK |
| VTTK | SHTYP | 1: CN | TVTK |
| VTTK | TDLNR | 1: CN | LFA1 |
| VTTK | TNDR_ACTC | 1: CN | TCURC |
| VTTK | TNDR_MAXC | 1: CN | TCURC |
| VTTK | TPLST | 1: CN | TTDS |
| VTTK | VSANL | C: CN | T173 |
| VTTK | VSART | C: CN | T173 |
| VTTK | VSAVL | C: CN | T173 |
| VTTK | VSBED | C: CN | TVSB |