ALV Report running for hours in QA box
My ALV report is running fine in development and production box but its running for hours in QA box. Following is the code where itÂ’s running for hours in QA box. Any help will be appreciated.
SELECT materialid~matnr_int
materialid~matnr_ext
zgrzrxxinv~werks
zgrzrxxinv~bklas
zgrzrxxinv~lbkum
zgrzrxxinv~verpr
zgrzrxxinv~peinh
zgrzrxxreq~dat00
zgrzrxxreq~rqmts
marc~schgt
marc~dispo
t024d~dsnam
FROM materialid AS materialid
INNER JOIN zgrzrxxinv AS zgrzrxxinv
ON zgrzrxxinvmatnr = materialidmatnr_int
INNER JOIN zgrzrxxreq AS zgrzrxxreq
ON zgrzrxxreqmatnr = materialidmatnr_int AND
zgrzrxxinvwerks = zgrzrxxreqwerks
INNER JOIN marc as marc
ON zgrzrxxreqmatnr = marcmatnr AND
zgrzrxxinvwerks = marcwerks
INNER JOIN t024d as t024d
ON marcdispo = t024ddispo AND
zgrzrxxinvwerks = t024dwerks
INTO TABLE gt_extrct
WHERE zgrzrxxinv~matnr IN s_matnr AND
zgrzrxxinv~werks IN s_werks AND
zgrzrxxinv~bklas IN s_bklas.
With Thanks
Sanjeet Rai