SAP ABAP Table S020 (SIS: Customer Potential Analysis)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCV (Package) R/3 application development: Sales Information System
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S020   Table Relationship Diagram
Short Description SIS: Customer Potential Analysis    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
9 KUNNR KUNAG KUNNR CHAR 10   0   Sold-to party KNA1
10 PRODH1 PRODH1 PRODH1 CHAR 5   0   Standard data element PRODH1  
11 WETTB WETTB KUNNR CHAR 10   0   Competitor KNA1
12 PRODH2 PRODH2 PRODH2 CHAR 5   0   Standard data element PRODH2  
13 PRODH3 PRODH3 PRODH3 CHAR 8   0   Standard data element PRODH3  
14 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
15 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
16 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
17 STWAE STWAE WAERS CUKY 5   0   Statistics currency TCURC
18 BASME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
19 AENETWR MC_AENETWR WERTV10 CURR 19   2   Net value of incoming orders  
20 FAENETWR MC_AENETWR WERTV10 CURR 19   2   Net value of incoming orders  
21 AEMENGE MC_AEMENGE MENGV15_3 QUAN 15   3   Incoming orders quantity  
22 FAEMENGE MC_AEMENGE MENGV15_3 QUAN 15   3   Incoming orders quantity  
23 UMNETWR MC_UMNETWR WERTV10 CURR 19   2   Net value of invoiced sales  
24 FUMNETWR MC_UMNETWR WERTV10 CURR 19   2   Net value of invoiced sales  
25 VBELN CAS_VBELN VBELN CHAR 10   0   SD document no. of a sales activity in sales support VBUK
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S020 BASME T006 MSEHI    
2 S020 KUNNR KNA1 KUNNR    
3 S020 MANDT T000 MANDT    
4 S020 MATNR MARA MATNR    
5 S020 STWAE TCURC WAERS    
6 S020 VBELN VBUK VBELN    
7 S020 VKORG TVKO VKORG    
8 S020 WETTB KNA1 KUNNR    
History
Last changed by/on SAP  20050411 
SAP Release Created in