SAPLicenseRecommendation Table

This table stores the data specific to an SAP license 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 SAPLicenseRecommendation table

Database Column

Details

SAPLicense RecommendationID

Type: integer. Key. Generated ID

A unique identifier for the SAP license 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 license recommendation belongs to.

SAPUserID

Type: integer. Key. Nullable

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

UserName

Type: text

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

SystemID

Type: text

The ID of the system that the license recommendation belongs to.

ClientID

Type: text

The ID of the client that the license recommendation belongs to.

OriginalLicenseType

Type: text (max 2 characters). Nullable

The license code originally assigned to the user.

RecommendedLicenseType

Type: text (max 2 characters). Nullable

The license code recommended the user be assigned.

SAPRuleID

Type: integer. Nullable

The unique identifier of the rule used to produce the license recommendation.

RuleSetName

Type: text. Nullable

The name of the rule set used to produce the license recommendation.

RuleName

Type: text. Nullable

The name of the rule used to produce the license recommendation.

RuleSequenceNumber

Type: integer. Nullable

The sequence number of the rule used to produce the license recommendation.

RuleMessage

Type: text. Nullable

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

SAPRecommendation ProcessedStatusID

Type: integer

Foreign key to the SAP recommendation processed status of the license recommendation.

OptimalLicenseType

Type: text (max 2 characters). Nullable

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

SAPRecommendation AdjustmentReasonID

Type: integer. Nullable

The unique identifier of the reason why the license recommendation differs from optimal.

RuleMessageResourceName

Type: text (max 256 characters). Nullable

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

RuleMessageParameters

Type: text (max 256 characters). Nullable

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