12-23-2008 4:35 PM
12-24-2008 8:57 AM
It's nice to see you've rewarded all answers but that still leaves me puzzled about the actual question.... Can you please enlighten us a bit more?
12-23-2008 4:49 PM
I just looked up the AGR* tables and didn't see any specific area that had a unique identifier. Have you seen this before from a different screen that wasn't a table?
12-23-2008 4:53 PM
12-23-2008 5:36 PM
I hope I understand your question correctly, if so, the key for all roles within SAP is a combination of client number and rolename. This means the rolename has to be unique within a client.
12-23-2008 6:59 PM
Hi Mike,
From your question what I understand is that you need a list of all the users assigned to a role. You can get this from report S_BCE_68001399.
Alternatively you can get this from table agr_users. However this will give multiple entries for a user if a user is assigned the same role more than once.
Regards,
Sameek
12-24-2008 6:15 AM
Hello Michael,
Jurjen has correctly pointed out that the role name and client number are combined to uniquely identify a role within a system.
A role name is unique within a client. You can use table AGR_DEFINE, field name AGR_NAME if you only want a client dependant table.
12-24-2008 8:57 AM
It's nice to see you've rewarded all answers but that still leaves me puzzled about the actual question.... Can you please enlighten us a bit more?
12-24-2008 12:39 PM
HI Jurjen,
Sorry .
i Try to look it myself , no progress until now...
What i want is some Unique key for Role in the system we have lot of rols,
so i think that have to be some unique id for them.
Regards
12-24-2008 12:49 PM
> so i think that have to be some unique id for them.
The role name is unique per client. There's nothing more to it. That's the entity you use to link all AGR_* tables.
However, if you're looking for something to identify roles to easily find out what they're meant for then no, that all depends on naming conventions made by the persons who built them. The SAP standard roles generally hold a reference to the module (HR BC FI etc) in their name.
Jurjen
12-24-2008 12:56 PM
Hi Jurjen,
Thanks for your time.
Maybe u can elaborate on this :
The SAP standard roles generally hold a reference to the module (HR BC FI etc) in their name.
Reagrds
12-24-2008 1:40 PM
> Maybe u can elaborate on this :
>
> The SAP standard roles generally hold a reference to the module (HR BC FI etc) in their name.
All roles for which the name starts with "SAP_" are standard SAP roles, meant as a template for role development. A lot of those have names starting with SAP_BC_, SAP_XI_, SAP_WPS_ etc.
The bit between the two underscores gives an idea for which part of SAP functionality they are meant. In an ECC system you'll see roles for FI, CO, MM, SD etcetera.
12-24-2008 3:40 PM
Hi Jurjen,
Thanks it make sense,
My last question on this topic ,
does role have unique folder ,u can see in in table AGR_HIER.
Thanks Again
Mickael A
12-25-2008 9:16 AM
> My last question on this topic ,
> does role have unique folder ,u can see in in table AGR_HIER.
No, there's no rule for the relations between roles and menu sections. It's all in the fantasy of the builder.
Trying to reverse-engineer the role design from the SAP tables will be a tedious task for which there are very few technical shortcuts. (I am guessing here that that's what you're trying to do)
Cheers
Jurjen