SAPSystem Table

FlexNet Manager Suite (Cloud)

This table stores the data specific to the definition of 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 SAPSystem table

Database Column

Details

SAPSystemID

Type: integer. Key. Generated ID

A unique identifier for the SAP system.

SystemName

Type: text (max 128 characters)

The name of the SAP system.

SystemDescription

Type: text. Nullable

A more detailed description of the SAP system.

SAPSystemLandscapeID

Type: integer. Key

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

SAPSystemGroupID

Type: integer. Key. Nullable

Foreign key to the system group that the SAP system belongs to.

SAPSystemEnvironmentID

Type: integer. Key. Nullable

The type of environment for the SAP system.

SystemID

Type: text (max 64 characters)

The System ID that is used to identify the SAP system.

ClientID

Type: text (max 32 characters)

The Client ID that is to be used when connecting to the SAP system.

ServerName

Type: text (max 256 characters). Nullable

The DNS name of the SAP system. This value will be used by the RFC connection. This field can also store the SAP System’s IP address.

SystemNumber

Type: text (max 32 characters). Nullable

The SAP system number. This value will be used by the RFC connection.

Username

Type: text (max 256 characters). Nullable

The user name that is to be used when connecting to the SAP system.

Password

Type: binary. Nullable

The password that is to be used when connecting to the SAP system.

IsOfflineSystem

Type: boolean

Indicates whether an SAP system is offline.

IsPortalSystem

Type: boolean

Indicates whether the system is a portal system.

SystemStatus

Type: text (max 128 characters). Nullable

The status of the SAP system.

UsersControlledByCUA

Type: boolean

Identifies whether the uses on the SAP system are controlled by a CUA.

ModelView

Type: text (max 128 characters). Nullable

Further clarification required.

CUACentralSystem

Type: boolean

The status of the SAP system.

CUACentralSystemID

Type: text (max 128 characters). Nullable

The System ID of the CUA system that this SAP system is controlled by.

FNMSAPRelease

Type: text (max 128 characters). Nullable

The version of FNM for SAP installed on the SAP system.

LAWVersion

Type: text (max 128 characters). Nullable

The version of the License Assignment Workbench module installed on the SAP system.

SAPRelease

Type: text (max 128 characters). Nullable

The version of SAP installed on the SAP system.

SAPPatchRelease

Type: text (max 128 characters). Nullable

The SAP patch version

STPIRelease

Type: text (max 128 characters). Nullable

The ST-PI version

DBSystem

Type: text (max 128 characters). Nullable

The database system running on the SAP system.

HardwareKey

Type: text (max 128 characters). Nullable

The hardware key of the SAP system.

InstallationNumber

Type: text (max 128 characters). Nullable

The SAP system installation number

LastChangedOn

Type: datetime. Nullable

The date and time the SAP system data was last refreshed.

SupportPackage

Type: text (max 128 characters). Nullable

The support package of the SAP system.

HRSystem

Type: text (max 128 characters). Nullable

The SAP system which contains the HR data.

SystemType

Type: text (max 128 characters). Nullable

Indicates whether the SAP system is an ABAP or JAVA based system.

DefaultLicenseType

Type: text (max 2 characters). Nullable

Default license type for the SAP system.

ContactFirstName

Type: text (max 128 characters). Nullable

First name of the contact for this system.

ContactLastName

Type: text (max 128 characters). Nullable

Last name of the contact for this system.

ContactBusinessPhone Number

Type: text (max 30 characters). Nullable

Business phone number of the contact for this system.

ContactMobilePhoneNumber

Type: text (max 30 characters). Nullable

Mobile phone number of the contact for this system.

ContactEmail

Type: text (max 200 characters). Nullable

Email address of the contact for this system.

Location

Type: text (max 128 characters). Nullable

Location of this system.

InventoryDate

Type: datetime. Nullable

The date and time the SAP system data was collected by SAP Reader.

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. Key

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

AccessToModuleData

Type: boolean

Indicates whether the system has access to module data.

SAPSystemTypeID

Type: integer

The type of system for the system. Foreign key to the SAPSystemType table.

SAPConnectivityTypeID

Type: integer. Nullable

The type of connectivity for the SAP system. Foreign key to the SAPConnectivityType table.

SAPConnectivity DirectionTypeID

Type: integer. Nullable

The type of SAP connectivity direction for the SAP system. Foreign key to the SAPConnectivityDirectionType table.

BeaconUID

Type: unique identifier. Key. Nullable

The inventory beacon where this connection is defined.

SAPSystemRoleTypeID

Type: integer. Nullable

The type of SAP SystemRole for the SAP system. Foreign key to SAPSystemRoleType Table

MasterSAPSystemID

Type: integer. Nullable

A unique identifier for the Master SAP system.

SAPSystemClassID

Type: integer. Key. Nullable

The class of SAP system. Foreign key to the SAPPlatformType table.

SAPSystemMigration StatusID

Type: integer. Nullable

Migration status of the SAP system. Foreign key to the SAPSystemMigrationStatus table.

FlexNet Manager Suite (Cloud)

Current