Hi All,
I have a requirement as below.
I have a internal table i_eket with some fields from ekpo ekko and eket.
IF NOT r_dates[] IS INITIAL.
SELECT eket~ebeln
eket~ebelp
eket~eindt
ekpo~matnr
ekpo~ematn
ekpo~werks
ekko~lifnr
INTO TABLE i_eket
FROM eket
INNER JOIN ekpo ON ekpoebeln = eketebeln AND
ekpoebelp = eketebelp
Inner Join ekko ON ekkoebeln = ekpo ebeln.
WHERE eket~eindt IN r_dates
AND ekpo~werks IN r_werks
AND ekpo~loekz = ' '.
ENDIF.
Now i need to delete some records from this internable table.
the condition is all the pos having land1( country) as 'US ' must be deleted .
I am thinking the logic as below.
Select lifnr from LFA1 into table i_lfa1
Where land1 = 'US'.
Loop at i_lfa1
Delete i_eket where ekkolifnr = i_lfa1lifnr.
Endloop.
can you suggest me logic with better performance.