Comparation of Query Properties with WinMerge and RSRTQ transaction.
Steps to make the comparison of the changes in a query:
1) 1) Run the transaction RSRTQ and choose a query, for example: Z_FI_MPCA2_016.Select all
2) 2) Checkbox and run.
sd 3) Need to press Export button as mentioned below:
4) Information popup comes then press OK.
5) Downloaded the file in Excel Format:
5) Open the Excel file y and we save in CSV format (coma delimited).
6) Lets take example : make the change in the query, in this case doing Always Show column “Cost to Serve per Hour to HIDE.
Pre Changes on Query : –>
After Changes on Query:–>
7) install WinMerge v 2.14, if it’s not have install.
http://winmerge.org/downloads/
8) Open the WinMerge Program, and select the menú File–>Open.
2)
9) Press Browse button to select the two newly csv files generated
10) Press OK and obtain the result of the comparison.
This figure shows the change to hide the column Cost to Serve per Hour that was detected by the WinMerge program.
Hi Puneet,
Nice document for comparing between 2 queries, very helpful when changes have to be found between the two.
Regards
Laurant Dsouza
NIce one Puneet... 🙂
Nice doc..
Regards
Poorna
good pictorial represenation
Nice doc ...you can also use "compareit " tool to replace winmerge .
Great document to have comparison.
Good one.
Thank you, very helpful document.
Best Regards,
Venu Gopal
Nice doc ...