topic Re: how to insert/modify records from internal table to database table in Application Development and Automation Discussions

how to insert/modify records from internal table to database table

Former Member — Fri, 10 Aug 2007 14:59:27 GMT

Hi ,

Can anyone please send me the code to modify a database table (MARA) from

Internal table t_MARA.

Regards

rahul

Re: how to insert/modify records from internal table to database table

Former Member — Fri, 10 Aug 2007 15:03:06 GMT

for inserting data

http://www.sapdb.org/htmhelp/34/ee7fb7293911d3a97d00a0c9449261/content.htm

for modifying

http://www.sapdb.org/7.4/htmhelp/34/ee7fba293911d3a97d00a0c9449261/content.htm

regards,

srinivas

<b>*reward for useful answers*</b>

Re: how to insert/modify records from internal table to database table

marcelo_ramos1 — Fri, 10 Aug 2007 15:15:50 GMT

Hi,

Try this way.


  INSERT mara FROM TABLE t_mara.

Or.

  LOOP AT t_mara.
    INSERT INTO mara VALUES t_mara.
  ENDLOOP.

Or.

  UPDATE mara FROM TABLE t_mara.

Or.

MODIFY mara FROM TABLE t_mara.

Regards.

Marcelo Ramos

Re: how to insert/modify records from internal table to database table

Former Member — Fri, 10 Aug 2007 15:31:15 GMT

PLEASE DO NOT UPDATE STANDARD TABLES FROM YOUR PROGRAM.

Re: how to insert/modify records from internal table to database table

former_member378318 — Fri, 10 Aug 2007 15:36:25 GMT

Hi Sharma,

Yes the previous replies are very naughty advising you to directly update table MARA, this is not recommended and could seriously damage the data integrity of the database.

Have a look at the BAPI called BAPI_MATERIAL_MAINTAINDATA_RT which you can use to safely update MARA and associated tables.

Surbjeet