Purpose

The purpose of this document is to define the conversion approach to create 1057 - QM Master Inspection Characteristics in S/4 HANA.

Master Inspection Characteristics are a fundamental element of SAP Quality Management (QM) used to define the parameters, specifications, and methods for quality inspections. MICs provide a standardized definition of what is to be inspected and how it should be measured, ensuring uniformity and consistency across inspection plans and quality processes. MICs can be maintained as Quantitative (numeric specifications such as measurement ranges and tolerances) or Qualitative (descriptive specifications such as defect classes or codes).

In SAP S/4HANA, the structure and usage of MICs remain consistent with SAP ECC, typically defined by key combinations such as plant, characteristic name, and characteristic type. MICs may include additional settings such as selected sets for qualitative characteristics, catalog assignments, default inspection methods, target values, upper and lower specification limits, and sampling procedures.

In SAP ECC, aside from the standard MIC structures, there may be additional configurations, such as plant-independent characteristics, characteristics linked to custom catalogs, or MICs with special control indicators and custom fields. Certain legacy systems may also include MICs with obsolete catalog references, inactive units of measure, or unused selected sets (pending MDS review), which must be validated before conversion.

This conversion aims to migrate active and relevant MIC records, along with their associated control indicators, selected sets, catalog assignments, default inspection methods, and specification limits, from existing ECC systems into S/4HANA. The migration will apply the required transformation logic using Syniti as the data migration and transformation platform. The converted records will be loaded into the target S/4HANA system using standard SAP mechanisms such as BAPIs (e.g., BAPI_INSPOPER_RECORDRESULTS for linking to inspection operations, or QS21 transaction for creation), IDOCs, or direct table loads where applicable, ensuring data integrity, compliance, and reusability across inspection plans.

This Conversion Specification does not include the WPX system (CUI Objects).


Conversion Scope

The scope of this document covers the approach for converting active Conversion Specification CNV-1057 Master Inspection Characteristic (MIC) from Legacy Source Systems into S/4HANA following the Master Inspection Characteristic Master Data Design Standard MDS-1057

From the current landscape, MIC data exists in legacy quality management systems (e.g., PF2 and WP2). Harmonization and validation are required to ensure accurate and consolidated MIC data in S/4HANA. While PF2 and WP2 serve as source systems, extensive mapping and transformation logic will be applied to ensure clean, relevant, and standardized data is migrated.

  1. Active MIC records that meet the Material Relevancy Criteria (aligned with valid Material Master Basic Data View, QM ViewQM Inspection Plan and Master Recipe) and are used in valid inspection processes within the last four (4) years.

  2. MICs without deletion flags, ensuring only valid and relevant characteristics are migrated.

  3. MICs assigned to in-scope plants or inspection plans based on the To-Be Plant Mapping.

  4. MICs linked to valid inspection types and usage (e.g., 01, 04, 09) to ensure functional integration with quality processes in the target system.

  5. MICs with valid catalog assignments (e.g., defect class, code group, selected set) and valid control indicators.

  6. MICs referenced in sampling procedures or inspection plans to ensure inspection process continuity in the target environment.

The data from legacy system excludes:

  1. Inactive or obsolete MICs that are not used in inspection plans or linked processes within the last four (4) years.

  2. MICs marked for deletion in the legacy system.

  3. MICs assigned to plants that are out of scope, based on the To-Be Plant Mapping in Enterprise Structure Catalog worksheet "30. Plants"

  4. Invalid or incomplete catalog assignments, missing required control indicators, or unsupported settings in S/4HANA.

Relevancy rule

  1. Material/Plant with history and active usage
    Materials must be defined at both global level (MARA) and plant level (MARC) with valid status and assignment to active in-scope plants. Only materials with active QM View are considered relevant. In addition, QM View relevancy must aligned with Material Master Basic Views (CNV-2019) to ensure consistent dependency with MARA-level relevancy. Usage confirmation may also include inspection lots (QALS) within the last four (4) years where applicable.
  2. Active Inspection Types
    Only materials with at least one valid and active inspection type (e.g., 01, 02, 03, 04, 05, 06, 08, 10, 11, 12, 17) maintained in QMAT and linked to relevant plants will be considered in scope.
  3. Inspection Setup with Valid Usage 
    Inspection types must be relevant to in-scope Syensqo business processes (e.g., Goods Receipt, In-Process, Delivery). Materials without any active inspection usage in the last four (4) years will be excluded.
  4. Plant-Specific Validation
    Materials with QM View will be checked against active plant mappings (To-Be Plant Definition) to ensure that only valid, active plants are considered for migration.

Material/Plant active with four (4) years inspection usage history ➝ validates active QM View (QMAT) with at least one valid inspection type (e.g., 01, 04, 09) ➝ confirms Control Key, Certificate Type, and Q-Score alignment with configuration ➝ ensures accurate integration with incoming inspection and quality processes in S/4HANA.

Plant Merging

Plants will be harmonized based on the To-Be Plant Mapping. As some legacy plants will be merged into one target plant, QM Views will be reassigned accordingly to ensure data consistency and alignment with the new plant structure in SAP S/4HANA.


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2 & WP2Master Inspection Characteristic will be extracted from PF2 and WP2

PF2 =10145 records

WP2 = 41526 records

S/4 HANA


11722 records

Additional Information

Multi-language Requirement

Master Inspection Characteristic description will be maintained in English by default.

Since multi-language support is available for Master Inspection Characteristic, users logging in with a different language will see the description displayed in their logon language, provided that the corresponding language key has been maintained in the on Characteristic.

Document Management

Not applicable

Legal Requirement

Not applicable

Special Requirements

Not applicable


Target Design

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirement
QPMKGUELTIGABGUELTIGABValid-from DateDATS8R
QPMKLOEKZLOEKZStatus of Master RecordCHAR1

R (Migrate only status 1 and 2)


1 = Being Created

2 = Released

3 = Can No Longer Be Used

4 = Deletion Flag

5 = Archive

QPMKMASSEINHSWMASSEINHSWUnit of Measurement in Which Quantitative Data Is StoredUNIT3C
QPMKMKMNRQMERNKRMaster Inspection Characteristic (MIC)CHAR18R
QPMKSOLLWERTSOLLWERTTarget Value for a Quantitative CharacteristicDEC15C
QPMKSTELLENSTELLENNumber of Places to the Right of a Decimal Point (Accuracy)NUMC2C
QPMKSTEUERKZSTEUERKZCntrl Indicator String for Insp. Char./Master Insp. Char.CHAR30R : Correspond to control data. System concatenate the data pulled from TQ27 customizing table or changed by the user --> Definition in Appendix tab
QPMKTOLERANZOBTOLERANZOBUpper Specification LimitDEC15C
QPMKTOLERANZSLTOLERANZSLTolerance KeyCHAR3C
QPMKTOLERANZUNTOLERANZUNLower Specification LimitDEC15C
QPMKVERSIONVERSIONMIC VersionNUMC6S
QPMKWERKSWERKSPlant for Master Inspection CharacteristicCHAR4R
QPMKZAEHLERQZAEHLERPlant for Master Inspection Characteristic (Plant Specific MIC)CHAR4R
QPMTZAEHLERZAEHLERPlant for Master Inspection CharacteristicNUM4R
QPMTMKMNRMKMNRMaster Inspection CharacteristicCHAR8R
QPMTVERSIONVERSIONVersion Number of Inspection MethodCHAR6S
QPMTSPRASSPRASLanguage KeyCHAR2R
QPMKCODE9UCODE9UDefect Code for Rejection at Lower Specification LimitCHAR8
If defect indicator and lower specification limit is set in QPMK-STEUERKZ and business required to maintain a defect catalog for the lower tolerance defect than this field need to be populated
Value can be : Copy from the current system or a data enrichment or can be a blank.
QPMKCODEGR9OCODEGR9ODefect Code Group for Rejection at Upper ToleranceCHAR8

C

If defect indicator and upper specification limit is set in QPMK-STEUERKZ and business required to maintain a defect catalog for the upper tolerance defect than this field need to be populated

Value can be : Copy from the current system or a data enrichment or can be a blank.

QPMKCODE9OCODE9ODefect Code for Rejection at Upper Specification LimitCHAR8

C

If defect indicator and upper specification limit is set in QPMK-STEUERKZ and business required to maintain a defect catalog for the upper tolerance defect than this field need to be populated

Value can be : Copy from the current system or a data enrichment or can be a blank.

QPMKATINNATINNInternal characteristicNUMC10S
QPMKEEANTVERFEEANTVERFFraction CalculationCHAR1NU
QPMKCODEGRQUALCODEGRQUALDefect Code Group for General RejectionCHAR8

C

If defect indicator and upper specification limit is set in QPMK-STEUERKZ and business required to maintain a defect catalog for the upper tolerance defect than this field need to be populated

Value can be : Copy from the current system or a data enrichment or can be a blank.

QPMKCODEQUALCODEQUALDefect Code for Rejection: GeneralCHAR8

C

If defect indicator and upper specification limit is set in QPMK-STEUERKZ and business required to maintain a defect catalog for the upper tolerance defect than this field need to be populated

Value can be : Copy from the current system or a data enrichment or can be a blank.

QPMKDUMMY10DUMMY10Spec IDCHAR10C
QPMKDUMMY20DUMMY20SpecCHAR20C
QPMKDUMMY40DUMMY40Text Line for Additional InformationCHAR40C
QPMKSORTFELDSORTFELDSearch FieldCHAR20R
QPMKLSPERLSPERData Record Is UsedCHAR1S
QPMKKONSISTENTKONSISTENTCopy Model/Reference CharacteristicCHAR1R : Empty is a valid value
QPMKAUTORAUTORName of User Who Created the Data RecordCHAR12S
QPMKDATESDATESSystem Date on Which Data Record Was CreatedDATS8S
QPMKAEAUTAEAUTName of User Who Last Changed Data RecordCHAR12S
QPMKDATAEDATAESystem Date on Which Data Record Was ChangedDATS8S
QPMKCHANGEDDATETIMECHANGEDDATETIMEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)CHAR14S
QPMKMERKGEWMERKGEWWeighting of CharacteristicDEC3

C (Empty is a valid value)

Value can be : Copy from the current system or a data enrichment or can be a blank.

Accepted values as per 10/2025 are : 

  • 01
  • 02
  • 03
  • 04
  • 05
  • 91
  • 92
  • 93
QPMKPRFQLPRFQLInspector QualificationCHAR3C
QPMKQAUTHQAUTHAuthorization Group QM Master DataCHAR4C
QPMKPLAUSIOBENPLAUSIOBENUpper Plausibility LimitDEC15C
QPMKPLAUSIUNTEPLAUSIUNTELower Plausibility LimitDEC15C
QPMKTOLERWEIOBTOLERWEIOBChange to Upper Specification LimitCHAR1C
QPMKTOLERWEIUNTOLERWEIUNChange to Lower Specification LimitCHAR1C
QPMKTOLERWABTOLERWABDate from Which the Tolerance Change Is ValidDATS8C
QPMKTOLERWBISTOLERWBISDate Until Which the Tolerance Change Is ValidDATS8C
QPMKCODEGR9UCODEGR9UDefect Code Group for Rejection at Lower ToleranceCHAR8

C

If defect indicator and lower secification limit is set in QPMK-STEUERKZ and business requiered to maintain a defect catalog for the lower tolerance defact than this field need to be populated
Value can be : Copy from the current system or a data enrichment or can be a blank.

QPMKGRENZEOB1GRENZEOB1First Upper Specification LimitDEC15C
QPMKGRENZEUN1GRENZEUN1First Lower Specification LimitDEC15C
QPMKGRENZEOB2GRENZEOB2Second Upper Specification LimitDEC15C
QPMKGRENZEUN2GRENZEUN2Second Lower Specification LimitDEC15C
QPMTKURZTEXTKURZTEXTShort Text for MICCHAR40R
STXHTDOBJECTTDOBJECTTexts: application objectCHAR10S : Always "QPMERKMAL"
STXHTDNAMETDNAMENameCHAR70S : Link with MIC
STXHTDIDTDIDText IDCHAR4S : Always "QPMT"
STXHTDSPRASTDSPRASLanguage KeyLANG1S
STXHTDTITLETDTITLETitle in dialog boxCHAR20S
STXHTDFRELESTDFRELESReleaseCHAR4S
STXHTDFUSERTDFUSERCreated byCHAR12S
STXHTDFDATETDFDATEDate createdDATS8S
STXHTDFTIMETDFTIMETime CreatedTIMS6S
STXHTDLRELESTDLRELESLast Changed in ReleaseCHAR4S
STXHTDLUSERTDLUSERLast changed byCHAR12S
STXHTDLTIMETDLTIMELast Changed AtTIMS6S
STXHTDVERSIONTDVERSIONVersionCHAR4S
STXHTDSTYLETDSTYLEStyle NameCHAR8S
STXHTDFORMTDFORMForm nameCHAR10S
STXHTDHYPHENATTDHYPHENATHyphenation ActiveCHAR1S
STXHTDTRANSTATTDTRANSTATTranslation statusCHAR1S
STXHTDOSPRASTDOSPRASOriginal languageLANG1S
STXHTDMACODE1TDMACODE1Short Title 1CHAR20S
STXHTDMACODE2TDMACODE2Short Title 2CHAR20S
STXHTDTXTLINESTDTXTLINESNumber of Text Lines in Line TableNUMC5S
STXHTDREFTDREFReference textCHAR70S
STXHTDREFNAMETDREFNAMEName of Referenced TextCHAR70S
STXHTDREFIDTDREFIDID of Referenced TextCHAR4S
STXHTDTEXTTYPETDTEXTTYPESAPscript: Format of TextCHAR1S
STXHTDCOMPRESSTDCOMPRESSSAPscript: Text is compressedCHAR1S
STXHLOGSYSLOGSYSLogical systemCHAR10S
STXHRELIDRELIDCHAR02 data elementCHAR2S
STXLTDOBJECTTDOBJECTText objectCHAR10S : Always "QPMERKMAL"
STXLTDNAMETDNAMEText nameCHAR70S : Link with MIC
STXLTDIDTDIDText IDCHAR4S : Always "QPMT"
STXLTDSPRASTDSPRASLanguageLANG1S
STXLSRTF2SRTF2BIN1 data element foRAW2S
STXLCLUSTRCLUSTRBIN2 data element foRAW2S
STXLCLUSTDCLUSTDDataRAW255S : Correspond to the long text
STXH TDLDATETDLDATEChanged OnDATS8S
STXH TDREFOBJTDREFOBJObject of Referenced TextCHAR10S
STXH TDOCLASSTDOCLASSSAPscript: Object ClassCHAR2S


Data Cleansing

All data cleansing activities must be performed in the source systems (e.g., PF2, WP2) wherever possible, following the rules and criteria defined in this document. The objective is to ensure that only valid, active, and relevant master data is migrated to S/4HANA, while obsolete, redundant, or inconsistent records are excluded.

If certain data cleansing activities cannot be executed directly in the source systems due to system limitations, they may be managed externally (e.g., using Syniti Migrate, 3rd Party Vendor tools, or DCT processes). In such cases, proper documentation of the cleansing activity must be maintained and appended to this deliverable to support review, validation, and sign-off by stakeholders.

IDCriticalityError Message/Report DescriptionRuleOutputSource System
1057-001C1MIC not used in last 4 yearsAll MICs not referenced in any inspection plan (PLMK) or inspection lot in the last 4 years won’t be migrated.Active MICs used within last 4 yearsPF2/WP2
1057-002C1MIC flagged for deletionAll MICs with status ≠ 1 and 2 (QPMK-LOEKZ) won’t be migrated.Active MICs with status = 1 (Being Created) and 2 (Released)PF2/WP2
1057-003C1Duplicate MIC (and duplicate description)Identify all MICs with duplicate or similar descriptions (e.g., PH, PH1, PH3) and provide them for consolidation. Only one MIC should be selected for use.Business must decide which MIC will be retained as the representative MIC for data migration purpose.PF2/WP2



Conversion Process

The high-level process is represented by the diagram below:

The ETL (Extract, Transform, Load) process is a structured approach to data migration and management, ensuring high-quality data is seamlessly transferred across systems. Here’s a breakdown of its key components:

1. Extraction
The process begins with extracting metadata and raw data from source systems, such as Syensqo ECC system (i.e. WP2/PF2) periodically. The extracted data is then staged for transformation.


2. Transformation
Once extracted, the data undergoes cleansing, consolidation, and governance. This step ensures data integrity, consistency, and compliance with business rules. The transformation process includes:
- Data validation to remove inconsistencies.
- Standardization to align formats across datasets.
- Business rule application to refine data for operational use.


3. Loading
The transformed data is then loaded into the target S/4HANA system. 

image-2025-6-10_17-0-33.png

Data Privacy and Sensitivity

Not applicable


Extraction

Extract data from a source into Syniti Migrate. There are 2 possibilities:

  1. The data exists. Syniti Migrate connects to the source and loads the data into Syniti Migrate. There are 3 methods:
    1. Perform full data extraction from relevant tables in the source system(s).
    2. Perform extraction through the application layer.
    3. Only if Syniti Migrate; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
  2. The data does not exist (or cannot be converted from its current state).  The data is manually collected by the business directly in Syniti Migrate. This is to be conducted using DCT (Data Collection Template) in Syniti Migrate.

The agreed relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target Loads

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible
Extraction Scope Definition- Identify the source systems and databases involved.
- Define the data objects (tables, fields, records) to be extracted.
- Establish business rules for data selection.

Syniti / LTC Data team

Extraction Methodology- Specify the extraction approach (full, incremental, or delta extraction).
- Determine the tools and technologies used.
- Define data filtering criteria to exclude irrelevant records.
Syniti 
Extraction Execution Plan- Establish execution timelines and batch processing schedules.
- Assign responsibilities for extraction monitoring.
- Document dependencies on other migration tasks.
Syniti
Data Quality and Validation- Define error handling mechanisms for extraction failures.Syniti


Selection Screen


Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
Not applicable




Data Collection Template (DCT)

A Target-Ready Data Collection Template will be created for all required fields in the SAP QM - Master Inspection Characteristics, except for fields that require transformation in accordance with the defined transformation rules. Each template will follow the structure and format required by the target S/4HANA Quality Management.

  1. Master Inspection Characteristic - Basic Data
    Field NameField DescriptionData TypeLengthRequirementRuleMapping
    QPMK-ZAEHLERPlant for Master Inspection CharacteristicNUM4RequiredMandatory technical key for MIC per plantCopy from DCT
    QPMK-MKMNRMaster Inspection CharacteristicCHAR8RequiredMust be unique per plantCopy from DCT
    QPMK-WERKSPlant for Master Inspection CharacteristicNUM4RequiredMust exist in plant mapping; must be active plantCopy from DCT
    QPMK-VERSIONVersion Number of Master Inspection CharacteristicsCHAR6System generatedSystem generated valueSystem-generated
    QPMK-GUELTIGABValid-From DateDATE8RequiredDefault = creation date unless specifiedCopy from DCT
    QPMK-SORTFELDSearch FieldCHAR20RequiredOptional (Used for search help)Copy from DCT
    QPMK-LOEKZStatus of Master RecordCHAR1RequiredValue as per below:
    1 = Being Created
    2 = Released
    3 = Can No Longer Be Used
    4 = Deletion Flag
    5 = Archived
    Copy from DCT
    QPMT-ZAEHLERPlant for Master Inspection CharacteristicNUM4RequiredMandatory technical key for MIC per plantCopy from DCT
    QPMT-MKMNRMaster Inspection CharacteristicCHAR8RequiredMust be unique per plantCopy from DCT
    QPMT-KURZTEXTShort TextCHAR40RequiredShort Text for MICCopy from DCT
    QPMT-VERSIONVersion Number of Inspection MethodsCHAR6System generatedSystem generated valueSystem-generated
    QPMT-SPRASLanguage KeyCHAR2RequiredDefault = EN unless multilingualCopy from DCT
    QPMK-LSPERData Record Is UsedCHAR1ConditionalCan be used to link MIC to a Batch CharacteristicCopy from DCT
    QPMK-KONSISTENTCopy Model / Reference CharacteristicCHAR1ConditionalValue as per below:
    Blank = Incomplete Copy Model (system default value)
    1 = Complete Copy Model
    X = Reference Characteristics
    Copy from DCT
    QPMK-STEUERKZControl Indicator StringCHAR30RequiredDerived from QS27 customizingCopy from DCT
    QPMK-MERKGEWWeighting of CharacteristicNUM2ConditionalValue as per below:
    01 =  Critical Characteristic
    02 = Major Characteristic A
    03 = Major Characteristic B
    04 = Minor Characteristic A
    05 = Minor Characteristic B
    91 = Critical Characteristic
    92 = Major Characteristic
    93 = Minor Characteristic
    Copy from DCT
    QPMK-PRFQLInspector QualificationCHAR8ConditionalValidate against qualification list (if used)Copy from DCT
    QPMK-DUMMY10Spec IDCHAR20ConditionalCopy from legacy or enrichment or blankCopy from DCT
    QPMK-DUMMY20SpecCHAR40ConditionalCopy from legacy or enrichment or blankCopy from DCT
    QPMK-DUMMY40Text Line for Additional InformationCHAR40ConditionalCopy from legacy or enrichment or blankCopy from DCT
    QPMK-QAUTHAuthorization Group QM Master DataCHAR4ConditionalOptional; controls access to QM master dataCopy from DCT
    QPMK-TOLERANZSLTolerance KeyCHAR4ConditionalPopulate only if tolerance data is maintainedCopy from DCT
    QPMK-STELLENDecimal PlacesNUM2ConditionalRequired for quantitative MICCopy from DCT
    QPMK-MASSEINSHWUnit of MeasurementCHAR3ConditionalRequired for quantitative MIC; must exist in T006Copy from DCT
    QPMK-SOLLWERTTarget ValueNUM13ConditionalOptional; only if maintained in legacyCopy from DCT
    QPMK-TOLERANZOBUpper Specification LimitNUM13ConditionalOptional; only if maintainedCopy from DCT
    QPMK-TOLERANZUNLower Specification LimitNUM13ConditionalOptional; only if maintainedCopy from DCT
    QPMK-GRENZEOB1First Upper Specification LimitNUM13ConditionalOptionalCopy from DCT
    QPMK-GRENZEUN1First Lower Specification LimitNUM13ConditionalOptionalCopy from DCT
    QPMK-GRENZEOB2Second Upper Specification LimitNUM13ConditionalOptionalCopy from DCT
    QPMK-GRENZEUN2Second Lower Specification LimitNUM13ConditionalOptionalCopy from DCT
    QPMK-PLAUSIOBENUpper Plausibility LimitNUM13ConditionalOptionalCopy from DCT
    QPMK-PLAUSIUNTELower Plausibility LimitNUM13ConditionalOptionalCopy from DCT
    QPMK-TOLERWEIOBChange to Upper Spec LimitCHAR13ConditionalOptionalCopy from DCT
    QPMK-TOLERWEIUNChange to Lower Spec LimitCHAR13ConditionalOptionalCopy from DCT
    QPMK-TOLERWABDate From Which Tolerance Change is ValidCHAR8ConditionalOptionalCopy from DCT
    QPMK-TOLERWBISDate Until Which Tolerance Change is ValidCHAR8ConditionalOptionalCopy from DCT
    QPMK-CODEGRUDefect Code Group for Rejection at Lower ToleranceCHAR8ConditionalRequired only if defect indicator in QPMK-STEUERKZ requires itCopy from DCT
    QPMK-CODEGUDefect Code for Rejection at Lower Spec LimitCHAR8ConditionalRequired only if defect indicator in QPMK-STEUERKZ requires itCopy from DCT
    QPMK-CODEGR90Defect Code Group for Rejection at Upper ToleranceCHAR8ConditionalRequired only if defect indicator in QPMK-STEUERKZ requires itCopy from DCT
    QPMK-CODEGQUALDefect Code Group for General RejectionCHAR8ConditionalRequired only if defect indicator in QPMK-STEUERKZ requires itCopy from DCT
    QPMK-CODEQUALDefect Code for Rejection: GeneralCHAR4ConditionalRequired only if defect indicator in QPMK-STEUERKZ requires itCopy from DCT
  2. Master Inspection Characteristic - Long Text
    Field NameField DescriptionData TypeLengthRequirementRuleMapping
    STXH-TDOBJECTText ObjectCHAR10RequiredAlways = QPMERKMALCopy from DCT
    STXH-TDNAMENameCHAR70RequiredLink with MIC (derived from MIC key)Copy from DCT
    STXH-TDIDText IDCHAR4RequiredAlways = QPMTCopy from DCT
    STXH-TDSPRASLanguage KeyCHAR1RequiredDefault = EN unless multilingualCopy from DCT
    STXL-CLUSTDText Cluster DataCHAR2000ConditionalMust contain MIC long text linesCopy from DCT
    Note:

    Please check the link attached for Layout:








 

Extraction Dependencies

Item #Step DescriptionTeam Responsible
1

Source System Availability

  • Ensure that the source database or application is accessible.
  • Confirm that necessary credentials and permissions are granted

Syensqo IT

2

Data Structure

  • Identify relationships between tables, views, and stored procedures.

Syniti

3

Referential Integrity

  • Ensure dependent records are extracted together.

Syniti

4

Extraction Methodology

  • Define whether extraction is full, incremental, or delta-based.
  • Establish batch processing schedules for large datasets.

Syniti

5

Performance and Scalability Considerations

  • Optimize extraction queries to prevent system overload.
  • Ensure network bandwidth supports data transfer volumes.

Syniti

6

Security and Compliance

  • Adhere to regulatory standards for sensitive information if applicable

Syniti


Transformation

The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow Syniti Migrate to make the data Target ready:

  1. Perform value mapping and data transformation rules.
    1. Legacy values are mapped to the to-be values (this could include a default value)
    2. Values are transformed according to the rules defined in Syniti Migrate
  2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

Transformation Run Sheet

Item #Step DescriptionTeam Responsible
1Obtain DCT Sign-off from BusinessSyWay Data Team
2<Add steps from Syniti Migrate here>SyWay Data Team
3Review and Validate Error and Preload ReportsSyWay Data Team
4Generate Load FilesSyWay Data Team


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2, WP2QPMKGUELTIGABValid-from DateS4 HANAQPMKGUELTIGABValid-from DateUse S/4 Start-from Date
2PF2, WP2QPMKLOEKZStatus of Master RecordS4 HANAQPMKLOEKZStatus of Master RecordCopy from legacy. Migrate both status 1 (Being Created) and status 2 (Released) records
3PF2, WP2QPMKVERSIONVersion of Master Inspection CharacteristicS4 HANAQPMKVERSIONVersion of Master Inspection CharacteristicSystem-generated value
4PF2, WP2QPMKMASSEINHSWUnit of Measurement in Which Quantitative Data Is StoredS4 HANAQPMKMASSEINHSWUnit of Measurement in Which Quantitative Data Is StoredXref (value mapping) from master data T006
5PF2, WP2QPMKMKMNRMaster Inspection Characteristic (MIC)S4 HANAQPMKMKMNRMaster Inspection Characteristic (MIC)Copy from legacy
6PF2, WP2QPMKSOLLWERTTarget Value for a Quantitative CharacteristicS4 HANAQPMKSOLLWERTTarget Value for a Quantitative CharacteristicCopy from legacy for quantitative MIC; blank for qualitative
7PF2, WP2QPMKSTELLENNumber of Places to the Right of a Decimal Point (Accuracy)S4 HANAQPMKSTELLENNumber of Places to the Right of a Decimal Point (Accuracy)Copy from legacy for quantitative MIC. Default value as 0 (blank) for qualitative. 
8PF2, WP2QPMKSTEUERKZCntrl Indicator String for Insp. Char./Master Insp. Char.S4 HANAQPMKSTEUERKZCntrl Indicator String for Insp. Char./Master Insp. Char.Copy from legacy. Validate against S/4 customizing (only permitted flags).
9PF2, WP2QPMKTOLERANZOBUpper Specification LimitS4 HANAQPMKTOLERANZOBUpper Specification LimitCopy from legacy. Numeric check; ensure upper ≥ lower when both present.
10PF2, WP2QPMKTOLERANZSLTolerance KeyS4 HANAQPMKTOLERANZSLTolerance KeyCopy from legacy. Must exist in S/4 target customizing
11PF2, WP2QPMKTOLERANZUNLower Specification LimitS4 HANAQPMKTOLERANZUNLower Specification LimitCopy from legacy. Numeric check; ensure lower ≤ upper when both present.
12PF2, WP2QPMKWERKSPlant for Master Inspection CharacteristicS4 HANAQPMKWERKSPlant for Master Inspection CharacteristicXref (value mapping) from To-Be Plant Mapping
13PF2, WP2QPMKZAEHLERPlant for Master Inspection Characteristic (Plant Specific MIC)S4 HANAQPMKZAEHLERPlant for Master Inspection Characteristic (Plant Specific MIC)Copy from legacy. Plant must be exist in Material Relevancy Rules.
14PF2, WP2QPMTZAEHLERPlant for Master Inspection CharacteristicS4 HANAQPMTZAEHLERPlant for Master Inspection CharacteristicCopy from legacy. Plant must be exist in Material Relevancy Rules.
15PF2, WP2QPMTMKMNRMaster Inspection Characteristic (MIC)S4 HANAQPMTMKMNRMaster Inspection Characteristic (MIC)Copy from legacy
16PF2, WP2QPMTKURZTEXTShort Text for MICS4 HANAQPMTKURZTEXTShort Text for MICCopy from legacy
17PF2, WP2QPMTVERSIONVersion number of Inspection MethodS4 HANAQPMTVERSIONVersion number of Inspection MethodCopy from legacy
18PF2, WP2QPMTSPRASLanguage KeyS4 HANAQPMTSPRASLanguage KeyDefault = EN unless multilingual
19PF2, WP2QPMKCODE9UDefect Code for Rejection at Lower Specification LimitS4 HANAQPMKCODE9UDefect Code for Rejection at Lower Specification LimitCopy from legacy. Catalog/code must exist in target.
20PF2, WP2QPMKCODEGR9ODefect Code Group for Rejection at Upper ToleranceS4 HANAQPMKCODEGR9ODefect Code Group for Rejection at Upper ToleranceCopy from legacy. Target catalog group must exist.
21PF2, WP2QPMKCODE9ODefect Code for Rejection at Upper Specification LimitS4 HANAQPMKCODE9ODefect Code for Rejection at Upper Specification LimitCopy from legacy. Ensure code is valid in target.
22PF2, WP2QPMKCODEGRQUALDefect Code Group for General RejectionS4 HANAQPMKCODEGRQUALDefect Code Group for General RejectionCopy from legacy. Target catalog group must exist.
23PF2, WP2QPMKCODEQUALDefect Code for Rejection: GeneralS4 HANAQPMKCODEQUALDefect Code for Rejection: GeneralCopy from legacy. arget code must exist.
24PF2, WP2QPMKDUMMY10Spec IDS4 HANAQPMKDUMMY10Spec IDCopy only if value exists (optional). Leave blank otherwise.
25PF2, WP2QPMKDUMMY20SpecS4 HANAQPMKDUMMY20SpecCopy only if value exists (optional). Leave blank otherwise.
26PF2, WP2QPMKDUMMY40Text Line for Additional InformationS4 HANAQPMKDUMMY40Text Line for Additional InformationCopy only if value exists (optional). Leave blank otherwise.
27PF2, WP2QPMKSORTFELDSearch FieldS4 HANAQPMKSORTFELDSearch FieldCopy from legacy
28PF2, WP2QPMKKONSISTENTCopy Model/Reference CharacteristicS4 HANAQPMKKONSISTENTCopy Model/Reference CharacteristicCopy from legacy
29PF2, WP2QPMKMERKGEWWeighting of CharacteristicS4 HANAQPMKMERKGEWWeighting of CharacteristicCopy from legacy
30PF2, WP2QPMKPRFQLInspector QualificationS4 HANAQPMKPRFQLInspector QualificationCopy from legacy
31PF2, WP2QPMKQAUTHAuthorization Group QM Master DataS4 HANAQPMKQAUTHAuthorization Group QM Master DataCopy from legacy. Ensure target auth group exists
32PF2, WP2QPMKPLAUSIOBENUpper Plausibility LimitS4 HANAQPMKPLAUSIOBENUpper Plausibility LimitCopy from legacy. Numeric check; only relevant to quantitative MICs.
33PF2, WP2QPMKPLAUSIUNTELower Plausibility LimitS4 HANAQPMKPLAUSIUNTELower Plausibility LimitCopy from legacy. Numeric check; only relevant to quantitative MICs.
34PF2, WP2QPMKTOLERWEIOBChange to Upper Specification LimitS4 HANAQPMKTOLERWEIOBChange to Upper Specification LimitCopy from legacy
35PF2, WP2QPMKTOLERWEIUNChange to Lower Specification LimitS4 HANAQPMKTOLERWEIUNChange to Lower Specification LimitCopy from legacy
36PF2, WP2QPMKTOLERWABDate from Which the Tolerance Change Is ValidS4 HANAQPMKTOLERWABDate from Which the Tolerance Change Is ValidCopy from legacy. Validate as a real date; must be ≤ “valid-to”.
37PF2, WP2QPMKTOLERWBISDate Until Which the Tolerance Change Is ValidS4 HANAQPMKTOLERWBISDate Until Which the Tolerance Change Is ValidCopy from legacy. Validate as a real date; must be ≥ “valid-from”.
38PF2, WP2QPMKCODEGR9UDefect Code Group for Rejection at Lower ToleranceS4 HANAQPMKCODEGR9UDefect Code Group for Rejection at Lower ToleranceCopy from legacy. Target group must exist.
39PF2, WP2QPMKGRENZEOB1First Upper Specification LimitS4 HANAQPMKGRENZEOB1First Upper Specification LimitCopy from legacy. Numeric; ensure UoM alignment
40PF2, WP2QPMKGRENZEUN1First Lower Specification LimitS4 HANAQPMKGRENZEUN1First Lower Specification LimitCopy from legacy. Numeric; check lower ≤ upper.
41PF2, WP2QPMKGRENZEOB2Second Upper Specification LimitS4 HANAQPMKGRENZEOB2Second Upper Specification LimitCopy from legacy
42PF2, WP2QPMKGRENZEUN2Second Lower Specification LimitS4 HANAQPMKGRENZEUN2Second Lower Specification LimitCopy from legacy
43PF2, WP2STXHTDOBJECTTexts: application objectS4 HANASTXHTDOBJECTTexts: application objectDefaulted to "QPMERKMAL"
44PF2, WP2STXHTDNAMENameS4 HANASTXHTDNAMENameLink with MIC
45PF2, WP2STXHTDIDText IDS4 HANASTXHTDIDText IDAlways "QPMT"
46PF2, WP2STXHTDSPRASLanguage KeyS4 HANASTXHTDSPRASLanguage KeyCopy from legacy
47PF2, WP2STXHTDTITLETitle in dialog boxS4 HANASTXHTDTITLETitle in dialog boxSystem-generated value
48PF2, WP2STXHTDFRELESReleaseS4 HANASTXHTDFRELESReleaseSystem-generated value
49PF2, WP2STXHTDFUSERCreated byS4 HANASTXHTDFUSERCreated bySystem-generated value
50PF2, WP2STXHTDFDATEDate createdS4 HANASTXHTDFDATEDate createdSystem-generated value
51PF2, WP2STXHTDFTIMETime CreatedS4 HANASTXHTDFTIMETime CreatedSystem-generated value
52PF2, WP2STXHTDLRELESLast Changed in ReleaseS4 HANASTXHTDLRELESLast Changed in ReleaseSystem-generated value
53PF2, WP2STXHTDLUSERLast changed byS4 HANASTXHTDLUSERLast changed bySystem-generated value
54PF2, WP2STXHTDLTIMELast Changed AtS4 HANASTXHTDLTIMELast Changed AtSystem-generated value
55PF2, WP2STXHTDVERSIONVersionS4 HANASTXHTDVERSIONVersionSystem-generated value
56PF2, WP2STXHTDSTYLEStyle NameS4 HANASTXHTDSTYLEStyle NameSystem-generated value
57PF2, WP2STXHTDFORMForm nameS4 HANASTXHTDFORMForm nameSystem-generated value
58PF2, WP2STXHTDHYPHENATHyphenation ActiveS4 HANASTXHTDHYPHENATHyphenation ActiveSystem-generated value
59PF2, WP2STXHTDTRANSTATTranslation statusS4 HANASTXHTDTRANSTATTranslation statusSystem-generated value
60PF2, WP2STXHTDOSPRASOriginal languageS4 HANASTXHTDOSPRASOriginal languageSystem-generated value
61PF2, WP2STXHTDMACODE1Short Title 1S4 HANASTXHTDMACODE1Short Title 1System-generated value
62PF2, WP2STXHTDMACODE2Short Title 2S4 HANASTXHTDMACODE2Short Title 2System-generated value
63PF2, WP2STXHTDTXTLINESNumber of Text Lines in Line TableS4 HANASTXHTDTXTLINESNumber of Text Lines in Line TableSystem-generated value
64PF2, WP2STXHTDREFReference textS4 HANASTXHTDREFReference textSystem-generated value
65PF2, WP2STXHTDREFNAMEName of Referenced TextS4 HANASTXHTDREFNAMEName of Referenced TextSystem-generated value
66PF2, WP2STXHTDREFIDID of Referenced TextS4 HANASTXHTDREFIDID of Referenced TextSystem-generated value
67PF2, WP2STXHTDTEXTTYPESAPscript: Format of TextS4 HANASTXHTDTEXTTYPESAPscript: Format of TextSystem-generated value
68PF2, WP2STXHTDCOMPRESSSAPscript: Text is compressedS4 HANASTXHTDCOMPRESSSAPscript: Text is compressedSystem-generated value
69PF2, WP2STXHLOGSYSLogical systemS4 HANASTXHLOGSYSLogical systemSystem-generated value
70PF2, WP2STXHRELIDCHAR02 data elementS4 HANASTXHRELIDCHAR02 data elementSystem-generated value
71PF2, WP2STXLTDOBJECTText objectS4 HANASTXLTDOBJECTText objectDefaulted to "QPMERKMAL"
72PF2, WP2STXLTDNAMEText nameS4 HANASTXLTDNAMEText nameLink with MIC
73PF2, WP2STXLTDIDText IDS4 HANASTXLTDIDText IDAlways "QPMT"
74PF2, WP2STXLTDSPRASLanguageS4 HANASTXLTDSPRASLanguageCopy from legacy
75PF2, WP2STXLSRTF2BIN1 data element foS4 HANASTXLSRTF2BIN1 data element foSystem-generated value
76PF2, WP2STXLCLUSTRBIN2 data element foS4 HANASTXLCLUSTRBIN2 data element foSystem-generated value
77PF2, WP2STXLCLUSTDDataS4 HANASTXLCLUSTDDataCopy from legacy
78PF2, WP2STXH TDLDATEChanged OnS4 HANASTXH TDLDATEChanged OnSystem-generated value
79PF2, WP2STXH TDREFOBJObject of Referenced TextS4 HANASTXH TDREFOBJObject of Referenced TextSystem-generated value
80PF2, WP2STXH TDOCLASSSAPscript: Object ClassS4 HANASTXH TDOCLASSSAPscript: Object ClassSystem-generated value


Transformation Mapping


Mapping Table NameMapping Table Description
PlantMapping of legacy Plants to new S/4HANA Plant codes according to To-Be Plant Mapping definition. Ensures characteristics are assigned to valid and active plants only.
Characteristic Name (MIC)Mapping of legacy Master Inspection Characteristic (QS21) names to new harmonized naming convention in S/4HANA, following corporate quality standards.
Characteristic TypeMapping of legacy Characteristic Type values (Quantitative / Qualitative) to target system domain values (QMTB-KZQUI).
Catalog TypeMapping of legacy Catalog Type to valid Catalog Type entries in configuration table TQ15 in S/4HANA.
Selected Set / Code GroupMapping of legacy Selected Set and Code Group to harmonized sets in target system (reference configuration table TQ15T). Ensures consistency of catalog-based inspection characteristics.
Unit of Measure (UoM)Mapping of legacy Units of Measure to ISO-compliant Units of Measure in S/4HANA (as defined in table T006).
Decimal PlacesMapping of legacy Decimal Place format to target format as per S/4HANA numeric precision standard (QPMK-ANZST / QPMK-STELL).
Target Value / Upper & Lower LimitConversion of legacy target, lower, and upper specification limits into harmonized decimal format consistent with target measurement system.
Characteristic GroupMapping of legacy characteristic groups (QPMK-MERKNR grouping) to harmonized groups in target system for standardized reporting and search.
Plant Authorization GroupMapping of legacy Authorization Groups (QPMK-BEGRU) to target Authorization Groups in S/4HANA (per configuration table TBRG).
Class / Class Type (Optional)Mapping of legacy class assignments (if MICs were linked to classes) to target class and class type configuration in S/4HANA.
Reference IndicatorMapping of legacy Reference Indicator values to target domain values ensuring correct reference linkage between global and plant-specific MICs.

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Ensure tables completenessSyniti
2Ensure all Transformation mappings are up to date.Syniti


Pre-Load Validation

Project Team

Completeness

TaskAction
Business validates the load fileSend the load file to the Business Representatives for all plants so they can review and validate the data.
Mock 1 test must occur beforehandThe 1st mock load (manual) must be executed before the actual load can take place.
Count before and afterReview and document the item counts in the Transformation Files before the load, and verify them again after the load.
Validation Reports


Accuracy

TaskAction
Conversion Accuracy

SyWay P2F-MFG Data Team to verify that all fields below meet pass the checks:

  1. Mandatory Fields
  2. Field and Value Mapping Correctness
  3. Null Checks
  4. Text Length Checks
Review Error ReportsReview and correct the errors.  Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data.

Business

Completeness

TaskAction
Verify Record CountBusiness Data Owner/s to verify that the total number of relevant records from the the system is equal to the total number of records in the Preload and Load Sheets.

Accuracy

TaskAction
Conversion AccuracyBusiness Data Owner/s to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules.


Load

The load process includes:

  1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
  2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation

Load Run Sheet

Item #Step DescriptionTeam Responsible

1

Ensure Pre-load sign-offs are obtained.

SyWay Data team

2

Go to the load tool and select the correct load Program.

SyWay Data team

3

Proceed with Data load.

SyWay Data team

4

Validate few records loaded by accessing standard transactions.

SyWay Data team

5

Generate the post load reports in the tool.

SyWay Data team

6

Log errors as defects, if any and address resolutions. Close defects.

SyWay Data team

7

Resolve defects by re-upload and re-generate post load reports if necessary.

SyWay Data team

8

Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off.

Business

9

Repeat steps 5 to 7 if necessary.

SyWay Data team


Load Phase and Dependencies

Pre-Cutover

Configuration

Item #Configuration Item
1T001W – Plants/Branches: Definition of plants where Master Inspection Characteristics are created and maintained.
2T006 – Units of Measurement: ISO-compliant UoM definitions to ensure consistency of quantitative inspection characteristics.
3TQ07A – Inspection Types: Configuration of valid inspection types used for assigning MICs in inspection plans or material QM view.
4TQ08 – Control Keys (QM): Definition of control keys for inspection processing, including in-process and final inspection controls.
5TQ09 – Usage Keys: Definition of usage keys to determine where inspection characteristics can be used (e.g., in inspection plans, material QM view).
6TQ15 – Catalog Types: Definition of catalog types for qualitative inspection characteristics (e.g., defect codes, result recording codes).
7TQ15T – Selected Sets & Code Groups: Configuration of selected sets and code groups used to classify qualitative MIC values.
8TBRG – Authorization Groups: Assignment of authorization groups controlling access and maintenance rights for MICs.
9TQ30 – Reference Indicators: Configuration of reference indicator usage for linking global and plant-specific MICs.
10TQ75 – Decimal Places & Format: Configuration of decimal places, number format, and rounding rules for quantitative MIC values.
11TCLA – Class Type (optional): Configuration of class type if MICs are linked to classification system (e.g., class type 023).
12TQ33 – Catalog Profile Assignment: Control of which catalog profiles are assigned to MICs for standardizing defect recording.
13TQ85 – Inspection Lot Origin: Configuration of inspection lot origin values that determine MIC usage in inspection processes.

Conversion Objects

Object #Preceding Object Conversion Approach
1064Sampling Procedure
1043Inspection Methods

Error Handling

Error TypeError DescriptionAction Taken
1Plant does not exist or not mapped in target systemVerify that the plant exists in the target system and mapping is correctly maintained. Reprocess once mapping is updated.
2UoM (Unit of Measure) not valid or not harmonizedEnsure that UoM is mapped correctly in T006 and harmonized with the target system. Correct invalid values in the collection template and reload.
3Catalog or Selected Set not found in target systemCheck if the required catalog and selected set are already migrated or configured in the target system. Migrate or create them before reprocessing.
4Characteristic code or description missingValidate source data completeness. Update missing mandatory fields (e.g., short text, characteristic ID) in the collection template.
5Duplicate inspection characteristic records for the same plantPerform deduplication and retain only the valid active characteristic in the collection file before loading.
6Invalid characteristic type or control indicatorsReview and correct control indicators (e.g., quantitative/qualitative flags, sampling procedures) to align with target system configuration.
7Authorization group or class type not maintained in target systemEnsure the required authorization group or class type is configured in the target system before reprocessing.
8Obsolete or marked-for-deletion characteristicsExclude these records from migration as per data cleansing rules.


Post-Load Validation

Project Team

Completeness

TaskAction
Verify CountSyWay P2F-MFG Data Team to verify the record count created in target S/4 HANA by accessing post load reports in dspMigrate or standard reports from S/4 HANA.

Accuracy

TaskAction
Verify LogsCheck if there is data that failed to load and perform the necessary actions (e.g. register as post load issue or attempt to load the record again, etc.).

Business

Completeness

TaskAction
Verify CountDownload Post Load Reports from dspMigrate and verify that the record count loaded in the target S/4 HANA is the same count as of the endorsed load file.

Accuracy

TaskAction
Conversion AccuracyVerify that the Material BOM data in target S/4 HANA were loaded correctly via DSP Migrate post load reports or standard reports from S/4 HANA.


Key Assumptions

  • Master Data Standard (MDS) is up to date as of the date of documenting this conversion approach and Master Inspection Characteristic data load.

  • Data cleansing activities have been completed to ensure only active, valid, and relevant Master Inspection Characteristics are migrated. Characteristics marked for deletion or obsolete records are excluded.

  • Required configuration elements such as Catalogs, Selected Sets, Code Groups, Control Indicators, and Authorization Groups are already in place in the target S/4HANA system prior to migration.

  • All Units of Measure (UoM) used in quantitative characteristics are harmonized between source and target systems to ensure data consistency during migration.

  • Plant master data and organizational mapping are completed prior to Master Inspection Characteristic load to ensure proper assignment.

  • Number ranges for characteristic identifiers are preconfigured in S/4HANA and internal numbering will be applied during migration unless otherwise specified.

  • Only fields required for QM inspection processing, quality planning, and execution are in scope for migration. Legacy-specific or unused fields will not be migrated.

  • Enrichment activities (such as missing control indicators, invalid UoM, or obsolete characteristics) are handled outside of the automated migration process and may require business sign-off.

  • Dependencies such as catalog entries, selected sets, and reference data are assumed to be loaded and validated prior to characteristic migration.

  • Any exceptions to these assumptions (e.g., manual updates to control indicators or special characteristic types) will be managed through a formal exception process.


Change log

Workflow history