topic Re: Read in Application Development and Automation Discussions

Read

Former Member — Tue, 12 Jun 2007 05:46:46 GMT

Iam fetching data frm few tables and want to put into final table,but which is better peformance..

ex 1. iam getting data from vbak and vbap(join) into i_vbap

2. vbuk and vbkd(join) into i_vbuk where vbeln = i_vbap-vbeln.

3.select parnt from table into i_parnt where id1 = i_vbap-kunnr and wert1 =

i_vbuk-bzirk.

4.get field from ibin into i_ibin where field = i_vbap-cuobj.

wich is best to loop.

Any help is higly appreciated.

Thanks

Former Member — Tue, 12 Jun 2007 05:52:02 GMT

hi krk,

first loop on i_vbap itab,

then throug read u can move-corresponding fields to final internal table from the ramining itab's.

this is good method even for performance.

regards,

seshu.

seshatalpasai_madala — Tue, 12 Jun 2007 05:53:34 GMT

Hi,

I think first two steps are fine.

In the 3rd and 4th step you can use IN or FOR ALL ENTRIES to get the values you need not loop.

Regards,

Sesh

Former Member — Tue, 12 Jun 2007 05:53:42 GMT

You mean to say loop i_vbap

and Read all tables and if sy-subrc = 0. then move to final internal tale.

Former Member — Tue, 12 Jun 2007 05:54:10 GMT

Hi,

The best way is loop throgh the i_vbap and then use READ for other tables.

SORT all other tables before use so that you can use BINARY SEARCH.

Reward points if useful.

Regards,

Atish

Former Member — Tue, 12 Jun 2007 05:55:04 GMT

ya that's right.

proceed.