S039

Statistics: Inventory Controlling | #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
DISPO FK MRP Controller
DISMM FK MRP Type
MTART FK Material type
MATKL FK Material Group
GSBER FK Business Area
SPART FK Division
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
WBWBEST Value of valuated stock
DZWBB Average valuated stock receipts value
DAWBB Average valuated stock issues value
DWBWBEST Average valuated stock value
DWGVBR Value of average total usage
DWUVBR Average unplanned usage value
WBESZUG Value of stock at goods receipt
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
MBWBEST Quantity of valuated stock
MKOBEST Quantity of consignment stock
DZUBB Average valuated stock receipts quantity
DAGBB Average quantity of valuated stock issues
DZUKB Average consignment stock receipts quantity
DAGKB Average quantity of consignment stock that has been issued
DGVBR Average consumption
GSBEST Total stock
DBWBEST Average quantity of valuated stock
DKOBEST Average quantity of consignment stock
DGSBEST Average quantity of total stock
DUVBR Average unplanned usage quantity
EISBE Safety stock
BESZUG Stock level at goods receipt
Column Name Description
SPTAG Period to analyze - current date
LETZTZUG Date: Last Receipt
LETZTABG Date: last (i.e. most recent) goods issue
LETZTVER Date: last (i.e. most recent) consumption
LETZTBEW Date: last (i.e. most recent) goods movement
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
RWGSBEST Range of coverage of total stock BCSP4
RWKOBEST Range of coverage of consignment stock BCSP4
RWBEWBEST Range of coverage of valuated stock BCSP4
UHGSBEST Turnover of total stock BCSP4
UHBWBEST Turnover of valuated stock BCSP4
UHKOBEST Turnover of consignment stock BCSP4
DRWBWBEST Average range of coverage of valuated stock BCSP4
DRWKOBEST Average range of coverage of consignment stock BCSP4
DRWGSBEST Average range of coverage of total stock BCSP4
DUHBWBEST Average inventory turnover of valuated stock BCSP4
DUHKOBEST Average turnover of consignment stock BCSP4
DUHGSBEST Average turnover of total stock BCSP4
UHWBWBEST Inventory turnover (value-based) of valuated stock BCSP4
UHWGSBEST Inventory turnover (value-based) of total stock BCSP4
DUHWGSBEST Average turnover (value-based) of total stock BCSP4
DUHWBWBEST Average turnover (value-based) of valuated stock BCSP4
JUHWGSBEST Annual inventory turnover (value-based) of total stock BCSP4
JUHWBWBEST Annual inventory turnover (value-based) of valuated stock BCSP4
JUHGSBEST Annual inventory turnover (quantity-based) of total stock BCSP4
JUHKOBEST Annual turnover (quantity-based) of consignment stock BCSP4
JUHBWBEST Annual inventory turnover of valuated stock BCSP4
RWWGSBEST Range of coverage (value-based) of total stock BCSP4
RWWBWBEST Range of coverage (value-based) of valuated stock BCSP4
DRWWGSBEST Average range of coverage (value-based) of total stock BCSP4
DRWWBWBEST Average range of coverage (value-based) of valuated stock BCSP4
BKLAS Valuation Class BKLAS
Master Data Relations Join Conditions
Base Unit of Measure
  • S039.MANDT == T006.MANDT
  • S039.BASME == T006.MSEHI
MRP Type
  • S039.MANDT == T438A.MANDT
  • S039.DISMM == T438A.DISMM
MRP Controller
  • Plant
  • MRP Controller
  • Client
  • S039.WERKS == T024D.WERKS
  • S039.DISPO == T024D.DISPO
  • S039.MANDT == T024D.MANDT
Business Area
  • S039.MANDT == TGSB.MANDT
  • S039.GSBER == TGSB.GSBER
Currency Key
  • S039.MANDT == TCURC.MANDT
  • S039.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S039.LGORT == T001L.LGORT
  • S039.MANDT == T001L.MANDT
  • S039.WERKS == T001L.WERKS
Client S039.MANDT == T000.MANDT
Material Group
  • S039.MANDT == T023.MANDT
  • S039.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S039.MATNR == MARA.MATNR
  • S039.MANDT == MARA.MANDT
Material type
  • S039.MANDT == T134.MANDT
  • S039.MTART == T134.MTART
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S039.PERIV == T009.PERIV
  • S039.MANDT == T009.MANDT
Division
  • S039.MANDT == TSPA.MANDT
  • S039.SPART == TSPA.SPART
Plant
  • S039.MANDT == T001W.MANDT
  • S039.WERKS == T001W.WERKS