SAPUser Table
This table stores the data specific to the definition of SAP users.
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.
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 |