topic Re: Delete itab From 2 To. in Application Development and Automation Discussions

Delete itab From 2 To.

muhammad_sohail — Tue, 01 Jun 2010 10:33:42 GMT

Dear All,

I want to delete itab on the basis of input which I enter on selection screen. Means I want to use delete as a between operator. e.g; delete field values between input_from to input_to.

I am using the following statement. It is not fullfilling my requirements, not deleteing all values from 2 to.

DELETE itab where field LE input_from AND field LE input_to.

Which statement I should use.

Thanks and Regards,

Sohail

Re: Delete itab From 2 To.

Former Member — Tue, 01 Jun 2010 10:38:28 GMT

hi,

please check GE( equal or greater) at your code.

DELETE itab where field GE input_from AND field LE input_to.

regards,

orhan

Re: Delete itab From 2 To.

Former Member — Tue, 01 Jun 2010 10:42:12 GMT

I guess you can directly use the BETWEEN addition


DELETE itab where field BETWEEN input_from AND input_to.

Vikranth

Re: Delete itab From 2 To.

Former Member — Tue, 01 Jun 2010 10:45:05 GMT

Hi Sohail,


DELETE itab WHERE field GE input_from AND field LE input_to.

This code will delete the record from itab the data of the field is between the range input_from & input_to.

Regards

Dillip

Re: Delete itab From 2 To.

Former Member — Tue, 01 Jun 2010 10:46:24 GMT

DELETE itab where field *LE* input_from AND field LE input_to.

Could it be GE.

Reddy

Re: Delete itab From 2 To.

Former Member — Tue, 01 Jun 2010 10:47:57 GMT

s_field-low = input_from.

s_field-sign = 'I'.

s_field-option = 'BT'.

s_filed-high = input_to.

append s_field.

DELETE itab where field in s_field.

Thanks

Regards

I.Muthukumar.

Re: Delete itab From 2 To.

Former Member — Tue, 01 Jun 2010 10:48:29 GMT

Hi,

try this:


TABLES: MARA.
SELECT-OPTIONS: S_MATNR FOR MARA-MATNR.
*
DATA: IT_ITAB TYPE TABLE OF MARA.
DATA: wa_ITAB TYPE          MARA.
*
SELECT * FROM MARA UP TO 100 ROWS INTO TABLE IT_ITAB.
*
LOOP AT IT_ITAB INTO WA_ITAB. WRITE: / WA_ITAB-MATNR. ENDLOOP.
DELETE IT_ITAB WHERE MATNR IN S_MATNR.
LOOP AT IT_ITAB INTO WA_ITAB. WRITE: / WA_ITAB-MATNR. ENDLOOP.

Regards, Dieter

Re: Delete itab From 2 To.

Former Member — Tue, 01 Jun 2010 10:53:00 GMT

Hi,

TYPES : BEGIN OF t_ekko,

ebeln TYPE ekko-ebeln,

END OF t_ekko.

DATA : it_ekko TYPE TABLE OF t_ekko,

wa_ekko TYPE t_ekko,

line TYPE i.

PARAMETERS : p_ebeln TYPE ekko-ebeln.

START-OF-SELECTION.

wa_ekko-ebeln = '4500109249'.

APPEND wa_ekko to it_ekko.

wa_ekko-ebeln = '4500109250'.

APPEND wa_ekko to it_ekko.

wa_ekko-ebeln = '4500109251'.

APPEND wa_ekko to it_ekko.

wa_ekko-ebeln = '4500109252'.

APPEND wa_ekko to it_ekko.

wa_ekko-ebeln = '4500109253'.

APPEND wa_ekko to it_ekko.

wa_ekko-ebeln = '4500109254'.

APPEND wa_ekko to it_ekko.

wa_ekko-ebeln = '4500109255'.

APPEND wa_ekko to it_ekko.

wa_ekko-ebeln = '4500109256'.

APPEND wa_ekko to it_ekko.

CLEAR : line.

DELETE it_ekko where ebeln BETWEEN '4500109250' AND '4500109255'.

DESCRIBE TABLE it_ekko LINES line.

WRITE : line.

With Regards,

Sumodh.P