cancel
Showing results for 
Search instead for 
Did you mean: 

Trying to link Goods Receipt Purchase Order (OPDN) to Landed Cost (OIPF)?

Former Member
0 Kudos

Hi Everyone,

I am wondering what the link is between a Goods Receipt Purchase Order and a Landed Cost. Here is a diagram of the link that I am trying to determine.

According to the Database Tables Reference there is a link between OPDN (Goods Receipt Purchase Order) and OIPF (Landed Costs) called 'ImportEnt', as shown below -

However I can't work out what 'ImportEnt' links to on the OPDN (Goods Receipt Purchase Order) side.

Any advice concerning how to link OPDN to OIPF will be greatly appreciated.

Kind Regards,

David

Accepted Solutions (1)

Accepted Solutions (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Try this query:

SELECT T0.[DocNum], T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.[Quantity],T1.[BaseEntry],t2.docentry,T1.[LineNum],T2.[BaseLine], T1.[Reference] FROM OIPF T0 INNER JOIN IPF1 T1 ON T0.DocEntry = T1.DocEntry left join PDN1 T2 on T1.[BaseEntry] = t2.docentry and T1.[LineNum] = T2.[BaseLine] INNER JOIN OPDN T3 ON T2.DocEntry = T3.DocEntry

Thanks & Regards,

Nagarajan

Former Member
0 Kudos

Hi Nagarajan,

Thank you for the helpful response. The key to fixing my query was in the code below (which you kindly shared) -


LEFT JOIN PDN1 T2 ON T1.[BaseEntry] = T2.[DocEntry] AND T1.[LineNum] = T2.[BaseLine]

Kind Regards,

David

Answers (0)