Hello All,
I'm attempting to import "Attribute Assignment" and "Attribute Assignment Item" values via the C4C Data Workbench. I've followed other posts and was able to successfully complete the process, but I have questions regarding the external keys. See below for sample files and questions...
Sample File for BusinessAttributeAssignment
Sample File for BusinessAttributeAssignmentItem
Question Details
It appears that the External Key is saved in the C4C database and permanently associated with a specific Business Partner. For example, if I execute imports for the above samples and I were to re-execute the import for BusinessAttributeAssignment with the following change, the external keys appear to remain assigned to their original BusinessPartnerID, and the second upload has no impact.
To me, this means that after upload, the External Key cannot be reused except to refer to the original Business Partner object (ex: I cannot use CUS001 to refer to BusPartID3 in a subsequent upload), and this limitation means that I must keep track of all External Keys I have ever uploaded in C4C or use sequential External Keys (which would assign multiple keys to the same object).
Questions are as follows:
Best Regards,
Brian
Hello Brian,
ExternalKey here can be any unique key and which be reused. It is required to be able to link the Item node.
to answer your queries:
Answer1) Yes that is correct the ExternalKey gets permanent assigned to the related object.
Answer2) The same is not visible in the frontend however you can refer to the imported template from Monitor view in Dataworkbench or you can refer to the excel template for the same.
Answer3) Once assignment is created between ExternalKey and respected imported Business Object , same can't be adjusted or modified later.
Thanks,
Nidhi
Hi Nidhi,
Many thanks for the answer. I've marked it as correct, but your comment also brings a follow-up question.
Because the relationship between External ID and Object is permanent, I must be able to extract this information from the system. Right now, there are two ways as you mentioned - via the Data Workbench Monitor or via template.
However, these solutions seem incomplete:
So, the problem remains that there is no "easy" way to extract these external IDs once imported. Did I misunderstand something in your reply? Are there any plans for SAP to make the export more full-featured and include a reference to the External ID in text format?
Best Regards,
Brian