SAP CIF_USER_PREF User Settings Table data and field list

CIF_USER_PREF is a standard SAP Table which is used to store User Settings data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The CIF_USER_PREF table consists of various fields, each holding specific information or linking keys about User Settings data available in SAP. These include USERNAME (User name), LAY_STORE_MODE (Mode for Layout Storage), BUFFER_MODE (Buffering Mode)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

CIF_USER_PREF table Technical Details:

Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP CIF_USER_PREF table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the CIF_USER_PREF table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Key field

Non-key field

How do I retrieve data from SAP table CIF_USER_PREF using ABAP code

The following ABAP code Example will allow you to do a basic selection on CIF_USER_PREF to SELECT all data from the table
DATA: WA_CIF_USER_PREF TYPE CIF_USER_PREF.

SELECT SINGLE *
FROM CIF_USER_PREF
INTO CORRESPONDING FIELDS OF WA_CIF_USER_PREF
WHERE...

How to access SAP table CIF_USER_PREF

Within an ECC or HANA version of SAP you can also view further information about CIF_USER_PREF and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).