Query to fetch item category mappings in costing

Summary:

Hi Team,

We have a requirement to create a BIP report which will fetch the mapping set code combination for a given item category. We have created separate queries to fetch item category information and mapping set information but couldn't find a common join to get the required information. We observed the common column in purchasing category name as this is not ID column we are unable to join based on this.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):