Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Performance issue in ME2M and ME2N standard reports in production

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.

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,


Former Member
Not what you were looking for? View more on this topic or Ask a question