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.
If it is not absolutely necessary, try to make some more fields as key fields.