Skip to Content

How to join OPRQ, PRQ1, OPOR and POR1 tables of SAP B1?

Hi all,

How can I join OPRQ, PRQ1, OPOR and POR1 tables of Purchase Request and Purchase Order in SAP B1 query?

Please anyone can help me

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 20, 2017 at 01:59 PM

    Hi,

    Sorry, I did it by joining OPOR1.[BaseEntry] = OPRQ.[DocEntry]

    Thank you all

    Add comment
    10|10000 characters needed characters exceeded