PT Sterling Tulus Cemerlang



Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

Unlimited Multilevel Bill of Material (BOM) Query in SAP Business One for HANA

unlimited bom query for hana sap b1 tips

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:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: or call +6221-5806336 or wa +6287786555055

, , , , , ,