Deleting record

[Former Member]

HI,

How to delete duplicates rows

[former_member223537]

DATA: BEGIN OF connection, 
        cityfrom TYPE spfli-cityfrom, 
        cityto   TYPE spfli-cityto, 
        distid   TYPE spfli-distid, 
        distance TYPE spfli-distance, 
      END OF connection. 

DATA connection_tab LIKE SORTED TABLE OF connection 
                    WITH NON-UNIQUE KEY cityfrom cityto 
                                        distid distance. 

SELECT cityfrom cityto distid distance 
       FROM spfli 
       INTO TABLE connection_tab. 

DELETE ADJACENT DUPLICATES FROM connection_tab.

[Former Member]

Hi sagar,

Delete adjacent duplicates from itab comparing primarykey.

<b>

Regards,

Azhar</b>

[paruchuri_nagesh]

hi use key word

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING <FIELD1>

regards

Nagesh.Paruchuri

[Former Member]

Hi

from Internal Table?

SORT the Internal table by Key fields

the use

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING <FIELD1> <FIELD2>

DELETE

DELETE { {FROM target [WHERE sql_cond]}

| {target FROM source} }.

The statement DELETE deletes one or more rows from the database table specified in target. The rows that are to be deleted are specified either in a WHERE condition sql_cond or with data objects in source.

Regards

Anji

[Former Member]

sort the itab...

thene write foll. code...

DELETE ADJACENT DUPLICATES FROM ITAB.

[Former Member]

hi,

first sort your itab whith the unique key that you have in itab or all those fields according to which you want to delete records,

i.e sort itab by fld1 fld2.

delete adjacent duplicates comparing fld1 fld2.

[Former Member]

First most important is to SORT the table by the key which u dont want as duplicate and then use DELETE ADJACENT DUPLICATES

Regards,

Reward if helpful