role(pfcg)

[Former Member]

hi all,

After creating a role, in which table it will get stored.

[Former Member]

Hi,

Roles are stored in table AGR_DEFINE and AGR_PROF has profiles for the role.

Hope this answers your question.

Do reward good points.

Feel free to ask more

[Former Member]

Hi Sri,

All role related data is stored in AGR* tables. Some of them are:

AGR_1016 -

---

> Name of the activity group profile

AGR_1016B----

---

> Name of the activity group profile

AGR_1250----

---

> Authorization data for the activity group

AGR_1251 -

---

> Authorization data for the activity group

AGR_1252 -

---

> Organizational elements for authorizations

AGR_AGRS -

---

> Roles in Composite Roles

AGR_DEFINE -

---

> Role definition

AGR_HIER2 -

---

> Menu structure information - Customer vers

AGR_HIERT----

---

> Role menu texts

AGR_OBJ----

---

> Assignment of Menu Nodes to Role

AGR_PROF----

---

> Profile name for role

AGR_TCDTXT -

---

> Assignment of roles to Tcodes

AGR_TEXTS -

---

> File Structure for Hierarchical Menu - Cus

AGR_TIME -

---

> Time Stamp for Role: Including profile

AGR_USERS -

---

> Assignment of roles to users

Hope it helps.

Please award points if it is useful.

Thanks & Regards,

Santosh

[Former Member]

Sri,

If u create a role, a lot of tables will be effected or updated with the role information. And the able names that store a role specific data starts wirh AGR, Below are some of the Tables that store role specific data.

AGR_1016 --- Name of the activity group profile

AGR_1251 --- Authorization data for the activity group

AGR_1252 --- Organizational elements for authorizations

AGR_1253 --- Authorization Data for Activity Group - St

AGR_AGRS --- Roles in Composite Roles

AGR_BUFFI --- Internet Links for a Role

AGR_CUSTOM --- Role Customizing objects

AGR_DATEU --- Personal settings for roles

AGR_DEFINE --- Role definition

AGR_FAVOS --- Personal settings for PFCG

AGR_FLAGS --- Role attributes

AGR_HIER --- Table for Structure Information for Menu

AGR_HIERT --- Role menu texts

AGR_HPAGE --- Role Home Page

AGR_HPAGET --- Description of the Home Page for a Role

AGR_LSD --- Role attributes

AGR_MAPP --- MiniApps in Role

AGR_NUMBER --- Internal Counter for Assigning Profile Nam

AGR_PROF --- Profile name for role

AGR_TCODES --- Assignment of roles to Tcodes

AGR_TEXTS --- File Structure for Hierarchical Menu - Cus

AGR_TIMEB --- Time Stamp for Role: Profile Generation

AGR_TIMEC --- Date stamp for role

AGR_USERS --- Assignment of roles to users

Hope this helps.

Regards,