Performance Issue !

[Former Member]

Hi,

I used this query to fetch records.Its taking 5 minutes to fetch the 300000 .

SELECT a_{vkorg a}vtweg a_{vmsta a}dwerk a_{prodh a}pmatn a_{kondm a}mvgr2

b_{matnr b}ersda b_{laeda b}lvorm b_{mtart b}matkl b_{meins b}ferth

b_{groes b}normt b_{volum b}spart b_{prdha c}mmsta c_{beskz c}prctr

c_{losgr c}lgpro d_{stprs d}zkprs d_{zkdat d}ekalr

INTO table it_matl

FROM mvke as a

INNER JOIN mara as b ON a_{matnr = b}matnr

INNER JOIN marc as c ON ( a_{matnr = c}matnr AND

a_{dwerk = c}werks )

INNER JOIN mbew as d ON ( c_{matnr = d}matnr AND

c_{werks = d}bwkey )

WHERE a~vkorg IN s_vkorg

AND a~vtweg IN s_vtweg

AND a~dwerk IN s_werks

AND b~mtart IN s_mtart.

I tried with for all entries and breaking the query into three

by using for all entries but of no use as the time is nearly

5 mints(Cheked performacet through ST05,SE30).

Also tried using SAP notes 332856 (Reading buffered mast data for cust )

Kindly suggest any inputs.

Thanks

Mohinder Singh Chauhan

[Former Member]

Hi,

SELECT a_{vkorg a}vtweg a_{vmsta a}dwerk a_{prodh a}pmatn a_{kondm a}mvgr2

b_{matnr b}ersda b_{laeda b}lvorm b_{mtart b}matkl b_{meins b}ferth

b_{groes b}normt b_{volum b}spart b~prdha

INTO table it_matl

FROM mvke as a

INNER JOIN mara as b ON a_{matnr = b}matnr .

WHERE a~vkorg IN s_vkorg

AND a~vtweg IN s_vtweg

AND a~dwerk IN s_werks

AND b~mtart IN s_mtart.

IF NOT it_matl[] IS INITIAL.

SELECT c_{mmsta c}beskz c~prctr

c_{losgr c}lgpro d_{stprs d}zkprs d_{zkdat d}ekalr

INTO table it_marc

FOR ALL ENTRIES IN it_matl

FROM marc as a

INNER JOIN mbew as d ON ( c_{matnr = d}matnr AND

c_{werks = d}bwkey )

WHERE c~matnr eq it_matl-matnr

AND c~werks eq t_matl-werks.

ENDIF.

Now check it like this......

[Former Member]

Hi Murali,

Thanks

alot for Inputs it certainly helped.

Thanks

Mohinder Singh Chauhan