Skip to Content
0
Sep 28, 2005 at 12:04 PM

Query designer: authorization for restriction list

25 Views

Hi,

i try to solve the following:

I have to restrict data by authorization on the level of the Source systemID - also in the querydesigner when using the restriction list. So I've created a authorization object zsoursyst for restricting data on this level. This works great for transactional data and even the selection list on characteristics within query execution. Although it does not work in the query designer when you are restricting on characteristics. Then in the restriction list there are always shown all entries of this masterdata (of all sourcesystems). I tried using the object S_TABU_LIN for this. So I defined in the customizing SAP Netweaver->SAP Web Application server->System administration->Users and authorization->line-oriented authorization an organisational criteria on the sourcesystem. Therefore i used the table RSSOURSYSIDT where the sourcesystem is in the key (as needed). The organizational criteria is activated. But there is still no restriction done on the sourcesystem within the query designer.

Any suggestions?

Thanks a lot, Klaus