SAPUser Table

This table stores the data specific to the definition of SAP users.

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

Database Column

Details

SAPUserID

Type: integer. Key. Generated ID

A unique identifier for the SAP user.

SAPSystemID

Type: integer. Key

Foreign key to the system that the user belongs to.

UserName

Type: text (max 256 characters). Key

The SAP user’s username.

FirstName

Type: text (max 40 characters). Nullable

The SAP user’s first name.

LastName

Type: text (max 40 characters). Nullable

The SAP user’s last name.

ValidFrom

Type: datetime. Nullable

The date that the SAP user is valid from on the SAP system.

ValidTo

Type: datetime. Nullable

The date that the SAP user is valid to on the SAP system.

UserType

Type: text (max 1 characters). Nullable

The type of user the SAP user is.

LicenseType

Type: text (max 2 characters). Nullable

The type of license assigned to the SAP user.

UserGroup

Type: text (max 12 characters). Nullable

The user group the SAP user belongs to.

LastLogonDate

Type: datetime. Nullable

The date when the SAP user last logged on to the SAP system.

IsDeveloper

Type: boolean

Indicates whether the SAP user is a developer or not.

UserCreationDate

Type: datetime. Nullable

The date the SAP user was created.

EmailAddress

Type: text (max 128 characters). Nullable

The SAP user’s email address.

TelephoneNumber

Type: text (max 30 characters). Nullable

The SAP user’s telephone number.

TelephoneExtension

Type: text (max 10 characters). Nullable

The SAP user’s telephone extension.

AccountID

Type: text (max 12 characters). Nullable

The SAP user’s account ID.

CostCenter

Type: text (max 8 characters). Nullable

The cost center the SAP user belongs to.

CompanyName1

Type: text (max 40 characters). Nullable

The name of the company the SAP user belongs to.

CompanyName2

Type: text (max 40 characters). Nullable

The name of a second company the SAP user belongs to.

Department

Type: text (max 40 characters). Nullable

The department the SAP user belongs to.

UserFunction

Type: text (max 40 characters). Nullable

UserLockStatus

Type: integer. Nullable

User lock status.

SpecialVersionAssignment

Type: text (max 2 characters). Nullable

CountrySurcharge

Type: text (max 4 characters). Nullable

RepresentativeFromDate

Type: datetime. Nullable

RepresentativeToDate

Type: datetime. Nullable

IsDeleted

Type: boolean

Indicated whether the SAP user has been deleted or not.

ChargeableUserClient

Type: text (max 32 characters). Nullable

ChargeableUserSysID

Type: text (max 32 characters). Nullable

ChargeableUserName

Type: text (max 12 characters). Nullable

RemoteServerUserName

Type: text (max 64 characters). Nullable

Remote server user name