Skip to Content
0

How does Referencing Data Source Key Field work in cloud data source in c4c?

Oct 31, 2016 at 02:51 PM

75

avatar image
Former Member

Hi Experts,

I am relatively new to cloud data source in c4c.

I came across columns Referencing Data Source and Referencing Data Source Key Field in cloud data source.

From Admin guide,I got to know it works similar to Foreign key constraint in SQL.

I created a Test CDS to know how it works with the following fields.

1.ZID - with Referencing Data Source - Account Master and Referencing Data Source Key Field - Account ID

2.ZName

And I tried to upload a file with Account ID having the value -1.To my surprise it got successfully uploaded,even though there is no Account in Account master with Account ID -1.This is not how a foreign key constraint works.

Can anyone please tell me how does Referencing Data Source Key Field work in cloud data source in c4c.

Please find the following screenshots.

sample-cds.png

cds-data.png

sample-cds.png (34.9 kB)
cds-data.png (22.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Arthur Hanauer
May 18 at 01:05 PM
0

Hi Vishnu,

Hope you are doing well, we have performed some research in our documentation for additional information regarding this topic.

We could find some interesting details in the below documentation:

  1. https://archive.sap.com/documents/docs/DOC-63005
  2. https://archive.sap.com/documents/docs/DOC-63006
  3. https://archive.sap.com/documents/docs/DOC-63007

These documentation cover almost the whole topic of Cloud Data Sources in the system, including the Referencing Data Source Key Field you mentioned in your question.

In case you need further assistance regarding this query, let us know.

Best Regards,

Arthur Hanauer,

Support Consultant, SAP Cloud Product Support

Share
10 |10000 characters needed characters left characters exceeded