S090

WM: Stock placements/removals | #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
LGNUM FK Warehouse Number / Warehouse Complex
LGTYP FK Stor.type for stock removal, placement, return
LGBER FK Storage section for stock removal, placement, return
MATNR FK Material Number
WERKS FK Plant
BWLVS FK Movement Type for Warehouse Management
LETYP FK Storage Unit Type
MG_LAGKL FK Storage class
LGORT FK Storage location
Column Name Description
Column Name Description
📏 Base Unit of Measure (BASME):
TAAMG Stock Removal Quantity from TO Item
TAEMG Putaway quantity for TO item
TARMG Return placement quantity from TO item
EXAMG External removal quantity (GI interface)
EXEMG External stock placement quantity (GR interface)
📏 Weight Unit (GEWEI):
TAAGW Weight of stock removal
TAEGW Weight of stock placement item
TARGW Weight of return transfer
EXAGW Weight of external stock removal
EXEGW Weight of external stock placement
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
TAAPC Number of stock removals MCZAEHLER
TAEPC Number of stock placement items MCZAEHLER
TARPC Number of TO items with return placement MCZAEHLER
EXAPC Number of external stock removal items MCZAEHLER
EXEPC Number of external stock placement items MCZAEHLER
RGLAC Return to stock removal bin MCZAEHLER
Master Data Relations Join Conditions
Base Unit of Measure
  • S090.MANDT == T006.MANDT
  • S090.BASME == T006.MSEHI
Movement Type for Warehouse Management
  • Warehouse Number / Warehouse Complex
  • Movement Type for Warehouse Management
  • Client
  • S090.LGNUM == T333.LGNUM
  • S090.BWLVS == T333.BWLVS
  • S090.MANDT == T333.MANDT
Weight Unit
  • S090.MANDT == T006.MANDT
  • S090.GEWEI == T006.MSEHI
Storage Unit Type
  • Storage Unit Type
  • Warehouse Number / Warehouse Complex
  • S090.MANDT == T307.MANDT
  • S090.LETYP == T307.LETYP
  • S090.LGNUM == T307.LGNUM
Storage section for stock removal, placement, return
  • Storage section for stock removal, placement, return
  • Warehouse Number / Warehouse Complex
  • Stor.type for stock removal, placement, return
  • S090.MANDT == T302.MANDT
  • S090.LGBER == T302.LGBER
  • S090.LGNUM == T302.LGNUM
  • S090.LGTYP == T302.LGTYP
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • S090.LGNUM == T300.LGNUM
  • S090.MANDT == T300.MANDT
Storage location
  • Storage location
  • Client
  • Plant
  • S090.LGORT == T001L.LGORT
  • S090.MANDT == T001L.MANDT
  • S090.WERKS == T001L.WERKS
Stor.type for stock removal, placement, return
  • Warehouse Number / Warehouse Complex
  • Client
  • Stor.type for stock removal, placement, return
  • S090.LGNUM == T301.LGNUM
  • S090.MANDT == T301.MANDT
  • S090.LGTYP == T301.LGTYP
Client S090.MANDT == T000.MANDT
MC structure
  • Material Number
  • Client
  • S090.MATNR == MARA.MATNR
  • S090.MANDT == MARA.MANDT
Storage class
  • S090.MANDT == T646L.MANDT
  • S090.MG_LAGKL == T646L.LAGKL
MC structure
  • S090.MANDT == T001W.MANDT
  • S090.WERKS == T001W.WERKS