BEx query information

[lakshminarasimhan_n4]

Dear team,

In which table we can find the below information.

bw.jpg

[Rambabu2]

Hi lakshminarasimhan.n2,

First thing I would like to let you know that we can't get all the information from a single table in BW side.

As per your screenshot, Information needed from the Bex query to underlying data target.

Since all these tables are inter dependent on each other, you need to follow the below sequence to find all the required information.

1. RSZCOMPDIR - This table covers most of the required information for you, - Take COMPID from this table.

2. RSZELTTXT - Provide the above COMPID and search for description of the query.

3. RSRREPDIR - you can provide the above COMPID and get the Data target (Info Provider) technical name.

4. RSDCUBE for cubes, RSDODSO for DSO - Finally you can find the Info Provider description here.

Regards.

Rambabu