topic Re: Report using table mseg in Application Development and Automation Discussions

Report using table mseg

Former Member — Tue, 30 Jan 2007 10:44:58 GMT

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

Re: Report using table mseg

Former Member — Tue, 30 Jan 2007 10:48:12 GMT

Hi Ashish,

To make your report faster, the first things is to use the table key or the index.

Then, you can use either a JOIN between MKPF & MSEG( on MBLNR & MJAHR ), or after a MKPF selection, use the FOR ALL ENTRIES Statement to select into MSEG.

Erwan

Re: Report using table mseg

Former Member — Tue, 30 Jan 2007 10:48:33 GMT

Pass MBLNR & MJAHR in where condition.

Re: Report using table mseg

Former Member — Tue, 30 Jan 2007 10:49:05 GMT

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.