The CIF_PREF_INDX table in SAP ERP or S/4HANA stores Cluster Table for Storing User Settings data. There are total 7 fields in CIF_PREF_INDX table. The Cluster Table for Storing User Settings 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 CIF_PREF_INDX table. It is in Core Interface (CIF) ABAP package and is part of the Interfaces (SCM-APO-INT) module.
SAP CIF_PREF_INDX Table Fields
Following is the list of fields that are available in SAP CIF_PREF_INDX table. The primary key fields of the table are MANDT (Client), RELID (Region in IMPORT/EXPORT Data Table), SRTFD (User-defined key in table INDX), SRTF2 (Next record counter in EXPORT/IMPORT data tables).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| RELID | Region in IMPORT/EXPORT Data Table | INDX_RELID | CHAR (2) | |
| SRTFD | User-defined key in table INDX | INDX_SRTFD | CHAR (22) | |
| SRTF2 | Next record counter in EXPORT/IMPORT data tables | INDX_SRTF2 | INT4 (10) | |
| USERA | User Name | USERNAME | CHAR (12) | |
| CLUSTR | Length field for user data in EXPORT/IMPORT tables | INDX_CLSTR | INT2 (5) | |
| CLUSTD | Data field for IMPORT/EXPORT database tables | INDX_CLUST | LRAW (2886) |
