topic Re: SAP Authorisation in QlikView

SAP Authorisation

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: SAP Authorisation

settu_periasamy — Mon, 07 Mar 2016 12:32:31 GMT

May be try like this..

Dimension : [User Name]

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

Re: SAP Authorisation

Mon, 07 Mar 2016 12:43:19 GMT

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 ,

Re: SAP Authorisation

Peter_Cammaert — Mon, 07 Mar 2016 13:21:54 GMT

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.

Re: SAP Authorisation

Thu, 10 Mar 2016 07:39:04 GMT

Not answered yet !

Re: SAP Authorisation

settu_periasamy — Thu, 10 Mar 2016 09:23:09 GMT

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

Re: SAP Authorisation

Thu, 10 Mar 2016 12:53:27 GMT

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!

Re: SAP Authorisation

Thu, 10 Mar 2016 12:56:50 GMT

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

Appreciate your input... in advance!

Re: SAP Authorisation

settu_periasamy — Fri, 11 Mar 2016 03:39:38 GMT

Hi,

Check the Attachment, is that you are looking?