S054

Stages of shipment | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
TPLST FK Transportation planning point
SHTYP FK Shipment type
TDLNR FK Number of forwarding agent in the shipment stage
LAND1A FK Country key for point of departure
LZONEA FK Transportation zone to or from which the goods are delivered
LAND1Z FK Country key
LZONEZ FK Transportation zone to or from which the goods are delivered
Column Name Description
Column Name Description
📏 Distance unit for statistics update (STADIS):
DISTZK TIS: Sum of distances in the shipment
📏 Weight unit for statistics update (STAGEW):
BRGEWK TIS: Sum of the delivery gross weights in shipment
NTGEWK TIS: sum of the delivery net weights in the shipment
📏 Volume unit for statistics update (STAVOL):
VOLUMK TIS: sum of the delivery volumes in a shipment
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
ANZTS TIS: Number of shipment stages MCZAEHLER
ANZTPLF TIS: Number of deliveries in the shipment MCZAEHLER
ANZPKK TIS: Number of packages MCZAEHLER
DURTP TIS: planned shipment duration TDURAMIN
DURTA TIS: actual shipment duration TDURAMIN
LATET TIS: Amount of time the planned shipment time was exceeded TDURAMIN
LATES TIS: amount of time shipment start was delayed (planned-act) TDURAMIN
LATEE TIS: delay of the actual shipment end (planned - actual) TDURAMIN
DURFAHP Planned travel time in minutes TDURAMIN
DURFAH Travel duration in real travel time (minutes) TDURAMIN
DURGESP Planned total duration in minutes TDURAMIN
DURGES Total duration in minutes TDURAMIN
TPAVGTPP Average planned shipment duration TDURAMIN
TPAVGTPA Average actual shipment duration TDURAMIN
TPAVGTPU Average time the planned shipment time was exceeded TDURAMIN
TPAVGTPV Average time shipment begin was delayed (planned - actual) TDURAMIN
TPAVGTPZ Average delay of the shipment end (planned - actual) TDURAMIN
TPAVGFAHP Average planned travel time (in minutes) TDURAMIN
TPAVGFAH Average transit time in real travel time (minutes) TDURAMIN
TPAVGGESP Average planned total duration in minutes TDURAMIN
TPAVGGES Average total duration in minutes TDURAMIN
Master Data Relations Join Conditions
Country key for point of departure
  • Country key for point of departure
  • Client
  • S054.LAND1A == T005.LAND1
  • S054.MANDT == T005.MANDT
Country key
  • Country key
  • Client
  • S054.LAND1Z == T005.LAND1
  • S054.MANDT == T005.MANDT
Transportation zone to or from which the goods are delivered
  • Country key
  • Client
  • Transportation zone to or from which the goods are delivered
  • S054.LAND1Z == TZONE.LAND1
  • S054.MANDT == TZONE.MANDT
  • S054.LZONEA == TZONE.ZONE1
Transportation zone to or from which the goods are delivered
  • Country key
  • Client
  • Transportation zone to or from which the goods are delivered
  • S054.LAND1Z == TZONE.LAND1
  • S054.MANDT == TZONE.MANDT
  • S054.LZONEZ == TZONE.ZONE1
Client S054.MANDT == T000.MANDT
Shipment type
  • S054.MANDT == TVTK.MANDT
  • S054.SHTYP == TVTK.SHTYP
Distance unit for statistics update
  • S054.MANDT == T006.MANDT
  • S054.STADIS == T006.MSEHI
Weight unit for statistics update
  • S054.MANDT == T006.MANDT
  • S054.STAGEW == T006.MSEHI
Volume unit for statistics update
  • S054.MANDT == T006.MANDT
  • S054.STAVOL == T006.MSEHI
Number of forwarding agent in the shipment stage
  • S054.MANDT == LFA1.MANDT
  • S054.TDLNR == LFA1.LIFNR
Transportation planning point
  • Transportation planning point
  • Client
  • S054.TPLST == TTDS.TPLST
  • S054.MANDT == TTDS.MANDT