Skip to Content
0
Former Member
Apr 21, 2010 at 04:02 AM

perfomance issue in quality

35 Views

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.