The CRMC_BP_UM_EMAIL table in SAP ERP or S/4HANA stores Customizing table for email notification in User Mgmt data. There are total 14 fields in CRMC_BP_UM_EMAIL table. The Customizing table for email notification in User Mgmt table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMC_BP_UM_EMAIL table. It is in Package for email notifications in User Management (CRM_BUPA_ACTION) ABAP package and is part of the Business Partners (CRM-MD-BP) module.
SAP CRMC_BP_UM_EMAIL Table Fields
Following is the list of fields that are available in SAP CRMC_BP_UM_EMAIL table. The primary key fields of Customizing table for email notification in User Mgmt table in SAP are MANDT (Client), UI_ROLE (Business Role), USER_TYPE (User type either Internal or External user).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| UI_ROLE | Business Role | CRMT_UI_PROFILE | CRMC_UI_PROFILE | CHAR (12) |
| USER_TYPE | User type either Internal or External user | BP_UM_USER_TYPE | INT1 (3) | |
| CREATE_USER | Enable/Disable E-Mail Notification When New User Is Created | NOTIFY_USER_CREATE | CHAR (1) | |
| PASSWORD_CHANGE | Enable/Disable E-Mail Notification when Password Is Changed | NOTIFY_PWD_CHANGE | CHAR (1) | |
| LOCK_USER | Enable/Disable E-Mail Notification When A User Is Locked | NOTIFY_USER_LOCK | CHAR (1) | |
| UNLOCK_USER | Enable/Disable E-Mail Notification When A User Is Unlocked | NOTIFY_USER_UNLOCK | CHAR (1) | |
| DELETE_USER | Enable/Disable E-Mail Notification When A User Is Deleted | NOTIFY_USER_DELETE | CHAR (1) | |
| FUTURE_EVENT1 | Enable/Disable E-Mail Notification For Future Action | NOTIFY_FUTURE_EVENT | CHAR (1) | |
| FUTURE_EVENT2 | Enable/Disable E-Mail Notification For Future Action | NOTIFY_FUTURE_EVENT | CHAR (1) | |
| FUTURE_EVENT3 | Enable/Disable E-Mail Notification For Future Action | NOTIFY_FUTURE_EVENT | CHAR (1) | |
| FUTURE_EVENT4 | Enable/Disable E-Mail Notification For Future Action | NOTIFY_FUTURE_EVENT | CHAR (1) | |
| FUTURE_EVENT5 | Enable/Disable E-Mail Notification For Future Action | NOTIFY_FUTURE_EVENT | CHAR (1) | |
| TEMPLATE | Template for E-Mail Notification | SF_TEMPLATE_NAME | STXFADM | CHAR (30) |
