| Status | Revision in Progress |
|---|---|
| Owner | |
| Stakeholders |
Purpose
The purpose of this document is to define the conversion approach to create 1041 Inspection Plan Conversion Specification Document in S/4 HANA.
Inspection Plans are a core component of SAP Quality Management (QM) that define how materials are inspected, including inspection characteristics, sampling procedures, and inspection methods. An inspection plan contains detailed steps for quality checks and ensures that inspections are carried out in a standardized, repeatable, and compliant manner for specific materials, plants, and usage scenarios.
In SAP S/4HANA, the structure and usage of inspection plans remain largely consistent with SAP ECC, typically organized by key combinations such as material/plant, material group/plant, or multiple materials assigned to the same inspection plan via task lists. Inspection plans may also be linked to specific usage types (e.g., goods receipt, in-process inspection, final inspection) and can be maintained with reference to alternative groupings for flexibility.
In SAP ECC, aside from the standard structures, there may be inspection plans with additional variants such as multiple alternative plans for the same material/plant combination, inspection plans assigned to multiple task list groups, or plans that use reference materials. In some legacy systems, plans may also include non-standard fields or custom enhancements (pending MDS review) that will require evaluation before conversion.
This conversion aims to migrate active and relevant inspection plan master data, including associated operations, inspection characteristics, sampling procedures, and inspection methods, from existing ECC systems into S/4HANA. The migration will apply 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_INSPECTIONPLAN_CREATE), IDOCs, or direct table loads where applicable, ensuring data consistency and compliance with S/4HANA requirements
Conversion Scope
The scope of this document covers the approach for converting active Inspection Plan from Legacy Source Systems into S/4 HANA system following the TBD Inspection Plan Master Data Design Standard.
From the current system landscape, Inspection Plan 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:
- Active Inspection Plans (PLKO) that are in “Released” status (STATU = 4), PLNTY = 'Q' and used in production, quality, or procurement processes within the last three (4) years.
- Inspection Plans without deletion flag (PLKO-LOEKZ not set).
- Plant-specific Inspection Plans that will be migrated according to the To-Be Plant Mapping (considering new plant definitions).
- Inspection Plans assigned to valid materials via MAPL, where the material exists in the Material Master (MARA/MARC) and is in scope for migration.
- Inspection Plans with valid Group and Group Counter (PLKO-PLNNR, PLKO-PLNAL)
- Inspection Plans containing valid operations (PLPO) that reference existing and active work centers (CRHD).
- Inspection Plan characteristics (PLMK) that:
- Reference valid Master Inspection Characteristics (QPMK)
- Reference valid Sampling Procedures (QDSV)
- Reference valid Inspection Methods (QMTB)
- Inspection Plans with valid validity dates (PLKO-DATUV)
The data from legacy system excludes:
- Inactive Inspection Plans that have not been used in inspection lots for more than three (4) years
- Inspection Plans marked for deletion (PLKO-LOEKZ = X)
- Inspection Plans belonging to deleted or out-of-scope plants (as per To-Be Plant Mapping)
- Inspection Plans with invalid or inconsistent references, such as:
- Characteristics linked to deleted/inactive MICs
- Sampling Procedures or Inspection Methods that do not exist in S/4HANA
- Work Centers flagged for deletion or not migrated
- Inspection Plans with invalid validity dates (Valid-From date into the future PLKO-DATUV).
Relevancy rule
Use the below rules for relevancy criteria.
1. Inspection Plans assigned to valid materials via MAPL, where the material exists in the Material Master (MARA/MARC) and is in scope for migration.
2. Active Inspection Plans (PLKO) that are in “Released” status (STATU = 4), PLNTY = 'Q' and used in production, quality, or procurement processes within the last three (4) years.
QALS-ENSTEHDAT >= (CURRENT DATE - 4 Years) AND QALS-PLNNR = PLKO-PLNNR AND QALS-PLNAL = PLKO-PLNAL AND PLKO-PLNTY = 'Q' AND
PLKO-STATU = '4' & PLKO-LOEKZ = Blank & PLPO-LOEKZ = Blank and PLKO-DATUV > CURRENT DATE
3. Inspection Plans containing valid operations (PLPO) that reference existing and active work centers (CRHD).
4. Inspection Plan characteristics (PLMK) that
- Reference valid Master Inspection Characteristics (QPMK)
- Reference valid Sampling Procedures (QDSV)
- Reference valid Inspection Methods (QMTB)
Plant Merging
Plants will be harmonized based on the To-Be Plant Mapping. As some legacy plants will be merged into one target plant, Inspection Plans 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 | Inspection Plan will be extracted from PF2 and WP2 | PF2 = 8129 records WP2 = 37451 records | S/4 HANA | 13209 records |
Additional Information
Multi-language Requirement
Inspection Plan description will be maintained in English by default.
Since multi-language support is available for Inspection Plan, 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 Inspection Plan.
Document Management
None identified. The conversion scope is limited to the migration of Inspection Plan object. No document attachments, images, or supporting files are included.
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
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
| PLKO | PLNTY | PLNTY | Key which classifies task lists according to their functionality. In the QM context this value is defaulted to "Q" | CHAR | 1 | R |
| PLKO | PLNNR | PLNNR | Key that uniquely identifies an Inspection Plan Group. | CHAR | 8 | S |
| PLKO | PLNAL | PLNAL | Key that identifies an Inspection Plan within a Task List Group. | CHAR | 2 | R |
| PLKO | ZAEHL | CIM_COUNT | Internal Counter to link the tables to ensure the data consistency | NUMC | 8 | S |
| PLKO | DATUV | DATUV | Date from which the an Inspection Plan object is valid. | DATS | 8 | R |
| PLKO | VALID_TO | DATUB | End of the validity period of the Inspection Plan object. | DATS | 8 | R |
| PLKO | AENNR | AENNR | Key for the change master record or engineering change order that the chosen change status of the Inspection Plan object was created with. Can be used for Customer Spec Updates | CHAR | 12 | NU |
| PLKO | VERWE | PLN_VERWE | Key indicating what the Inspection Plan is used for, such as Inspection for GR, Recurring Inspection, Goods Issue. | CHAR | 3 | R |
| PLKO | WERKS | WERKS_D | Plant of the material to be inspected. | CHAR | 4 | R |
| PLKO | STATU | PLNST | Status key to indicate the processing status of an Inspection Plan. For example, indicate whether the recipe is still in the creation phase or has already been released. | CHAR | 3 | R |
| PLKO | PLNME | PLNME | Unit of measure of the charge quantity | UNIT | 3 | R |
| PLKO | LOSVN | LOSGRVON | Lower limit of the charge quantity range for which the recipe is valid. | QUAN | 13 | NU |
| PLKO | LOSBS | LOSGRBIS | Upper limit of the charge quantity range for which the recipe is valid. | QUAN | 13 | NU |
| PLKO | VAGRP | VAGRP | Key of the planner group responsible for maintaining the Inspection Plan. | CHAR | 3 | C |
| PLKO | KTEXT | PLANTEXT | Describes the Inspection Plan | CHAR | 40 | R |
| PLKO | TXTSP | SPRAS | Language key | LANG | 1 | S |
| PLKO | LOEKZ | LKENZ | Indicator set if the Inspection Plan to be completely deleted at the next reorganization run, with all its change states. | CHAR | 1 | S |
| PLKO | QKZRASTER | QKZRASTER | Identifier for Inspection Point Field Combination Inspection points are used as reference objects for recording inspection results below operation level. If a value is entered for the inspection point, this value is copied to the inspection lots. | CHAR | 1 | C |
| PLKO | QPRZIEHVER | QPRZIEHVER | A master data object in QM sample management that contains instructions for a sample drawing. | CHAR | 8 | C |
| PLKO | QDYNREGEL | QDYNREGEL | Contains the definition of inspection stages and the conditions that lead to changes in inspection stages. | CHAR | 3 | C |
| PLKO | QDYNHEAD | QDYNHEAD | Identifies the level at which the decision for inspection stages is made and the quality level maintained. | CHAR | 1 | NU |
| MAPL | MATNR | MATNR | Material Number for witch the recipe is created | CHAR | 40 | R |
| MAPL | WERKS | WERKS_D | Plant | CHAR | 4 | R |
| MAPL | PLNTY | PLNTY | Key which classifies task lists according to their functionality. In the QM context this value is defaulted to "Q" | CHAR | 1 | R |
| MAPL | PLNNR | PLNNR | Key that uniquely identifies an Inspection Plan Group. | CHAR | 8 | S |
| MAPL | PLNAL | PLNAL | This key and the task list group uniquely identify a task list. | CHAR | 2 | S |
| MAPL | ZKRIZ | DZKRIZ | Internal Counter to link the tables to ensure the data consistency | NUMC | 7 | S |
| MAPL | ZAEHL | CIM_COUNT | Internal Counter to link the tables to ensure the data consistency | NUMC | 8 | S |
| MAPL | LIFNR | ELIFN | Supplier | CHAR | 10 | C |
| MAPL | KUNR | CPKUNR | Customer | CHAR | 10 | C |
| PLPO | PLNTY | PLNTY | Key which classifies task lists according to their functionality. In the QM context this value is defaulted to "Q" | CHAR | 1 | R |
| PLPO | PLNNR | PLNNR | Key that uniquely identifies an Inspection Plan Group. | CHAR | 8 | S |
| PLPO | PLNAL | PLNAL | Key that identifies an Inspection Plan within a Task List Group. | CHAR | 2 | R |
| PLPO | ZAEHL | CIM_COUNT | Internal Counter to link the tables to ensure the data consistency | NUMC | 8 | S |
| PLPO | VORNR | VORNR | Determines in which order the operations of a sequence are carried out. | CHAR | 4 | R |
| PLPO | ARBID | OBJEKTID | Workcenter used to perform the QM activity | NUMC | 8 | R |
| PLPO | STEUS | STEUS | Determines which business transactions should be executed for the object that belongs to the task list or order (for example scheduling or costing). | CHAR | 4 | R |
| PLPO | LTXA1 | LTXA1 | Operation Short Text | CHAR | 40 | C |
| PLPO | BMSCH | BMSCH | Quantity of the material to be inspected to which the standard values of the operation refer. | QUAN | 13 | R |
| PLPO | MEINH | VORME | Unit of measure used in the operation for the material to be inspected. | UNIT | 3 | R |
| PLPO | WERKS | WERKS_D | Plant | CHAR | 4 | R |
| PLPO | LAR01 | LSTAR | Activity Type | CHAR | 6 | NU |
| PLPO | VGE01 | VGWRTEH | Unit of Measurement of Standard Value | UNIT | 3 | NU |
| PLPO | VGW01 | VGWRT | QUAN | 9 | NU | |
| PLMK | PLNTY | PLNTY | Key which classifies task lists according to their functionality. In the QM context this value is defaulted to "Q" | CHAR | 1 | R |
| PLMK | PLNNR | PLNNR | Key that uniquely identifies an Inspection Plan Group. | CHAR | 8 | S |
| PLMK | PLNKN | PLNKN | The Node field represents the unique identifier of a task list node, which links an operation in a task list to specific inspection characteristics | NUMC | 8 | S |
| PLMK | MERKNR | QMERKNRP | The number that explicitly identifies an inspection characteristic within an operation in an inspection plan. | NUMC | 4 | R |
| PLMK | VERWMERKM | QMERKNR | Master Inspection Characteristics | CHAR | 8 | R |
| PLMK | KZEINSTELL | QKZEINSTMK | Characteristic Type: Quantitative or Qualitative | CHAR | 1 | S |
| PLMK | ZAEHL | CIM_COUNT | Internal Counter to link the tables to ensure the data consistency | NUMC | 8 | S |
| PLMK | QPMK_ZAEHL | QZAEHLER | Plant | CHAR | 4 | R |
| PLMK | MKVERSION | QVERSNRMK | Version Number of Master Inspection Characteristic | CHAR | 6 | S |
| PLMK | KURZTEXT | QTXT_CHA | Text of up to 40 characters that describes the object in more detail. This description is also known as short text. | CHAR | 40 | C |
| PLMK | PMETHODE | QPMETHODE | An inspection method describes how to inspect an inspection characteristic. You can assign an inspection method to a master inspection characteristic or directly to an inspection characteristic in an inspection plan. | CHAR | 8 | C |
| PLMK | QMTB_WERKS | Q_METH_PLANT | Plant for Inspection Method | CHAR | 4 | S |
| PLMK | PMTVERSION | QVERSNRPM | Version Number of Inspection Method | CHAR | 6 | S |
| PLMK | STICHPRVER | QSTICHVERF | Procedure by which the sample size for an inspection is determined. In the sampling procedure, the valuation mode is also defined for the inspection result. | CHAR | 8 | R |
| PLMK | MASSEINHSW | QMASSEH | Measurement Unit in Which Quantitative Data Is Maintained Specifies the unit of measurement for the proposed values of a quantitative inspection characteristic (for example, target value, specification limits). You have 6 digits to specify the unit of measurement. | UNIT | 3 | S |
| PLMK | SOLLWERT | QSOLLWERTE | Target Value for a Quantitative Characteristic Value of a quantitative characteristic, from which the actual value of the inspection characteristic should deviate as little as possible. | FLTP | 16 | R |
| PLMK | TOLERANZUN | QTOLUN | Lower Specification Limit Lower limiting value for the actual value of an inspection characteristic. | FLTP | 16 | R |
| PLMK | TOLERANZOB | QTOLOB | Upper Specification Limit Upper limit value for the actual value of an inspection characteristic. | FLTP | 16 | R |
| PLMK | AUSWMENGE1 | QCGRAUSW | If the characteristic is qualitative with a characteristic attribute you can enter a selected set in this field. | CHAR | 8 | R |
| PLMK | AUSWMGWRK1 | QWERKAUSW | Plant of assigned selected set | CHAR | 4 | S |
| PLMK | DUMMY10 | QTXT10 | Text Line for Additional Information_1 | CHAR | 10 | NU |
| PLMK | DUMMY20 | QTXT20 | Text Line for Additional Information_2 | CHAR | 20 | NU |
| PLMK | DUMMY40 | QTXT40 | Text Line for Additional Information_3 | CHAR | 40 | NU |
| PLMK | GRENZEOB1 | QGRENZOB1 | Upper limit value of a user-specified limit, for example, a warning limit. The system does not use the contents of this field. This field provides a place to store a user-specified limit value that is relevant | FLTP | 16 | NU |
| PLMK | GRENZOB1NI | QNINITIAL | Value Not Initial If Set | CHAR | 1 | NU |
| PLMK | GRENZEUN1 | QGRENZUN1 | Lower limiting value of a user-specified limit, for example, a warning limit The system does not use the contents of this field. This field provides a place to store a user-specified limit value that is relevant for a quantitative characteristic. | FLTP | 16 | NU |
| PLMK | GRENZUN1NI | QNINITIAL | Value Not Initial If Set | CHAR | 1 | NU |
| PLMK | GRENZEOB2 | QGRENZOB2 | Upper limit value of a user-specified limit, for example, a warning limit. The system does not use the contents of this field. This field provides a place to store a user-specified limit value that is relevant | FLTP | 16 | NU |
| PLMK | GRENZOB2NI | QNINITIAL | Value Not Initial If Set | CHAR | 1 | NU |
| PLMK | GRENZEUN2 | QGRENZUN2 | Lower limiting value of a user-specified limit, for example, a warning limit The system does not use the contents of this field. This field provides a place to store a user-specified limit value that is relevant for a quantitative characteristic. | FLTP | 16 | NU |
| PLMK | GRENZUN2NI | QNINITIAL | Value Not Initial If Set | CHAR | 1 | NU |
| PLMK | PLAUSIOBEN | QPLAUSIOB | Maximum plausible value of a plausibility limit.It protects against the recording and processing of invalid or improbable values | FLTP | 16 | C |
| PLMK | PLAUSIOBNI | QNINITIAL | Value Not Initial If Set | CHAR | 1 | S |
| PLMK | PLAUSIUNTE | QPLAUSIUN | Minimum plausible value of a plausibility limit.This field is used only for results recording of quantitative characteristics. It protects against the recording and processing of invalid or improbable values. | FLTP | 16 | C |
| PLMK | PLAUSIUNNI | QNINITIAL | Value Not Initial If Set | CHAR | 1 | S |
| PLMK | TOLERWEIOB | QTOLWOB | Amount by which the specification limit is temporarily increased or decreased. | FLTP | 16 | NU |
| PLMK | TOLWOBNI | QNINITIAL | Value Not Initial If Set | CHAR | 1 | S |
| PLMK | TOLERWEIUN | QTOLWUN | Amount by which the specification limit is temporarily increased or decreased. | FLTP | 16 | NU |
| PLMK | TOLWUNNI | QNINITIAL | Value Not Initial If Set | CHAR | 1 | S |
| PLMK | TOLERWAB | QTOLWAB | Date from Which the Tolerance Change Is Valid | DATS | 8 | C |
| PLMK | TOLERWBIS | QTOLWBIS | Date Until Which the Tolerance Change Is Valid | DATS | 8 | C |
Data Cleansing
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
| 1006-001 | C1 | Invalid or inactive Work Center linked to Operation | Operation (PLPO) assigned to a Work Center (CRHD) that does not exist or is flagged for deletion. | Work Center | PF2/WP2 |
| 1041-001 | C1 | Inspection Plan not released | Header (PLKO-STATU) not set to “Released” (status = 4). Only released plans are migrated. | Inspection Plan Header | PF2/WP2 |
| 1041-002 | C1 | Invalid Usage assignment | Inspection plan header (PLKO-VERWE) has an invalid or non-configured Task List Usage. | Usage | PF2/WP2 |
| 1041-003 | C1 | Missing or invalid Group Counter | Inspection plan (PLKO-PLNAL) is blank, duplicated, or inconsistent with group. | Plan Counter | PF2/WP2 |
| 1041-004 | C1 | Invalid Validity Date | Valid-From date (PLKO-DATUV) is in the future or overlaps inconsistently with other plans for same material/usage. | Inspection Plan Header | PF2/WP2 |
| 1041-005 | C1 | Obsolete Inspection Plan | Header marked with deletion flag (PLKO-LOEKZ = X). Exclude from migration. | Inspection Plan Header | PF2/WP2 |
| 1043-001 | C1 | Missing or Invalid Inspection Method | Plan characteristic (PLMK-PRFGEB) references an Inspection Method (QMTB) that does not exist, is obsolete, or not valid for plant. | Inspection Method | PF2/WP2 |
| 1057-001 | C1 | Invalid Inspection Characteristic | Plan characteristic (PLMK) references a Master Inspection Characteristic (QPMK) that does not exist, is inactive, or marked for deletion. | Master Insp. Characteristic | PF2/WP2 |
| 1057-002 | C1 | Inconsistent Quantitative/Qualitative Settings | Plan characteristic (PLMK-QUALI) is inconsistent with assigned MIC type (quantitative/qualitative). | Characteristic | PF2/WP2 |
| 1057-003 | C1 | Duplicate Inspection Characteristics | Inspection plan contains duplicate operation/characteristic entries (same VORNR + MERKNR). | Inspection Plan Operations/Characteristics | PF2/WP2 |
| 1064-001 | C1 | Missing Sampling Procedure | Plan characteristic (PLMK-STICHPRVER) references a Sampling Procedure (QDSV) that does not exist or is obsolete. | Sampling Procedure | PF2/WP2 |
| 2009-001 | C1 | Invalid or inactive Material Assignment in Inspection Plan | Inspection plan (MAPL) is assigned to a material/plant that does not exist or is inactive in Material Master (MARA/MARC). | Material Master | 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.
Data Privacy and Sensitivity
Not applicableExtraction
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
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| 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 Inspection Plan 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
| 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 Material Master - QM View with assigned inspection type data must be completed. 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 | Transformation Scope Definition - Identify the source and target data structures. - Define business rules for data standardization. - Establish data cleansing requirements to remove inconsistencies. | Data Team |
2 | Data Mapping and Standardization - Align source fields with target fields. - Ensure unit consistency (e.g., currency, measurement units) | Data Team |
3 | Business Rule Application - Implement data enrichment/collection if applicable - Apply conditional transformations based on predefined logic/business rules | Data Team |
4 | Transformation Execution Plan - Define batch processing schedules. - Assign responsibilities for monitoring execution. - Establish error-handling mechanisms | Syniti |
Transformation Rules
| Rule # | Source System | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
| 1 | PF2/WP2 | PLKO | PLNTY | Task List Type(Q = Inspection Plant) | S/4 HANA | PLKO | PLNTY | Task List Type(Q = Inspection Plant) | R.Default to "Q" |
| 2 | PF2/WP2 | PLKO | PLNNR | Key for Task List Group | S/4 HANA | PLKO | PLNNR | Key for Task List Group | S.Internal |
| 3 | PF2/WP2 | PLKO | PLNAL | Group Counter(Alternative) | S/4 HANA | PLKO | PLNAL | Group Counter(Alternative) | R.Internal |
| 4 | PF2/WP2 | PLKO | ZAEHL | Counter | S/4 HANA | PLKO | ZAEHL | Counter | S.Internal |
| 5 | PF2/WP2 | PLKO | DATUV | Valid-From Date | S/4 HANA | PLKO | DATUV | Valid-From Date | R.Internal |
| 6 | PF2/WP2 | PLKO | VALID_TO | Valid-to date | S/4 HANA | PLKO | VALID_TO | Valid-to date | R. Default to '31.12.9999' |
| 7 | PF2/WP2 | PLKO | AENNR | Change Number | S/4 HANA | PLKO | AENNR | Change Number | Not used |
| 8 | PF2/WP2 | PLKO | VERWE | Task List Usage | S/4 HANA | PLKO | VERWE | Task List Usage | R: In case of Inspection Type 01,05 and 08 use 5 Usage. In case of Inspection Type 89 use task list 3, in case of Inspection Type 02, 06, 10, 11, 12 use the task list 6, in case of Inspection Type 09 use the 09 Task list Rule: Step1: Join MAPL, QMAT/MARC on MATNR,WERKS, QMAT-ART(Inspection type) Setp2: If Inspection Type in 01,05 and 08 then Map usage(VERWE) = 5 If Inspection Type is 89 then Map usage(VERWE) = 3 in case of Inspection Type 02, 06, 10, 11, 12 then Map usage(VERWE) = 6 in case of Inspection Type 09 then Map usage(VERWE) = 09 |
| 9 | PF2/WP2 | PLKO | WERKS | Plant | S/4 HANA | PLKO | WERKS | Plant | R. Xref: Use xref for Plant (per mapping file) |
| 10 | PF2/WP2 | PLKO | STATU | Status | S/4 HANA | PLKO | STATU | Status | R. Only migrate Released (4) plans. Others excluded (cleansing). Default to 4 |
| 11 | PF2/WP2 | PLKO | PLNME | Task List Unit of Measure | S/4 HANA | PLKO | PLNME | Task List Unit of Measure | R.Copy from source system |
| 12 | PF2/WP2 | PLKO | LOSVN | Minimum Lot Size | S/4 HANA | PLKO | LOSVN | Minimum Lot Size | Not used |
| 13 | PF2/WP2 | PLKO | LOSBS | Maximum Lot Size | S/4 HANA | PLKO | LOSBS | Maximum Lot Size | Not used |
| 14 | PF2/WP2 | PLKO | VAGRP | Responsible Planner Group or Department | S/4 HANA | PLKO | VAGRP | Responsible Planner Group or Department | C. Xref: Use xref for VAGRP (per mapping file) |
| 15 | PF2/WP2 | PLKO | KTEXT | recipe Description | S/4 HANA | PLKO | KTEXT | recipe Description | R. Copy from Source system |
| 16 | PF2/WP2 | PLKO | TXTSP | Language Key | S/4 HANA | PLKO | TXTSP | Language Key | S.Internal |
| 17 | PF2/WP2 | PLKO | LOEKZ | Deletion Indicator | S/4 HANA | PLKO | LOEKZ | Deletion Indicator | S.Internal |
| 18 | PF2/WP2 | PLKO | QKZRASTER | Inspection Point | S/4 HANA | PLKO | QKZRASTER | Inspection Point | C. Copy from source system |
| 19 | PF2/WP2 | PLKO | QPRZIEHVER | Sample-Drawing Procedure | S/4 HANA | PLKO | QPRZIEHVER | Sample-Drawing Procedure | C. Xref: Use xref for Sample drawing procedure (per mapping file) |
| 20 | PF2/WP2 | PLKO | QDYNREGEL | Dynamic Modification rule | S/4 HANA | PLKO | QDYNREGEL | Dynamic Modification rule | C. Xref: Use xref for Dynamic modification rule (per mapping file) |
| 21 | PF2/WP2 | PLKO | QDYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | S/4 HANA | PLKO | QDYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | Not used |
| 22 | PF2/WP2 | MAPL | MATNR | Material Number | S/4 HANA | MAPL | MATNR | Material Number | R. Xref: Use xref for Material (per mapping file) |
| 23 | PF2/WP2 | MAPL | WERKS | Plant | S/4 HANA | MAPL | WERKS | Plant | R. Xref: Use xref for Plant (per mapping file) |
| 24 | PF2/WP2 | MAPL | PLNTY | Task List Type | S/4 HANA | MAPL | PLNTY | Task List Type | R. Default to "Q" |
| 25 | PF2/WP2 | MAPL | PLNNR | Key for Task List Group | S/4 HANA | MAPL | PLNNR | Key for Task List Group | S.Internal |
| 26 | PF2/WP2 | MAPL | PLNAL | Group Counter | S/4 HANA | MAPL | PLNAL | Group Counter | S.Internal |
| 27 | PF2/WP2 | MAPL | ZKRIZ | Counter for Additional Criteria | S/4 HANA | MAPL | ZKRIZ | Counter for Additional Criteria | S.Internal |
| 28 | PF2/WP2 | MAPL | ZAEHL | Counter | S/4 HANA | MAPL | ZAEHL | Counter | S.Internal |
| 29 | PF2/WP2 | MAPL | LIFNR | Supplier | S/4 HANA | MAPL | LIFNR | Supplier | C.Xref: Use xref for Supplier (per mapping file) |
| 30 | PF2/WP2 | MAPL | KUNR | Customer | S/4 HANA | MAPL | KUNR | Customer | C.Xref: Use xref for Customer (per mapping file) |
| 31 | PF2/WP2 | PLPO | VORNR | Operation | S/4 HANA | PLPO | VORNR | Operation | R. Copy from Source system Re-sequence 0010… if duplicates |
| 32 | PF2/WP2 | PLPO | PLNTY | Task List Type(Q = Inspection Plant) | S/4 HANA | PLPO | PLNTY | Task List Type(Q = Inspection Plant) | R. Default to "Q" |
| 33 | PF2/WP2 | PLPO | PLNNR | Key for Task List Group | S/4 HANA | PLPO | PLNNR | Key for Task List Group | S.Internal |
| 34 | PF2/WP2 | PLPO | PLNAL | Group Counter(Alternative) | S/4 HANA | PLPO | PLNAL | Group Counter(Alternative) | R.Internal |
| 35 | PF2/WP2 | PLPO | ZAEHL | Counter | S/4 HANA | PLPO | ZAEHL | Counter | S.Internal |
| 36 | PF2/WP2 | PLPO | ARBID | Workcenter | S/4 HANA | PLPO | ARBID | Workcenter | R : PLPO-ARBID = CRHD-OBJID that represent the Workcenter CRHD-ARBPL Xref: Use xref for Workcenter(Per mapping file) |
| 37 | PF2/WP2 | PLPO | STEUS | Control Key | S/4 HANA | PLPO | STEUS | Control Key | R: Default to "QM01" |
| 38 | PF2/WP2 | PLPO | LTXA1 | Operation Short Text | S/4 HANA | PLPO | LTXA1 | Operation Short Text | C: Copy from Source system |
| 39 | PF2/WP2 | PLPO | BMSCH | Base quantity | S/4 HANA | PLPO | BMSCH | Base quantity | R. Copy from Source system |
| 40 | PF2/WP2 | PLPO | MEINH | Unit of measure for activity | S/4 HANA | PLPO | MEINH | Unit of measure for activity | R. Copy from Source system |
| 41 | PF2/WP2 | PLPO | WERKS | Plant | S/4 HANA | PLPO | WERKS | Plant | R. Xref: Use xref for Plant (per mapping file) |
| 42 | PF2/WP2 | PLPO | LAR01 | Activity Type | S/4 HANA | PLPO | LAR01 | Activity Type | Not used |
| 43 | PF2/WP2 | PLPO | VGE01 | Unit of Measurement of Standard Value | S/4 HANA | PLPO | VGE01 | Unit of Measurement of Standard Value | Not used |
| 44 | PF2/WP2 | PLPO | VGW01 | Standard Value | S/4 HANA | PLPO | VGW01 | Standard Value | Not used |
| 45 | PF2/WP2 | PLMK | PLNTY | Task List Type(Q = Inspection Plant) | S/4 HANA | PLMK | PLNTY | Task List Type(Q = Inspection Plant) | R. Default to "Q" |
| 46 | PF2/WP2 | PLMK | PLNNR | Key for Task List Group | S/4 HANA | PLMK | PLNNR | Key for Task List Group | S.Internal |
| 47 | PF2/WP2 | PLMK | PLNKN | Node | S/4 HANA | PLMK | PLNKN | Node | S.Internal |
| 48 | PF2/WP2 | PLMK | MERKNR | Inspection Characteristic Number | S/4 HANA | PLMK | MERKNR | Inspection Characteristic Number | R. Copy; if missing, derive sequentially per operation (0001…n) |
| 49 | PF2/WP2 | PLMK | VERWMERKM | Master Inspection Characteristic | S/4 HANA | PLMK | VERWMERKM | Master Inspection Characteristic | R. Xref: Use xref for MIC (per mapping file) |
| 50 | PF2/WP2 | PLMK | KZEINSTELL | Characteristic Type | S/4 HANA | PLMK | KZEINSTELL | Characteristic Type | S.Internal |
| 51 | PF2/WP2 | PLMK | ZAEHL | Counter | S/4 HANA | PLMK | ZAEHL | Counter | S.Internal |
| 52 | PF2/WP2 | PLMK | QPMK_ZAEHL | Plant | S/4 HANA | PLMK | QPMK_ZAEHL | Plant | R. Xref: Use xref for Plant (per mapping file) |
| 53 | PF2/WP2 | PLMK | MKVERSION | Version | S/4 HANA | PLMK | MKVERSION | Version | S.Internal |
| 54 | PF2/WP2 | PLMK | KURZTEXT | Short Text for Inspection Characteristic | S/4 HANA | PLMK | KURZTEXT | Short Text for Inspection Characteristic | C. Copy from source system |
| 55 | PF2/WP2 | PLMK | PMETHODE | Inspection Method | S/4 HANA | PLMK | PMETHODE | Inspection Method | C.Xref: Use xref for Inspection Method (per mapping file) |
| 56 | PF2/WP2 | PLMK | QMTB_WERKS | Plant for Inspection Method | S/4 HANA | PLMK | QMTB_WERKS | Plant for Inspection Method | S.Internal |
| 57 | PF2/WP2 | PLMK | PMTVERSION | Version Number of Inspection Method | S/4 HANA | PLMK | PMTVERSION | Version Number of Inspection Method | S.Internal |
| 58 | PF2/WP2 | PLMK | STICHPRVER | Sampling Procedure in Inspection Characteristic | S/4 HANA | PLMK | STICHPRVER | Sampling Procedure in Inspection Characteristic | R. Xref: Use xref for Sample procedure (per mapping file) System expects a value if we have MIC |
| 59 | PF2/WP2 | PLMK | MASSEINHSW | MIC UoM | S/4 HANA | PLMK | MASSEINHSW | MIC UoM | S.Internal |
| 60 | PF2/WP2 | PLMK | SOLLWERT | Target Value | S/4 HANA | PLMK | SOLLWERT | Target Value | R.Copy from Source system |
| 61 | PF2/WP2 | PLMK | TOLERANZUN | Lower Specification Limit | S/4 HANA | PLMK | TOLERANZUN | Lower Specification Limit | R.Copy from Source system |
| 62 | PF2/WP2 | PLMK | TOLERANZOB | Upper Specification Limit | S/4 HANA | PLMK | TOLERANZOB | Upper Specification Limit | R.Copy from Source system |
| 63 | PF2/WP2 | PLMK | AUSWMENGE1 | Assigned Code Group or Selected Set | S/4 HANA | PLMK | AUSWMENGE1 | Assigned Code Group or Selected Set | R.Xref: Use xref for Code group or Selected set |
| 64 | PF2/WP2 | PLMK | AUSWMGWRK1 | Plant of the Assigned Selected Set | S/4 HANA | PLMK | AUSWMGWRK1 | Plant of the Assigned Selected Set | S.Internal |
| 65 | PF2/WP2 | PLMK | DUMMY10 | Text Line for Additional Information_1 | S/4 HANA | PLMK | DUMMY10 | Text Line for Additional Information_1 | Not used |
| 66 | PF2/WP2 | PLMK | DUMMY20 | Text Line for Additional Information_2 | S/4 HANA | PLMK | DUMMY20 | Text Line for Additional Information_2 | Not used |
| 67 | PF2/WP2 | PLMK | PLMK-DUMMY40 | Text Line for Additional Information_3 | S/4 HANA | PLMK | PLMK-DUMMY40 | Text Line for Additional Information_3 | Not used |
| 68 | PF2/WP2 | PLMK | GRENZEOB1 | First Upper Specification Limit | S/4 HANA | PLMK | GRENZEOB1 | First Upper Specification Limit | Not used |
| 69 | PF2/WP2 | PLMK | GRENZOB1NI | Value Not Initial If Set | S/4 HANA | PLMK | GRENZOB1NI | Value Not Initial If Set | Not used |
| 70 | PF2/WP2 | PLMK | GRENZEUN1 | First Lower Specification Limit | S/4 HANA | PLMK | GRENZEUN1 | First Lower Specification Limit | Not used |
| 71 | PF2/WP2 | PLMK | GRENZUN1NI | Value Not Initial If Set | S/4 HANA | PLMK | GRENZUN1NI | Value Not Initial If Set | Not used |
| 72 | PF2/WP2 | PLMK | GRENZEOB2 | Second Upper Specification Limit | S/4 HANA | PLMK | GRENZEOB2 | Second Upper Specification Limit | Not used |
| 73 | PF2/WP2 | PLMK | GRENZOB2NI | Value Not Initial If Set | S/4 HANA | PLMK | GRENZOB2NI | Value Not Initial If Set | Not used |
| 74 | PF2/WP2 | PLMK | GRENZEUN2 | Second Lower Specification Limit | S/4 HANA | PLMK | GRENZEUN2 | Second Lower Specification Limit | Not used |
| 75 | PF2/WP2 | PLMK | GRENZUN2NI | Value Not Initial If Set | S/4 HANA | PLMK | GRENZUN2NI | Value Not Initial If Set | Not used |
| 76 | PF2/WP2 | PLMK | PLAUSIOBEN | Upper Plausibility Limit | S/4 HANA | PLMK | PLAUSIOBEN | Upper Plausibility Limit | C: Copy from Source system |
| 77 | PF2/WP2 | PLMK | PLAUSIOBNI | Value Not Initial If Set | S/4 HANA | PLMK | PLAUSIOBNI | Value Not Initial If Set | S: Internal |
| 78 | PF2/WP2 | PLMK | PLAUSIUNTE | Lower Plausibility Limit | S/4 HANA | PLMK | PLAUSIUNTE | Lower Plausibility Limit | C: Copy from Source system |
| 79 | PF2/WP2 | PLMK | PLAUSIUNNI | Value Not Initial If Set | S/4 HANA | PLMK | PLAUSIUNNI | Value Not Initial If Set | S: Internal |
| 80 | PF2/WP2 | PLMK | TOLERWEIOB | Change to Upper Specification Limit | S/4 HANA | PLMK | TOLERWEIOB | Change to Upper Specification Limit | Not used |
| 81 | PF2/WP2 | PLMK | TOLWOBNI | Value Not Initial If Set | S/4 HANA | PLMK | TOLWOBNI | Value Not Initial If Set | S: Internal |
| 82 | PF2/WP2 | PLMK | TOLERWEIUN | Change to Lower Specification Limit | S/4 HANA | PLMK | TOLERWEIUN | Change to Lower Specification Limit | Not used |
| 83 | PF2/WP2 | PLMK | TOLWUNNI | Value Not Initial If Set | S/4 HANA | PLMK | TOLWUNNI | Value Not Initial If Set | S: Internal |
| 84 | PF2/WP2 | PLMK | TOLERWAB | Date from Which the Tolerance Change Is Valid | S/4 HANA | PLMK | TOLERWAB | Date from Which the Tolerance Change Is Valid | C: Rule: If PLMK-TOLERWEIOB or PLMK-TOLERWEIUN is not empty this field need to be populated; |
| 85 | PF2/WP2 | PLMK | TOLERWBIS | Date Until Which the Tolerance Change Is Valid | S/4 HANA | PLMK | TOLERWBIS | Date Until Which the Tolerance Change Is Valid | C: Rule: If PLMK-TOLERWEIOB or PLMK-TOLERWEIUN is not empty this field need to be populated; |
| 86 | PF2/WP2 | STXH | TDOBJECT | Text Object (e.g., “STKO”) | S/4HANA | STXH | TDOBJECT | Text Object (e.g., “ROUTING”) | Default to"ROUTING" |
| 87 | PF2/WP2 | STXH | TDNAME | Text Name (Combination of BOM Number + Language + Key) | S/4HANA | STXH | TDNAME | Text Name PLKO : MANDT+PLNTY+PLNNR+PLNAL+ZAEHL PLPO : MANDT+PLNTY+PLNNR+PLNKN+ZAEHL | The STXH table data will be migrated as-is from the current system to S/4HANA, with no modifications, ensuring consistency and traceability of existing records. |
| 88 | PF2/WP2 | STXH | TDID | Text ID (e.g., “ST”) | S/4HANA | STXH | TDID | Text ID: PLKO,PLPO | The STXH table data will be migrated as-is from the current system to S/4HANA, with no modifications, ensuring consistency and traceability of existing records. |
| 89 | PF2/WP2 | STXH | TDSPRAS | Language Key | S/4HANA | STXH | TDSPRAS | Language Key | The STXH table data will be migrated as-is from the current system to S/4HANA, with no modifications, ensuring consistency and traceability of existing records. |
| 90 | PF2/WP2 | STXH | TDVERSION | Version Number of Text | S/4HANA | STXH | TDVERSION | Version Number of Text | The STXH table data will be migrated as-is from the current system to S/4HANA, with no modifications, ensuring consistency and traceability of existing records. |
| 91 | PF2/WP2 | STXH | TDLOCK | Lock Indicator for Text | S/4HANA | STXH | TDLOCK | Lock Indicator for Text | The STXH table data will be migrated as-is from the current system to S/4HANA, with no modifications, ensuring consistency and traceability of existing records. |
| 92 | PF2/WP2 | STXL | CLUSTD | Text Line (Compressed) | S/4HANA | STXL | CLUSTD | Text Line (Compressed) | The STXL table data will be migrated as-is from the current system to S/4HANA, with no modifications, ensuring consistency and traceability of existing records. |
| 93 | PF2/WP2 | STXL | TDOBJECT | Text Object (Reference from STXH) | S/4HANA | STXL | TDOBJECT | Text Object (Reference from STXH) | Default to"ROUTING" |
| 94 | PF2/WP2 | STXL | TDNAME | Text Name | S/4HANA | STXL | TDNAME | Text Name | The STXL table data will be migrated as-is from the current system to S/4HANA, with no modifications, ensuring consistency and traceability of existing records. |
| 95 | PF2/WP2 | STXL | TDSPO | Text Line Sequence | S/4HANA | STXL | TDSPO | Text Line Sequence | The STXL table data will be migrated as-is from the current system to S/4HANA, with no modifications, ensuring consistency and traceability of existing records. |
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
| Plant | Mapping of legacy Plants to To-Be Plants in S/4HANA (used for PLKO/PLPO/PLMK and MAPL). |
| Work Center | Mapping of legacy Work Centers (CRHD-ARBPL) to new Work Centers in the target plant. |
| Task List Usage | Mapping of legacy Task List Usage (PLKO-VERWE) to S/4HANA usage codes (e.g., map local values to 5 – Inspection Plan). |
| Control Key | Mapping of legacy Operation Control Keys (PLPO-STEUS) to target control keys (e.g., to QM01). |
| Material Number | Mapping/normalization of Material numbers (legacy format) to the 18-char S/4 MATNR used in MAPL assignment. |
| Master Inspection Characteristic (MIC) | Mapping of legacy MICs (QPMK/QPMT: VERWMERKM/VERSION) to harmonized MIC IDs in S/4; includes merge rules for duplicates/versions. |
| Sampling Procedure | Mapping of Sampling Procedures (QDSV / QAMV-STICHPRVER) from legacy IDs to target IDs and sampling schemes. |
| Inspection Method | Mapping of Inspection Methods (QMTB/QMTT) from legacy method numbers and versions to target method IDs. |
| Unit of Measure | Mapping of UoM (PLMK-MSEHI, PLPO/PLMK qty fields) to S/4 UoM using T006; includes conversion rules/decimals. |
| Catalogs / Code Groups / Selected Sets | Mapping of QM catalogs (defect/characteristic/usage) and selected sets used in plan characteristics to target catalogs/code groups. |
| Language Texts | Mapping strategy for short & long texts (header/operation/characteristic) from legacy languages to target language keys (EN + approved translations). |
| Status | Mapping of plan status to S/4 rules (only Released = 4 migrated; others excluded). |
| Supplier | Mapping for Supplier from Legacy to S4 |
| Customer | Mapping for Customer from Legacy to S/4 |
| Responsible Planner Group or Department | Mapping of Planner group from Legacy to S/4 |
| Sample-Drawing Procedure | Mapping of Sample drawing procedure from Legacy to S/4 |
| Dynamic Modification rule | Mapping of Dynamic modification rule from Legacy to S/4 |
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
1 | Value Mappings are according to the latest design - <List of Value Mappings> | SyWay Data Team |
Pre-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Compare Data Counts |
|
Validate the mandatory fields | Validate there is value for all the mandatory fields |
Validate Primary Keys and Unique Constraints |
|
Test Referential Integrity | Confirm dependent records exist in related tables |
Accuracy
| Task | Action |
|---|---|
Validate the transformation | Validate the fields which require transformation have the value after transformation instead of the original field value |
Check Data Consistency |
|
Business
Completeness
| Task | Action |
|---|---|
Compare Data Count |
|
| Review populated templates for missing or incorrect values | Use checklists to verify completeness and correctness before submission |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Business Data Owner/s to verify that all the data in the load table/file is accurate as per endorsed transformation/ mapping rules (and signed-off DCT data). |
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 |
|---|---|---|
1 | Load Scope Definition - Identify the target system and database structure. - Define data objects (tables, fields, records) to be loaded. - Establish business rules for data validation. | Data team |
2 | Load Methodology - Specify the loading tools and technologies (Migration Cockpit, LSMW, custom loading program). | Syniti |
3 | Data Quality and Validation - Ensure data integrity checks (null values, duplicates, format validation). - Perform pre-load validations to verify completeness. - Define error handling mechanisms for load failures | Syniti |
4 | Load Execution Plan - Establish execution timelines and batch processing schedules. - Assign responsibilities for monitoring execution. - Document dependencies on other migration tasks | Syniti |
5 | Logging and Reporting - Maintain detailed logs of loading activities. - Generate summary reports on loaded data volume and quality. - Define escalation procedures for errors | Syniti |
Load Phase and Dependencies
The Inspection Plan will be loaded in the pre-cutover (PreCutover 4 phase) period.
Before loading, it will have dependency on the following configuration and data objects in the S/4 HANA.
Configuration
| Item # | Configuration Item |
| 1 | KNA1 - General Data in Customer Master |
| 2 | LFA1 - Supplier Master (General Section) |
| 3 | MARA - General Material Data |
| 4 | TCA01 - Task list types |
| 5 | T001W - Plants/Branches |
| 6 | T006 - Units of Measurement |
| 7 | TQ39A - Definition of dynamic modification level |
| 8 | QDDR - Dynamic modification rule (header) |
| 9 | QPRVK - Sample-drawing procedure |
| 10 | T412 - Task list status |
| 11 | T002 - Language Keys (Component BC-I18) |
| 12 | T024A - Planner group |
| 13 | T411 - Task list usage |
| 14 | QMTB - Inspection method master record |
| 15 | QPMK - Inspection characteristic master |
| 16 | CSLA - Activity master |
| 17 | T430 - Operation/Activity control key |
| 18 | T001W - Plants/Branches |
| 19 | TQ15 - Inspection catalog type index |
| 20 | TQ07 - Follow-Up Action for Usage Decision of Inspection Lot |
| 21 | TQ06 - Procedure for Calculating the Quality Score |
| 22 | T006 - Units of Measurement |
| 23 | TQ29A - Dependency tolerance key - nominal measurement |
| 24 | QPMK - Inspection characteristic master |
| 25 | QMTB - Inspection method master record |
| 26 | CRHD - Work Center Header |
| 27 | T430 - Operation/Activity control key |
| 28 | T024 - Purchasing Groups |
| 29 | TQ31 - Inspection Lot Origins |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| 1043 | Inspection methods (Inspection methods must exist before assignment to plan) |
| 1056 | Resources / Work Centers (needed for operations in the Inspection Plan) |
| 1057 | Master Inspection Characteristics (MICs must exist before assignment to plan) |
| 1064 | Sampling Procedures (must exist before they can be assigned in plans) |
| 2009 | Material Master (QM View must exist before Inspection Plan assignment) |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
| 1 | Material Master (QM View) does not exist for the plant/material combination | Ensure that the Material Master with QM View is created and valid before plan migration |
| 2 | Work Center not created or inactive in the assigned plant | Validate Work Center mapping and create/activate the Work Center if required |
| 3 | Sampling Procedure assigned in plan does not exist | Ensure Sampling Procedures are created and mapped correctly before assignment |
| 4 | Master Inspection Characteristic (MIC) referenced in plan does not exist or is invalid | Validate that MICs exist, are active, and correctly mapped before migration |
| 5 | Invalid or missing Task List Usage in Inspection Plan header | Update Usage assignment to valid configuration |
| 6 | Inspection method referenced in plan does not exist or is invalid | Validate that Inspection methods exist, are active, and correctly mapped before migration |
Post-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Validate Record count in the backend | Validate all tables with prefix “PLKO” has the same records as the loading file |
Display Records | Pick up a few random Inspection Plan and run t-code: QP03 to validate the Inspection Plan can be displayed without any error. |
Perform Source-to-Target Comparisons |
|
Accuracy
| Task | Action |
|---|---|
Execute Sample Queries and Reports |
|
Conduct Post-Migration Reconciliation | Generate reports comparing pre- and post-migration data. |
Business
Post-load validation is a critical step in data migration, ensuring that transferred data is accurate, complete, and functional within the target system.
1. Ensuring Data Integrity
After migration, data must be consistent with its original structure. Post-load validation checks for missing records, incorrect mappings, and formatting errors to prevent discrepancies.
2. Business Continuity
Faulty data can disrupt operations, leading to financial losses and inefficiencies. Validating post-load data ensures that applications function as expected, preventing downtime.
3. Error Detection and Resolution
By validating data post-migration, businesses can detect anomalies early, reducing the cost and effort required for corrections
Completeness
| Task | Action |
|---|---|
| Perform Source-to-Target Comparisons |
|
| Conduct Post-Migration Reconciliation | Go through reports comparing pre- and post-migration data. |
Accuracy
| Task | Action |
|---|---|
Perform Manual Testing | Conduct manual spot-checks for additional assurance. |
Key Assumptions
- Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
- Inspection Plan is in scope based on data design and any exception requested by business.
- Data cleansing has met the required percentage threshold for the specified mock cycle and all preparation activities have been completed.
- Data entries in DCT are target-ready data unless a specific transformation rule is stated for that field in the transformation rules.
See also
Change log
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||
