S050

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
ALAND FK Country or Region: shipment start
AZONE FK Zone: shipment start
LLAND FK Country or Region: shipment end
LZONE FK Zone: shipment end
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
BRGEW_VE LIS: Gross weight of all main shipping units in shipment
NTGEW_VE LIS: Net weight of all main shipping units in shipment
MAGEW_VE LIS: Max. freight weight of all main shipping units in shpmt
📏 Volume unit for statistics update (STAVOL):
VOLUMK TIS: sum of the delivery volumes in a shipment
NTVOL_VE LIS: Net volume of all main shipping units in shipment
MAVOL_VE LIS: Max. freight volume of all main shipping units in shpmt
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
ANZTP TIS: No. of shipments MCZAEHLER
ANZTS TIS: Number of shipment stages MCZAEHLER
ANZHV TIS: Number of main shipping units in the shipment MCZAEHLER
ANZTPLF TIS: Number of deliveries in the shipment MCZAEHLER
ANZPKK TIS: Number of packages MCZAEHLER
PRVOL_TOT Utilization percentage: volume DEC_10
PRGEW_TOT Total weight utilization as a percentage DEC_10
DURLP TIS: planned shipment loading time TDURAMIN
DURLA TIS: actual shipment loading time TDURAMIN
LATEL TIS: Amount of time the planned loading time was exceeded TDURAMIN
DURTP TIS: planned shipment duration TDURAMIN
DURTA TIS: actual shipment duration TDURAMIN
LATET TIS: Amount of time the planned shipment time was exceeded TDURAMIN
LATER TIS: Check-in delay (planned - actual) TDURAMIN
LATEB TIS: Loading start delay (planned - actual) 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
TPAVGLDV Average delay of loading begin (planning - actual) TDURAMIN
TPAVGLDA Average actual loading time for a shipment TDURAMIN
TPAVGLDP Average planned loading time for a shipment TDURAMIN
TPAVGLDU Average time the planned shipment loading time was exceeded TDURAMIN
TPAVGRGV Average delay of check-in (planning - actual) TDURAMIN
TPAVGTPV Average time shipment begin was delayed (planned - actual) TDURAMIN
TPAVGTPZ Average delay of the shipment end (planned - actual) TDURAMIN
TPAVGTPA Average actual shipment duration TDURAMIN
TPAVGTPP Average planned shipment duration TDURAMIN
TPAVGTPU Average time the planned shipment time was exceeded TDURAMIN
TPAVGGESP Average planned total duration in minutes TDURAMIN
TPAVGGES Average total duration in minutes TDURAMIN
TPAVGFAHP Average planned travel time (in minutes) TDURAMIN
TPAVGFAH Average transit time in real travel time (minutes) TDURAMIN
AUSLG_VE Utilization percentage: Weight DEC3
AUSLV_VE Utilization percentage: volume DEC3
Master Data Relations Join Conditions
Country or Region: shipment start
  • Country or Region: shipment start
  • Client
  • S050.ALAND == T005.LAND1
  • S050.MANDT == T005.MANDT
Zone: shipment start
  • Country or Region: shipment end
  • Client
  • Zone: shipment start
  • S050.LLAND == TZONE.LAND1
  • S050.MANDT == TZONE.MANDT
  • S050.AZONE == TZONE.ZONE1
Country or Region: shipment end
  • Country or Region: shipment end
  • Client
  • S050.LLAND == T005.LAND1
  • S050.MANDT == T005.MANDT
Zone: shipment end
  • Country or Region: shipment end
  • Client
  • Zone: shipment end
  • S050.LLAND == TZONE.LAND1
  • S050.MANDT == TZONE.MANDT
  • S050.LZONE == TZONE.ZONE1
Client S050.MANDT == T000.MANDT
Shipment type
  • S050.MANDT == TVTK.MANDT
  • S050.SHTYP == TVTK.SHTYP
Distance unit for statistics update
  • S050.MANDT == T006.MANDT
  • S050.STADIS == T006.MSEHI
Weight unit for statistics update
  • S050.MANDT == T006.MANDT
  • S050.STAGEW == T006.MSEHI
Volume unit for statistics update
  • S050.MANDT == T006.MANDT
  • S050.STAVOL == T006.MSEHI
Number of forwarding agent
  • S050.MANDT == LFA1.MANDT
  • S050.TDLNR == LFA1.LIFNR
Transportation planning point
  • Transportation planning point
  • Client
  • S050.TPLST == TTDS.TPLST
  • S050.MANDT == TTDS.MANDT