Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Help on joining tables.

Greetings of the Experts.

Can anyone help me in joining OPOR, POR1, OPDN and PDN1 tables.

By default B1 joins OPOR and POR1, OPDN and PDN1.

Need some information for PO and GRPO comparison.

Regards.

replied

Hi,

Try this link between tables:

OPOR T0  INNER JOIN POR1 T1 ON T0.DocEntry = T1.DocEntry left join PDN1 T2 on  T2.[BaseEntry] =  T1.[DocEntry] and T2.[BaseLine]  =  T1.[LineNum] INNER JOIN OPDN T3 ON T2.DocEntry = T3.DocEntry

Thanks & Regards,

Nagarajan

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question