How to Join ....

[Former Member]

Guys - In the morning today I got a request from our audit team they want to see transactions assign to each role Which security table I may join to get Role Name and transaction assign to it.

<b>Role Name, Transaction code ,</b>

Here are fields

AGR_NAME,

TCODE,

TTEXT

I am interested to make join table ….query ...........

Thank you !!

[Former Member]

Guys - In the morning today I got a request from our audit team they want to see transactions assign to each role Which security table I may join to get Role Name and transaction assign to it.

<b>Role Name, Transaction code ,</b>

Here are fields

AGR_NAME,

TCODE,

TTEXT

I am interested to make join table ….query ...........

Thank you !!

[Former Member]

Hi Imran,

I cant remember exactly which table you need but i think it is either AGR_1250 or AGR_1251.

Regards

Ashley

[dhorions]

It's in table agr_1251.

AGR_NAME = <i>your role</i>

OBJECT = S_TCODE

FIELD = TCD

LOW <-> HIGH = <i>your transactions</i>

Hope this helps,

Dries

[Former Member]

Try this http://www.sapsecurityonline.com/tutorials/r3_sqvi_tutorial.htm

[Former Member]

Thanks !!