SAPConsolidatedUserDuplicate Table

This table stores the data specific to an SAP consolidated user duplicate.

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 SAPConsolidatedUserDuplicate table

Database Column

Details

SAPConsolidatedUser DuplicateID

Type: integer. Key. Generated ID

A unique identifier for the SAP consolidated duplicate user.

SAPRecommendationSetID

Type: integer. Key

Foreign key to the SAP recommendation set that the duplicate user belongs to.

SAPConsolidatedUserID

Type: integer. Key

Foreign key to the SAP consolidated user linked to an SAP user.

SAPUserID

Type: integer. Key

Foreign key to the SAP user that the duplicate user belongs to.

IsConsolidatedBySAP

Type: boolean. Key

Whether or not this user is consolidated by SAP.