First it would be helpful to help you know for which purpose you ahave to extract the data: reporting? Data integrity control? spot report?
By tables you mean actual tables or the entities that refer to those tables from Data management? Because in the Data management workspace you can find a lot of entities (aggregation of D365 tables) that in most of the cases are the best basis for mass extractions. For starter in your case, the entity "Product category assignments" extracts a list of all the items and the categories and category hierarchies they are assigned to.
Another thing: when you are talking about "brand" and "manufacturer", are those product categories or fields of the items?
Best regards
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.