What I would like to do is produce a web based version of the FLOC and BOMS with the current stock levels for my entire line. The reasoning for this is so those that shy away from SAP can still see if we are carrying spares should the need arise to change a spare.
Further to this I will be adding engineering drawings to the website and other relevant info for the shift engineers/fitters to help them find the required info quicker than using SAP.
I am not aware of any transaction that would display the entire expanded floc and boms of the line and then the associated stock levels of each material within the structure, unless somebody else knows differently.
Has anybody done this, or know how to do it. We have got it working as a prototype but it extracts the info and dumps it into excel and then we push this to SQL; its slow and very clunky.
Any help would be gratefully appreciated
Thanks in advance