S195BIW1

S195BIW1 * Goods Movement: Storage Location | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPMON Period to analyze - month
MATNR FK Material Number
WERKS FK Plant
LGORT FK Storage location
VRSIO Version number in the information structure
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
Column Name Description
📏 Base Unit of Measure (S195.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
PERIV Fiscal Year Variant PERIV
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
AGVBR Number of times that total usage has been updated ANZAHL
AUVBR Number of times an unplanned usage has been recorded ANZAHL
AMBWG Number of material movements ANZAHL
ASTOR Number of cancelation documents to date ANZAHL
Master Data Relations Join Conditions
Base Unit of Measure
  • S195BIW1.MANDT == T006.MANDT
  • S195BIW1.BASME == T006.MSEHI
Storage location
  • Storage location
  • Client
  • Plant
  • S195BIW1.LGORT == T001L.LGORT
  • S195BIW1.MANDT == T001L.MANDT
  • S195BIW1.WERKS == T001L.WERKS
Client S195BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S195BIW1.MATNR == MARA.MATNR
  • S195BIW1.MANDT == MARA.MANDT
Plant
  • S195BIW1.MANDT == T001W.MANDT
  • S195BIW1.WERKS == T001W.WERKS