Dynamic SQL with var range

[Former Member]

Hi

I have dynamic sql:

CONCATENATE 'datum <= ''' datumOP '''' INTO whereLine.

APPEND whereLine TO iwhereSQL.

select * from table WHERE (iwhereSQL)

but when I change it to:

• datumRG is like parameter range

CONCATENATE 'datum IN ''' datumRG '''' INTO whereLine.

APPEND whereLine TO iwhereSQL.

then this don't work, it isn't correct.

How to define dynamic SQL with range field?

[Former Member]

Hi Kosmo,

use following code.

select-options: datumRG for sy-datum.

CONCATENATE 'datum IN ' 'datumRG ' INTO whereLine separated by space.

Regards,

Yellappa.

Edited by: yellappa m on Feb 22, 2008 6:56 PM

[Former Member]

It isn't too simple

Your code give effect "datum IN ' IEQ2008022200000000 '"

It's not work

[Former Member]

Then you have to deal with every cases included within the select-option : EQ, but also BT, NE, GT, etc.

Loop at your select option and do some transalation with a Case/When.

N.H.