| Status | Tech Review |
|---|---|
| Owner | |
| Stakeholders | GERVAIS, Pascal NICASTRI-ext, Michele |
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
Active Material Master QM Views that are in use within the last three (3) years in inspection lots, quality certificates, or inspection plans.
QM Views without Deletion Flag, i.e., not blocked or obsolete.
QM Views assigned to plants that are in-scope for S/4HANA migration, based on the To-Be Plant Mapping.
Materials with at least one valid inspection type (e.g., 01, 04, 09) configured and active in the QM View.
Materials where control key, inspection setup, and certificate requirements are consistent with S/4HANA target design.
The data from legacy system excludes:
Inactive QM Views for materials not used in inspection lots or quality processes for more than three (3) years.
QM Views marked for deletion or with inspection types blocked in ECC.
QM Views belonging to plants that are out of scope or deleted as per To-Be Plant Mapping.
Obsolete inspection types or settings that are not supported in S/4HANA.
Duplicate or conflicting QM Views for the same material/plant combination, where only one harmonized record should remain.
Relevancy rule
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.
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.
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.
Component materials – All components within the BOM must be valid, active materials in the Material Master and not marked for deletion.
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
| Source | Scope | Source Approx No. of Records | Target System | Target 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,000 | S4 HANA | 400,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)
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| MARC | MATNR | MATNR | Material Number | CHAR | 18 | R |
| MARC | WERKS | WERKS_D | Plant | CHAR | 4 | R |
| MARC | QMATV | QMATV | QM Control Key (Material Active in QM) | CHAR | 1 | R |
| QMAT | ART | ART | Inspection Setup Indicator | CHAR | 1 | R |
| QMAT | ARTINSP | ARTINSP | Inspection Type | CHAR | 4 | R |
| QMAT | AKTIV | AKTIV | Active Indicator for Inspection Type | CHAR | 1 | R |
| QMAT | STEURKZ | STEURKZ | Control Key for Inspection Type (Insp. lot creation etc.) | CHAR | 2 | R |
| QMAT | PRUEFLOS | PRUEFLOS | Inspection Lot Origin | CHAR | 2 | C |
| QMAT | LOSART | LOSART | Lot Size for Inspection | NUMC | 6 | C |
| QMAT | VERWMERKM | VERWMERKM | Master Inspection Characteristics Assigned | CHAR | 18 | C |
| QMAT | LOEKZ | LOEKZ | Deletion Indicator | CHAR | 1 | C |
| MARC | SSQSS | SSQSS | QM Procurement Key | CHAR | 2 | C |
| MARC | SPRQKZ | SPRQKZ | Quality Management in Procurement Active | CHAR | 1 | C |
| MARC | PRUEFGR | PRUEFGR | QM Control Key for Goods Receipt | CHAR | 4 | C |
| MARC | INSMK | INSMK | Stock Type for Quality Inspection | CHAR | 1 | C |
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.
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
|---|---|---|---|---|---|
| 2009-001 | C1 | Invalid 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 Type | PF2/WP2 |
| 2009-002 | C1 | Inspection 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-Plant | PF2/WP2 |
| 2009-003 | C1 | Inspection 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 Record | PF2/WP2 |
| 2009-004 | C2 | Quality Level Indicator inconsistent. | Quality Level Indicator (QMAT-QBEST) must follow valid range defined in configuration table TQ07. | Quality Level | PF2/WP2 |
| 2009-005 | C1 | Inspection Setup maintained with invalid Usage Key. | Usage Key (QMAT-VERWM) must exist in configuration table (TQ09). | Usage Key | PF2/WP2 |
| 2009-006 | C1 | Invalid or missing Control Key in QM View. | Control Key (QMAT-STEUF) must be maintained and valid per configuration table (TQ08). | Control Key | PF2/WP2 |
| 2009-007 | C2 | Inconsistent Active Flag (Material without active QM view). | Only materials with QMAT-AKTIV = ‘X’ are valid for migration. Inactive records to be excluded. | Active Flag | PF2/WP2 |
| 2009-008 | C1 | Missing linkage between Inspection Type and Inspection Lot Origin. | Each Inspection Type must have a valid Inspection Lot Origin (TQ85-QPRUEFART). | Inspection Lot Origin | PF2/WP2 |
| 2009-009 | C1 | Missing or invalid Quality Control Key assignment. | Control Key (QMAT-STEUF) must match configuration in TQ09 with valid status. | Control Key | PF2/WP2 |
| 2009-010 | C1 | Missing 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 Indicator | 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.
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:
- The data exists. Syniti Migrate connects to the source and loads the data into Syniti Migrate. There are 3 methods:
- Perform full data extraction from relevant tables in the source system(s).
- Perform extraction through the application layer.
- Only if Syniti Migrate; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
- 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 Description | Team 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 Description | Team Responsible |
|---|---|---|
| 1 | Source System Availability
| Syensqo IT |
| 2 | Data Structure
| Syniti |
| 3 | Referential Integrity
| Syniti |
| 4 | Extraction Methodology
| Syniti |
| 5 | Performance and Scalability Considerations
| Syniti |
| 6 | Security and Compliance
| 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:
- Perform value mapping and data transformation rules.
- Legacy values are mapped to the to-be values (this could include a default value)
- Values are transformed according to the rules defined in
- 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 Description | Team Responsible |
|---|---|---|
| 1 | Obtain DCT Sign-off from Business | SyWay Data Team |
| 2 | <Add steps from Syniti Migrate here> | SyWay Data Team |
| 3 | Review and Validate Error and Preload Reports | SyWay Data Team |
| 4 | Generate Load Files | SyWay 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:
- Perform value mapping and data transformation rules.
- Legacy values are mapped to the to-be values (this could include a default value)
- Values are transformed according to the rules defined in
- 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 system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PF2/WP2 | QMAT | MATNR | Material | S/4HANA | QMAT | MATNR | Material | Legacy Material Number mapped to new S/4HANA Material Number per Material Master mapping file |
| 2 | PF2/WP2 | QMAT | WERKS | Plant | S/4HANA | QMAT | WERKS | Plant | Map legacy Plant to new S/4HANA Plant per To-Be Plant Mapping table |
| 3 | PF2/WP2 | QMAT | QPRUEFART | Inspection Type | S/4HANA | QMAT | QPRUEFART | Inspection Type | Transfer directly; must exist and be active in configuration table TQ07A |
| 4 | PF2/WP2 | QMAT | AKTIV | Active Indicator | S/4HANA | QMAT | AKTIV | Active Indicator | Retain value if ‘X’; otherwise exclude from migration (inactive QM View) |
| 5 | PF2/WP2 | QMAT | STEUF | Control Key | S/4HANA | QMAT | STEUF | Control Key | Map via configuration table TQ08 to ensure valid Control Key value |
| 6 | PF2/WP2 | QMAT | VERWM | Usage Key | S/4HANA | QMAT | VERWM | Usage Key | Map legacy usage key to harmonized usage per configuration table TQ09 |
| 7 | PF2/WP2 | QMAT | PRUEFLOS | Inspection Lot Origin | S/4HANA | QMAT | PRUEFLOS | Inspection Lot Origin | Ensure linkage to valid entry in TQ85; default based on Inspection Type if blank |
| 8 | PF2/WP2 | QMAT | QBEST | Quality Level Indicator | S/4HANA | QMAT | QBEST | Quality Level Indicator | Validate against TQ07 value range; incorrect values default to blank |
| 9 | PF2/WP2 | QMAT | LOEKZ | Deletion Indicator | S/4HANA | QMAT | LOEKZ | Deletion Flag | Exclude records where Deletion Indicator = ‘X’ (inactive or obsolete) |
| 10 | PF2/WP2 | QMAT | ERSDA | Created On | S/4HANA | QMAT | ERSDA | Created On Date | System-generated field during load |
| 11 | PF2/WP2 | QMAT | ERNAM | Created By | S/4HANA | QMAT | ERNAM | Created By | System-generated field during load |
| 12 | PF2/WP2 | QMAT | AEDAT | Changed On | S/4HANA | QMAT | AEDAT | Changed On | System-generated field during load |
| 13 | PF2/WP2 | QMAT | AENAM | Changed By | S/4HANA | QMAT | AENAM | Changed By | System-generated field during load |
| 14 | PF2/WP2 | QINF | QMATNR | Quality Info Record Material | S/4HANA | QINF | MATNR | Quality Info Record Material | Include only if corresponding Inspection Type is active in QMAT |
| 15 | PF2/WP2 | QINF | QWERKS | Quality Info Record Plant | S/4HANA | QINF | WERKS | Quality Info Record Plant | Map per To-Be Plant mapping table |
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
| Material | Mapping 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. |
| Plant | Mapping of legacy Plant codes to new Plant codes in the S/4HANA target system, based on To-Be Plant Mapping definition. |
| Inspection Type | Mapping of legacy Inspection Types to harmonized Inspection Types in S/4HANA, ensuring alignment with target configuration (TQ07A). |
| Usage Key | Mapping of legacy Usage Key values to standardized Usage Keys as per S/4HANA configuration (TQ09). |
| Control Key | Mapping of legacy Control Key values to target system Control Keys (TQ08) for consistent inspection processing logic. |
| Inspection Lot Origin | Mapping 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 Group | Mapping of legacy Authorization Group values to new Authorization Groups maintained in S/4HANA (TBRG). |
| Quality Level Indicator | Mapping 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 Description | Team Responsible |
|---|---|---|
| 1 | Ensure tables completeness | Syniti |
| 2 | Ensure all Transformation mappings are up to date. | Syniti |
Pre-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Business
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Load
The load process includes:
- Execute the automated data load into target system using load tool or product the load file if the load must be done manually
- 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 Description | Team Responsible |
|---|---|---|
Load Phase and Dependencies
Configuration
| Item # | Configuration Item |
|---|---|
| 1 | T001W – 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. |
| 2 | T006 – Units of Measurement (UoM): ISO-compliant UoM definitions to ensure consistent measurement units across all inspection processes. |
| 3 | TQ07A – 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. |
| 4 | TQ85 – Inspection Lot Origin: Configuration of inspection lot origin values to control how inspection lots are created from different business processes. |
| 5 | TQ09 – Usage Keys: Definition of usage keys to specify valid scenarios for inspection (e.g., goods receipt, production, stock transfer). |
| 6 | TQ08 – Control Keys (QM): Definition of control keys determining inspection processing behavior (e.g., automatic lot creation, inspection point usage). |
| 7 | TQ15 – Catalog Types: Definition of catalog types (e.g., defects, results, codes) used in conjunction with inspection types and usage keys. |
| 8 | TQ15T – Selected Sets & Code Groups: Configuration of selected sets and code groups for qualitative results recording and defect tracking. |
| 9 | TQ33 – Catalog Profile Assignment: Configuration of catalog profiles assigned to inspection types and materials for standardized defect documentation. |
| 10 | TBRG – Authorization Groups: Assignment of authorization groups for controlling access and maintenance rights to QM view data. |
| 11 | TQ30 – Reference Indicators: Control of reference indicator usage for linking plant-specific and global quality settings. |
| 12 | TQ75 – Decimal Places & Format: Configuration of decimal places, number format, and rounding rules for quantitative inspection data entry. |
| 13 | T134 – Material Types: Configuration of BOM- and QM-relevant material types (e.g., ROH, HALB, FERT) to control where QM view is required or optional. |
| 14 | TQ02 – Quality Levels / Dynamic Modification: Configuration of quality levels and dynamic modification rules for inspection type control. |
| 15 | TQ03 – Inspection Severity: Configuration of severity levels used in conjunction with dynamic modification rules for quality levels. |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| list the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram) | |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
Post-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Business
Completeness
| Task | Action |
|---|---|
Accuracy
| Task | Action |
|---|---|
Key Assumptions
- Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
- is in scope based on data design and any exception requested by business.
See also
Change log
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||

