| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | No | | SYSYSID | Allow NULL? |
| 2 | MTMCNAME | Alert: Name of Monitoring Context | nvarchar | 40 | 0 | CHAR | (N' ') | No | | ALMCNAME | Allow NULL? |
| 3 | MTNUMRANGE | Alert: monitoring type number range (perm., temp, ...) | nvarchar | 3 | 0 | CHAR | (N' ') | No | | ALTIDNUMRG | Allow NULL? |
| 4 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | CHAR | (N' ') | No | | ALTIDUID | Allow NULL? |
| 5 | MTCLASS | Alert: monitoring type class (perf., single msg.,...) | nvarchar | 3 | 0 | CHAR | (N' ') | No | | ALTIDMTCL | Allow NULL? |
| 6 | OBJNAME | Alert: short name of MTE | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALNAMESHRT | Allow NULL? |
| 7 | ATTRNAME | Alert: short name of MTE | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALNAMESHRT | Allow NULL? |
| 8 | MTETYPE | Alert: monitoring type class (perf., single msg.,...) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALMTCLASS | Allow NULL? |
| 9 | MTESUBTYPE | Alert: monitoring tree element: subtype | int | 10 | 0 | INT4 | ((0)) | Yes | | ALMTESUBT | Allow NULL? |
| 10 | MTECLASS | CCMS Monitoring Architecture: Name of MTE class | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMTECLASS | Allow NULL? |
| 11 | PARENTCL | CCMS Monitoring Architecture: Name of MTE class | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMTECLASS | Allow NULL? |
| 12 | P_MTSYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 13 | P_MTMCNAME | Alert: Name of Monitoring Context | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMCNAME | Allow NULL? |
| 14 | P_MTNUMRG | Alert: monitoring type number range (perm., temp, ...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ALTIDNUMRG | Allow NULL? |
| 15 | P_MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDUID | Allow NULL? |
| 16 | P_MTCLASS | Alert: monitoring type class (perf., single msg.,...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ALTIDMTCL | Allow NULL? |
| 17 | P_MTINDEX | Alert: internal handle for TID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDINDEX | Allow NULL? |
| 18 | P_EXTINDEX | Alert: internal handle for TID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDINDEX | Allow NULL? |
| 19 | OBREFID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDUID | Allow NULL? |
| 20 | MTE_PATH | Path of an MTE in the Monitoring Tree | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | ALMTEPATH | Allow NULL? |
| 21 | OBS_SYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 22 | ACOMP | Application component ID | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | UFPS_POSID | Allow NULL? |
| 23 | VALUNIT | ALert: Unit for Perfomance Values | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ALUNIT | Allow NULL? |
| 24 | DECIMALS | ALert: Decimal part of Performance Values | int | 10 | 0 | INT4 | ((0)) | Yes | | ALDECIMALS | Allow NULL? |
