S005BIW1

S005BIW1 * SIS: Ship.Pnt/Route/Forw.Agent/Recipient Country | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPBUP Period to analyze - posting period
VSTEL FK Shipping Point / Receiving Point
ROUTE FK Route
SPDNR FK Forwarding Agent
LLAND FK Destination Country/Region
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SSOUR Statistic(s) origin
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)
  • S005BIW1.MANDT == T006.MANDT
  • S005BIW1.GEWEI == T006.MSEHI
Destination Country/Region
  • Destination Country/Region
  • Client
  • S005BIW1.LLAND == T005.LAND1
  • S005BIW1.MANDT == T005.MANDT
Client S005BIW1.MANDT == T000.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S005BIW1.PERIV == T009.PERIV
  • S005BIW1.MANDT == T009.MANDT
Route
  • S005BIW1.MANDT == TVRO.MANDT
  • S005BIW1.ROUTE == TVRO.ROUTE
Forwarding Agent
  • S005BIW1.MANDT == LFA1.MANDT
  • S005BIW1.SPDNR == LFA1.LIFNR
Volume unit for statistics (CDM)
  • S005BIW1.MANDT == T006.MANDT
  • S005BIW1.VOLEH == T006.MSEHI
Shipping Point / Receiving Point
  • S005BIW1.MANDT == TVST.MANDT
  • S005BIW1.VSTEL == TVST.VSTEL