Skip to Content
Former Member
Oct 13, 2008 at 06:00 PM

inserting data in database table issue



I am trying to insert data from an internal table to a custom database table. Internal table got 53 entries and i can insert only one record. Now sure why ?

I am using insert db from itab accepting duplicate keys and failed.

I also tried Modify statement and still it is inserting single record only. But sy-dbcnt is 53 here and sy-subrc is 0 here, i am not sure why records are not inserted in internal table.

Note: I have only MANDT (client) as unique key in my DB table. Not sure if this have any impact.

Also, I have observed that during MODIFY statement, record inserted in from HEADER data record of internal table and when I use statement INSERT i see 1st record from internal table inserted into DB table.