PR and PO list-SAP Std. T-Code

[former_member196530]

Hi

We have an urgent requirement from client to know the list of purchase order converted from purchase requisition on daily basis .Selection option will be :

Plant : USXX

Date : Purchase Order Create/Purchase Conversion date

Out put should be :

Purchase Req Number :

Purchase Order Number :

Plant :USXX

Date : XX/XX/XXXX

Is there any standard SAP transaction for this above requirement.I need to create a variant for this .Please let me

know

Regards

Jia

[former_member196530]

closed

[csaba_szommer]

Hi Jiaul,

You can create a query (e.g. in SQVI) using tables EKKO & EKPO.

INPUT (selection fields)

date of creation: EKKO-ERDAT

plant: EKPO-WERKS

suggetion:

PR no.: EKPO-BANFN (filter criteria: >0)

OUTPUT

PR no.: EKPO-BANFN

PO no.: EKKO-EBELN (or EKPO-EBELN)

Plant: EKPO-WERKS

date of creation: EKKO-ERDAT

Please give feedback if it's OK / not OK.

(When you run the query you can use selection criteria '>0' for EKPO-BANFN - in this way you will get PO items that were generated from PR)

BR

Csaba

Edited by: Csaba Szommer on Mar 4, 2008 6:43 PM

[Former Member]

GO transaction ME57.

Kevin