S279BIW1

S279BIW1 * BW Transfer: Inventory Management | #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
BSTTYP Stock categories in the Logistics Information System Show values
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
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 BW: Stock Characteristic Value 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
KDAUF Sales Order Number VBELN
KDPOS Item number in Sales Order NUM06
PS_POSID Work Breakdown Structure Element (WBS Element) PS_POSID
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • S279BIW1.AKTNR == WAKH.AKTNR
  • S279BIW1.MANDT == WAKH.MANDT
Base Unit of Measure
  • S279BIW1.MANDT == T006.MANDT
  • S279BIW1.BASME == T006.MSEHI
Movement type (inventory management)
  • S279BIW1.MANDT == T156.MANDT
  • S279BIW1.BWART == T156.BWART
Valuation Type
  • S279BIW1.MANDT == T149D.MANDT
  • S279BIW1.BWTAR == T149D.BWTAR
Batch Number
  • Material Number
  • Batch Number
  • Plant
  • S279BIW1.MANDT == MCHA.MANDT
  • S279BIW1.MATNR == MCHA.MATNR
  • S279BIW1.CHARG == MCHA.CHARG
  • S279BIW1.WERKS == MCHA.WERKS
Local Currency
  • S279BIW1.MANDT == TCURC.MANDT
  • S279BIW1.HWAER == TCURC.WAERS
Storage location
  • Storage location
  • Client
  • Plant
  • S279BIW1.LGORT == T001L.LGORT
  • S279BIW1.MANDT == T001L.MANDT
  • S279BIW1.WERKS == T001L.WERKS
Vendor's account number
  • S279BIW1.MANDT == LFA1.MANDT
  • S279BIW1.LIFNR == LFA1.LIFNR
Client S279BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S279BIW1.MATNR == MARA.MATNR
  • S279BIW1.MANDT == MARA.MANDT
Sold-to Party
  • S279BIW1.MANDT == KNA1.MANDT
  • S279BIW1.PKUNAG == KNA1.KUNNR
Receiving plant/issuing plant
  • S279BIW1.MANDT == T001W.MANDT
  • S279BIW1.UMWRK == T001W.WERKS
Plant
  • S279BIW1.MANDT == T001W.MANDT
  • S279BIW1.WERKS == T001W.WERKS