How to Identify duplicate technical names for Bex Components issue and solve

Issue: Same BEX Query with 2 different technical IDs

A Bex report is  modified in Dev system and moved into test system and I executed the report in RSRT and it strangely shows some older version of report .

Why because:

The report has 2 technical IDs existing in the system. Ideally a report should have one technical id. But in our case the report has 2 technical ids. Why this happened could have many reasons. Lets concentrate on how to resolve this.

Now whenever report is executed always the older tech id is read and so new modifications are not appearing in NWT for this report.

How to solve it:

Run Programme ANALYZE_RSZ_TABLES

In the RSZCOMPDIR section you will find Components with duplicated technical names.

When you display the details you will get a list of the duplicated Queries. With the ID REP you can find the Quires,

Rename the Query name pointing to old technical id and save this.( Execute at rename query components)

This will now reflect all associated tables. And when query is executed then brings your modified report and changes.