topic UPDATE DB with empty field in Application Development and Automation Discussions

UPDATE DB with empty field

Former Member — Wed, 11 Feb 2009 13:35:12 GMT

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?

Re: UPDATE DB with empty field

tarangini_katta — Wed, 11 Feb 2009 13:36:28 GMT

Hi ,

USe Modify then it solves the problem.

Thansk

Re: UPDATE DB with empty field

former_member404244 — Wed, 11 Feb 2009 13:37:27 GMT

Hi,

Use modify statement.. it will work..

Regards,

Nagaraj

Re: UPDATE DB with empty field

Former Member — Wed, 11 Feb 2009 13:48:28 GMT

This message was moderated.

Re: UPDATE DB with empty field

Former Member — Wed, 11 Feb 2009 13:52:02 GMT

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

Re: UPDATE DB with empty field

Former Member — Wed, 11 Feb 2009 13:52:26 GMT

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

Re: UPDATE DB with empty field

Former Member — Wed, 11 Feb 2009 13:54:02 GMT

Hi,

you can use,

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

Regards,

Manoj Kumar P

Re: UPDATE DB with empty field

Former Member — Wed, 11 Feb 2009 13:54:48 GMT

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