| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPCross-Application Components |
1 | CCMSBI_BWPTR_CPH | CPH/BI: Delta Management Table for Extraction of CPH Data | 20 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
2 | CCMSBI_CPH_BWPTR | CPH/BW: Reader Pointer for the Extraction of CPH Data | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
3 | CCMSBI_CUSTDATA | Time-Dependent General MTE Data | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
4 | CCMSBI_METHODS | Time-Dependent Reaction Methods | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
5 | CCMSBI_THRH_VAL | Time-Dependent Threshold Values | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
TOPDirectory |
6 | LDAPGATEW | LDAP Connector | 5 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
TOPMonitoring |
7 | ALALERTDB | Alert: alert database (general alert structure, raw message) | 8 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
8 | ALALERTX | CCMS Monitoring: Cache for Alerts Already Read | 15 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
9 | ALALRTGUID | GUIDs for CCMS Alert IDs (for Alert Framework) | 8 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
10 | ALDBSMTE | CCMS Monitoring Arch.: Database Segment: General MTE Data | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
11 | ALDBSPERF | CCMS Monitoring Arch.: Database Segment: Performance MTE | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
12 | ALDBSSMES | CCMS Monitoring Arch.: Database Segment: Status AttributeMTE | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
13 | ALDBSTOOL | CCMS Monitoring Arch.: Database Segment: MTE Method Data | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
14 | ALDWNTIME | Downtime of systems for availability calculations | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
15 | ALMBCDATA | CCMS Monitoring Cache: Data for "MTEs of one Class" | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
16 | ALMBRDATA | CCMS Monitoring Cache: Data for "MTEs of one Class" | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
17 | ALMONIDEF | Alerts: Description of Monitor Definition Nodes | 12 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
18 | ALMTCUSGEN | Alert: MT-specific Customizing Class-independent | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
19 | ALMTCUSMSC | Alert: MTE-specific Customizing: message container | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
20 | ALMTCUSPER | Alert: MT-specific Customizing Performance-Class | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
21 | ALMTCUSSMG | Alert: MT-specific Customizing: Single Message Class | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
22 | ALMTMSCFIL | Alert: MTE-Specific Message Container Filter | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
23 | ALNODEKEY | MTEKEY to node mapping | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
24 | ALPERFDB | Alert: Performance database | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
25 | ALPERFDB_C | Alert: Performance Database | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
26 | ALPERFOB | Alert: Performance Database Object Part | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
27 | ALPFASSIGN | Alert: Assignment of Reorg/Coll Schema to MTE (New Version) | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
28 | ALPFCOLLSYS | Systems from Which the CPH Collects Data | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
29 | ALPFCOLLTID | TID List Created from ALPFREORG:Objects to Collect in PerfDB | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
30 | ALPFTHRHIST_RWS | Performance Threshold History: Number of Records | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
31 | ALPFTHRHIST_TB | Performance Threshold History | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
32 | ALTEXTASSIGN | Assignments of Text collection schemas to MTE classes | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
33 | ALTIDTOOL | Alert: Assignment of tools to Tid | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
34 | ALXMBALERT | Persistence Table for XMB Alert IDs | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
35 | CCMSBIDATA | Time-Dependent General MTE Data | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
36 | CCMSBIMETH | Time-Dependent MTE Reaction Methods | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
37 | CCMSBITHRH | Time-Dependent MTE Threshold Values | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
38 | CCMSBI_MTE_DATA | Time-Dependent General MTE Data | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
39 | CCMSBI_MTE_METH | Time-Dependent MTE Reaction Methods | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
40 | CCMSBI_MTE_THRH | Time-Dependent MTE Threshold Values | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
41 | CSMBK_SEM | CSM_BK: Semantic and Token Definitions | 5 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
42 | CSMCENTOOL | CCMS Monitoring: Container for Methods Started Centrally | 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
43 | SCMC_NODE | Basic Data of Executed Monitors | 8 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
44 | SCMC_NODE_MSC | Additional Attributes for Message Container Nodes | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
45 | SCMC_NODE_PERF | Additional Attributes for Performance Nodes | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
46 | SCMC_NODE_SMES | Additional Attributes for Log Nodes | 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
TOPProcess Monitoring Infrastructure |
47 | SSPIMOALERTS | PMI: Self-Monitoring, Table of Triggered Alerts | 11 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
TOPWithout Description |
48 | CCMSBIAVAILDOWNT | Individual Non-Availability Settings | 3 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |
49 | CCMSBIAVLREPCF | Individual Reporting Settings: SLA Limits | 3 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | | |