VTTK SAP (Shipment Header) Table details

Dictionary Type: Table
Description: Shipment Header




ABAP Code to SELECT data from VTTK
Related tables to VTTK
Access table VTTK




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
MANDTClient MANDTCLNT3T000MANDT
TKNUMShipment Number TKNUMCHAR10ALPHATKNUMTNRSD_F4_SHP_ID
VBTYPSD document category VBTYPCHAR1VBTYP
SHTYPShipment type SHTYPCHAR4TVTKSHTYPTSH
TPLSTTransportation planning point TPLSTCHAR4TTDSTPLSTTDP
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZETEntry time ERZETTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AEZETTime last change was made AEZETTIMS6UZEIT
STERMLeg determination STERMCHAR1STERM
ABFERShipment completion type ABFERCHAR1ABFER
ABWSTProcessing control ABWSTCHAR1ABWST
BFARTService Level BFARTCHAR1BFART
VSARTShipping type VSARTTRCHAR2T173VERSART
VSAVLShipping type of preliminary leg VSAVLCHAR2T173VERSART
VSANLShipping type of subsequent leg VSANLCHAR2T173VERSART
LAUFKLeg Indicator LAUFKCHAR1LAUFK
VSBEDShipping Conditions VSBEDCHAR2TVSBVSBED
ROUTEShipment route ROUTRCHAR6TVROROUTEVMTR
SIGNIContainer ID SIGNICHAR20TEXT20
EXTI1External identification 1 EXTI1CHAR20TEXT20
EXTI2External identification 2 EXTI2CHAR20TEXT20
TPBEZDescription of Shipment TPBEZCHAR20TEXT20
STDISStatus of transportation planning STDISCHAR1STTRA
DTDISDate of end of planning DTDISDATS8DATUM
UZDISScheduling end time UZDISTIMS6UZEIT
STREGStatus of check-in STREGCHAR1STTRA
DPREGPlanned date of check-in DPREGDATS8DATUM
UPREGPlanned check-in time UPREGTIMS6UZEIT
DAREGActual date of check-in DAREGDATS8DATUM
UAREGCurrent time of check-in UAREGTIMS6UZEIT
STLBGStatus for start of loading STLBGCHAR1STTRA
DPLBGPlanned date for start of loading DPLBGDATS8DATUM
UPLBGPlanned loading start time UPLBGTIMS6UZEIT
DALBGCurrent date for start of loading DALBGDATS8DATUM
UALBGActual loading start time UALBGTIMS6UZEIT
STLADStatus for end of loading STLADCHAR1STTRA
DPLENPlanned date for end of loading DPLENDDATS8DATUM
UPLENPlanned loading end time UPLENDTIMS6UZEIT
DALENActual date for end of loading DALENDDATS8DATUM
UALENActual loading end time UALENDTIMS6UZEIT
STABFStatus of shipment completion STABFCHAR1STTRA
DPABFPlanned date for shipment completion DPABFDATS8DATUM
UPABFPlanned time for processing UPABFTIMS6UZEIT
DTABFCurrent date of shipment completion DTABFDATS8DATUM
UZABFTime of transportation processing UZABFTIMS6UZEIT
STTBGStatus for start of shipment STTBGCHAR1STTRA
DPTBGPlanned date for start of shipment DPTBGDATS8DATUM
UPTBGPlanned transport start time UPTBGTIMS6UZEIT
DATBGCurrent date for start of shipment DATBGDATS8DATUM
UATBGActual transport start time UATBGTIMS6UZEIT
STTENStatus for end of shipment STTENCHAR1STTRA
DPTENPlanned date for end of shipment DPTENDATS8DATUM
UPTENPlanned transport end time UPTENTIMS6UZEIT
DATENActual Date for End of Shipment DATENDDATS8DATUM
UATENActual shipment end time UATENDTIMS6UZEIT
STTRGOverall transportation status STTRGCHAR1STTRG
TDLNRNumber of forwarding agent TDLNRCHAR10LFA1ALPHALIFNRLIFF4_CARRIERS
TERNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
PKSTKShipment Contains Handling Units PKSTK_VTTKCHAR1XFELD
DTMEGUnit of Weight for Transportation Planning DTMEGUNIT3Assigned to domainCUNITMEINS
DTMEVVolume Unit for Transportation Planning DTMEVUNIT3Assigned to domainCUNITMEINS
DISTZDistance DISTZQUAN13(3) MENG13
MEDSTUnit of measure for distance MEDSTUNIT3Assigned to domainCUNITMEINS
FAHZTTravelling time only between two locations FAHZTQUAN5(2) FAHZT
GESZTTotal travelling time between two locations incl. breaks GESZTQUAN5(2) FAHZT
MEIZTUnit of measure for travelling times MEIZTUNIT3Assigned to domainCUNITMEINS
STAFOUpdate group for statistics update STAFOCHAR6Assigned to domainALPHASTAFOMCF
FBSTAStatus of shipment costs calculation FBSTACHAR1FBSTA
FBGSTOverall status of calculation of shipment costs for shipment FBGSTCHAR1FBGST
ARSTAStatus of shipment costs settlement ARSTACHAR1ARSTA
ARGSTTotal status of shipment costs settlement for shipment ARGSTCHAR1ARGST
STERM_DONELeg determination complete STERM_DONECHAR1STERM_DONE
VSE_FRKHandling Unit Data are Referred in Shipment Cost Document VSE_FRKCHAR1VSE_FRK
KKALSMPricing procedure in shipment header KALSM_KOPFCHAR6T683KALSM
SDABWSpecial processing indicator SDABWCHAR4TVSAKSDABW
FRKRLShipment costs relevance KFRKRLCHAR1FRKRL
GESZTDPlanned total time of transportation (in days) KP_GESZTDPDEC11TSTRGTSTRDURAG
FAHZTDPlanned duration of transportation (in hours:minutes) KP_EFFZTDPDEC11TSTRNTSTRDURAN
GESZTDAActual total time of shipment (in days) KP_GESZTDADEC11TSTRGTSTRDURAG
FAHZTDAActual time needed for transporation (in hours:minutes) KP_EFFZTDADEC11TSTRNTSTRDURAN
ROCPY_DONERoute copied from delivery ROCPY_DONECHAR1ROCPY_DONE
HANDLEGlobally unique identifier (linked to time segment, etc) TSEGGUIDCHAR22SYSUUID_22
TSEGFLTime segment exists TSEGEXISTSCHAR1FLAG
TSEGTPTime segment event group shipment header TSEGTPLVTTCHAR10Assigned to domainTMPLATSEGTEMPLA
ADD01Suppl. 1 VTTK_ADD01CHAR10VTADD01VTTK_ADD01
ADD02Suppl. 2 VTTK_ADD02CHAR10VTADD02VTTK_ADD02
ADD03Suppl. 3 VTTK_ADD03CHAR10VTADD03VTTK_ADD03
ADD04Suppl. 4 VTTK_ADD04CHAR10VTADD04VTTK_ADD04
TEXT1Addit.text 1 VTTK_TEXT1CHAR40TEXT40
TEXT2Addit.text 2 VTTK_TEXT2CHAR40TEXT40
TEXT3Addit.text 3 VTTK_TEXT3CHAR40TEXT40
TEXT4Addit.text 4 VTTK_TEXT4CHAR40TEXT40
PROLIDangerous Goods Management Profile in SD Documents ADGE_PROLICHAR3TDGC5ADGD_PROLITDGC5_PROLI_01
DGTLOCKBlock Indicator for Dangerous Goods ADGE_TLOCKCHAR1X
DGMDDATSelection date dangerous goods master data ADGE_MDDATDATS8DATUM
CONT_DGIndicator: Document contains dangerous goods ADGE_NCDGCHAR1X
WARZTDPlanned waiting time of shipment (in hours:minutes) KP_WARZTDPDEC11TSTRNTSTRDURAN
WARZTDACurrent waiting time of shipment (in hours:minutes) KP_WARZTDADEC11TSTRNTSTRDURAN
AULWERoute Schedule AULWECHAR10Assigned to domainAULWE
TNDRSTTender Status TNDRSTCHAR2TNDRST
TNDRRCAcceptance Condition/Rejection Reason TNDRRCCHAR2TNDRRC
TNDR_TEXTTendering Text TNDR_TEXTCHAR80TEXT80
TNDRDATDate of tender status TNDRDATDATS8DATUM
TNDRZETTime of tender status TNDRZETTIMS6UZEIT
TNDR_MAXPMaximum Price for Shipment TNDR_MAXPCURR15(2) WERT15
TNDR_MAXCCurrency of Maximum Price TNDR_MAXCCUKY5TCURCWAERS
TNDR_ACTPActual Shipment Costs for Shipment TNDR_ACTPCURR15(2) WERT15
TNDR_ACTCCurrency of Actual Shipment Costs TNDR_ACTCCUKY5TCURCWAERS
TNDR_CARRForwarding Agent Who Accepted the Shipment TNDR_CARRCHAR10TEXT10
TNDR_CRNMName of Carrier Who Accepted the Shipment TNDR_CRNMCHAR35NAME
TNDR_TRKIDForwarding Agent Tracking ID TNDR_TRKIDCHAR35TEXT35
TNDR_EXPDDate on Which Offer Expires TNDR_EXPDDATS8DATUM
TNDR_EXPTTime at Which Quotation Expires TNDR_EXPTTIMS6UZEIT
TNDR_ERPDEarliest Pickup Date TNDR_ERPDDATS8DATUM
TNDR_ERPTEarliest Pickup Time TNDR_ERPTTIMS6UZEIT
TNDR_LTPDLatest Pickup Date TNDR_LTPDDATS8DATUM
TNDR_LTPTLatest Pickup Time TNDR_LTPTTIMS6UZEIT
TNDR_ERDDEarliest Delivery Date TNDR_ERDDDATS8DATUM
TNDR_ERDTEarliest Delivery Time TNDR_ERDTTIMS6UZEIT
TNDR_LTDDLatest Delivery Date TNDR_LTDDDATS8DATUM
TNDR_LTDTLatest Delivery Time TNDR_LTDTTIMS6UZEIT
TNDR_LDLGLength of Loading Platform TNDR_LDLGQUAN13(3) MENG13
TNDR_LDLUUnit of Measure for Load Length TNDR_LDLUUNIT3Assigned to domainCUNITMEINS
KZHULFRIndicator: HUs Relevant for Delivery Item Generation KZHULFRCHAR1KZHULFR
ALLOWED_TWGTAllowed total weight of shipment ALLOWED_TWGTQUAN8MENG12_0
VLSTKDistribution Status (Decentralized Warehouse Processing) VLSTKCHAR1VLSTK
VERURSYSShipment Distribution: Original System TRA_VERURSYSCHAR10Assigned to domainALPHALOGSYS
CM_IDENTIdentification Number for Continuous Moves CMIDENTIFIERCHAR12CHAR12
CM_SEQUENCESequence of Transports in Connecting Traffice CMSEQUENCENUMC4SEQUENCE1
EXT_FREIGHT_ORDExternal Freight Order ID EXT_FREIGHT_ORDERCHAR20EXT_FREIGHT_ORDER
EXT_TM_SYSKey Name of Business System SLD_BSKEYCHAR60SLD_BSKEY
.INCLU--AP 0
/BEV1/RPFAR1Driver 1 /DSD/RP_DRIVER1CHAR10KNA1ALPHAKUNNR
/BEV1/RPFAR2Driver 2 /DSD/RP_DRIVER2CHAR10KNA1ALPHAKUNNR
/BEV1/RPMOWAVehicle /DSD/RP_TRUCKCHAR18Assigned to domainALPHAEQUNR
/BEV1/RPANHAETrailer /DSD/RP_TRAILCHAR18Assigned to domainALPHAEQUNR
/BEV1/RPFLGNRLoading Sequence Number in the Tour /DSD/RP_SEQUENCENRNUMC5/DSD/RP_SEQUENCENR
.INCLU--AP 0
/VSO/R_STATUSStatus of Vehicle Space Optimization /VSO/M_VSO_STATUSCHAR1/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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!