Purpose

The purpose of this document is to define the conversion approach to create 1040-Production Versions in S/4 HANA.

Production Version is used to define the product data structure. Meaning PV contains Master Recipe, BOM and Resources. According with lot size, Production version can be defined for each material to be processed in several production units. Usually, all Manufacturing plants need to use Production Versions for planning and scheduling processes. The aim is to migrate all the active Prod. Versions to S/4 HANA.


Conversion Scope

The scope of this document covers the approach for converting active from Legacy Source Systems into S/4HANA following the Master Data Design Standard.

Stand alone rules

The data from legacy system includes:

  1. The migration of Production Versions will be governed by the Material Relevancy Criteria, which serve as the foundational rule for identifying and including Production Versions that are valid, active, and business-relevant for conversion to S/4HANA.
  2. All active Production Versions W/o locked status
  3. All Active Production Versions W/O Deletion Flag
  4. All active Production Versions related to active material and Plant (Mapped in the To-Be Plant Mapping)

The data from legacy system excludes:

  1. All Production Versions older more than 4 years
  2. All production versions with Locked status (This needs to be checked to approve Production versions with Locked status in CM) Data Relevancy Criteria Meeting Review
  3. All Production Versions with deletion flag
  4. All Production Versions belonging to Materials flagged for deletion
  5. All Production Versions Belonging to Material-Plant combination not existing in the To-be Plant Mapping

Relevancy for Syniti

  1. Production version creation is only relevant when the following is live and active in a sequential order
  2. Material and Plant have a live status at Plant and at a Global level and contain 4 years of process order history
  3. BOM and all BOM components are live and active at plant level Based on the condition set that Materials contain 4 years of Process order History
  4. Master Recipe is live and an active BOM is available and live at Plant level, based on the condition set that Materials contain 4 years of Process order History

Material/Plant active Red Arrow BOM and all BOM components are live and active at Plant level Red Arrow Master Recipe is live and an active BOM is available at Plant level = Creation of Production Version

Plant Merging

Plants will be defined accordingly as some plants will be merged into one plant. Plants will be defined as NEW plant codes and be transformed via a transformation table, which will be contained in Syniti.

List of source systems and approximate number of records 

SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2, WP2

Production Versions will be extracted from PF2 and WP2  

105,000S/4 HANA105,000

Additional Information

Multi-language Requirement

N/A

Document Management

N/A

Legal Requirement

N/A

Special Requirements

N/A




Target Design

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirement
MKALMKAL‑MANDTMANDTClientCLNT3S
MKALMKAL‑WERKSWERKS_DPlantCHAR4R
MKALMKAL‑MATNRMATNRMaterial NumberCHAR18R
MKALMKAL‑TEXT1VERS_TEXTVersion Short DescriptionCHAR40R - max. Of 40 characters.
MKALMKAL‑VERIDVERIDProduction VersionCHAR4C - 4 digits
MKALMKAL-MKSPMKSPProduction Version LockCHAR1R- "No locked" as default
MKALMKAL‑ADATUADATMValid‑From DateDATS8R
MKALMKAL‑BDATUBDATMValid‑To DateDATS8R
MKALMKAL‑BSTMISA_LOSVNMin Lot‑Size Interval Lower LimitQUAN13R
MKALMKAL‑BSTMASA_LOSBSLot‑Size Interval Upper LimitQUAN13R
MKALMKAL‑STLALSTALTAlternative BOMCHAR2R
MKALMKAL‑STLANSTLANBOM UsageCHAR1R = BOM usage = "1" - Production
MKALMKAL‑PLNTYPLNTYTask List TypeCHAR1R
MKALMKAL‑PLNNRPLNNRTask List GroupCHAR8R
MKALMKAL‑ALNALPLNALGroup CounterCHAR2R
MKALMKAL‑PLTYGPLTYGTask List Type for Rate‑based PlanningCHAR2R
MKALMKAL‑SERKZSA_VERSIRepetitive Mfg AllowedCHAR1NU
MKALMKAL‑MDV01SA_LINE1Production LineCHAR8NU
MKALMKAL‑MDV02MDVPlanning IdentificationCHAR8NU
MKALMKAL‑MATKOMATKOOther Material (BOM+Routing maintained)CHAR40NU
MKALMKAL‑VERTOSA_VERTODistribution KeyCHAR4NU
MKALMKAL‑ALORTALORTRepetitive Mfg Storage Loc.CHAR4NU
MKALMKAL‑EWM_LGNUMLGNUMWarehouse Number (EWM)CHAR4NU
MKALMKAL‑EWM_LGPLALGPLADestination Storage Bin (EWM)CHAR4NU
MKALMKAL‑PRVBESA_PRVBETarget PSACHAR10NU
MKALMKAL‑ELPROSA_ELPROProposed Issue Storage LocationCHAR4NU
MKALMKAL-TSA_PRVBETSA_PRVBEDefault Supply AreaCHAR10NU
MKALMKAL-UCMATVBOB_OB_RFMATOB reference materialCHAR40NU


Data Cleansing

Business will perform data cleansing in the current ECC system. This means ECC will serve as the single source of truth for Manufacturing Data prior to the migration to S/4HANA.

IDCriticalityError Message/Report DescriptionRuleOutputSource System
1040-001C1Invalid, Inactive or no Master Recipe for the Plant/ Material CombinationMaster recipe needs to be created as pre-requisite to create Prod. Versions. Master RecipePF2/WP2
1040-001C1Invalid, Inactive or no Bill of Material for the Plant/ Material CombinationBill of Material needs to be created as pre-requisite to create Prod. Versions. Bill of MaterialsPF2/WP2
1040-004C1BOM Alternative Missing / incorrect.BOM alternative is missing/ incorrectBOM AlternativePF2/WP2
1040-005C2Master Recipe Group Missing / IncorrectMaster Recipe Group Counter is needed. Master Recipe Group CounterPF2/WP2
1040-006C1BOM usage 1 / Routing type 2 / Master RecipeOnly BOM usage 1 and Routing type 2 or Master Recipe are valid for creating the Production VersionBOM Type 1 / Routing type 2 / Master Recipe categoryPF2/WP2
1040-008C1Production Version has status lockedAll Production Versions with status Locked, won't be migratedPV Status LockedPF2/WP2
1040-009C1Production Version NOT used the last 4 yearsBy rule, all Production Version with no Usage during the last 4 years won't be migratedActive PVPF2/WP2
1040-012C1PV with master recipe flagged for deletionPV with a Master recipe flagged for deletion, won't be migratedMaster Recipe deletion FlagPF2/WP2
1040-013C1PV With BOM flagged for deletionPV with a BOM flagged for deletion, won't be migratedBOM deletion flagPF2/WP2



Conversion Process

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

image-2025-7-1_15-31-3.png


Data Privacy and Sensitivity


Extraction

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

  1. The data exists. connects to the source and loads the data into . 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 ; 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 . This is to be conducted using DCT (Data Collection Template) in

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
1Extract data from source system based on relevancy ruleData Team
2Google Sheet report pre-populated with PF2 and WP2 information to be generated based on relevancy criteria. Data Team
3Sinity Extraction in SQL / Excel to check the resultSinity/ Data Team


Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















Data Collection Template (DCT)

Target Ready Data Collection Template will be created for1040 - Production Version data with exception of some fields which require transformation as mentioned in the transformation rule. 

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 Production Version 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. DCT Rules

Field NameField DescriptionRule



Extraction Dependencies

Item #Step DescriptionTeam Responsible
1

Source System Availability

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

Syensqo IT

2

Data Structure

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

Syniti

3

Referential Integrity

  • Ensure dependent records are extracted together.

Syniti

4

Extraction Methodology

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

Syniti


5

Performance and Scalability Considerations

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

Syniti

6

Security and Compliance

  • Adhere to regulatory standards for sensitive information if applicable

Syniti

7

Data cleansing of legacy Production Version -

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

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2MKALWERKSPlantS4 HANAMKALWERKSPlantMap from Old Plants to New Plants
2PF2MKALMATNRMaterial NumberS4 HANAMKALMATNRMaterial NumberGenerate new Material number in Target System and maintain mapping in reference table
3PF2MKALTEXT1Version Short DescriptionS4 HANAMKALTEXT1Version Short DescriptionValue Direct from the current system
4PF2MKALVERIDProduction VersionS4 HANAMKALVERIDProduction VersionValue Direct from the current system - BASED on conditions
5PF2MKALMKSPProduction Version LockS4 HANAMKALMKSPProduction Version Lock"Blank - Not locked"
6PF2MKALADATUValid‑From DateS4 HANAMKALADATUValid‑From DateDetermines the effective period for BOM and master recipe. Date will be set on creation
7PF2MKALBDATUValid‑To DateS4 HANAMKALBDATUValid‑To DateDefault 31129999
8PF2MKALBSTMIMin Lot‑Size Interval Lower LimitS4 HANAMKALBSTMIMin Lot‑Size Interval Lower LimitValue Direct from the current system
9PF2MKALBSTMALot‑Size Interval Upper LimitS4 HANAMKALBSTMALot‑Size Interval Upper LimitValue Direct from the current system
10PF2MKALSTLALAlternative BOMS4 HANAMKALSTLALAlternative BOMDetermined by the BOM master if the BOM exists. Auto generated when the BOM is created.
11PF2MKALSTLANBOM UsageS4 HANAMKALSTLANBOM UsageR = BOM usage = "1" - Production
12PF2MKALPLNTYTask List TypeS4 HANAMKALPLNTYTask List TypeDefault to "2"
13PF2MKALPLNNRTask List GroupS4 HANAMKALPLNNRTask List GroupDerived from the creation of master recipe (internally generated when the Recipe is created)
14PF2MKALALNALGroup CounterS4 HANAMKALALNALGroup CounterSequential 1,2,3,4 etc when the master recipe is created (Internally generated when the Recipe is created)
15PF2MKALPLTYGTask List Type for Rate‑based PlanningS4 HANAMKALPLTYGTask List Type for Rate‑based PlanningTask List Type = "2" 


Transformation Mapping

Mapping Table NameMapping Table Description
PlantMapping of legacy Plants to new Plants to target system value
MaterialMapping of legacy Materials to New Material number

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible

1

Ensure DCT tables completeness

SyWay Data Team

2

Value Mappings are according to the latest design - <List of Value Mappings>

SyWay Data Team


Pre-Load Validation

Project Team

Completeness

TaskAction

Verify Record Count 

Data team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets.


Accuracy

TaskAction

Conversion Accuracy

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 reports

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

Business team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets.


Accuracy

TaskAction

Conversion Accuracy

Business  to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules (and signed-off data) 


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
1Go to <Load Tool>SyWay Data Team
2Load 3 records for < > to validate if data is loaded successfully without errorsSyWay Data Team
3Proceed with full load if steps 2 and 3 are validatedSyWay Data Team
4Validate few records loaded by accessing standard transactions from S/4HNA eg. MDO4SyWay Data Team
5Generate post load report if step 5 is validatedSyWay Data Team


Load Phase and Dependencies

Configuration

Item #Configuration Item
1T001W - Plants/Branches
2MARC/MARA - Material Number connected to a Plant
3TCA01 - Task List Type

Conversion Objects

Object #Preceding Object Conversion Approach
2019Materials - Basic Data View and Plant view
10381038 Material BOM
10391039 Master Recipe

Error Handling

Error TypeError DescriptionAction Taken
1Material has not been created in a PlantEnsure the Material mapping is correct and or create the Material if it is valid
2Material BOM has not been created in a PlantMakes sure the BOM is available in the Plant, if not check to make sure it is required or Create the BOM for the PV Material
3Master Recipe has not been created in a PlantMakes sure the Master Recipe is available in the Plant, if not check to make sure it is required or Create the Master Recipe for the PV Material


Post-Load Validation

Project Team

Completeness

TaskAction

Verify Count

Data team to verify the record count created in target S/4 HANA by accessing post load reports in Sinity Migrate or standard reports from S/4 HANA.

Verify Logs

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


Accuracy

TaskAction

Conversion Accuracy

Data team to verify that the Measuring Point data in target S/4 HANA were loaded correctly via Sinity Migrate post load reports or standard reports from S/4 HANA. 


Business

Completeness

TaskAction

Verify Count

Download Post Load Reports from Sinity Migrate and verify that the record count loaded in the target S/4 HANA is the same count as of the endorsed load file.


Accuracy

TaskAction

Conversion Accuracy 

Verify that the Measuring Point data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA.


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

Version Published Changed By Comment
CURRENT (v. 35) Apr 29, 2026 14:28 ULLAH-ext, Colin
v. 52 Apr 28, 2026 10:00 ULLAH-ext, Colin
v. 51 Apr 27, 2026 10:28 ULLAH-ext, Colin
v. 50 Apr 27, 2026 09:19 ULLAH-ext, Colin
v. 49 Apr 20, 2026 14:07 ULLAH-ext, Colin
v. 48 Apr 14, 2026 11:21 ULLAH-ext, Colin
v. 47 Mar 18, 2026 16:02 ULLAH-ext, Colin
v. 46 Mar 12, 2026 16:03 ULLAH-ext, Colin
v. 45 Mar 12, 2026 15:32 ULLAH-ext, Colin Updated DCT Fields STLAN and PLTYG
v. 44 Feb 24, 2026 10:50 ULLAH-ext, Colin

Go to Page History

Workflow history

Title Last Updated By Updated Status  
There are no pages at the moment.