You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

Status

  Lead Approval

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create Equipment in S/4 HANA.

Legacy Equipment are using a diverse range of formats across the different systems. There are instances where the same Equipment are duplicated within and across sources, with informal words. This results in data inconsistency. As per SyWay design, EAM Equipment will be standardized.


Conversion Scope

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

In Syensqo’s SAP S/4HANA landscape, Equipment is used to define an individual asset or a sub-component of an asset. Each Equipment record represents a maintainable unit, serving as a critical master data for executing maintenance and work management processes.

Depending on its installation context, Equipment can be categorized as either a Static asset or a rotable part which can be dismantled and installed at a different location. Regardless of its type, every piece of Equipment is installed at a relevant superior Functional Location, ensuring its position within the asset hierarchy is clearly defined.
This structured approach supports efficient maintenance planning, traceability, and lifecycle management of assets across Syensqo’s operations.

The data from legacy system includes:

  • Equipment having Maintenance Plant (IFLOT-WERKS) in scope (Value Mapping : Plant, where Maintenance Plant = 'Yes')
  • Functional Locations to be migrated as Equipment as part of Inclusion List (EXC-Functional Location_ID)

The data from legacy system excludes:

  • Equipment with System Status (JEST-STAT) = Inactive 'INAC'
  • Equipment with System Status (JEST-STAT) = Deletion Flag 'DLFL'
  • Equipment with System Status (JEST-STAT) = In the warehouse 'ESTO'
  • Equipment with System Status (JEST-STAT) = Available 'AVLB'
  • Equipment with System Status (JEST-STAT) <> Installed 'INST'
  • Equipment with Serial Number (EQUI-SERNR) <> '' (BLANK)

List of Tables to extract for this object is maintained here: Extract Table Register.


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2, WP2

Active Equipment will be extracted from PF2 and WP2

60,347S/4HANA60,347

DCT

1. Additional Functional Location to be created as Equipment
2. Any other Equipment in the site not created as equipment

TBD

S/4HANA

TBD

Additional Information

Multi-language Requirement

Equipment description will be made available in English.

Multi language is supported for Equipment. Login via a different language will have its description displayed in the logon language if the language key is maintained in the Equipment.

Document Management

  1. <Types of documents> documents currently attached to Equipment will be migrated to <TBD>.
  2. Refer to the conversion approach for <TBD>.

Legal Requirement

Not Applicable

Special Requirements

Not Applicable



Target Design

EAM Equipment Data strictly adheres to the Master Data Standard. The complete information of the key fields that hold the Equipment information follows the Master Data Standard document DD-FUN- 050 Master Data Standard Equipment.xlsx.

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirement






















Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System
1002-001C1Invalid, Inactive or no Cost Centres linked to EquipmentEquipment as per Relevancy Criteria assigned with a Cost Centre which does not belong below:
1. Cost Centre (FI) as per Relevancy Criteria
Cost CentrePF2, WP2
1002-002C1Invalid or Inactive Business Partner (Customer) linked to EquipmentEquipment as per Relevancy Criteria assigned with a Business Partner / Customer (Partner) which does not belong below:
1. Business Partner FLCU01 (SD) as per Relevancy Criteria
Business Partner (Customer)PF2, WP2
1002-003C1Invalid or Inactive Business Partner (Vendor) linked to EquipmentEquipment as per Relevancy Criteria assigned with a Business Partner / Customer (Partner) which does not belong below:
1. Business Partner / Vendor (S2P) as per Relevancy Criteria
Business Partner (Vendor)PF2, WP2
1002-004C1Invalid, Inactive or no Characteristic linked to EquipmentEquipment as per Relevancy Criteria assigned with a Characteristic which does not belong below:
1. Characteristic as per Relevancy Criteria
CharacteristicPF2, WP2
1002-005C1Invalid, Inactive or no Class linked to EquipmentEquipment as per Relevancy Criteria assigned with a Class which does not belong below:
1. Class as per Relevancy Criteria
ClassPF2, WP2
1002-006C1Invalid, Inactive or no Construction Type linked to EquipmentEquipment as per Relevancy Criteria assigned with a Construction Type which does not belong below:
1. Construction Type as per Relevancy Criteria
Construction TypePF2, WP2
1002-007C1Invalid or Inactive Document Info Record linked to EquipmentEquipment as per Relevancy Criteria assigned with a Document Info Record which does not belong below:
1. Document Info Record as per Relevancy Criteria
Document Info RecordPF2, WP2
1002-008C1Invalid, Inactive or no Fixed Asset linked to EquipmentEquipment as per Relevancy Criteria assigned with a Fixed Asset which does not belong below:
1. Fixed Asset (FI) as per Relevancy Criteria
Fixed AssetPF2, WP2
1002-009C1Invalid, Inactive or no Work Centre linked to EquipmentEquipment as per Relevancy Criteria assigned with a Work Centre which does not belong below:
1. Work Centre as per Relevancy Criteria
Work CentrePF2, WP2
1002-010C1Invalid, Inactive or no WBS linked to EquipmentEquipment as per Relevancy Criteria assigned with a WBS which does not belong below:
1. Work Breakdown Structure (PS) as per Relevancy Criteria
Work Breakdown StructurePF2, WP2
1002-011C1Invalid, Inactive or no Functional Location linked to EquipmentEquipment as per Relevancy Criteria assigned with a Functional Location which does not belong below:
1. Functional Location as per Relevancy Criteria
Functional LocationPF2, WP2
1002-012C1Invalid, Inactive or no Maintenance Plans linked to EquipmentEquipment as per Relevancy Criteria with no Maintenance Plan Linked or with a Maintenance Plan which does not belong below:
1. Maintenance Plan as per Relevancy Criteria
Maintenance PlanPF2, WP2
1002-013C1Invalid or no Planner Group linked to EquipmentEquipment as per Relevancy Criteria with no Planner Group Assigned or Invalid Planner Group (T024I)Planner GroupPF2, WP2
1002-014C1Invalid or no Technical Object Type linked to EquipmentEquipment as per Relevancy Criteria with no Technical Object Type Assigned or Invalid Technical Object Type (T370K)Technical Object TypePF2, WP2
1002-015C2Maintaiable physical assets not created in the SAP systems
EquipmentPF2, WP2
1002-016C1Review all Functional Location / Equipment sitting under 'DLFL' or 'DLT'
If these data set is not used / not needed, the system status should be set to INAC.

System StatusPF2, WP2
1002-017C3Duplicate Equipment by Manufacturer, Model, Serial NumberEquipment as per Relevancy Criteria where there is more than one Manufacturer + Model + Serial Number Combination.Manufacturer, Model, Serial NumberPF2, WP2
1002-018C1Invalid, Inactive or no Material linked to EquipmentEquipment as per Relevancy Criteria assigned with a Material which does not belong below:
1. Material Master (S2P) as per Relevancy Criteria
MaterialPF2, WP2
1002-019C2Material Types of Construction Types are non-Maintenance AssemblyEquipment as per Relevancy Criteria where the Construction Type Assigned has a non-Maintenance Assembly Material Type*
QF2: ZZ90-Maintenance Assembly
WQ2: ZIBA-Maintenance Assembly
Construction TypePF2, WP2
1002-020C1Missing Equipment DescriptionsEquipment as per Relevancy Criteria where there are blank Equipment Descriptions.Equipment DescriptionPF2, WP2
1002-021C2Equipment Descriptions with Informal WordsEquipment as per Relevancy Criteria which contain [Informal Words] in the Equipment DescriptionEquipment DescriptionPF2, WP2
1002-022C1ABC Indicator missing on EquipmentEquipment as per Relevancy Criteria where ABC Indicator is blankABC IndicatorPF2, WP2
1002-023C1Equipment Company Code incorrect.Equipment as per Relevancy Criteria with Invalid Company Code (T001)Company CodePF2, WP2
1002-024C1Equipment Technical object authorization group incorrect.Equipment as per Relevancy Criteria with Invalid Authorization Group (T370F)Authorization GroupPF2, WP2
1002-025C2Equipment Planning Plant and Maintenance Plant are not the same.Equipment as per Relevancy Criteria with Planning Plant <> Maintenance PlantMaintenance Plant, Planning PlantPF2, WP2
1002-026C1ABC Indicator missing on EquipmentEquipment as per Relevancy Criteria where ABC Indicator is blankABC IndicatorPF2, WP2



Conversion Process

Conversion will involve both Source System Extraction as well as using DCT (Data Collection Template) - 

The high-level process for Source System Extraction is represented by the diagram below:

image-2025-6-9_14-37-29.png


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:

image-2025-6-11_16-37-32.png

Data Privacy and Sensitivity

<To add more info later if applicable>


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 ruleSyWay Data Team
2Google Sheet report pre-populated with PF2 and WP2 information to be generated based on relevancy criteria. SyWay Data Team


Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
Not Applicable



















Data Collection Template (DCT)

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

DCT Rules

Field NameField DescriptionRule
TPLNR_HISLEGACY FUNCTIONAL LOCATION
EQUNR_HISLEGACY EQUIPMENT NUMBER
ITOB-DATABVALID FROM
EQUI-EQTYPEQUIPMENT CATEGORY
EQKT-EQKTXDESCRIPTION
EQKT-SPRASLANGUAGE KEY
EQUI-EQARTOBJECT TYPE

Assign Object Type for selected Functional Locations include in the mapping

EQUI-BEGRUAUTHORISATION GROUP 
EQUI-BRGEWWEIGHT
EQUI-GEWEIWEIGHT UNIT
EQUI-GROESSIZE/DIMENSION
EQUI-INVNRINVENTORY NUMBER
EQUI- INBDTSTART-UP DATE
EQUI-ANSWTACQUISITION VALUE
EQUI-WAERSCURRENCY KEY
EQUI-ANSDTACQUISITION DATE
EQUI-HERSTMANUFACTURER
EQUI-HERLDMANUFACTURER COUNTRY
EQUI-TYPBZMODEL NUMBER
EQUI-BAUJJCONSTRUCTION YEAR
EQUI-BAUMMCONTRUCTION MONTH
EQUI-MAPARMANUFACTURERS PART NUMBER
EQUI-SERGEMANUFACTURERS SERIAL NUMBER
ILOA-SWERKMAINTENANCE PLANT
ILOA-BEBERPLANT SECTION
ARBPLWORK CENTER
ILOA-ABCKZABC INDICATOR
ILOA-EQFNRSORT FIELD
ILOA-ANLNRASSET
ILOA-KOSTLCOST CENTER
EQUZ-IWERKPLANNING PLANT
EQUZ-INGRPPLANNER GROUP
EQUZ-GEWRKMAIN WORK CENTER
WERKMAIN WORK CENTER PLANT
EQUZ-RBNRCATALOG PROFILE
TPLMA_HISLEGACY FUNCTIONAL LOCATION
HEQUI_HISLEGACY SUPERORDINATE EQUIPMENT
ITOB-POSNRPOSITION
EQUZ-TIDNRTECHNICAL ID NUMBER
EQUZ-SUBMTCONSTRUCTION TYPE
EQUI-KMATN

DEL_FLAGDELETION
Alternate Language

SPRAS_ALTLANGUAGE KEY
OBJTX_ALTSHORT TEXT
DEL_LANGDELETION

Extraction Dependencies

Item #Step DescriptionTeam Responsible

1

Ensure Syniti has the necessary connection and access to legacy servers 

Data

2

Ensure that the necessary cleansing activities in legacy sources are complete 

Data / Business 

3

Ensure that create, change and deletion of master data is freeze in legacy Production system 

Legacy IT





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

1

Obtain DCT Sign-off from Business

SyWay A2D Data Team

2

<Add steps from Syniti Migrate here>

SyWay A2D Data Team

3

Review and Validate Error and Preload Reports

SyWay A2D Data Team

4

Generate Load Files

SyWay A2D Data Team


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic









































Transformation Mapping

Mapping Table NameMapping Table Description
EXC-Functional Location_IDFunctional Locations (Lowest Level) to be created as Equipment. To be compiled based on manual Review (Initial List Low-Level Functional Location). This will be an inclusion for Equipment.






Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Ensure DCT tables completenessSyWay A2D Data Team
2Value Mappings are according to the latest design - <List of Value Mappings>SyWay A2D Data Team







Pre-Load Validation

Project Team

Completeness

TaskAction
Verify Record CountSyWay A2D Data Team to verify that the total number of relevant records from the Source Extract and DCT is equal to the total number of records in the Preload and Load Sheets.

Accuracy

TaskAction
Conversion Accuracy

SyWay A2D Data Team to verify that all fields below meet pass the checks:

  1. Mandatory Fields
  2. Field and Value Mapping Correctness
  3. Null Checks
  4. Text Length Checks
Review Error ReportsReview and correct the errors.  Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data.

Business

Completeness

TaskAction
Verify Record CountBusiness Data Owner/s to verify that the total number of relevant records from the Source Extract and DCT is equal to the total number of records in the Preload and Load Sheets.

Accuracy

TaskAction
Conversion AccuracyBusiness Data Owner/s to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules (and signed-off Source Extract & DCT 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













Load Phase and Dependencies

Configuration

Item #Configuration Item
1

Equipment Category

2

Technical Object Type

3

Weight Unit

4

Currency

5

Country of manufacturer

6

Maintenance Plant and Planning Plant

7

Plant Section

8

Planner Group

9

ABC indicator

10

Catalog Profile 

Conversion Objects

Object #Preceding Object Conversion Approach
1003Functional Location

Error Handling

Error TypeError DescriptionAction Taken

Configuration

Equipment cat missing

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Object Type

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Weight Unit

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Currency

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Country of Manufacturer

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Maintenance Plant

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Plant Section

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid ABC indicator

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Planning Plant

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid Planner Group

Engage Functional team to expedite and fix the error in the system

Configuration

Invalid catalog profile

Engage Functional team to expedite and fix the error in the system

Invalid Data

Invalid Cost Centre 

Expedite whether the master data is changed in the system

Invalid Data

Invalid Class

Expedite whether the master data is changed in the system

Invalid Data

Invalid Production Work Centre

Expedite whether the master data is changed in the system

Invalid Data

Invalid Maintenance Work Centre

Expedite whether the master data is changed in the system

Invalid Data

Invalid Assembly

Expedite whether the master data is changed in the system


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 dspMigrate 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 dspMigrate post load reports or standard reports from S/4 HANA. 






Business

Completeness

TaskAction

Verify Count

Download Post Load Reports from dspMigrate 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.
  • Equipment is in scope based on data design and any exception requested by business.
  • All data cleansing and preparation has been completed.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 9) Apr 22, 2026 15:51 PUN-ext, Eddy
v. 165 Apr 22, 2026 14:24 PUN-ext, Eddy
v. 164 Apr 22, 2026 14:11 PUN-ext, Eddy
v. 163 Apr 22, 2026 14:09 PUN-ext, Eddy
v. 162 Apr 22, 2026 14:07 PUN-ext, Eddy
v. 161 Apr 22, 2026 14:05 PUN-ext, Eddy
v. 160 Apr 22, 2026 13:48 PUN-ext, Eddy
v. 159 Apr 22, 2026 13:43 PUN-ext, Eddy CR0446
v. 158 Apr 22, 2026 13:22 PUN-ext, Eddy
v. 157 Apr 14, 2026 15:30 JOSHI-ext, Aditya

Go to Page History

Workflow history

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

  • No labels