Fetching the data from List tables

[Former Member]

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

[Former Member]

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

[Former Member]

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..

[Former Member]

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

[Former Member]

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.

[Former Member]

Hemant,

My internal table is having the data.

and also i used the following statment before going to fetch

if itab[] is not initial.