Where resctricted list of an often used charactistic

[Former Member]

Hey guys,

for an often used characteristic I need to find out if it is restricted to fixed values in any query where it is used. However, this characteristic is used in hundreds of queries. Do I really need to check every query, its row, column and restricted key figure definitions now where this characteristic is used? Or is there any better and faster approach? If this exists I would be very thankful if you share it with me.

Many Thanks in advance!

Greets

Norbert

[Former Member · Accepted solution]

Hi,

Check the values in following table.

RSECLOPDQFILTER (Filter within queries).

I hope it will help.

Thanks,

S

[Former Member · Accepted solution]

Thanks for your answers,

however they didn't help me a lot.

@Rakesh: The where-used feature inside the query designer is known, but not really helpful in my case. First I would need to know in which restricted key figures the characteristic is used and in my opinion I have to go through all of them manually. Also, the where-used feature reaches only to queries within the same InfoProvider. A better feature would be a programm or fuction which shows me all queries and restricted key figures where the respective characteristic has been used and best it would also show if it is restricted.

@Choudhary: The table looks good, but in my case its totally empty.Is it filled in your case?

Best Greets

Norbert

[Former Member · Accepted solution]

Hi,

Yes it is filled in my case.

I would suggest go se12 tcode and search for RS* tables over there. You will find some interesting table as per your need.

I hopr it wll help.

Thanks,

S

[Former Member · Accepted solution]

Thanks,

they are truly very interesting tables, but unfortunately I didn't found any table names which could provide me with the searched information. In my opinion they must be a table where it can be checked in which queries a certain infoobject is actually used.

[Former Member · Accepted solution]

Hello,

have a look into table "RSDDSTAT_OLAP". You can see the last run / runtime of a query.

[former_member189638]

Open anyone Query in the Query Designer which conatins this particular key figure. Select the Restricted Key Figure and do a right click on that and select Where used list. It will give you a complete list of all queries where it is being used.