Filling multiple Variables through one manually entered Variable

[Former Member]

Hi BWers,

here is my question:

I have Queries with multiple time characteristics like 5x date from and 5x date to. These have to be filled <= from and >= to with a specific date that the user can enter.

I already got it working when i was testing it quite some time ago when i was prototyping.

But now in my final solution the query designer always says - "no valid variable". My plan is to make one variable for entering a date like: 12.11.2008 and all other variables shall be filled automatically with <= 12.11.2008 and >= 12.11.2008.

Can anyone help me?

Thanks in advance!

Dominik

[Former Member]

Hi Dominik,

I guess that your requirement is to use the same variable in several selections (rows/columns). If this is the case it can be solved quite simple, and you can actually use the same variable in all selections.

E.g. selection 1 which is <= 12.11.2008 : make a new selection and choose value range, less than or equal to and your date variable (let's say ZDATEVAR).

Selection 2 which is >= 12.11.2008 : make a new selection and choose value range, more than or equal to and the same date variable (ZDATEVAR).

In the above example you will only have to enter the date once even though the variable acts differently in the selections.

Hope it helps.

BR

Stefan

[Former Member]

Hi Dominik,

Have you tried to create exit variable in your query?

You can create variable, processing by "customer exit"

Check this help:

[http://help.sap.com/saphelp_nw70/helpdata/EN/f1/0a56f5e09411d2acb90000e829fbfe/frameset.htm|http://help.sap.com/saphelp_nw70/helpdata/EN/f1/0a56f5e09411d2acb90000e829fbfe/frameset.htm]

Regards,

Steph