SAPEngineConsumptionSummary Table

This table stores the total consumption of SAP package consumption 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 SAPEngineConsumptionSummary table

Database Column


SAPEngineConsumption SummaryID

Type: integer. Key. Generated ID

A unique identifier for the SAP engine consumption.


Type: text (max 128 characters)

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


Type: text (max 128 characters)

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

SAPRecommendationSet StatusID

Type: integer

The status of the recommendation set.

SAPSystemLandscape EngineID

Type: integer. Key. Nullable

A unique identifier for the SAP system landscape engine table.


Type: text (max 128 characters)

A global unique identifier for the SAP engine in a system landscape.


Type: text (max 128 characters)

Name of engine.


Type: decimal. Nullable

The number of consumed units for the package (null = indeterminate)


Type: text. Nullable

Unit description to describe the consumption amount.


Type: text. Nullable

And optional message detailing the reason for the consumed result.


Type: integer

Total number of purchased license entitlements.


Type: currency. Nullable

The unit price of a license entitlement.


Type: integer. Nullable

The unit price rate of a license entitlement.


Type: datetime

The date of the license postion calculation.


Type: datetime

The date the system measurement calculation was performed.