S278BIW1

S278BIW1 * Transfer to BW: Stock | #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
BSTTYP Stock categories in the Logistics Information System Show values
BSTAUS BW: Stock Characteristic Value Show values
LGORT FK Storage location
CHARG FK Batch Number
BWTAR FK Valuation Type
BWKULIF FK Customer/Supplier
BWKAPRN Sales Order/ Project Number
Column Name Description
💲 Local Currency (HWAER):
BWGEO BW: Cost Value in Local Currency
BWGVO BW: Retail Value in Local Currency
BWGVP BW: Retail Value with Tax in Local Currency
Column Name Description
📏 Base Unit of Measure (BASME):
BWMNG BW: Quantity in Base Unit of Measure
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
BSTTYP Stock categories in the Logistics Information System Show values
BSTAUS BW: Stock Characteristic Value Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
BWAPPLNM Application Component RSAPPLNM
Master Data Relations Join Conditions
Base Unit of Measure
  • S278BIW1.MANDT == T006.MANDT
  • S278BIW1.BASME == T006.MSEHI
Customer/Supplier
  • S278BIW1.MANDT == KNA1.MANDT
  • S278BIW1.BWKULIF == KNA1.KUNNR
Valuation Type
  • S278BIW1.MANDT == T149D.MANDT
  • S278BIW1.BWTAR == T149D.BWTAR
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • S278BIW1.MANDT == MCHA.MANDT
  • S278BIW1.MATNR == MCHA.MATNR
  • S278BIW1.CHARG == MCHA.CHARG
  • S278BIW1.WERKS == MCHA.WERKS
Local Currency
  • S278BIW1.MANDT == TCURC.MANDT
  • S278BIW1.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S278BIW1.LGORT == T001L.LGORT
  • S278BIW1.MANDT == T001L.MANDT
  • S278BIW1.WERKS == T001L.WERKS
Client S278BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S278BIW1.MATNR == MARA.MATNR
  • S278BIW1.MANDT == MARA.MANDT
Plant
  • S278BIW1.MANDT == T001W.MANDT
  • S278BIW1.WERKS == T001W.WERKS