SAPEngineSystemConsumption Table

FlexNet Manager Suite 2020 R1 (On-Premises)

This table stores the per-system 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 SAPEngineSystemConsumption table

Database Column

Details

SAPEngineSystem ConsumptionID

Type: integer. Key. Generated ID

A unique identifier for the SAP engine consumption.

SAPRecommendationSetID

Type: integer. Key

Foreign key to the SAP recommendation set that the license recommendation belongs to.

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.

SAPSystemID

Type: integer. Key. Nullable

The unique identifier of the system that the consumed count 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.

Consumed

Type: decimal. Nullable

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

ReasonMessage

Type: text. Nullable

And optional message detailing the reason for the consumed result.

SystemMeasurementDate

Type: datetime. Nullable

The date the system measurement calculation was performed.

FlexNet Manager Suite (On-Premises)

2020 R1