The CMCBC_NOTIFY_CTL table in SAP ERP or S/4HANA stores Cash Budgeting Notification and Alert Control data. There are total 18 fields in CMCBC_NOTIFY_CTL table. The Cash Budgeting Notification and Alert Control 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 CMCBC_NOTIFY_CTL table. It is in Service for Cash Budgeting (EA_FIN_CM_CB_PLANNING_SRV) ABAP package and is part of the Cash Budgeting China (FI-LOC-CB-CN) module.
SAP CMCBC_NOTIFY_CTL Table Fields
Following is the list of fields that are available in SAP CMCBC_NOTIFY_CTL table. The primary key fields of the table are MANDT (Client), CB_AREA (Cash Budget Area), CYCLE_TYPE (Cycle Type).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| CB_AREA | Cash Budget Area | CMCB_CB_AREA | CMCBC_CBAREA_T | CHAR (4) |
| CYCLE_TYPE | Cycle Type | CMCB_CYCLE_TP | CMCBC_CYCLE_TP_T | CHAR (4) |
| NOTIFY_FLAG | Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘) | BOOLE_D | CHAR (1) | |
| ALERT_FLAG | Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘) | BOOLE_D | CHAR (1) | |
| NOTE_CB_APPROVE | Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘) | BOOLE_D | CHAR (1) | |
| NOTE_CB_COMPLETE | Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘) | BOOLE_D | CHAR (1) | |
| ALERT_DEADLINE | Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘) | BOOLE_D | CHAR (1) | |
| ALERT_DAY | Alert days before deadline | CMCB_ALERT_DAY | INT1 (3) | |
| ALERT_CON | Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘) | BOOLE_D | CHAR (1) | |
| ALT_TOL_AMT | Target length CURR(23,2) Output 30 | AFLEX17D2O22N | CURR (23) | |
| ALERT_TOL_PER | Alert percentage | CMCB_ALERT_PER | NUMC (3) | |
| ALT_TOL_CURR | Currency Key | WAERS | CUKY (5) | |
| NOTE_BLOCK | Data element for domain BOOLE: TRUE (=’X’) and FALSE (=’ ‘) | BOOLE_D | CHAR (1) | |
| PS_CTGY_APP | Cash budgeting position category | CMCB_PS_CTGY | CMCBC_PS_CTGY | CHAR (4) |
| PS_CTGY_COMP | Cash budgeting position category | CMCB_PS_CTGY | CMCBC_PS_CTGY | CHAR (4) |
| PS_CTGY_BLOCK | Cash budgeting position category | CMCB_PS_CTGY | CMCBC_PS_CTGY | CHAR (4) |
| PS_CTGY_ALERT | Cash budgeting position category | CMCB_PS_CTGY | CMCBC_PS_CTGY | CHAR (4) |
