Security tables...

[Former Member]

Hello,

I have requirement where I have to scan a role in SAP which has certain combination

of T-Code, Object, Field and value.

For example:

I need to write a query which will find all roles in SAP which has following combination of T-Code, Object, Field and Value:

T-CODE.......... Object...............Field......Value

F-02...........F_BKPF_BUK......... ACTVT.......01

What are the tables on which I can write query to fetch these kind of details ?

Thanks.

Regards,

Rajesh.

[Former Member]

You can do that with table AGR_1251.

[Former Member]

Hi

You can also use T-Code suim

SUIM> Activity Groups>List of Activity Groups According to Complex Selection Criteria-->By authorization values

You can see the fields as you mentioned .

You will get the profiles which satisfying the above criteria

Regards

Sohin

[Former Member]

When you talk about

T-CODE.......... Object...............Field......Value

F-02...........F_BKPF_BUK......... ACTVT.......01 ,

I understand that you need the values that are maintained for a tcode in su24.

Please refer to table USOBT_C for these values.

-

---

sorry, I guess I interpreted the question wrongly earlier. You can refer to SUIM -> Roles by complex selection criteria for that.. but that also will not give a correct idea about the tcode if that is actually checking for that object in its program..

Edited by: Hemant Raj on Jun 17, 2008 3:05 PM