topic Re: Security tables... in Application Development and Automation Discussions

Security tables...

Former Member — Mon, 16 Jun 2008 16:35:17 GMT

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.

Re: Security tables...

Former Member — Mon, 16 Jun 2008 16:39:15 GMT

You can do that with table AGR_1251.

Re: Security tables...

Former Member — Tue, 17 Jun 2008 05:25:00 GMT

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

Re: Security tables...

Former Member — Tue, 17 Jun 2008 09:32:27 GMT

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