topic Re: Delete Statement in Application Development and Automation Discussions

Delete Statement

Former Member — Thu, 23 Jan 2014 13:46:37 GMT

i have a code like below

DELETE lt_cddetails WHERE tabname EQ 'KONDAT' AND

( f_old EQ '00.00.000' OR chngind EQ 'I' )

If this internal table contains f_old as 00/00/0000 it is not deleting that entry. Is there any way to delete this for all null values ? ( other than adding all possible formats in OR condition ?

Regards,

Praveen

Re: Delete Statement

Former Member — Thu, 23 Jan 2014 13:52:07 GMT

hi,

date store internally different format so try this

DELETE lt_cddetails WHERE tabname EQ 'KONDAT' AND

( f_old eq '00000000' OR chngind EQ 'I' )

thanks

Re: Delete Statement

nabheetscn — Thu, 23 Jan 2014 13:55:39 GMT

You can use delete itab wher f_old is initial. did you search before posting?

Re: Delete Statement

Former Member — Thu, 23 Jan 2014 14:26:47 GMT

Check Below code

TYPES:

   BEGIN OF t_date,
     date TYPE sy-datum,
    END OF t_date.
DATA:
       i_date TYPE TABLE OF t_date,
       i_date_line TYPE t_date.

i_date_line-date = sy-datum.
APPEND i_date_line TO i_date.
CLEAR i_date_line.
APPEND i_date_line TO i_date.

DELETE i_date WHERE date IS INITIAL.

Thanks

Re: Delete Statement

Former Member — Thu, 23 Jan 2014 14:37:03 GMT

Here f_old is String type not of type sy-datum.

Regards,

Praveen

Re: Delete Statement

RaymondGiuseppi — Thu, 23 Jan 2014 14:52:52 GMT

If the string data is not provided with a fixed format, you could expect a null value to contain only space, '0', '.', '-' and '/', So you could use a test like


WHERE f_old CO ' 0.,-/'.

(ref - log_exp - Comparison Operators for Character-Like Data Types)

Regards,

Raymond

Re: Delete Statement

Former Member — Fri, 24 Jan 2014 05:40:58 GMT

try like this

DELETE lt_cddetails WHERE tabname EQ 'KONDAT' AND

( f_old is intial OR chngind EQ 'I' )

Re: Delete Statement

Former Member — Fri, 24 Jan 2014 06:07:24 GMT

F_old is string field we can't use initial here.Here CO '0./- ' is working for me.

Regards,

Praveen

Re: Delete Statement

former_member197781 — Fri, 24 Jan 2014 06:19:56 GMT

praveen kumar

delete FROM tabnam WHERE date <= '01.01.0001' and field = 'xxx'.

I think it gives u the answer u required.

regards,

N.SUDHAKAR