S275BIW2

S275BIW2 * Transfer to BW: Purchasing Data | #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
BWEINT FK BW: Document Schedule
BWVORG BW: Transaction Key SAP BW
BWSUPKZ Auxiliary statistics update indicator Show values
ERZET Entry time
Column Name Description
💲 Purchase order currency (BSTWA):
BRTWR Gross order value in order currency
DBWGEO Delta purchase order/goods receipt at cost
KZWI1 Subtotal 1 from Pricing Procedure for Price Element
KZWI2 Subtotal 2 from Pricing Procedure for Price Element
KZWI3 Subtotal 3 from Pricing Procedure for Price Element
KZWI4 Subtotal 4 from Pricing Procedure for Price Element
KZWI5 Subtotal 5 from Pricing Procedure for Price Element
KZWI6 Subtotal 6 from Pricing Procedure for Price Element
BWGEOO BW: Cost Value in Order Currency
💲 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
📏 Purchase Order Unit of Measure (BSTME):
BWMBE BW: Quantity in Order Unit
BWDMBE BW: Delta Purchase Order/GR in Order Unit
Column Name Description
SPTAG Period to analyze - current date
ERZET Entry time
BEDAT Purchasing Document Date
BUDAT Posting date of goods received or invoice receipt for order
Column Name Description
BWSUPKZ Auxiliary statistics update indicator Show values
BWBLTYP BW: Document Category Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
BWANZ BW: Number of Transactions MCZAEHLINT
BWAPPLNM Application Component RSAPPLNM
BSGRU Reason for Ordering BSGRU
KURSK Exchange Rate for Price Determination KURRF
BPUMZ Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
BPUMN Denominator for Conv. of Order Price Unit into Order Unit UMBSN
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • S275BIW2.AKTNR == WAKH.AKTNR
  • S275BIW2.MANDT == WAKH.MANDT
Purchase Order Unit of Measure
  • S275BIW2.MANDT == T006.MANDT
  • S275BIW2.BSTME == T006.MSEHI
Purchase order currency
  • S275BIW2.MANDT == TCURC.MANDT
  • S275BIW2.BSTWA == TCURC.WAERS
BW: Document Type
  • S275BIW2.MANDT == TVAK.MANDT
  • S275BIW2.BWBLART == TVAK.AUART
BW: Material Group from Document
  • S275BIW2.MANDT == T023.MANDT
  • S275BIW2.BWMATKL == T023.MATKL
Purchasing Group
  • Purchasing Group
  • Client
  • S275BIW2.EKGRP == T024.EKGRP
  • S275BIW2.MANDT == T024.MANDT
Purchasing organization
  • S275BIW2.MANDT == T024E.MANDT
  • S275BIW2.EKORG == T024E.EKORG
Local Currency
  • S275BIW2.MANDT == TCURC.MANDT
  • S275BIW2.HWAER == TCURC.WAERS
Vendor's account number
  • S275BIW2.MANDT == LFA1.MANDT
  • S275BIW2.LIFNR == LFA1.LIFNR
Client S275BIW2.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S275BIW2.MATNR == MARA.MATNR
  • S275BIW2.MANDT == MARA.MANDT
Base Unit of Measure
  • S275BIW2.MANDT == T006.MANDT
  • S275BIW2.MEINS == T006.MSEHI
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • S275BIW2.PSTYP == T163.PSTYP
  • S275BIW2.MANDT == T163.MANDT
Supplying (issuing) plant in case of stock transport order
  • S275BIW2.MANDT == T001W.MANDT
  • S275BIW2.RESWK == T001W.WERKS
Plant
  • S275BIW2.MANDT == T001W.MANDT
  • S275BIW2.WERKS == T001W.WERKS