SAPSystemLandscapeEngineMapping Table

This table stores mapping between SAP system landscape engines 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 SAPSystemLandscapeEngineMapping table

Database Column

Details

SAPSystemLandscape EngineMappingID

Type: integer. Key. Generated ID

A unique identifier for the SAP system landscape engine mapping.

SAPSystemLandscape EngineID

Type: integer. Key

Foreign key to SAPSystemLandscapeEngine 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.