Link between RSZELTDIR and RSRREPDIR

[former_member184624]

Dear BW Experts,

I want to identify the query technical name based on Restricted keyfigure. I have a restricted keyfigure RFK_1. I just want to know, in which queries, the RKF_1 are using ? As i checked the table RSRREPDIR and RSZELTDIR, there is no link. I can see my RKF in table RSZELTDIR but there is no link with the table RSRREPDIR. Please suggest how to identify the queries using the RKFs.

Thanks.

[Abhishek_Hazra · Accepted solution]

Hello jelina.masilamani,
The easiest but manual way of checking it is from the where used list option in your application. All you need to do is to open the RKF & click on the where used list option.

However, if you are looking for the link between the repository tables, there is no easy way to do this. You need to build a utility program which should loop through the table : RSZELTXREF. The logic should be as following :
1. Go to table : RSZELTDIR, under field MAPNAME provide the RKF name you want to search for & select OBJVERS = A (for active). Display data & you'll get a value for field ELTUID.

2. Now take the ELTUID value & place it in table RSZELTXREF under field : TELTUID & select OBJVERS = A. You might get multiple rows for this selections & you need to take each of the unique values retrieved from field SELTUID & pass that on to the same table RSZELTXREF under field TELTUID. You need to keep doing this until the field LAYTP shows value SHT (query sheet).

3. Upon reaching the stage where LAYTP = SHT, take the values from field : SELTUID & pass that on to table : RSZELTDIR under field : ELTUID & keep OBJVERS = A. Display data, and under field MAPNAME you'll get the query names.

The table RSZELTXREF is the core table that holds the relationship & references between different component types within a query.

Best Regards,
Abhi

[bhavinvyas]

Hi,

You can get this information from where used list in BEx Query Designer.

Select the RKF in BEx Query, Now press where used list button from top.

It will display list of queries where this particular RKF is used.

Thanks,

Bhavin