Find an unique relation (unique field) between two transaction ME5A and ME2M.

[Former Member]

Hi all, would you please help me find an unique relation (unique field) between two transaction ME5A and ME2M.

Actually, I am going to export spreadsheets from both of above transactions and then use Excel functions to other useful reports.

Thanks a lot.

H. Yazdani

[JL23]

Are you not able to find common fields when you execute both reports?

I think that is pretty easy, the question is more if they make any sense to be linked for unknown reasons in your Excel

ME5A lists requisitions, ME2M purchase orders by material - if the requisition is not yet processed into a purchase order then both reports have to correlation

[Former Member]

Dear Jurgen,

Thanks for your reply.

For example, I like know the open quantities of thousands purchase requisition into a report transaction.

ME2M give reports of purchase orders (PO) by material and ME5A give Purchase requisitions (PR). For finding the residual of a PR (with 1000 units of a good for example) you must be have the unique field between these two transaction to calculate sum of all Po on a PR first.

Actually I don't know any transaction for giving a report which both of PO and PR be exist on it.

Regards.