SAPEngineConsumptionSummary Table

FlexNet Manager Suite 2020 R1 (On-Premises)

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

Details

SAPEngineConsumption SummaryID

Type: integer. Key. Generated ID

A unique identifier for the SAP engine consumption.

LandscapeUID

Type: text (max 128 characters)

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

RecommendationSetUID

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.

EngineUID

Type: text (max 128 characters)

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

EngineName

Type: text (max 128 characters)

Name of engine.

Consumed

Type: decimal. Nullable

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

ConsumptionUnit

Type: text. Nullable

Unit description to describe the consumption amount.

ReasonMessage

Type: text. Nullable

And optional message detailing the reason for the consumed result.

EntitlementsPurchased

Type: integer

Total number of purchased license entitlements.

EngineUnitPrice

Type: currency. Nullable

The unit price of a license entitlement.

EngineUnitPriceRateID

Type: integer. Nullable

The unit price rate of a license entitlement.

CalculationDate

Type: datetime

The date of the license postion calculation.

SystemMeasurementDate

Type: datetime

The date the system measurement calculation was performed.

FlexNet Manager Suite (On-Premises)

2020 R1