VTTS

Stage of Shipment | #transactional | Component: Transportation

🔑 Keys (3)
💰 Amounts
∑ Quantities (3)
📅 Dates (12)
☰ Categorical (9)
Other (18)
🔗 Relations (30)

Column Name	Description
MANDT FK	Client
TKNUM FK	Shipment Number
TSNUM	Stage of transport number

Column Name	Description

Column Name	Description
📏 Distance Unit of Measure (MEDST):
DISTZ	Distance
📏 Unit of measure for travelling times (MEIZT):
FAHZT	Travelling time only between two locations
GESZT	Total travelling time between two locations incl. breaks

Column Name	Description
ERDAT	Date on which the record was created
ERZET	Entry time
AEDAT	Last Changed On
AEZET	Time last change was made
DPTBG	Stage: Planned date for start of shipment
UPTBG	Stage: Planned shipment start time
DATBG	Stage: Current date for start of shipment
UATBG	Stage: Current shipment start time
DPTEN	Stage: Planned date for end of shipment
UPTEN	Stage: Planned shipemnt end time
DATEN	Stage: Actual Date for End of Shipment
UATEN	Stage: Actual shipment end time

Column Name	Description
TSTYP	Stage category	Show values
ELUPD	Change Indicator	Show values
LAUFK	Leg indicator for shipment stage	Show values
ADRKNZA	Point of departure: Origin indicator of address	Show values
ADRKNZZ	Destination: Origin indicator of address	Show values
FRKRL	Shipment costs relevance	Show values
FBSTA	Status of shipment costs calculation	Show values
ARSTA	Status of shipment costs settlement	Show values
CONT_DG	Indicator: Section contains dangerous goods	Show values

Column Name	Description	Domain name
TSRFO	Stage of transport sequence	TSRFO
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
ADRNA	Departure point: Address	ADRNR
BELAD	Point of departure: Additional info (e.g. loading point)	TEXT25
ADRNZ	Destination address	ADRNR
ABLAD	Destination: Additional information (e.g. unloading point)	TEXT25
GESZTD	Planned total time at stage level (in days)	TSTRDURAG
FAHZTD	Plan: Actual duration at stage level (in hours:minutes)	TSTRDURAN
GESZTDA	Actual total time at stage of shipment (in days)	TSTRDURAG
FAHZTDA	Actual duration of shipment stage (in hours:minutes)	TSTRDURAN
STAFO	Update Group for statistics update	STAFO
WARZTD	Planned waiting time in shipment stage (in hrs:min)	TSTRDURAN
WARZTDA	Current waiting time in shipment stage (in hrs:min)	TSTRDURAN
ABPSTLZ	Departure postal code	PSTLZ
ABORT01	Point of departure	ORT01
EDPSTLZ	Destination Postal Code	PSTLZ
EDORT01	Destination	ORT01

Master Data Relations	Join Conditions
Country of departure Country of departure Client	`VTTS.ABLAND1 == T005.LAND1` `VTTS.MANDT == T005.MANDT`
Destination Country Destination Country Client	`VTTS.EDLAND1 == T005.LAND1` `VTTS.MANDT == T005.MANDT`
Incoterms for printout Incoterms for printout Client	`VTTS.INCO1 == TINC.INCO1` `VTTS.MANDT == TINC.MANDT`
Departure Point Departure Point Client	`VTTS.KNOTA == TVKN.KNOTE` `VTTS.MANDT == TVKN.MANDT`
Destination point Destination point Client	`VTTS.KNOTZ == TVKN.KNOTE` `VTTS.MANDT == TVKN.MANDT`
Point of departure: Customer's unloading point Departure point: Customer Client Point of departure: Customer's unloading point	`VTTS.KUNNA == KNVA.KUNNR` `VTTS.MANDT == KNVA.MANDT` `VTTS.KUNABLA == KNVA.ABLAD`
Destination: Customer's unloading point Customer number for destination point Client Destination: Customer's unloading point	`VTTS.KUNNZ == KNVA.KUNNR` `VTTS.MANDT == KNVA.MANDT` `VTTS.KUNABLZ == KNVA.ABLAD`
Departure point: Customer	`VTTS.MANDT == KNA1.MANDT` `VTTS.KUNNA == KNA1.KUNNR`
Customer number for destination point	`VTTS.MANDT == KNA1.MANDT` `VTTS.KUNNZ == KNA1.KUNNR`
Point of departure: Warehouse number Point of departure: Warehouse number Client	`VTTS.LGNUMA == T300.LGNUM` `VTTS.MANDT == T300.MANDT`
Destination: Warehouse number Destination: Warehouse number Client	`VTTS.LGNUMZ == T300.LGNUM` `VTTS.MANDT == T300.MANDT`
Departure point: Storage location in plant Departure point: Storage location in plant Client Plant at point of departure	`VTTS.LGORTA == T001L.LGORT` `VTTS.MANDT == T001L.MANDT` `VTTS.WERKA == T001L.WERKS`
Destination: Storage location in plant Destination: Storage location in plant Client Plant at destination point	`VTTS.LGORTZ == T001L.LGORT` `VTTS.MANDT == T001L.MANDT` `VTTS.WERKZ == T001L.WERKS`
Vendor number of departure point	`VTTS.MANDT == LFA1.MANDT` `VTTS.LIFNA == LFA1.LIFNR`
Vendor number of destination point	`VTTS.MANDT == LFA1.MANDT` `VTTS.LIFNZ == LFA1.LIFNR`
Point of departure: Loading point at shipping point Shipping point at point of departure Point of departure: Loading point at shipping point	`VTTS.MANDT == TVLA.MANDT` `VTTS.VSTEL == TVLA.VSTEL` `VTTS.LSTEL == TVLA.LSTEL`
Destination: Loading point at shipping point Shipping point at destination Destination: Loading point at shipping point	`VTTS.MANDT == TVLA.MANDT` `VTTS.VSTEZ == TVLA.VSTEL` `VTTS.LSTEZ == TVLA.LSTEL`
Client	`VTTS.MANDT == T000.MANDT`
Route for shipment stage	`VTTS.MANDT == TVRO.MANDT` `VTTS.ROUTE == TVRO.ROUTE`
Special Processing Indicator	`VTTS.MANDT == TVSAK.MANDT` `VTTS.SDABW == TVSAK.SDABW`
Pricing procedure in stage of shipment ? Pricing procedure in stage of shipment ?	`VTTS.MANDT == T683.MANDT` `VTTS.[column in domain "KAPPL"] == T683.KAPPL` `VTTS.SKALSM == T683.KALSM` `VTTS.[column in domain "KVEWE"] == T683.KVEWE`
Number of forwarding agent in the shipment stage	`VTTS.MANDT == LFA1.MANDT` `VTTS.TDLNR == LFA1.LIFNR`
Point of departure: Gate for warehouse number Point of departure: Gate for warehouse number Point of departure: Warehouse number	`VTTS.MANDT == T30B.MANDT` `VTTS.TORA == T30B.LGTOR` `VTTS.LGNUMA == T30B.LGNUM`
Destination. Gate for warehouse number Destination. Gate for warehouse number Destination: Warehouse number	`VTTS.MANDT == T30B.MANDT` `VTTS.TORZ == T30B.LGTOR` `VTTS.LGNUMZ == T30B.LGNUM`
Shipping type for shipment stage Shipping type for shipment stage Client	`VTTS.VSART == T173.VSART` `VTTS.MANDT == T173.MANDT`
Shipping point at point of departure	`VTTS.MANDT == TVST.MANDT` `VTTS.VSTEL == TVST.VSTEL`
Shipping point at destination	`VTTS.MANDT == TVST.MANDT` `VTTS.VSTEZ == TVST.VSTEL`
Plant at point of departure	`VTTS.MANDT == T001W.MANDT` `VTTS.WERKA == T001W.WERKS`
Plant at destination point	`VTTS.MANDT == T001W.MANDT` `VTTS.WERKZ == T001W.WERKS`