Skip to Content
0
Former Member
Apr 23, 2014 at 04:20 AM

MKPF & MSEG Performance issue : Join on table MKPF & MSEG taking too much time ..

1423 Views

Hello Experts,

I had a issue where we are executing one custom report in which i used inner join on table MKPF & MSEG, some time join statement took 9-10 min to excute and some time execute within 1-2 min with same test data .

i am not able to understand what the actaully happing .

please help.

code :

SELECT f~mblnr f~mjahr f~usnam f~bktxt p~bukrs
INTO TABLE itab
FROM mkpf AS f INNER JOIN mseg AS p
ON f~mblnr = p~mblnr AND f~mjahr = p~mjahr
WHERE f~vgart = 'WE'
AND f~budat IN p_budat
AND f~usnam IN p_sgtxt
AND p~bwart IN ('101','105')
AND p~werks IN p_werks
AND p~lgort IN p_lgort.

Regards,

Dipendra Panwar.