Query - BOM Component Where Used

#1 · June 3, 2020, 12:54 pm

This SAP Business One HANA query lists all the assemblies for a prompted for component. Easy to use and deploy, will provide you with a list of all BOM's the entered component item exists in.

SELECT T0."Code",
T2."ItemName",
T1."Code",
T3."ItemName",
T3."OnHand"
FROM OITT T0 INNER JOIN ITT1 T1 ON T0."Code" = T1."Father"
INNER JOIN OITM T2 ON T0."Code" = T2."ItemCode"
INNER JOIN OITM T3 ON T1."Code" = T3."ItemCode"
WHERE T1."Code" =[%0]