topic Re: Not generated profile analysis in Application Development and Automation Discussions

Not generated profile analysis

Former Member — Wed, 30 Mar 2016 13:37:15 GMT

Dear Colleagues

I have to analyze thousends of not generated single profiles.

I know that I can check each Profile on field values level

But for such a big amount of profiles I Need table.

Which table can Show us all Profile filed values?

Thank you

Re: Not generated profile analysis

surya_appala — Wed, 30 Mar 2016 14:31:47 GMT

Hi Yan,

May I know the version of SAP you are using now ? We usually generate the roles and not profiles as far as I know.

Regards,

Surya

Re: Not generated profile analysis

Former Member — Wed, 30 Mar 2016 14:56:43 GMT

Hello Surya.

It does not depend on version. It is an old authorization Approach.

Re: Not generated profile analysis

Colleen — Wed, 30 Mar 2016 22:51:16 GMT

Hi Yan

Have a look at the diagram I posted in the following link for tables. Although yours are not based on derived roles, the profiles should be in same tables.

In terms of your analysis, you can reduce scope by seeing which ones are assigned to users

What system are you on? If higher than a 3.1X, have you considered converting them to roles via SU25? PFCG can then be used along with SU24. Best win is you now have validity dates for role assignments to users.

Regards

Colleen

Re: Not generated profile analysis

Former Member — Wed, 30 Mar 2016 23:12:01 GMT

Hello Coleen.

Thank you for your comment. My profiles are not in roles. They are assigned derictly to users (in your table - UST04).

Never tried to convert profiles to roles via SU25. Maybe in my case this is not the best solution, but is is very interesting!

I have checked SQL and Table buffer trace, when I looked inside of one single profile. UST12, USR10, UST10S are involved.

Now I think to unite these tables to analyze all profiles in Excel. After I will replace them with existing roles.

Yan

Re: Not generated profile analysis

Colleen — Wed, 30 Mar 2016 23:33:50 GMT

good luck

The diagram was to show you the profile tables as well. End of the day, PFCG sits over the profiles - profiles in both are still in the same tables just different classifications (generated, standard, composite)