SAP CCMS Monitoring & Alerting Tables

Are you looking for the right table related to SAP CCMS Monitoring & Alerting Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in CCMS Monitoring & Alerting (BC-CCM-MON) module.

Top 10 tables in CCMS Monitoring & Alerting

TableDescription
CSMBK_CLClass Definitions in CCMS Repository
ASTAT_OKDFDefinition of OPENKEYS for Application-Triggered Statistics
ALCSMCONF_LOCUser/Client Info for Local CSMCONF for J2EE Add-Ins
ALF1DEFLTCCMS Monitoring Architecture: Default Description Texts
ALBTCMONTable for Batch Monitoring
ALAVLAGENTCombine CCMSPING Agents into Groups
ALGRPCUSMGAlert: Group Customizing data single message class
GRMG_COMPONENTSGRMG: table for components
CSMNUMETHUpdate Method Assignments for CCMS CSM Tables
CCMSBI_MTE_THRHTime-Dependent MTE Threshold Values

List of tables in CCMS Monitoring & Alerting

TableDescription
CSMBK_CLClass Definitions in CCMS Repository
ASTAT_OKDFDefinition of OPENKEYS for Application-Triggered Statistics
ALCSMCONF_LOCUser/Client Info for Local CSMCONF for J2EE Add-Ins
ALF1DEFLTCCMS Monitoring Architecture: Default Description Texts
ALBTCMONTable for Batch Monitoring
ALAVLAGENTCombine CCMSPING Agents into Groups
ALGRPCUSMGAlert: Group Customizing data single message class
GRMG_COMPONENTSGRMG: table for components
CSMNUMETHUpdate Method Assignments for CCMS CSM Tables
CCMSBI_MTE_THRHTime-Dependent MTE Threshold Values
CSMBK_TK2Token Definition in CCMS Repository
CSMPRPINH2Mapping Table: Property Inheritance of CCMS SCR Classes
ALAVLPTRCControl Table for RFC_PING - CCMS Availability Monitoring
ALMSETSAlerts: Monitor Sets and Corresponding Attributes
SAPWLSFIHDSAP Workload: stat. record: starts of the statistics files
ALCCMCUSTPValue table for CCMS Customizing Parameters
CCMSBIMETHTime-Dependent MTE Reaction Methods
SCSM_CHECK_LOGLog for Consistency Check
ALDWNTIMEDowntime of systems for availability calculations
SCMC_SYSTEMSSystems in CCMS Monitoring Console
ALMBCADMCCMS Monitoring Cache: Administration of "MTEs of one Class"
SCMLPSMOI_WS: Configuration of Logical Ports for SAPSTARTSRV
ALMONITORSAlerts: Monitors and Corresponding Default Values
SCSM_CHECK_ITFMapping Table: Adobe Forms ITF <-> RZ50 Checks
CSMCENTOOLCCMS Monitoring: Container for Methods Started Centrally
CSMBKFact Table for CCMS System Repository
GRMG_RUN_LOGGRMG: Table for run log
GRMG_AWS_CTRLControl Flags: Transaction GRMG, GRMG ABAP Web Services UI
ALMONIDEFAlerts: Description of Monitor Definition Nodes
CSMVIEWDTSCR Viewer
CCMSBI_MTE_DATATime-Dependent General MTE Data
ASTAT_TYP2Customer specific activation of application statistics
ALIMCDATAAlerts: ABAP-Shared-Buffer for IMC Communication
CSMBK_CLSTTranslation Table for CCMS CSM Class Names
CSM_PRPINHMapping Table: Property Inheritance of CCMS SCR Classes
CSMCONTXCCMS Central System Management: Remote Managed Contexts
ALAVLWORKCCMS: Dummy Table for Config. Table Controls
ALGRPCUSPFAlert: Group Customizing data performance class
CSMBK_ASCAssociations in CCMS System Repository
ALCSMCONFConfiguration for CCMS Agents
ALDTSCTRLControl Table for CCMS Evaluated Data Service
ALAVLCTRLCCMSPING Push Technology: Current State of Worklists
SMOI_WS_PROF_TProfile descriptions
CSM_ASCAssociations in SCR (from SAP Web AS 6.10)
ALDTSCACHESDTS: Current/Next Downtimes for CCMS Systems/Instances
SCSM_CHECK_DCODERZ50: Dynamic Coding
ALDBSMSEGCCMS Monitoring Arch.: Database Segment: Monitoring Segments
ALMDRLDSCAlerts: Language-dependent rule description
CCMSBITHRHTime-Dependent MTE Threshold Values
ALMONISETSAlerts: Monitor sets of the CCMS monitoring infrastructure
ALAVLGRP_CCCMS: Control Table for RFC_PING Check of Logon Groups
GRMG_CONTROLGRMG: Table for application control
ALMBRDATACCMS Monitoring Cache: Data for "MTEs of one Class"
EWTXTStatistics, text for applications and exceptions in EWEXC
ALCLASTOOLAlert: Assignment of tools to object class
SMOI_WS_PROFILERegistration Profiles
SCMC_LANDSCAPESLandscapes in CCMS Monitoring Console
SCSM_CHECK_MLCUSCustomer Link Between Check Object and Text Object
SCMC_LNDKEYKey Table for Instance Names of SAP Landscapes
ALCACHECNFConfiguration of the SALC Cache
ALMBRADMCCMS Monitoring Cache: For SAL_GET_MTES_BY_REQUEST_TABLE
CSM_ABOSCRSubscription to Intrinsic Events in CCMS SCR
ALMTCUSGENAlert: MT-specific Customizing Class-independent
ALDBSPERFCCMS Monitoring Arch.: Database Segment: Performance MTE
CSMCLSINH2CCMS System Comp Repository: Class Derivation Relationships
ASTAT_TYP1Types of I/Okeys
ALCCMSPING_TRACECCMSPING-Trace-Tabelle - ├╝ber ALAVLCTRL angeschaltet
ALDTSMAPSDTS: Cache Table for CCMS Downtime Mapping
ALCONSEGAlert: Context/segment assignment
CSMNIPINGCFGCCMS : Configuration Table for NI PING Availability
EWRELStatistics, relations in hierarchy
ALGLOBSYSLGFILCentral System Log Filter Definition
CCMSBIDATATime-Dependent General MTE Data
ALGRPCUSGEAlert: General Customizing for MTE classes
ALAVLGCNTLCCMS Avail. Mon.: Control Table for Reference System Group
CSMBK_TOKTTranslation Table for CCMS CSM Token Names
SCMC_AM_GUIDRelation Between ObjectName and GUI
ALCUSTSETAlert: Monitoring Properties Variants
ALDBSMTECCMS Monitoring Arch.: Database Segment: General MTE Data
SCMC_NODE_PERFAdditional Attributes for Performance Nodes
ALAVLGUIDCCMSPING: Mapping Table GUID <-> Monitored System
SCSM_CHECK_RELATConfiguration of the Available Standard Checks
ALALERTDBAlert: alert database (general alert structure, raw message)
CSMCLGUID2Mapping Table: GUIDs/SCR Classes and Properties
ALDBSSMESCCMS Monitoring Arch.: Database Segment: Status AttributeMTE
ALDBSTOOLCCMS Monitoring Arch.: Database Segment: MTE Method Data
ALGRPMCFILAlert: Message container filter for Cust. groups
ALCCMCUSTCustomizing settings for CCMS
CSMBK_OBJObject Repository in CCMS System Repository
SQLRUSER1User Table for Groups for SQL Trace Interpreter
SCMC_CACHE_CHGLogging of All Deleted/New Cache Entries
EDS_VERI_TESTTestdaten f├╝r Evaluated Data Service Veri-Test SCSM_EDS_OQT
ALMRULESAlerts: Rule Descriptions for Monitor Definitions (V3)
CSMBK_SEMTTranslation Table for CCMS CSM Semantic Names
CSM_EXTVALExtended Keys for SCR Objects
ALALERTXCCMS Monitoring: Cache for Alerts Already Read
SCSM_CHECK_CFGuser based Configuration of checks
ALGRPCUSMCAlert: Message container Customizing for Cust. groups
ALAVLPINGControl Table for CCMS RFC_PING - SALK_SYSTEM_AVAILABILITY
CSMTOOLASGCCMS Monitoring: Assignment of Methods Started Centrally
CSM_TEXTSTranslation Table for SCR Classes and Other Texts
ALTEXTASSIGNAssignments of Text collection schemas to MTE classes
SCSM_CHECK_MAILStandard Link Between Check Object and Text Object
ALCCMCUSTVValue table for possible values of parameters
ALCCMCUSTTText table for customizing settings
ALLONGJOB_CTRLControl Table for CCMS Monitoring of Jobs by Runtime
ALMTMSCFILAlert: MTE-Specific Message Container Filter
CSMBK_TKToken Definition in CCMS Repository
ALMTCUSPERAlert: MT-specific Customizing Performance-Class
SCMC_NODE_MSCAdditional Attributes for Message Container Nodes
CSMBK_OB2New Object Table for SCR from SAP Web AS 6.10
ALNAMEDUSERSCustomizing Settings for CCMS Named Used Data Collector
ALTOOLEXECAlert: Tool definition (executable, dispatcher and so on)
CSMBK_PROTTranslation Table for CCMS CSM Provider Names
ALALRTGUIDGUIDs for CCMS Alert IDs (for Alert Framework)
ALTOOLDPAlert: Name of tool dispatchers
ALMTCUSSMGAlert: MT-specific Customizing: Single Message Class
GRMG_SCENARIOSGRMG: Table for scenario descriptions
ALPFDBVARIPFDB: Additional Performance History Report Information
CSMCLSGUIDMapping Table: GUIDs/SCR Classes and Properties
CSM_CLSTTranslation Table for CCMS CSM Class Names
ALPERFOBAlert: Performance Database Object Part
ALPFCOLLSYSSystems from Which the CPH Collects Data
CSMNUDATACSM CEN CCMS Data to be Processed
ALTRAMONIMonitoring Arch.: Table for Transaction-Specific Monitoring
ASTAT_OKTXShort Texts for SAP Functions for Appl.-Triggered Statistics
ALMBCDATACCMS Monitoring Cache: Data for "MTEs of one Class"
ASTAT_TYPTText for types of application statistics
ALVFOBMOAlerts: Association Between Object Type and Monitor Set
ALMDRULESAlerts: Rules for rule nodes of a monitor definition
ALPFPARAMCPH Settings
ALMSETSV2Alerts: Copy of Monitor Sets From Database Version 2
SCSM_MONSYS_BUFBuffer Table ALSYSTEM
SAPWLWAMAITable to dynam. output fields in Trans. STAD - main list
ARCH_OHEADArchive File Overhead
CSMBK_CL2Class Definitions in CCMS Repository
CSM_TOKTTranslation Table for CCMS CSM Token Names
GRMG_HTML_TAGSHTML tags the GRMG takes into account for resolving Web pgs
ALDBSCTXCCMS Monitoring Arch.: Database Segment: Monitoring Contexts
ALPFAUTOREPORTList of PerfDB Report to Be Executed Automatically
CSMCLDISPTDisplay Properties for SCR Classes
ALMTCUSMSCAlert: MTE-specific Customizing: message container
SQLRUSER2User Table for Function for SQL Trace Interpreter
SQLRUSERCustomizing Table for SQL Trace Interpreter
ALPERFDB_CAlert: Performance Database
EWEXCStatistics, exceptions for EWAGG
CSMSYSCentral Table of Known Systems
ALPFREPDEFTable for Report Definitions
CSMCLSMAP2Directory of CSM Classes for Fasr Access
ALXMBALERTPersistence Table for XMB Alert IDs
SQLRTEXT2Text Table for Function for SQL Trace Interpreter
ALPFTHRHIST_RWSPerformance Threshold History: Number of Records
ALSLDUPDCCMS SCR SLD Comparison: Delet. and DSR Registration Actions
CSM_CLSINHCCMS System Comp Repository: Class Derivation Relationships
ALXMBEMAILCCMS: Registration of E-Mail Recipients for Alerts
ALPFPOLICYAlert: Performance DB Schema (Reorg/Coll)
ALTEXTSCHEMADefinition of Schemas for Text History
ALPFREP_DATTable for PerfDB Report Data
TAM0TApplication Monitor: Texts
SMOI_WS_RFCLOGONConnection details for RFC-Logon to and from remote systems
ALPERSONELAlerts: Personalized Data of Monitoring Architecture
CSMCLSMAPDirectory of CSM Classes for Fasr Access
CSMSEGMCCMS Central System Management: Remote Managed Segments
ALQRFCMONAAssign qRFC Queues Application MSC MTEs
ALXMBINHERITKEYInheritance Hierarchy for XI Monitor Nodes
SCMC_CACHE_PRCSynchronization Table for the Cache Update Processes
ALTOOLCHEKAlert: Tools that have been checked as usable
GRMG_COMPONENT_TGRMG: table for components
ALQRFCMONOOwner of the Active Queue Group Settings for RZ20
ALSYSALInstance Table for BOR Object SYALERT (for Use with WFs)
ALTLDESCRAlert: Method Description - Language-Dependent
CSM_EVNTSTDescriptions of Intrinsic CCMS SCR Events
GRMG_PROPERTIESGRMG: Table for properties
ALMTECLSETAlert: MTEClass setting of the Monitoring Architecture
CSM_TEXTS2Translation Table for SCR Classes and Other Texts
CSMBK_SEMCSM_BK: Semantic and Token Definitions
ALPFCOLLTIDTID List Created from ALPFREORG:Objects to Collect in PerfDB
ALPFTHRHIST_TBPerformance Threshold History
CSM_CNTXTContexts for Executing Asynchronous SCR Methods
ALPFASSIGNAlert: Assignment of Reorg/Coll Schema to MTE (New Version)
CSMSEGMXCCMS: Cache for Administration of Monitored Segments
ALSYSGRPSAlerts: Definition of R/3 System Groups
CSMSYSASCentral CCMS: List of SAP System Instances
CCMSBI_MTE_METHTime-Dependent MTE Reaction Methods
SQLRRELESAP R/3 Releases
CSM_EVENTSIntrinsic Events in CCSM System Component Repository
SCMC_FVRSCCMS MC Favorites Objects Table
ALNODEKEYMTEKEY to node mapping
SCMC_NODE_SMESAdditional Attributes for Log Nodes
SCSM_CHECK_USRCustomizing Table for Checking Locked Users
CSMNSDICCCMS CSM: Central Name Server Directory
ALPERFDBAlert: Performance database
SCSM_CHECK_SETConfigured Check Sets
ALTIDTOOLAlert: Assignment of tools to Tid
ALVFOBTYAlerts: List of Supported Object Types
CPH_TRACETable for CPH Log Information
GRMG_MESSAGESGRMG: Table for messages
CSMSCRMETHIntrinsic Methods of CCMS System Component Repository
ALPFCOLLREORGSCHCollection/Reorganization Schemas for PerfDB
SCSM_CHECK_CUSTCustomizing of CCMS Checks
ALPF_TESTDATARepository for Test Data
ALTEXTDBHistory Database for text, status, and message nodes
SQLRTABCustomizing Table for SQL Trace Interpreter
SCMC_SETUPSettings and Parameters
ALPFREORGAlert: Assignment of Reorg/Coll Schema to MTE
ALPFWSCHEMWeighting Schemas for PerfDB Reorganizations
SCSM_CHECK_RLCUSConfiguration of the Customer Checks
SCMC_CACHE_UPDCCMS Monitoring Console Cache Update Information
GRMG_SCENARIO_TGRMG: Table for scenario descriptions
SAPWLSFIDXSAP Workload: Stats. record: index for statistics files
ALPFREPORTDEFTable for PerfDB Report Definitions
SCMC_CACHE_ACCLast Cache Access to Data of a Monitor
ALQRFCMONQAssign qRFC Queues Application MSC MTEs
ALSLDCTRLCCMS Access to Standard SLD - X Not Possible, 0 Possible
EWAGGStatistics, hierarchy of devclasses and applications
ALTSTLODMonitoring Arch.: For Report to Measure a Standard Load
GRMG_ERROR_LOGGRMG: Table for error log
SCMC_NODEBasic Data of Executed Monitors
ALXMBPFALERTExchange Infrastructure: Performance Alerts for XI Messages
ALPFREP_CATPerfDB Reporting Catalog
SQLRTEXT1Text Table for Groups for SQL Trace Interpreter
ALPFSFTPLYTable for Performance Database Shift Aggregate Schema
ALPFDBVARPFDB: Report Variants
CSM_OBJObjects in System Component Repository from SAP Web AS 6.10
ALPFDBVDESPFDB: Language-dependent report variant description
ALQRFCMONDefine Additional Message Container for qRFC Queue Mon.
ALSYSTEMSCCMS Central System Management: Remote Managed Systems