SAP table SALRTCAT (Alert Category: Definition Table)
SAP table SALRTCAT has 2 primary key fields being MANDT,CATEGORY.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| CATEGORY | Alert Category | CHAR | 30 | 0 | SALRTDCAT | ||
| CLASS | Classification of Alert Category | CHAR | 30 | 0 | SALRTCATC | SALRTDCATC | |
| PRIORITY | Alert priority | CHAR | 1 | 0 | SALRTDPRIO | ||
| CONTDEF | ID for Parameter Condition | CHAR | 32 | 0 | SWJ_CONDID | ||
| MAXDELVRY | Maximum Number of Alert Deliveries | INT1 | 3 | 0 | SALRTDMAXD | ||
| ESCACTIVE | Escalation Active | CHAR | 1 | 0 | SALRTDESCA | ||
| ESCRECIPT | Escalation Recipient | CHAR | 12 | 0 | USR02 | SALRTDESCR | |
| ESCTOLTIME | Tolerance Time for Escalation in Minutes | DEC | 8 | 0 | SALRTDESCT | ||
| DYNTEXT | Dynamic Text | CHAR | 1 | 0 | SALRTDDYTX | ||
| EXPIRYTIME | Expiry Time in Minutes | DEC | 8 | 0 | SALRTDEXPI | ||
| NOEXTID | Do not insert an external alert ID | CHAR | 1 | 0 | SALRTDNOID | ||
| ORIGLANG | Original Language of the Alert Category | LANG | 1 | 0 | * | SALRTDORIGLANG | |
| DEVCLASS | Application Package of the Alert Category | CHAR | 30 | 0 | * | SALRTDDEVCLASS |
SALRTCAT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 SALRTCAT | CLASS | SALRTCATC | Alert Category: Classifications | MANDT |
| 0 SALRTCAT | CLASS | SALRTCATC | Alert Category: Classifications | CLASS |
| 1 SALRTCAT | ESCRECIPT | USR02 | Logon Data (Kernel-Side Use) | BNAME |