topic Re: perfomnace issue in Application Development and Automation Discussions

perfomnace issue

Former Member — Tue, 03 Jun 2008 04:31:45 GMT

Hi guys,

i have to remove nested select endselect statement please help.

Re: perfomnace issue

Former Member — Tue, 03 Jun 2008 04:36:37 GMT

hi,

for that u have to

add 'into (corresponding fields of) table itab.'

~~ please be specific. or give ur code here!!!

regards,

madhu

Re: perfomnace issue

Former Member — Tue, 03 Jun 2008 04:43:23 GMT

Hi,

Try to use join query or else populate entries into internal table and fetch entries in another table using that internal table.

Thanks

Murugan.B

Re: perfomnace issue

Former Member — Tue, 03 Jun 2008 04:45:08 GMT

thanks for response,

actually my TL is telling to use FOR ALL ENTRIES.

i don't know how to use it.please guide

Re: perfomnace issue

Former Member — Tue, 03 Jun 2008 05:06:27 GMT

say if u want to display material and its text. u can use this concept.

~from the master table i'm selecting the materials based on the input s_matnr.

~then for the materials selected above , i have to get their corresponding description.

ie:

select matnr from mara into table i_matnr

where matnr in s_matnr.

if sy-subrc = 0.

select matnr maktx

from makt into table i_makt

for all entries in i_matnr

where matnr = i_mara-matnr.

endif.

This is similar to INNER JOIN concept. get the common data from 2 tables based on the input. Sometimes Join will give poor performance , n there u can use FOR ALL ENTRIES.

regards,

madhu

Re: perfomnace issue

Former Member — Wed, 04 Jun 2008 03:21:13 GMT

Hi,

Madhumita is right............

with that Never forget to use

SORT and DELETE ADJASCENT DUPLICATES stmt whenever u use FOR ALL ENTRIES stmt in SELECT....

Try to check everytime if the table going to be checked wether INITIAL or not.....

performance will be gud...

Reward all helpful answers,

Thanks

Re: perfomnace issue

Former Member — Wed, 04 Jun 2008 06:29:11 GMT

hi...

instead of using nested select end select while writing select query use' select * from ....into table .....itwill select all enties at one go in your internal table for given conditions.

Re: perfomnace issue

Former Member — Thu, 05 Jun 2008 05:43:36 GMT

ive me ur id will send you code where for all entries has been used