Hi experts,
I have performance issue with the below piece of code. since its going for time out error in quality system in ECC 6.0 but its working fine in development and production systems in R/3 sytems.
SELECT dlifnr dland1 dname1 dstras dpstlz dort01
k~stblg
fbuzei faugdt f~augbl
fdmbtr fqbshb f~hkont
fbukrs fbelnr f~blart
a~landx
FROM bkpf AS k INNER JOIN bsak AS f
ON kbukrs = fbukrs
AND kbelnr = fbelnr
AND kgjahr = fgjahr
INNER JOIN lfa1 AS d
ON flifnr = dlifnr
INNER JOIN t005t AS a
ON dland1 = aland1
INTO CORRESPONDING FIELDS OF TABLE gt_data
FOR ALL ENTRIES IN gt_item
WHERE k~bukrs = gt_item-bukrs
AND k~belnr = gt_item-belnr
AND k~gjahr = gt_item-gjahr
AND ( f~blart = 'ZP'
OR f~blart = 'KZ' )
AND k~stblg = ''
AND a~spras = 4.
so, can u please suggest how can i rectify this issue.