S020

SIS: Customer Potential Analysis | #transactional | Component: Information System
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
KUNNR FK Sold-to Party
PRODH1 Standard data element PRODH1
WETTB FK Competitor
PRODH2 Standard data element PRODH2
PRODH3 Standard data element PRODH3
MATNR FK Material Number
Column Name Description
💲 Statistics Currency (STWAE):
AENETWR Net Value of Incoming Orders
FAENETWR Net Value of Incoming Orders
UMNETWR Net Value of Invoiced Sales
FUMNETWR Net Value of Invoiced Sales
Column Name Description
📏 Base Unit of Measure (BASME):
AEMENGE Incoming Orders Quantity
FAEMENGE Incoming Orders Quantity
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
VBELN SD document no. of a sales activity in sales support VBELN
Master Data Relations Join Conditions
Base Unit of Measure
  • S020.MANDT == T006.MANDT
  • S020.BASME == T006.MSEHI
Sold-to Party
  • S020.MANDT == KNA1.MANDT
  • S020.KUNNR == KNA1.KUNNR
Client S020.MANDT == T000.MANDT
Material: order item
  • Material Number
  • Client
  • S020.MATNR == MARA.MATNR
  • S020.MANDT == MARA.MANDT
Statistics Currency
  • S020.MANDT == TCURC.MANDT
  • S020.STWAE == TCURC.WAERS
Sales organization in order header
  • S020.MANDT == TVKO.MANDT
  • S020.VKORG == TVKO.VKORG
Competitor
  • S020.MANDT == KNA1.MANDT
  • S020.WETTB == KNA1.KUNNR