SAP ABAP Table S116 (Customer Analysis)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S116   Table Relationship Diagram
Short Description Customer 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 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
10 SPART SPART SPART CHAR 2   0   Division TSPA
11 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant T399I
12 QMART QMART QMART CHAR 2   0   Message Type TQ80
13 KUNUM KUNUM KUNNR CHAR 10   0   Customer Number KNA1
14 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location IFLOT
15 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number EQUI
16 BAUTL BAUTL MATNR CHAR 18   0   Assembly MARA
17 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
18 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
19 SUNIT MAUEH MEINS UNIT 3   0   Unit for Breakdown Duration T006
20 SMOFN SMOFN MCZAEHLER DEC 9   0   No.of recorded notifications  
21 SMMAB SMMAB MCZAEHLER DEC 9   0   No. of completed notifications  
22 SABTG SABTG MCZAEHLER DEC 9   0   No. processing days creation to completion  
23 SGMSAUS SGMSAUS MCZAEHLER DEC 9   0   Number of machine breakdowns reported  
24 SGAUSZT SGAUSZT MENG13 QUAN 13   3   Downtime entered  
25 SSCODE SSCODE MCZAEHLER DEC 9   0   PMIS: No.of damages  
26 SACODE SACODE MCZAEHLER DEC 9   0   PMIS: number of activity codes  
27 SUCODE SUCODE MCZAEHLER DEC 9   0   PMIS: No. of cause of damage codes  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S116 BAUTL MARA MATNR    
2 S116 EQUNR EQUI EQUNR    
3 S116 IWERK T399I IWERK    
4 S116 KUNUM KNA1 KUNNR    
5 S116 MANDT T000 MANDT    
6 S116 QMART TQ80 QMART    
7 S116 SPART TSPA SPART    
8 S116 SUNIT T006 MSEHI    
9 S116 TPLNR IFLOT TPLNR    
10 S116 VKORG TVKO VKORG    
11 S116 VTWEG TVTW VTWEG    
History
Last changed by/on SAP  20050411 
SAP Release Created in