Dear Experts.
I want to write a query to select all levels of BOM.
I could do it with the "WITH" clause on SQL Server but I could not make it on SAP Hana.
What I have tried
With BOM ("Parent","Child","Quantity","Level")
As
(
Select P."F...
Hi,My Company uses SAP Hana for the database. Do you have Hana query for thisI have triedWith BOM ("Parent","Child","Quantity","Level") As ( Select P."Father" "Parent",P."Code" "Child", "Quantity",0 "Level" From ITT1 P
Where P."Code" = 'XXXXXX' Union...
