We can use Process Runner transaction to read as well as write values simultaneously. Here's how you do it.
1.Record a new transaction for MM02. You can refer the tutorial section of Process Runner for recording a new transaction and go to the Mapper tab.
2.Right click on MARA-GREW (Gross Weight) and click on 'Clone'.
3.Map the newly copied row to SAP To Excel and column D as to retrieve the Gross Weight value before update from column B. SAP to Excel values in here will be the one that we get before any updates to that field.
4.Similarly do it for Net weight.
5.As soon as you are done mapping as above, go to Home Tab. You will notice an extra option in Control parameters automatically suggested by Process Runner. This is because in order to read/retrieve SAP To Excel fields we need to turn off 'Stop transaction on Commit and run in BI mode'. There's an additional option to "Suppress All "Copy from SAP To Excel" mappings" which you can turn on to perform normal MM02 write function. This way you can use the same transaction to work for two modes Read and Read-Write.
6.Notice the below output which shows gross weight and net weight before change in column D and E. It also updated Gross weight and Net weight from column B and C.
Next |
|