SCMC_NODE SAP (Basic Data of Executed Monitors) Table details
Dictionary Type: Table
Description: Basic Data of Executed Monitors
Description: Basic Data of Executed Monitors
Table field list including key, data, relationships and ABAP select examples
SCMC_NODE is a standard SAP Table which is used to store Basic Data of Executed Monitors data and is available within R/3 SAP systems depending on the version and release level.
The SCMC_NODE table consists of various fields, each holding specific information or linking keys about Basic Data of Executed Monitors data available in SAP. These include PARENT_KEY (Key for Cache Entries), OBJECT_NAME (Complete Object Name of All Domain Model Objects), OBJECT_TYPE (Data Type of the Node), MODIFY_TIME (UTC Time Stamp in Short Form (YYYYMMDDhhmmss)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP SCMC_NODE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
OBJECT_KEY | Key for Cache Entries | SCMC_CACHE_KEY | RAW | 16 | SYSUUID | ||||
PARENT_KEY | Key for Cache Entries | SCMC_CACHE_KEY | RAW | 16 | SYSUUID | ||||
OBJECT_NAME | Complete Object Name of All Domain Model Objects | SCMC_DM_OBJECT_NAME | CHAR | 250 | CHAR250 | ||||
OBJECT_TYPE | Data Type of the Node | SCMC_OBJECT_TYPE | CHAR | 40 | |||||
MODIFY_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
MONI_NAME | Name of a monitor in the CCMS monitoring infrastructure | ALTRINNM | CHAR | 60 | TEXT60 | ||||
MS_NAME | Alerts: Name of a monitor set | ALMONISET | CHAR | 60 | TEXT60 | ||||
MTSYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
MTMCNAME | Alert: Name of Monitoring Context | ALMCNAME | CHAR | 40 | TEXT40 | ||||
MTNUMRANGE | Alert: monitoring type number range (perm., temp, ...) | ALTIDNUMRG | CHAR | 3 | CHAR3 | ||||
MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | ALTIDUID | CHAR | 10 | CHAR10 | ||||
MTCLASS | Alert: monitoring type class (perf., single msg.,...) | ALTIDMTCL | CHAR | 3 | CHAR3 | ||||
MTINDEX | Alert: internal handle for TID | ALTIDINDEX | CHAR | 10 | CHAR10 | ||||
EXTINDEX | Alert: internal handle for TID | ALTIDINDEX | CHAR | 10 | CHAR10 | ||||
ALTREENUM | Alert: MT Tree info: Number of tree | ALTREENUM | INT4 | 10 | |||||
ALIDXINTRE | Alert: Tree Info: Index of MT in Tree | ALIDXINTRE | INT4 | 10 | |||||
ALLEVINTRE | Alert: Tree Info: Level of MTE in Tree | ALLEVINTRE | INT4 | 10 | |||||
ALPARINTRE | Alert: Tree Info: Index of Parent of MT in Tree | ALPARINTRE | INT4 | 10 | |||||
OBJECTNAME | Alert: Name of Monitoring Object | ALMOBJECT | CHAR | 40 | CHAR40 | ||||
MTNAMESHRT | Alert: Short Name of Monitoring Type | ALMTNAMESH | CHAR | 40 | CHAR40 | ||||
CUSGRPNAME | Alert: Customization: Name of Customization Group | ALCUSGROUP | CHAR | 40 | TEXT40 | ||||
DELIVERSTA | Alert: MT Val: Delivery Status | ALDELIVSTA | INT4 | 10 | |||||
HIGHALVAL | Alert: alert value (1 = green, 2 = yellow, ....) | ALVALUE | INT4 | 10 | |||||
HIGHALSEV | Alert: severity (alerts, monitoring type custom..) | ALSEVERITY | INT4 | 10 | |||||
ALSYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
MSEGNAME | Alert: Name of Monitoring Segment | ALMSEGNAME | CHAR | 40 | TEXT40 | ||||
ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | ALAIDUID | CHAR | 10 | CHAR10 | ||||
ALINDEX | Alert: internal handle | ALINDEX | CHAR | 10 | CHAR10 | ||||
ALERTDATE | Alert: date | ALDATE | DATS | 8 | DATUM | ||||
ALERTTIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | TIME | ||||
DUMMYALIGN | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | CHAR2 | ||||
LASTVALDAT | Alert: date | ALDATE | DATS | 8 | DATUM | ||||
LASTVALTIM | Alert: Time value in timeformat | ALTIME | TIMS | 6 | TIME | ||||
LASTVALDUM | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | CHAR2 | ||||
ACTUALVAL | Alert: alert value (1 = green, 2 = yellow, ....) | ALVALUE | INT4 | 10 | |||||
ACTUALSEV | Alert: severity (alerts, monitoring type custom..) | ALSEVERITY | INT4 | 10 | |||||
VALSYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
VMSEGNAME | Alert: Name of Monitoring Segment | ALMSEGNAME | CHAR | 40 | TEXT40 | ||||
VALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | ALAIDUID | CHAR | 10 | CHAR10 | ||||
VALINDEX | Alert: internal handle | ALINDEX | CHAR | 10 | CHAR10 | ||||
VALERTDATE | Alert: date | ALDATE | DATS | 8 | DATUM | ||||
VALERTTIME | Alert: Time value in timeformat | ALTIME | TIMS | 6 | TIME | ||||
VALERTDUM | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | ALDUMMYC2 | CHAR | 2 | CHAR2 | ||||
COUNTOFACT | Alert: MT Val: Count of active Alerts | ALCNTACTAL | INT4 | 10 | |||||
COUNTSUM | Alert: MT Val: Sum of Alerts in MT | ALCNTSUMAL | INT4 | 10 | |||||
VISUSERLEV | Alert: MTE type dev cust: Visible on user level (op,exp,dev) | ALVISILEVL | INT4 | 10 | |||||
TDSTATUS | Alert: MT: Type Def Status | ALTDSTATUS | INT4 | 10 |
Key field | Non-key field |
How do I retrieve data from SAP table SCMC_NODE using ABAP code
The following ABAP code Example will allow you to do a basic selection on SCMC_NODE to SELECT all data from the tableDATA: WA_SCMC_NODE TYPE SCMC_NODE.
SELECT SINGLE *
FROM SCMC_NODE
INTO CORRESPONDING FIELDS OF WA_SCMC_NODE
WHERE...
How to access SAP table SCMC_NODE
Within an ECC or HANA version of SAP you can also view further information about SCMC_NODE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects