topic Re: Fetching the data from List tables in Application Development and Automation Discussions

Fetching the data from List tables

Former Member — Mon, 14 Apr 2008 16:21:57 GMT

Hi,

I am trying to fetching that data from List table S501. based on other internal table using "FOR ALL ENTRIES".

It taking much time to get the data.

But when i tried to get the data from MCHB table using the above procedure. it taking less time.

May i know the procedure how to fetch the data very fastly from the list tables like S501

Thanks

Lucky

Re: Fetching the data from List tables

Former Member — Mon, 14 Apr 2008 16:53:26 GMT

i dont think there is a shortcut..

try to define all possible keys.. even if there are no contents for most of them..

for eg, define ranges for SPMON, vkorg etc...

and in selection query,

specify all of them

where

spmon in R_spmon and

vkorg in r_vkorg and

.....

compare with your current code, and see whether atleast some improvement is there... i have noticed at least 25 % improvement..

Re: Fetching the data from List tables

Former Member — Tue, 15 Apr 2008 04:48:29 GMT

i think that is not because of the database table, but may be you are not making sure the internal table which you are using in FOR ALL ENTRIES is blank or what.

If the internal table does not contain entries than it will fetch all the data from the database table.

So befor writing FOR ALL ENTRIES make sure the internal table which you are using must contain atleast a entry in it.

Re: Fetching the data from List tables

Former Member — Tue, 15 Apr 2008 04:59:26 GMT

Sujamol Augustine ,

yes you are right..... there was increase in perfromance to 25%if we use the primary keys fields even if not necessary.

Thanks for your help.

Lucky

Re: Fetching the data from List tables

Former Member — Tue, 15 Apr 2008 05:03:43 GMT

Hemant,

My internal table is having the data.

and also i used the following statment before going to fetch

if itab[] is not initial.