Skip to Content
0

unique constraint violated: Table SOPDD_STAGING_KFTAB*

Dec 26, 2016 at 05:26 AM

232

avatar image
Former Member

Hi Experts,

We are trying to load the key figure from CSV and using the staging table for key figures is found under Timeseries Folder like SAPSOPG.SOPDD_STAGING_KFTAB_*.

However we are facing the key duplication error as follows.
(cause: [301]: unique constraint violated: Table(SOPDD_STAGING_KFTAB_SAPIBP1SAPIBP1))

I guess the reason is because "ID" column in the staging table for key figure is a key.

Please let me know the reason why "ID" is set as key and how I deal it to avoid the error.

Thanks in advance.

Regards,
Kosuke

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jan 13, 2017 at 11:41 AM
0

Hi Kosuke,

use the following mapping for "ID":

gen_uuid()

Doku

Best regards,

Benjamin

Share
10 |10000 characters needed characters left characters exceeded