Skip to Content

In C4C how to query materials by sales org, [and division [and distribution channel]]

Feb 10, 2017 at 01:01 PM


avatar image

Hi Everyone!

As you know a material can be associated with multiple 'sales data' records, each with Sales org, division and distribuition channel.

We have a requirement where we would like to get a list of materials into a node that match a specific combination of Sales Org. Division and distribution channel. To be clear, we may want to query materials with a sales org, or with a sales org and division.

I don't see any Query in the material object to do this. Am I missing something? I only see Queries by Supplier, ProductCategory, description and Global Trade Item.

Thank you very much,

Kind regards,


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

1 Answer

Best Answer
Suresh Babu Mula
Feb 15, 2017 at 08:51 AM

Dear Tiago,

if i understood your requirement you wanted to create a query for the products in system with sales org division however you don’t see these fields in the advanced search.

to do so click on advanced search then click on personalize button on top then choose untitled tab here we have the fields like sales org ID division and distribution channel try add these and then save & publish, now you should be able to create a query of your choice.



10 |10000 characters needed characters left characters exceeded