The CIF_USER_PREF table in SAP ERP or S/4HANA stores User Settings data. There are total 2 fields in CIF_USER_PREF table. The 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_USER_PREF table. It is in Core Interface (CIF) ABAP package and is part of the Interfaces (SCM-APO-INT) module.
SAP CIF_USER_PREF Table Fields
Following is the list of fields that are available in SAP CIF_USER_PREF table. The primary key fields of the table are PGMID (ABAP Program Name), USERNAME (User Name).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| PGMID | ABAP Program Name | PROGNAME | CHAR (40) | |
| USERNAME | User Name | USERNAME | CHAR (12) |
