S274BIW2

Do not use! | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPTAG Period to analyze - current date
WERKS FK Plant
MATNR FK Material Number
BSTTYP Stock categories in the Logistics Information System Show values
BSTAUS Stock Values in the Logistics Information System Show values
SHKZG Debit/Credit Indicator Show values
LIFNR FK Vendor's account number
PKUNAG FK Sold-to Party
LGORT FK Storage location
CHARG FK Batch Number
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
💲 Local Currency (S274.HWAER):
BIWGEO RIS/Reporting Server - Transfer cost price
BIWGVO RIS/Reporting Server - Transfer retail price
BIWGVP RIS/Reporting Server - Transfer retail price with tax
Column Name Description
📏 Base Unit of Measure (S274.BASME):
BIWMNG RIS/Reporting Server - Transfer base quantity
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
BSTTYP Stock categories in the Logistics Information System Show values
BSTAUS Stock Values in the Logistics Information System Show values
SHKZG Debit/Credit Indicator Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Base Unit of Measure
  • S274BIW2.MANDT == T006.MANDT
  • S274BIW2.BASME == T006.MSEHI
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • S274BIW2.MANDT == MCHA.MANDT
  • S274BIW2.MATNR == MCHA.MATNR
  • S274BIW2.CHARG == MCHA.CHARG
  • S274BIW2.WERKS == MCHA.WERKS
Local Currency
  • S274BIW2.MANDT == TCURC.MANDT
  • S274BIW2.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S274BIW2.LGORT == T001L.LGORT
  • S274BIW2.MANDT == T001L.MANDT
  • S274BIW2.WERKS == T001L.WERKS
Vendor's account number
  • S274BIW2.MANDT == LFA1.MANDT
  • S274BIW2.LIFNR == LFA1.LIFNR
Client S274BIW2.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S274BIW2.MATNR == MARA.MATNR
  • S274BIW2.MANDT == MARA.MANDT
Sold-to Party
  • S274BIW2.MANDT == KNA1.MANDT
  • S274BIW2.PKUNAG == KNA1.KUNNR
Plant
  • S274BIW2.MANDT == T001W.MANDT
  • S274BIW2.WERKS == T001W.WERKS