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

[Former Member]

Hi ,

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

Internal table t_MARA.

Regards

rahul

[Former Member]

Hi ,

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

Internal table t_MARA.

Regards

rahul

[Former Member]

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>

[marcelo_ramos1]

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

[Former Member]

PLEASE DO NOT UPDATE STANDARD TABLES FROM YOUR PROGRAM.

[former_member378318]

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