Purpose

The purpose of this document is to define the conversion approach to create Conversion Specification Document CNV-2009 Material Master – QM View in S/4HANA.

The QM View in the Material Master contains quality-related settings that control how a material is handled in Quality Management processes. These settings include inspection types (e.g., goods receipt, in-process, delivery), quality control keys, certificate requirements, preferred inspection plans or material specifications, and the status of quality management activation for the material. Maintaining the QM View ensures that materials are consistently subjected to the correct inspection processes during procurement, production, and sales.

In SAP S/4HANA, the structure and usage of the Material Master QM View remain consistent with SAP ECC. The QM View is defined by material (MARA-MATNR), plant (MARC-WERKS), and the associated quality-related fields. These include inspection setup (QMAT), inspection types (QMAT-ART), active status, and assignment of task lists or material specifications.

In SAP ECC, aside from the standard fields, additional legacy configurations may exist, such as:

  • Materials with inactive or obsolete inspection types still marked in the QM View.
  • Materials assigned to inspection types without corresponding inspection plans or specifications.
  • Redundant or duplicate plant-level QM settings for the same material.
  • Materials with blocked or obsolete quality control keys.
    These cases will need to be validated and cleansed as part of the Master Data Services (MDS) process prior to migration.

This conversion aims to migrate active and relevant Material Master QM View data from existing ECC systems into S/4HANA by applying 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_OBJCL_CREATE or BAPI_MATERIAL_SAVEDATA), IDOCs, or direct table loads where applicable, ensuring that all materials in scope have consistent and accurate QM-related setup in the target system.

Conversion Scope

The scope of this document covers the approach for converting active Conversion Specification 2009 Material Master – QM View data from Legacy Source Systems into S/4HANA following the MDS-2009 Material Master QM View Design Standard.

From the current system landscape, Material Master QM View data exists separately in the legacy systems (PF2 and WP2), with potential discrepancies in both systems. Harmonization and validation are required to ensure accurate and consolidated data in S/4HANA. While PF2 and WP2 serve as source systems, extensive mapping and transformation logic will be necessary to produce properly formatted load templates in line with the target design.

The data from legacy system includes: Final relevancy rule pending MDS

  1. Active Material Master QM Views that are in use within the last three (3) years in inspection lots, quality certificates, or inspection plans.

  2. QM Views without Deletion Flag, i.e., not blocked or obsolete.

  3. QM Views assigned to plants that are in-scope for S/4HANA migration, based on the To-Be Plant Mapping.

  4. Materials with at least one valid inspection type (e.g., 01, 04, 09) configured and active in the QM View.

  5. Materials where control key, inspection setup, and certificate requirements are consistent with S/4HANA target design.

The data from legacy system excludes:

  1. Inactive QM Views for materials not used in inspection lots or quality processes for more than three (3) years.

  2. QM Views marked for deletion or with inspection types blocked in ECC.

  3. QM Views belonging to plants that are out of scope or deleted as per To-Be Plant Mapping.

  4. Obsolete inspection types or settings that are not supported in S/4HANA.

  5. Duplicate or conflicting QM Views for the same material/plant combination, where only one harmonized record should remain.

Relevancy rule

  1. Material/Plant with history and active production usage – Materials must be defined at global (MARA) and plant level (MARC) with valid status and assignment to active plants in scope.

  2. BOMs linked to active materials – Only BOMs associated with materials that have valid production usage (Usage = 1 “Production”) and are actively used in production within the last three (3) years will be considered.

  3. Production Versions referencing BOMs – Production Versions must exist and be valid, linking BOMs with corresponding Routings/Master Recipes at the plant level to ensure continuity of manufacturing execution.

  4. Component materials – All components within the BOM must be valid, active materials in the Material Master and not marked for deletion.

  5. Plant-specific validation – BOMs will be checked against active plant mappings (per To-Be Plant definition) to ensure only relevant BOMs are migrated.

Material/Plant Active with three years production usage history ➡ defines Active BOMs (Usage = 1 “Production”) by Plant ➡ validates Production Versions ➡ ensures accurate mapping of dependent Routings/Master Recipes.

Plant Merging

Plants will be harmonized based on the To-Be Plant Mapping. As some legacy plants will be merged into one target plant, BOMs will be reassigned accordingly. Plant transformation will be managed through a mapping table maintained in Syniti to ensure consistent alignment with the To-Be Plant structure.


List of source systems and approximate number of records

SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2/WP2

Material Master QM views will be extracted from source systems.

An initial extract of the relevant data will be provided in Google Sheet format to assist business in decision making on including any relevant data from Source Systems.

500,000S4 HANA400,000 After cleansing

Additional Information

Multi-language Requirement

Not applicable

Document Management

Not applicable

Legal Requirement

Not applicable

Special Requirements

Not applicable


Target Design

Inspection Plan strictly adheres to the Master Data Standard. The complete information of the tables and key fields that hold the Inspection Plan information follows the Master Data Standard document.

The technical design of the target for this conversion approach (pending MDS)

TableFieldData ElementField DescriptionData TypeLengthRequirement
MARCMATNRMATNRMaterial NumberCHAR18R
MARCWERKSWERKS_DPlantCHAR4R
MARCQMATVQMATVQM Control Key (Material Active in QM)CHAR1R
QMATARTARTInspection Setup IndicatorCHAR1R
QMATARTINSPARTINSPInspection TypeCHAR4R
QMATAKTIVAKTIVActive Indicator for Inspection TypeCHAR1R
QMATSTEURKZSTEURKZControl Key for Inspection Type (Insp. lot creation etc.)CHAR2R
QMATPRUEFLOSPRUEFLOSInspection Lot OriginCHAR2C
QMATLOSARTLOSARTLot Size for InspectionNUMC6C
QMATVERWMERKMVERWMERKMMaster Inspection Characteristics AssignedCHAR18C
QMATLOEKZLOEKZDeletion IndicatorCHAR1C
MARCSSQSSSSQSSQM Procurement KeyCHAR2C
MARCSPRQKZSPRQKZQuality Management in Procurement ActiveCHAR1C
MARCPRUEFGRPRUEFGRQM Control Key for Goods ReceiptCHAR4C
MARCINSMKINSMKStock Type for Quality InspectionCHAR1C


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
2009-001C1Invalid or inactive Inspection Type maintained for the material.Material as per relevancy criteria with active Inspection Type (QMAT-QMART) and valid activation flag (QMAT-AKTIV = ‘X’) within the plant scope.Inspection TypePF2/WP2
2009-002C1Inspection Type not linked with valid Plant/Material combination.Material Master (MARA/MARC) must have corresponding entry in QMAT with valid Plant and active flag.Material-PlantPF2/WP2
2009-003C1Inspection Type maintained without valid Quality Info Record.Inspection Type (QMAT) must have a corresponding valid entry in QINF with same Material and Plant combination.Quality Info RecordPF2/WP2
2009-004C2Quality Level Indicator inconsistent.Quality Level Indicator (QMAT-QBEST) must follow valid range defined in configuration table TQ07.Quality LevelPF2/WP2
2009-005C1Inspection Setup maintained with invalid Usage Key.Usage Key (QMAT-VERWM) must exist in configuration table (TQ09).Usage KeyPF2/WP2
2009-006C1Invalid or missing Control Key in QM View.Control Key (QMAT-STEUF) must be maintained and valid per configuration table (TQ08).Control KeyPF2/WP2
2009-007C2Inconsistent Active Flag (Material without active QM view).Only materials with QMAT-AKTIV = ‘X’ are valid for migration. Inactive records to be excluded.Active FlagPF2/WP2
2009-008C1Missing linkage between Inspection Type and Inspection Lot Origin.Each Inspection Type must have a valid Inspection Lot Origin (TQ85-QPRUEFART).Inspection Lot OriginPF2/WP2
2009-009C1Missing or invalid Quality Control Key assignment.Control Key (QMAT-STEUF) must match configuration in TQ09 with valid status.Control KeyPF2/WP2
2009-010C1Missing or invalid Deletion Indicator setup.Material marked for deletion (MARA-LOEKZ = ‘X’) or with inactive QM view (QMAT-AKTIV ≠ ‘X’) should be excluded from migration scope.Deletion IndicatorPF2/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. 

For sites that are not on SAP-PF2 and WP2 systems, collection will be done manually in the data collection template.

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


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 /P2F 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

Not applicable


Data Collection Template (DCT)

The Data Collection Template (DCT) will not be applicable in this case. If there is a need to create a new Master Data (MD) for Material BOM object, the business must perform this activity in the source system. The newly created object will then be captured and migrated as part of the standard migration process.

Extraction Dependencies

Before data extraction can commence, several prerequisite steps and conditions must be met to ensure a smooth and accurate extraction process. These dependencies involve confirming system readiness, validating data structures, and ensuring that appropriate access rights and credentials are in place.

Each step must be clearly defined, assigned to responsible teams, and completed prior to extraction activities. Proper coordination across stakeholders is required to mitigate risks and avoid delays in the migration timeline.

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

7

Data cleansing of legacy Resource 

If standardization within the DCT begins using relevant data from PF2 and WP2 before the cleansing is finalized, it is understood that the business will take due diligence to ensure any subsequent delta cleansing is verified and aligned within the DCT.

Business


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 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
  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

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 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
  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
Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2/WP2QMATMATNRMaterialS/4HANAQMATMATNRMaterialLegacy Material Number mapped to new S/4HANA Material Number per Material Master mapping file
2PF2/WP2QMATWERKSPlantS/4HANAQMATWERKSPlantMap legacy Plant to new S/4HANA Plant per To-Be Plant Mapping table
3PF2/WP2QMATQPRUEFARTInspection TypeS/4HANAQMATQPRUEFARTInspection TypeTransfer directly; must exist and be active in configuration table TQ07A
4PF2/WP2QMATAKTIVActive IndicatorS/4HANAQMATAKTIVActive IndicatorRetain value if ‘X’; otherwise exclude from migration (inactive QM View)
5PF2/WP2QMATSTEUFControl KeyS/4HANAQMATSTEUFControl KeyMap via configuration table TQ08 to ensure valid Control Key value
6PF2/WP2QMATVERWMUsage KeyS/4HANAQMATVERWMUsage KeyMap legacy usage key to harmonized usage per configuration table TQ09
7PF2/WP2QMATPRUEFLOSInspection Lot OriginS/4HANAQMATPRUEFLOSInspection Lot OriginEnsure linkage to valid entry in TQ85; default based on Inspection Type if blank
8PF2/WP2QMATQBESTQuality Level IndicatorS/4HANAQMATQBESTQuality Level IndicatorValidate against TQ07 value range; incorrect values default to blank
9PF2/WP2QMATLOEKZDeletion IndicatorS/4HANAQMATLOEKZDeletion FlagExclude records where Deletion Indicator = ‘X’ (inactive or obsolete)
10PF2/WP2QMATERSDACreated OnS/4HANAQMATERSDACreated On DateSystem-generated field during load
11PF2/WP2QMATERNAMCreated ByS/4HANAQMATERNAMCreated BySystem-generated field during load
12PF2/WP2QMATAEDATChanged OnS/4HANAQMATAEDATChanged OnSystem-generated field during load
13PF2/WP2QMATAENAMChanged ByS/4HANAQMATAENAMChanged BySystem-generated field during load
14PF2/WP2QINFQMATNRQuality Info Record MaterialS/4HANAQINFMATNRQuality Info Record MaterialInclude only if corresponding Inspection Type is active in QMAT
15PF2/WP2QINFQWERKSQuality Info Record PlantS/4HANAQINFWERKSQuality Info Record PlantMap per To-Be Plant mapping table


Transformation Mapping


Mapping Table NameMapping Table Description
MaterialMapping of legacy Material Number to new Material Number in S/4HANA target system. Ensures all inspection-related records are aligned with the migrated Material Master.
PlantMapping of legacy Plant codes to new Plant codes in the S/4HANA target system, based on To-Be Plant Mapping definition.
Inspection TypeMapping of legacy Inspection Types to harmonized Inspection Types in S/4HANA, ensuring alignment with target configuration (TQ07A).
Usage KeyMapping of legacy Usage Key values to standardized Usage Keys as per S/4HANA configuration (TQ09).
Control KeyMapping of legacy Control Key values to target system Control Keys (TQ08) for consistent inspection processing logic.
Inspection Lot OriginMapping of legacy Inspection Lot Origin values to valid entries in target configuration (TQ85).
UoM (Unit of Measure)Mapping of legacy Units of Measure to ISO-compliant Units of Measure in S/4HANA (T006).
Authorization GroupMapping of legacy Authorization Group values to new Authorization Groups maintained in S/4HANA (TBRG).
Quality Level IndicatorMapping of legacy Quality Level Indicator values to valid target domain values in S/4HANA (TQ07).

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
Verify Record CountSyWay P2F-MFG Data Team to verify that the total number of relevant records from the  system is equal to the total number of records in the Preload and Load Sheets.

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 inspection activities and quality control processes are carried out. Ensures material QM view is maintained only in valid, active plants.
2T006 – Units of Measurement (UoM): ISO-compliant UoM definitions to ensure consistent measurement units across all inspection processes.
3TQ07A – Inspection Types: Configuration of valid inspection types (e.g., 01, 02, 04, 05, 06, 08, 10, 11, 12, 17, 89) used in material QM view.
4TQ85 – Inspection Lot Origin: Configuration of inspection lot origin values to control how inspection lots are created from different business processes.
5TQ09 – Usage Keys: Definition of usage keys to specify valid scenarios for inspection (e.g., goods receipt, production, stock transfer).
6TQ08 – Control Keys (QM): Definition of control keys determining inspection processing behavior (e.g., automatic lot creation, inspection point usage).
7TQ15 – Catalog Types: Definition of catalog types (e.g., defects, results, codes) used in conjunction with inspection types and usage keys.
8TQ15T – Selected Sets & Code Groups: Configuration of selected sets and code groups for qualitative results recording and defect tracking.
9TQ33 – Catalog Profile Assignment: Configuration of catalog profiles assigned to inspection types and materials for standardized defect documentation.
10TBRG – Authorization Groups: Assignment of authorization groups for controlling access and maintenance rights to QM view data.
11TQ30 – Reference Indicators: Control of reference indicator usage for linking plant-specific and global quality settings.
12TQ75 – Decimal Places & Format: Configuration of decimal places, number format, and rounding rules for quantitative inspection data entry.
13T134 – Material Types: Configuration of BOM- and QM-relevant material types (e.g., ROH, HALB, FERT) to control where QM view is required or optional.
14TQ02 – Quality Levels / Dynamic Modification: Configuration of quality levels and dynamic modification rules for inspection type control.
15TQ03 – Inspection Severity: Configuration of severity levels used in conjunction with dynamic modification rules for quality levels.

Conversion Objects

Object #Preceding Object Conversion Approach
2019Material Master - Basic Data View
2023Material Master - Classification & Characteristic Assignment

Error Handling

Error TypeError DescriptionAction Taken










Post-Load Validation

Project Team

The following post-load validations will be performed by the Project Team.

Completeness

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Accuracy

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Business

The following post-load validations will be performed by the business.

Completeness

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Accuracy

TaskAction
titlespecific details of what and how the task needs to be performed e.g. which reports are being used etc.





Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • Data Object is in scope based on data design and any exception requested by business.

Any additional key assumptions.


See also

Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.

Change log

Workflow history