Skip to Content
0
Former Member
Sep 04, 2007 at 06:31 AM

performance tuning - huge data in table EKPO

734 Views

hi guys,

I have this select statement:

SELECT a~ebeln

a~ebelp

a~ktmng

a~loekz

a~meins

a~umrez

a~umren

a~werks

b~bsart

b~lifnr

b~kdatb

b~kdate

a~konnr

a~ktpnr

b~bstyp

INTO CORRESPONDING FIELDS OF TABLE i_purch_doc2

FROM ekpo AS a

INNER JOIN ekko AS b

ON aebeln = bebeln

FOR ALL ENTRIES IN li_purch_doc

WHERE b~bstyp = c_l

AND a~konnr = li_purch_doc-ebeln

AND a~ktpnr = li_purch_doc-ebelp.

IF sy-subrc = 0.

endif.

I have a performance issue because table EKPO has very huge data, it has 1213339 data on it. how can i solve this issue?

i hope someone could help me.

thanks very much.