The CRMS4C_IU_THFLT table in SAP ERP or S/4HANA stores Filter Definition for Tree Profil Hierachy Node data. There are total 9 fields in CRMS4C_IU_THFLT table. The Filter Definition for Tree Profil Hierachy Node 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 CRMS4C_IU_THFLT table. It is in S4CRM-IS Utilities: UI IC Tools (CRMS4_IU_IC_TOOLS) ABAP package and is part of the S4CRM: Utilities Industry (CRM-S4-IU) module.
SAP CRMS4C_IU_THFLT Table Fields
Following is the list of fields that are available in SAP CRMS4C_IU_THFLT table. The primary key fields of the table are MANDT (Client), PROF_ID (Profile Name of Tree Hierarchy), ID (Filter Name), NODE_ID (Node ID), ATTR_NAME (Attribute Name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| PROF_ID | Profile Name of Tree Hierarchy | CRMT_TREE_PROFILE | CRM_ISUTREE_PROF | CHAR (10) |
| ID | Filter Name | CRMS4_IU_TPFLT_ID | CRMS4C_IU_TPFLT | CHAR (20) |
| NODE_ID | Node ID | CRMT_NODE_ID | CRM_ISUTREE_HIER | CHAR (10) |
| ATTR_NAME | Attribute Name | CRMS4_IU_THFLT_ATTR_NAME | * | CHAR (30) |
| FILTER_SIGN | Inclusion/exclusion criterion SIGN for range tables | BAPISIGN | CHAR (1) | |
| FILTER_OPTION | Selection operator OPTION for range tables | BAPIOPTION | CHAR (2) | |
| FILTER_LOW | Low Value in Range | CRMS4_IU_RANGE_VALUE_LOW | CHAR (200) | |
| FILTER_HIGH | High Value in Range | CRMS4_IU_RANGE_VALUE_HIGH | CHAR (200) |
