HANA BOM Multi level explosion with HIERARCHY with bom as ( SELECT * FROM HIERARCHY ( SOURCE ( SELECT m1.mandt , m1.stlnr , m1.stlal , m1.stlan , s1.stlty , s1.stlkn , m2.stlnr as child_bom , m1.matnr as parent_id , p1.posnr , p1.idnrk as node_id .. SAP/ABAP_SQL 2024.08.07