SAPRecommendationSetSummary Table

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.