topic Re: Deleting record in Application Development and Automation Discussions

Deleting record

Former Member — Thu, 11 Oct 2007 04:47:33 GMT

HI,

How to delete duplicates rows

Re: Deleting record

Former Member — Thu, 11 Oct 2007 04:48:26 GMT

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.

Re: Deleting record

Former Member — Thu, 11 Oct 2007 04:49:04 GMT

Hi sagar,

Delete adjacent duplicates from itab comparing primarykey.

<b>

Regards,

Azhar</b>

Re: Deleting record

paruchuri_nagesh — Thu, 11 Oct 2007 04:50:01 GMT

hi use key word

DELETE ADJACENT DUPLICATES FROM ITAB COMPARING <FIELD1>

regards

Nagesh.Paruchuri

Re: Deleting record

Former Member — Thu, 11 Oct 2007 04:50:05 GMT

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

Re: Deleting record

Former Member — Thu, 11 Oct 2007 04:50:27 GMT

sort the itab...

thene write foll. code...

DELETE ADJACENT DUPLICATES FROM ITAB.

Re: Deleting record

Former Member — Thu, 11 Oct 2007 04:51:22 GMT

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.

Re: Deleting record

Former Member — Thu, 11 Oct 2007 04:51:40 GMT

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