SAPSystemLandscapeLicenseType Table

This table stores SAP license types belonging to SAP system landscapes.

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

Database Column

Details

SAPSystemLandscape LicenseTypeID

Type: integer. Key. Generated ID

A unique identifier for SAP system landscape license type.

SAPSystemLandscapeID

Type: integer. Key

Foreign key to SAP system landscape.

Identifier

Type: text (max 2 characters). Key

The SAP license type identifier.

ShortName

Type: text (max 128 characters). Nullable

The SAP license type short name.

LongName

Type: text (max 256 characters). Nullable

The SAP license type long name.

Active

Type: boolean

Indicate whether the SAP license is active or not.

IsS4HanaRecommended

Type: boolean

Indicates whether the license type is included in Recommended license types for S/4HANA in License Assignment Rule.

NumberPurchased

Type: integer. Nullable

Number purchased.

UnitPrice

Type: currency. Nullable

Unit price of an SAP license type.

UnitPriceRateID

Type: integer. Nullable

The unit price rate of an SAP license type.

CreationUser

Type: text (max 128 characters). Nullable

The user who created the SAP license type.

CreationDate

Type: datetime

The data and time the SAP license type was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The last user who update the SAP license type.

UpdatedDate

Type: datetime

The date and time the SAP license type was last updated.

AllowLicenseBalancing

Type: boolean

Indicates whether license types can be rebalanced to use excess purchases of higher license types.