Skip to Content
0

References between SAP B1 tables

Dec 14, 2017 at 07:25 PM

36

avatar image
Former Member

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!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Ralph Oliveira
Dec 15, 2017 at 10:53 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded