TVRO

Routes | #masterdata | Component: Transportation
Column Name Description
MANDT FK Client
ROUTE Route
Column Name Description
Column Name Description
📏 Distance Unit of Measure (MEDST):
DISTZ Distance
📏 Unit of Measurement for Allowed Total Weight of Shipment (ALLOWED_UOM):
ALLOWED_TWGT Allowed total weight of shipment
Column Name Description
Column Name Description
TDIIX Relevance for transportation ID Show values
TCTAB Take Table for Transit Cntrs/Regs into Account Show values
Column Name Description Domain name
TRAZT Outdated: Transit Time from GI to Ship-to Party (in Days) DIFZT
TRAZTD Transit Duration in Calendar Days TSTRDURAG
TDVZT Outdated: Transportation-Planning Lead Time (in Days) DIFZT
TDVZTD Transportation Lead Time in Calendar Days TSTRDURAG
TDVZND Transportation Lead Time in Hours/Minutes Work Time TSTRDURAN
FAHZTD Travel Duration as Actual Time (Hours/Minutes) TSTRDURAN
ROUTID Route Identification CHAR100
Master Data Relations Join Conditions
Mode of Transport at the Border (Intrastat)
  • ?
  • Mode of Transport at the Border (Intrastat)
  • TVRO.MANDT == T618.MANDT
  • TVRO.[column in domain "/ECRS/RPCTY"] == T618.LAND1
  • TVRO.EXPVZ == T618.EXPVZ
Client TVRO.MANDT == T000.MANDT
Factory calendar key TVRO.SPFBK == TFACD.IDENT
Number of forwarding agent
  • TVRO.MANDT == LFA1.MANDT
  • TVRO.TDLNR == LFA1.LIFNR
Shipping Type of Subsequent Leg
  • Shipping Type of Subsequent Leg
  • Client
  • TVRO.VSANL == T173.VSART
  • TVRO.MANDT == T173.MANDT
Shipping Type
  • Shipping Type
  • Client
  • TVRO.VSART == T173.VSART
  • TVRO.MANDT == T173.MANDT
Shipping Type of Preliminary Leg
  • Shipping Type of Preliminary Leg
  • Client
  • TVRO.VSAVL == T173.VSART
  • TVRO.MANDT == T173.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Working time from sales view
  • ?
  • Factory calendar key
  • Working time from sales view
  • TVRO.MANDT == TTSTRSD.MANDT
  • TVRO.[column in domain "TSTRTYPE"] == TTSTRSD.TSTRTYPE
  • TVRO.SPFBK == TTSTRSD.CALENDARID
  • TVRO.SPZST == TTSTRSD.TSTREAMID