We are delighted to share our new EIC Delivery Methodology for efficiently managing Saviynt Implementations and delivering quick time to value. CLICK HERE.

Saviynt entitlement attribute mapping to SAP table

Miko
New Contributor III
New Contributor III

Hello Team,

SAP connector is used to import account and access data from these table

USR02,TSTC,TSTCT,AGR_AGRS,AGR_TEXTS,AGR_DEFINE,AGR_USERS,USORG,AGR_1252,AGR_1251

I am looking for which SAP table data is mapped to entitlement custom attributes on Saviynt. I don't see these info on documentation site.

Thank you,

3 REPLIES 3

rushikeshvartak
All-Star
All-Star

AGR_TEXTS

Refer https://saviynt.freshdesk.com/support/solutions/articles/43000539903-sap-integration-guide

SAP Table Details

Table Names

Description

Mandatory for Account or Access Import?

AGR_1016

Provides information about names of the activity group profile.

No

AGR_1016B

Provides information about names of the activity group profile.

No

AGR_1250

Provides information about authorization data for the activity group.

No

AGR_1251

Provides information about SAPROLES with Authorization object data. This table also provides information regarding fields, their maximum values and minimum values.

Yes

AGR_1252

Provides information about SAPROLES with Organizational level data for authorizations.

Yes

AGR_AGRS

Provides mapping information about single role and composite role. The data from this table will be stored in the entitlements2 table.

Yes

AGR_DEFINE

Provides information about role definitions and derived roles. The data from this table is stored in the account_entitlements1 and entitlements2 tables.

Yes

AGR_PROF

Provides information about profile name for roles.

No

AGR_TCODES

Provides information about assignment of roles to Tcodes.

No

AGR_TEXTS

Provides information about entitlement types, SAPROLEs along with short texts. The data from this table is stored in the description and ENTITLEMENT_VALUE columns of the entitlement_valuestable.

Yes

AGR_USERS

Provides information about composite roles assigned to a user. It shows data regarding mapping of SAPROLEs to an account. The data from this table is stored in the account_entitlements1 table.

Yes

SWNCMONIINDEX

Provides information about Tcodes, their usage for each account on each SAP application. You can get the usage data for various entitlements for different periods of time. However, the usage period is mentioned as D-day or W-week for respective entitlements.

Yes

T000

Provides information about clients.

No

TSTC

Provides information about Tcode added to the program. The data from this table is stored in the description column of the entitlement_values table. This table contains link to the TSTCT table which stores the transaction names.

Note: To address such scenarios, you must add the tables in the order specified in Prerequisites for Integrating with SAP.

Yes

TSTCT

Provides information about Tcodes and their descriptions. This table contains link to the transaction codes data available in the TSTC table.

Yes

USOBT_C

Provides information about Relation Transaction > Auth. Object (Customer).

No

USORG

Provides information about Organization levels for profile generator.

No

USR01

Provides information about user master record (runtime data).

No

USR02

Provides information about the user logon details. It is also referred as table that provides user account information from SAP

The data from this table is imported into the accounts table in EIC.

Yes

USR11

Provides information about user master texts for profiles (USR10).

No

UST04

Provides information about user masters.

No

UST10C

Provides information about user master for composite profiles.

No

UST10S

Provides information about user master for single profile table.

No

UST12

Provides information about user master for Authorizations.

No


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.

Miko
New Contributor III
New Contributor III

Hi Rushikesh,

Can you provide entitlement_values mapping where which ent custom properties are mapped to AGR_TEXTS table fields

Thanks,

You can raise support ticket to get information about it .

AGR_TEXTS

Provides information about entitlement types, SAPROLEs along with short texts. The data from this table is stored in the description and ENTITLEMENT_VALUE columns of the entitlement_valuestable.


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.