VTTK SAP (Shipment Header) Table details
Dictionary Type: Table
Description: Shipment Header
Description: Shipment Header
Table field list including key, data, relationships and ABAP select examples
VTTK is a standard SAP Table which is used to store Shipment Header data and is available within R/3 SAP systems depending on the version and release level.
The VTTK table consists of various fields, each holding specific information or linking keys about Shipment Header data available in SAP. These include TKNUM (Shipment Number), VBTYP (SD document category), SHTYP (Shipment type), TPLST (Transportation planning point).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP VTTK table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
TKNUM | Shipment Number | TKNUM | CHAR | 10 | ALPHA | TKNUM | TNR | SD_F4_SHP_ID | |
VBTYP | SD document category | VBTYP | CHAR | 1 | VBTYP | ||||
SHTYP | Shipment type | SHTYP | CHAR | 4 | TVTK | SHTYP | TSH | ||
TPLST | Transportation planning point | TPLST | CHAR | 4 | TTDS | TPLST | TDP | ||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZET | Time last change was made | AEZET | TIMS | 6 | UZEIT | ||||
STERM | Leg determination | STERM | CHAR | 1 | STERM | ||||
ABFER | Shipment completion type | ABFER | CHAR | 1 | ABFER | ||||
ABWST | Processing control | ABWST | CHAR | 1 | ABWST | ||||
BFART | Service Level | BFART | CHAR | 1 | BFART | ||||
VSART | Shipping type | VSARTTR | CHAR | 2 | T173 | VERSART | |||
VSAVL | Shipping type of preliminary leg | VSAVL | CHAR | 2 | T173 | VERSART | |||
VSANL | Shipping type of subsequent leg | VSANL | CHAR | 2 | T173 | VERSART | |||
LAUFK | Leg Indicator | LAUFK | CHAR | 1 | LAUFK | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | TVSB | VSBED | |||
ROUTE | Shipment route | ROUTR | CHAR | 6 | TVRO | ROUTE | VMTR | ||
SIGNI | Container ID | SIGNI | CHAR | 20 | TEXT20 | ||||
EXTI1 | External identification 1 | EXTI1 | CHAR | 20 | TEXT20 | ||||
EXTI2 | External identification 2 | EXTI2 | CHAR | 20 | TEXT20 | ||||
TPBEZ | Description of Shipment | TPBEZ | CHAR | 20 | TEXT20 | ||||
STDIS | Status of transportation planning | STDIS | CHAR | 1 | STTRA | ||||
DTDIS | Date of end of planning | DTDIS | DATS | 8 | DATUM | ||||
UZDIS | Scheduling end time | UZDIS | TIMS | 6 | UZEIT | ||||
STREG | Status of check-in | STREG | CHAR | 1 | STTRA | ||||
DPREG | Planned date of check-in | DPREG | DATS | 8 | DATUM | ||||
UPREG | Planned check-in time | UPREG | TIMS | 6 | UZEIT | ||||
DAREG | Actual date of check-in | DAREG | DATS | 8 | DATUM | ||||
UAREG | Current time of check-in | UAREG | TIMS | 6 | UZEIT | ||||
STLBG | Status for start of loading | STLBG | CHAR | 1 | STTRA | ||||
DPLBG | Planned date for start of loading | DPLBG | DATS | 8 | DATUM | ||||
UPLBG | Planned loading start time | UPLBG | TIMS | 6 | UZEIT | ||||
DALBG | Current date for start of loading | DALBG | DATS | 8 | DATUM | ||||
UALBG | Actual loading start time | UALBG | TIMS | 6 | UZEIT | ||||
STLAD | Status for end of loading | STLAD | CHAR | 1 | STTRA | ||||
DPLEN | Planned date for end of loading | DPLEND | DATS | 8 | DATUM | ||||
UPLEN | Planned loading end time | UPLEND | TIMS | 6 | UZEIT | ||||
DALEN | Actual date for end of loading | DALEND | DATS | 8 | DATUM | ||||
UALEN | Actual loading end time | UALEND | TIMS | 6 | UZEIT | ||||
STABF | Status of shipment completion | STABF | CHAR | 1 | STTRA | ||||
DPABF | Planned date for shipment completion | DPABF | DATS | 8 | DATUM | ||||
UPABF | Planned time for processing | UPABF | TIMS | 6 | UZEIT | ||||
DTABF | Current date of shipment completion | DTABF | DATS | 8 | DATUM | ||||
UZABF | Time of transportation processing | UZABF | TIMS | 6 | UZEIT | ||||
STTBG | Status for start of shipment | STTBG | CHAR | 1 | STTRA | ||||
DPTBG | Planned date for start of shipment | DPTBG | DATS | 8 | DATUM | ||||
UPTBG | Planned transport start time | UPTBG | TIMS | 6 | UZEIT | ||||
DATBG | Current date for start of shipment | DATBG | DATS | 8 | DATUM | ||||
UATBG | Actual transport start time | UATBG | TIMS | 6 | UZEIT | ||||
STTEN | Status for end of shipment | STTEN | CHAR | 1 | STTRA | ||||
DPTEN | Planned date for end of shipment | DPTEN | DATS | 8 | DATUM | ||||
UPTEN | Planned transport end time | UPTEN | TIMS | 6 | UZEIT | ||||
DATEN | Actual Date for End of Shipment | DATEND | DATS | 8 | DATUM | ||||
UATEN | Actual shipment end time | UATEND | TIMS | 6 | UZEIT | ||||
STTRG | Overall transportation status | STTRG | CHAR | 1 | STTRG | ||||
TDLNR | Number of forwarding agent | TDLNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | F4_CARRIERS |
TERNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
PKSTK | Shipment Contains Handling Units | PKSTK_VTTK | CHAR | 1 | XFELD | ||||
DTMEG | Unit of Weight for Transportation Planning | DTMEG | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DTMEV | Volume Unit for Transportation Planning | DTMEV | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DISTZ | Distance | DISTZ | QUAN | 13(3) | MENG13 | ||||
MEDST | Unit of measure for distance | MEDST | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FAHZT | Travelling time only between two locations | FAHZT | QUAN | 5(2) | FAHZT | ||||
GESZT | Total travelling time between two locations incl. breaks | GESZT | QUAN | 5(2) | FAHZT | ||||
MEIZT | Unit of measure for travelling times | MEIZT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | Assigned to domain | ALPHA | STAFO | MCF | |
FBSTA | Status of shipment costs calculation | FBSTA | CHAR | 1 | FBSTA | ||||
FBGST | Overall status of calculation of shipment costs for shipment | FBGST | CHAR | 1 | FBGST | ||||
ARSTA | Status of shipment costs settlement | ARSTA | CHAR | 1 | ARSTA | ||||
ARGST | Total status of shipment costs settlement for shipment | ARGST | CHAR | 1 | ARGST | ||||
STERM_DONE | Leg determination complete | STERM_DONE | CHAR | 1 | STERM_DONE | ||||
VSE_FRK | Handling Unit Data are Referred in Shipment Cost Document | VSE_FRK | CHAR | 1 | VSE_FRK | ||||
KKALSM | Pricing procedure in shipment header | KALSM_KOPF | CHAR | 6 | T683 | KALSM | |||
SDABW | Special processing indicator | SDABW | CHAR | 4 | TVSAK | SDABW | |||
FRKRL | Shipment costs relevance | KFRKRL | CHAR | 1 | FRKRL | ||||
GESZTD | Planned total time of transportation (in days) | KP_GESZTDP | DEC | 11 | TSTRG | TSTRDURAG | |||
FAHZTD | Planned duration of transportation (in hours:minutes) | KP_EFFZTDP | DEC | 11 | TSTRN | TSTRDURAN | |||
GESZTDA | Actual total time of shipment (in days) | KP_GESZTDA | DEC | 11 | TSTRG | TSTRDURAG | |||
FAHZTDA | Actual time needed for transporation (in hours:minutes) | KP_EFFZTDA | DEC | 11 | TSTRN | TSTRDURAN | |||
ROCPY_DONE | Route copied from delivery | ROCPY_DONE | CHAR | 1 | ROCPY_DONE | ||||
HANDLE | Globally unique identifier (linked to time segment, etc) | TSEGGUID | CHAR | 22 | SYSUUID_22 | ||||
TSEGFL | Time segment exists | TSEGEXISTS | CHAR | 1 | FLAG | ||||
TSEGTP | Time segment event group shipment header | TSEGTPLVTT | CHAR | 10 | Assigned to domain | TMPLA | TSEGTEMPLA | ||
ADD01 | Suppl. 1 | VTTK_ADD01 | CHAR | 10 | VTADD01 | VTTK_ADD01 | |||
ADD02 | Suppl. 2 | VTTK_ADD02 | CHAR | 10 | VTADD02 | VTTK_ADD02 | |||
ADD03 | Suppl. 3 | VTTK_ADD03 | CHAR | 10 | VTADD03 | VTTK_ADD03 | |||
ADD04 | Suppl. 4 | VTTK_ADD04 | CHAR | 10 | VTADD04 | VTTK_ADD04 | |||
TEXT1 | Addit.text 1 | VTTK_TEXT1 | CHAR | 40 | TEXT40 | ||||
TEXT2 | Addit.text 2 | VTTK_TEXT2 | CHAR | 40 | TEXT40 | ||||
TEXT3 | Addit.text 3 | VTTK_TEXT3 | CHAR | 40 | TEXT40 | ||||
TEXT4 | Addit.text 4 | VTTK_TEXT4 | CHAR | 40 | TEXT40 | ||||
PROLI | Dangerous Goods Management Profile in SD Documents | ADGE_PROLI | CHAR | 3 | TDGC5 | ADGD_PROLI | TDGC5_PROLI_01 | ||
DGTLOCK | Block Indicator for Dangerous Goods | ADGE_TLOCK | CHAR | 1 | X | ||||
DGMDDAT | Selection date dangerous goods master data | ADGE_MDDAT | DATS | 8 | DATUM | ||||
CONT_DG | Indicator: Document contains dangerous goods | ADGE_NCDG | CHAR | 1 | X | ||||
WARZTD | Planned waiting time of shipment (in hours:minutes) | KP_WARZTDP | DEC | 11 | TSTRN | TSTRDURAN | |||
WARZTDA | Current waiting time of shipment (in hours:minutes) | KP_WARZTDA | DEC | 11 | TSTRN | TSTRDURAN | |||
AULWE | Route Schedule | AULWE | CHAR | 10 | Assigned to domain | AULWE | |||
TNDRST | Tender Status | TNDRST | CHAR | 2 | TNDRST | ||||
TNDRRC | Acceptance Condition/Rejection Reason | TNDRRC | CHAR | 2 | TNDRRC | ||||
TNDR_TEXT | Tendering Text | TNDR_TEXT | CHAR | 80 | TEXT80 | ||||
TNDRDAT | Date of tender status | TNDRDAT | DATS | 8 | DATUM | ||||
TNDRZET | Time of tender status | TNDRZET | TIMS | 6 | UZEIT | ||||
TNDR_MAXP | Maximum Price for Shipment | TNDR_MAXP | CURR | 15(2) | WERT15 | ||||
TNDR_MAXC | Currency of Maximum Price | TNDR_MAXC | CUKY | 5 | TCURC | WAERS | |||
TNDR_ACTP | Actual Shipment Costs for Shipment | TNDR_ACTP | CURR | 15(2) | WERT15 | ||||
TNDR_ACTC | Currency of Actual Shipment Costs | TNDR_ACTC | CUKY | 5 | TCURC | WAERS | |||
TNDR_CARR | Forwarding Agent Who Accepted the Shipment | TNDR_CARR | CHAR | 10 | TEXT10 | ||||
TNDR_CRNM | Name of Carrier Who Accepted the Shipment | TNDR_CRNM | CHAR | 35 | NAME | ||||
TNDR_TRKID | Forwarding Agent Tracking ID | TNDR_TRKID | CHAR | 35 | TEXT35 | ||||
TNDR_EXPD | Date on Which Offer Expires | TNDR_EXPD | DATS | 8 | DATUM | ||||
TNDR_EXPT | Time at Which Quotation Expires | TNDR_EXPT | TIMS | 6 | UZEIT | ||||
TNDR_ERPD | Earliest Pickup Date | TNDR_ERPD | DATS | 8 | DATUM | ||||
TNDR_ERPT | Earliest Pickup Time | TNDR_ERPT | TIMS | 6 | UZEIT | ||||
TNDR_LTPD | Latest Pickup Date | TNDR_LTPD | DATS | 8 | DATUM | ||||
TNDR_LTPT | Latest Pickup Time | TNDR_LTPT | TIMS | 6 | UZEIT | ||||
TNDR_ERDD | Earliest Delivery Date | TNDR_ERDD | DATS | 8 | DATUM | ||||
TNDR_ERDT | Earliest Delivery Time | TNDR_ERDT | TIMS | 6 | UZEIT | ||||
TNDR_LTDD | Latest Delivery Date | TNDR_LTDD | DATS | 8 | DATUM | ||||
TNDR_LTDT | Latest Delivery Time | TNDR_LTDT | TIMS | 6 | UZEIT | ||||
TNDR_LDLG | Length of Loading Platform | TNDR_LDLG | QUAN | 13(3) | MENG13 | ||||
TNDR_LDLU | Unit of Measure for Load Length | TNDR_LDLU | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
KZHULFR | Indicator: HUs Relevant for Delivery Item Generation | KZHULFR | CHAR | 1 | KZHULFR | ||||
ALLOWED_TWGT | Allowed total weight of shipment | ALLOWED_TWGT | QUAN | 8 | MENG12_0 | ||||
VLSTK | Distribution Status (Decentralized Warehouse Processing) | VLSTK | CHAR | 1 | VLSTK | ||||
VERURSYS | Shipment Distribution: Original System | TRA_VERURSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
CM_IDENT | Identification Number for Continuous Moves | CMIDENTIFIER | CHAR | 12 | CHAR12 | ||||
CM_SEQUENCE | Sequence of Transports in Connecting Traffice | CMSEQUENCE | NUMC | 4 | SEQUENCE1 | ||||
EXT_FREIGHT_ORD | External Freight Order ID | EXT_FREIGHT_ORDER | CHAR | 20 | EXT_FREIGHT_ORDER | ||||
EXT_TM_SYS | Key Name of Business System | SLD_BSKEY | CHAR | 60 | SLD_BSKEY | ||||
.INCLU--AP | 0 | ||||||||
/BEV1/RPFAR1 | Driver 1 | /DSD/RP_DRIVER1 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
/BEV1/RPFAR2 | Driver 2 | /DSD/RP_DRIVER2 | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
/BEV1/RPMOWA | Vehicle | /DSD/RP_TRUCK | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | ||
/BEV1/RPANHAE | Trailer | /DSD/RP_TRAIL | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | ||
/BEV1/RPFLGNR | Loading Sequence Number in the Tour | /DSD/RP_SEQUENCENR | NUMC | 5 | /DSD/RP_SEQUENCENR | ||||
.INCLU--AP | 0 | ||||||||
/VSO/R_STATUS | Status of Vehicle Space Optimization | /VSO/M_VSO_STATUS | CHAR | 1 | /VSO/M_VSO_STATUS |
Key field | Non-key field |
How do I retrieve data from SAP table VTTK using ABAP code
The following ABAP code Example will allow you to do a basic selection on VTTK to SELECT all data from the tableDATA: WA_VTTK TYPE VTTK.
SELECT SINGLE *
FROM VTTK
INTO CORRESPONDING FIELDS OF WA_VTTK
WHERE...
How to access SAP table VTTK
Within an ECC or HANA version of SAP you can also view further information about VTTK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects