I have a table with the team hierarchy Manger-Whole seller-Rep.I can implement section access in a single field.But I want to implement this in Manger-Whole seller-Rep fields.Whenever a user logs in as per its position he can view data below his hierarchy.Whenever manager log in he can see data of all his reportee.For Rep they can only view his own data.
Re: Section Access in Team level with multiple field
[first of all, do you have the Publisher? That would change the possibilities and limitations quite a lot]
in principle, you have the option in SA of reducing data based on some field, like BUKRS, so that people on a certain hierarchy level can only see what they are supposed to see - just what you want.
You need such a field to begin with - so in some way or other you need some field in the qvd's loaded that the SA can use to decide what to show. Do you have such a field or can you have one automatically generated? I suppose there is some name_stamp in every record - you will need the hierarchy in another table so this can be processed to decide, for the person logging in, what is below their level and thus visible for them.
I don't have too much experience with SA myself, but it is quite flexible and I'm sure it can be done.