Query

[Former Member]

How can we create relation(JOINING) between Purchase order and Goods Received PO

for identify for Vendor and item quantity relation.

Edited by: Philip Eller on Jul 1, 2008 9:27 AM

[former_member583013 · Accepted solution]

Sandeep,

When you say creating a relation what exactly are you trying to accomplish. Are you building a Query Report?

Explaining a little more of what you are doing will make it easy for us to answer more precisely

Suda

Edited by: Rui Pereira on Jul 8, 2008 6:53 PM

[Former Member]

The joining is through lines in goods receipt (table pdn1) and BaseRef and BaseType fields. Base type should be 22 for vendor order and BaseRef is DocNum in OPOR table.

Edited by: Petr Verner on Jun 16, 2008 10:50 AM

[Former Member]

Hi,

The link is between the line level GRPO (PDN1) and header level PO (OPOR). So:

PDN1.BaseEntry = OPOR.DocEntry

Regards,

Nat