Data Dic??

Hi Vipin,

We Can use DELETE Keyword For Deleting the Record From Table.

Check this Example.

TABLES:MARA.

SELECT-OPTIONS:S_MATNR FOR MARA-MATNR.

DATA:ITAB LIKE MARA OCCURS 0 WITH HEADER LINE.

START-OF-SELECTION.

SELECT * FROM MARA INTO TABLE ITAB WHERE MATNR IN S_MATNR.

LOOP AT ITAB.

DELETE MARA FROM TABLE ITAB.

ENDLOOP.

Hi,

Use this code this will surely work..

DELETE ADJACENT DUPLICATES FROM (table name)COMPARING (field name).

eg:

DELETE ADJACENT DUPLICATES FROM t_tot_wegh COMPARING vpobjkey.

Regards,

Ari

Hi ,

Can u please try this code.

loop at itab into wa_itab.

on change of itab-matnr.

clear l_index.

endon.

l_index = l_index + 1.

if l_index > 2.

delete dbname from wa_itab.

endif.

endloop.

Regards

DV

Hi, This may help you.

select * from z-table into itab.

loop at itab into wa.

if sy-tabix = 10.

DELETE FROM Z-Plant where plant = wa-plant.

endif.

Endloop.

With Regards

Madhu