insert into db with key primary equals

[Former Member]

how do I insert data into a custom database even if the primary keys are the same (from a report).?

[Former Member]

how do I insert data into a custom database even if the primary keys are the same (from a report).?

[ThomasZloch]

What's a "custom database" ?

[dev_parbutteea]

A primary key is unique for each record.. it defeats the purpose if you'd like to insert duplicates..

[former_member549144]

Insert help can provide you with correct syntax but you can use command Insert accepting duplicate keys

[matt]

ACCEPTING DUPLICATE KEYS just means that the insert doesn't dump. It does not insert records with duplicate keys.

[former_member1716]

nick.reyan,

You should not do that, it contradicts the primary key concept completely.

Recommend you to add all those fields that can represent a unique entry when combined as primary key. By this you can both adhere to the table standards and preserve data as well.

Can you explain the business scenario here?

Regards!

[mynynachau]

nick.reyan Please check out this tutorial about asking questions in SAP Community, it helps you and other community members who need help by other community members.

Thanks and best regards

Mynyna ( SAP Community moderator)