SAPRuleSet Table
This table stores SAP rule sets used for recommending optimizations for SAP.
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.
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 |