SAPTransactionProfileObject Table

This table stores the linking between SAP transaction profile and SAP object.

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

Database Column

Details

SAPTransactionProfile ObjectID

Type: integer. Key. Generated ID

A unique identifier for the SAP transaction profile object

SAPTransactionProfileID

Type: integer. Key

Foreign key to an SAP transaction profile.

ObjectName

Type: text (max 128 characters)

The SAP object name

Description

Type: text. Nullable

The SAP object description

IsTransaction

Type: boolean

Indicates whether the object is of type Transaction

IsReport

Type: boolean

Indicates whether the object is of type Report

IsJob

Type: boolean

Indicates whether the object is of type Job

IsExcludedFromProfile

Type: boolean

Indicates whether the object is marked as excluded from this profile.

CreationUser

Type: text (max 128 characters). Nullable

The user who created the profile and object link.

CreationDate

Type: datetime

The data and time the profile and object link was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The last user who update the profile and object link.

UpdatedDate

Type: datetime

The date and time the profile and object link was last updated.

IsNonSAP

Type: boolean

Indicates whether the object is of type Non-SAP