Update the database table

[Former Member]

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

[Former Member]

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

[awin_prabhu]

Have u tried MODIFY dbtab FROM TABLE itab.

Also try using BAPI's for updating database.

[Former Member]

I tired to use as

MODIFY bseg from gw_bkpf.

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[_IvanFemia_]

Hi,

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

Regards,

Ivan

[Former Member]

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

[Former Member]

use

modify <dtab> from table <itab>.

Regards,

Lalit Mohan Gupta.