# mes.spPopulateItemClassHierarchy

## Description
Populates the `mes.itemClassHierarchy_MAT` table with the full path hierarchy of item classes using a recursive CTE. Designed to improve performance of lookups and filters based on item class lineage.

## Key Operations
- Truncates the existing hierarchy materialized table
- Builds full hierarchical paths (e.g., `RootClass\SubClass\LeafClass`)
- Stores parent-enabled status for UI and logic filtering

## Usage Notes
Run this after any modifications to the item class tree to ensure the hierarchy view stays accurate.

### Example

```sql
-- Refresh the item class hierarchy
EXEC mes.spPopulateItemClassHierarchy;