Hi,
I have some master data tables:
Employees: User1 and User2
Divisions: 100, 200
Departments, ABCD, EFGH and IJKL
General ledgers: 7000, 8000, 8050, 8090, 9000, 9500 and 9999
Then I have a security table with 5 columns with some data:
User, division, department, generalledger_from, generalledger_to
User1, 100, ABCD, 8000, 8090
User1, 100, ABCD, 9500, 9999
User2, 200, <ANY>,7000, 9999
Out of these records I want to create a table to see which user is allowed to see which divisions, departments and general ledgers. Outcome should be a combination of all users, divisions, departments and general ledgers which the user is allowed to see based on the security table.
with <ANY> I mean that the user is allowed to see all departments
So I want to create a table like:
User, division, department, general_leger
User1, 100, ABCD, 8000
User1, 100, ABCD, 8050
User1, 100, ABCD, 8090
..
User2, 200, ABCD, 7000
User2, 200, EFGH, 7000
User2, 200, IJKL, 7000
User2, 200, ABCD, 8000
User2, 200, EFGH, 8000
.. etc
How do I create such a script?
