SAP QM Master Data Cutover Tracker Worksheet
QM master data has a hard load order, and errors in an early object block everything after it. A simple tracker per object gives the cutover meeting one honest view of what is loaded, what failed and what is still open.
| QM object | Load method | Owner | Source records | Loaded | In error | Not yet loaded | Complete % | Error rate % | Load date | |
|---|---|---|---|---|---|---|---|---|---|---|
0 | 100% | 0% | ||||||||
0 | 100% | 0% | ||||||||
174 | 81.4% | 6.6% | ||||||||
1,160 | 75% | 2.7% | ||||||||
310 | 0% | 0% |
Object names and methods are examples. Load order matters: characteristics and methods first, then catalogs and sampling, then plans, then material QM views. Confirm the objects available in your release of the migration cockpit.
Validate QM data before the load
Optional review of your source spreadsheets for common load errors.
Optional. The tool and every export work without this. No spam.
How to use it
List each QM object you migrate, the method used and an owner. Enter the number of source records, the number loaded and the number in error after each load run. The worksheet calculates the open records, percent complete and error rate for every object and for the whole load. Export to Excel for the cutover report.
- Update after every load cycle, not only at the end
- Keep error counts separate from not-yet-loaded counts
- Sort by load date to see the critical path
- Add a row for each separate plant load if plants load apart
Load order for QM
Inspection plans reference master inspection characteristics, inspection methods, code groups, sampling procedures and often work centers and test equipment. Load those dependencies first. Material QM views and inspection types activate lot creation and should load after plans exist, otherwise lots are created with no plan. Quality info records and open lots come last, if at all. Many projects choose not to migrate open lots and instead close them in the legacy system.
Reading the numbers
Percent complete is loaded over source records. Open is source minus loaded minus errors, so a negative number means counts were entered wrongly. A rising error rate on plans often points to a missing characteristic or a work center that was not loaded. Look at the first error messages before reloading, since repeating a failed load usually repeats the same failure.
Common mistakes
Loading material QM views before inspection plans exist. Reloading plans that were created already, producing duplicate versions. Forgetting to transport the QM customizing before the data load. Not reconciling counts against the legacy system after the load.
Frequently Asked Questions
Which method should I use to load inspection plans?
It depends on the release and the volume. The S/4HANA migration cockpit covers some QM objects, and older projects use LSMW or BAPI-based programs. Check which objects your release supports before you choose.
Should I migrate open inspection lots?
Usually not. Open lots carry results and status that are hard to recreate. Most projects finish them in the legacy system before cutover and start new lots in SAP after go-live.
What error rate is acceptable?
Any error needs a decision. Errors are acceptable only when they are understood and fixed in a later cycle before cutover. Zero unexplained errors on the final run is the usual exit criterion.
Why track not yet loaded separately?
Because records that were never attempted are a schedule risk, while records in error are a quality risk. Mixing them hides which problem you actually have.
If your plans and characteristics sit in spreadsheets or a legacy QMS, Netray can help check them for load errors before the cutover.
Related Tools
SAP QM Inspection Plan Design Template
A design document you fill in before building an inspection plan in QP01: scope, operations, characteristics, sampling and sign-off.
SAPSAP QM Calibration Equipment Register Worksheet
A register of test equipment with calibration interval, as-found and as-left error and tolerance use, to prepare or reconcile SAP QM calibration data.
SAPSAP QM Inspection Workload and FTE Calculator
Turn inspection lot volume, characteristics per lot and skip-lot rate into monthly inspection hours, staff needed and cost.
SAPSAP QM Certificate of Analysis Profile Template
A requirements document for the certificate of analysis your customers expect from SAP QM, with the layout and sample certificate content in one place.