S050E

S050 - Structural Information | #masterdata | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
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
Column Name Description
Column Name Description
Column Name Description Domain name
USTADIS Conversion factor: quantities FLTP
USTAGEW Conversion factor: quantities FLTP
USTAVOL Conversion factor: quantities FLTP
PLOBJ Planning object CHAR18
PERKZ Period indicator PERVR
PLTKZ Indicator: element used in planning CHAR01
ANTEI Proportional factor (%) for disaggregation of product group FLTP
Master Data Relations Join Conditions
Country or Region: shipment start
  • Country or Region: shipment start
  • Client
  • S050E.ALAND == T005.LAND1
  • S050E.MANDT == T005.MANDT
Zone: shipment start
  • Country or Region: shipment end
  • Client
  • Zone: shipment start
  • S050E.LLAND == TZONE.LAND1
  • S050E.MANDT == TZONE.MANDT
  • S050E.AZONE == TZONE.ZONE1
Country or Region: shipment end
  • Country or Region: shipment end
  • Client
  • S050E.LLAND == T005.LAND1
  • S050E.MANDT == T005.MANDT
Zone: shipment end
  • Country or Region: shipment end
  • Client
  • Zone: shipment end
  • S050E.LLAND == TZONE.LAND1
  • S050E.MANDT == TZONE.MANDT
  • S050E.LZONE == TZONE.ZONE1
Client S050E.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S050E.PERIV == T009.PERIV
  • S050E.MANDT == T009.MANDT
Shipment type
  • S050E.MANDT == TVTK.MANDT
  • S050E.SHTYP == TVTK.SHTYP
Distance unit for statistics update
  • S050E.MANDT == T006.MANDT
  • S050E.STADIS == T006.MSEHI
Weight unit for statistics update
  • S050E.MANDT == T006.MANDT
  • S050E.STAGEW == T006.MSEHI
Volume unit for statistics update
  • S050E.MANDT == T006.MANDT
  • S050E.STAVOL == T006.MSEHI
Number of forwarding agent
  • S050E.MANDT == LFA1.MANDT
  • S050E.TDLNR == LFA1.LIFNR
Transportation planning point
  • Transportation planning point
  • Client
  • S050E.TPLST == TTDS.TPLST
  • S050E.MANDT == TTDS.MANDT