on 05-15-2009 10:47 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.