topic Updating data base tables in Application Development and Automation Discussions

Updating data base tables

Former Member — Mon, 16 Jul 2007 11:31:36 GMT

Hi all,

Iam updating database tables using below statement .

INSERT data_base_table FROM workarea.

This is working but but looking for better method other than this. Ple let me know if u have any.

Regards,

Shiva

Re: Updating data base tables

amit_khare — Mon, 16 Jul 2007 11:34:01 GMT

Check out for any BAPI or FM for uploading the same table.

Regards,

Amit

Reward all helpful replies.

Re: Updating data base tables

Former Member — Mon, 16 Jul 2007 11:34:59 GMT

Hi,

try and use UPDATE statement for the same.

Regards,

Ameet

Re: Updating data base tables

Former Member — Mon, 16 Jul 2007 11:35:13 GMT

Use modify statement :

keep the data into internal table ,in last use below method.

modify dbtable from table int_table.

Thanks

Seshu

Re: Updating data base tables

Former Member — Mon, 16 Jul 2007 11:35:28 GMT

Mass update of all records form an internal table

INSERT data_base_table FROM TABLE internal_table

MODIFY data_base_table FROM TABLE internal_table. "If an existing match exists, it will update it, if not, creates a new record.

Regards,

ravi

Re: Updating data base tables

Former Member — Mon, 16 Jul 2007 15:15:13 GMT

Hi Siva,

Use ACCEPTING DUPLICATE KEYS addition along with INSERT so that run time error can be avoided, instead system will set the SY-SUBRC value accordingly.

Please reward if helpful

Re: Updating data base tables

Former Member — Mon, 16 Jul 2007 18:45:30 GMT

instead of inserting a single record u can insert the whole internal table..

INSERT <dbtable> FROM TABLE itab.

Or u should find out some FM to update the table... because in many cases there are dependencies for the table..

Regards

Prax