Three way match Report (PO/GR/IR) for import vendor

[Velusamy]

Dear Friends,

we have requirement to develop a reqport three way match for Import vendo

purchase order , Goods Receipt, Invoice receipt

we need to track weather goods receipt happen against the invoice aswell as GR happen against IR.

could you please provide your input wheather standard SAP itself proved the Reports

1. what are the configuration we need to perform to get that report.

2. which transaction code we need to use pull that report.

If the standard report not possible.

3. could you please advice what are the table and fields we can use to develop the report.

Advance thanks for your support. 

[sanilbhandari]

Hi

Please have a look at the report ME80FN. This transaction essentially pulls up data based on Purchase Order history and has the required fields you are looking for. You can get the vendor details, PO No, GR Quantity and value (both Delivered and Ordered), Invoice Quantity & Amount (Both Invoiced and Total as per PO).

Click as per the screen shot below to get the PO History and you will have the required information.

Regards

Sanil Bhandari

[Velusamy]

Dear Friends,

Thank you very much for your reply

We started developing new report

Logic

1. Import vendor Table LFA1 based on account group
   (ktokk field) And lifnr vendor number
2. Vendor Company code details LFB1
3. Based on Vendor information fetch the data Po document
   information EKKO and EKPO
4. Based on PO information Fetch the data from MSEG
   & MKPF ( Goods Receipt)
5. Based on PO information fetch the data from RSEG
   & RBKP.
6. And finally applied the logic to get the report.

      Once again thanks every one

[Former Member]

Hello,

Thanks for your reply Mb5s and ME2L/ME2N/ME2M not satisfied our requirement

my business needs single report for this requirement.

could you please what are the tables we need to refer we will develop the rew report.

once again thanks for your reply...:)

[Former Member]

SKV : A custom report needs to be build based on EKBE table( PO History)

[former_member190652]

I don't think there is any standard report for this.  You need to develop a custom report for this.

[Former Member]

Hi,

Please check MB5S as well.

Thanks,

Jyoti

[Former Member]

Hi Senthil Kumar,

You can try standard MM reports ME2L/ME2N/ME2M etc.

Regards,

Arjun