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	2023.0.2
Tablespace	COCKPIT_DATA
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	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	VARCHAR(255), NULL

ITEM

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

USERLOGIN

Definition	The SAP CC user login of the setting. The user is the owner of the setting.
Type	VARCHAR(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