topic Re: Regarding modifying database from internal table in Application Development and Automation Discussions

Regarding modifying database from internal table

Former Member — Mon, 02 Mar 2009 11:46:02 GMT

Hi ABAP Experts,

I am facing an issue regarding modifying DB table from itab.

All the records of itab are not getting reflected in DB table using Modify statement.

Syntax is as follows -

Locking DB table using enque FM

MODIFY abc FROM TABLE i_abc.

Unlocking DB table using deques FM

Please suggest what could be wrong with this. Helpful suggestion will be appreciated.

Thanks in adv,

Akash

Re: Regarding modifying database from internal table

Former Member — Mon, 02 Mar 2009 11:49:31 GMT

it will works n=based on primary key

Plese check u r primary key of the tabe with internal table..

Kiran

Re: Regarding modifying database from internal table

Mohamed_Mukhtar — Mon, 02 Mar 2009 11:53:15 GMT

Hi,

First Delete entries from the table(hope it is a custom table),

for example

DELETE  FROM <DatabaseTable name> WHERE <primarykey = 'somevalue'>.

'After deleting those records.....then use insert statement

 IF sy-subrc = 0.
   INSERT <DatabaseTable name> FROM TABLE  <InternalTable name> ACCEPTING DUPLICATE KEYS.
  ENDIF.

Thanks & REgards

Re: Regarding modifying database from internal table

Former Member — Mon, 02 Mar 2009 11:53:25 GMT

Hi,

Use Sy-Subrc after modify statment. If sy-Subrc equals to Zero then use commit statement.

Check in debug mode.

Regards

Md.MahaboobKhan

Re: Regarding modifying database from internal table

I355602 — Mon, 02 Mar 2009 11:55:39 GMT

Hi,

Use:-


MODIFY <db_table> FROM TABLE <itab>.

IF sy-subrc = 0.
  "sy-dbcnt will contain the number of records effected in db table
  COMMIT WORK.
ENDIF.

Hope this helps you.

Regards,

Tarun

Re: Regarding modifying database from internal table

Former Member — Mon, 02 Mar 2009 12:21:35 GMT

Hi all,

Already tried by checking sy-subrc and doing commit work but no success. Also SY-DBCNT contains the value as total number of entries of itab.

Thanks,

Akash

Re: Regarding modifying database from internal table

Former Member — Mon, 02 Mar 2009 12:35:30 GMT

Hi,

If the primary key fields have same value as the records present in internal table then for these records the modify statement is not worked. We can check it using SY-SUBRC & SY-DBCNT.