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.