S272

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
BIWPNL RIS/Reporting Server - Transfer price reduction
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
OAUWE Net Value of Open Orders
💲 SD Document Currency (WAERK):
WAVWR Cost in Document Currency
NETWR Net Value of Billing item in Document Currency
BRTWR Gross Value of the Billing Item in Document Currency
MWSBP Tax Amount in Document Currency
Column Name Description
📏 Base Unit of Measure (BASME):
BIWMNG RIS/Reporting Server - Transfer base quantity
OAUME Open orders quantity in base unit of measure
📏 Sales unit (VRKME):
BIWMVE RIS/Reporting Server - Transfer quantity sold
Column Name Description
SPTAG Period to analyze - current date
ERZET Entry time
Column Name Description
SUPKZ Statistics update indicator (post in/post out) Show values
BWBELT Type of transfer document 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 activity CHAR4
Master Data Relations Join Conditions
Reason for Rejection of Sales Documents
  • S272.MANDT == TVAG.MANDT
  • S272.ABGRU == TVAG.ABGRU
Promotion
  • Promotion
  • Client
  • S272.AKTNR == WAKH.AKTNR
  • S272.MANDT == WAKH.MANDT
Base Unit of Measure
  • S272.MANDT == T006.MANDT
  • S272.BASME == T006.MSEHI
Transfer document type
  • S272.MANDT == TVAK.MANDT
  • S272.BWBELA == TVAK.AUART
Item category transfer document
  • Item category transfer document
  • Client
  • S272.BWPOST == TVPT.PSTYV
  • S272.MANDT == TVPT.MANDT
Local Currency
  • S272.MANDT == TCURC.MANDT
  • S272.HWAER == TCURC.WAERS
Sales Deal
  • Sales Deal
  • Client
  • S272.KNUMA_AG == KONA.KNUMA
  • S272.MANDT == KONA.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • S272.KNUMA_PI == KONA.KNUMA
  • S272.MANDT == KONA.MANDT
Client S272.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S272.MATNR == MARA.MATNR
  • S272.MANDT == MARA.MANDT
Material Entered
  • Material Entered
  • Client
  • S272.MATWA == MARA.MATNR
  • S272.MANDT == MARA.MANDT
Sold-to Party
  • S272.MANDT == KNA1.MANDT
  • S272.PKUNAG == KNA1.KUNNR
Ship-to Party
  • S272.MANDT == KNA1.MANDT
  • S272.PKUNWE == KNA1.KUNNR
Division
  • S272.MANDT == TSPA.MANDT
  • S272.SPART == TSPA.SPART
Sales group
  • Sales group
  • Sales office
  • S272.MANDT == TVBVK.MANDT
  • S272.VKGRP == TVBVK.VKGRP
  • S272.VKBUR == TVBVK.VKBUR
Sales Organization
  • S272.MANDT == TVKO.MANDT
  • S272.VKORG == TVKO.VKORG
Sales unit
  • S272.MANDT == T006.MANDT
  • S272.VRKME == T006.MSEHI
Distribution Channel
  • Distribution Channel
  • Client
  • S272.VTWEG == TVTW.VTWEG
  • S272.MANDT == TVTW.MANDT
SD Document Currency
  • S272.MANDT == TCURC.MANDT
  • S272.WAERK == TCURC.WAERS
Plant
  • S272.MANDT == T001W.MANDT
  • S272.WERKS == T001W.WERKS
Product catalog number
  • Product catalog number
  • Client
  • S272.WMINR == WWMI.WMINR
  • S272.MANDT == WWMI.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • S272.VKORG == TVKBZ.VKORG
  • S272.MANDT == TVKBZ.MANDT
  • S272.VTWEG == TVKBZ.VTWEG
  • S272.SPART == TVKBZ.SPART
  • S272.VKBUR == TVKBZ.VKBUR