USER_RIGHT_ASSIGNMENT

SAP CC User Right Assignments (Technical Settings)

Definition

The USER_RIGHT_ASSIGNMENT table links an SAP CC user to a client context. Each row represents one assignment of a user to a client, with its associated catalog.

Description

The USER_RIGHT_ASSIGNMENT table is an intermediate entity between HCI_USER and USER_RIGHT / OBJECT_ACCESS_RULE. It links an SAP CC user to a client context (client number and catalog name). A user can have multiple assignments, each representing an independent security domain with its own roles and permissions. A system-level assignment has a null client number.

Technical Data

Schema Version	2025.0.2
Tablespace	CATALOG_DATA
Partitioned	No

Summary

The USER_RIGHT_ASSIGNMENT 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
OID						The unique identifier of the assignment, generated by the SAP CC system
USER_OID			IX_URA_USER	HCI_USER (OID)		The unique ID of the SAP CC user as defined in the HCI_USER table
CLIENT_NUMBER						The client number associated to this assignment. Null means the assignment is at system scope (not client-specific).
CATALOG_NAME						The name of the pricing catalog associated to this assignment More...

Column Details

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

OID

Definition	The unique identifier of the assignment, generated by the SAP CC system
Type	DECIMAL(28), NOT NULL

USER_OID

Definition	The unique ID of the SAP CC user as defined in the HCI_USER table
Type	DECIMAL(28), NOT NULL
Available Index	IX_URA_USER

CLIENT_NUMBER

Definition	The client number associated to this assignment. Null means the assignment is at system scope (not client-specific).
Type	DECIMAL(3), NULL

CATALOG_NAME

Definition	The name of the pricing catalog associated to this assignment
Description	The field CATALOG_NAME is the identification codename
Format	If this field is not set, the SAP CC user has access to objects from every pricing catalog configured in the SAP CC system. If this field is set with the name of a catalog, the user only has access to the objects contained in this catalog.
Type	VARCHAR(64), NULL

Index Details

The following database indexes are available in the USER_RIGHT_ASSIGNMENT database table to improve the speed of data retrieval operations during the business processes of SAP Convergent Charging:

IX_URA_USER

Indexed Column(s)	USER_OID
Unique	No
Partitioned	No
Tablespace	CATALOG_INDX