Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

inserting data in database table issue

Hi,

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.

Cheers...

Tags:
Former Member
Former Member replied

HI,

If it is not absolutely necessary, try to make some more fields as key fields.

regards,

Advait

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question