Skip to Content

SAP B1 Query for PR, PQ & PO. Some of PO created without PQ direct Created from PR.

Jul 23, 2017 at 11:35 AM


avatar image
Former Member

Hi Expert,

I already created query but Without PQ. PR not displaying in my report.Kindly help for me.

This is my Query.

SELECT T0."DocNum" "PR Number", T1."LineNum", T0."DocDate" "PR Date", T1."ItemCode", T1."Dscription", T1."Project", T1."Quantity" "PRQty",T3."CardCode", T3."DocNum" "PQNumber", T2."Quantity" "PQQty", T5."DocNum" "PO Number", T4."Quantity" "POQty", t4."Price" FROM OPRQ T0 INNER JOIN PRQ1 T1 ON T0."DocEntry" = T1."DocEntry" left outer join PQT1 T2 on T1."DocEntry" = T2."BaseEntry" and T1."LineNum" = T2."BaseLine" left outer join OPQT T3 on T3."DocEntry" = T2."DocEntry" left outer join POR1 T4 on T2."DocEntry" = T4."BaseEntry" and T2."LineNum" = T4."BaseLine" left outer join OPOR T5 on T5."DocEntry" = T4."DocEntry" where T3."CardCode"='SCP' and month(T0."DocDate")=06 and year(T0."DocDate")=2017 order by t0."DocNum", T1."LineNum"

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

0 Answers