Skip to Content
avatar image
Brian Nienhaus

C4C Data Workbench - Relationship Between External Keys and Associated Objects

May 17, 2017 at 03:34 PM | 936 Views

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:

  1. Can anyone confirm that my assumptions regarding the permanent assignment of an external key to the related object are correct?
  2. Can anyone suggest the best way to view the relationship between the External Key and the related Business Partner object within C4C after executing the data import?
  3. Is there any way to adjust the association of an External Key and assign it to a different related object after the first assignment has been made.

Best Regards,

Brian

bpa-header.jpg (21.2 kB)
bpa-item.jpg (47.3 kB)
bpa-header-reversed.jpg (21.0 kB)
SAP Cloud for Customer add-ins | c4c | data workbench | marketing attributes
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Nidhi Chhabra
    May 22, 2017 at 10:58 AM

    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


    Add comment
    10|10000 characters needed characters exceeded

    • Brian Nienhaus
      May 30, 2017 at 08:47 PM

      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:

      1. If the Monitor is used, one would have to check all imports of the same object time to compile a full list. As the list of imports grows over time (to perhaps hundreds of entries), this seems like a great deal of effort.
      2. I tried to use the Export function of the Data Workbench to export a full list, but instead of the External IDs (text), the Object ID (GUID) is returned.

      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