Where Used in SAP B1

[Former Member]

Hello there,

     I am looking for the best way to do a where used function in SAP B1 to find which BOMs contain certain material.  Can anyone share any experience on this type of functionality in B1? 

[Former Member · Accepted solution]

Hi Lance,

Yes Possible with the help of SAP Query.

Please check below query.

SELECT T0.[Code] As 'Father Item Code', T1.[Code] As 'Component Item Code', T2.[ItemName] As 'Component Item Name', T1.[Quantity] As 'Component Item Quantity', T1.[Warehouse] As 'Component Warehouse', T1.[Price] As 'Component Warehouse', T1.[IssueMthd] As 'Component Issue Method' FROM OITT T0  INNER JOIN ITT1 T1 ON T0.[Code] = T1.[Father] INNER JOIN OITM T2 ON T0.[Code] = T2.[ItemCode] WHERE T0.[Code] =[%0]

Hope this helps

--

--

Regards::::

Atul Chakraborty

[Former Member · Accepted solution]

Hi Atul,

I'm also looking for a report to show in which BOMs a particular item is currently used. The question Lance posted seems to need the same thing. However, your report only shows the items used in the BOM of one particular item. Instead, I'm looking to show all BOMs that one particular item is used in.

In other words, using your report gives me all children of a parent item. Instead, I need all parents for one item.

Did I misunderstand, or am I doing something wrong maybe?

Thanks!!!

Phil

[kothandaraman_nagarajan]

Hi,

1. This is function is useful to find BOM( FG item) where selected item is used.

2. Enter components in selection criteria. Then you get detailed of used BOM and related information.

Thanks & Regards,

Nagarajan

[Former Member]

Nagarajan,

     I find Atul's query to met my needs but it appears your solution may be more appealing to my users.  Is this a print layout? 

[kothandaraman_nagarajan]

Hi,

No. This is crystal report.

Thanks & Regards,

Nagarajan

[Former Member]

Yes! this Is perfect.  Thank you Atul

Regards,

Lance

[Former Member]

Hi Lance,

If you got Answer then Please Close this thread by Making Correct Answer.

Thanks

--

--

Regards::::

Atul Chakraborty