Skip to Content
0
Former Member
Apr 29, 2009 at 12:48 PM

Deleting interanl table records

71 Views

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.