Delete Statement

[Former Member]

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

[Former Member]

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

[nabheetscn]

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

[Former Member]

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

[Former Member]

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

Regards,

Praveen

[RaymondGiuseppi]

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

[Former Member]

try like this

DELETE lt_cddetails WHERE tabname EQ 'KONDAT' AND

                                  ( f_old is intial OR chngind EQ 'I' )

[Former Member]

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

Regards,

Praveen

[former_member197781]

hi

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