SAP Authorisation

[#1]

Hello Every One,

I am doing an SAP Authorization exercise, I have two tables with below fields,

Table 01:

[User Name],

Role_Name,

[T-code]

Table 02:

[Serial No],

[T-code],

[T-code1],

[Risk Description Short],

[Risk Description]

default relationship is maintain by [T-code] field. What I want to pull out, is the users who have combination of Tcode which is my SOD Risk.

for example,

Return the User who has access to Tcode: CN25 & MB01.... and so on.

can you please share the expression which will return the Users...

Hope this elaborate my Question..

Appreciate in Advance.

[settu_periasamy]

May be try like this..

Dimension : [User Name]

Expression : Concat(Distinct [T-code],',')

[#3]

This does not solve my problem, I just want to return those users who's access match in [T-code] & [T-code1].

Appreciate settu_periasamy ,

[Peter_Cammaert]

You can use a T-Code listbox and switch it to and-mode. Selecting any two Transaciton IDs in that listbox will automatically show Users that have access to the first Tx and to the second Tx.

[#5]

Not answered yet !

[settu_periasamy]

Can you provide the sample and expected output? Let's try..

[#7]

Hope below scenario explain my Question clear to you !

Table 1:

User Name	T-Code
10000011	0KW7
20000092	CN25
20002544	0KW7
20002942	0KW7
30000008	CN25
30000012	0KW7
10000011	0VRF
20000092	0VRF
20002544	0VRF
20002942	0VRF
30000008	0VRF
30000012	0VRF
10000011	0VTA
20000092	0VTA
20002544	0VTA
20002942	0VTA
30000008	0VTA

Table 2:

S.NO	Conflicting Transactions-1	Conflicting Transactions-2	Description
1	0KW7	MB01	Confirm Completions in Network & Post Goods Receipt for PO
2	CN25	MB02	Confirm Completions in Network & Change Goods Receipt for PO
3	CN25	0KW7	Confirm Completions in Network & Post Goods Receipt for PO
4	CN25	MB1A	Confirm Completions in Network & Goods Issue

I want to get User who matches tables 2 .... which means a User having access to Conflict Trnx 1 & 2 would be my result. Please note that having access to only one T-code in does not trigger risk, User should have both tcode at same point.

Appreciate your input... in advance!

[#8]

Hope below scenario explain my Question clear to you !

Table 1:

User Name	T-Code
10000011	0KW7
20000092	CN25
20002544	0KW7
20002942	0KW7
30000008	CN25
30000012	0KW7
10000011	0VRF
20000092	0VRF
20002544	0VRF
20002942	0VRF
30000008	0VRF
30000012	0VRF
10000011	0VTA
20000092	0VTA
20002544	0VTA
20002942	0VTA
30000008	0VTA

Table 2:

S.NO	Conflicting Transactions-1	Conflicting Transactions-2	Description
1	0KW7	MB01	Confirm Completions in Network & Post Goods Receipt for PO
2	CN25	MB02	Confirm Completions in Network & Change Goods Receipt for PO
3	CN25	0KW7	Confirm Completions in Network & Post Goods Receipt for PO
4	CN25	MB1A	Confirm Completions in Network & Goods Issue

I want to get User who matches tables 2 .... which means a User having access to Conflict Trnx 1 & 2 would be my result. Please note that having access to only one T-code in does not trigger risk, User should have both tcode at same point.

Appreciate your input... in advance!

[settu_periasamy]

Hi,

Check the Attachment, is that you are looking?