Address the Component status as a Parent or a child depending on Hierarchy Path

[Oleander]

I have a BOM and want to set  a Parent or a child status due to position in a Hierarchie Path:

Level	Comp	Parent	Imm Parent	Hiarchy
Parent	101	101		101
1	1002	101	101	101|1002
.2	1008	101	1002	101|1002|1008
1	1003	101	101	101|1003
.2	1009	101	1003	101|1003|1009
.2	1008	101	1003	101|1003|1008
1	1010	101	101	101|1010
1	1004	101	101	101|1004
.2	1011	101	1004	101|1004|1011
.2	1005	101	1004	101|1004|1005
..3	1012	101	1005	101|1004|1005|1012
..3	1013	101	1005	101|1004|1005|1013
.2	1005	101	1004	101|1004|1005
..3	1007	101	1005	101|1004|1005|1007
...4	1014	101	1007	101|1004|1005|1007|1014
...4	1015	101	1007	101|1004|1005|1007|1015
...4	1016	101	1007	101|1004|1005|1007|1016
...4	1017	101	1007	101|1004|1005|1007|1017
..3	1018	101	1005	101|1004|1005|1018
..3	1019	101	1005	101|1004|1005|1019
..3	1020	101	1005	101|1004|1005|1020
1	1021	101	101	101|1021

I want to address the Component status as this :

Level	Comp	Parent	Imm Parent	Hiarchy	Comp Status
Parent	101	101		101	Parent
1	1002	101	101	101|1002	Parent
.2	1008	101	1002	101|1002|1008	Child
1	1003	101	101	101|1003	Parent
.2	1009	101	1003	101|1003|1009	Child
.2	1008	101	1003	101|1003|1008	Child
1	1010	101	101	101|1010	Child
1	1004	101	101	101|1004	Parent
.2	1011	101	1004	101|1004|1011	Child
.2	1005	101	1004	101|1004|1005	Parent
..3	1012	101	1005	101|1004|1005|1012	Child
..3	1013	101	1005	101|1004|1005|1013	Child
.2	1005	101	1004	101|1004|1005	Parent
..3	1007	101	1005	101|1004|1005|1007	Parent
...4	1014	101	1007	101|1004|1005|1007|1014	Child
...4	1015	101	1007	101|1004|1005|1007|1015	Child
...4	1016	101	1007	101|1004|1005|1007|1016	Child
...4	1017	101	1007	101|1004|1005|1007|1017	Child
..3	1018	101	1005	101|1004|1005|1018	Child
..3	1019	101	1005	101|1004|1005|1019	Child
..3	1020	101	1005	101|1004|1005|1020	Child
1	1021	101	101	101|1021	Child

[Oleander · Accepted solution]

Sorry , I didn't see it myself:

"=if(BOM[Level]="Parent";"Parent";IF(CONTAINS(BOM;BOM[Imm Parent];BOM[Comp]);"Parent";"Child"))"