Skip to Content
0
Nov 14, 2012 at 12:21 PM

Create multiple ranges dynamically with unique name

861 Views

Hi Friends,

i have a requirement to create a program to select data from table. User will maintain the condition (i.e. where) to be applied in select statement in a database table.

Select * from (Table) into <target Table> where (lc_where).

In order to create the dynamic where clause, i need to create dynamic range table with unique name and populate the condtion.

WHERE COMPCODE IN <FS_COMPCODE>

AND INVOICENO IN <FS_INVOICENO>

AND FISCALYEAR IN <FS_FISCALYEAR>

Plese let me know how we can address this requirement.

Regards

Suresh Kumar