SAP QM Inspection Plan Planning Worksheet (Excel)
Most inspection plan problems are decided before anyone opens SAP: which characteristics, which method, which sample. This worksheet lets the quality engineer and the SAP QM consultant agree the content row by row and see the inspection time it implies.
| Operation | Characteristic | Data type | Inspection method | Lower limit | Upper limit | Tolerance width | Sample size | Min per unit | Minutes per lot | |
|---|---|---|---|---|---|---|---|---|---|---|
0.10000000000000142 | 7.5 min | |||||||||
0.4000000000000057 | 5 min | |||||||||
1.6 | 6 min | |||||||||
0 | 16 min | |||||||||
0 | 2 min | |||||||||
0 | 2.5 min |
Qualitative characteristics have no numeric limits, leave limits at 0. Use this as a planning aid; the master inspection characteristics and plan are maintained in SAP (QS21 and QP01).
Inspection plan review
Optional: ask for an expert review of your inspection plans against drawings.
Optional. The tool and every export work without this. No spam.
How to use it
List each characteristic by operation, choose its data type, state the method and the limits, then the sample size and time per unit. The worksheet computes the tolerance width and minutes per lot and totals them. Edit, add or delete rows freely and export to Excel to send for review. Group rows by operation as they will appear in the inspection plan so the review follows the same order as the SAP master data.
Mapping to SAP QM objects
Each row maps to a master inspection characteristic (transaction QS21), usually a quantitative or qualitative one, which is then assigned to an operation in the inspection plan (QP01). The inspection method is a separate master record (QS31), and the sampling procedure (QDV1) defines the sample size. Planning these together prevents later rework when a characteristic is created without a method or valid sample rule.
Reviewing the plan
Check that every drawing characteristic flagged critical has a row, that limits match the latest drawing revision and that the data type fits the way results will be recorded. Quantitative characteristics are needed if you want capability analysis later. Sum the minutes per lot against realistic throughput; a plan that takes 90 minutes per lot will not be followed on a busy dock.
Common mistakes
Writing the limits as a tolerance range instead of absolute values, mixing units across rows, using attribute checks where a measurement would yield capability data, and forgetting document and label checks that auditors ask for.
Frequently Asked Questions
Can I load this straight into SAP?
No, it is a planning document. Use it to align on content, then maintain master data in SAP or through your standard mass upload route.
Why compute minutes per lot?
It shows the workload a plan creates, so you can balance risk against the inspector time actually available.
How do I treat qualitative checks?
Choose the Qualitative type, leave numeric limits at zero and describe the acceptance criterion in the method column.
What about different inspection types?
Create one worksheet per inspection type, for example goods receipt, in-process and final, since sample sizes and characteristics differ.
If you maintain many inspection plans, we can help generate and check them against drawings and ERP data before they are loaded, with human approval.
Related Tools
SAP QM Inspection Effort and Cost Calculator
Estimate the annual labour and destructive test cost of a sampling plan and see the effect of sample size.
Quality & InspectionSAP QM Gauge R&R Study Calculator
Combine repeatability, reproducibility and part variation into %GRR, %tolerance and distinct categories.
SAPSAP QM Zero Acceptance Sample Size Calculator
Find how many units to inspect when the rule is accept on zero defects, for a given lot size, LTPD and consumer risk.
SAPSAP QM Implementation Readiness Checklist
Check master data, integration points, inspection setup and user readiness before cutting over SAP QM.