PO Details with GR/IR Documents and Payment Documents

[manojikhar]

Respected All,

I need a report for PO Which look like this;

Text will be captured from RE-L Follow on Document ( FI user give description for expenses in MIR7)

I tried in SAP Query but not getting desired result. Kindly Help.

[former_member222241]

Hi,

There are two ways:

1. I agree with Gabriel Coleti answer.

2. You need to club BSEG with BKPF to get PO (BSEG - EBELN) and Item (BSEG - EBELP)

[coleti]

Dear Manoj,

Try to create some query or Z report using the MM table EKBE which contain the History per Purchasing Document. I don´t SAP will have a standard report as you need.

Best regards,

Gabriel Coleti

[manojikhar]

Thanks, but how to get Corresponding Accounting Document No. of Material Document No.

[coleti]

You have the MM document key defined in the Reference Key BKPF-AWKEY... in case of GR document you will have MBLNR + MJAHR in this field, for IR you will have BELNR + GJAHR.

Best regards,

Gabriel Coleti