Skip to Content
0
Sep 17, 2016 at 03:13 PM

Problem with select fetching data and processing

51 Views

Hi Experts,

I am doing performance tuning for a program.

I am fetching data from EKET table based on EBELN , EBELP and EINDT field entries into I_EKET table.

Than I am processing the entries in I_EKET table as


SELECT EBELN EBELP EINDT

FROM EKET

INTO TABLE I_EKET

FOR ALL ENTRIES IN I_EKPO

WHERE EBELN EQ I_EKPO-EBELN

AND EBELP EQ I_EKPO-EBELP

AND EINDT IN S_EINDT.

IF I_EKET[] IS NOT INITIAL.

SORT I_EKET BY EBELN EBELP.

DELETE ADJACENT DUPLICATES FROM I_EKET COMPARING ALL FIELDS.


is it possible to write the sort and delete adjacent duplicates inside the select query itself.


Thanks,

RG