# SAP Master Inspection Characteristic Upload Worksheet > Source: https://netray.co/tools/sap-master-inspection-characteristic-upload-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Collect master inspection characteristics in one worksheet, check tolerances and export a clean file for your data load. ## Category sap ## Erp SAP ECC / S/4HANA ## Industry Manufacturing ## Audience - SAP QM consultant - Quality engineer - Data migration lead ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Plant **Key:** plant **Type:** text #### MIC name **Key:** mic **Type:** text #### Short text **Key:** short **Type:** text #### Type **Key:** kind **Type:** select **Options:** - Quantitative - Qualitative #### Unit **Key:** uom **Type:** select **Options:** - MM - UM - KG - G - DEG - N - none #### Lower limit **Key:** lsl **Type:** number #### Upper limit **Key:** usl **Type:** number #### Tolerance range **Key:** range **Type:** number **Expr:** usl - lsl #### Target **Key:** target **Type:** number **Expr:** (usl + lsl) / 2 #### Decimals **Key:** dec **Type:** number **Rows:** **Plant:** 1000 **Mic:** DIA_SHAFT_A **Short:** Shaft diameter A **Kind:** Quantitative **Uom:** MM **Lsl:** 24.98 **Usl:** 25.02 **Dec:** 3 **Plant:** 1000 **Mic:** LEN_SHAFT **Short:** Shaft overall length **Kind:** Quantitative **Uom:** MM **Lsl:** 149.9 **Usl:** 150.1 **Dec:** 2 **Plant:** 1000 **Mic:** SURF_RA **Short:** Surface roughness Ra **Kind:** Quantitative **Uom:** UM **Lsl:** 0 **Usl:** 1.6 **Dec:** 2 **Plant:** 1000 **Mic:** TORQ_NUT **Short:** Nut tightening torque **Kind:** Quantitative **Uom:** N **Lsl:** 45 **Usl:** 55 **Dec:** 1 **Plant:** 1000 **Mic:** VIS_FINISH **Short:** Visual finish **Kind:** Qualitative **Uom:** none **Lsl:** 0 **Usl:** 0 **Dec:** 0 **Totals:** #### Total tolerance range **Key:** range **Agg:** sum **Format:** decimal #### Number of characteristics **Key:** mic **Agg:** count **Format:** integer **Notes:** Qualitative characteristics have no numeric limits, so leave limits at zero. The worksheet is a planning and cleansing tool. The load itself (LSMW, BAPI, migration cockpit or recording of QS21) must match field names in your release. ## Content **Intro:** Master inspection characteristics (MICs) are the reusable measurement definitions in SAP QM. Collecting and cleansing them in a worksheet before the load avoids duplicates and bad tolerances. **Sections:** #### How to use the worksheet **Body:** Add one row per characteristic and plant. Enter a short name, whether it is quantitative or qualitative, the unit, the limits and the number of decimals. The worksheet calculates the tolerance range and the target (midpoint) so you can spot reversed or implausible limits straight away. Export to Excel or CSV and hand the file to the person doing the data load. #### What a MIC contains in SAP QM **Body:** A master inspection characteristic is created in QS21 and holds the descriptive text, the inspection method, the unit and the tolerance defaults. A quantitative characteristic records measured values. A qualitative one records an accept or reject outcome, often with a code catalog. MICs are then referenced from inspection plans so you maintain the definition once and reuse it across plans. Versions and status control who can use a MIC. **Bullets:** - Quantitative: measured value with limits, unit and decimals - Qualitative: coded result with a catalog of codes - Plant specific or shared across plants through a controlling area - Version and status control the lifecycle of the definition #### Common mistakes **Body:** Data loads fail or create trouble for several reasons. Limits can be reversed, units may not match the base unit of the method, decimals can be too few for the resolution of the instrument, or names can break the naming rule. Another mistake is creating a MIC per plan instead of a reusable one, which makes later changes a big project. **Bullets:** - Lower limit larger than upper limit - Decimals fewer than the measuring instrument resolution - Different spelling of the same MIC across plants - Qualitative characteristics loaded without a code catalog **Cta:** Netray can help clean legacy quality data and map it to SAP QM structures before migration. Tell us about your source system if you would like help. **Faq:** #### Which transaction creates master inspection characteristics? **Answer:** QS21 creates a master inspection characteristic, QS22 changes it and QS23 displays it. Bulk loads normally use a migration tool or a recording, depending on your release and skills. #### Can I load MICs with LSMW? **Answer:** Many projects do load MICs with LSMW recordings or the migration cockpit, but you should check what is supported for your release. Always do a test load and compare the result with QS23. #### What is the difference between a MIC and a characteristic in a plan? **Answer:** A MIC is a reusable definition. The characteristic in an inspection plan references a MIC and can override some values, such as limits, for the specific plan. #### Why does the worksheet calculate a target? **Answer:** The midpoint helps spot errors in limits. Your plan target may differ from the midpoint for one sided tolerances, so treat the calculated target as a check only. ## Search terms sap master inspection characteristic, sap mic upload, sap qs21 master inspection characteristic, sap mic template excel, sap qm data migration mic, sap quantitative characteristic, sap qualitative characteristic, sap mic lsmw --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json