topic Re: Regarding 'Select .... for all entries' statement in Application Development and Automation Discussions

Regarding 'Select .... for all entries' statement

Former Member — Fri, 16 Jan 2009 07:37:42 GMT

Hi experts,

Can anyone suggest me that whether we can use two internal tables in 'Select .... for all entries' statement?

Re: Regarding 'Select .... for all entries' statement

JozsefSzikszai — Fri, 16 Jan 2009 07:41:37 GMT

no, it is not possible.

Re: Regarding 'Select .... for all entries' statement

Former Member — Fri, 16 Jan 2009 07:42:02 GMT

Hi,

I think using two internal tables in select....for all enteries in table degrade the performance in case there is large data.

so better is use two separate select statements for two tables.

Regards

Rajesh Kumar

Re: Regarding 'Select .... for all entries' statement

Former Member — Fri, 16 Jan 2009 07:45:52 GMT

hi,

You cannot have two driver internal tables in the FOR ALL ENTRIES..

thanks

Re: Regarding 'Select .... for all entries' statement

Former Member — Fri, 16 Jan 2009 07:53:47 GMT

Hi,

You can use ranges instead of second for all entries.

Eg:

Say for example i need to write selec statement using fields from two int tables in where conidition namely itab1, itab2.

RANGES: r_vbeln FOR wa_tab1-vbeln.

LOOP AT itab1 INTO wa_tab1.

  r_vbeln-sign = 'I'.
  r_vbeln-option = 'EQ'.
  r_vbeln-low = wa_tab1-vbeln.
  APPEND r_vbeln.
ENDLOOP.

SELECT * FROM vbap INTO TABLE itab3
FOR ALL ENTRIES IN itab2
WHERE vbeln IN r_vbeln "range contains all vbeln from the table itab1
AND matwa = itab2-matwa.

Hope this helps you.

Regards,

Manoj Kumar P