Delete variable from Query

[Former Member]

Hi Guru's,

I copied a query saved with a new name and made some changes to the new one, when I run the Query I get 3 variables(pop up) eg., PlanVersion, Period Interval, Year. I dont need Plan Version, Period Interval, but need just the Year...When I see the Query Properties I see all the three Variables I dont have the option to delete any of them... Any ideas would be highly appreciated...

Cheers..

PR

[former_member188975 · Accepted solution]

Hi PR,

You cannot delete the variables from the query properties. You will need to delete them from the query definition (rows, columns, filter and free char areas). The period variable would be restricting char 0FISCPER (most probably) so see where it is included in the query definition and remove it from there. Same goes for the Plan Version.

Hope this helps...

[Former Member · Accepted solution]

Hi Bhanu Gupta,

It just did not help, but solved the Problem... Do u have a Crystal Ball?;-) Thanx very much...

Cheers..

Preetham

[former_member188975]

There is a difference between deleting a variable from a query definition and deleting it from the system. Be careful about what you exactly want to do. The system will not let you delete if the variable is being used in any query defintion.

Hope this helps...

[Former Member]

PR

You could do this at query designer also use transaction Code RSZDELETE with Type Variabls.

Thnaks

Sat

[Martin_Fei]

Excellent, this is what I was looking for. Thank you, Sat!