Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Need table, which shows me status of authorisation object (pfcg inactive)

Former Member
0 Kudos

Hello all together,

I have a problem.

I am writing a report, which compares some roles.

I have two internal tables, which are filled from agr_1250.

Now I need in one table, only these rolenames (agr_name) and objects, that are active!

If you don´t understand what I mean by active or inactive, just look into pfcg. When I look at some roles there are objects where in red is "inactive" written before. That is okay, that doesn´t matter me, but:

Where the hell is this coming from?

If I know that, I can modifiy my Select-Statement, so, that only objects are selected, that are not inactive.

I wasted two days without getting a result.

Can you help me?

I looked at all agr_* tables, without result.

The deleted flag is not the one need, because there are roles, that are not deleted, but also inactive.

I despair!

Greetz,

Sascha

1 ACCEPTED SOLUTION

uwe_schieferstein
Active Contributor
0 Kudos

Hello Sascha

Inactive objects are marked as (AGR_1250-)DELETED = 'X'.

If you create a simple sample role (e.g. with object S_APPL_LOG) and inactivate this object the only change in AGR_1250 is DELETED = ' ' -> DELETED = 'X'.

Regards

Uwe

4 REPLIES 4

uwe_schieferstein
Active Contributor
0 Kudos

Hello Sascha

Inactive objects are marked as (AGR_1250-)DELETED = 'X'.

If you create a simple sample role (e.g. with object S_APPL_LOG) and inactivate this object the only change in AGR_1250 is DELETED = ' ' -> DELETED = 'X'.

Regards

Uwe

0 Kudos

Thanks for your answer.

But if the deleted flag is all I need, I have another question:

Is it possible that an object is inactive but not deleted? Because when I look in my tables it looks like.

0 Kudos

Hello Sascha

The SAP Profilgenerator is one of the more weird pieces of software and its logic is - by no means - always intuitive.

Objects that are entirely deleted from the role are also deleted from the AGR_... tables and, thus, do no longer appear there. Only the inactive objects which remain in the roles are still visible in the DB tables yet marked as DELETED = 'X'.

Regards

Uwe

PS: If you are doubtful about the meaning of the attributes in the AGR_... tables I always recommend to create a simple role, change this role in a systematic manner and check the corresponding changes in the DB tables.

0 Kudos

PERFECT!

THX!