Skip to Content
1
Sep 17, 2020 at 03:36 PM

SAP Business One BoM routing query

426 Views

I would like to write a query that shows the BoM routing for a BoM. I have the following query that displays the needed BoM details, but it only shows ITEMS, not the Routing steps.

Is there a table that links the Route with the BoM?

I know the user can just look at the BoM to see this, I am going to add more fields/tables to create a BoM report, I am keeping t simple for this question.

SELECT        T0.Code AS 'BOM Code', T2.ItemName AS 'BOM Name', T1.VisOrder, T1.Code AS 'Component Item Code', OITM.ItemName AS [Component Name]
FROM    OITT AS T0 INNER JOIN
           OITM AS T2 ON T0.Code = T2.ItemCode INNER JOIN
           ITT1 AS T1 ON T0.Code = T1.Father INNER JOIN
           OITM ON T1.Code = OITM.ItemCode
WHERE        (T0.Code = [%0])
ORDER BY T1.VisOrder