SALRTDLVRY SAP (Alert Assignment (Personalization)) Table details
Dictionary Type: Table
Description: Alert Assignment (Personalization)
Description: Alert Assignment (Personalization)
Table field list including key, data, relationships and ABAP select examples
SALRTDLVRY is a standard SAP Table which is used to store Alert Assignment (Personalization) data and is available within R/3 SAP systems depending on the version and release level.
The SALRTDLVRY table consists of various fields, each holding specific information or linking keys about Alert Assignment (Personalization) data available in SAP. These include UNAME (Alert Recipients), NO_POPUP (Indicator: Do Not Send Dialog Box for Incoming New Alert), EMAIL (Send Alert by E-Mail), EMAIL_XML (Notification by Mail and XML Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP SALRTDLVRY table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| UNAME | Alert Recipients | SALRTDRCPT | CHAR | 12 | Assigned to domain | XUBNAME | |||
| NO_POPUP | Indicator: Do Not Send Dialog Box for Incoming New Alert | SALRTDNPUP | CHAR | 1 | BOOLE | ||||
| Send Alert by E-Mail | SALRTDMAIL | CHAR | 1 | BOOLE | |||||
| EMAIL_XML | Notification by Mail and XML Document | SALRTDMLX | CHAR | 1 | BOOLE | ||||
| PAGER | Indicator: Send Alert Via SMS or To a Pager | SALRTDPAGR | CHAR | 1 | BOOLE | ||||
| EXTALRTSYS | Send Alert Via External Alert System | SALRTDEXT | CHAR | 1 | BOOLE | ||||
| ALRTSYSTEM | External Alert System | SALRTDESY | CHAR | 30 | CHAR30 | ||||
| SOUND | Indicator: Acoustic Signal for New Incoming Alert | SALRTDSND | CHAR | 1 | BOOLE | ||||
| PROXY_ACT | Substitution Active | SALRTDPACT | CHAR | 1 | BOOLE | ||||
| PROXY | Substitute | SALRTDPRX | CHAR | 12 | UNAME | ||||
| MAIL_RULE | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR | 25 | TEXT25 | ||||
| SMS_RULE | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR | 25 | TEXT25 | ||||
| USE_RULES | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| SMSONHOLD | Delivery by SMS on Public Holidays | SALRTDSMSH | CHAR | 1 | CHAR1 | ||||
| MAILONHOLD | Delivery by Fax on Public Holidays | SALRTDINTH | CHAR | 1 | CHAR1 | ||||
| FACTORYCAL | Factory Calendar | WFCID | CHAR | 2 | Assigned to domain | WFCID | FCI | ||
| FAX_RULE | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR | 25 | TEXT25 | ||||
| FAXONHOLD | Delivery by Fax on Public Holidays | SALRTDFAXH | CHAR | 1 | CHAR1 | ||||
| FAX | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| XML | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| XML_RULE | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR | 25 | TEXT25 | ||||
| XMLONHOLD | Delivery by External Tool (XML) on Public Holidays | SALRTDXMLH | CHAR | 1 | CHAR1 | ||||
| WAP | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
| WAP_RULE | Internal Identification of Rules of Periodic Appointments | SC_RULEID | CHAR | 25 | TEXT25 | ||||
| WAPONHOLD | Delivery by WAP Push on Public Holidays | SALRTDWAPH | CHAR | 1 | CHAR1 |
| Key field | Non-key field |
How do I retrieve data from SAP table SALRTDLVRY using ABAP code
The following ABAP code Example will allow you to do a basic selection on SALRTDLVRY to SELECT all data from the tableDATA: WA_SALRTDLVRY TYPE SALRTDLVRY.
SELECT SINGLE *
FROM SALRTDLVRY
INTO CORRESPONDING FIELDS OF WA_SALRTDLVRY
WHERE...
How to access SAP table SALRTDLVRY
Within an ECC or HANA version of SAP you can also view further information about SALRTDLVRY and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects