cancel
Showing results for 
Search instead for 
Did you mean: 

Define constant in query 3.5

Former Member
0 Kudos

In the moment I use a hierarchy variable and fill this variable via VBA makro. ( I have 4 different values (hierarchy nodes) for the variable)) But the customer wants to avoid VBA makro.

The variable is used in a row structure different times.

The variable should get a fixed value inside the query at one place. (Use default value is not an option) and then 4 different queries with different values should be stored.

So I want to use a constant instead of a variable. But where to define a constant (as used in a programming language) in the query designer 3.5 ? Or is there an option in query designer 7.0 ?

There exits u201Cconstant selectionu201D but this brings no solution here.

In cell definitions there is the possibility to use a help cell (on the low left) and reference on that cell in other cells. But this works only in the cell grid. Outside this help cell canu2019t be referenced.

Hope someone was an idea u2026..

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

if you want the place the constant value as some numeric and use it for your calculations, then u can create a formula/CKF and key the nos e.g 40 and save it.Now u can use it.

else,

you can create a formula variable and populate the required value in it.

Also u can write an exit to populate teh exit variable to the required constant value.

Reg,

Dhanya

Former Member
0 Kudos

- No programming should be used. So i can't work with ABAP for the exit variable

- To use a formula or KF is also not useful because i would have to define 4 different ones and replace them at every place i use the variable.