| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | OBJECT_KEY | Key for Cache Entries | varbinary | 16 | 0 | RAW | | No | | SCMC_CACHE_KEY | |
| 2 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 3 | MTMCNAME | Alert: Name of Monitoring Context | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMCNAME | Allow NULL? |
| 4 | MTNUMRANGE | Alert: monitoring type number range (perm., temp, ...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ALTIDNUMRG | Allow NULL? |
| 5 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDUID | Allow NULL? |
| 6 | MTCLASS | Alert: monitoring type class (perf., single msg.,...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ALTIDMTCL | Allow NULL? |
| 7 | MTINDEX | Alert: internal handle for TID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDINDEX | Allow NULL? |
| 8 | EXTINDEX | Alert: internal handle for TID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDINDEX | Allow NULL? |
| 9 | CUSTSTAT | Alert: Customizing Status | int | 10 | 0 | INT4 | ((0)) | Yes | | ALCUSTSTAT | Allow NULL? |
| 10 | RAISEVALUE | Alert: alert value (1 = green, 2 = yellow, ....) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALVALUE | Allow NULL? |
| 11 | RAISESEVER | Alert: severity (alerts, monitoring type custom..) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALSEVERITY | Allow NULL? |
| 12 | ACTMSGMODE | Alert: Current log attribute value as: ... | int | 10 | 0 | INT4 | ((0)) | Yes | | ALMSCACTU | Allow NULL? |
| 13 | ACTMSGMAXS | Alert: MSG cont.: No. "max. value of the last" seconds | int | 10 | 0 | INT4 | ((0)) | Yes | | ALMAXCNTMS | Allow NULL? |
| 14 | MAXALPROID | Alert: MTE Cus: Maximum number of alerts to keep | int | 10 | 0 | INT4 | ((0)) | Yes | | ALKEEPALMX | Allow NULL? |
| 15 | KEEPLINTYP | Alert: MSG Container: Keep lines type | int | 10 | 0 | INT4 | ((0)) | Yes | | ALKEEPLNTY | Allow NULL? |
| 16 | KEEPLINMAX | Alert: MSG-Container: Max. number of lines to keep | int | 10 | 0 | INT4 | ((0)) | Yes | | ALKEEPLNMX | Allow NULL? |
| 17 | CUSGRPNAME | Alert: Customization: Name of Customization Group | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALCUSGROUP | Allow NULL? |
| 18 | MSCGLLID | Alert: Message container: global external line ID | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | ALMSCGLLID | Allow NULL? |
| 19 | MSCDATE | Alert: date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALDATE | Allow NULL? |
| 20 | MSCTIME | Alert: Time value in timeformat | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ALTIME | Allow NULL? |
| 21 | MSCDUMMY | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ALDUMMYC2 | Allow NULL? |
| 22 | VALUEORIG | Alert: alert value (1 = green, 2 = yellow, ....) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALVALUE | Allow NULL? |
| 23 | SEVERORIG | Alert: severity (alerts, monitoring type custom..) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALSEVERITY | Allow NULL? |
| 24 | VALUEFLTRD | Alert: alert value (1 = green, 2 = yellow, ....) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALVALUE | Allow NULL? |
| 25 | SEVERFLTRD | Alert: severity (alerts, monitoring type custom..) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALSEVERITY | Allow NULL? |
| 26 | MANDT | Client ID | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | SYMANDT | Allow NULL? |
| 27 | USERID | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 28 | MSG | The expanded (translated) message for ext. tools | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | XMIEXTMSG | Allow NULL? |
| 29 | MSGCLASS | XMI logging: company name of external management tool | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | XMILOGCOMP | Allow NULL? |
| 30 | MSGID | Message ID for an XMI log entry | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | XMILOGMID | Allow NULL? |
| 31 | MSGARG1 | Argument string for an XMI log | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | XMIARGTXT | Allow NULL? |
| 32 | ARGTYPE1 | Argument type of an XMI log entry | char | 1 | 0 | CHAR | (N' ') | Yes | | XMIARGTYP | Allow NULL? |
| 33 | MSGARG2 | Argument string for an XMI log | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | XMIARGTXT | Allow NULL? |
| 34 | ARGTYPE2 | Argument type of an XMI log entry | char | 1 | 0 | CHAR | (N' ') | Yes | | XMIARGTYP | Allow NULL? |
| 35 | MSGARG3 | Argument string for an XMI log | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | XMIARGTXT | Allow NULL? |
| 36 | ARGTYPE3 | Argument type of an XMI log entry | char | 1 | 0 | CHAR | (N' ') | Yes | | XMIARGTYP | Allow NULL? |
| 37 | MSGARG4 | Argument string for an XMI log | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | XMIARGTXT | Allow NULL? |
| 38 | ARGTYPE4 | Argument type of an XMI log entry | char | 1 | 0 | CHAR | (N' ') | Yes | | XMIARGTYP | Allow NULL? |
| 39 | MSGTEXT | Actual text of message | nvarchar | 128 | 0 | CHAR | (N' ') | Yes | | XMIMSGTXT | Allow NULL? |
| 40 | RC | Alert: Return Code | int | 10 | 0 | INT4 | ((0)) | Yes | | ALRETCODE | Allow NULL? |