SAP Table VTTS

Stage of Shipment

VTTS (Stage of Shipment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VTTS to other SAP tables.

VTTS table fields

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

VTTS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTTS ABLAND1 VTTS MANDT T005 Countries MANDT
VTTS ABLAND1 VTTS ABLAND1 T005 Countries LAND1
VTTS EDLAND1 VTTS MANDT T005 Countries MANDT
VTTS EDLAND1 VTTS EDLAND1 T005 Countries LAND1
VTTS INCO1 VTTS MANDT TINC Customers: Incoterms MANDT
VTTS INCO1 VTTS INCO1 TINC Customers: Incoterms INCO1
VTTS KNOTA VTTS MANDT TVKN Routes: Transportation Connection Points MANDT
VTTS KNOTA VTTS KNOTA TVKN Routes: Transportation Connection Points KNOTE
VTTS KNOTZ VTTS KNOTZ TVKN Routes: Transportation Connection Points KNOTE
VTTS KNOTZ VTTS MANDT TVKN Routes: Transportation Connection Points MANDT
VTTS KUNABLA VTTS KUNABLA KNVA Customer Master Unloading Points ABLAD
VTTS KUNABLA VTTS MANDT KNVA Customer Master Unloading Points MANDT
VTTS KUNABLA VTTS KUNNA KNVA Customer Master Unloading Points KUNNR
VTTS KUNABLZ VTTS MANDT KNVA Customer Master Unloading Points MANDT
VTTS KUNABLZ VTTS KUNNZ KNVA Customer Master Unloading Points KUNNR
VTTS KUNABLZ VTTS KUNABLZ KNVA Customer Master Unloading Points ABLAD
VTTS KUNNA VTTS MANDT KNA1 General Data in Customer Master MANDT
VTTS KUNNA VTTS KUNNA KNA1 General Data in Customer Master KUNNR
VTTS KUNNZ VTTS MANDT KNA1 General Data in Customer Master MANDT
VTTS KUNNZ VTTS KUNNZ KNA1 General Data in Customer Master KUNNR
VTTS LGNUMA VTTS MANDT T300 WM Warehouse Numbers MANDT
VTTS LGNUMA VTTS LGNUMA T300 WM Warehouse Numbers LGNUM
VTTS LGNUMZ VTTS LGNUMZ T300 WM Warehouse Numbers LGNUM
VTTS LGNUMZ VTTS MANDT T300 WM Warehouse Numbers MANDT
VTTS LGORTA VTTS MANDT T001L Storage Locations MANDT
VTTS LGORTA VTTS WERKA T001L Storage Locations WERKS
VTTS LGORTA VTTS LGORTA T001L Storage Locations LGORT
VTTS LGORTZ VTTS LGORTZ T001L Storage Locations LGORT
VTTS LGORTZ VTTS MANDT T001L Storage Locations MANDT
VTTS LGORTZ VTTS WERKZ T001L Storage Locations WERKS
VTTS LIFNA VTTS LIFNA LFA1 Vendor Master (General Section) LIFNR
VTTS LIFNA VTTS MANDT LFA1 Vendor Master (General Section) MANDT
VTTS LIFNZ VTTS MANDT LFA1 Vendor Master (General Section) MANDT
VTTS LIFNZ VTTS LIFNZ LFA1 Vendor Master (General Section) LIFNR
VTTS LSTEL VTTS MANDT TVLA Org.unit: Loading points per shipping point MANDT
VTTS LSTEL VTTS VSTEL TVLA Org.unit: Loading points per shipping point VSTEL
VTTS LSTEL VTTS LSTEL TVLA Org.unit: Loading points per shipping point LSTEL
VTTS LSTEZ VTTS VSTEZ TVLA Org.unit: Loading points per shipping point VSTEL
VTTS LSTEZ VTTS LSTEZ TVLA Org.unit: Loading points per shipping point LSTEL
VTTS LSTEZ VTTS MANDT TVLA Org.unit: Loading points per shipping point MANDT
VTTS MANDT VTTS MANDT T000 Clients MANDT
VTTS OIG_MEIZT VTTS OIG_MEIZT T006 Units of Measurement MSEHI
VTTS OIG_MEIZT SY MANDT T006 Units of Measurement MANDT
VTTS ROUTE VTTS MANDT TVRO Routes MANDT
VTTS ROUTE VTTS ROUTE TVRO Routes ROUTE
VTTS SDABW VTTS SDABW TVSAK Special Processing Indicator SDABW
VTTS SDABW VTTS MANDT TVSAK Special Processing Indicator MANDT
VTTS SKALSM VTTS SKALSM T683 Pricing procedures KALSM
VTTS SKALSM VTTS MANDT T683 Pricing procedures MANDT
VTTS SKALSM 'A' T683 Pricing procedures KVEWE
VTTS SKALSM 'F ' T683 Pricing procedures KAPPL
VTTS TDLNR VTTS MANDT LFA1 Vendor Master (General Section) MANDT
VTTS TDLNR VTTS TDLNR LFA1 Vendor Master (General Section) LIFNR
VTTS TKNUM VTTS TKNUM VTTK Shipment Header TKNUM
VTTS TKNUM VTTS MANDT VTTK Shipment Header MANDT
VTTS TORA VTTS MANDT T30B WM Gates MANDT
VTTS TORA VTTS LGNUMA T30B WM Gates LGNUM
VTTS TORA VTTS TORA T30B WM Gates LGTOR
VTTS TORZ VTTS LGNUMZ T30B WM Gates LGNUM
VTTS TORZ VTTS TORZ T30B WM Gates LGTOR
VTTS TORZ VTTS MANDT T30B WM Gates MANDT
VTTS VSART VTTS MANDT T173 Routes: Mode of Transport for Each Shipping Type MANDT
VTTS VSART VTTS VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
VTTS VSTEL VTTS MANDT TVST Organizational Unit: Shipping Points MANDT
VTTS VSTEL VTTS VSTEL TVST Organizational Unit: Shipping Points VSTEL
VTTS VSTEZ VTTS MANDT TVST Organizational Unit: Shipping Points MANDT
VTTS VSTEZ VTTS VSTEZ TVST Organizational Unit: Shipping Points VSTEL
VTTS WERKA VTTS MANDT T001W Plants/Branches MANDT
VTTS WERKA VTTS WERKA T001W Plants/Branches WERKS
VTTS WERKZ VTTS MANDT T001W Plants/Branches MANDT
VTTS WERKZ VTTS WERKZ T001W Plants/Branches WERKS