SAPCompositeRole Table

This table stores SAP composite roles.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for SAPCompositeRole table

Database Column

Details

SAPCompositeRoleID

Type: integer. Key. Generated ID

A unique identifier for SAP composite role.

CompositeRoleID

Type: integer. Key

Foreign key to SAP role which contain one or more single roles.

SingleRoleID

Type: integer. Key

Foreign key to SAP role that is a member if the composite role.