Skip to Content
0
Former Member
Feb 23, 2009 at 02:10 PM

performance error: table DFKKOP No field of a table index in WHERE conditn

551 Views

Hello ,

I am geeting the error " Large table DFKKOP: No field of a table index in WHERE condition" in below mention select query in performace check .

SELECT opbel

INTO lt_dfkkop1

FROM dfkkop

WHERE hvorg EQ '6500'

AND spart EQ 'ME'

AND budat IN r_budat.

ENDSELECT.

IF NOT lt_dfkkop1[] IS INITIAL.

SELECT opbel budat awkey AS xblnr waers awtyp awkey

INTO CORRESPONDING FIELDS OF TABLE lt_dfkkko

FROM dfkkko

WHERE opbel = lt_dfkkop1-opbel

AND budat IN r_budat

AND awtyp EQ 'VBRK'.

ENDIF.

Please help me out

Regards

Rahul