Purchase Request (PR) to Purchase Order (PO) days taken

[MukeshSingh]

Expert,

We are using SAP 9.0 PL4

We need Query for PR to PO days taken

Example

I make Purchase Request on 05/09/14 than make Purchase Quotation on 07/09/14 finally made Purchase Order on 10/09/14 with line item 5

We need report

From PR date to PO date. How many days taken?

My problem is how to join with PR to PO directly because PR to PO not tag directly in between we made Purchase Quotation.

Please advise

Thanks in advance

Mukesh Singh

[former_member186712]

Hi Mukesh,

Try this query. It connects the 3 tables that you need. You need to add the fields that you want to see on the report.

SELECT T0.[DocNum], T1.LineNum, T0.[DocDate], T1.[ItemCode], T1.[Dscription], T1.WhsCode, T1.[Quantity], T3.CardCode, T3.Cardname, T2.BaseType , T2.[BaseRef] , T2.[BaseLine],  T2.DocENtry , T2.[Quantity] , T4.DocEntry, T5.DocNum, T4.Quantity, t4.price, t4.basetype
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 and T2.BaseType = '1470000113'
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 and T4.BaseType = '540000006'
left outer join OPOR T5 on T5.DocEntry = T4.DocEntry
order by t0.docnum, T1.LineNum

Regards,

[kothandaraman_nagarajan]

Hi,

Not sure below link works for you or not.

Try:

Link PRQ1 linevendor with OCRD cardcode and line OCRD cardcode with OPOR cardcode

Thanks & Regards,

Nagarajan

[MukeshSingh]

Hi Nagarajan Sir,

We not tagging in PR supplier code than it's difficult to extract the data

Our requirement is PR to PO how many days taken

Regards

Mukesh Singh

[Former Member]

Hi Mukesh,

Because PO may only have direct link to PQ, you could create a query for this relation instead.

In my option, no matter how early you have the request, it may only count if you raised a quotation.

Thanks,

Gordon

[MukeshSingh]

Hi Gordon Sir,

Thanks for your suggestion but my problem is some time we making PQ but some not direct making PO from PR.

If possible please send me query.

Regards

Mukesh Singh

[Former Member]

For those not direct PO from PR, how do you link them?