SAP Table S020
SIS: Customer Potential Analysis
S020 (SIS: Customer Potential Analysis) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link S020 to other SAP tables.
S020 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |
|
SSOUR
Statistic(s) origin
|
SSOUR |
CHAR
|
4 | 0 | ||
|
VRSIO
Version number in the information structure
|
VRSIO |
CHAR
|
3 | 0 | ||
|
SPMON
Period to analyze - month
|
SPMON |
NUMC
|
6 | 0 | ||
|
SPTAG
Period to analyze - current date
|
SPTAG |
DATS
|
8 | 0 | ||
|
SPWOC
Period to analyze - week
|
SPWOC |
NUMC
|
6 | 0 | ||
|
SPBUP
Period to analyze - posting period
|
SPBUP |
NUMC
|
6 | 0 | ||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |
|
KUNNR
Sold-to party
|
KUNAG | KNA1 |
CHAR
|
10 | 0 | |
|
PRODH1
Standard data element PRODH1
|
PRODH1 |
CHAR
|
5 | 0 | ||
|
WETTB
Competitor
|
WETTB | KNA1 |
CHAR
|
10 | 0 | |
|
PRODH2
Standard data element PRODH2
|
PRODH2 |
CHAR
|
5 | 0 | ||
|
PRODH3
Standard data element PRODH3
|
PRODH3 |
CHAR
|
8 | 0 | ||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |
|
PERIV
Fiscal Year Variant
|
PERIV |
CHAR
|
2 | 0 | ||
|
VWDAT
Pointer to administrative data
|
VWDAT |
NUMC
|
10 | 0 | ||
|
STWAE
Statistics currency
|
STWAE | TCURC |
CUKY
|
5 | 0 | |
|
BASME
Base Unit of Measure
|
MEINS | T006 |
UNIT
|
3 | 0 | |
|
AENETWR
Net value of incoming orders
|
MC_AENETWR |
CURR
|
19 | 2 | ||
|
FAENETWR
Net value of incoming orders
|
MC_AENETWR |
CURR
|
19 | 2 | ||
|
AEMENGE
Incoming orders quantity
|
MC_AEMENGE |
QUAN
|
15 | 3 | ||
|
FAEMENGE
Incoming orders quantity
|
MC_AEMENGE |
QUAN
|
15 | 3 | ||
|
UMNETWR
Net value of invoiced sales
|
MC_UMNETWR |
CURR
|
19 | 2 | ||
|
FUMNETWR
Net value of invoiced sales
|
MC_UMNETWR |
CURR
|
19 | 2 | ||
|
VBELN
SD document no. of a sales activity in sales support
|
CAS_VBELN | VBUK |
CHAR
|
10 | 0 |
S020 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| S020 | BASME | S020 | MANDT |
T006
Units of Measurement
|
MANDT |
| S020 | BASME | S020 | BASME |
T006
Units of Measurement
|
MSEHI |
| S020 | KUNNR | S020 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| S020 | KUNNR | S020 | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| S020 | MANDT | S020 | MANDT |
T000
Clients
|
MANDT |
| S020 | MATNR | S020 | MANDT |
MARA
General Material Data
|
MANDT |
| S020 | MATNR | S020 | MATNR |
MARA
General Material Data
|
MATNR |
| S020 | STWAE | S020 | MANDT |
TCURC
Currency Codes
|
MANDT |
| S020 | STWAE | S020 | STWAE |
TCURC
Currency Codes
|
WAERS |
| S020 | VBELN | S020 | MANDT |
VBUK
Sales Document: Header Status and Administrative Data
|
MANDT |
| S020 | VBELN | S020 | VBELN |
VBUK
Sales Document: Header Status and Administrative Data
|
VBELN |
| S020 | VKORG | S020 | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| S020 | VKORG | S020 | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| S020 | WETTB | S020 | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| S020 | WETTB | S020 | WETTB |
KNA1
General Data in Customer Master
|
KUNNR |