01-30-2007 10:44 AM
Well i m makin a report on material consumption which gets the opening stock, purchase, consumption & closing stock of all the materials in a particular month.
i m getting mblnr from mkpf table & then go to mseg table. but it is taking a lot of time. can i make it faster. how??
01-30-2007 10:48 AM
Hi Ashish,
To make your report faster, the first things is to use <b>the table key or the index</b>.
Then, you can use either a <b>JOIN</b> between MKPF & MSEG( on MBLNR & MJAHR ), <b>or</b> after a MKPF selection, use the <b>FOR ALL ENTRIES</b> Statement to select into MSEG.
Erwan
01-30-2007 10:48 AM
Hi Ashish,
To make your report faster, the first things is to use <b>the table key or the index</b>.
Then, you can use either a <b>JOIN</b> between MKPF & MSEG( on MBLNR & MJAHR ), <b>or</b> after a MKPF selection, use the <b>FOR ALL ENTRIES</b> Statement to select into MSEG.
Erwan
01-30-2007 10:48 AM
01-30-2007 10:49 AM
hi,
can u paste ur code here to know the exact pblm. if u r using read table statement then use binary search option with it.
is u r using select in loop then avoid it and use for all entries to amke it faster.
it would be nice if u paste ur code to know the pblm clearly.
check tips in the run time analysis.
hope this helps u.
reward points if helpful.