SAPDuplicateUserRecommendation Table

FlexNet Manager Suite (Cloud)

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

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

Database Column

Details

SAPDuplicateUser RecommendationID

Type: integer. Key. Generated ID

A unique identifier for the SAP duplicate user recommendation.

RecommendationUID

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.

DuplicateGroupNum

Type: integer

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

SAPUserID

Type: integer. Key. Nullable

The unique identifier of the user that the duplicate user recommendation belongs to.

UserName

Type: text

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

SystemID

Type: text

The ID of the system that the duplicate user recommendation belongs to.

ClientID

Type: text

The ID of the client that the duplicate user recommendation belongs to.

IsConsolidatedBySAP

Type: boolean

Whether or not this duplicate is consolidated by SAP.

SAPRuleID

Type: integer. Nullable

The unique identifier of the rule used to produce the duplicate user recommendation.

RuleSetName

Type: text. Nullable

The name of the rule set used to produce the duplicate user recommendation.

RuleName

Type: text. Nullable

The name of the rule used to produce the duplicate user recommendation.

RuleSequenceNumber

Type: integer. Nullable

The sequence number of the rule used to produce the duplicate user recommendation.

RuleMessage

Type: text. Nullable

The message produced given by the rule used to produce the duplicate user recommendation.

SAPRecommendation ProcessedStatusID

Type: integer

Foreign key to the SAP recommendation processed status of the duplicate user recommendation.

RuleMessageResourceName

Type: text (max 256 characters). Nullable

The resource name of the message produced given by the rule used to produce the duplicate user recommendation.

RuleMessageParameters

Type: text (max 256 characters). Nullable

The parameters used by the message produced given by the rule used to produce the duplicate user recommendation.

FlexNet Manager Suite (Cloud)

Current