We don't use drawings or documents in our company but I am trying to assist a friend on how to download a report with basic material (parts) and drawing information into excel.
From what I can see, is that the drawing is saved in additional data > document data as type DWG. The basic information that the user wants is available in MARA (material number & description) & DRAW (drawing number for a plant/s).
I don't know how to access the drawings attached to a material for a plant because draw does not reference the material and I don't know if there is a table referencing both?
I want to help the guy access the information and download to excel... if necessary, do a lookup to produce a simple report
Any suggestions please