Hi All,
The following query is giving the error message:
SELECT mkpfbudat msegbwart msegwerks msegmatnr mseg~shkzg
msegmenge msegmeins msegdmbtr maraextwg makt~maktx
INTO TABLE i_src
FROM mkpf
JOIN mseg ON mkpfmblnr = msegmblnr
AND mkpfmjahr = msegmjahr
JOIN mara ON msegmatnr = maramatnr
JOIN makt ON msegmatnr = maktmatnr
WHERE mkpf~budat IN s_budat AND
mseg~bwart IN s_bwart AND
mseg~matnr IN s_matnr AND
mseg~werks IN s_werks AND
mara~mtart = c_mtart AND
makt~spras = sy-langu.
The error message is :
The program ZMMPR_KEY_MOVEMENT has exceeded the maximum permitted runtime and therefore has been terminated.
Can you tell me how we can improve the performance?
Thanks,
Sobhan.