topic Re: delete one perticula field data in Application Development and Automation Discussions

delete one perticula field data

Former Member — Tue, 02 Sep 2008 05:33:10 GMT

Hi All,

how to delete the perticular field data.(not complete field)

for expample:ztab is table with zno,zname are two fields

now i want to delete data for field of 'ztab-zno.

thanks,

sriii

Re: delete one perticula field data

Former Member — Tue, 02 Sep 2008 05:37:00 GMT

hi,

loop at itab.

clear itab-field1.

modify itab index sy-tabix transporting field1.

endloop.

Is this you want?

Regards,

Theja

Re: delete one perticula field data

Former Member — Tue, 02 Sep 2008 05:37:03 GMT

Use the following command

If you want to Update Database table

UPDATE ZTAB SET ZNO = 0.

If you want to update internal table.

WA_ZTAB-ZNO = 0.

MODIFY ZTAB

FROM WA_ZTAB

TRANSPORTING ZNO.

Re: delete one perticula field data

GauthamV — Tue, 02 Sep 2008 05:37:26 GMT

hi,

delete will remove entire record.

use modify statement for tht fields .

Re: delete one perticula field data

Former Member — Tue, 02 Sep 2008 05:38:50 GMT

Hello,

Try this

1.Select data into internal table it_data.

loop at it_data into wa_data.

wa_data-no = ' '.

modify it_data from wa_data index sy-tabix.

endloop.

modify db_table from table it_data.

Create table maintainance generator for that.

Re: delete one perticula field data

Former Member — Tue, 02 Sep 2008 05:39:19 GMT

hi,

Use MODIFY statement.

ztab-<filed> = ' '.

MODIFY <tab> index sy-index.

Regards

Sumit Agarwal

Re: delete one perticula field data

former_member734916 — Tue, 02 Sep 2008 05:41:19 GMT

First get all entries into one internal table.

Then loop at internal table and clear the field which you want to delete and modify the internal table.

The internal table type shoule be z table type.

Then use modify statement.

Regards.

Krishna Yerram.

Re: delete one perticula field data

Former Member — Tue, 02 Sep 2008 05:45:41 GMT

Hi Dude,

U Can Delete a particular column.

But this cannot be Done by Delete Statement.

One Way of doing this is by MODIFY Statement.

Declare WA_Ztab for the table Ztab.

set the value of this to space. 'wa_ztab-zno' = ' ' .

Modify ZTAB From WA_ztab.

Hope this helps U.