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.