Query | Text Variable with space or empty

[ChristianSass]

Hi Community,

we use variable exits in a BW Query to show texts in columns.

Is there a way to return '' or empty or null? If I do so, then the technical name of the variable is shown in the columns.

ls_range-low = ' ' (space) doesn't work either.

As a workaround, I return '.' but I'm looking for another solution.

Thx for any hint!

[gregor_dieckmann]

Hi Christian,

the logic behind text usually is to check whether a text is initial and then to take the technical name as text. In other words, as long as LS_RANGE-LOW is initial the fall-back will be used.

I have never tried this approach: one idea is to assign a white space to LS_RANGE-LOW, e.g. something like this

field-symbols:
  <x_low> type x.

assign ls_range-low to <x_low> casting.
<x_low> = '09'. " i.e. horizontal tab

Regards,

Gregor

[former_member231709]

Try to using backquotes:

LS_RANGE-LOW = ` `.

[ChristianSass]

nope ... doesn't work either