SAP AGR_1252 data mapped to which entitleent attribute in Saviynt

[Pravallika_t]

Hello Team,

we are importing accounts and entitlements using the below tables and order:

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

The document states that organizational level data is fetched from AGR_1252, can we know where exactly the data is stored in Saviynt? Are they stored in any entitlement attributes? 

How do we know which SAP data is mapped to entitlement attributes? We couldn't find any information in documentation.

[rushikeshvartak]

You can validate from UI from Account - Entitlement Hierarchy 

Query 

SELECT U.username,
       A.NAME,
       A.accountid,
       E.entitlement_value,
       ET.entitlementname
FROM   entitlement_values E,
       entitlement_types ET,
       account_entitlements1 AE,
       accounts A,
       user_accounts UA,
       users U,
       endpoints EP
WHERE  ET.entitlementtypekey = E.entitlementtypekey
       AND E.entitlement_valuekey = AE.entitlement_valuekey
       AND AE.accountkey = A.accountkey
       AND A.accountkey = UA.accountkey
       AND UA.userkey = U.userkey
       AND A.endpointkey = EP.endpointkey
       AND EP.endpointname = '<Provide endpoint name here>'
       AND U.username = '<Provide username here>'