S270

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
BWEINT FK Schedule line number for Retail transfer
BWVORG SAP BW transaction key
SUPKZ Statistics update indicator (post in/post out) Show values
ERZET Entry time
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 (HWAER):
BIWGEO RIS/Reporting Server - Transfer cost price
BIWGVO RIS/Reporting Server - Transfer retail price
BIWGVP RIS/Reporting Server - Transfer retail price with tax
DBWGEO Delta purchase order/goods receipt at cost
DBWGVO Delta purchase order/goods receipt at retail
DBWGVP Delta purchase order/goods receipt at retail with tax
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
💲 Purchase order currency (BSTWA):
BRTWR Gross order value in order currency
NETWR Net order value in order currency
Column Name Description
📏 Base Unit of Measure (BASME):
BIWMNG RIS/Reporting Server - Transfer base quantity
DBWMNG Delta purchase order/goods receipt quantity in BUn
📏 Purchase Order Unit of Measure (BSTME):
BIWMBE RIS/Reporting Server - Transfer purchase order quantity
DBWMBE Delta purchase order/GR in PO qty
Column Name Description
SPTAG Period to analyze - current date
ERZET Entry time
BEDAT Document date
Column Name Description
SUPKZ Statistics update indicator (post in/post out) Show values
BWBELT Type of transfer document Show values
RETPO Returns Item 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
Master Data Relations Join Conditions
Promotion
  • Promotion
  • Client
  • S270.AKTNR == WAKH.AKTNR
  • S270.MANDT == WAKH.MANDT
Base Unit of Measure
  • S270.MANDT == T006.MANDT
  • S270.BASME == T006.MSEHI
Purchase Order Unit of Measure
  • S270.MANDT == T006.MANDT
  • S270.BSTME == T006.MSEHI
Purchase order currency
  • S270.MANDT == TCURC.MANDT
  • S270.BSTWA == TCURC.WAERS
Transfer document type
  • S270.MANDT == TVAK.MANDT
  • S270.BWBELA == TVAK.AUART
Purchasing Group
  • Purchasing Group
  • Client
  • S270.EKGRP == T024.EKGRP
  • S270.MANDT == T024.MANDT
Purchasing organization
  • S270.MANDT == T024E.MANDT
  • S270.EKORG == T024E.EKORG
Local Currency
  • S270.MANDT == TCURC.MANDT
  • S270.HWAER == TCURC.WAERS
Vendor's account number
  • S270.MANDT == LFA1.MANDT
  • S270.LIFNR == LFA1.LIFNR
Client S270.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S270.MATNR == MARA.MATNR
  • S270.MANDT == MARA.MANDT
Supplying (issuing) plant in case of stock transport order
  • S270.MANDT == T001W.MANDT
  • S270.RESWK == T001W.WERKS
Plant
  • S270.MANDT == T001W.MANDT
  • S270.WERKS == T001W.WERKS