SAPSystemLandscape Table

FlexNet Manager Suite (Cloud)

This table stores the data specific to the definition of system landscapes.

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

Database Column

Details

SAPSystemLandscapeID

Type: integer. Key. Generated ID

A unique identifier for the system landscape.

LandscapeUID

Type: text (max 128 characters). Key

A global unique identifier for the system landscape.

LandscapeName

Type: text (max 128 characters)

A unique identifier for the system landscape.

LandscapeDescription

Type: text. Nullable

A more detailed description of the SAP system group.

SAPSystemLandscape StatusID

Type: integer

Identifies whether this system landscape is actively being used in the license optimization process.

LocationID

Type: text (max 128 characters). Key. Nullable

Any enterprise location associated with this landscape. Foreign key to the GroupEx table.

BusinessUnitID

Type: text (max 128 characters). Key. Nullable

Any corporate unit in the enterprise associated with this landscape. Foreign key to the GroupEx table.

CostCenterID

Type: text (max 128 characters). Key. Nullable

Any cost center in the enterprise associated with this landscape. Foreign key to the GroupEx table.

CategoryID

Type: text (max 128 characters). Key. Nullable

Any enterprise category associated with this landscape. Foreign key to the GroupEx table.

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.

CanRebalanceLicenseTypes

Type: boolean

Indicates whether license types can be rebalanced to use excess purchases of higher license types.

FlexNet Manager Suite (Cloud)

Current