Relation Between VendPackingSlipJour,vendtrans and VendInvoiceJour

Question Status

Suggested Answer
Scotly asked a question on 12 Apr 2017 6:57 AM

Hi Every One,

I am new to this community ,

I have requirement that I need pull data from VendPackingSlipJour,vendtrans and VendInvoiceJour

I am struggle to join three tables  

Please Help

Reply
Suggested Answer
André Arnaud de Calavon responded on 12 Apr 2017 6:59 AM

Hi Scotly,

The most common relation on these tables is the Voucher (or Invoice) and Transaction date (or Invoice date). The relations are also visible in the table designs.

Reply
Scotly responded on 12 Apr 2017 7:12 AM

Can you please elaborate more about Primary key and foreign key relationship between these tables ?

Reply
André Arnaud de Calavon responded on 12 Apr 2017 7:49 AM

Hi Scotly,

What is your exact question? Did you have a look at the tables and the defined relations in the Application Object Tree (AOT)?

Reply
Suggested Answer
André Arnaud de Calavon responded on 12 Apr 2017 6:59 AM

Hi Scotly,

The most common relation on these tables is the Voucher (or Invoice) and Transaction date (or Invoice date). The relations are also visible in the table designs.

Reply