S020 is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of S020 in SAP.
- Table description : SIS: Customer Potential Analysis
- Module : CRM
- Parent Module : CRM
- Package : MCV
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP S020 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| VKORG | Sales Organization | VKORG | VKORG |
| KUNNR | Sold-to party | KUNAG | KUNNR |
| PRODH1 | Standard data element PRODH1 | PRODH1 | PRODH1 |
| WETTB | Competitor | WETTB | KUNNR |
| PRODH2 | Standard data element PRODH2 | PRODH2 | PRODH2 |
| PRODH3 | Standard data element PRODH3 | PRODH3 | PRODH3 |
| MATNR | Material Number | MATNR | MATNR |
| PERIV | Fiscal Year Variant | PERIV | PERIV |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| STWAE | Statistics currency | STWAE | WAERS |
| BASME | Base Unit of Measure | MEINS | MEINS |
| AENETWR | Net value of incoming orders | MC_AENETWR | WERTV10 |
| FAENETWR | Net value of incoming orders | MC_AENETWR | WERTV10 |
| AEMENGE | Incoming orders quantity | MC_AEMENGE | MENGV15_3 |
| FAEMENGE | Incoming orders quantity | MC_AEMENGE | MENGV15_3 |
| UMNETWR | Net value of invoiced sales | MC_UMNETWR | WERTV10 |
| FUMNETWR | Net value of invoiced sales | MC_UMNETWR | WERTV10 |
| VBELN | SD document no. of a sales activity in sales support | CAS_VBELN | VBELN |
S020 related tables
| Table | Note |
|---|---|
| S020 | SIS: Customer Potential Analysis |
| T77TMCPPPERIOD | Analysis Period for Performance and Potential |
| T77TMCPPPERIODT | Analysis Period for Performance and Potential |
| T77TMCPPTARGET | Analysis Period for Performance and Potential |
| JJTGPBTBR | IS-M/AM: Customer Potential: Industry Sector - BP |
| JJTGPBTBZ | IS-M/AM: Customer Potential: Zone - BP |
| JJTGPBTF1 | IS-M/AM: Customer Potential: Free Attribute 1 - BP |
| JJTGPBTF2 | IS-M/AM: Customer Potential: Free Attribute 2 - BP |
| JJTGPBTF3 | IS-M/AM: Customer Potential: Free Attribute 3 - BP |
| JJTGPBTF4 | IS-M/AM: Customer Potential: Free Attribute 4 - BP |
| JJTGPBTF5 | IS-M/AM: Customer Potential: Free Attribute 5 - BP |
| JJTGPBTF6 | IS-M/AM: Customer Potential: Free Attribute 6 - BP |
| JJTGPBTF7 | IS-M/AM: Customer Potential: Free Attribute 7 - BP |
| S001 | SIS: Customer Statistics |
| S001BIW1 | S001BIW1 * SIS: Customer Statistics |
Related tcodes for S020
Transaction codes in the same SAP package (MCV) as the S020 table.
| Tcode | Description |
|---|---|
| MCS7 | SIS: Create Evaluation Structure |
| MCS8 | SIS: Change Evaluation Structure |
| MCS9 | SIS: Display Evalaution Structure |
| MCT0 | Initial SIS Screen |
| MCT1 | Standard SDIS Analyses |
| MCT2 | Initial SIS Screen |
| MCV5 | Call Up Price List w.Stepped Display |
| MCV6 | Call Up Indiv. Customer Prices List |
| MCV7 | Call Up List of Price Groups |
| MCV8 | Call Up Material/MatPrcGroup List |
| MCV9 | Call Up List of Incomplete Documents |
| MCTV01 | SIS: Sales Activity - Selection |
Production order cost analysis TablesProduction order costing analysis table TablesAnalysis authorization TablesResults analysis TablesAssignment of analysis structure to client TablesCategory for variance/results analysis TablesProduction version cost analysis TablesCharacteristics profitability analysis Tables
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP