Can we create SQVI for PR to PO to GRN flow

[Former Member]

Dear Experts, Can we create report by linking PR, PO and GRN tables. If it is possible what are all the unique fields to be linked in SQVI? Kindly guide me on this. When i tried, getting Illegal connections error message.

I want to create SQL query for the below fields:

Created By PR NO. Department Doc.Type PR Date PR Release Date Lead Time (Days) RFQ Num RFQ Date Lead Time (Days) Evaluation NO Eval Date Lead Time (Days) Deleted Purchase Date-In Date-Out Lead Time (Days) Intiator Date-In Date-Out Lead Time (Days) Section Head Date-In Date-Out Lead Time (Days) Dept Head Date-In Date-Out Lead Time (Days) Approval Rel Code1 Date-In Date-Out Lead Time (Days) Rel Code2 Date-In Date-Out Lead Time (Days) Rel Code3 Date-In Date-Out Lead Time (Days) Rel Code4 Date-In Date-Out Lead Time (Days) Rel Code5 Date-In Date-Out Lead Time (Days) Date-In PO No PO Date Lead Time (Days) Overall Total Lead Time (Days) PO Del.Date GR Doc(103 Mvt) GR Date Lead Time PO Del.to GR date

[Lakshmipathi · Accepted solution]

Not sure what efforts you made in achieving this. In EKPO & EKBE tables, all purchasing related data are available including PR & PO references