1. Home
  2. Resources
  3. SAP Tables
  4. VTTS_ALL - Leg Data and Descriptions

SAP Table VTTS_ALL

Leg Data and Descriptions

VTTS_ALL (Leg Data and Descriptions) 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_ALL to other SAP tables.

VTTS_ALL 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
UPDKZ Update indicator UPDKZ_D CHAR 1 0
DLNAMT Name of the Service Agent DLNRNAME CHAR 35 0
VSBEDT Description of the shipping conditions VSBED_BEZ CHAR 20 0
ADRNAD Departure point: Address ADRNA CHAR 10 0
ADRHNDA Point of departure: Handle of an address ADRHNDA CHAR 10 0
UPDADA Point of departure: Update indicator of address UPDKZA CHAR 1 0
TKNOTA Description of departure point BEZKNOTA CHAR 30 0
TORT2A Description of departure point - Part 2 BEZKNOTA2 CHAR 30 0
PSTLZA Departure point: Postal code PSTLZ_A CHAR 10 0
LAND1A Point of departure: Country key LAND1_A CHAR 3 0
LZONEA Point of departure: Transportation zone LZONE_A CHAR 10 0
REGIOA Dep.point: Region (state, Federal county, province etc.) REGIO_A CHAR 3 0
BEZKOMPRA Departure point: Description of location (compressed) BEZKOMPRA CHAR 60 0
ADRNZD Destination address ADRNZ CHAR 10 0
ADRHNDZ Destination: Handle of an address ADRHNDZ CHAR 10 0
UPDADZ Destination: Update indicator of address UPDKZZ CHAR 1 0
TKNOTZ Description of destination point BEZKNOTZ CHAR 30 0
TORT2Z Description of destination - Part 2 BEZKNOTZ2 CHAR 30 0
PSTLZZ Destination: Postal code PSTLZ_Z CHAR 10 0
LAND1Z Destination: Country key LAND1_Z CHAR 3 0
LZONEZ Destination: Transportation zone LZONE_Z CHAR 10 0
REGIOZ Destination: Region (state, Federal county, province) REGIO_Z CHAR 3 0
BEZKOMPRZ Destination: Description of Location (Compressed) BEZKOMPRZ CHAR 60 0
ADRNRDL Address no. of forwarding agent ADRNR_SP CHAR 10 0
ADRDADL Address indicator ADRDA CHAR 1 0
NULL No address exists
A Address from master data
B Address entered in document manually
C Address entered in document manually / dependent on 'B'
D ADRC address from master data
E ADRC address entered in document manually
F ADRC address entered in document manually / dep. on 'E' doc.
G Private address from master data
TSTYP_TXT Description of stage category TSTYP_TXT CHAR 15 0
TSTYP_ICON Stage category, represented with an icon TSTYP_ICON CHAR 15 0
ELUPD_TXT Description of change indicator ELUPD_TXT CHAR 20 0
ROUTE_TXT Name of shipment route ROUTE_TXT CHAR 30 0
VSART_TXT Description of shipping type VSART_TXT CHAR 15 0
INCO1_TXT Incoterms description for printing INCO1_TXT CHAR 15 0
LAUFK_TXT Leg indicator description LAUFK_TXT CHAR 15 0
TDLNR_TXT Forwarding agent name TDLNR_TXT CHAR 35 0
SDABW_TXT Description of special processing indicator SDABW_TXT CHAR 35 0
FRKRL_TXT Description of freight costs relevance FRKRL_TXT CHAR 40 0
SKALSM_TXT Name of procedure for shipment stage SKALSM_TXT CHAR 30 0
FBSTA_TXT Status of shipment costs calculation FBSTA_TXT CHAR 30 0
ARSTA_TXT Status of shipment cost settlement (description) ARSTA_TXT CHAR 30 0
BAHNRA TrainStnNumber BAHNR CHAR 10 0
STBNHA Indicator: General cargo train station STBNH CHAR 1 0
X Yes
NULL No
EXBNHA Express train station EXBNH CHAR 1 0
X Yes
NULL No
PABNHA Train station used for freight transport PABNH CHAR 1 0
X Yes
NULL No
LABNHA Loading train station LABNH CHAR 1 0
X Yes
NULL No
BAHNGA Rail carrier BAHNG CHAR 10 0
STREKLA Leg class for rail STREKL CHAR 7 0
BAHNRZ TrainStnNumber BAHNR CHAR 10 0
STBNHZ Indicator: General cargo train station STBNH CHAR 1 0
X Yes
NULL No
EXBNHZ Express train station EXBNH CHAR 1 0
X Yes
NULL No
PABNHZ Train station used for freight transport PABNH CHAR 1 0
X Yes
NULL No
LABNHZ Loading train station LABNH CHAR 1 0
X Yes
NULL No
BAHNGZ Rail carrier BAHNG CHAR 10 0
STREKLZ Leg class for rail STREKL CHAR 7 0
BAHNGA_TXT Name of rail carrier BAHNG_TXT CHAR 35 0
BAHNGZ_TXT Name of rail carrier BAHNG_TXT CHAR 35 0
LOCA_TXT Departure point: Description of location (compressed) BEZKOMPRA CHAR 60 0
LOCZ_TXT Destination: Description of Location (Compressed) BEZKOMPRZ CHAR 60 0
KNOTA_TXT Point description KNOTE_TXT CHAR 30 0
VSTEL_TXT Description of shipping point VSTEL_TXT CHAR 30 0
LSTEL_TXT Description of loading point LSTEL_TXT CHAR 20 0
KUNNA_TXT Customer description KUNNR_TXT CHAR 35 0
LIFNA_TXT Vendor description LIFNR_TXT CHAR 35 0
WERKA_TXT Plant description WERKS_TXT CHAR 30 0
LGORTA_TXT Description of storage location LGORT_TXT CHAR 16 0
LGNUMA_TXT Warehouse number description LGNUM_TXT CHAR 25 0
LGTORA_TXT Door description LGTOR_TXT CHAR 25 0
ADRNA_TXT Full details of address ADRNR_TXT CHAR 80 0
VSLSA_TXT Combined description of shipping point/loading point VSTLST_TXT CHAR 50 0
WKLGA_TXT Combined description plant / storage location WRKLGO_TXT CHAR 50 0
LGTRA_TXT Concatenated description for warehouse number / gate LGNTOR_TXT CHAR 50 0
ADKNZA_TXT Origin of the address ADRKNZ_TXT CHAR 50 0
KNOTZ_TXT Point description KNOTE_TXT CHAR 30 0
VSTEZ_TXT Description of shipping point VSTEL_TXT CHAR 30 0
LSTEZ_TXT Description of loading point LSTEL_TXT CHAR 20 0
KUNNZ_TXT Customer description KUNNR_TXT CHAR 35 0
LIFNZ_TXT Vendor description LIFNR_TXT CHAR 35 0
WERKZ_TXT Plant description WERKS_TXT CHAR 30 0
LGORTZ_TXT Description of storage location LGORT_TXT CHAR 16 0
LGNUMZ_TXT Warehouse number description LGNUM_TXT CHAR 25 0
LGTORZ_TXT Door description LGTOR_TXT CHAR 25 0
ADRNZ_TXT Full details of address ADRNR_TXT CHAR 80 0
VSLSZ_TXT Combined description of shipping point/loading point VSTLST_TXT CHAR 50 0
WKLGZ_TXT Combined description plant / storage location WRKLGO_TXT CHAR 50 0
LGTRZ_TXT Concatenated description for warehouse number / gate LGNTOR_TXT CHAR 50 0
ADKNZZ_TXT Origin of the address ADRKNZ_TXT CHAR 50 0
MARK Selection indicator MARKFIELD CHAR 1 0
NULL No
X Yes
TXT_INFO Description with lenght of 80 BEZEI80 CHAR 80 0
SEP1 Optical division of columns in table control SEPARATOR CHAR 1 0
X Yes
NULL No
SEP2 Optical division of columns in table control SEPARATOR CHAR 1 0
X Yes
NULL No
SEP3 Optical division of columns in table control SEPARATOR CHAR 1 0
X Yes
NULL No

VTTS_ALL foreign key relationships

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