In SAP Business One for SQL Server, if you want to create an unlimited multilevel Bill of Material (BOM) report, you can use WITH Recursive query expressions. However, in HANA as stated in the documentation, the <with_clause> cannot support recursive query expressions.
But don’t worry, you can still create unlimited multilevel bill of material (BOM) queries in SAP Business One for HANA, with a Stored Procedure and 2 temporary tables, here is the snippet :
Now, you can use this query and expand it according to your needs. Hope this article helps you.
Also read:
