UPDATE DB with empty field

[Former Member]

I have a structure and a field of it is empty.

I would like to overwrite the field in the database with this initial field.

but it seems that update only changes values if they are filled.

Does any workaround exist?

[Former Member]

Hi ,

USe Modify then it solves the problem.

Thansk

[tarangini_katta]

Hi ,

USe Modify then it solves the problem.

Thansk

[former_member404244]

Hi,

Use modify statement.. it will work..

Regards,

Nagaraj

[Former Member]

This message was moderated.

[Former Member]

hi.

just check like this.

select f1 f2 from ztable into corresponding field of itab 
where condition.

loop at itab into wa_itab where f1 ne 0. " suppose f1 is field which u want to modify
  wa_itab-f1 = 0.
modify itab from wa_itab index sy-tabix.
endloop.

Edited by: tahir naqqash on Feb 11, 2009 6:53 PM

Edited by: tahir naqqash on Feb 11, 2009 6:53 PM

[Former Member]

Hi,

Try this, this will surely solve ur problem

MODIFY <dbtab> from <your wokarea or internal table>.

Edited by: Digvijay Singh Pawar on Feb 11, 2009 2:59 PM

[Former Member]

Hi,

you can use,

MODIFY <db tab> FROM TABLE <int tab> "Here int tab contains the initial values

Regards,

Manoj Kumar P

[Former Member]

hi,

use the following statements as per your requirement

Modify DBTAB from wa.

Modify DBTAB from table itab.

These statements modify or insert based on the records in the data base table.

Thanks

Sharath