SAPConsolidatedUser Table

FlexNet Manager Suite (Cloud)

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

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

Database Column

Details

SAPConsolidatedUserID

Type: integer. Key. Generated ID

A unique identifier for the SAP consolidated user.

UserUID

Type: text (max 128 characters). Key

A globally unique identifier for the SAP license recommendation.

SAPRecommendationSetID

Type: integer. Key

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

SAPUserID

Type: integer. Key

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

UserName

Type: text

The user name of the user that the duplicate user recommendation belongs to.

DuplicateGroupNum

Type: integer

The unique identifier showing which users are duplicates of one another.

LicenseType

Type: text (max 2 characters). Nullable

The license code originally assigned to the user.

IsConsolidatedBySAP

Type: boolean

Whether or not this user is consolidated by SAP.

OptimalLicenseType

Type: text (max 2 characters). Nullable

The license code recommended the user be assigned ignoring license ratios and rebalancing.

FlexNet Manager Suite (Cloud)

Current