The CRMS4C_IU_TPSRT table in SAP ERP or S/4HANA stores Sort Definition for Tree Profil data. There are total 5 fields in CRMS4C_IU_TPSRT table. The Sort Definition for Tree Profil 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_TPSRT 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_TPSRT Table Fields
Following is the list of fields that are available in SAP CRMS4C_IU_TPSRT table. The primary key fields of the table are MANDT (Client), PROF_ID (Profile Name of Tree Hierarchy), ID (Sort Order 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 | Sort Order Name | CRMS4_IU_TPSRT_ID | CHAR (20) | |
| ACTIVE | Active | CRMS4_IU_TPSRT_ACTIVE | CHAR (1) | |
| SORT_ORDER | Sort Order | CRMS4_IU_TPSRT_ORDER | NUMC (3) |
