topic Re: Select in Application Development and Automation Discussions

Select

Former Member — Fri, 30 May 2008 10:46:37 GMT

I have an internal table ITAB with work area WA_ITAB with (n-2) fields filled in

I need to fill two more fields from anotehr database table depending on condition databse table-fieldname = WA_ITAB

Hoe to do this

Re: Select

valter_oliveira — Fri, 30 May 2008 10:52:04 GMT

Hello.

Considering that the key of that database table is field1 of your internal table, do like this:


LOOP AT itab INTO wa.
  SELECT SINGLE fieldn-1 fieldn
    FROM database_table
    INTO (wa-fieldn-1, wa-fieldn)
   WHERE field1 = wa-field1.
  CHECK sy-subrc EQ 0.
  MODIFY itab FROM wa TRANSPORTING fieldn-1 fieldn.
ENDLOOP.

Best regards.

Valter Oliveira.

Re: Select

Former Member — Fri, 30 May 2008 10:52:58 GMT

Hi,

Use transporting option.

then u can insert data into new fields.

Re: Select

Former Member — Fri, 30 May 2008 10:55:39 GMT

Use "for all entries"

select query in loop is not at all advisable..

It will reduce ur performance to a level in production..

Regards..

Manish.