Tables for BW-Query Elements (where-used list)

[moha_nan]

Hello,

I would like to find the tables in BW in which I can see where a characteristic with the filter/constant (e.g. company code = 1111) is used in the following BW query elements (where-used list):

Global restricted key figures
Filter
Local restricted key figures

Unfortunately, I have not found the best solution. We are on BW4HANA.

Thanks

[MichalCK]

I once did such a search. I've built an SQL that I run in HANA, based on RSZELTDIR and RSZELTXREF tables. This XREF table contains a nested structure of your query elements and I think as well you should be able to find your 1111 value there - but it was quite a while ago, so I hope I remember it correctly.