S003

SIS: SalesOrg/DistCh/Division/District/Customer/Product | #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
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
BZIRK FK Sales District
KUNNR FK Sold-to Party
MATNR FK Material Number
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
Sales District
  • S003.MANDT == T171.MANDT
  • S003.BZIRK == T171.BZIRK
Sold-to Party
  • S003.MANDT == KNA1.MANDT
  • S003.KUNNR == KNA1.KUNNR
Client S003.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S003.MATNR == MARA.MATNR
  • S003.MANDT == MARA.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • S003.PERIV == T009.PERIV
  • S003.MANDT == T009.MANDT
Division
  • S003.MANDT == TSPA.MANDT
  • S003.SPART == TSPA.SPART
Sales Organization
  • S003.MANDT == TVKO.MANDT
  • S003.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S003.VTWEG == TVTW.VTWEG
  • S003.MANDT == TVTW.MANDT