How Can I Show BOM Level Information for Each Item in a Report?

I’m encountering an issue and would appreciate some guidance. I need to display the BOM in the report with the level information, and I’ve attached a picture for reference.

I understand that I can use the EGP_SYSTEM_ITEMS_B table for level 0 or finished goods, and then join it with EGP_STRUCTURES_B on Inventory_item_id (from ESIB = PK1.value in EGP_Structure), using bill_sequence_id and common_bill_sequence_id to retrieve the child items.

While I am aware of the tables I need to use, my concern is how to display the level information for each item, as shown in the attached picture and the provided link. Has anyone else encountered a similar issue?