S277BIW1

S277BIW1 * Transfer to BW: Revaluation at Retail | #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
BWBELN BW: Document Number
BWBLPOS BW: Document Item Number
BWBJAHR BW: Document Year
BWVORG BW: Transaction Key SAP BW
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
📏 Sales unit (VRKME):
BWMVE BW: Quantity in Sales Unit
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
SHKZG Debit/Credit Indicator Show values
SPANN Flag: not affecting margins Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
BWANZ BW: Number of Transactions MCZAEHLINT
GRUND Reason for goods movment NUMC4
BWBREL BW: Stock Relevance MCBW_BREL
BWAPPLNM Application Component RSAPPLNM
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • S277BIW1.AKTNR == WAKH.AKTNR
  • S277BIW1.MANDT == WAKH.MANDT
Base Unit of Measure
  • S277BIW1.MANDT == T006.MANDT
  • S277BIW1.BASME == T006.MSEHI
Local Currency
  • S277BIW1.MANDT == TCURC.MANDT
  • S277BIW1.HWAER == TCURC.WAERS
Client S277BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S277BIW1.MATNR == MARA.MATNR
  • S277BIW1.MANDT == MARA.MANDT
Sales unit
  • S277BIW1.MANDT == T006.MANDT
  • S277BIW1.VRKME == T006.MSEHI
Plant
  • S277BIW1.MANDT == T001W.MANDT
  • S277BIW1.WERKS == T001W.WERKS