S194BIW1

S194BIW1 * MRP: Business Info Warehouse | #other | Component: Data Collection
Column Name Description
MANDT FK Client
SPWOC Period to analyze - week
MATNR FK Material Number
WERKS FK Plant
DISPO FK MRP Controller
DISMM FK MRP Type
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
💲 Local Currency (HWAER):
WABGA Future value of goods issues that is valid for MRP
WGABGA Value of total goods issues quantity
WZUGA Future value of goods receipts that is valid for MRP
WGZUGA Total value of goods receipts quantity
WATP_KUM Value of cummulated ATP quantity
WATP Value of ATP quantity
WBEST Value of future stock (MRP)
WBESZUG Value of stock at goods receipt
WGSBEST Value of Future Total Stock
WEISB Value of the safety stock
Column Name Description
📏 Base Unit of Measure (BASME):
MABGA Future qty. of goods issues that is valid for MRP
GABGA Total quantity of future goods issues
MNG02 Requirement
MNG01 Planned independent requirements
MZUGA Future quantity of goods receipts that is valid for MRP
GZUGA Total future goods receipts
MNG06 Sum of receipts that are not available
MATP Cumulated ATP quantity
MNG05 ATP quantity
MBEST Future stock (disposition)
BESZUG Stock level at goods receipt
GSBEST Total stock
EISBE Safety stock
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
AZZUG Number of receipts per period NUMC5
Master Data Relations Join Conditions
Base Unit of Measure
  • S194BIW1.MANDT == T006.MANDT
  • S194BIW1.BASME == T006.MSEHI
MRP Type
  • S194BIW1.MANDT == T438A.MANDT
  • S194BIW1.DISMM == T438A.DISMM
MRP Controller
  • Plant
  • MRP Controller
  • Client
  • S194BIW1.WERKS == T024D.WERKS
  • S194BIW1.DISPO == T024D.DISPO
  • S194BIW1.MANDT == T024D.MANDT
Local Currency
  • S194BIW1.MANDT == TCURC.MANDT
  • S194BIW1.HWAER == TCURC.WAERS
Client S194BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S194BIW1.MATNR == MARA.MATNR
  • S194BIW1.MANDT == MARA.MANDT
Plant
  • S194BIW1.MANDT == T001W.MANDT
  • S194BIW1.WERKS == T001W.WERKS