S020 - SIS: Customer Potential Analysis
SIS: Customer Potential Analysis information is stored in SAP table S020.
It is part of development package MCV in software component SD-IS. This development package consists of objects that can be grouped under "R/3 application development: Sales Information System".
It is part of development package MCV in software component SD-IS. This development package consists of objects that can be grouped under "R/3 application development: Sales Information System".
Fields for table S020
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| VKORG | Sales Organization | X | VKORG | CHAR | 8 | TVKO |
| KUNNR | Sold-to Party | X | KUNAG | CHAR | 20 | KNA1 |
| PRODH1 | Standard data element PRODH1 | X | PRODH1 | CHAR | 10 | |
| WETTB | Competitor | X | WETTB | CHAR | 20 | KNA1 |
| PRODH2 | Standard data element PRODH2 | X | PRODH2 | CHAR | 10 | |
| PRODH3 | Standard data element PRODH3 | X | PRODH3 | CHAR | 16 | |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| STWAE | Statistics Currency | STWAE | CUKY | 10 | TCURC | |
| BASME | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| AENETWR | Net Value of Incoming Orders | MC_AENETWR | CURR | 10 | ||
| FAENETWR | Net Value of Incoming Orders | MC_AENETWR | CURR | 10 | ||
| AEMENGE | Incoming Orders Quantity | MC_AEMENGE | QUAN | 8 | ||
| FAEMENGE | Incoming Orders Quantity | MC_AEMENGE | QUAN | 8 | ||
| UMNETWR | Net Value of Invoiced Sales | MC_UMNETWR | CURR | 10 | ||
| FUMNETWR | Net Value of Invoiced Sales | MC_UMNETWR | CURR | 10 | ||
| VBELN | SD document no. of a sales activity in sales support | CAS_VBELN | CHAR | 20 | * |