| 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 | PARENT_KEY | Key for Cache Entries | varbinary | 16 | 0 | RAW | | Yes | | SCMC_CACHE_KEY | |
| 3 | OBJECT_NAME | Complete Object Name of All Domain Model Objects | nvarchar | 250 | 0 | CHAR | (N' ') | Yes | | SCMC_DM_OBJECT_NAME | Allow NULL? |
| 4 | OBJECT_TYPE | Data Type of the Node | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | SCMC_OBJECT_TYPE | Allow NULL? |
| 5 | MODIFY_TIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | decimal | 15 | 0 | DEC | ((0)) | Yes | | TIMESTAMP | |
| 6 | MONI_NAME | Name of a monitor in the CCMS monitoring infrastructure | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ALTRINNM | Allow NULL? |
| 7 | MS_NAME | Alerts: Name of a monitor set | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ALMONISET | Allow NULL? |
| 8 | MTSYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 9 | MTMCNAME | Alert: Name of Monitoring Context | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMCNAME | Allow NULL? |
| 10 | MTNUMRANGE | Alert: monitoring type number range (perm., temp, ...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ALTIDNUMRG | Allow NULL? |
| 11 | MTUID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDUID | Allow NULL? |
| 12 | MTCLASS | Alert: monitoring type class (perf., single msg.,...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ALTIDMTCL | Allow NULL? |
| 13 | MTINDEX | Alert: internal handle for TID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDINDEX | Allow NULL? |
| 14 | EXTINDEX | Alert: internal handle for TID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDINDEX | Allow NULL? |
| 15 | ALTREENUM | Alert: MT Tree info: Number of tree | int | 10 | 0 | INT4 | ((0)) | Yes | | ALTREENUM | Allow NULL? |
| 16 | ALIDXINTRE | Alert: Tree Info: Index of MT in Tree | int | 10 | 0 | INT4 | ((0)) | Yes | | ALIDXINTRE | Allow NULL? |
| 17 | ALLEVINTRE | Alert: Tree Info: Level of MTE in Tree | int | 10 | 0 | INT4 | ((0)) | Yes | | ALLEVINTRE | Allow NULL? |
| 18 | ALPARINTRE | Alert: Tree Info: Index of Parent of MT in Tree | int | 10 | 0 | INT4 | ((0)) | Yes | | ALPARINTRE | Allow NULL? |
| 19 | OBJECTNAME | Alert: Name of Monitoring Object | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMOBJECT | Allow NULL? |
| 20 | MTNAMESHRT | Alert: Short Name of Monitoring Type | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMTNAMESH | Allow NULL? |
| 21 | CUSGRPNAME | Alert: Customization: Name of Customization Group | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALCUSGROUP | Allow NULL? |
| 22 | DELIVERSTA | Alert: MT Val: Delivery Status | int | 10 | 0 | INT4 | ((0)) | Yes | | ALDELIVSTA | Allow NULL? |
| 23 | HIGHALVAL | Alert: alert value (1 = green, 2 = yellow, ....) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALVALUE | Allow NULL? |
| 24 | HIGHALSEV | Alert: severity (alerts, monitoring type custom..) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALSEVERITY | Allow NULL? |
| 25 | ALSYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 26 | MSEGNAME | Alert: Name of Monitoring Segment | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMSEGNAME | Allow NULL? |
| 27 | ALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALAIDUID | Allow NULL? |
| 28 | ALINDEX | Alert: internal handle | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALINDEX | Allow NULL? |
| 29 | ALERTDATE | Alert: date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALDATE | Allow NULL? |
| 30 | ALERTTIME | Alert: Time value in timeformat | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ALTIME | Allow NULL? |
| 31 | DUMMYALIGN | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ALDUMMYC2 | Allow NULL? |
| 32 | LASTVALDAT | Alert: date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALDATE | Allow NULL? |
| 33 | LASTVALTIM | Alert: Time value in timeformat | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ALTIME | Allow NULL? |
| 34 | LASTVALDUM | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ALDUMMYC2 | Allow NULL? |
| 35 | ACTUALVAL | Alert: alert value (1 = green, 2 = yellow, ....) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALVALUE | Allow NULL? |
| 36 | ACTUALSEV | Alert: severity (alerts, monitoring type custom..) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALSEVERITY | Allow NULL? |
| 37 | VALSYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 38 | VMSEGNAME | Alert: Name of Monitoring Segment | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMSEGNAME | Allow NULL? |
| 39 | VALUNIQNUM | Alert: Unique Identifier to be used in AID (char10) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALAIDUID | Allow NULL? |
| 40 | VALINDEX | Alert: internal handle | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALINDEX | Allow NULL? |
| 41 | VALERTDATE | Alert: date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALDATE | Allow NULL? |
| 42 | VALERTTIME | Alert: Time value in timeformat | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ALTIME | Allow NULL? |
| 43 | VALERTDUM | Alert: Dummy field. Purpose: Alignment of date/time 16 byte | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ALDUMMYC2 | Allow NULL? |
| 44 | COUNTOFACT | Alert: MT Val: Count of active Alerts | int | 10 | 0 | INT4 | ((0)) | Yes | | ALCNTACTAL | Allow NULL? |
| 45 | COUNTSUM | Alert: MT Val: Sum of Alerts in MT | int | 10 | 0 | INT4 | ((0)) | Yes | | ALCNTSUMAL | Allow NULL? |
| 46 | VISUSERLEV | Alert: MTE type dev cust: Visible on user level (op,exp,dev) | int | 10 | 0 | INT4 | ((0)) | Yes | | ALVISILEVL | Allow NULL? |
| 47 | TDSTATUS | Alert: MT: Type Def Status | int | 10 | 0 | INT4 | ((0)) | Yes | | ALTDSTATUS | Allow NULL? |