Skip to Content
author's profile photo Suyog Shah
0
Suyog Shah
Sep 08, 2020 at 05:58 PM

Relationship Map dates query

141 Views Last edit Sep 08, 2020 at 09:32 PM 2 rev

Hello,

I am attempting to write a query that will display Relationship Map Dates

The following fields need to displayed in the report in the order

PO # | PO Ready Date | PO ETA | PO Del. Date | GRPO # | GRPO Posting Date | Landed Cost Posting Date

The tables I am using are :

  • OPOR
  • POR1
  • PDN1
  • OPDN
  • OIPF

The query I have used is as follows:

SELECT T0.[DocNum] "PO#", T1.[U_CommitedDate] "PO Ready Date", T2.[U_ArrivalDate] "PO ETA", T0.[DocDueDate] "PO Del. Date", T3.[DocNum] "GRPO#", T3.[DocDate] "GRPO Posting Date", T4.[DocDate] "Landed Cost Posting Date" FROM OPOR T0 INNER JOIN POR1 T1 ON T0.[DocEntry] = T1.[DocEntry], PDN1 T2 INNER JOIN OPDN T3 ON T2.[DocEntry] = T3.[DocEntry] INNER JOIN OIPF T4 ON T3.[ImportEnt] = T4.[DocEntry]

it says "No data was found as a result of the selection criteria".

Please help and suggest.

Thanking you,

Regards,

Suyog Shah