S005

SIS: Shipping Point/Route/Forwarding Agent/Receiving Country | #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
VSTEL FK Shipping Point / Receiving Point
ROUTE FK Route
SPDNR FK Forwarding Agent
LLAND FK Destination Country/Region
Column Name Description
Column Name Description
📏 Unit of weight for statistics (kg) (GEWEI):
NTGEW Net weight of deliveries
BRGEW Gross weight of deliveries
RLNTGEW Net weight of returns deliveries
RLBRGEW Gross weight of returns deliveries
📏 Volume unit for statistics (CDM) (VOLEH):
VOLUM Volume of deliveries
RLVOLUM Volume of returns delivery
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
ARBLA Labor Required for Deliveries on Hand DECV5_2
RLARBLA Labor required for returns deliveries on hand DECV5_2
Master Data Relations Join Conditions
Unit of weight for statistics (kg)
  • S005.MANDT == T006.MANDT
  • S005.GEWEI == T006.MSEHI
Destination Country/Region
  • Destination Country/Region
  • Client
  • S005.LLAND == T005.LAND1
  • S005.MANDT == T005.MANDT
Client S005.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S005.PERIV == T009.PERIV
  • S005.MANDT == T009.MANDT
Route
  • S005.MANDT == TVRO.MANDT
  • S005.ROUTE == TVRO.ROUTE
Forwarding Agent
  • S005.MANDT == LFA1.MANDT
  • S005.SPDNR == LFA1.LIFNR
Volume unit for statistics (CDM)
  • S005.MANDT == T006.MANDT
  • S005.VOLEH == T006.MSEHI
Shipping Point / Receiving Point
  • S005.MANDT == TVST.MANDT
  • S005.VSTEL == TVST.VSTEL