Input ready columns for 2 usergroups
1 input ready query contains 2 columns (structure) for Value local and value central, which are to be entered by the local responsibles or the central employees only.
In the lines there are several positions of different key figures (e.g. positions with % - values or positions containing currencies).
Now the local users should be able to only enter data in local column and the central users should be able to enter data only in central column - but both user groups should in this input ready query be able to see the data the other group has entered in their column.
So far it seems that authorizations for local or central column will always turn the whole input ready query to not input ready due to unsufficient authorizations.
Since both user groups might enter data at the same time... dataslices don´t seem to be a proper solution either.
What is your advice?
Bindu Priya Chaluvadi replied
Just check the feasibility of below solution. Instead of having two separate key figures for local and central, create only one key figure and a characteristic (char1) to differentiate b/w local and central. Key Figure - Value Char1 values will be say LOC(local), CEN(central). Now as you want to see two columns in the query, restrict the first column by kf Value with Char1 as LOC and the second column by kf Value with Char1 as CEN. Maintain a Z-table with the user id and the value he is authorized to for Char1. Say for Ex: User Char1 U1 LOC U2 CEN U3 CEN U4 LOC etc Create a data slice restricting Char1 with an exit variable. In the code for the exit variable, read the Sy-uname, get the corresponding Char1 from z-table. If the value is LOC, populate CEN as the result. If the value is CEN, populate LOC as result. For ex, U1 is planning. So sy-uname will be U1 and for U1, LOC is maintained in Z-table. So populate CEN for the exit variable then as the active data slice is restricted by this exit variable, for that user, data will be locked for CEN and he can be able to plan for LOC as well see data for CEN. Hope this is clear.