Recently I needed to compare Financial Statement Versions, Configurations and Table data between two SAP systems or clients in order to ensure synchronization across multiple landscape
While SAP offers great tools to compare ABAP programs and many configurations within the system and across multiple systems, comparing financial statement versions, table data could be tricky. Comparison in Excel may work well for comparing table data, but it becomes a time consuming activity if you need to compare each and every cell
I stumbled upon a beautiful tool to compare two text files. SAP allows any Financial Statement Version (FSV), Configuration or Table to be downloaded to a ASCII text (.txt) file using menu option System > List > Save > Local File > Unconverted in case of FSVs or Configuration screens
On screens where the Save Local option is not available a Print option may also be used to download data to an unconverted .txt file. Only precaution required is, files from both the SAP systems or clients you need to compare should be downloaded with exact same procedure.
After downloading the data into two files to be compared, just enter the location of the two data files in the Exam Diff tool and it would provide you with usual analysis of entries which are common in both the files, records which exist in one file but do not exist in other file or records which exist in both the files but are different in some way
ExamDiff is a freeware visual file comparison tool which can be downloaded from PrestoSoft's website at the following location: ExamDiff Download Page It's also available for download on CNET.
No comments:
Post a Comment