S052

Means of transportation | #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
VHILM_VE FK LIS: Highest shipping element in transport
ROUTE FK Shipment route
Column Name Description
Column Name Description
📏 Weight unit for statistics update (STAGEW):
BRGEW_VE LIS: Gross weight of all main shipping units in shipment
NTGEW_VE LIS: Net weight of all main shipping units in shipment
TARAG_VE LIS: Tare weight of all main shipping units in shipment
MAGEW_VE LIS: Max. freight weight of all main shipping units in shpmt
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):
BRVOL_VE LIS: Gross volume of all main shipping units in shipment
NTVOL_VE LIS: Net volume of all main shipping units in shipment
TAVOL_VE LIS: Tare volume of all main shipping units in shipment
MAVOL_VE LIS: Max. freight volume of all main shipping units in shpmt
VOLUMK TIS: sum of the delivery volumes in a shipment
📏 Distance unit for statistics update (STADIS):
DISTZK TIS: Sum of distances in the 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
ANZHV TIS: Number of main shipping units in the shipment MCZAEHLER
ANZTP TIS: No. of shipments MCZAEHLER
ANZTPLF TIS: Number of deliveries in the shipment MCZAEHLER
PRGEW_TOT Total weight utilization as a percentage DEC_10
PRVOL_TOT Utilization percentage: volume 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
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
TPAVGTPA Average actual shipment duration TDURAMIN
TPAVGTPP Average planned shipment duration TDURAMIN
TPAVGTPU Average time the planned shipment time was exceeded TDURAMIN
AUSLG_VE Utilization percentage: Weight DEC3
AUSLV_VE Utilization percentage: volume DEC3
Master Data Relations Join Conditions
Client S052.MANDT == T000.MANDT
Shipment route
  • S052.MANDT == TVRO.MANDT
  • S052.ROUTE == TVRO.ROUTE
Shipment type
  • S052.MANDT == TVTK.MANDT
  • S052.SHTYP == TVTK.SHTYP
Distance unit for statistics update
  • S052.MANDT == T006.MANDT
  • S052.STADIS == T006.MSEHI
Weight unit for statistics update
  • S052.MANDT == T006.MANDT
  • S052.STAGEW == T006.MSEHI
Volume unit for statistics update
  • S052.MANDT == T006.MANDT
  • S052.STAVOL == T006.MSEHI
Transportation planning point
  • Transportation planning point
  • Client
  • S052.TPLST == TTDS.TPLST
  • S052.MANDT == TTDS.MANDT
LIS: Highest shipping element in transport
  • LIS: Highest shipping element in transport
  • Client
  • S052.VHILM_VE == MARA.MATNR
  • S052.MANDT == MARA.MANDT