cancel
Showing results for 
Search instead for 
Did you mean: 

Duplicate Queries in a system

Former Member
0 Kudos

Hi All,

We have a scenario where we are developing and transporting a query from sandbox to production. If the same query with the same techincal name is developed and transported from another system to production will the query be duplicated.

Thanks in Advance.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

If you have transported the query and you now have two queries with the same tecnical name run this program ANALYZE_RSZ_TABLES to fix the problem. Leaving both queries there will be problematic.

Former Member
0 Kudos

Yes there will be two queries with same technial names if you do like this. but if this situation already exists in your production then you use ANALYZE_RSZ_TABLES to change the technical names directly, no need to copy and delete the original query.

Regards,

Rk.

dennis_scoville4
Active Contributor
0 Kudos

The query keys aren't the technical name, it is an internally assigned GUID. If you take a look at the RSZELTDIR table, the key is ELTID (Query Element ID) which is this internally assigned GUID. The MAPNAME column on this table is where the technical name of the query is stored.

So, if you create two queries with the same technical name, you can transport them both through your landscape and they will both coexist. If you're using the SAP BW Portal, updates to the published query will be affected. If you modify a query that has the same technical name, but isn't the query that was published (different Query Element ID), the query in the portal will not change.

Former Member
0 Kudos

Yes they will be duplicated as they have internally different id in system level as Dennis told.

If you want to have only the queries created and moved from dev-> quality -> production

Open the query which you dont want and copy them as another query and delete the existing thing which is duplicated so that it will help you in avoiding confiusion.

Thanks,

Arun

Former Member
0 Kudos

The transport will not happen. It will give error while transportting to P.