Require Idea on using pattern in section access

[#1]

Hi All,

We have a requirement where users should be authorized to see specific BU's.

USER	BU
U1	6J
U2	2N
U3	1N

But in the transactions, for every order no, we get more than one BU's associated and the assignment varies from one to many.

OrderNo#	BU
100	6J,2N
102	2N,1N,6J
103	1N,6J

When U1 logs in, he should be authorized to see order no - 100,102 and 103

and when U2 logs in, he should be authorized to see order no - 100,102

and when u3 logs in, he should be authorized to see order no - 102 , 103.

Kindly help us on the above requirement?

Regards

Bala

[kaushiknsolanki]

Hi,

     The simplest way can be that you create a nother table which will be linked to the single BU's with multi BU's.

     Say for example in your case the table will be.

     Load * inline [

     BU, MULTIBU

     6J,6J,2N

     6J,2N,1N,6J

     2N,2N,1N,6J

     2N,6J,2N

     1N,1N,6J

     1N,2N,1N,6J

     ];

     Here the BU should link to the Section Access field and the MULTIBU in your database field.

     Hope this is clear.

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

BU's are huge in general.

and the association to ordernos are not fixed. It varies from 1 to 20.

Regards

Bala