topic Re: problem with mseg table in Application Development and Automation Discussions

problem with mseg table

Former Member — Mon, 21 Apr 2008 12:44:38 GMT

hi,

I am fetching data from MSEG table but it takes more time to retrive data..... I have tried with secondary indexes also..

but the performance of the program has not improved...

I am selecting with non-keyfields only ....

IF NOT i_mara[] IS INITIAL.

SELECT mblnr

mjahr

zeile

bwart

matnr

werks

shkzg

dmbtr

menge

FROM mseg

INTO TABLE i_mseg

FOR ALL ENTRIES IN i_mara

WHERE matnr EQ i_mara-matnr

AND werks EQ p_werks

AND lgort IN r_lgort

AND bwart IN r_bwart.

IF sy-subrc NE 0.

Sy-subrc check not required

STOP.

ENDIF.

this is my select statment with this only i have to select i have not other option this is my requirement.....

can any one guide me to improve my pgm performenace.. i have tried with all possible tables.....

Re: problem with mseg table

Former Member — Mon, 21 Apr 2008 12:49:51 GMT

Hi,

Please check out if the order of the fields in where condition is same as that of the order of secondary index. If possible run the report in background.

Regards,

Santosh

Re: problem with mseg table

Former Member — Mon, 21 Apr 2008 12:54:06 GMT

hi,

The order of fields are correct, it is working in background

it takes more than 0ne hour to execute client dont want this performance......

Re: problem with mseg table

Former Member — Mon, 21 Apr 2008 13:05:15 GMT

Hi,

Try to use MBLNR and MJAHR in your select statement, then only you can improve the performance of the report. Even if you use secondary index also you will not achive the performance.

Thanks,

Sriram Ponna.

Re: problem with mseg table

Former Member — Mon, 21 Apr 2008 13:11:47 GMT

hi,

My requirements is as such i donot have any options I have to go with this where clause only

Regards,

priya

Re: problem with mseg table

Former Member — Wed, 23 Apr 2008 06:44:03 GMT

This may not be achieved whatever options is used

Re: problem with mseg table

asik_shameem — Wed, 23 Apr 2008 06:59:00 GMT

Hi,

Create a RANGE for the key fields and use them in SELECT query. It will help.

DATA: r_mblnr TYPE RANGE OF mseg-mblnr,
 r_mjahr TYPE RANGE OF mseg-mjahr,
 r_zeile TYPE RANGE OF mseg-zeile.

SELECT 
mblnr
mjahr
zeile
bwart
matnr
werks
shkzg
dmbtr
menge
FROM mseg
INTO TABLE i_mseg
FOR ALL ENTRIES IN i_mara
WHERE matnr EQ i_mara-matnr

AND mblnr IN r_mblnr
AND mjahr IN r_mjahr
AND zeile IN r_zeile

AND werks EQ p_werks
AND lgort IN r_lgort
AND bwart IN r_bwart.

Re: problem with mseg table

Former Member — Thu, 05 Jun 2008 13:32:29 GMT

Hi,

Am getting the same problem with MSEG table (Performance issue). Can you please tell me how to solve the. Code will be helpful.

Regards,

Vijay.

Re: problem with mseg table

Former Member — Fri, 20 Jun 2008 13:11:00 GMT

Dear Banu

I also tired with the same problem, if you got the solution please update me to my business card id

Thanks in Advance

Re: problem with mseg table

Former Member — Fri, 20 Jun 2008 13:12:26 GMT

nelsonDOTrodrigoATloadstarlkDOTcom