SQVI query not working for dervied roles.

[Former Member]

Hello Gurus,

Could you please advice why SQVI is not listing outout for the Derirved Roles. I have created a query to list down all the Users with Roles and assigned T.codes.,but query is not giving outout for the derived roles .

Tables used , agr_users, agr_tcodes.

best regards

matt

[Former Member]

Hi Matt,

Please refer the following table for the derived roles,

AGR_DEFINE (field PARENT_AGR is filled for derived roles).

Regards,

Amit

[Former Member]

Hi Amit,

I have added the table AGR_DEFINE in my query , still not populating Dervied Roles.

Thanks and regards

Joji

[Former Member]

Hi Joji,

Can you please check the roles that you are looking for in AGR_DEFINE in se11.

If you find your rolrs here in table then there a problem with your qwery i.e not properly written.

Else no custom roles exista .

Kindly check.

Regards,

Amit