SAPSystem Table

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.