I have a bill of material named : T1-IFX720QCRFKC
In that BOM I have those parts

Parts with a F (in the 4th column) means they are an assembly and also contains parts
Those F type parts now become my next level. In this Example,
PROFI-IFX720, 404646-2F, 404655 and CA-SST_IFX now become my level 1 and MOD-ASSEMBLAGE stay in the Master level
I want to be able to go to the last level containing a F type and be able to get the cost for each level
How can I regroup and generate levels
(in my real database I don’t have the Level field) I add it to this example to make it clear