SAPRecommendationSetSummary Table

FlexNet Manager Suite (Cloud)

This table stores a history of SAP license positions.

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

Database Column

Details

SAPRecommendationSet SummaryID

Type: integer. Key. Generated ID

A unique identifier for the SAP license recommendation summary.

LandscapeUID

Type: text (max 128 characters). Key

A global unique identifier for the system landscape the summary belongs to.

RecommendationSetUID

Type: text (max 128 characters). Key

A global unique identifier for the SAP recommendation set the summary belongs to.

SAPRecommendationSet StatusID

Type: integer

The status of the recommendation set.

LicenseType

Type: text (max 2 characters). Key. Nullable

The license code to which the position applies.

EntitlementsPurchased

Type: integer

Total number of purchased license entitlements.

EntitlementsOriginal

Type: integer

Total number of consumed license entitlements.

EntitlementsRecommended

Type: integer

Total number of recommended license entitlements.

LicenseTypeUnitPrice

Type: currency. Nullable

The unit price of a license entitlement.

LicenseTypeUnitPrice RateID

Type: integer. Nullable

The unit price rate of a license entitlement.

CalculationDate

Type: datetime

The date of the license postion calculation.

EntitlementsOptimal

Type: integer

Total number of recommended license entitlements without license ratio constraints.

FlexNet Manager Suite (Cloud)

Current