Find technical name of query if only internal is given (and delete it)

[Former Member]

Hello,

a query has a readable name like "Invoice for north pole customers", a technical name like "Z_MM_CUST_NPOLE" and an generated internal name like "4BUI9VVDT8A057L8G3BQ4IN4G".

When I search which queries belong to an old multiprovider, I only get the internal query names like "4BUI9VVDT8A057L8G3BQ4IN4G". I cannot search with this internal name in the BEx Query Designer nor can I search there using the InfoArea folder (I can only find one query instead of two queries).

How do I find the technical name like "Z_MM_CUST_NPOLE"?

Apart from that, I cannot delete the query in the BEx Query Designer ("Delete" is inacitve (gray)).

The query seems corrupt. Can I delete a query in the SAP GUI (rsa1 or something like this)?

Best regards

Thomas

[former_member202718 · Accepted solution]

Hi Thomas,

You can delete the Query in BIW GUI by using T Code RSZDELETE.

After that u get a screen where u enter the

Type :- REP

Object Version :-A

Technical Name as :-"The Tech name of the Query"

Leave the other Rows Blank.

Rgds

SVU123

Edited by: svu123 on Apr 3, 2009 1:07 PM

[Former Member · Accepted solution]

I used transaction RSZDELETE and selected by InfoProvider. After that the entries in table RSZCOMPDIR were gone. After that the used MultiProvider could be finally deleted.

Thank you very much!

Thomas

[shanthi_bhaskar]

try it with RSZCOMPDIR table by the tech name...if you delete from this table then the query will b deleted from Designer