Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try like this..
Dimension : [User Name]
Expression : Concat(Distinct [T-code],',')
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 ,
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.
Not answered yet !
Can you provide the sample and expected output? Let's try..
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!
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!
Hi,
Check the Attachment, is that you are looking?