How to delete WAD and query objects in sap bi

[Former Member]

hi,

we need to delete the WAD and query from the BW development server and transport the same to the quality and production.

please provide the task we need to perform to delete the particular WAD and related queries in the sap bi.

[anshu_lilhori · Accepted solution]

Hi,

You can make use of T-CODE RSZDELETE to delete all the query

In that select TYPE as REP which means query

Technical name-Give your query name.

Hope it helps.

Regards,

AL

[Former Member]

hi,

tcode RSZDELETE for query,

for WAD, Goto your web template-->Select Webtemplate(from menu) and then click on Delete.

While deleting it'll ask you for the trasport request, Save it in the TR and then move it prd--> web template in prd system will get deleted.

Note: WAD template can be delete through table RSZWTEMPLATE , but it is not recomended to delete it from the table.. and more over you'll not have autorization to delete entries in prd system.. so its better delete it from dev and save it in a TR and then move the TR to prd

-jijo