Relate EGP_STRUCTURES_B/EGP_SYSTEM_ITEMS with Catalogue Categories.
Hi. I made a BOM explosion using EGP_STRUCTURES_B and now I need to filter out some results based on catalogue properties of the items. I did not find meaningful fields in either EPG_STRUCTURES or EGP_SYSTEM_ITEMS that help me to relate with the item's catalogue properties (found them in MSC_CATALOG_CATEGORIES and EGP_CATEGORIES_B) I'm pretty sure must be an intermediate table or a field with a pesky name.
Any help is greatly welcomed!