topic Re: Dyanamic Select Query in Application Development and Automation Discussions

Dyanamic Select Query

Former Member — Thu, 25 Feb 2010 18:10:32 GMT

Hi,

Can you pls guide me on the use of Dyanamic WHERE Clause in a Select Query?

I came across the syntax:

SELECT * FROM za004 INTO TABLE ia004 WHERE (options).

Here Options is an internal table of type 'RFC_DB_OPT'

But I am unable to fill this internal table correctly.

Can some one pls guild me with sample code.

Regards,

Pankaj Bist.

Former Member — Thu, 25 Feb 2010 18:32:38 GMT

Check this :

DATA: BEGIN OF lt_options OCCURS 10.

INCLUDE STRUCTURE rfc_db_opt.

DATA: END OF lt_options.

CONCATENATE 'PERIV EQ ' '''' 'V8' '''' ' AND' INTO " <-- PERIV is the field name

lt_options-text.

APPEND lt_options.

CONCATENATE 'BDATJ EQ ' '''' l_pyear '''' INTO

lt_options-text.

APPEND lt_options.

Use lt_options in where condition.

kesavadas_thekkillath — Thu, 25 Feb 2010 18:56:27 GMT

Have a look at souce code of fm

CONVERT_SELECT_INTO_WHERE

ADSPC_CREATE_WHERE_CLAUSE

DYNSQL_GENERATE_WHERE_CLAUSE

FREE_SELECTIONS_RANGE_2_WHERE

ThomasZloch — Thu, 25 Feb 2010 21:09:44 GMT

This and much more can be found in the ABAP online documentation

Thomas