Skip to Content
Jul 08, 2019 at 06:05 PM

Join Sales Order - Received payments and Business Partner

455 Views Last edit Jul 10, 2019 at 12:28 PM 2 rev

Hi team,

Need to build a query with this tables from SAP B1:

ORDR - Sales Order

RDR1 - Sales Order - Rows

OCRD - Business Partner Data Master

ORCT - Payments Received

how can I join all these tables to use their fields?

I need to know the payments received for the items purchased by the customer