S033

Statistics: Movements for Current Stock (Individual Records) | #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
WERKS FK Plant
MATNR FK Material Number
LGORT FK Storage location
MBLNR Number of Material Document
Column Name Description
💲 Currency Key (HWAER):
WZUBB Valuated stock receipts value
WAGBB Value of valuated stock that has been issued
WGVBR Total usage value
WUVBR Unplanned usage value
Column Name Description
📏 Base Unit of Measure (BASME):
MZUBB Valuated stock receipts quantity
MZUKB Consignment stock receipts quantity
MAGBB Quantity of valuated stock issues
MAGKB Quantity of consignment stock that has been issued
MGVBR Total usage quantity
MUVBR Unplanned usage quantity
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
AZUBB Number of times that valuated stock has been received ANZAHL
AZUKB Number of times that consignment stock has been received ANZAHL
AAGBB Number of times valuated stock has been issued ANZAHL
AAGKB Number of times consignment stock has been issued ANZAHL
AMBWG Number of material movements ANZAHL
AGVBR Number of times that total usage has been updated ANZAHL
AUVBR Number of times an unplanned usage has been recorded ANZAHL
ASTOR Number of cancelation documents to date ANZAHL
BBNULL Number of times that valuated stock was zero ANZAHL
KBNULL Number of times that consignment stock was zero ANZAHL
GBNULL Number of times that total stock was zero ANZAHL
Master Data Relations Join Conditions
Base Unit of Measure
  • S033.MANDT == T006.MANDT
  • S033.BASME == T006.MSEHI
Currency Key
  • S033.MANDT == TCURC.MANDT
  • S033.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S033.LGORT == T001L.LGORT
  • S033.MANDT == T001L.MANDT
  • S033.WERKS == T001L.WERKS
Client S033.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S033.MATNR == MARA.MATNR
  • S033.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S033.PERIV == T009.PERIV
  • S033.MANDT == T009.MANDT
Plant
  • S033.MANDT == T001W.MANDT
  • S033.WERKS == T001W.WERKS