SAP table VTTS (Stage of Shipment)

SAP table VTTS has 3 primary key fields being MANDT,TKNUM,TSNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TKNUM Shipment Number CHAR 10 0 VTTK TKNUM
TSNUM Stage of transport number NUMC 4 0 TSNUM
TSTYP Stage category CHAR 1 0 TSTYP
1 Transportation
2 Load transfer
3 Border
TSRFO Stage of transport sequence NUMC 4 0 TSRFO
ELUPD Change Indicator CHAR 1 0 ELUPD
1 Created automatically
2 Created automatically, changed manually
3 Created manually
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZET Time last change was made TIMS 6 0 AEZET
ROUTE Route for shipment stage CHAR 6 0 TVRO ROUTES
VSART Shipping type for shipment stage CHAR 2 0 T173 VERSARTS
INCO1 Incoterms for printout CHAR 3 0 TINC INCO1VTTS
LAUFK Leg indicator for shipment stage CHAR 1 0 LAUFS
ADRNA Departure point: Address CHAR 10 0 * ADRNA
KNOTA Departure Point CHAR 10 0 TVKN KNOTA
VSTEL Shipping point at point of departure CHAR 4 0 TVST VSTELA
LSTEL Point of departure: Loading point at shipping point CHAR 2 0 TVLA LSTELA
WERKA Plant at point of departure CHAR 4 0 T001W WERKSA
LGORTA Departure point: Storage location in plant CHAR 4 0 T001L LGORTA
KUNNA Departure point: Customer CHAR 10 0 KNA1 KUNNA
LIFNA Vendor number of departure point CHAR 10 0 LFA1 LIFNA
BELAD Point of departure: Additional info (e.g. loading point) CHAR 25 0 BELAD
ADRNZ Destination address CHAR 10 0 * ADRNZ
KNOTZ Destination point CHAR 10 0 TVKN KNOTZ
VSTEZ Shipping point at destination CHAR 4 0 TVST VSTELZ
LSTEZ Destination: Loading point at shipping point CHAR 2 0 TVLA LSTELZ
WERKZ Plant at destination point CHAR 4 0 T001W WERKSZ
LGORTZ Destination: Storage location in plant CHAR 4 0 T001L LGORTZ
KUNNZ Customer number for destination point CHAR 10 0 KNA1 KUNNZ
LIFNZ Vendor number of destination point CHAR 10 0 LFA1 LIFNZ
ABLAD Destination: Additional information (e.g. unloading point) CHAR 25 0 ABLADZ
DPTBG Stage: Planned date for start of shipment DATS 8 0 DPTBGS
UPTBG Stage: Planned shipment start time TIMS 6 0 UPTBGS
DATBG Stage: Current date for start of shipment DATS 8 0 DATBGS
UATBG Stage: Current shipment start time TIMS 6 0 UATBGS
DPTEN Stage: Planned date for end of shipment DATS 8 0 DPTENS
UPTEN Stage: Planned shipemnt end time TIMS 6 0 UPTENS
DATEN Stage: Actual Date for End of Shipment DATS 8 0 DATENDS
UATEN Stage: Actual shipment end time TIMS 6 0 UATENDS
TDLNR Number of forwarding agent in the shipment stage CHAR 10 0 LFA1 TDLNRS
DISTZ Distance QUAN 13 3 DISTZ
MEDST Distance Unit of Measure UNIT 3 0 * MEDST
FAHZT Travelling time only between two locations QUAN 5 2 FAHZT
GESZT Total travelling time between two locations incl. breaks QUAN 5 2 GESZT
MEIZT Unit of measure for travelling times UNIT 3 0 * MEIZT
LGNUMA Point of departure: Warehouse number CHAR 3 0 T300 LGNUMA
TORA Point of departure: Gate for warehouse number CHAR 3 0 T30B LGTORA
ADRKNZA Point of departure: Origin indicator of address CHAR 1 0 ADRKNZA
KUNABLA Point of departure: Customer's unloading point CHAR 25 0 KNVA KUNABLA
LGNUMZ Destination: Warehouse number CHAR 3 0 T300 LGNUMZ
TORZ Destination. Gate for warehouse number CHAR 3 0 T30B LGTORZ
ADRKNZZ Destination: Origin indicator of address CHAR 1 0 ADRKNZZ
KUNABLZ Destination: Customer's unloading point CHAR 25 0 KNVA KUNABLZ
GESZTD Planned total time at stage level (in days) DEC 11 0 AB_GESZTDP
FAHZTD Plan: Actual duration at stage level (in hours:minutes) DEC 11 0 AB_EFFZTDP
GESZTDA Actual total time at stage of shipment (in days) DEC 11 0 AB_GESZTDA
FAHZTDA Actual duration of shipment stage (in hours:minutes) DEC 11 0 AB_EFFZTDA
SDABW Special Processing Indicator CHAR 4 0 TVSAK SDABW
FRKRL Shipment costs relevance CHAR 1 0 FRKRL
Not relevant for freight costs
X Relevant for freight costs
SKALSM Pricing procedure in stage of shipment CHAR 6 0 T683 KALSM_TRAB
FBSTA Status of shipment costs calculation CHAR 1 0 FBSTA
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
ARSTA Status of shipment costs settlement CHAR 1 0 ARSTA
Not Relevant
A Not Processed
B Partially Processed
C Completely Processed
STAFO Update Group for statistics update CHAR 6 0 * STAFO
CONT_DG Indicator: Section contains dangerous goods CHAR 1 0 ADGE_SCDG
WARZTD Planned waiting time in shipment stage (in hrs:min) DEC 11 0 AB_WARZTDP
WARZTDA Current waiting time in shipment stage (in hrs:min) DEC 11 0 AB_WARZTDA
ABLAND1 Country of departure CHAR 3 0 T005 ABLAND1
ABPSTLZ Departure postal code CHAR 10 0 ABPSTLZ
ABORT01 Point of departure CHAR 35 0 ABORT01
EDLAND1 Destination Country CHAR 3 0 T005 EDLAND1
EDPSTLZ Destination Postal Code CHAR 10 0 EDPSTLZ
EDORT01 Destination CHAR 35 0 EDORT01

VTTS foreign key relationships

Table Field Check Table Check Field
0 VTTS ABLAND1 T005 Countries MANDT
0 VTTS ABLAND1 T005 Countries LAND1
1 VTTS EDLAND1 T005 Countries MANDT
1 VTTS EDLAND1 T005 Countries LAND1
0 VTTS INCO1 TINC Customers: Incoterms INCO1
1 VTTS KNOTA TVKN Routes: Transportation Connection Points MANDT
1 VTTS KNOTA TVKN Routes: Transportation Connection Points KNOTE
0 VTTS KNOTZ TVKN Routes: Transportation Connection Points MANDT
0 VTTS KNOTZ TVKN Routes: Transportation Connection Points KNOTE
1 VTTS KUNABLA KNVA Customer Master Unloading Points MANDT
1 VTTS KUNABLA KNVA Customer Master Unloading Points KUNNR
0 VTTS KUNABLZ KNVA Customer Master Unloading Points MANDT
0 VTTS KUNABLZ KNVA Customer Master Unloading Points KUNNR
1 VTTS KUNNA KNA1 General Data in Customer Master MANDT
1 VTTS KUNNA KNA1 General Data in Customer Master KUNNR
0 VTTS KUNNZ KNA1 General Data in Customer Master MANDT
0 VTTS KUNNZ KNA1 General Data in Customer Master KUNNR
1 VTTS LGNUMA T300 WM Warehouse Numbers MANDT
1 VTTS LGNUMA T300 WM Warehouse Numbers LGNUM
0 VTTS LGNUMZ T300 WM Warehouse Numbers MANDT
0 VTTS LGNUMZ T300 WM Warehouse Numbers LGNUM
1 VTTS LGORTA T001L Storage Locations MANDT
1 VTTS LGORTA T001L Storage Locations WERKS
0 VTTS LGORTZ T001L Storage Locations MANDT
0 VTTS LGORTZ T001L Storage Locations WERKS
1 VTTS LIFNA LFA1 Supplier Master (General Section) MANDT
1 VTTS LIFNA LFA1 Supplier Master (General Section) LIFNR
0 VTTS LIFNZ LFA1 Supplier Master (General Section) MANDT
0 VTTS LIFNZ LFA1 Supplier Master (General Section) LIFNR
1 VTTS MANDT T000 Clients MANDT
0 VTTS ROUTE TVRO Routes MANDT
0 VTTS ROUTE TVRO Routes ROUTE
1 VTTS SDABW TVSAK Special Processing Indicator SDABW
0 VTTS SKALSM T683 Pricing procedures KAPPL
0 VTTS SKALSM T683 Pricing procedures KALSM
1 VTTS TDLNR LFA1 Supplier Master (General Section) MANDT
1 VTTS TDLNR LFA1 Supplier Master (General Section) LIFNR
0 VTTS TKNUM VTTK Shipment Header MANDT
0 VTTS TKNUM VTTK Shipment Header TKNUM
1 VTTS TORA T30B WM Gates MANDT
1 VTTS TORA T30B WM Gates LGNUM
1 VTTS TORA T30B WM Gates LGTOR
0 VTTS TORZ T30B WM Gates MANDT
0 VTTS TORZ T30B WM Gates LGNUM
0 VTTS TORZ T30B WM Gates LGTOR
1 VTTS VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
1 VTTS VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
0 VTTS VSTEL TVST Organizational Unit: Shipping Points MANDT
0 VTTS VSTEL TVST Organizational Unit: Shipping Points VSTEL
1 VTTS VSTEZ TVST Organizational Unit: Shipping Points MANDT
1 VTTS VSTEZ TVST Organizational Unit: Shipping Points VSTEL
0 VTTS WERKA T001W Plants/Branches MANDT
0 VTTS WERKA T001W Plants/Branches WERKS
1 VTTS WERKZ T001W Plants/Branches MANDT
1 VTTS WERKZ T001W Plants/Branches WERKS