IntegrityError: (301, 'unique constraint violated') when loading data from S4HANA CDS to Native HANA

[former_member462348]

Hi,

I have created a CDS view in S4HANA cloud using the "I_CustomerPaymentTerms" as data source and exposed all the columns from this view.

Now when trying to load the data from this view to Native HANA table using Python script, we are facing the IntegrityError: (301, 'unique constraint violated') error.

Can anyone help me to know the reason for this error ?

Thanks
Rufus Samuel

[Amith_Nair · Accepted solution]

Hello,

This is not necessarily an issue at the custom CDS view level nor an issue on your S4HANA Cloud instance. This usually comes when there is data in your table and the report or procedure or operation that you are performing tries to insert similar data to a column marked with unique constraint.

Please see the reference link that listed similar question and its answer from the past.

https://answers.sap.com/questions/260560/unique-constraint-violated.html

Hopefully, this should help!

Thank you! Amith Nair