PIM Catalog - Category Hierarchy Table

Summary

table to retrieve category hierarchy

Content

We have create a catalog under Manage catalogs table, which is not assigned to any functional area.

Categories are defined under the catalog in a hierarchy structure, as shown in the attached image.

Items are associated to the Lowest category only i.e. Tees - eCommerce.

Also the category hierarchy is not available in any of the transactions and available as a place holder under PIM catalogs.

The category hierarchy is not available as a dimension/fact under Product Management - OTBI subject area.

We have a requirement to generate reports for these category hierarchy and need the table name which store the details for Parent and Child category, as per the category hierarchy shown in attached image.