Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Delete Filed Values from DB tabel

Former Member
0 Kudos

Hi all,

i need to delete perticular field values from Database table using Program.

I have to delete only perticular field values not other filed values.

thanks in advance.

Thanks,

Subu.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

- Read the database table.

- Loop at entries.

- Modify entries

- Update the entry back using UPDATE statement.

Let me know if you need any other information.

Regards,

RS

2 REPLIES 2

Former Member
0 Kudos

Hi,

- Read the database table.

- Loop at entries.

- Modify entries

- Update the entry back using UPDATE statement.

Let me know if you need any other information.

Regards,

RS

Former Member
0 Kudos
data : itab type table of ZTABLE.

SELECT  * from ztable into table itab where fieldname eq 'XXXXX'.

loop at itab into wa_itab.
  clear wa_itab-field.          "<-------- field to be deleted
  modify itab from wa_itab.
endloop.

UPDATE ZTABLE FROM TABLE ITAB.