SETTING

User Settings (Technical Data)

Definition

The SETTING table contains the SAP CC user settings (aka preferences) for the Cockpit user interface

Description

The SETTING table contains the user settings (aka user preferences) of the SAP CC users for the Cockpit user interface. The settings relate to the Cockpit launchpad or to a given app.

The possible settings are:

• User settings such as language, visual theme (for the appearance)
• Fiori variants that store settings for custom dashboards or views in certain apps of the Cockpit user interface

Note that the settings for the user notification management are stored in the NOTIFICATIONSETTING database table.

Technical Data

Schema Version	2022.0.2
Partitioned	No

Summary

The SETTING table is defined by the following columns in your back-end database. See the column details for more information.

Name	PK	FK	IX	Uses	Used by	Definition
ID	PK_SETTING					The unique identifier of the setting
CONTAINER						The container of the setting, defining its technical domain of application
ITEM						The item of the setting to configure
USERLOGIN						The SAP CC user login of the setting. The user is the owner of the setting.
VALUE						The value of the setting

Column Details

The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

ID

Definition	The unique identifier of the setting
Type	DECIMAL(28), NOT NULL
Primary Key	PK_SETTING

CONTAINER

Definition	The container of the setting, defining its technical domain of application
Type	NVARCHAR(255), NULL

ITEM

Definition	The item of the setting to configure
Type	NVARCHAR(255), NULL

USERLOGIN

Definition	The SAP CC user login of the setting. The user is the owner of the setting.
Type	NVARCHAR(255), NULL

VALUE

Definition	The value of the setting
Type	CLOB, NULL

Primary Key Details

See the primary key information:

PK_SETTING

Column(s)	ID
Tablespace	COCKPIT_INDX