topic Re: [Performance Issue] Select from MSEG in Application Development and Automation Discussions

[Performance Issue] Select from MSEG

Former Member — Wed, 25 Jul 2007 05:45:49 GMT

Hi experts,

Need your help on how to improve the performance in the select from MSEG, it takes about 30 minutes to just finish the select. Thanks!

SELECT mblnr

mjahr

zeile

bwart

matnr

werks

lgort

charg

shkzg

menge

ummat

lgpla

FROM mseg

INTO CORRESPONDING FIELDS OF TABLE i_mseg2

FOR ALL ENTRIES IN i_likp

WHERE bwart IN ('601','602','653','654')

AND matnr IN s_matnr

AND werks IN s_werks

AND lgort IN s_sloc

AND lgpla EQ i_likp-vbeln.

Re: [Performance Issue] Select from MSEG

Former Member — Wed, 25 Jul 2007 05:47:49 GMT

try to avoid corrosponding field command.you will get the difference.

Re: [Performance Issue] Select from MSEG

Former Member — Wed, 25 Jul 2007 05:48:39 GMT

Hi,

an important field for MSEG is the year.

MJAHR

You should put it in your select. In best case use it only with 1 year and not as an intervall.

Regards

Nicole

Re: [Performance Issue] Select from MSEG

Former Member — Wed, 25 Jul 2007 05:59:23 GMT

Hi,

Try to include all the key fields in ur selection criteria for this query.

The primary key fields of MSEG table is MBLNR, MJAHR, ZEILE.

But none of the key fields or included in ur where condition. This will definitely impact in performance

Re: [Performance Issue] Select from MSEG

kesavadas_thekkillath — Wed, 25 Jul 2007 06:14:38 GMT

store all the vbeln to ranges.

ranges:r_vbeln for i_likp-vbeln.

r_vbeln-option = 'EQ'.

r_vbeln-sign = 'I'.

loop at i_likp.

r_vbeln-low = i_likp-vbeln.

append r_vbeln.

endloop.

sort r_vbeln ascending

delete adjacent duplicates from r_vbeln.

then modify the fetch as below.

donot use a loop to fetch data from mseg.

SELECT mblnr mjahr zeile bwart matnr werks lgort charg shkzg menge ummat lgpla

FROM mseg client specified INTO CORRESPONDING FIELDS OF TABLE i_mseg2

FOR ALL ENTRIES IN i_likp

where mandt = sy-mandt

and (bwart = '601' or bwart = '602' or bwart = '653' or bwart = '654' )

AND matnr IN s_matnr

AND werks IN s_werks

AND lgort IN s_sloc

AND lgpla in r_vbeln.

there is another table where u can get this data...i,ll let u know shortly...

try with this if useful

reward points....

Re: [Performance Issue] Select from MSEG

kesavadas_thekkillath — Wed, 25 Jul 2007 06:16:03 GMT

sorry, remove the for all entries from u r query and apply this

Re: [Performance Issue] Select from MSEG

kesavadas_thekkillath — Wed, 25 Jul 2007 06:20:01 GMT

if any where u can apply the date range it will be useful...

get the mblnr from mkpf for the date range and pass in mseg fetch.

Re: [Performance Issue] Select from MSEG

kesavadas_thekkillath — Wed, 25 Jul 2007 06:26:04 GMT

there is one more table where u can get related data of mseg

S225

check it.......

from there u can get the data related to mseg and its fast