Issue

Currently Syensqo has multiple SAP systems (WPX, WP1 WP2 and PF1PF2), and a single real-world material can be on represented in different systems with a different Material Master number in each. As part of moving to a single new system and the associated data cleanse, a single system needs to align the material (and other transactional legacy data) so the same real-world material has the same number in the new system.. 

Recommendation

To balance global standardization with critical business constraints, Syensqo will adopt a hybrid material numbering approach (Option 3):

    • All material masters, except those belonging to the Composite Materials GBU (ZDIR: raw, semi-finished and finished products), will be assigned new material numbers from the global number range as part of the migration to S/4HANA.
    • Composite Materials will retain their legacy material numbers to avoid triggering regulatory or customer requalification processes.
    • A robust mapping and governance framework will be established to ensure seamless integration and traceability between legacy and new material numbers.

This approach enables the program to advance with standardization for the majority of materials while mitigating significant business risk for qualified Composite Materials

Recommendation

To remove/change the material master numbers across the system and align them so that the same material has the same number and is easily identifiable globally.

Background & Context

Historically Currently Syensqo has let plants maintain their own Material Master data across three different systems. This means that while Syensqo may use the same real-world physical materials across the world, a single materials may have been created under different material master numbers in each system.

This makes it hard to get a global view of the usage and availability of the same material. In addition, implementing S4 HANA as a single entity means that the same real-world materials which had different numbers in the old systems now have to be aligned to the same number in the new system.

This will have an impact on the data migration of master and transaction data to the new system and will have a change management impact on the users who will have to use a different material number for old materials. The materials in each system will need to be compared to find genuine same Real-world materials and any legacy transaction data using these materials will need to be updated with the new single material number.

This change may also cause confusion if, as expected WPX remains as a separate system. A pre-existing material is likely to have its number changed to the new standard even though the users may perceive WPX as still being a separate system.

Assumptions

• The same physical material does actually get used by the different systems
• It is feasible to identify where the same physical materials are represented differently in the systems even when the descriptions or other factors may not be identical

Constraints

multiple SAP systems (WPX, WP2 and PF2) and a single material can be represented in different systems with a different Material Master number. 

Assumptions

Qualification constraints are non-negotiable for Composite Materials within the current project timeline.

Constraints

• Regulatory product qualification processes limit immediate renumbering for Composite Materials.
• Dual numbering requires additional governance and control.
• Integration and reporting layers must accommodate both numbering strategies during the transition.

Impacts

Legacy Data – TransactionsMaster data

All dependent master data ex: BOM's etc.. will be updated with the new material numbers. 

Legacy Data – Transactions

Any historical data that is migrated to the new S/4 system will be updated with the new material numbers

Any catalogs (internal / 3rd party hosted on Ariba network) will be updated with the new material numbers

Legacy Data – Interfaces

Mappings to the customer / vendor material numbers will be updated with the new material numbers

Stock Valuation 

There might be an impact on the stock valuation when there is de-duplication of materials with different valuations

Downstream systems

Any downstream system using the material master numbers will be updated with the new material numbers or by creating a mapping table with the old and new material numbers

Change Management

Training material will describe how the users can search and find the material using the old material number

Communication

Communication will be sent to customers / vendors / 3rd party system owners using material master number 

Business Rules

• Material numbers will be system-assigned with no intelligence.
• Legacy numbers will remain traceable through mapping structures.
• Governance will ensure consistent treatment of dual numbering throughout the transition.

If we bring across legacy data from the WP1, PF1 and WPX systems then it will hold the old differing material numbers. If we do not amend the legacy data to include the new single numbering approach, then it will be invalid. Any changes will need to be applied to the legacy data.

Legacy Data – Master data

Any contracts or other master data will need to be replaced with the new material number – which for things like contracts could result in multiple contracts in the old system, with different pricing and conditions having to be aligned to a single standard.

The same applies to material master information at the Material wide level. E.g. Classification. If a material in one system mandates batches but in another system, it does not then one standard will have to be agreed on and the system aligned.

Legacy Data – Other Systems/distributed data (e.g. Ariba and Catalogs)

A new installation of Ariba could be uploaded with the new material standard without much impact. But the 400 or so Catalogs  (External and static) would need to be checked for any legacy material numbers and have these updated. Most catalog items are used to Indirect Spend and do not use Material Masters but there is the possibility that some exist and so these should be confirmed and updated.

Legacy Data – Interfaces

Any EDI Interfaces using material numbers and therefor potential mapping to customer’s or vendor’s own material numbers will need to be investigated and re-mapped.

Legacy Data – Stock Levels, Material Pricing

When aligning three material masters, their legacy stock levels and their material pricing will all need to be consolidated into a single set of stock levels and a single valuation approach. This will be a significant change from a finance point of view and will have an impact on the corporate balance sheet. Therefor this part of the migration/unification will need to be done carefully and in close coordination with Finance.

Legacy Data – 3^rd parties (Vendors and Customers)

If we change the material numbers that we order for we will need to update this with the vendors and customers or facilitate a mapping that lets them continue to use the old numbers. Mapping to the old numbers would be tricky as each new material numnber cold have up to three different old numbers and so it would be a vendor or customer specific number that would need to be mapped to.

Options considered

Option 1 – Do not change the legacy material numbers 

Materials from the legacy systems are copied into the new S/4 system without de-duplication. 

Image Added numbers – have each material replicated even if they we now have multiple versions of the same material on the new system

Advantages:

• No work required to map the materials to their new numberNo impact on legacy data
• No impact on vendors and customers as material numbers don’t change

Disadvantages:

• Significant duplication of material masters
• No global view of material data
• Duplication of material masters
• Sub optimal supply chain planning
• Incorrect inventory levels
• Incorrect Confusing and inconsistent reporting

Option 2 –

Create all valid Material Masters with new number ranges

As a part of this option, the material masters are de-duplicated, and one material master is created per valid material. The material numbers are automatically assigned by the system and are sequential with no intelligence.  

Image Added

• Clean set of de-duplicated material masters
• Optimal supply chain planning
• Correct inventory level across the globe
• Correct reporting

Disadvantages:

• Additional one-time effort for de-duplication 
• Additional one-time effort by the downstream system to adopt the new material master numbers or to incorporate a mapping table between old and new numbers

Option 3 – Hybrid Numbering Approach 

This approach recognizes the unique regulatory and qualification requirements associated with Composite Materials, where changing material numbers would directly trigger product requalification, involving both internal testing and third-party regulatory approvals.

Under this hybrid model:

• All materials except those from Composite Materials GBU (ZDIR: raw, semi-finished, finished) are assigned new S/4HANA material numbers from the global number range.
• Composite Materials retain legacy material numbers to avoid triggering requalification.
• Mapping tables are implemented to manage mixed numbering in S/4.
• All new materials created after go-live will follow the standard global numbering approach, including for Composite Materials

Advantages 

• Maintains compliance and avoids costly qualification impacts for Composite Materials.
  
• Enables global standardization for the majority of materials.
  
• Reduces overall implementation risk while maintaining project momentum.

Disadvantages  

• Increased complexity in data migration (dual numbering strategy).
• Additional effort in interface mapping and reporting structures.

Advantages:

• No effort to update and map the legacy data
• No change for the vendors and customers

Disadvantages:

• Legacy data will be inconsistent and possibly unusable
• Reports using historical data will not be compatible with the new report data
• Need to create a vendor/customer mapping of the old to new material numbers

Option 3 – Change the legacy numbers and the legacy transaction data and work with vendors and customers to use the new material numbers.

Advantages:

• Fully consistent data and reporting. Global view of availability and usage
• No need to build custom mapping for customers and suppliers

Disadvantages:

• Considerable effort to remap and test the legacy data
• Vendors and Customers will need to adapt to new system and so may result in errors or confusion

Evaluation

Based on the evaluation of the options, it Option 2 is recommended that Syensqo should aim to align the material master numbering to a single standard in the new system and also align the master and transactional data brought across to the new standard to ensure accurate reporting and information in the new system. It should also work with customers and vendors to have them also use the new single material master numbers.

Next Steps

. All Syensqo's materials (finished, semi-finished, raw materials, spares etc.) will be represented by a unique material master number which will be assigned from a new number range. For ease of search, the newly created material number will have the reference to the old material numbers. 

Factor	Option 1 - Do not change the legacy material numbers	Option 2 - Create all valid Material Masters with new number ranges	Option 3 Hybrid Numbering Approach
Alignment with project charter - Standardization and Simplification	No standardization and simplification	Aligns with the standardization and simplification principle	Achieves standardization for most materials while maintaining exceptions for qualified products.
Operational Efficiency	No Operational efficiency	Increased operation efficiency e.g. supply chain planning etc..	Standardized material base enables streamlined operations and global planning.
Reporting	In accurate / fragmented reporting	Accurate global reporting e.g. stock etc..	Accurate reporting benefits will be ensured through material cleansing and standardization
Regulatory & Qualification Impact	No renumbering avoids requalification.	Composite Materials may trigger extensive requalification effort	Hybrid approach isolates impact and avoids qualification issues while enabling progress elsewhere.
Change Impact	Low, data must still be migrated	High due to the reasons above mentioned	Focused change for most materials, with minimal impact for Composite Materials GBU.
Integration Impact	Low	One time cleansing or mapping activity in downstream systems	Dual numbering requires more complex migration mapping and processes

See also

Change log

Workflow history