SAP Table S020

SIS: Customer Potential Analysis

The table S020 (SIS: Customer Potential Analysis) is a standard table in SAP ERP. It belongs to the package MCV.

Technical Information

Table	S020
Short Text	SIS: Customer Potential Analysis
Package	MCV
Table Type	Transparent Table

Fields for Table S020

Field Name	Key	Description	Data Element	Type	Length	Check Table
MANDT	✔	Client	MANDT	CLNT	3	T000
SSOUR	✔	Statistic(s) origin	SSOUR	CHAR	4
VRSIO	✔	Version number in the information structure	VRSIO	CHAR	3	*
SPMON	✔	Period to analyze - month	SPMON	NUMC	6
SPTAG	✔	Period to analyze - current date	SPTAG	DATS	8
SPWOC	✔	Period to analyze - week	SPWOC	NUMC	6
SPBUP	✔	Period to analyze - posting period	SPBUP	NUMC	6
VKORG	✔	Sales Organization	VKORG	CHAR	4	TVKO
KUNNR	✔	Sold-to party	KUNAG	CHAR	10	KNA1
PRODH1	✔	Standard data element PRODH1	PRODH1	CHAR	5
WETTB	✔	Competitor	WETTB	CHAR	10	KNA1
PRODH2	✔	Standard data element PRODH2	PRODH2	CHAR	5
PRODH3	✔	Standard data element PRODH3	PRODH3	CHAR	8
MATNR	✔	Material Number	MATNR	CHAR	18	MARA
PERIV		Fiscal Year Variant	PERIV	CHAR	2	*
VWDAT		Pointer to administrative data	VWDAT	NUMC	10
STWAE		Statistics currency	STWAE	CUKY	5	TCURC
BASME		Base Unit of Measure	MEINS	UNIT	3	T006
AENETWR		Net value of incoming orders	MC_AENETWR	CURR	19
FAENETWR		Net value of incoming orders	MC_AENETWR	CURR	19
AEMENGE		Incoming orders quantity	MC_AEMENGE	QUAN	15
FAEMENGE		Incoming orders quantity	MC_AEMENGE	QUAN	15
UMNETWR		Net value of invoiced sales	MC_UMNETWR	CURR	19
FUMNETWR		Net value of invoiced sales	MC_UMNETWR	CURR	19
VBELN		SD document no. of a sales activity in sales support	CAS_VBELN	CHAR	10	VBUK