SAPRuleSet Table

This table stores SAP rule sets used for recommending optimizations for SAP.

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

Database Column

Details

SAPRuleSetID

Type: integer. Key. Generated ID

A unique identifier for the SAP rule set.

RuleSetName

Type: text (max 128 characters)

Name of rule set.

RuleSetDescription

Type: text. Nullable

Description of rule set.

SAPSystemLandscapeID

Type: integer. Key

Foreign key to the system landscape that the SAP rule set belongs to.

IsActive

Type: boolean

Whether or not this rule set is used to automatically optimize SAP license assignments.

SequenceNumber

Type: integer

The sequence number used to designate the order of the rule sets within the landscape.

SAPRuleCategoryID

Type: integer. Key

Foreign key to the rule category of the SAP rule set.

NumberOfConsumptionMonth

Type: integer

ConsumptionMonthEndDate

Type: datetime. Nullable

End date of consumption period used for recommending optiomizations. If null,

CreationUser

Type: text (max 256 characters)

The user who created the system landscape.

CreationDate

Type: datetime

The data and time the system landscape was created.

UpdatedUser

Type: text (max 256 characters)

The last user who update the system landscape.

UpdatedDate

Type: datetime

The date and time the system landscape was last updated.

SecurityTypeID

Type: integer

Security type for this object. Foreign key to the SecurityType table.