Purpose

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

In SAP Plant Maintenance (SAP S4/HANA EAM), a piece of equipment is an individual object that is to be maintained independently. Each piece of equipment is managed independently in the system, so that you can: 

  • Manage individual data from a maintenance perspective for the object

  • Perform individual maintenance tasks for the object

  • Keep a record of the maintenance tasks performed for the object

  • Collect and evaluate data over a long period of time for the object

As per Syensqo's design, all maintainable asset will be represented by Equipment, with the exception where the asset is maintained by Syensqo but not owned, in which case the asset will be migrated as a Functional Location. As per SyWay design, EAM Equipment will be standardized.


Conversion Scope

The scope of this document covers the approach for creation of Equipment in 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. An Equipment is defined based on its construction and a defined Maintenance strategy is followed by to ensure its Reliability and sustainability.

An Equipment is only created when there is a defined Maintenance Strategy defined for it and a criticality derived from Risk Assessment process.

Depending on its installation context, Equipment is categorized by a user status to define its current state in its lifecycle from Planning to Retire. Every piece of Equipment that is Inservice is installed at a relevant superior Asset Functional Location or superior Equipment, 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.

Conversion from legacy will adopt a hybrid method: Extraction and DCT for migration.

  • Extraction to include all active Equipment, as well as the specific Functional Locations identified for migration as Equipment.
  • Data Construct Template to capture all relevant assemblies and materials linked to the below objects, as confirmed by the Business, for migration as Equipment. 
    • Maintenance Item (Assembly field)

    • Maintenance Item (Object List for Material)

    • Notification (Assembly field)

    • Work Order (Assembly field)

    • Work Order (Object List for Material)

    • Equipment (Construction Type)

Equipment in Syensqo to-be asset structure will be positioned under the Category 'A' (Asset) Functional Location and will comprise of 2 levels. 

Level

Technical Object

Function/ Meaning

Equipment Level 1EquipmentMaintainable Item / Class (Primary maintainable unit)
Equipment Level 2EquipmentMaintainable Item / Component (sub-equipment)

Note: Please refer CNV-1003 Function Location for details on the Functional Location Asset Level conversion. 


The data from legacy system includes:

  • Equipment (EQUI-EQUNR) having Maintenance Plant (EQUI-WERKS) in scope (Value Mapping : Plant, where Maintenance Plant = 'Yes')
  • Functional Locations (IFLOT-TPLNR) to be migrated as Equipment as part of mapping (Functional Location, where New Technical Object = 'EQ')
  • Equipment Long Text in Inclusion-EQ Long Text
  • Functional Location Long Text in Inclusion-FL_EQ Long Text

The data from legacy system excludes:

  • Equipment (EQUI-EQUNR) with System Status (JEST-STAT) = Inactive 'INAC'
  • Equipment (EQUI-EQUNR) with System Status (JEST-STAT) = Deletion Flag 'DLFL'
  • Equipment (EQUI-EQUNR) with System Status (JEST-STAT) = In the warehouse 'ESTO'
  • Equipment (EQUI-EQUNR) with System Status (JEST-STAT) = Available 'AVLB'
  • Equipment (EQUI-EQUNR) with System Status (JEST-STAT) <> Installed 'INST'
  • Equipment (EQUI-EQUNR) 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

Relevant Equipment will be extracted from PF2 and WP2

400,000S/4HANA400,000
PF2, WP2

Functional Location flagged to be migrated as Equipment will be extracted from PF2 and WP2

30,000S/4HANA30,000

DCT

  1. Assemblies to be created as Equipment
  2. Equipment for plants which do not have data existing from PF2 and WP2

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

Refer to the KDD085 - Document Management in the SyWay Solution

Note: Documents attached to Equipment will be migrated as part of 9104-EAM Attachments.

Legal Requirement

Not Applicable

Special Requirements

Not Applicable


Target Design

The technical design of the target for this conversion approach.

1. Equipment Master

TableFieldData ElementField DescriptionData TypeLengthRequirement
EQUIEQUNREQUNREquipment NumberCHAR18

System

Key Field

EQUIEQTYPEQTYPEquipment CategoryCHAR

1

Mandatory
EQUIEQARTEQARTTechnical Object TypeCHAR10Mandatory
EQUIBRGEWBRGEWWeightQUAN13Conditional
EQUIGEWEIGEWEIUnit of WeightUNIT3Conditional
EQUIINVNRINVNRInventory NoCHAR25Conditional
EQUIINBDTINBDTStart-up dateDATS8Conditional
EQUIANSWTANSWTAcquisition ValueNUMC13Conditional
EQUIWAERSWAERSCurrencyCUKY5Conditional
EQUIHERSTHERSTManufacturerCHAR30Conditional
EQUITYPBZTYPBZModel NumberCHAR20Conditional
EQUISERGESERGEManufacturer Serial NumberCHAR30Conditional
EQUIHERLDHERLDCountry/Region of ManufactureCHAR3Conditional
EQUIBAUJJBAUJJYear of constructionCHAR4Conditional
EQUIBAUMMBAUMMMonth of ManufactureCHAR2Conditional
EQUZDATABDATABValid-From DateDATS8Mandatory
EQUZIWERKIWERKMaintenance Planning PlantCHAR4Mandatory
EQUZINGRPINGRPPlanner Group CHAR3Conditional
EQUZGEWRKGEWRKMain work centerCHAR8Conditional
EQUZWERGWWERGW

Plant associated with main work center

CHAR4Conditional
EQUZHEQUIHEQUISuperordinate EquipmentCHAR18Conditional
EQUZSUBMTSUBMTConstruction typeCHAR40Mandatory
ILOAABCKZABCKZABC IndicatorCHAR1Mandatory
ILOATPLNRTPLNRFunctional LocationCHAR30Conditional
ILOASWERKSWERKMaintenance PlantCHAR4Mandatory
ILOABEBERBEBERPlant SectionCHAR3Mandatory
ILOAEQFNREQFNRSort FieldCHAR30Mandatory
ILOABUKRSBUKRSCompany CodeCHAR4Mandatory
ILOAKOSTLKOSTLCost CenterCHAR10Mandatory
ILOAKOKRSKOKRSControlling AreaCHAR4Mandatory
ADRCNAME1NAME1Name 1CHAR40Conditional
ADRCNAME2NAME2Name 2CHAR40Conditional
ADRCNAME3NAME3Name 3CHAR40Conditional
ADRCNAME4NAME4Name 4CHAR40Conditional
ADRCCOUNTRYCOUNTRYCountry/Region KeyCHAR3Conditional


2. Equipment Short Text

TableFieldData ElementField DescriptionData TypeLengthRequirement
EQKTSPRASSPRASLanguage KeyLANG1Mandatory
EQKTEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

EQKTPLTXTPLTXTDescription of EquipmentCHAR40Mandatory

Note: Each Equipment must have 1 entry for English language and 1 entry for the language(s) of the country in which each Maintenance Plant assigned is located (French, Italian, Mandarin, Brazilian Portuguese, German or Spanish). 


3. Equipment Classification (Header)

TableFieldData ElementField DescriptionData TypeLengthRequirement
KSSKKLARTKLARTClass TypeCHAR20Mandatory
KSSKOBTABOBTABName of Database Table for ObjectCHAR30Mandatory
KSSKCLASSNUMCLASSNUMClass NameCHAR30Mandatory
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

KSSKSTATUSTATUClassification StatusCHAR80Mandatory


 4. Equipment Classification (Characteristics Value Allocation)

TableFieldData ElementField DescriptionData TypeLengthRequirement
CABN

ATNAM

ATNAM

Characteristic NameCHAR30Mandatory
AUSPPOSNRPOSNR Item NumberCHAR3Mandatory
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

AUSPATFLVATFLVNumerical Value - From NUMC16Conditional
AUSPATFLBATFLBNumerical Value - ToNUMC16Conditional
AUSPATCODATCODCode for Value DependencyCHAR1Conditional
AUSPDATE_FROMDATE_FROMLower Boundary for Date - IntervalDATS8Conditional
AUSPDATE_TODATE_TOUpper Boundary for Date - IntervalDATS8Conditional
AUSPTIME_FROMTIME_FROMLower Boundary for Time - IntervalTIMS6Conditional
AUSPTIME_TOTIME_TOUpper Boundary for Time - IntervalTIMS6Conditional
AUSPATFLVATFLVCurrency Value - From (Floating Point)NUMC16Conditional
AUSPATFLBATFLBCurrency Value - To (Floating Point)NUMC16Conditional
AUSPCURRENCYCURRENCYCurrency KeyCUKY5Conditional
AUSPATWRTATWRTCharacteristic ValueCHAR30Conditional
KSSKKLARTKLARTClass TypeCHAR20Mandatory
KSSKCLASSCLASSClass NameCHAR30Mandatory


5. Equipment Partner

TableFieldData ElementField DescriptionData TypeLengthRequirement
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

IHPAOBTYPOBTYPObject TypeCHAR3Mandatory
IHPAPARVWPARVWPartner FunctionCHAR2Mandatory
IHPAPARNRPARNRPartnerCHAR12Mandatory


6. Equipment User Status

TableFieldData ElementField DescriptionData TypeLengthRequirement
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

JSTOSTSMASTSMAStatus profile of the functional locationCHAR8Mandatory

JEST

STAT

STATStatus Number in User Status ListCHAR5Mandatory


7. Equipment Long Text Header

TableFieldData ElementField DescriptionData TypeLengthRequirement
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

STXHTDOBJECTTDOBJECTTexts: application objectCHAR10Mandatory
STXHTDNAMETDOBNAMENameCHAR70Mandatory
STXHTDIDTDIDText IDCHAR4Mandatory
STXHTDSPRASSPRASLanguage KeyLANG1Mandatory


8. Equipment Long Text Line

TableFieldData ElementField DescriptionData TypeLengthRequirement
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

STXLTDOBJECTTDOBJECTTexts: application objectCHAR10Mandatory
STXLTDNAMETDOBNAMENameCHAR70Mandatory
STXLTDIDTDIDText IDCHAR4Mandatory
STXLTDSPRASSPRASLanguage KeyLANG1Mandatory
STXLTDFORMATTDFORMATTag columnCHAR1Mandatory
STXLTDLINETDLINEText LineCHAR72Mandatory

Note:

  1. Long Text is not mandatory, only load when there is data
  2. One Long Text Header must have at least 1 Long Text Line

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 that is located here.


Data Cleansing

All data cleansing should take place in the data source system as defined in this document, unless system limitations prevent it.

If data cleansing is managed outside of the source system (e.g. Syniti Migrate, 3rd Party Vendor, DCT), the necessary documentation must be produced and appended to this deliverable for sign-off.

IDCriticalityError Message/Report DescriptionRuleOutputSource System
1002-001C1Relevant Equipment missing Technical Object TypeEquipment as per Relevancy Criteria with no Technical Object Type AssignedPlant, Equipment, Equipment Description, Technical Object TypePF2, WP2
1002-002C1Relevant Equipment missing Superior Equipment or Functional LocationEquipment as per Relevancy Criteria not installed either below a Superior Equipment or Functional LocationPlant, Equipment, Equipment Description, Technical Object Type, Superior Equipment, Functional LocationPF2, WP2
1002-003C1Relevant Equipment missing Plant SectionEquipment as per Relevancy Criteria with no Plant Section AssignedPlant, Equipment, Equipment Description, Technical Object TypePF2, WP2
1002-004C1Relevant Functional Location missing Technical Object TypeFunctional Location as per Relevancy Criteria ( mapping - Functional Location, where New Technical Object = 'EQ') with no Technical Object Type AssignedPlant, Functional Location, Functional Description, Technical Object TypePF2, WP2
1002-005C1Relevant Functional Location missing Plant SectionFunctional Location as per Relevancy Criteria ( mapping - Functional Location, where New Technical Object = 'EQ') with no Plant Section AssignedPlant, Functional Location, Functional Description, Technical Object TypePF2, WP2
1002-006C2Relevant Equipment maintaining Acquisition Value but missing Currency Key

Equipment as per relevancy criteria where EQUI_ANSWT <> '' (Blank) and EQUI_WAERS = '' (Blank)

Plant, Equipment, Equipment Description, Technical Object Type, Superior Equipment, Functional Location, Acquisition ValuePF2, WP2
1002-007C2Relevant Functional Location maintaining Acquisition Value but missing Currency Key

Functional Location as per Relevancy Criteria ( mapping - Functional Location, where New Technical Object = 'EQ')where IFLOT_ANSWT <> '' (Blank) and IFLOT_WAERS = '' (Blank)

Plant, Functional Location, Functional Description, Superior Functional Location, Acquisition ValuePF2, WP2
1002-008C3Info Report : Relevant Equipment Long Text for CleansingEquipment as per Relevancy Criteria where Long Text Exist flag is assigned (EQUI-KZLTX) = 'X'. This is for manual review.Plant, Equipment, Equipment Description, Long TextPF2, WP2
1002-009C3Info Report : Relevant Functional Location Long Text for CleansingFunctional Location as per Relevancy Criteria ( mapping - Functional Location, where New Technical Object = 'EQ') for which Long Text Exist flag is assigned (IFLOTX-KZLTX) = 'X'. This is for manual review.Plant, Functional Location, Functional Description, Long TextPF2, WP2
1002-010C3Info Report : Construction Type (CT) assigned to Relevant Equipment which are not part of a BOM (Bill of Material). This report is to support Business to review Legacy Construction Types to be included in Equipment DCT for migration.Construction Type (EQUZ-SUBMT) maintained on relevant Equipment which are/ are not part of a BOM (MAST-MATNR). Plant, Equipment, Equipment Description, CT, CT description, Material Type, Material Type DescriptionPF2, WP2
1002-011C3Info Report : Assemblies assigned to Relevant Maintenance Items which are not part of a BOM (Bill of Material). This report is to support Business to review Legacy Assemblies to be included in Equipment DCT for migration.Assembly (MPOS-BAUTL) maintained on relevant Maintenance Items (MPOS-WAPOS) which are/ are not part of a BOM (MAST-MATNR)Plant, Maintenance Item,  Assembly, Assembly description, Material Type, Material Type DescriptionPF2, WP2
1002-012C3Info Report : Assemblies listed on Relevant Maintenance Item Object list which are not part of a BOM (Bill of Material). This report is to support Business to review Legacy Assemblies to be included in Equipment DCT for migration.Assembly (OBJK-BAUTL) maintained on relevant Maintenance Items (MPOS-WAPOS) which are/ are not part of a BOM (MAST-MATNR)Plant, Maintenance Item,  Assembly, Assembly description, Material Type, Material Type DescriptionPF2, WP2
1002-013C3Info Report : Assemblies listed on Relevant Work Orders which are not part of a BOM (Bill of Material). This report is to support Business to review Legacy Assemblies to be included in Equipment DCT for migration.Assembly (AFIH-BAUTL) maintained on relevant Work Order (AUFK-AUFNR) which are/ are not part of a BOM (MAST-MATNR)Plant, Work Order,  Assembly, Assembly description, Material Type, Material Type DescriptionPF2, WP2
1002-014C3Info Report : Assemblies listed on Relevant Work Order Object list which are not part of a BOM (Bill of Material). This report is to support Business to review Legacy Assemblies to be included in Equipment DCT for migration.Assembly (OBJK-BAUTL) maintained on relevant Work Order (AUFK-AUFNR) which are/ are not part of a BOM (MAST-MATNR)Plant, Work Order,  Assembly, Assembly description, Material Type, Material Type DescriptionPF2, WP2
1002-015C3Info Report : Assemblies listed on Relevant Notifications which are not part of a BOM (Bill of Material). This report is to support Business to review Legacy Assemblies to be included in Equipment DCT for migration.Assembly (QMIH-BAUTL) maintained on relevant Notification (QMEL-QMNUM) which are/ are not part of a BOM (MAST-MATNR)Plant, Notification, Assembly description, Material Type, Material Type DescriptionPF2, WP2

Note: List of Cleansing is maintained here: Conversion Specs Register (DCT & Cleansing Report)


Conversion Process

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

 1. Source = PF2/WP2:

2. Source = DCT

 Collection will be done manually in the Data Collection Template for the following scenarios:

  • For sites not on SAP-PF2 or WP2 systems
  • For Equipment that need to be created for the relevant Assembly/ Materials

Data Privacy and Sensitivity

Not Applicable


Extraction

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

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

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


Selection Screen

If applicable, this section will give the details on any selection screen parameters, including the parameter type, that are required to be entered to ensure consistent data extracts.
Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
Not Applicable




Data Collection Template (DCT)

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

  1. The extracted report will be loaded into the required structure using the DCT.
  2. Standardization activities (including deduplication, standardization and additions)  will be carried out within the DCT.

Note: All rules specified below should be documented as a tooltip in the DC Page.

Format:

Line 1: Mandatory / Conditional

Line 2: Remaining text

1. Equipment Master Data Construction Rules

Field NameField DescriptionRule
zLegacyEQUNRLegacy Equipment Number

Mandatory

Must be unique

EQARTTechnical Object Type

PF2/WP2 data enrichment: Not used

For new data construction:

Mandatory

Allowed values from T370K to be populated

BRGEWWeight

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Populate if information exists

GEWEIUnit of Weight

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Populate unit value if BRGEW (Weight) has been maintained.

Allowed values from T006 to be populated

INVNRInventory No

Conditional

Populate Critical Material representing the relevant procured Capital Spare (Fixed Asset) for the Equipment

Criteria for Assigning Critical Materials as the Inventory Number

  • The material must have a cost greater than 15,000 and a useful life exceeding one year.
  • The material type should be either 'UNBW' or 'NLAG'.
  • The "Critical Part" checkbox must be selected in the Purchasing view of the Material Master.
ANSWTAcquisition Value

Conditional

Populate the Fixed Asset value if Inventory Number has been maintained. 

WAERSCurrency

Conditional

Populate only if 'Acquisition Value' field has been populated

Allowed values from TCURC to be populated. 

HERSTManufacturer

Conditional

Populate if information exists

TYPBZModel Number

Conditional

Populate if information exists

SERGEManufacturer Serial Number

Conditional

Populate if information exists

HERLDCountry/Region of Manufacture

Conditional

Populate if information exists

BAUJJYear of construction

Conditional

Populate if information exists

BAUMMMonth of Manufacture

Conditional

Populate if information exists

SWERKMaintenance Plant

PF2/WP2 data enrichment: Not used

For new data construction:

Mandatory

Populate values from Value Mapping - Plant (where Maintenance Plant = Yes)

INGRPPlanner Group 

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Must Populate value if Equipment is in Installed Status i.e HEQUI is not Blank or TPLNR is not Blank

Allowed values from T024I (where IWERK = Planning Plant) to be populated

GEWRKMain work center

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Must Populate value if Equipment is in Installed Status i.e HEQUI is not Blank or TPLNR is not Blank

Allowed values from Work Centre DCT to be populated. 

HEQUISuperordinate Equipment

For new data construction:

Conditional

Populate if Equipment is a Sub-Equipment. 

Plant section of the Superior Equipment should be identical the the Equipment to be installed.

SUBMTConstruction type

For new data construction:

Mandatory

Populate value from Assembly DCT.

Assigned Construction Type should have a TOT Characteristic value maintained which matches the 'Object Type' assigned on the Equipment and 'SubAssembly' Characteristic = 'No'

TPLNRFunctional Location

Conditional

Populate Category 'A' Functional Location if Equipment installed under Functional Location.

Assigned Functional Location should have a TOT value identical to the Equipment and the Plant Section of the Functional Location should be identical to the one assigned on the Equipment

Allowed Category 'A' Functional Location values from mapping (Functional Location, where New Technical Object = 'FL') to be used. 

BEBERPlant Section

Mandatory

Allowed values from T357 to be populated.

EQFNRSort Field

Mandatory

The Sort Field is used to store the Plant Tag ID, representing the physical identifier attached to an asset in the field.
Each Equipment record must have a unique Sort Field value within the same Plant, except in cases where the Equipment is defined as a sub-equipment of a parent asset, in which case it may share the same Plant Tag ID.

Ensure that it does not include any of below characters: 

;        Semi-colon
:        Colon
::        Double Colon
?        Question Mark
/        Forward Slash
@        At sign
&        Ampersand
=        Equal Sign
+        Plus Sign
$        Dollar Sign
%        Percent
|        Vertical Bar
[]        Left or Right Square Bracket
"        Double Quotes

KOSTLCost Center

PF2/WP2 data enrichment: 

Mandatory

Must Populate value if Equipment is in Installed Status i.e HEQUI is not Blank or TPLNR is not Blank

Allowed values from R2R Cost Centre Value Mapping. 

NAME1Name 1

PF2/WP2 data enrichment: 

Conditional

Populate NAME1-4 fields with the Name and Location of the Asset

NAME2Name 2

PF2/WP2 data enrichment: 

Conditional

Populate NAME1-4 fields with the Name and Location of the Asset

NAME3Name 3

PF2/WP2 data enrichment: 

Conditional

Populate NAME1-4 fields with the Name and Location of the Asset

NAME4Name 4

PF2/WP2 data enrichment: 

Conditional

Populate NAME1-4 fields with the Name and Location of the Asset

PLTXT_ENDescription of Equipment (English)

PF2/WP2 data enrichment

For new data construction:

Mandatory

Guide for Description:

A = Technical Object Type Description (in English language)
B = Asset Tag (Sort Field)
C = Additional Description as provided by business (in English Language)

Equipment Description = A+B+C

All Letters must be in Capital letters/ Uppercase. 

Cannot have duplicate records based on corresponding language text (2 Equipment cannot have the same English language key texts)

Ensure that it does not include any of below characters: 

;        Semi-colon
:        Colon
::        Double Colon
?        Question Mark
/        Forward Slash
@        At sign
&        Ampersand
=        Equal Sign
+        Plus Sign
$        Dollar Sign
%        Percent
|        Vertical Bar
[]        Left or Right Square Bracket
"        Double Quotes

SPRAS_LCLanguage Key_Local

PF2/WP2 data enrichment: 

For new data construction:

Conditional

User to populate Language Key based language of the Country where the Maintenance Plant exists. 

Allowed values:
1. "F" - French
2. "1" - Mandarin/Simplified Chinese
3. "I' - Italian
4. "P" - Portuguese/Brazilian
5. "D" - German
6. "S" - Spanish

PLTXT_LCDescription of Equipment (Local Language)

PF2/WP2 data enrichment: 

For new data construction:

Conditional

Guide for Description:

A = Technical Object Type Description (in Local Language of Plant)
B = Asset Tag (Sort Field)
C = Additional Description as provided by business (in language of the country in which each plant is located)

Equipment Description = A+B+C

All Letters must be in Capital letters/ Uppercase. 

Cannot have duplicate records based on corresponding language text (2 Equipment cannot have the same Local language key texts)

Ensure that it does not include any of below characters: 

;        Semi-colon
:        Colon
::        Double Colon
?        Question Mark
/        Forward Slash
@        At sign
&        Ampersand
=        Equal Sign
+        Plus Sign
$        Dollar Sign
%        Percent
|        Vertical Bar
[]        Left or Right Square Bracket
"        Double Quotes

zLegacyPARNR_Z1

Partner (Asset Owner)

PF2/WP2 data enrichment:

For new data construction:

Conditional

Populate 'Z1' (Asset Owner) Vendor Business Partner as per below rule. 

Rule -
For Assets that are Owned by Syensqo and Maintained by Syensqo Inter Company Vendor are to be populated. 

For Assets that are rented from specific vendors or maintained by third-party service providers, external Vendors are to be populated

zLegacyPARNR_Z2Partner (Asset Maintainer)

PF2/WP2 data enrichment:

For new data construction:

Conditional

Populate 'Z2' (Asset Maintainer) Vendor Business Partner as per below rule. 

Rule -

For Assets that are Owned by Syensqo and Maintained by Syensqo Inter Company Vendor are to be populated.

For Assets that are rented from specific vendors or maintained by third-party service providers, external Vendors are to be populated

zLegacyPARNR_Z3Partner (Vendor Contact)

PF2/WP2 data enrichment:

For new data construction:

Conditional

Populate 'Z3' (Vendor Contact) Contact Person Business Partner of the External Vendor.

STAT_N1Sequential Status in User Status Profile

PF2/WP2 data enrichment: No Used 

For new data construction:

Conditional

Populate from allowed values:
    'PLAN'- Planned
    'COMM'- Commissioned
    'INSR'- In Service
    'OTSR'- Out Of Service
    'SCRP'- Scrap

If none is provided, it will be defaulted to 'PLAN'

STAT_X1Non-Sequential Status in the User Status Profile - EXHZ (Extremely Hazardous) 

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Populate 'EXHZ' (Extremely Hazardous) status if applicable. 

STAT_X2Non-Sequential Status in the User Status Profile - MTNA (Maintenance Not Allowed)

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Populate 'MTNA' (Maintenance Not Allowed) status if applicable. 


2. Equipment Classification Data Construction Rules

Data ElementField DescriptionRule
zLegacyEQUNREquipment Number

Mandatory

Key to link to Equipment

Should exist in Equipment Master DCT Rules

CLASSClass Name

Mandatory

  • Must always have an always an entry for EAM_9999.
  • User to populate any other class of class type '002' (Equipment) as required

Class other than 'EAM_9999' must have naming convention = EAM_TOT (Tech Object Type) of the Equipment

ATNAMCharacteristic Name

Mandatory

User to populate Characteristic assigned to the Class 'EAM_9999' and other mapped legacy classes as per the Class DCT

ATWRTCharacteristic Value

Conditional.

  • If the characteristic has character format (CHAR), populate with alphanumeric characters.
  • If the characteristic has character format (DATE), must have the format DDMMYYYY. E.g. 31122000
  • If the characteristic has character format (TIME), must have the format HHMMSS. E.g. 110000
  • If the characteristic has character format (NUM), the field should contain only numerical characters. E.g. 888
  • If the characteristic has character format (CURR), this field should contain only numerical characters. E.g. 200

Note for DATE, TIME, NUM and CURR formats:

  • If a range is required, the from and to values should be concatenated using a hyphen (" - ").
    • E.g. DATE: 1 - 2, 110000 -112855
  • Fill in only if Characteristic - Interval values allowed (ATINT) is populated with "X"
  • The Characteristic Value (From) should be <= Characteristic Value (To)
POSNRItem Number

Conditional

Sequential number to be maintained if multiple values are being recorded for the same Characteristic


3. Equipment Long Text Data Construction Rules

Data ElementField DescriptionRule
zLegacyEQUNRLegacy Equipment Number

Mandatory

Key to link to Equipment

TDLINE_ENText Line (English)

Conditional

User to populate Free Text in English Language as applicable. All Letters must be in Capital letters/ Uppercase. 

TDSPRAS_LCLanguage Key_Local

Conditional

User to populate Language Key based language of the Country where the Maintenance Plant exists. 

Allowed values:
1. "F" - French
2. "1" - Mandarin/Simplified Chinese
3. "I' - Italian
4. "P" - Portuguese/Brazilian
5. "D" - German
6. "S" - Spanish

TDLINE_LCText Line (Local Language)

Conditional

User to populate Free Text in language of the country in which each plant is located (French, Italian, Mandarin, Brazilian Portuguese, German or Spanish).

All Letters must be in Capital letters/ Uppercase. 


4. Inclusion-EQ Long Text Data Construction Rules

Data ElementField DescriptionRule
zLegacyEQUNRLegacy Equipment Number

Mandatory

Key to link to Equipment

zLegacyWERKSLegacy Plant

Mandatory

zLegacySPRASLegacy Language Key

Mandatory.

Allowed values:
1. "E" - English
2. "F" - French
3. "1" - Mandarin/Simplified Chinese
4. "I' - Italian
5. "P" - Portuguese/Brazilian
6. "D" - German
7. "S" - Spanish

Note: Only Long Texts that are added into this list will be migrated.

Note: List of DCTs is maintained here: Conversion Specs Register (DCT & Cleansing Report)

Extraction Dependencies

List the steps that need to occur before extraction can commence

Item #Step DescriptionTeam Responsible

Not Applicable




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 Syniti Migrate 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 Advanced Data Migration and Management (ADMM)
  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 Data Team

2

In dspMigrate, select the wave – S4/HANA – Plant Maintenance

Syniti

3

Go to Process Area Launch and Process the Object – Equipment

Syniti

4

Review and Validate Error and Preload Reports

Syniti

5

Execute the transformation to prepare the target tables

Syniti

6

Validate data from pre-load and error reports

Business/Data owner

7

Generate load files

Syniti


Transformation Rules

1. Equipment Master Transformation Rule (ECC)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2, WP2EQUIEQUNREquipment NumberS/4 HanaEQUIEQUNR
Internal Generated Number 
2
EQUIEQTYPEquipment CategoryS/4 HanaEQUIEQTYP
Default to 'M'
3
EQUIEQARTTechnical Object TypeS/4 HanaEQUIEQART

4
EQUIBRGEWWeightS/4 HanaEQUIBRGEW

5
EQUIGEWEIUnit of WeightS/4 HanaEQUIGEWEI

6
EQUIINVNRInventory NoS/4 HanaEQUIINVNR

7-EQUI--S/4 HanaEQUIINBDTStart-Up Date

If derived Target User Status for Equipment from Equipment User Status (STAT) Transformation Rules (ECC) is either of the below:
'COMM' (Commissioned)
'INSR' (In Service)
'OTSR' (Out of Service)
'SCRP' (Scrap)
then assign the date as per Value mapping :
 OTH_Migration_Date Relevant Values A2D (where Object ID "1002" and Field Name = "EQUI-INBDT".

Else leave blank

8
EQUIANSWTAcquisition ValueS/4 HanaEQUIANSWT

9
EQUIWAERSCurrencyS/4 HanaEQUIWAERS

10
EQUIHERSTManufacturerS/4 HanaEQUIHERST

11
EQUITYPBZModel NumberS/4 HanaEQUITYPBZ

12
EQUISERGEManufacturer Serial NumberS/4 HanaEQUISERGE

13
EQUIHERLDCountry/Region of ManufactureS/4 HanaEQUIHERLD

14
EQUIBAUJJYear of constructionS/4 HanaEQUIBAUJJ

15
EQUIBAUMMMonth of ManufactureS/4 HanaEQUIBAUMM

16
EQUZ--S/4 HanaEQUZDATABValid-From DateAssign the date as per Value mapping : OTH_Migration_Date Relevant Values A2D (where Object ID "1002" and Field Name = "EQUI-DATAB".
17
EQUZIWERKMaintenance Planning PlantS/4 HanaEQUZIWERK

18
EQUZINGRPPlanner Group S/4 HanaEQUZINGRP

19
EQUZGEWRKMain work centerS/4 HanaEQUZGEWRK

20
EQUZWERGW

Plant associated with main work center

S/4 HanaEQUZWERGW

21
EQUZHEQUISuperordinate EquipmentS/4 HanaEQUZHEQUI

22
EQUZSUBMTConstruction typeS/4 HanaEQUZSUBMT

23
ILOAABCKZABC IndicatorS/4 HanaILOAABCKZ

24
ILOATPLNRFunctional LocationS/4 HanaILOATPLNR

25
ILOASWERKMaintenance PlantS/4 HanaILOASWERK

26
ILOABEBERPlant SectionS/4 HanaILOABEBER

27
ILOAEQFNRSort FieldS/4 HanaILOAEQFNR

28
ILOABUKRSCompany CodeS/4 HanaILOABUKRS

29
ILOAKOSTLCost CenterS/4 HanaILOAKOSTL

30
ILOAKOKRSControlling AreaS/4 HanaILOAKOKRS

31
ADRCNAME1Name 1S/4 HanaADRCNAME1

32
ADRCNAME2Name 2S/4 HanaADRCNAME2

33
ADRCNAME3Name 3S/4 HanaADRCNAME3

34
ADRCNAME4Name 4S/4 HanaADRCNAME4

35
ADRCCOUNTRYCountry/Region KeyS/4 HanaADRCCOUNTRY


2. Equipment Master Transformation Rule (DCT)

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



zLegacyEQUNREquipment NumberS/4 HanaEQUIEQUNR
Key to link to the Equipment



EQTYPEquipment CategoryS/4 HanaEQUIEQTYP
Default to 'M'



EQARTTechnical Object TypeS/4 HanaEQUIEQART




BRGEWWeightS/4 HanaEQUIBRGEW




GEWEIUnit of WeightS/4 HanaEQUIGEWEI




INVNRInventory NoS/4 HanaEQUIINVNR




INBDTStart-up dateS/4 HanaEQUIINBDT




ANSWTAcquisition ValueS/4 HanaEQUIANSWT




WAERSCurrencyS/4 HanaEQUIWAERS




HERSTManufacturerS/4 HanaEQUIHERST




TYPBZModel NumberS/4 HanaEQUITYPBZ




SERGEManufacturer Serial NumberS/4 HanaEQUISERGE




HERLDCountry/Region of ManufactureS/4 HanaEQUIHERLD




BAUJJYear of constructionS/4 HanaEQUIBAUJJ




BAUMMMonth of ManufactureS/4 HanaEQUIBAUMM




DATABValid-From DateS/4 HanaEQUZDATAB




IWERKMaintenance Planning PlantS/4 HanaEQUZIWERK




INGRPPlanner Group S/4 HanaEQUZINGRP




GEWRKMain work centerS/4 HanaEQUZGEWRK




WERGW

Plant associated with main work center

S/4 HanaEQUZWERGW




HEQUISuperordinate EquipmentS/4 HanaEQUZHEQUI




SUBMTConstruction typeS/4 HanaEQUZSUBMT




ABCKZABC IndicatorS/4 HanaILOAABCKZ




TPLNRFunctional LocationS/4 HanaILOATPLNR




SWERKMaintenance PlantS/4 HanaILOASWERK




BEBERPlant SectionS/4 HanaILOABEBER




EQFNRSort FieldS/4 HanaILOAEQFNR




BUKRSCompany CodeS/4 HanaILOABUKRS




KOSTLCost CenterS/4 HanaILOAKOSTL




KOKRSControlling AreaS/4 HanaILOAKOKRS




NAME1Name 1S/4 HanaADRCNAME1




NAME2Name 2S/4 HanaADRCNAME2




NAME3Name 3S/4 HanaADRCNAME3




NAME4Name 4S/4 HanaADRCNAME4




COUNTRYCountry/Region KeyS/4 HanaADRCCOUNTRY

 

3. Equipment Short Text Transformation Rule (ECC) 

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2, WP2EQKTEQUNRLegacy Equipment NumberS/4 HanaEQKTEQUNRLegacy Equipment Number

Internal Generated Number 

2PF2, WP2EQKTSPRASLanguage KeyS/4 HanaEQKTSPRASLanguage KeyDirect Mapping
3PF2, WP2EQKTEQKTXDescription of EquipmentS/4 HanaEQKTEQKTXDescription of Equipment

Direct Mapping

Overwrite with DCT if provided (as part of enrichment)

4. Equipment Short Text Transformation Rule (DCT) 

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQKTzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQKTEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaEQKTSPRASLanguage KeyDefault to 'E'
3DCTEQKTEQKTX_ENDescription of Equipment (English)S/4 HanaEQKTEQKTXDescription of Equipment

Direct Mapping

Overwrite with DCT if provided (as part of enrichment)

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQKTzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQKTEQUNREquipment Number

Key to link to the Equipment

2DCTEQKTSPRAS_LCLanguage KeyS/4 HanaEQKTSPRASLanguage KeyDirect Mapping
3DCTEQKTEQKTX_LCDescription of Equipment (Local Language of Plant)S/4 HanaEQKTEQKTXDescription of Equipment

Direct Mapping

Overwrite with DCT if provided (as part of enrichment)


5. Functional Location Classification Transformation Rule (ECC)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2, WP2EQUIEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Internal Generated Number 

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaINOBOBTABName of Database Table for ObjectDefault to 'EQUI'
4PF2, WP2KSSKCLASSClass NameS/4 HanaKSSKCLASSClass NameValue mapping : Class A2D
5PF2, WP2CABNATNAMCharacteristic NameS/4 HanaAUSPATNAMCharacteristic Name

Step1- Use Value mapping: Characteristic A2D (Staging) to get the Staging Characteristic;

Step2 - Use Value mapping: Characteristic A2D to get the Target Characteristic

6PF2, WP2AUSPADZHLItem NumberS/4 HanaAUSPPOSNRItem NumberDirect Mapping
7PF2, WP2AUSPATFLVNumerical Value - FromS/4 HanaAUSPATFLVNumerical Value - From (Floating Point)Convert existing Legacy value to Float
8PF2, WP2AUSPATFLBNumerical Value - ToS/4 HanaAUSPATFLBNumerical Value - To (Floating Point)Convert existing Legacy value to Float
9PF2, WP2AUSPATFLVDate Interval - FromS/4 HanaAUSPDATE_FROMLower Boundary for Date - IntervalConvert existing Legacy value to Float
10PF2, WP2AUSPATFLBDate Interval - ToS/4 HanaAUSPDATE_TOUpper Boundary for Date - IntervalConvert existing Legacy value to Float
11PF2, WP2AUSPATFLVTime Interval - FromS/4 HanaAUSPTIME_FROMLower Boundary for Time - IntervalConvert existing Legacy value to Float
12PF2, WP2AUSPATFLBTime Interval - ToS/4 HanaAUSPTIME_TOUpper Boundary for Time - IntervalConvert existing Legacy value to Float
13PF2, WP2AUSPATFLVCurrency Value - FromS/4 HanaAUSPATFLVCurrency Value - From (Floating Point)Convert existing Legacy value to Float
14PF2, WP2AUSPATFLBCurrency Value - ToS/4 HanaAUSPATFLBCurrency Value - To (Floating Point)Convert existing Legacy value to Float
15PF2, WP2AUSPATWRTCharacteristic ValueS/4 HanaAUSPATWRTCharacteristic ValueDirect Mapping

  

6. Equipment Classification Transformation Rule (DCT)

Only get the records where Characteristics with Data Type = CHAR

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSNUMClass NameS/4 HanaKSSKCLASSClass NameDirect Mapping
5DCTAUSPATNAMCharacteristic NameS/4 HanaAUSPATNAMCharacteristic NameValue Mapping: Characteristic A2D
6DCTAUSPATWRTCharacteristic ValueS/4 HanaCAWNATWRTCharacteristic ValueDirect Mapping
7DCTAUSPPOSNRItem NumberS/4 HanaAUSPPOSNRItem NumberDirect Mapping

Only get the records where Characteristics with Data Type = CURR

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSNUMClass NameS/4 HanaKSSKCLASSClass NameDirect Mapping
5DCTAUSPATNAMCharacteristic NameS/4 HanaAUSPATNAMCharacteristic NameDirect Mapping
6DCTAUSPATWRTCharacteristic Value S/4 HanaCAWNATFLVCharacteristic Value (From)

If range: values concatenated using " - ", derive the value before " - ".

Otherwise, direct mapping.

7DCTAUSPATWRTCharacteristic ValueS/4 HanaCAWNATFLBCharacteristic Value (To)

If range: values concatenated using " - ", derive the value after " - ".

Otherwise, direct mapping.

8DCTAUSPCURRENCYCurrency KeyS/4 HanaAUSPCURRENCYCurrency KeyDerive from Currency Key of the Characteristics
9DCTAUSPPOSNRItem NumberS/4 HanaAUSPPOSNRItem NumberDirect Mapping

Only get the records where Characteristics with Data Type = DATE

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSNUMClass NameS/4 HanaKSSKCLASSClass NameDirect Mapping
5DCTAUSPATNAMCharacteristic NameS/4 HanaAUSPATNAMCharacteristic NameDirect Mapping
6DCTAUSPATWRTCharacteristic ValueS/4 HanaCAWNDATE_FROMCharacteristic Value (From)

If range: values concatenated using " - ", derive the value before " - ".

Otherwise, direct mapping.

7DCTAUSPATWRTCharacteristic ValueS/4 HanaCAWNDATE_TOCharacteristic Value (To)

If range: values concatenated using " - ", derive the value after " - ".

Otherwise, direct mapping.

8DCTAUSPPOSNRItem NumberS/4 HanaAUSPPOSNRItem NumberDirect Mapping

Only get the records where Characteristics with Data Type = NUM

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSNUMClass NameS/4 HanaKSSKCLASSClass NameDirect Mapping
5DCTAUSPATNAMCharacteristic NameS/4 HanaAUSPATNAMCharacteristic NameDirect Mapping
6DCTAUSPATWRTCharacteristic ValueS/4 HanaCAWNATFLVCharacteristic Value (From)

If range: values concatenated using " - ", derive the value before " - ".

Otherwise, direct mapping.

7DCTAUSPATWRTCharacteristic ValueS/4 HanaCAWNATFLBCharacteristic Value (To)

If range: values concatenated using " - ", derive the value after " - ".

Otherwise, leave blank.

8DCTAUSPPOSNRItem NumberS/4 HanaAUSPPOSNRItem NumberDirect Mapping

 Only get the records where Characteristics with Data Type = TIME

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSNUMClass NameS/4 HanaKSSKCLASSClass NameDirect Mapping
5DCTAUSPATNAMCharacteristic NameS/4 HanaAUSPATINNCharacteristic NameDirect Mapping
6DCTAUSPATWRTCharacteristic Value S/4 HanaCAWNTIME_FROMCharacteristic Value (From)

If range: values concatenated using " - ", derive the value before " - ".

Otherwise, direct mapping.

7DCTAUSPATWRTCharacteristic ValueS/4 HanaCAWNTIME_TOCharacteristic Value (To)

If range: values concatenated using " - ", derive the value after " - ".

Otherwise, direct mapping.

8DCTAUSPPOSNRItem NumberS/4 HanaAUSPPOSNRItem NumberDirect Mapping


7. Functional Location Partner Transformation Rule (DCT)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2-

-

-

-S/4 HanaIHPAOBTYPObject TypeDefault to 'IEQ'
3-

-

-

-S/4 HanaIHPAPARVWPartner FunctionDefault to 'Z1' (Asset Owner)
4DCTIHPAzLegacyPARNR_Z1Partner (Asset Owner)S/4 HanaIHPAPARNRPartner

Overwrite with DCT if provided (as part of enrichment)

Value mapping : Vendor Number

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2-

-

-

-S/4 HanaIHPAOBTYPObject TypeDefault to 'IEQ'
3-

-

-

-S/4 HanaIHPAPARVWPartner FunctionDefault to 'Z2' (Asset Maintainer)
4DCTIHPAzLegacyPARNR_Z2Partner (Asset Maintainer)S/4 HanaIHPAPARNRPartner

Overwrite with DCT if provided (as part of enrichment)

Value mapping : Vendor Number

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2-

-

-

-S/4 HanaIHPAOBTYPObject TypeDefault to 'IEQ'
3-

-

-

-S/4 HanaIHPAPARVWPartner FunctionDefault to 'Z3' (Vendor Contact)
4DCTIHPAzLegacyPARNR_Z2Partner (Vendor Contact)S/4 HanaIHPAPARNRPartner

Overwrite with DCT if provided (as part of enrichment)

Value mapping : Vendor Number


8. Functional Location User Status Transformation Rules (ECC)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2, WP2EQUIEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Internal Generated Number 

3----S/4 HanaJSTOSTSMAStatus profile of the EquipmentDefault to 'ZEAMEQ01'
4PF2, WP2

JEST

STAT

Status Number in User Status ListS/4 Hana

JEST

STAT

Status Number in User Status List

Value Mapping : User Status Equipment

Overwrite with DCT if provided (as part of enrichment)

5-

-

-

-S/4 Hana

JEST

INACT

Indicator: Status Is InactiveDefault to '' (Blank)

Note: Filter on TJ30T for Status Profiles with ESTAT starting with E*. 

9. Functional Location User Status Transformation Rules (DCT)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaJSTOSTSMAStatus profile of the EquipmentDefault to 'ZEAMEQ01'
3DCT

JEST

STAT_N1

Sequential Status in the User Status ProfileS/4 Hana

JEST

STAT

Status Number in User Status List

Default 'PLAN' for Category 'O' and 'N' 

For Category 'A':
Direct Mapping. If blank, default to 'PLAN'

4----S/4 Hana

JEST

INACT

Indicator: Status Is InactiveDefault to '' (Blank)

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaJSTOSTSMAStatus profile of the EquipmentDefault to 'ZEAMEQ01'
3DCT

JEST

STAT_X1

Non-Sequential Status in the User Status Profile - EXHZ (Extremely Hazardous) S/4 Hana

JEST

STAT

Status Number in User Status List

Default Blank for Category 'O' and 'N' 

For Category 'A':
Direct Mapping

4----S/4 Hana

JEST

INACT

Indicator: Status Is InactiveDefault to '' (Blank)

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment

2----S/4 HanaJSTOSTSMAStatus profile of the EquipmentDefault to 'ZEAMEQ01'
3DCT

JEST

STAT_X2

Non-Sequential Status in the User Status Profile - MTNA (Maintenance Not Allowed)S/4 Hana

JEST

STAT

Status Number in User Status List

Default to 'MNTA' (Maintenance Not Allowed) for Category 'O' and 'N'

For Category 'A':
Direct Mapping

4----S/4 Hana

JEST

INACT

Indicator: Status Is InactiveDefault to '' (Blank)


10. Functional Location Long Text Header (ECC)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1----S/4 HanaSTXHTDOBJECTTexts: application objectDefault to 'EQUI'
2PF2, WP2EQUIEQUNRLegacy Equipment NumberS/4 HanaSTXHTDNAMEName

Concatenate '000000000' + Value Mapping: Equipment (New Equipment)

3----S/4 HanaSTXHTDIDText IDDefault to 'LTXT'
4PF2, WP2STXHTDSPRASLanguage KeyS/4 HanaSTXHTDSPRASLanguage KeyDirect Mapping

Note: Only the records marked as Cleansed in Inclusion-FL Long Text will be migrated

11. Functional Location Long Text Header (DCT)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1----S/4 HanaSTXHTDOBJECTTexts: application objectDefault to 'EQUI'
2DCTEQUIzLegacyEQUNRLegacy Equipment NumberS/4 HanaSTXHTDNAMEName

Direct Mapping

3----S/4 HanaSTXHTDIDText IDDefault to 'LTXT'
4DCTSTXHTDSPRASLanguage KeyS/4 HanaSTXHTDSPRASLanguage KeyDefault to 'E'

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1----S/4 HanaSTXHTDOBJECTTexts: application objectDefault to 'IFLOT'
2DCTIFLOTTPLNRFunctional LocationS/4 HanaSTXHTDNAMEName

Direct Mapping

3----S/4 HanaSTXHTDIDText IDDefault to 'LTXT'
4DCTSTXHTDSPRAS_LCLanguage KeyS/4 HanaSTXHTDSPRASLanguage KeyDirect Mapping


12. Functional Location Long Text Line (ECC)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1----S/4 HanaSTXLTDOBJECTTexts: application objectDefault to 'IFLOT'
2PF2, WP2IFLOTTPLNRLegacy Functional LocationS/4 HanaSTXHTDNAMEName

Value Mapping: Functional Location (New Functional Location)

3----S/4 HanaSTXLTDIDText IDDefault to 'LTXT'
5PF2, WP2STXHTDSPRASLanguage KeyS/4 HanaSTXLTDSPRASLanguage KeyDirect Mapping
6----S/4 HanaSTXLTDFORMATTag columnDefault to "*"
7PF2, WP2STXLTDLINEText LineS/4 HanaSTXLTDLINEText LineDirect Mapping

Note: Only the records marked as Cleansed in Inclusion-FL Long Text will be migrated


13. Functional Location Long Text Line (DCT)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1----S/4 HanaSTXHTDOBJECTTexts: application objectDefault to 'IFLOT'
2DCTIFLOTTPLNRFunctional LocationS/4 HanaSTXHTDNAMEName

Direct Mapping

3----S/4 HanaSTXHTDIDText IDDefault to 'LTXT'
5DCTSTXHTDSPRASLanguage KeyS/4 HanaSTXHTDSPRASLanguage KeyDefault to 'E'
6----S/4 HanaSTXLTDFORMATTag columnDefault to "*"
7DCTSTXLTDLINE_ENText LineS/4 HanaSTXLTDLINEText LineDirect Mapping

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1----S/4 HanaSTXHTDOBJECTTexts: application objectDefault to 'IFLOT'
2DCTIFLOTTPLNRFunctional LocationS/4 HanaSTXHTDNAMEName

Direct Mapping

3----S/4 HanaSTXHTDIDText IDDefault to 'LTXT'
5DCTSTXHTDSPRAS_LCLanguage KeyS/4 HanaSTXHTDSPRASLanguage KeyDirect Mapping
6----S/4 HanaSTXLTDFORMATTag columnDefault to "*"
7DCTSTXLTDLINE_LCText LineS/4 HanaSTXLTDLINEText LineDirect Mapping

Note: For all relevant fields Data Origin will be defaulted to 'Individual Maintenance' 

List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.


Transformation Mapping

Use the exact name and reference this section in the “Transformation rules” above
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.







List of Transformation Mappings with additional details is maintained here: Transformation Mappings

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

The following pre-load validations will be performed by the 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

The following pre-load validations will be performed by the 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

Identify the phase as to “when” the load for this object will occur. <Pre-Cutover, Cutover, Post Cutover> and list the steps that need to occur before the load can commence

Configuration

List the Configurations required before loading can commence

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

The table below depicts some possible system errors for this data object during data load. All data load error is to be logged as defect and managed within the Defect Management

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

The following post-load validations will be performed by the 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

The following post-load validations will be performed by the 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.

Any additional key assumptions.


See also

Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.

Change log

Workflow history