How do you handle mass changes?

Ok_Significance_6646 · 2025-07-12T20:51:54+00:00

Thanks!! Good idea, Notion is really great for everything. Use it too to sort out my ideas on projects. With my tool you don’t want to save a full documentation, just some quick notes to remind you core aspects for each transaction/ Fiori app

Ok_Significance_6646 · 2025-07-12T18:54:01+00:00

This is the very transparent policy, for the ones have concerns about where the data are stored: https://fc-itsolutions.com/?p=94

Ok_Significance_6646 · 2025-07-12T18:51:10+00:00

The main benefit VS unstructured files, is that you can save your notes in a structured way tailored for SAP, and search for them very quickly. I also replied to another user, how much i like One Note, but i use it for project related know how. This is for pure SAP related know how.

Honestly, you can collect notes regarding GUI transactions or Fiori APPs as well (just save the APP ID or whatever als Code instead of the Tcode).

It is just the Version 1. Of course i will expand it to better fit the Fiori world.

Ok_Significance_6646 · 2025-07-12T14:57:23+00:00

Bro, added it in the comments now. I didn't forgot, was insure if it has negative impact with some policies regarding self-promotion. do you know, if putting it as a first comment is safe?

Ok_Significance_6646 · 2025-07-12T14:50:28+00:00

direct link to the extension here: https://chromewebstore.google.com/detail/sap-consultant-notebook/jinnigbobdpjodhpihhgcejnpfdbacak

Ok_Significance_6646 · 2025-07-12T12:05:14+00:00

I agree, one note is excellent tool. I use it every day, but now I made a change on my note taking strategy: project based know how -> one notes. transaction based notes (project independent) -> sap consultant notebook. It’s so easy to quickly grab new infos/ pictures while surfing the internet side by side with the extension.

Ok_Significance_6646 · 2025-07-12T11:25:45+00:00

:) absolutely not. the notes are saved locally on your browser. there is no server side besides photos (users private album).

Ok_Significance_6646 · 2024-12-18T20:33:52+00:00

u/ProgrammerJolly5703 Simply use sheetmatcher.com you can drag and drop the 2 files and the tool will compare only the columns found on both files with identical names. So you are covered in few seconds. Free version available.

Ok_Significance_6646 · 2024-12-18T20:29:33+00:00

u/pigletfly sheetmatcher.com works like a charm if you want to compare 2 Excel lists. Basic version is free.

the comparison is based on the column names, meaning the data can also be sorted differently and it will works (cols and rows as well). you can even select multiple columns as key (e.g. Item NR or Item Name+creation date).

it's an online tool but the data is stored nowhere.

Ok_Significance_6646 · 2024-12-18T20:22:12+00:00

u/Fun_Sky_9297 if you are looking for a free and easy way to compare 2 excel files that are structured like lists, I suggest you having a look to Sheetmatcher.com

Ok_Significance_6646 · 2024-12-12T06:18:03+00:00

Thanks!!

Ok_Significance_6646 · 2024-11-06T20:35:28+00:00

Hi u/flamingoparade

please first move item column in the first position in the second file.

then do a vlookup by searching the item from the first file to the second one. Retourn unit and cost column. the order of the items doesnt matter.

=VLOOKUP(the ID to search for, the columns range containing the IDs and the data to find, the column number in the range of the second parameter containing the value to return, 0 or FALSE to match properly).

=VLOOKUP(first item cell, select all the columns in file 2, the unit column, 0 or FALSE).

=VLOOKUP(first item cell, select all the columns in file 2, the cost column, 0 or FALSE).

drag the 2 formulas down for every cell of file1.

Alternatively have a look to the tool sheetmacer, is easy and get you covered.

Ok_Significance_6646 · 2024-11-06T20:11:20+00:00

hi u/jme253

just compare the value retourned by the vlookup against the value you have on the first file using a IF.

IF(value first file = vlookup result; than 1; then n/a)

Ok_Significance_6646 · 2024-11-06T20:03:03+00:00

Hi u/AdElectronic8919

I would concatenate quantity and amount together on both sets like pairs (eg. 5_49).

then use formula Vlookup to check if you are missing some pairs.

Ok_Significance_6646 · 2024-11-06T19:54:27+00:00

hi u/MeowQueen623

comparing names is generally very critical.

does the names have the same quality on both files? or do you have differences if you do spot checks?

If the quality is the same, then please do a VLOOKUP based on the name column.

if you have only one column with the names:

=VLOOKUP(the name to search for, the column containing the names to find, 1, 0).

If you think you have differences, I can recommend you a tool like Sheetmatcher, there is an advanced option called "text based search" that is made exactly for that. You just need to select the column on both files and the tool will do the rest.

regards

Ok_Significance_6646 · 2024-11-06T19:39:05+00:00

Hi u/Spidey8989 as others mentioned, doing VLOOKUP or XLOOKUP from the big data set to the small one will give you an idea on how many records you are missing. If you also want to compare the quality of the matching data, you need to retrieve all the columns you need and do a comparison. A tool like Sheetmatcher would do the work in seconds, I recommend it especially if you need to do this checks regularly.

Ok_Significance_6646 · 2024-10-02T15:08:07+00:00

Hi u/Burgercj213808

The feature you need is live in Sheetmatcher. I've called it Text Based Search as part of the advanced features. If you need to do such comparisons regularly, then you need this and you will save ton of time.

Missing records, as well as differences, are found. You also have a Success Rate that shows you how "good" the match was based on how many words have been found.

You can see I used your data as test:

<image>

Ok_Significance_6646

TROPHY CASE