The CRMC_FDT_ATTR table in SAP ERP or S/4HANA stores Rule Builder Attributes data. There are total 28 fields in CRMC_FDT_ATTR table. The Rule Builder Attributes 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_FDT_ATTR table. It is in Package for CRM Rule Builder Customizations (CRM_FDT_CUST) ABAP package and is part of the BRF Plus Rule Modeller (CRM-BF-BRF-RM) module.
SAP CRMC_FDT_ATTR Table Fields
Following is the list of fields that are available in SAP CRMC_FDT_ATTR table. The primary key fields of Rule Builder Attributes table in SAP are MANDT (Client), APPL_ID (Rule Policy Type ID), BO_ID (Condition Group ID), ATTR_ID (Attribute ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| APPL_ID | Rule Policy Type ID | CRMDT_FDT_APPLID | CRMC_FDT_APPL | CHAR (32) |
| BO_ID | Condition Group ID | CRMDT_FDT_ROID | CRMC_FDT_BO | CHAR (6) |
| ATTR_ID | Attribute ID | CRMDT_FDT_ATTRID | CHAR (30) | |
| HELP_TYPE | Rule Builder Attribute Help Type | CRMDT_FDT_HLP_TYPE | CHAR (1) | |
| SHOW_ATTR | Attribute Active | CRMDT_FDT_ATTR_ACTIVE | CHAR (1) | |
| DATA_TYPE | Rule Builder Attribute Data Type | CRMDT_FDT_DATA_TYPE | CHAR (1) | |
| OPTIONAL | Attribute Availability | CRMDT_FDT_OPTIONAL | CHAR (1) | |
| FDT_ATTR_GUID | Rule Builder: Universal Unique Identifier | CRMDT_FDT_GUID | CHAR (32) | |
| EQ | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| NE | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| BT | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| NB | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| CP | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| NP | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| LT | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| LE | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| GT | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| GE | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| FORMULA_FLAG | Formula Indicator | CRMDT_FDT_FORMULA_FLAG | CHAR (1) | |
| SAP_FLAG | SAP Indicator | CRMDT_SAP_FLAG | CHAR (1) | |
| IX | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| WL | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| WA | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| F4HELP | Data Element for F4 Help in Condition Attribute | CRMDT_FDT_F4HELP | CHAR (60) | |
| SUB_ATTR | Subattribute Indicator | CRMDT_FDT_SUB_ATTR | CHAR (1) | |
| I1 | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) | |
| I2 | Operator Active | CRMDT_FDT_OPERATOR | CHAR (1) |
