SAPUserRole Table

This table stores SAP users and its SAP role memberships

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

Database Column

Details

SAPUserRoleID

Type: integer. Key. Generated ID

A unique identifier for SAP user role.

SAPUserID

Type: integer. Key

Foreign key to the SAP user that the role belongs to.

SAPRoleID

Type: integer. Key

Foreign key to SAP role.

ValidFrom

Type: datetime. Nullable

The date that the SAP role is valid from.

ValidTo

Type: datetime. Nullable

The date that the SAP role is valid to.