11/22/2022 06:47 AM
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,
11/22/2022 06:55 AM - edited 11/22/2022 06:57 AM
AGR_TEXTS
Refer https://saviynt.freshdesk.com/support/solutions/articles/43000539903-sap-integration-guide
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 |
11/22/2022 07:00 AM
Hi Rushikesh,
Can you provide entitlement_values mapping where which ent custom properties are mapped to AGR_TEXTS table fields
Thanks,
11/22/2022 07:03 AM
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. |