09-10-2007 8:35 PM
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
09-10-2007 9:29 PM
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
09-10-2007 9:29 PM
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
09-11-2007 6:57 AM
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.
09-11-2007 8:23 AM
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.
09-11-2007 8:37 AM