SAP Knowledge Base Article - Public

2812052 - Data Relating to a Sales Organization are not Present in "BusinessPartnerRelationshipCollection" Standard OData

Symptom

You have a requirement to query "Business Partner Relationship data " from C4C system.

When you use the Standard OData URL, you are not able to see Business Partner Relationship data related to ABC Sales Organization.

Where ABC is a particular Country.

But data related to other Countries' Sales Organization are available.

Example URL: https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/BusinessPartnerRelationshipCollection

Though, when you check in the system you can see that there are Business Partner Relationship data present for all the countries including ABC.

Environment

SAP Cloud for Customer

Cause

If you query the Business Partner Relationship data without a filter, the result will be truncated with the maximum number of rows, i.e., 1000.

Resolution

If you want to find a specific Sales ID related to ABC, you have to apply the filter like this :

https://myXXXXXX.crm.ondemand.com/sap/c4c/odata/v1/c4codataapi/BusinessPartnerRelationshipCollection?$filter=SalesOrganisationIDeq('ID-ABC')

Keywords

BusinessPartnerRelationshipCollection, Sales Organization , KBA , odata , sales organization , businesspartnerrelationshipcollection , country , LOD-LE-BP-BP , Business Partner , Problem

Product

SAP Cloud for Customer core applications 1905