S006BIW1

S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/ | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPTAG Period to analyze - current date
VRTNR Sales employee
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
KUNNR FK Sold-to Party
MATNR FK Material Number
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
💲 Statistics currency (STWAE):
AENETWR Net Value of Incoming Orders
RENETWR Net Value of Incoming Returns
UMNETWR Net Value of Invoiced Sales
GUNETWR Net Value of Credit Memos
AEKZWI1 Incoming orders: gross
AEKZWI2 Incoming orders: net 1
AEKZWI3 Incoming orders: net 2
AEKZWI4 Incoming orders: freight
AEKZWI5 Incoming orders: pricing subtotal 5
AEKZWI6 Incoming orders: pricing subtotal 6
REKZWI1 Incoming returns: gross
REKZWI2 Incoming returns: net 1
REKZWI3 Incoming returns: net 2
REKZWI4 Incoming returns: freight
REKZWI5 Incoming returns: pricing subtotal 5
REKZWI6 Incoming returns: pricing subtotal 6
UMKZWI1 Invoiced sales: gross
UMKZWI2 Invoiced sales: net 1
UMKZWI3 Invoiced sales: net 2
UMKZWI4 Invoice freight charges
UMKZWI5 Billing document: pricing subtotal 5
UMKZWI6 Billing document: pricing subtotal 6
GUKZWI1 Credit memos: gross
GUKZWI2 Credit memos: net 1
GUKZWI3 Credit memos: net 2
GUKZWI4 Credit memos: freight
GUKZWI5 Credit memos: pricing subtotal 5
GUKZWI6 Credit memos: pricing subtotal 6
AEWAVWR Cost of incoming orders
REWAVWR Incoming returns: cost
UMWAVWR Cost of invoiced sales
GUWAVWR Credit memos: cost
Column Name Description
📏 Base Unit of Measure (BASME):
AEMENGE Incoming Orders Quantity
REMENGE Quantity of Returns
UMMENGE Sales Volume Quantity
GUMENGE Quantity of Credit Memos
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
VWDAT Pointer to administrative data VWDAT
ANZAUPOS Number of Order Items MCZAEHLER
ANZREPOS No.of returns items MCZAEHLER
Master Data Relations Join Conditions
Base Unit of Measure
  • S006BIW1.MANDT == T006.MANDT
  • S006BIW1.BASME == T006.MSEHI
Sold-to Party
  • S006BIW1.MANDT == KNA1.MANDT
  • S006BIW1.KUNNR == KNA1.KUNNR
Client S006BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S006BIW1.MATNR == MARA.MATNR
  • S006BIW1.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S006BIW1.PERIV == T009.PERIV
  • S006BIW1.MANDT == T009.MANDT
Division
  • S006BIW1.MANDT == TSPA.MANDT
  • S006BIW1.SPART == TSPA.SPART
Statistics currency
  • S006BIW1.MANDT == TCURC.MANDT
  • S006BIW1.STWAE == TCURC.WAERS
Sales Organization
  • S006BIW1.MANDT == TVKO.MANDT
  • S006BIW1.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S006BIW1.VTWEG == TVTW.VTWEG
  • S006BIW1.MANDT == TVTW.MANDT