ALDBSMTE SAP (CCMS Monitoring Arch.: Database Segment: General MTE Data) Table details

Dictionary Type: Table
Description: CCMS Monitoring Arch.: Database Segment: General MTE Data




ABAP Code to SELECT data from ALDBSMTE
Related tables to ALDBSMTE
Access table ALDBSMTE




Table field list including key, data, relationships and ABAP select examples

ALDBSMTE is a standard SAP Table which is used to store CCMS Monitoring Arch.: Database Segment: General MTE Data data and is available within R/3 SAP systems depending on the version and release level.

The ALDBSMTE table consists of various fields, each holding specific information or linking keys about CCMS Monitoring Arch.: Database Segment: General MTE Data data available in SAP. These include MTSYSID (Name of SAP System), MTMCNAME (Alert: Name of Monitoring Context), MTNUMRANGE (Alert: monitoring type number range (perm., temp, ...)), MTUID (ALert: Unique Identifier for Monitoring Types (used in TID)).. 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 empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP ALDBSMTE 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
MTSYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
MTMCNAMEAlert: Name of Monitoring Context ALMCNAMECHAR40TEXT40
MTNUMRANGEAlert: monitoring type number range (perm., temp, ...) ALTIDNUMRGCHAR3CHAR3
MTUIDALert: Unique Identifier for Monitoring Types (used in TID) ALTIDUIDCHAR10CHAR10
MTCLASSAlert: monitoring type class (perf., single msg.,...) ALTIDMTCLCHAR3CHAR3
P_MTSYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
P_MTMCNAMEAlert: Name of Monitoring Context ALMCNAMECHAR40TEXT40
P_MTNUMRGAlert: monitoring type number range (perm., temp, ...) ALTIDNUMRGCHAR3CHAR3
P_MTUIDALert: Unique Identifier for Monitoring Types (used in TID) ALTIDUIDCHAR10CHAR10
P_MTCLASSAlert: monitoring type class (perf., single msg.,...) ALTIDMTCLCHAR3CHAR3
SEGMENTAlert: Name of Monitoring Segment ALMSEGNAMECHAR40TEXT40
SHORTNAMEAlert: short name of MTE ALNAMESHRTCHAR40CHAR40
MTECLASSCCMS Monitoring Architecture: Name of MTE class ALMTECLASSCHAR40TEXT40
MTESUBCLASAlert: Customization: Name of Customization Group ALCUSGROUPCHAR40TEXT40
OBJECTNAMEAlert: Name of Monitoring Object ALMOBJECTCHAR40CHAR40
MTESTATUSAlert: MT: Type Def Status ALTDSTATUSINT410
MTESUBTYPEAlert: monitoring tree element: subtype ALMTESUBTINT410
CUSTSTATAlert: Customizing Status ALCUSTSTATINT410
CLASORSPECAlert: Use Class or TID-Specif. Customizing and Tools ALUSECLASSINT410
SEVERITYAlert: severity (alerts, monitoring type custom..) ALSEVERITYINT410
VISILEVELAlert: MTE type dev cust: Visible on user level (op,exp,dev) ALVISILEVLINT410
KEEPALTYPEAlert: MTE Customizing: keep alerts type ALKEEPALTYINT410
KEEPALMAXAlert: MTE Cus: Maximum number of alerts to keep ALKEEPALMXINT410
SECTILCOLTAlert: Time values in seconds ALTIMSECSINT410
SECTILINACAlert: Time values in seconds ALTIMSECSINT410
SECWARMUPTAlert: Time values in seconds ALTIMSECSINT410
DTEXTCLASSXMI logging: company name of external management tool XMILOGCOMPCHAR16TEXT16
DTEXTIDMessage ID for an XMI log entry XMILOGMIDCHAR30XMSGID
DELIVERSTAAlert: MT Val: Delivery Status ALDELIVSTAINT410
HIGHALVALAlert: alert value (1 = green, 2 = yellow, ....) ALVALUEINT410
HIGHALSEVAlert: severity (alerts, monitoring type custom..) ALSEVERITYINT410
ALSYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
MSEGNAMEAlert: Name of Monitoring Segment ALMSEGNAMECHAR40TEXT40
ALUNIQNUMAlert: Unique Identifier to be used in AID (char10) ALAIDUIDCHAR10CHAR10
ALERTDATEAlert: date ALDATEDATS8DATUM
ALERTTIMEAlert: Time value in timeformat ALTIMETIMS6TIME
LASTVALDATAlert: date ALDATEDATS8DATUM
LASTVALTIMAlert: Time value in timeformat ALTIMETIMS6TIME
CURVALVALAlert: alert value (1 = green, 2 = yellow, ....) ALVALUEINT410
CURVALSEVAlert: severity (alerts, monitoring type custom..) ALSEVERITYINT410
CUR_ASYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
CUR_AMSEGAlert: Name of Monitoring Segment ALMSEGNAMECHAR40TEXT40
CUR_AUIDAlert: Unique Identifier to be used in AID (char10) ALAIDUIDCHAR10CHAR10
CUR_ADATEAlert: date ALDATEDATS8DATUM
CUR_ATIMEAlert: Time value in timeformat ALTIMETIMS6TIME
COUNTOFACTAlert: MT Val: Count of active Alerts ALCNTACTALINT410
COUNTSUMAlert: MT Val: Sum of Alerts in MT ALCNTSUMALINT410
TRGTDEFNAMAlert: Logical Name of Tool ALTOOLKEYCHAR40TEXT40
TRGTDEFDSPAlert method dispatcher ALTOOLDISPCHAR40CHAR40
TRGTDEFSTAAlert: Tool: Alert Tool Status ALTOOLSTATINT410
TRGTDEFCOSAlert: Use Class or TID-Specif. Customizing and Tools ALUSECLASSINT410
ANATDEFNAMAlert: Logical Name of Tool ALTOOLKEYCHAR40TEXT40
ANATDEFDSPAlert method dispatcher ALTOOLDISPCHAR40CHAR40
ANATDEFSTAAlert: Tool: Alert Tool Status ALTOOLSTATINT410
ANATDEFCOSAlert: Use Class or TID-Specif. Customizing and Tools ALUSECLASSINT410
ONATDEFNAMAlert: Logical Name of Tool ALTOOLKEYCHAR40TEXT40
ONATDEFDSPAlert method dispatcher ALTOOLDISPCHAR40CHAR40
ONATDEFSTAAlert: Tool: Alert Tool Status ALTOOLSTATINT410
ONATDEFCOSAlert: Use Class or TID-Specif. Customizing and Tools ALUSECLASSINT410
TRGTRUNNAMAlert: Logical Name of Tool ALTOOLKEYCHAR40TEXT40
TRGTRUNSTAAlert: Tool: Alert Tool Status ALTOOLSTATINT410
TRGTRUNDATAlert: date ALDATEDATS8DATUM
TRGTRUNTIMAlert: Time value in timeformat ALTIMETIMS6TIME
TRGTRUNDSPAlert method dispatcher ALTOOLDISPCHAR40CHAR40
ONATRUNNAMAlert: Logical Name of Tool ALTOOLKEYCHAR40TEXT40
ONATRUNSTAAlert: Tool: Alert Tool Status ALTOOLSTATINT410
ONATRUNDATAlert: date ALDATEDATS8DATUM
ONATRUNTIMAlert: Time value in timeformat ALTIMETIMS6TIME
ONATRUNDSPAlert method dispatcher ALTOOLDISPCHAR40CHAR40

Key field Non-key field



How do I retrieve data from SAP table ALDBSMTE using ABAP code

The following ABAP code Example will allow you to do a basic selection on ALDBSMTE to SELECT all data from the table
DATA: WA_ALDBSMTE TYPE ALDBSMTE.

SELECT SINGLE *
FROM ALDBSMTE
INTO CORRESPONDING FIELDS OF WA_ALDBSMTE
WHERE...

How to access SAP table ALDBSMTE

Within an ECC or HANA version of SAP you can also view further information about ALDBSMTE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!