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

Compare with Current View Page History

« Previous Version 165 Current »

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.


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 in service 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 installed Equipment
  • Data Construct Template to capture -
    • Relevant Functional Locations identified for migration as Equipment as specified in Functional Location CS.
    • Relevant Assembly 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)

      • Task List Operation (Assembly)
      • 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 (ILOA-SWERK) in scope (Value Mapping : Plant, where Maintenance Plant = 'Yes')
    • </Start CR0417> Active (JEST-INAC <> 'X') </End CR0417> System Status (JEST-STAT) = Installed 'INST' or Allocated to superior equipt 'ASEQ' 
  • </Start CR0417>
    Equipment (EQUI-EQUNR) with Valid To Date (EQUZ-DATBI) = '99991231'
    </End CR0417>
  • Equipment (EQUI-EQUNR) as part of Inclusion List (INC-Equipment). For e.x Equipment relevant for Asset Integration.
  • Equipment Long Text for the Equipment listed in Inclusion-EQ Long Text. </Start CR0446> Only long text records and having the design approved Language Key (English, French, Italian, Mandarin, Brazilian Portuguese, German, Spanish) to be considered. </End CR0446>

The data from legacy system excludes:

  • Equipment (EQUI-EQUNR) with </Start CR0417> Active (JEST-INAC <> 'X') </End CR0417> System Status (JEST-STAT) = Inactive 'INAC'
  • Equipment (EQUI-EQUNR) with </Start CR0417> Active (JEST-INAC <> 'X') </End CR0417> System Status (JEST-STAT) = Deletion Flag 'DLFL'
  • Equipment (EQUI-EQUNR) with </Start CR0417> Active (JEST-INAC <> 'X') </End CR0417> System Status (JEST-STAT) = In the warehouse 'ESTO'
  • Equipment (EQUI-EQUNR) with </Start CR0417> Active (JEST-INAC <> 'X') </End CR0417> System Status (JEST-STAT) = Available 'AVLB'
  • Equipment (EQUI-EQUNR) with Serial Number (EQUI-SERNR) <> '' (BLANK)
  • Equipment (EQUI-EQUNR) part of Exclusion List (EXC-Equipment)

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

DCT

Functional Location to be migrate as Equipment as part of mapping (Functional Location, where New Technical Object = 'EQ')

An initial extract of the relevant Functional Locations will be provided in google sheet format to assist business in decision making.

TBD

S/4HANA

TBD

DCT

Assembly to be created as Equipment based on Info reports extract of the relevant Assemblies. The reports will be provided in google sheet format to assist business in decision making.

TBD

S/4HANA

TBD

DCT

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

Scope

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
EQUIBRGEWBRGEWWeightQUAN

</Start CR0446>

13

13,3

</End CR0446>

Conditional
EQUIGEWEIGEWEIUnit of WeightUNIT3Conditional
EQUIINVNRINVNRInventory NoCHAR25Conditional
EQUIINBDTINBDTStart-up dateDATS8Conditional
EQUIANSWTANSWTAcquisition Value

</Start CR0446>

NUMC

CURR

</End CR0446>

</Start CR0446>

13

13,2

</End CR0446>

Conditional
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 CHAR3Mandatory
EQUZGEWRKGEWRKMain work centerCHAR8Mandatory
EQUZWERGWWERGW

Plant associated with main work center

CHAR4Mandatory
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
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

EQKTSPRASSPRASLanguage KeyLANG1Mandatory
EQKTEQKTXEQKTXDescription 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
KSSKCLASSCLASSClass NameCHAR30Mandatory
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)


 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
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 EquipmentCHAR8Mandatory

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
STXHTDNAMETDNAMENameCHAR70Mandatory
STXHTDIDTDIDText IDCHAR4Mandatory
STXHTDSPRASTDSPRASLanguage KeyLANG1Mandatory


8. Equipment Long Text Line

TableFieldData ElementField DescriptionData TypeLengthRequirement
EQUIEQUNREQUNREquipment NumberCHAR18

Mandatory

(Key to link to Equipment)

STXLTDOBJECTTDOBJECTTexts: application objectCHAR10Mandatory
STXLTDNAMETDNAMENameCHAR70Mandatory
STXLTDIDTDIDText IDCHAR4Mandatory
STXLTDSPRASTDSPRASLanguage KeyLANG1Mandatory
STXLTDFORMATTDFORMATTag columnCHAR1Mandatory
STXLTDLINETDLINEText LineCHAR</Start CR0417>
72
132
</End CR0417>
Mandatory

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

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
</Start CR0417> 

  
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
</End CR0417> 

  
1002-003C3Info Report: Equipment from in-scope Plants in Available 'AVLB' Status

</Start CR0417>

'Floating' Equipment i.e having

Equipment (EQUI-EQUNR) with Active (JEST-INAC <> 'X') System Status (JEST-STAT) = Available 'AVLB' and Maintenance Plant (ILOA-SWERK) in scope (Value Mapping : Plant, where Maintenance Plant = 'Yes')

</End CR0417>

Plant, Equipment, Equipment DescriptionPF2, WP2
1002-004C3

Info Report : Relevant Equipment Long Text for Cleansing

Equipment as per Relevancy Criteria where Long Text Exist flag is assigned (EQUI-KZLTX) = 'X'. This is for manual review.

</Start CR0446>

Only consider Long Text for the following language key: English, French, Italian, Mandarin, Brazilian Portuguese, German, Spanish

</End CR0446>

</Start CR0446> 

Plant, Equipment, Equipment Description,Long Text


Plant, Equipment, Equipment Description, Language Key, Row Number, Long Text </End CR0446>

PF2, WP2
1002-005C3Info 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-006C3Info 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-007C3Info 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-008C3Info 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-009C3Info 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-010C3Info 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
1002-011C3Info Report: Functional Location identified to be migrated as Equipment. This report is to support Business to review Legacy Functional Location to be included in Equipment DCT for migration.Functional Location (IFLOT-TPLNR) to be migrate as Equipment as part of mapping (Functional Location, where New Technical Object = 'EQ' )Plant, Functional Location, Functional Description, Technical Object Type, Weight, Unit of Weight, Inventory No, Acquisition Value, Currency, Manufacturer, Model Number, Manufacturer Serial Number, Country/Region of Manufacture, Year of construction, Month of Manufacture, Maintenance Plant, Planner Group, Main Work Center, Sort Field, Cost Center, Name 1, Name 2, Name 3, Name 4PF2, WP2
</Start CR0446>

   
1002-012C3Info Report: Relevant Equipment reportReport for Equipment as per Relevancy Criteria with the mentioned fields. This would be the basis for the EnrichmentMaintenance Plant, Equipment, Equipment Description, Technical Object Type, Superordinate Equipment, Superordinate Equipment Description, Functional Location, Functional Location Description, Sort Field, Weight, Unit of Weight,  Inventory No, Acquisition Value, Currency, Planner Group, Main work Center, Plant Section, Cost Center, Name1, Name 2, Name 3, Name 4PF2, WP2
1002-013C3Info Report: Relevant Equipment with Long Text missing in English LanguageEquipment as per Relevancy Criteria where Long Text Exist flag is assigned (EQUI-KZLTX) = 'X' and Language Key (STXH-TDSPRAS = 'E') is not present for the EquipmentPlant, Equipment, Equipment Description, Language Key, Row Number, Long TextPF2, WP2
</End CR0446>

   

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:

  • Equipment to be created where the source data is set up as Functional Locations

  • Equipment to be created where the source data is set up as Assemblies

  • Legacy Equipment to be split into multiple Equipment

image-2025-9-27_16-39-42.png

  • For sites not on SAP-PF2 or WP2 systems

DCT.png

Data Privacy and Sensitivity

Not Applicable


Extraction

Extract data from a source into Advanced Data Migration and Management (ADMM). There are 2 possibilities:

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

2

Google Sheet report pre-populated with PF2 and WP2 information to be generated based on below info reports.

  • Assembly/ Construction Type - 1002-004/005/006/007/008/009
  • Functional Location - 1002-010

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 Equipment 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 Id

Mandatory

If exists in Value Mapping: Equipment (Staging), then populate the Staging Id mapped to the Legacy Id

Else populate the Legacy Id of the Equipment/ Functional Location/ Assembly Material

zLegacyObjectTypeLegacy Object Type

Mandatory

Allowed Values - 'EQ' (Equipment)/ 'FL' (Functional Location) / 'ASY' (Assembly)

EQARTTechnical Object Type

Mandatory

Allowed values from T370K to be populated

BRGEWWeight

Conditional

Populate if information exists

GEWEIUnit of Weight

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

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

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Populate if information exists

TYPBZModel Number

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Populate if information exists

SERGEManufacturer Serial Number

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Populate if information exists

HERLDCountry/Region of Manufacture

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Allowed values from T005 to be populated. 

BAUJJYear of construction

PF2/WP2 data enrichment: Not used

For new data construction:

Conditional

Populate if information exists

BAUMMMonth of Manufacture

PF2/WP2 data enrichment: Not used

For new data construction:

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 

Mandatory

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

GEWRKMain work center

Mandatory

Allowed values from Work Centre DCT to be populated. 

HEQUISuperordinate Equipment

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

Mandatory

Populate value from Assembly DCT.

Assigned Construction Type should have a TOT Characteristic value (A_ALLOWED_TOT) maintained which matches the 'Technical Object Type' assigned on the Equipment and 'SubAssembly' Characteristic (A_SUB_ASSEMBLY) = '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. 

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

Mandatory 

Allowed values from R2R Cost Centre Value Mapping maintained for the Company Code associated to the Maintenance Plant.  

NAME1Name 1

Conditional

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

NAME2Name 2

Conditional

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

NAME3Name 3

Conditional

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

NAME4Name 4

Conditional

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

EQKTX_ENDescription of Equipment (English)

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

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

EQKTX_LCDescription of Equipment (Local Language)

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)

Mandatory

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)

Mandatory

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)

Mandatory

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

STAT_N1Sequential Status in User Status Profile

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)

Conditional

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

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

Conditional

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


2. Equipment Classification Data Construction Rules

Data ElementField DescriptionRule
zLegacyEQUNRLegacy Id

Mandatory

Key to link to the Legacy Object (Equipment/ Functional Location/ Assembly)

Should exist in Equipment Master DCT Rules

CLASSClass Name

Mandatory

  • Must always have 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 Id

Mandatory

Key to link to the Legacy Object (Equipment/ Functional Location/ Assembly)

Should exist in Equipment Master DCT Rules

TDLINE_ENText Line (English)

Mandatory

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. 

</Start CR0446>

The Long Text DCT is also applicable for legacy data in PF2/WP2

</End CR0446>



4. Inclusion-EQ Long Text Data Construction Rules

Data ElementField DescriptionRule
zLegacyEQUNRLegacy Equipment Number

Mandatory

Populate relevant Legacy Equipment Number for which Long Text has to be migrated. 

zLegacyWERKSLegacy Plant

Mandatory

</Start CR0446>

 

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

</End CR0446>

 


5. Equipment (Staging) Data Construction Rules 

Data ElementField DescriptionRule
OBJECTLegacy Object Type

Mandatory

Allowed Values: 'Functional Location', 'Equipment', 'Assembly'

Populate relevant Legacy Object Type applicable for consolidation or splitting

OBJECT_IDLegacy Object Id

Mandatory

Populate relevant Legacy Object Id (Functional Location Label/ Equipment Number/ Material Number)

zLegacyWERKSLegacy Plant

Mandatory

OPERATIONOperation

Mandatory

Populate 'Split' if the record has to be Split into multiple Ids. 

Populate 'Consolidate' where multiple records have be merged to one.

STAGING_ID

Staging Equipment Id

Mandatory.

Guideline to populate the Staging Id  - 

For Consolidation i.e merging multiple legacy objects into one

Legacy Object IdStaging Id
10000234 (Master)10000234
10000235 (Slave)10000234
10000236 (Slave)10000234
TPL_PROD_1235 (Master)TPL_PROD_1235
TPL_PROD_1236 (Slave)TPL_PROD_1235
TPL_PROD_1237 (Slave)TPL_PROD_1235
89993244 (Master)89993244
89993245 (Slave)89993244
89993246 (Slave)89993244

For Splitting single legacy objects into multiple

Legacy Object IdStaging Id
10000001

10000001_1

1000000110000001_2
1000000110000001_3
WLO_UTIL_X3512WLO_UTIL_X3512_1
WLO_UTIL_X3512WLO_UTIL_X3512_2
WLO_UTIL_X3512WLO_UTIL_X3512_3
812364533812364533_1
812364533812364533_2
812364533812364533_3

Note: Above DCT is only to populated for Legacy Objects (Functional Location, Equipment, Assembly) which require consolidation or splitting. 


 6. ENR-Equipment  Enrichment Data Construction Rules 

Field NameField DescriptionRule
zLegacyEQUNRLegacy Equipment Number

Mandatory

Values: Legacy Equipment Number

This field must not be edited.

</Start CR0446>


zLegacyEQKTXLegacy Equipment Description

Values: Legacy Equipment Description

This field must not be edited.

zLegacyHEQUILegacy Superordinate Equipment

Values: Legacy Superordinate Equipment Number

This field must not be edited.

zLegacyHEQUI_EQKTXLegacy Superordinate Equipment Description

Values: Legacy Superordinate Equipment Description

This field must not be edited.

zLegacyTPLNRLegacy Functional Location

Values: Legacy Functional Location

This field must not be edited.

zLegacyPLTXTLegacy Functional Location Description

Values: Legacy Functional Location Description

This field must not be edited.

zLegacyEQARTLegacy Technical Object Type

Values: Legacy Technical Object Type

This field must not be edited.

zLegacyEQARTXLegacy Technical Object Type Text

Values: Legacy Technical Object Type Text

This field must not be edited.

</End CR0446>


EQARTTechnical Object Type

Conditional

Allowed values from T370K to be populated

EQKTX_ENDescription of Equipment (English)

Conditional

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

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

EQKTX_LCDescription of Equipment (Local Language)

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

SUBMTConstruction type

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'

HEQUISuperordinate Equipment

Conditional

Populate if Equipment is a Sub-Equipment. 

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

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. 

EQFNRSort Field

</Start CR0446>

Mandatory
Conditional

</End CR0446>

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

STAT_N1Sequential Status in User Status Profile

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) 

Conditional

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

zLegacyPARNR_Z1

Partner (Asset Owner)

Mandatory

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)

Mandatory

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)

Mandatory

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

</Start CR0446>

 

BRGEWWeight

Conditional

Populate if information exists

GEWEIUnit of Weight

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. 

INGRPPlanner Group 

Conditional

Must Populate value if Equipment is in Installed Status.

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

GEWRKMain work center

Conditional

Must Populate value if Equipment is in Installed Status.

Allowed values from Work Centre DCT to be populated. 

BEBERPlant Section

Conditional

Allowed values from T357 to be populated for the Maintenance Plant (SWERK) selected

KOSTLCost Center

Conditional

Must Populate value if Equipment is in Installed Status

Allowed values from R2R Cost Centre Value Mapping. 

NAME1Name 1

Conditional

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

NAME2Name 2

Conditional

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

NAME3Name 3

Conditional

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

NAME4Name 4

Conditional

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

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

Conditional

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

</End CR0446>



7. Equipment Inclusion Data Construction Rules

Data ElementField DescriptionRule
zLegacyEQUNRLegacy Equipment Number

Mandatory

Populate Legacy Equipment Number to be included for Equipment migration

zLegacyWERKSLegacy Plant

Mandatory

COMMENTComment

Mandatory

Populate requirement for Inclusion


8. Equipment Exclusion Data Construction Rules

Data ElementField DescriptionRule
zLegacyEQUNRLegacy Equipment Number

Mandatory

Populate Legacy Equipment Number to be excluded for Equipment migration

zLegacyWERKSLegacy Plant

Mandatory

COMMENTComment

Mandatory

Populate requirement for Exclusion


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

Extraction Dependencies

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 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 HanaEQUIEQUNREquipment Number

Internally Generated Number 

2----S/4 HanaEQUIEQTYPEquipment CategoryDefault to 'M'
3PF2, WP2EQUIEQARTTechnical Object TypeS/4 HanaEQUIEQARTTechnical Object Type

Value MappingAsset_Technical Object Type

Overwrite with DCT if provided (as part of enrichment)

4PF2, WP2EQUIBRGEWWeightS/4 HanaEQUIBRGEWWeight

Direct Mapping

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

5PF2, WP2EQUIGEWEIUnit of WeightS/4 HanaEQUIGEWEIUnit of Weight

Direct Mapping

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

6

</Start CR0446>

DCT

PF2, WP2

</End CR0446>

EQUIINVNRInventory NoS/4 HanaEQUIINVNRInventory No

Direct Mapping

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

8PF2, WP2EQUIANSWTAcquisition ValueS/4 HanaEQUIANSWTAcquisition Value

Direct Mapping

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

9PF2, WP2EQUIWAERSCurrencyS/4 HanaEQUIWAERSCurrency

Direct Mapping

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

10PF2, WP2EQUIHERSTManufacturerS/4 HanaEQUIHERSTManufacturerDirect Mapping
11PF2, WP2EQUITYPBZModel NumberS/4 HanaEQUITYPBZModel NumberDirect Mapping
12PF2, WP2EQUISERGEManufacturer Serial NumberS/4 HanaEQUISERGEManufacturer Serial Number Direct Mapping
13PF2, WP2EQUIHERLDCountry/Region of ManufactureS/4 HanaEQUIHERLDCountry/Region of ManufactureDirect Mapping
14PF2, WP2EQUIBAUJJYear of constructionS/4 HanaEQUIBAUJJYear of constructionDirect Mapping
15PF2, WP2EQUIBAUMMMonth of ManufactureS/4 HanaEQUIBAUMMMonth of ManufactureDirect Mapping
16----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----S/4 HanaEQUZIWERKMaintenance Planning PlantCopy value populated for Target Maintenance Plant (SWERK)
18PF2, WP2EQUZINGRPPlanner Group S/4 HanaEQUZINGRPPlanner Group 

Value mapping : Maintenance Planner Group

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

19PF2, WP2EQUZGEWRKMain work centerS/4 HanaEQUZGEWRKMain work center

Value mapping : Work Center A2D 

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

20---

-

S/4 HanaEQUZWERGW

Plant associated with main work center

Copy value populated for Target Maintenance Plant (SWERK)
21DCTEQUZSUBMTConstruction typeS/4 HanaEQUZSUBMTConstruction type

Direct Mapping

22----S/4 HanaILOAABCKZABC Indicator

Derive the Indicator based on below logic -

  • Aggregate values for all Characteristics assigned (in Target CABN) to the Equipment which are relevant for Asset Criticality Analysis i.e having Characteristic Group (CABN_ATKLA) with Characteristic Group Name (TCMGT_ATKLT) = 'Criticality Risk Scoring' 
  • Derive ABC Indicator value by applying the below categorization on the aggregated value from the last step
    Value > 14500, then assign 'A'
    Value in Range 101 < 14500, then assign 'B'
    Value in Range 0 < 101, then assign 'C'
23PF2, WP2ILOASWERKMaintenance PlantS/4 HanaILOASWERKMaintenance PlantValue Mapping: Plant (Maintenance Plant = Yes)
24PF2, WP2ILOABEBERPlant SectionS/4 HanaILOABEBERPlant Section

Value mapping : Plant Section

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

25DCTILOAEQFNRSort FieldS/4 HanaILOAEQFNRSort Field

Direct Mapping

26PF2, WP2ILOABUKRSCompany CodeS/4 HanaILOABUKRSCompany CodeDerive the Company code from table 'T001K' where Target Maintenance Plant( SWERK) = T001K_BWKEY
27PF2, WP2ILOAKOSTLCost CenterS/4 HanaILOAKOSTLCost Center

Value Mapping : Cost Center

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

28----S/4 HanaILOAKOKRSControlling AreaDefault to 'CO01' (SYSQ Controlling Area)
29PF2, WP2ADRCNAME1Name 1S/4 HanaADRCNAME1Name 1

Direct Mapping

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

30PF2, WP2ADRCNAME2Name 2S/4 HanaADRCNAME2Name 2

Direct Mapping

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

31PF2, WP2ADRCNAME3Name 3S/4 HanaADRCNAME3Name 3

Direct Mapping

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

32PF2, WP2ADRCNAME4Name 4S/4 HanaADRCNAME4Name 4

Direct Mapping

</Start CR0446>

Overwrite with DCT if provided (as part of enrichment)

</End CR0446>

33PF2, WP2ADRCCOUNTRYCountry/Region KeyS/4 HanaADRCCOUNTRYCountry/Region KeyDerive Country/ Region from Table T001W where Target Maintenance Plant( SWERK) = T001K_BWKEY


2. Equipment Master Transformation Rule (DCT)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Direct Mapping

2--EQTYPEquipment CategoryS/4 HanaEQUIEQTYPEquipment CategoryDefault to 'M'
3DCTEQUIEQARTTechnical Object TypeS/4 HanaEQUIEQARTTechnical Object TypeDirect Mapping
4DCTEQUIBRGEWWeightS/4 HanaEQUIBRGEWWeightDirect Mapping
5DCTEQUIGEWEIUnit of WeightS/4 HanaEQUIGEWEIUnit of WeightDirect Mapping
6DCTEQUIINVNRInventory NoS/4 HanaEQUIINVNRInventory NoDirect Mapping
7----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

8DCTEQUIANSWTAcquisition ValueS/4 HanaEQUIANSWTAcquisition ValueDirect Mapping
9DCTEQUIWAERSCurrencyS/4 HanaEQUIWAERSCurrencyDirect Mapping
10DCTEQUIHERSTManufacturerS/4 HanaEQUIHERSTManufacturerDirect Mapping
11DCTEQUITYPBZModel NumberS/4 HanaEQUITYPBZModel NumberDirect Mapping
12DCTEQUISERGEManufacturer Serial NumberS/4 HanaEQUISERGEManufacturer Serial NumberDirect Mapping
13DCTEQUIHERLDCountry/Region of ManufactureS/4 HanaEQUIHERLDCountry/Region of ManufactureDirect Mapping
14DCTEQUIBAUJJYear of constructionS/4 HanaEQUIBAUJJYear of constructionDirect Mapping
15DCTEQUIBAUMMMonth of ManufactureS/4 HanaEQUIBAUMMMonth of ManufactureDirect Mapping
16----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----S/4 HanaEQUZIWERKMaintenance Planning PlantCopy value populated for Target Maintenance Plant (SWERK)
18DCTEQUZINGRPPlanner Group S/4 HanaEQUZINGRPPlanner Group Direct Mapping
19DCTEQUZGEWRKMain work centerS/4 HanaEQUZGEWRKMain work centerDirect Mapping
20----S/4 HanaEQUZWERGW

Plant associated with main work center

Copy value populated for Target Maintenance Plant (SWERK)
21DCTEQUZSUBMTConstruction typeS/4 HanaEQUZSUBMTConstruction typeDirect Mapping
22----S/4 HanaILOAABCKZABC Indicator

Derive the Indicator based on below logic -

  • Aggregate values for all Characteristics assigned (in Target CABN) to the Equipment which are relevant for Asset Criticality Analysis i.e having Characteristic Group (CABN_ATKLA) with Characteristic Group Name (TCMGT_ATKLT) = 'Criticality Risk Scoring' 
  • Derive ABC Indicator value by applying the below categorization on the aggregated value from the last step
    Value > 14500, then assign 'A'
    Value in Range 101 < 14500, then assign 'B'
    Value in Range 0 < 101, then assign 'C'
23DCTILOASWERKMaintenance PlantS/4 HanaILOASWERKMaintenance PlantDirect Mapping
24----S/4 HanaILOABEBERPlant Section

Copy the Plant Section value assigned to the Target Superordinate Equipment (HEQUI) if populated else copy the Plant Section value assigned to the populated Target Functional Location (TPLNR)

25DCTILOAEQFNRSort FieldS/4 HanaILOAEQFNRSort FieldDirect Mapping
26----S/4 HanaILOABUKRSCompany CodeDerive the Company code from table 'T001K' where Target Maintenance Plant( SWERK) = T001K_BWKEY
27DCTILOAzLegacyKOSTLCost CenterS/4 HanaILOAKOSTLCost CenterValue mapping : Cost Center
28----S/4 HanaILOAKOKRSControlling AreaDefault to 'CO01' (SYSQ Controlling Area)
29DCTADRCNAME1Name 1S/4 HanaADRCNAME1Name 1Direct Mapping
30DCTADRCNAME2Name 2S/4 HanaADRCNAME2Name 2Direct Mapping
31DCTADRCNAME3Name 3S/4 HanaADRCNAME3Name 3Direct Mapping
32DCTADRCNAME4Name 4S/4 HanaADRCNAME4Name 4Direct Mapping
33DCTADRCCOUNTRYCountry/Region KeyS/4 HanaADRCCOUNTRYCountry/Region KeyDerive Country/ Region from Table T001W where Target Maintenance Plant( SWERK) = T001K_BWKEY

 

3. Equipment Short Text Transformation Rule (ECC) 

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

Key to link to the Equipment Master

2PF2, WP2EQKTSPRASLanguage KeyS/4 HanaEQKTSPRASLanguage Key

Direct Mapping

Overwrite with DCT if provided (as part of enrichment) as below

  • If Description of Equipment (English) is populated in DCT, then SPRAS = 'E'.
  • If Description of Equipment (Local Language of Plant) is populated in DCT, then SPRAS = Language Key (Local Language of Plant)
3PF2, WP2EQKTEQKTXDescription of EquipmentS/4 HanaEQKTEQKTXDescription of Equipment

Direct Mapping

Convert to Upper Case

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
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQKTEQUNREquipment Number

Key to link to the Equipment Master

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

Direct Mapping

Convert to Upper Case

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQKTEQUNREquipment Number

Key to link to the Equipment Master

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

Direct Mapping

Convert to Upper Case


5. Equipment Installation Transformation Rule

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

Value Mapping: Equipment

2PF2, WP2, DCTEQUZHEQUISuperordinate EquipmentS/4 HanaEQUZHEQUISuperordinate Equipment

Value Mapping: Equipment

Overwrite with DCT if provided (as part of enrichment)

3PF2, WP2, DCTILOATPLNRFunctional LocationS/4 HanaILOATPLNRFunctional Location

Value Mapping: Equipment

Overwrite with DCT if provided (as part of enrichment)

4----S/4 HanaDATA_INSTALLINST_DATEInstallation DateDefault Current System Date
5----S/4 HanaDATA_INSTALLINST_TIMEInstallation TimeDefault Current System Time
6----S/4 Hana

INHERITANCE_FLAGS

STORT-Default 'E'
7----S/4 Hana

INHERITANCE_FLAGS

MSGRP-Default 'E'
8----S/4 Hana

INHERITANCE_FLAGS

BEBER-Default 'E'
9----S/4 Hana

INHERITANCE_FLAGS

PPSID-Default 'E'
10----S/4 Hana

INHERITANCE_FLAGS

ABCKZ-Default 'E'
11----S/4 Hana

INHERITANCE_FLAGS

EQFNR-Default 'E'
12----S/4 Hana

INHERITANCE_FLAGS

GSBER-Default 'E'
13----S/4 Hana

INHERITANCE_FLAGS

KOSTL-Default 'E'
14----S/4 Hana

INHERITANCE_FLAGS

PROID-Default 'E'
15----S/4 Hana

INHERITANCE_FLAGS

DAUFN-Default 'E'
16----S/4 Hana

INHERITANCE_FLAGS

AUFNR-Default 'E'
17----S/4 Hana

INHERITANCE_FLAGS

IWERK-Default 'E'
18----S/4 Hana

INHERITANCE_FLAGS

INGRP-Default 'E'
19----S/4 Hana

INHERITANCE_FLAGS

GEWRK-Default 'E'
20----S/4 Hana

INHERITANCE_FLAGS

RBNR-Default 'E'
21----S/4 Hana

INHERITANCE_FLAGS

VKORG-Default 'E'
22----S/4 Hana

INHERITANCE_FLAGS

VTWEG-Default 'E'
23----S/4 Hana

INHERITANCE_FLAGS

SPART-Default 'E'
24----S/4 Hana

INHERITANCE_FLAGS

ADRNR-Default 'E'
25----S/4 Hana

INHERITANCE_FLAGS

VKBUR-Default 'E'
26----S/4 Hana

INHERITANCE_FLAGS

VKGRP-Default 'E'

Note - Equipment Installation Target is based on BAPI_EQUI_INSTALL structure


6. Equipment Classification Transformation Rule (ECC)

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

Value Mapping: Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaINOBOBTABName of Database Table for ObjectDefault to 'EQUI'
4----S/4 HanaKSSKCLASSClass Name

Default below Classes -

  • 'EAM_9999' (General Class)
  • EAM_<TOT> (Tech Object EQART assigned to Equipment) 
    For e.x if EQUART  = '01_01_001', then assign 'EAM_01_01_001' as the Class. 
5PF2, WP2CABNATNAMCharacteristic NameS/4 HanaAUSPATNAMCharacteristic Name

Derive the Target Value as below:

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

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

6PF2, WP2AUSPPOSNR Item 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

  

7. 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
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Value Mapping: Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSClass NameS/4 HanaKSSKCLASSClass NameDirect Mapping
5DCTAUSPATNAMCharacteristic NameS/4 HanaAUSPATNAMCharacteristic Name

Direct Mapping

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
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Value Mapping: Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSClass 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
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Value Mapping: Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSClass 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
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Value Mapping: Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSClass 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
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Value Mapping: Equipment

2----S/4 HanaKSSKKLARTClass TypeDefault to '002'
3----S/4 HanaKSSKOBTABName of Database Table for ObjectDefault to 'EQUI'
4DCTKSSKCLASSClass NameS/4 HanaKSSKCLASSClass NameDirect Mapping
5DCTAUSPATNAMCharacteristic NameS/4 HanaAUSPATNAMCharacteristic 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


8. Equipment Partner Transformation Rule (DCT)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment Master

2-

-

-

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

-

-

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

Value mapping : Vendor Number

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment Master

2-

-

-

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

-

-

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

Value mapping : Vendor Number

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Key to link to the Equipment Master

2-

-

-

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

-

-

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

Value mapping : Contact Person


9. Equipment User Status Transformation Rules (ECC)

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

Value Mapping: Equipment

2----S/4 HanaJSTOSTSMAStatus profile of the EquipmentDefault to 'ZEAMEQ01'
3PF2, 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)

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


10. Equipment User Status Transformation Rules (DCT)

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Value Mapping: 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

Direct Mapping

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Value Mapping: 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

Direct Mapping

UNION

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1DCT-zLegacyEQUNRLegacy IdS/4 HanaEQUIEQUNREquipment Number

Value Mapping: 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

Direct Mapping


11. Equipment Long Text Header (ECC)

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

PF2, WP2

</Start CR0446>

DCT

</End CR0446>

EQUIEQUNREquipment NumberS/4 HanaSTXHTDNAMEName

Concatenate '000000000' + Target Equipment Number derived from Value Mapping: Equipment

3----S/4 HanaSTXHTDIDText IDDefault to 'LTXT'
4

PF2, WP2

</Start CR0446>

DCT

</End CR0446>

STXHTDSPRASLanguage KeyS/4 HanaSTXHTDSPRASLanguage KeyDirect Mapping

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

</Start CR0446>

Include records added in the DCT

</End CR0446>


12. Equipment Long Text Header (DCT)

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

Concatenate '000000000' + Target Equipment Number derived from Value Mapping: Equipment

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 'EQUI'
2DCT-zLegacyEQUNRLegacy IdS/4 HanaSTXHTDNAMEName

Concatenate '000000000' + Target Equipment Number derived from Value Mapping: Equipment

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


13. Equipment Long Text Line (ECC)

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

PF2, WP2

</Start CR0446>

DCT

</End CR0446>

EQUIEQUNREquipment NumberS/4 HanaSTXHTDNAMEName

Concatenate '000000000' + Target Equipment Number derived from Value Mapping: Equipment

3----S/4 HanaSTXLTDIDText IDDefault to 'LTXT'
5

PF2, WP2

</Start CR0446>

DCT

</End CR0446>

STXHTDSPRASLanguage KeyS/4 HanaSTXLTDSPRASLanguage KeyDirect Mapping
6----S/4 HanaSTXLTDFORMATTag columnDefault to "*"
</Start CR0446>  


 


 
7PF2, WP2STXHROWCOUNTRow NumberS/4 HanaSTXLROWCOUNTRow NumberDirect Mapping
</End CR0446 


 


 
8

PF2, WP2

</Start CR0446>

DCT

</End CR0446>

STXLTDLINEText LineS/4 HanaSTXLTDLINEText Line

Direct Mapping

Convert to Upper Case

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

</Start CR0446>

Include records added in the DCT

</End CR0446>


14. Equipment Long Text Line (DCT)

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

Concatenate '000000000' + Target Equipment Number derived from Value Mapping: Equipment

3----S/4 HanaSTXHTDIDText IDDefault to 'LTXT'
5DCTSTXHTDSPRASLanguage KeyS/4 HanaSTXHTDSPRASLanguage KeyDefault to 'E'
6----S/4 HanaSTXLTDFORMATTag columnDefault to "*"
</Start CR0417> 



 



7----S/4 HanaSTXLROWCOUNTRow NumberFor each 132-character string generated, create a separate target row and increment the row number by 1 in sequence until the complete text is split.
</End CR0417>



 



8DCTSTXLTDLINE_ENText LineS/4 HanaSTXLTDLINEText Line

</Start CR0417>

Direct Mapping

Split the DCT long text into consecutive 132-character strings. For each 132-character string generated, create a separate target row and increment the row counter by 1 in sequence until the complete text is split.

</End CR0417>

Convert to Upper Case

UNION

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

Concatenate '000000000' + Target Equipment Number derived from Value Mapping: Equipment

3----S/4 HanaSTXHTDIDText IDDefault to 'LTXT'
5DCTSTXHTDSPRAS_LCLanguage KeyS/4 HanaSTXHTDSPRASLanguage KeyDirect Mapping
6----S/4 HanaSTXLTDFORMATTag columnDefault to "*"
</Start CR0417>  


 


 
7----S/4 HanaSTXLROWCOUNTRow NumberFor each 132-character string generated, create a separate target row and increment the row number by 1 in sequence until the complete text is split.
</End CR0417>



 



8DCTSTXLTDLINE_LCText LineS/4 HanaSTXLTDLINEText Line

</Start CR0417>

Direct Mapping

Split the DCT long text into consecutive 132-character strings. For each 132-character string generated, create a separate target row and increment the row counter by 1 in sequence until the complete text is split.

</End CR0417>

Convert to Upper Case


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


Transformation Mapping

Mapping Table NameMapping Table Description
OTH_Migration_Date Relevant Values A2DDates to be defaulted for A2D objects for each Migration Cycle
Assembly and Construction Type  

Mapping of legacy Assembly/ Construction Type to new Assembly/ Construction Type

Characteristic A2D (Staging)Old to Staging Characteristic A2D
Characteristic A2DOld to New Characteristic A2D
Class A2DOld to New Class A2D
Contact PersonOld to New Contact Person
Cost CentreOld to New Cost Center
Equipment (Staging)Legacy to Staging Equipment
EquipmentLegacy/Staging to New Equipment
Functional LocationList of relevant Asset Functional Locations slated for migration, including the Target Technical Object. This will also be used for Old to New Functional Location Mapping
Maintenance Planner GroupOld to New Planner Group
PlantOld Plant to New Plant
Plant SectionOld to new Plant Section
User Status Equipment

Old to New Equipment User Status

Vendor Number

LIFNR: Old Vendor Code to New Vendor Code

Work Centre A2DOld to new Work Centre A2D
</Start CR0282>  

OTH_Technical Object Type_APM


List of Functional Location and Equipment TOTs required for migrating historical Measurement Documents and Notifications

OTH_Plant_APM

List of Plants required for migrating historical Measurement Documents and Notifications

</End CR0282> 

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 Data Team
2Ensure all Transformation mappings are up to dateSyWay 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 systems and/or the  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

1

Ensure Pre-load sign-offs are obtained.

SyWay Data team

2

Go to the load tool and select the correct load Program.

SyWay Data team

3

Proceed with Data load.

SyWay Data team

4

Validate few records loaded by accessing standard transactions.

SyWay Data team

5

Generate the post load reports in the tool.

SyWay Data team

6

Log errors as defects, if any and address resolutions. Close defects.

SyWay Data team

7

Resolve defects by re-upload and re-generate post load reports if necessary.

SyWay Data team

8

Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off.

Business

9

Repeat steps 5 to 7 if necessary.

SyWay Data team


Load Phase and Dependencies

Pre-Cutover : 1002 Equipment

Pre-Cutover : 1002a Equipment Installation

Pre-Cutover : 1002b Equipment Classification

Pre-Cutover : 1002c Equipment User Status

Pre-Cutover : 1002d Equipment Long Text

Pre-Cutover : 1002e Equipment Partner Assignment

Note: A separate load program may need to be created for 1002b, 1002c, 1002d, 1002e. If these become a risk to the actual cutover and need to be removed from the critical path. This will be evaluated post Mock 1

Configuration

Item #Configuration Item
1

T370T - Equipment Category

2

T370K - Object Type

3

TCURC - Currency

4

T005 - Country of manufacturer

5

T001W - Maintenance Plant

6

T357 - Plant Section

7

T370C - ABC indicator

8

T399I - Planning Plant

9

T024I - Planner Group

10

TPAR - Business Partner: Functions

11

T002 - Language Keys

Conversion Objects

Object #Preceding Object Conversion Approach
1003Functional Location
1006

Work Centre

1074

Cost Center

1010

PM Assembly/ Construction Types

1015

Characteristics

1009

Class

3018

Business Partner - FI Vendor (FLVN00)

2019Materials - Basic Data View
2020Materials - Purchasing View
3011Contact Person

Error Handling

Error TypeError DescriptionAction Taken

Configuration

Invalid Equipment category

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 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 Partner Function

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

Configuration

Invalid Language Key

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

Invalid Data

Invalid Superordinate Equipment

Expedite whether the master data is changed in the system

Invalid Data

Invalid Functional Location

Expedite whether the master data is changed in the system

Invalid Data

Invalid Work Centre

Expedite whether the master data is changed in the system

Invalid Data

Invalid Cost Center

Expedite whether the master data is changed in the system

Invalid Data

Invalid Construction Type

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 Characteristics

Expedite whether the master data is changed in the system

Invalid Data

Invalid Vendor Business Partner

Expedite whether the master data is changed in the system

Invalid Data

Invalid Material Number in Inventory Number Field

Expedite whether the master data is changed in the system


Post-Load Validation

Project Team

Completeness

TaskAction

Verify Count

SyWay A2D Data team to verify the record count created in target S/4 HANA by accessing post load reports in ADMM 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

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


Business

Completeness

TaskAction

Verify Count

Download Post Load Reports from ADMM 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 Equipment data in target S/4 HANA were loaded correctly via ADMM 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.
  • Data cleansing has met the required percentage threshold for the specified mock cycle and all preparation activities have been completed.
  • Data entries in DCT are target-ready data unless a specific transformation rule is stated for that field in the transformation rules
  • Equipment can't exist stand alone and should always be installed under a Superior Equipment or a Functional Location.
  • Material record shall be created for Specific Critical capital spares along with a Fixed Asset record. Equipment related to these critical spares shall be assigned with the material record created as the Inventory Number (INVNR). Sequentially, the Fixed Asset will be updated with the specific Equipment record
  • Equipment having serial no. populated in legacy are spares and are not be migrated as in the Syensqo target design spares will be identified by Material Masters only. 
  • Any Functional Location relevant for Asset Integration shall be migrated as Equipment and flagged in the Functional Location Mapping. 
  • For Object being split into multiple Equipment, all data including Master, Classification, Partner, Long Text to be managed using DCT. Split Object to be maintained in the EXC-Equipment exclusion list. 
  • For Objects being consolidated into one Equipment, the master will be transformed and the slave objects will be maintained in the EXC-Equipment exclusion list.
  • Below is the criteria for Critical Materials to be populated as the Inventory Number. Business will be populate the data based on the information provided by functional team

    • 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.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 165) 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