delete internal table records by comparing select-options

[Former Member]

i need to delete the i_final internal table records whre exp = select options range, i have writtenthe code can u help me out in this.

l_exp_i LE s_date-high.

wa_final-ebeln = wa_ekko-ebeln.

wa_final-kdatb = wa_ekko-kdatb.

wa_final-kdate = wa_ekko-kdate.

wa_final-lifnr = wa_ekko-lifnr.

wa_final-exp = l_exp_i.

wa_final-ebelp = wa_ekbe-ebelp.

wa_final-matnr = wa_ekko-matnr.

wa_final-ktmng = wa_ekko-ktmng.

wa_final-consume = v_consume.

APPEND wa_final TO i_final.

CLEAR wa_final.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDLOOP.

DELETE i_final WHERE exp < s_date-low.

DELETE i_final WHERE exp > s_date-high.

[Former Member]

i need to delete the i_final internal table records whre exp = select options range, i have writtenthe code can u help me out in this.

l_exp_i LE s_date-high.

wa_final-ebeln = wa_ekko-ebeln.

wa_final-kdatb = wa_ekko-kdatb.

wa_final-kdate = wa_ekko-kdate.

wa_final-lifnr = wa_ekko-lifnr.

wa_final-exp = l_exp_i.

wa_final-ebelp = wa_ekbe-ebelp.

wa_final-matnr = wa_ekko-matnr.

wa_final-ktmng = wa_ekko-ktmng.

wa_final-consume = v_consume.

APPEND wa_final TO i_final.

CLEAR wa_final.

ENDIF.

ENDIF.

ENDIF.

ENDIF.

ENDLOOP.

DELETE i_final WHERE exp < s_date-low.

DELETE i_final WHERE exp > s_date-high.

[Former Member]

HI,

delete <itab> where exp not in s_date.

rgds,

bharat.

[Former Member]

try something like this...

DELETE i_final WHERE exp not in s_date.

[Former Member]

hi,

no need to write two statements.

just write

DELETE i_final WHERE exp not in s_date.

Message was edited by:

Sudha Rani Pathuri

[santhosh_patil]

Hi,

Just use

<b>DELETE i_final WHERE not exp in s_date</b>

-

---

Patil

[Former Member]

Hi

you can try like this

delete table itab where not exp in s_date

regards

Shiva

[Former Member]

Hi

You can use

<b>DELETE i_final where NOT exp IN <select_option>.</b>

Regards

Raj

[Former Member]

hi,

DELETE i_final from wa_final where exp not in s_date.

or

DELETE i_final[] where exp not in s_date.

if helpful reward some points.

with regards,

suresh babu aluri.