Skip to Content

References between SAP B1 tables

Hello,

I'm developping reports for our company on SAP B1 (V. 9.2 PL09). I'm specifically looking for the references between the tables, I can't find any doc about this. I need to get the references between:

INV1 and OPOR (this one I could find out: PoTrgEntry).

POR1 and OPDN (Good Receipt PO)

PDN1 and OPCH (A/P Invoice)

And how does it works when there's more than one related items (like having 2 or more GoodReceipt PO attached to a single Purchase Order) ?

thanks for your time and help!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 15, 2017 at 10:53 AM

    In the B1 SDK installation folder you can find a DB Reference help file. I am not sure there is any document beyond that.

    Add comment
    10|10000 characters needed characters exceeded