Report using table mseg

[Former Member]

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

[Former Member]

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

[Former Member]

Pass MBLNR & MJAHR in where condition.

[Former Member]

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.