S276

null | #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 FK BW: Document Number
BWBLPOS FK 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
💲 SD Document Currency (WAERK):
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
BWGEOD BW: Cost Value in Document Currency
BWGVOD BW: Retail Value in Document Currency
BWGVPD BW: Retail Value with Tax in Document Currency
BWPNLD BW: Price Reduction in Document Currency
BWOAUWD BW: Net Open Sales Order Value in Document Currency
Column Name Description
📏 Sales unit (VRKME):
BWMVE BW: Quantity in Sales Unit
📏 Base Unit of Measure (BASME):
BWOAUMV BW: Open Order Quantity in Base Unit of Measure
BWMNG BW: Quantity in Base Unit of Measure
Column Name Description
SPTAG Period to analyze - current date
ERZET Entry time
KURSK_DAT Translation date
APERDAT Date on which the record was created
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
WMINR Product Catalog Number MCBW_WMINR
VOGRU BW: Reason for Transaction CHAR4
BWAPPLNM Application Component RSAPPLNM
KURSK Exchange Rate for Price Determination KURRF
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
Master Data Relations Join Conditions
Reason for Rejection of Sales Documents
  • S276.MANDT == TVAG.MANDT
  • S276.ABGRU == TVAG.ABGRU
Promotion
  • Promotion
  • Client
  • S276.AKTNR == WAKH.AKTNR
  • S276.MANDT == WAKH.MANDT
Base Unit of Measure
  • S276.MANDT == T006.MANDT
  • S276.BASME == T006.MSEHI
BW: Document Type
  • S276.MANDT == TVAK.MANDT
  • S276.BWBLART == TVAK.AUART
BW: Item Category Document
  • BW: Item Category Document
  • Client
  • S276.BWBTYP == TVPT.PSTYV
  • S276.MANDT == TVPT.MANDT
Sales Deal
  • Sales Deal
  • Client
  • S276.KNUMA_AG == KONA.KNUMA
  • S276.MANDT == KONA.MANDT
Client S276.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S276.MATNR == MARA.MATNR
  • S276.MANDT == MARA.MANDT
Material Entered
  • Material Entered
  • Client
  • S276.MATWA == MARA.MATNR
  • S276.MANDT == MARA.MANDT
Sold-to Party
  • S276.MANDT == KNA1.MANDT
  • S276.PKUNAG == KNA1.KUNNR
Ship-to Party
  • S276.MANDT == KNA1.MANDT
  • S276.PKUNWE == KNA1.KUNNR
Division
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S276.VKORG == TVTA.VKORG
  • S276.VTWEG == TVTA.VTWEG
  • S276.SPART == TVTA.SPART
  • S276.MANDT == TVTA.MANDT
Sales group
  • Sales group
  • Sales office
  • S276.MANDT == TVBVK.MANDT
  • S276.VKGRP == TVBVK.VKGRP
  • S276.VKBUR == TVBVK.VKBUR
Sales Organization
  • S276.MANDT == TVKO.MANDT
  • S276.VKORG == TVKO.VKORG
Sales unit
  • S276.MANDT == T006.MANDT
  • S276.VRKME == T006.MSEHI
Distribution Channel
  • Sales Organization
  • Client
  • Distribution Channel
  • S276.VKORG == TVKOV.VKORG
  • S276.MANDT == TVKOV.MANDT
  • S276.VTWEG == TVKOV.VTWEG
SD Document Currency
  • S276.MANDT == TCURC.MANDT
  • S276.WAERK == TCURC.WAERS
Local Currency
  • S276.MANDT == TCURC.MANDT
  • S276.WAERS == TCURC.WAERS
Plant
  • S276.MANDT == T001W.MANDT
  • S276.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • S276.VKORG == TVKBZ.VKORG
  • S276.MANDT == TVKBZ.MANDT
  • S276.VTWEG == TVKBZ.VTWEG
  • S276.SPART == TVKBZ.SPART
  • S276.VKBUR == TVKBZ.VKBUR