Procurement Document Links

Hi Guys,

I am trying to create a report that shows a PO that is generated from an SO using the Procurement Document function in the Logistics tab of a Sales Order.

I believe that the tables I require are OPOR, POR1, ORDR, RDR1, with the required fields being

SO side - Card Code, Card Name, Doc Num, Doc Type, PoTrgNum

PO side - CardCode, CardName, DocNum, DocType, ImportEnt

What I need to be able to do is link the two documents together so where PoTrgNum is populated with a PO number or ImportEnt it shows the corresponding document next to it - I hope that makes sense, apologies if not. I will be turning this in to a Crystal Report so your help is greatly appreciated.

Kind regards

Sean Martin