Hi there
I have a query from DB with all BOMs of production items
My problem is that I want to see all the levels of the item by filter- The item B17 contains item W2 so I want to see the materials for w2 too
I need a way to chek every material and if the material has a BOM, to see the bom
Something like this
If I write in the filter B17 I want to see
item CODE Материал CODE qty Price SUM1 SUM2
B17 C7 1 0,10 0,1
B17 C8 1 0,12 0,12
B17 C9 2 1,54 3,08
B17 C10 1 0,04 0,043
B17 C11 1 0,75 0,75
B17 C12 1 3,36 3,36
B17 C13 1 1,60 1,6
B17 C14 1 0,07 0,07
B17 C15 1 1,90 1,9
B17 (+/-)W2 1 9,41 9,41
C1 1 0,00 0,001
C2 1 0,43 0,428
C3 1 0,50 0,5
C4 1 3,73 3,73
C5 2 1,82 3,64
C6 3 0,37 1,11


But the database look like this and i cannot view all the levels in the BOM

Filter B17
item CODE Материал CODE qty Price
B17 C7 1 0,10
B17 C8 1 0,12
B17 C9 2 1,54
B17 C10 1 0,04
B17 C11 1 0,75
B17 C12 1 3,36
B17 C13 1 1,60
B17 C14 1 0,07
B17 C15 1 1,90
B17 W2 1 0,00
W2 C1 1 0,00
W2 C2 1 0,43
W2 C3 1 0,50
W2 C4 1 3,73
W2 C5 2 1,82
W2 C6 3 0,37


If i filter by B17 i see only the first level
Filter B17
item CODE Материал CODE qty Price
B17 C7 1 0,10
B17 C8 1 0,12
B17 C9 2 1,54
B17 C10 1 0,04
B17 C11 1 0,75
B17 C12 1 3,36
B17 C13 1 1,60
B17 C14 1 0,07
B17 C15 1 1,90
B17 W2 1 0,00