how to delete the queries and WAD templates from the SAP BI

[Former Member]

HI,

We had a task to delete the list of quires and WAD templates from the SAP BI landscape(development,quality and production servers)

Please suggest the process to follow for removing the quires from the SAP BI landscape.

[Former Member · Accepted solution]

Hi Venkata,

You can use RSZDELETE transaction for mass deletion of BEx Queries and their objects.

Thanks,

Ramakrishna Kamurthy

[Former Member · Accepted solution]

Hi Ramakrishna,

how to store the deleted quires in the transport request for deleting the same quires in the quality and production system.

[former_member202718 · Accepted solution]

Hi Venkata,

I assume that the DEV-QA -PRD are in Sync with each other.

When you are deleting a query from the DEV,it should ask for a NEW transport request.IF not it means it is collected in some other request ,may be in NA or in Junk request.So see to it that it is FIRST saved in your request and then using RSZDELETE T .Code you can delete it.When you transport the request to QA or to PRD ,the query automatically gets deleted from that landscape.

Let me know if there are any issues.

Rgds

SVU123

[Former Member · Accepted solution]

HI,

How to delete the query first means by using which transaction code ,we can delete the query.Please provide the step by step process here.

[former_member202718 · Accepted solution]

Hi Venkata,

Use T.Code RSZDELETE and then give 'REP' in TYPE and in Tech Name,give the tech name of the query...

Rgds

SVU123