Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Kaushik,
BU's are huge in general.
and the association to ordernos are not fixed. It varies from 1 to 20.
Regards
Bala