topic Re: Update the database table in Application Development and Automation Discussions

Update the database table

Former Member — Fri, 10 Apr 2009 08:11:22 GMT

Hi,

I want to update the table bseg.I have the values of belnr,gjahr and bukrs.If i use the keyword "Update" performance issue is occured.How to update the table is someother way.Plz help

Re: Update the database table

Former Member — Fri, 10 Apr 2009 08:14:32 GMT

hi,

its not a gud practive to directly update the database table...

instead use some function module to update the database tables.....

then you will not get any performance issues

Regards,

Siddarth

Re: Update the database table

awin_prabhu — Fri, 10 Apr 2009 08:20:03 GMT

Have u tried MODIFY dbtab FROM TABLE itab.

Also try using BAPI's for updating database.

Re: Update the database table

Former Member — Fri, 10 Apr 2009 08:22:48 GMT

Y ur not using Modify Key word as u said this is not much performance.

Re: Update the database table

Former Member — Fri, 10 Apr 2009 08:34:35 GMT

I tired to use as

MODIFY bseg from gw_bkpf.

gi_bkpf is of type bkpf.This is throwing error.How to correct it

Re: Update the database table

Former Member — Fri, 10 Apr 2009 08:38:33 GMT

hi ,

please check the data type of gw_bkpf... it should be of type bseg.

use the code given below...

data : w_bseg type bseg.

move-corresponding gw_bkpf to w_bseg.
modify bseg from w_bseg.

Regards,

Siddarth

Re: Update the database table

Former Member — Fri, 10 Apr 2009 08:38:45 GMT

Declare work area of type BSEG . Error is becz u r updating table with workarea of different type

Re: Update the database table

Former Member — Fri, 10 Apr 2009 08:54:59 GMT

Thanks this is working out.In addition to this have to set a value of the field when i modify the table.In the "Update" statement we have the option is there any way to do the same in MODIFY also

Re: Update the database table

Former Member — Fri, 10 Apr 2009 08:55:17 GMT

typoes: begin of tyt_bseg,

belnr type bseg-belnr,

end of ty_bseg.

data:it_bseg type standard table of ty_bseg,

wa_bsefg type ty_bseg.

loop at it_bseg into wa_bseg .

modify bseg from wa_bseg.

endloop.

Re: Update the database table

_IvanFemia_ — Fri, 10 Apr 2009 09:00:03 GMT

Hi,

do not update standard table directly, some inconsistences may occur... Find a BAPI that is useful for you!!!

Regards,

Ivan

Re: Update the database table

Former Member — Fri, 10 Apr 2009 09:23:18 GMT

Hi,

The MODIFY statement will scan all records in database table before making an UPDATE or an INSERT. That's why you are having performance issues. If you are able to know wether your current record already exists or not use INSERT or UPDATE instead.

DESPITE ALL THIS, YOU SHOULD NEVER UPDATE DIRECTLY A STANDARD DATABASE TABLE.

Use FI function modules or batch input to upadate your data.

Issa

Re: Update the database table

Former Member — Fri, 10 Apr 2009 09:57:46 GMT

use

modify <dtab> from table <itab>.

Regards,

Lalit Mohan Gupta.