SQL Recursive CTE Lookup in Hierarchy to get a Part Only Flat BOM

I am trying to create a part only flat level Puchase/Manufacturing BOM from a Hierarchal Engineering BOM. the Database is set up with a PARTMASER table the lists all partnumberss and a BOMLEGER table that has the PARENT, CHILD columns for all assemblies. I am using the following code to get my flat BOM

WITH cteBuildPath AS
   (
   --=== This is the "anchor" part of the recursive CTE.
     -- The only thing it does is load the Root Node.
      SELECT ROOT.PARENT_PARTMASTER_CODE, ROOT.CHILD_PARTMASTER_CODE, ROOT.BOMLEGER_QTY
       FROM BOMLEGER ROOT
       WHERE ROOT.PARENT_PARTMASTER_CODE LIKE '%10550-03A%'--The Root Node
    UNION ALL
     --==== This is the "recursive" part of the CTE that adds 1 for each level
     -- and concatenates each level of EmployeeID's to the SortPath column.
      SELECT 
            PARENT.PARENT_PARTMASTER_CODE, 
            --CHILD.PARENT_PARTMASTER_CODE as SUBPARENT,
            CHILD.CHILD_PARTMASTER_CODE, 
            CONVERT(decimal(6,2),PARENT.BOMLEGER_QTY*CHILD.BOMLEGER_QTY)
       FROM 
            cteBuildPath PARENT, 
            BOMLEGER CHILD
       WHERE PARENT.CHILD_PARTMASTER_CODE = CHILD.PARENT_PARTMASTER_CODE
   )
   --=== This final SELECT/INTO creates the Node # in the same order as a
     -- push-stack would.
SELECT PARENT_PARTMASTER_CODE AS PARENT, 
--SUBPARENT,
CHILD_PARTMASTER_CODE AS CHILD, 
SUM(BOMLEGER_QTY) AS "Total QTY"

 FROM cteBuildPath
  GROUP BY PARENT_PARTMASTER_CODE, CHILD_PARTMASTER_CODE
  ORDER BY PARENT_PARTMASTER_CODE, CHILD_PARTMASTER_CODE;

and I get the result

The issue is I am getting all the mid sub-assemblies in my result and I don't want them. So the SUB-0000018 is a midlevel Subassembly with children so since the Children are in the output I dont want the Subassembly.

You can just add a NOT EXISTS to the final SELECT to check if it's the bottom level part.

WITH cteBuildPath AS
(
   --=== This is the "anchor" part of the recursive CTE.
     -- The only thing it does is load the Root Node.
      SELECT
        ROOT.PARENT_PARTMASTER_CODE,
        ROOT.CHILD_PARTMASTER_CODE,
        ROOT.BOMLEGER_QTY
      FROM BOMLEGER ROOT
      WHERE ROOT.PARENT_PARTMASTER_CODE LIKE '%10550-03A%'--The Root Node

    UNION ALL

     --==== This is the "recursive" part of the CTE that adds 1 for each level
     -- and concatenates each level of EmployeeID's to the SortPath column.
    SELECT 
        PARENT.PARENT_PARTMASTER_CODE, 
        CHILD.CHILD_PARTMASTER_CODE,
        CONVERT(decimal(6,2), PARENT.BOMLEGER_QTY * CHILD.BOMLEGER_QTY)
    FROM 
      cteBuildPath PARENT
    JOIN BOMLEGER CHILD
        ON PARENT.CHILD_PARTMASTER_CODE = CHILD.PARENT_PARTMASTER_CODE
)
   --=== This final SELECT/INTO creates the Node # in the same order as a
     -- push-stack would.
SELECT
  PARENT_PARTMASTER_CODE AS PARENT, 
  CHILD_PARTMASTER_CODE AS CHILD, 
  SUM(BOMLEGER_QTY) AS "Total QTY"
FROM cteBuildPath bp
WHERE NOT EXISTS (SELECT 1
    FROM BOMLEDGER_ROOT child
    WHERE child.PARENT_PARTMASTER_CODE = bp.CHILD_PARTMASTER_CODE
)
GROUP BY
  PARENT_PARTMASTER_CODE,
  CHILD_PARTMASTER_CODE
ORDER BY
  PARENT_PARTMASTER_CODE,
  CHILD_PARTMASTER_CODE;