Skip to Content
avatar image
Former Member

Performance Issue in ME2M and ME2M Reports

Hi Experts,

I was running these 2 reports ME2M and ME2N in back ground, I Have given all the possibilities of selection criteria, But its taking 25 to 30 minutes of time and displaying only 15 to 20 records. I found a query inside the code. I running over a range of 20,000 records.

SELECT * INTO CORRESPONDING FIELDS OF TABLE lt_ekpo
FROM ekko as k INNER JOIN ekpo as p
ON p~ebeln = k~ebeln
WHERE k~lifnr IN s_lifnr             "EKKO-Data
  AND k~ekorg IN r_ekorg
  AND k~bsart IN s_bsart
  AND k~ekgrp IN s_ekgrp
  AND k~reswk IN s_reswk
  AND k~bedat IN s_bedat
  AND p~matnr IN em_matnr            "EKPO-Data
  AND p~werks IN em_werks
  AND p~bstyp IN r_bstyp
  AND p~wepos IN r_wepos
  AND p~repos IN r_repos
  AND p~loekz IN r_loekz
  AND p~pstyp IN r_pstyp
  AND p~knttp IN s_knttp
  AND p~matkl IN s_matkl
  AND p~ean11 IN s_ean11
  AND p~idnlf IN s_idnlf
  AND p~ltsnr IN s_ltsnr
  AND p~aktnr IN s_aktnr
  AND p~saiso IN s_saiso
  AND p~saisj IN s_saisj
  AND p~ebeln IN s_ebeln.

how can i fix this performance issue. any suggestions.

Thanks & Regards,

Poorna.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 18, 2009 at 08:07 AM

    you cannot solve this yourself, except you copy the program to a Z-report and change the ABAP to your specific needs.

    Better report it as problem to SAP.

    Add comment
    10|10000 characters needed characters exceeded