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 |
Possible values
|
||||||||||||
TSRFO | Stage of transport sequence | TSRFO | NUMC | 4 | 0 | |||||||||||||
ELUPD | Change Indicator | ELUPD | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
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 |
Possible values
|
||||||||||||
SKALSM | Pricing procedure in stage of shipment | KALSM_TRAB | T683 | CHAR | 6 | 0 | ||||||||||||
FBSTA | Status of shipment costs calculation | FBSTA | CHAR | 1 | 0 |
Possible values
|
||||||||||||
ARSTA | Status of shipment costs settlement | ARSTA | CHAR | 1 | 0 |
Possible values
|
||||||||||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | 0 | |||||||||||||
CONT_DG | Indicator: Section contains dangerous goods | ADGE_SCDG | CHAR | 1 | 0 |
Possible values
|
||||||||||||
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 |