| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | SYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | No | | SYSYSID | Allow NULL? |
| 2 | CONTEXT | Alert: Name of Monitoring Context | nvarchar | 40 | 0 | CHAR | (N' ') | No | | ALMCNAME | Allow NULL? |
| 3 | SEGMENT | Alert: Name of Monitoring Segment | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMSEGNAME | Allow NULL? |
| 4 | CONTXTSTAT | Alert: Status of Context (active/inactive/....) | char | 1 | 0 | CHAR | (N' ') | Yes | | ALCONTSTAT | Allow NULL? |
| 5 | CTXCLASS | Alert: Customization: Name of Customization Group | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALCUSGROUP | Allow NULL? |
| 6 | CTXOWNER | Alert: Owner of Monitoring Context | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMCOWNER | Allow NULL? |
| 7 | CTXCLIENT | Client ID | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | SYMANDT | Allow NULL? |
| 8 | CSMSYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 9 | CONTXTTYPE | Alert: Type of Monitoring Context | int | 10 | 0 | INT4 | ((0)) | Yes | | ALMCTYPE | Allow NULL? |
| 10 | CHG_USER | Alert: Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ALCHGUSER | Allow NULL? |
| 11 | CHG_DATE | Alert: Date of last change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ALCHGDATE | Allow NULL? |
| 12 | CHG_TIME | Alert: Time of last change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ALCHGTIME | Allow NULL? |
| 13 | CTX_SYSID | Name of SAP System | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | SYSYSID | Allow NULL? |
| 14 | CTX_MCNAME | Alert: Name of Monitoring Context | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ALMCNAME | Allow NULL? |
| 15 | CTX_NUMRNG | Alert: monitoring type number range (perm., temp, ...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ALTIDNUMRG | Allow NULL? |
| 16 | CTX_UID | ALert: Unique Identifier for Monitoring Types (used in TID) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDUID | Allow NULL? |
| 17 | CTX_CLAS | Alert: monitoring type class (perf., single msg.,...) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ALTIDMTCL | Allow NULL? |
| 18 | CTX_INDEX | Alert: internal handle for TID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDINDEX | Allow NULL? |
| 19 | CTX_EXTIDX | Alert: internal handle for TID | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ALTIDINDEX | Allow NULL? |
| 20 | RESERVE_C | | nvarchar | 10 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 21 | RESERVE_I | | int | 10 | 0 | | ((0)) | Yes | | | Allow NULL? |