SAPSoftwareLicense Table

SAPSoftwareLicense stores additional SAP-specific licensing information for SAP licenses.

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

Database Column

Details

SoftwareLicenseID

Type: integer. Key

The SAP license. Foreign key to the SoftwareLicense table.

SAPServerName

Type: text (max 256 characters). Nullable

The name of the SAP server. Should match the ComputerName of the record in the ComplianceComputer table which corresponds to the computer on which SAP is installed.

SAPBaseLicenseTypeID

Type: integer

The SAP base license type, coming from the first pair of symbols in the “xx-xx-xx” license code. Foreign key to the SAPSoftwareLicenseType table.

SAPSpecialVersionID

Type: integer

The SAP special version (language, country, etc.), coming from the second pair of symbols in the “xx-xx-xx” license type code. Foreign key to the SAPSoftwareLicenseType table.

SAPSurchargeID

Type: integer

The SAP surcharge special version, coming from the third pair of symbols in the “xx-xx-xx” license code. Foreign key to the SAPSoftwareLicenseType table

SAPLicenseCode

Type: text (max 32 characters)

The SAP license code, consisting of the license type, special version and surcharge.

HasUsage

Type: boolean

Set this field to True if this license contains SAP usage/optimization information.

Description

Type: text (max 512 characters). Nullable

A decription of the SAP license.