topic Re: Select statement issue in Application Development and Automation Discussions

Select statement issue

Former Member — Thu, 24 Jun 2010 20:18:07 GMT

I have to select data from table ZABC, which has following fields & data

FieldA Field B

A X

B Y

A Y

C Z

My selection parameter SEL_TAB is a table type with FieldA and FieldB.

I want to write a select statement which gets only records matching both FieldA & FieldB, for example if I pass 'A' & 'X', it should get only first record.

Since my selection parameter contains thousands of records, do I need to write a select statement within loop? or is there a better way to handle this.

Loop at SEL_TAB intl l_sel_tab.

select * from ZABC where fieldA = l_sel_tab-fieldA

and fieldB = l_sel_tab-feildB.

Endloop

Thanks,

Re: Select statement issue

ThomasZloch — Thu, 24 Jun 2010 20:30:27 GMT

Have a look at the SELECT ... FOR ALL ENTRIES ... statement, this does what you are looking for.

Thomas

Re: Select statement issue

Former Member — Thu, 24 Jun 2010 20:52:33 GMT

Since those are simple select-options, you no need to loop them,


select-options: s_fielda for table1-fielda, 
                        s_fieldb for table1-fieldb. 

select * from table1 
             into table <internal table> 
            where fielda in s_fielda 
                and fieldb in s_fieldb.

Thanks

Satyasuresh Donepudi

Re: Select statement issue

Former Member — Thu, 24 Jun 2010 21:05:27 GMT

Thanks Thomas..I dont know how I forgot this option:-)

Anyway, have assigned you the points.