S271BIW1

Do not use! | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPTAG Period to analyze - current date
BWBELN Document number for Retail transfer structures
BELPOS Item number for Retail transfer structures
TRJAHR Transfer document year
BSTTYP Stock categories in the Logistics Information System Show values
BWVORG SAP BW transaction key
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 (S271.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 (S271.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
SHKZG Debit/Credit Indicator Show values
BSTAUS Stock Values in the Logistics Information System Show values
BRELEV RIS/Reporting Server - stock relevance Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
BIWANZ RIS/Reporting Server - Transfer number of activities MCZAEHLINT
GRUND Reason for goods movment NUMC4
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • S271BIW1.AKTNR == WAKH.AKTNR
  • S271BIW1.MANDT == WAKH.MANDT
Base Unit of Measure
  • S271BIW1.MANDT == T006.MANDT
  • S271BIW1.BASME == T006.MSEHI
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • S271BIW1.MANDT == MCHA.MANDT
  • S271BIW1.MATNR == MCHA.MATNR
  • S271BIW1.CHARG == MCHA.CHARG
  • S271BIW1.WERKS == MCHA.WERKS
Local Currency
  • S271BIW1.MANDT == TCURC.MANDT
  • S271BIW1.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S271BIW1.LGORT == T001L.LGORT
  • S271BIW1.MANDT == T001L.MANDT
  • S271BIW1.WERKS == T001L.WERKS
Vendor's account number
  • S271BIW1.MANDT == LFA1.MANDT
  • S271BIW1.LIFNR == LFA1.LIFNR
Client S271BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S271BIW1.MATNR == MARA.MATNR
  • S271BIW1.MANDT == MARA.MANDT
Sold-to Party
  • S271BIW1.MANDT == KNA1.MANDT
  • S271BIW1.PKUNAG == KNA1.KUNNR
Supplying (issuing) plant in case of stock transport order
  • S271BIW1.MANDT == T001W.MANDT
  • S271BIW1.RESWK == T001W.WERKS
Plant
  • S271BIW1.MANDT == T001W.MANDT
  • S271BIW1.WERKS == T001W.WERKS