topic Re: MSEG Performance Issue in Application Development and Automation Discussions

MSEG Performance Issue

Former Member — Fri, 20 Apr 2007 05:00:21 GMT

Hi All,

I have to access data from MKPF & MSEG tables.

I first take the data from MKPF(give BUDAT in the where condition) in an internal table.

Then i loop through that internal table and select data from MSEG. I am giving all the primary keys in the where clause for MSEG. It has to extract just 25 records, but when I see in SM50 it shows sequential read for MSEG, and also takes lot of time(more than 1200 secs).

Plz suggest me a sol...how do I fix this problem

Thanks & regards

Niyati

Re: MSEG Performance Issue

Former Member — Fri, 20 Apr 2007 05:24:57 GMT

create a secondary index for MSEG and MKPF also.

if i_mkpf[] is not initial.

select * from mseg into corresponding fields of imseg

for all entreis in i_mkpf

where mblnr = i_mkpf-mblnr

mjahr = i_mkpf-mjahr.

endif.

Regards

Prabhu

Re: MSEG Performance Issue

Former Member — Fri, 20 Apr 2007 08:14:09 GMT

Select inside a LOOP-ENDLOOP can cause performance bottleneck.

try to use FOR ALL ENTRIES. delete the duplicate entries before that:

try this:

sort it_mkpf by mblnr mjahr.  " chk this
if i_mkpf[] is not initial.
 select mblnr mjahr zeile 
    into table it_mseg
    from mseg
    for all entries in it_mkpf
    where mblnr = it_mkpf-mblnr and
              mjahr = it_mkpf-mjahr.
endif.

**reward if helpful

regards,

madhu

Re: MSEG Performance Issue

Former Member — Fri, 20 Apr 2007 13:01:16 GMT

hi,

use binary search with read statement.and create secondary indexes for mseg fields.

thanks & regards,

j.prakash.

Re: MSEG Performance Issue

Former Member — Sat, 21 Apr 2007 13:27:10 GMT

INSTEAD OF USING LOOP USE SELECT ..........FOR ALL ENTRIES STATEMENT .

EX.

SELECT <SELECTION LIST>

FROM MSEG

INTO TABLE I_MSEG

FOR ALL ENTRIES IN I_MKPF

WHERE MBLNR EQ I_MKPF-MBLNR

AND BUDAT EQ I_MKPF-BUDAT.

I THINK THIS WOULD SOLVE UR PROBLEM.

Re: MSEG Performance Issue

VijayasekarK — Mon, 23 Apr 2007 11:16:34 GMT

Hi ,

Check this sap note for custom developments in MM module...

191492 Performance: Customer developments in MM/WM

Regards,

K Vijayasekar

Re: MSEG Performance Issue

Former Member — Mon, 23 Apr 2007 16:11:38 GMT

Please use below following Option to get good Performance

1. Use For all entries if possible

2. use Read Statement with binary search ,before this one use sort command.

3. use Secondary index in where condition if table created secondary index for MSEG.

use all where condition .

if it is useful give me award points

Thanks

Seshu

Re: MSEG Performance Issue

Sathish — Tue, 24 Apr 2007 03:40:49 GMT

check this link.. this should help..

https://wiki.sdn.sap.com/wiki/display/ABAP/ABAP+Performance

Re: MSEG Performance Issue

Former Member — Wed, 25 Apr 2007 11:34:06 GMT

Hi Akash ,

Try to use the view WB2_V_MKPF_MSEG to get the data .

This will improve your performance .

Regards ,

Praveen .