Enterprise Search - Search for Bill of Materials

Adina Rösner

March 12, 2024 13:44

Hi,

It would be very helpful to find items in the enterprise search that are linked to bills of material. This way, when you search for an item, you can see directly in which bills of material the article is included. 

0

• 

  Raphael Michel

  March 19, 2024 08:14

  Hi Adina
  
  You can try this Query an place it one a menu
  SELECT T0."Code", T0."Name", T0."TreeType", T0."PriceList", T0."Qauntity" FROM OITT T0  INNER JOIN ITT1 T1 ON T0."Code" = T1."Father" WHERE T1."Code" = [%1]

  0
• 

  Lothar Hasenkämper

  March 19, 2024 08:44

  Hi Raphael,

  there is a little typo in your query and Adina like'd to see the father which is missing, but it is in the ITT1.

  I think it could make more sense this way

  SELECT
T0.Father
,OITM.ItemName AS [FatherName]
,T0.Code
,T0.ItemName
FROM 
ITT1 T0
INNER JOIN OITM ON OITM.ItemCode = ITT1.Father /*in older Versions of SAP, it could happen that the Name is not changed in the BOM*/
WHERE 
T0.Code = '[%0]'

  regards Lothar

  0

Please sign in to leave a comment.