Skip to Content
0

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

Apr 27, 2017 at 09:35 AM

46

avatar image

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

pu
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jürgen L
Apr 28, 2017 at 03:09 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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.

0