SAPRuleMapping Table

FlexNet Manager Suite 2020 R1 (On-Premises)

This table stores mapping between SAP rule to either System Landscapes, System Groups or SAP systems.

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

Database Column

Details

SAPRuleMappingID

Type: integer. Key. Generated ID

A unique identifier for the SAP rule set mapping.

SAPRuleID

Type: integer. Key

Foreign key to SAP Rule ID

SAPSystemLandscapeID

Type: integer. Key. Nullable

Foreign key to System Landscape ID

SAPSystemGroupID

Type: integer. Key. Nullable

Foreign key to System Group ID.

SAPSystemID

Type: integer. Key. Nullable

Foreign key to the SAP system.

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.

FlexNet Manager Suite (On-Premises)

2020 R1