Purpose

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

A Notification is a structured record in SAP PM used to report, track, and manage maintenance issues or requests.
It acts as the starting point for most maintenance processes, ensuring that problems, inspections, or service requests are documented and communicated.

Legacy Plant Maintenance Notification is using a diverse range of formats across the different systems. As per SyWay design, EAM Notification will be standardized.


Conversion Scope

The scope of this document covers the approach for converting active Notification from Legacy Source Systems into S/4HANA.

In standard SAP functionality whenever an asset or its component is identified as having suffered a fault or malfunction, a maintenance notification is created to report the event and to request maintenance.  The appropriate technical object (i.e. functional location or equipment) that represents the asset is referenced on that notification along with the suspected symptom and other information (e.g. priority, short / long description, date, reported by, breakdown indicator, etc.)

In general terms, a notification can be utilised in the following situations:

  • Corrective Maintenance work identification - non-breakdown maintenance requests, in-service breakdowns, extra malfunctions uncovered during routine maintenance
  • Activity reports during routine maintenance and inspections
  • Work order execution and completion - recording of technical data such as failure/cause codes)
  • Condition-based / predictive maintenance - creation of notifications when asset reaches an exceptional technical condition (e.g. measurements exceed or fall below a certain tolerance)

Besides capturing maintenance requests and providing a means to track outstanding faults/defects and their current rectification, notifications are also used to capture malfunction and failure data which is crucial for long-term asset reliability analysis.

The data from legacy system includes:

  1. All Open Notifications (Source System Status: Outstanding, In Process (TJ02T-TXT04 = OSNO or NOPR)
  2. Assigned to active legacy Functional Location (IFLOT-TPLNR) (Source System Status Not any of these: Inactive, Delete (TJ02T-TXT04 = INAC or DLFL))
  3. Assigned to active legacy Equipment (EQUI-EQUNR) (Source System Status Not any of these: Inactive, In the warehouse, Available (TJ02T-TXT04 = INAC, ESTO or AVLB)) 
  4. Notifications having Maintenance Plant (QMEL-ARBPLWERK) in scope - Refer to Value Mapping: Plant (Maintenance Plant = Yes)
  5. Closed Notifications associated to relevant Functional Locations and Equipment for the past 3 years, limited to specific Technical Object Type (listed in OTH_Technical Object Type_APM) and specific list of Maintenance Plants only (for APM Historical Data)

The data from legacy system excludes:

  1. Notification with Source System Status Notification completed status (TJ02T-TXT04 = NOCO)
  2. Open Notifications with closed Work Orders (AUFK-AUFNR) (Source System Status: Closed (TJ02T-TXT04 = CLSD))

    APM - Historical Data
    Closed Notifications associated to relevant Functional Locations and Equipment for the past 3 years, limited to specific Technical Object Type (listed in OTH_Technical Object Type_APM) and specific list of Maintenance Plants only

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 Measurement Documents will be extracted from PF2 and WP2

110,000

S/4HANA

110,000

Additional Information

Multi-language Requirement

Notification does not have multi language support. Notification text will be migrated using EN logon. 

Document Management

Refer to the Document Management in the SyWay Solution.

Note: Documents attached to Notification 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.Notification Header

TableFieldData ElementField DescriptionData TypeLengthRequirement (Notif. Type Y1)Requirement (Notif. Type Y2)
QMELQMNUMQMNUMNotification NumberCHAR12Mandatory 
QMELQMARTQMARTNotification TypeCHAR2Mandatory 
QMELQMTXTQMTXTShort TextCHAR40Mandatory 
QMELARTPRARTPRPriority Type CHAR2Mandatory 
QMIHEQUNREQUNREquipment numberCHAR18Conditional 
ILOATPLNRTPLNRFunctional LocationCHAR30Mandatory 
QMIHINGRPINGRPPlanner GroupCHAR3Conditional 
QMIHIWERKIWERKMaintenance Planning PlantCHAR4Mandatory 
QMELARBPLLGWIDObject ID of the Work CenterNUMC8Conditional 
QMELQMDATQMDATDate of NotificationDATS8Mandatory 
QMELMZEITMZEITTime of NotificationTIMS6Mandatory 
QMELPRIOKPRIOKPriorityCHAR1Mandatory 
QMELERNAMERNAMReported ByCHAR12Mandatory 
QMELERDATERDATDate on Which Record Was CreatedDATS8Mandatory 
QMELAENAMAENAMName of Person Who Changed ObjectCHAR12Conditional 
QMELAEDATAEDATChanged OnDATS8Conditional 
QMELMZEITMZEITTime of NotificationTIMS6Mandatory 
QMELQMDATQMDATDate of NotificationDATS8Mandatory 
QMELQMNAMQMNAMName of Person Reporting NotificationCHAR12Mandatory 
QMELSTRMNSTRMNRequired Start DateDATS8Mandatory 
QMELSTRURSTRURRequired Start TimeTIMS6Mandatory 
QMELLTRMNLTRMNRequired End DateDATS8Mandatory 
QMELLTRURLTRURRequested End TimeTIMS6Mandatory 
QMELAUFNRAUFNROrder NumberCHAR12Conditional 
QMELOBJNRQMOBJNRObject Number for Status ManagementCHAR22System 
QMELRBNRRBNRCatalog ProfileCHAR9Conditional 
QMELRBNRIRBNRIOrigin of Notifications Catalog ProfileCHAR1Mandatory 
QMELINDTXINDLTXObject Long Text AvailableCHAR1Mandatory 
QMELKZMLAKZMLAPrimary language indicator for text segmentCHAR1Mandatory 
QMELHERKZHERKZOrigin of NotificationCHAR2Mandatory
QMELBEZDTBEZDTNotification Reference DateDATS8Mandatory 
QMELBEZURBEZUR_DNotification Reference TimeTIMS6Mandatory 
QMELAEZEITAEZEITTime of ChangeTIMS6Mandatory 
QMELERZEITERZEITTime, at Which Record Was AddedTIMS6Mandatory 
QMELQMKATQMKATCatalog Type - CodingCHAR1Mandatory 
QMELQMGRPQMGRPCode Group - CodingCHAR8Mandatory 
QMELQMCODQMCODCodingCHAR4Mandatory 
QMELCROBJTYCR_OBJTYObject types of the CIM resourceCHAR2Mandatory 
QMELARBPLLGWIDObject ID of the Work CenterNUMC8Mandatory 
QMELARBPLWERKQARBPWERKSPlant for Work CenterCHAR4Mandatory 
QMELTZONSOTZONSOTime Zone for NotificationCHAR6Mandatory 
QMELPHASEQM_PHASENotification Processing PhaseCHAR1  






  
QMIHILARTILAMaintenance activity typeCHAR3Mandatory 
QMIHREVNRREVNIRevisionCHAR8Conditional 
QMIHMSAUSMSAUSBreakdown IndicatorCHAR1Conditional 
QMIHAUSVNAUSVNMalfunct. Start DateDATS8Conditional 
QMIHAUZTVAUZTVMalfunct. Start TimeTIMS6Conditional 
QMIHAUSBSAUSBS

Malfunct. End Date

DATS8Conditional 
QMIHAUZTBAUZTBMalfunct. End TimeTIMS6Conditional 
QMIHAUSZTAUSZT

Breakdown Duration

FLTP16Conditional 
QMIHMAUEHMAUEH

Breakdown Unit

UNIT3Conditional 

 2.Notification Header Long Text Header

TableFieldData ElementField DescriptionData TypeLengthRequirement
STXHTDOBJECTTDOBJECTTexts: application objectCHAR10Mandatory
STXHTDNAMETDOBNAMENameCHAR70Mandatory
STXH

TDID

TDID

Text IDCHAR4Mandatory
STXHTDSPRASSPRASLanguage KeyLANG1Mandatory

3.Notification Header Long Text Line

TableFieldData ElementField DescriptionData TypeLengthRequirement
STXLTDOBJECTTDOBJECTTexts: application objectCHAR10Mandatory
STXLTDNAMETDOBNAMENameCHAR70Mandatory
STXL

TDID

TDID

Text IDCHAR4Mandatory
STXLTDSPRASSPRASLanguage KeyLANG1Mandatory
STXLCLUSTD_TAGTDFORMAT

Tag column

CHAR1

Mandatory

STXLROWCOUNTROWCOUNT

Row number

NUMC10Mandatory
STXLTXLINETDLINE

Text Line

CHAR72Mandatory

4.Notification Item

TableFieldData ElementField DescriptionData TypeLengthRequirement
QMFEQMNUMQMNUMNotification NumberCHAR12Mandatory
QMFEFENUMFELFDItem Number in Item RecordNUMC4Mandatory
QMFEFETXTFETXTNotification Item Short TextCHAR40Mandatory
QMFEFEGRPFEGRPCode Group - ProblemCHAR8Conditional
QMFEFECODFECODProblem or Damage CodeCHAR4Conditional
QMFEOTGRPOTGRPCode Group - Object PartsCHAR8Conditional
QMFEOTEILOTEILPart of ObjectCHAR4Conditional
QMURURTXTURSTXCause TextCHAR40Conditional
QMURURGRPURGRPCode Group - CausesCHAR8Conditional
QMURURCODURCODCause CodeCHAR4Conditional

Note: Each Notification Header can have many Notification Items

 5.Notification Item Long Text Header

TableFieldData ElementField DescriptionData TypeLengthRequirement
STXHTDOBJECTTDOBJECTTexts: application objectCHAR10Mandatory
STXHTDNAMETDOBNAMENameCHAR70Mandatory
STXH

TDID

TDID

Text IDCHAR4Mandatory
STXHTDSPRASSPRASLanguage KeyLANG1Mandatory

6.Notification Item Long Text Line

TableFieldData ElementField DescriptionData TypeLengthRequirement
STXLTDOBJECTTDOBJECTTexts: application objectCHAR10Mandatory
STXLTDNAMETDOBNAMENameCHAR70Mandatory
STXL

TDID

TDID

Text IDCHAR4Mandatory
STXLTDSPRASSPRASLanguage KeyLANG1Mandatory
STXLCLUSTD_TAGTDFORMAT

Tag column

CHAR1

Mandatory

STXLROWCOUNTROWCOUNT

Row number

NUMC10Mandatory
STXLTXLINETDLINE

Text Line

CHAR72Mandatory

 7. Quality notification - causes

TableFieldData ElementField DescriptionData TypeLengthRequirement
QMELQMNUMQMNUMNotification NumberCHAR12Mandatory
QMURFENUMFELFDItem Number in Item RecordNUMC4Mandatory
QMURURNUMURNUMSequential Number for CauseNUMC4Mandatory
QMUR

URGRP

URGRP

Code Group - Causes

CHAR8Conditional
QMUR

URCOD

URCOD

Cause Code

CHAR4Conditional
QMUR

URTXT

URSTX

Cause Text

CHAR40Conditional



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

9004-001


C1 

Notification with assigned Functional Location which is not Relevant (as per Relevancy Criteria)

Notification as per Relevancy Criteria assigned with an Equipment / Functional which does not belong below:

  1. Functional Location as per Relevancy Criteria

Notification Number, Short Text, Plant for Work Centre, Functional Location

PF2, WP2

9004-002

C1 

Notification with assigned Equipment which is not Relevant (as per Relevancy Criteria)

Notification as per Relevancy Criteria assigned with an Equipment / Functional which does not belong below:

  1. Equipment as per Relevancy Criteria

Notification Number, Short Text, Plant for Work Centre, Equipment

 PF2, WP2

9004-003

C1

Catalog Code Groups: Invalid or Inactive Catalog Code Groups & Code linked to Notification

Notification as per Relevancy Criteria assigned with a Catalog Code Groups & Code does not belong below:
1. Catalog Code Groups & Code as per Relevancy Criteria

Notification Number, Short Text, Plant for Work Centre, Catalog Code Groups & Code

PF2, WP2

9004-004

C1

Maintenance Item: Invalid or Inactive Maintenance Item linked to Notification

Notification as per Relevancy Criteria assigned with a Maintenance Plan and Item does not belong below:
1. Maintenance Plan and Item as per Relevancy Criteria

Notification Number, Short Text, Plant for Work Centre, Maintenance Item

PF2, WP2

9004-005


C1

Revision: Invalid or Inactive Revision linked to Notification 

Notification as per Relevancy Criteria assigned with a Revision does not belong below:
1. Revision as per Relevancy Criteria 

Notification Number, Short Text, Plant for Work Centre, Revision

PF2, WP2

9004-006

C1


Work Centre: Invalid or Inactive Work Centre linked to Notification

Notification as per Relevancy Criteria assigned with a Work Centre does not belong below:
1. Work Centre as per Relevancy Criteria

Notification Number, Short Text, Plant for Work Centre, Work Centre 

PF2, WP2


9004-007

C2

Notification Creation Date: Open Notifications older than 3 months with No Work Order Assigned 

Open Notifications older than 3 months with No Work Order Assigned (Status ORAS = Work Order Assigned)

Notification Number, Short Text, Plant for Work Centre, Notification Creation Date

PF2, WP2

9004-008

C1

Plant: Notification Plant incorrectNotification as per Relevancy Criteria with Invalid Plant (T001W)Notification Number, Short Text, Plant for Work Centre

PF2, WP2

9004-009

C1 

Planner Group: Invalid or no Planner Group linked to Notification

Notification as per Relevancy Criteria with no Planner Group Assigned or Invalid Planner Group (T024I) 

Notification Number, Short Text, Plant for Work Centre, Planner Group 

PF2, WP2

9004-010

C2

Description: Notification contains Thai characters

Notification Description with Thai characters

Notification Number, Short Text, Plant for Work Centre

PF2, WP2

9004-011

C1

Notification with assembly only

Notification with assembly without Functional Location / Equipment

Notification Number, Short Text, Plant for Work Centre, Assembly

PF2, WP2

9004-012

C1

Notification for non asset level in legacy system

Notification assigned to non asset level Functional Location

Notification Number, Short Text, Plant for Work Centre, Functional Location

PF2, WP2

9004-013  

C2

Notification Short Text contain informal word

Notification Short Text contain informal word

Notification Number, Short Text, Plant for Work Centre

PF2, WP2

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

Informal Words **

Group 1

Group 2

Group 3

Group 4

Group 5

*DNU

Delete

donot

Formerly

Old #

..

Deletion

DONT USE

From

Old[ ]

/

DELISTED

DON'T USE

Incorrect

PLEASE USE

?

Discontinued

Dup Use

Invalid

Pls Use

@

Disposable

DUPLICATE

New

Previously

^

DNU

-DUPLICATE

NOT ACTIVE

Replace

+

Do Not

DUPLICATION

not in use

Replaced

++

Do Not Re

Duplicidad

Not Used

RESERVED

£

Do Not Sell

Duplikat

NOT VALID

Retired

Defective

Do Not Use

Former

Obsolete

ZZDEL


Conversion Process

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

For sites that are not on SAP-PF2 and WP2 systems, collection will be done manually in the data collection template.


Data Privacy and Sensitivity


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

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)

No DCT will be used for Notification.

Notification DCT Rules

Field NameField DescriptionRule

Not applicable



 Extraction Dependencies

List the steps that need to occur before extraction can commence

Item #Step DescriptionTeam Responsible
1Relevancy Criteria for Catalog Profile

SyWay A2D Data Team

2Relevancy Criteria for Catalog Code Groups & Codes

SyWay A2D Data Team

3Relevancy Criteria for Characteristics

SyWay A2D Data Team

4Relevancy Criteria for Class

SyWay A2D Data Team

5Relevancy Criteria for Construction Type

SyWay A2D Data Team

6Relevancy Criteria for Equipment

SyWay A2D Data Team

7Relevancy Criteria for Functional Location

SyWay A2D Data Team

8Relevancy Criteria for Maintenance Plan and Item

SyWay A2D Data Team

9Relevancy Criteria for Revision

SyWay A2D Data Team

10Relevancy Criteria for Task List

SyWay A2D Data Team

11Relevancy Criteria for Work Centre

SyWay A2D Data Team


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

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.Notification Header Data Construction Rules

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

PF2, WP2 

QMEL

QMNUM

Notification Number

S/4 HANA

QMEL

QMNUM

Notification Number

System (Internal numbering).

2

PF2, WP2 

QMEL

AUFNR

Order Number

S/4 HANA

QMEL

AUFNR

Order Number

Value Mapping: Work Order

3PF2, WP2QMELQMARTNotification TypeS/4 HANAQMELQMARTNotification TypeDirect Mapping.
4PF2, WP2QMELQMTXTShort TextS/4 HANAQMELQMTXTShort TextDirect Mapping.
Only if notification does not exist for PM01 Work Order, default to: Work Order Description
5PF2, WP2QMELEQUNREquipment NumberS/4 HANAQMELEQUNREquipment Number

If not blank then Value Mapping: Equipment Number

If blank or cannot be mapped, and if linked to Work Order, then use Work Order value.

6PF2, WP2QMELTPLNRFunctional LocationS/4 HANAIFLOTPLNRFunctional Location Label

Default to blank if Equipment is not blank.

If not blank then Value Mapping: Functional Location.

If blank or cannot be mapped, and if linked to Work Order, then use Work Order value.

7PF2, WP2QMIHINGRPPlanner GroupS/4 HANAVIQMLINGRPPlanner Group

Value Mapping: Planner Group

If blank or cannot be mapped, and if linked to Work Order, then use Work Order value.

8PF2, WP2CRHDARBPLWork CentreS/4 HANACRHDARBPLWork Centre

Value Mapping: Work Centre

9PF2, WP2CRHDWERKSWork Centre plantS/4 HANACRHDWERKSWork Centre plant

Value Mapping: Plant (Maintenance Plant = Yes)

10PF2, WP2QMELQMDATNotification DateS/4 HANAQMELQMDATNotification DateDirect Mapping.
If notification does not exist for PM01 Work Order, default to: Work Order Basic Start Date
11PF2, WP2QMELMZEITNotification TimeS/4 HANAQMELMZEITNotification TimeDirect Mapping.
Only if notification does not exist for PM01 Work Order, default to: 00:00:00
12PF2, WP2QMELERNAMReported ByS/4 HANAQMELERNAMReported ByDirect Mapping.
Only if notification does not exist for PM01 Work Order, default to: Migration User ID (Name)
13PF2, WP2QMELSTRMNRequired Start DateS/4 HANAQMELSTRMNRequired Start DateIf STRMN is blank, and if linked to Work Order, then use Work Order value for both start and end date
If End Date is earlier than Start Date, then default both Start and End Date from Work Order.
If Start Date is before 2 years prior to go live date, then default both Start and End Date from Work Order.
14PF2, WP2QMELLTRMNRequired End DateS/4 HANAQMELLTRMNRequired End DateIf LTRMN is blank, and if linked to Work Order, then use Work Order value for both start and end date
If End Date is earlier than Start Date, then default both Start and End Date from Work Order>
If End Date is before 2 years prior to go live date, then default both Start and End Date from Work Order.
If LTRMN is blank and not linked to Work Order, copy Start Date into End Date.
Validation Rule: End Date cannot be earlier than start date
15PF2, WP2QMELPRIOKPriorityS/4 HANAQMELPRIOKPriority

Value Mapping: Priority

Only if notification does not exist for PM01 Work Order, default to: Low

16PF2, WP2QMELQMGRPCode GroupS/4 HANAQMELQMGRPCode GroupDirect Mapping.
17PF2, WP2QMELQMCODCodingS/4 HANAQMELQMCODCodingDirect Mapping.
18PF2, WP2QMELRBNRCatalog ProfileS/4 HANAQMELRBNRCatalog ProfileDerive from Functional Location
19----


Issue PermitIf Notification is assigned to Work Order then default to “X”.
20PF2, WP2QMIHILARTMaintenance Activity TypeS/4 HANAQMIHILARTMaintenance Activity TypeDerive from Work Order ILART
21PF2, WP2QMIHREVNRRevisionS/4 HANAQMIHREVNRRevisionDirect Mapping.
22PF2, WP2

QMIH

MSAUSBreakdown IndicatorS/4 HANA

QMIH

MSAUSBreakdown IndicatorDirect Mapping.
23PF2, WP2

QMIH

AUSVNMalfunct. Start DateS/4 HANA

QMIH

AUSVNMalfunct. Start DateDirect Mapping.
24PF2, WP2

QMIH

AUZTVMalfunct. Start TimeS/4 HANA

QMIH

AUZTVMalfunct. Start TimeDirect Mapping.
25PF2, WP2

QMIH

AUSBSMalfunct. End DateS/4 HANA

QMIH

AUSBSMalfunct. End DateDirect Mapping.
26PF2, WP2

QMIH

AUZTBMalfunct. End TimeS/4 HANA

QMIH

AUZTBMalfunct. End TimeDirect Mapping.
27PF2, WP2

QMIH

AUSZTBreakdown DurationS/4 HANA

QMIH

AUSZTBreakdown DurationDirect Mapping.
28PF2, WP2

QMIH

MAUEHBreakdown UnitS/4 HANA

QMIH

MAUEHBreakdown UnitDirect Mapping.

 2.Notification Item Data Construction Rules

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

PF2, WP2 

QMIH

QMNUM

Notification Number

S/4 HANA

QMEL

QMNUM

Notification Number

System (Internal numbering).

2PF2, WP2QMFEIWERKMaintenance Planning PlantS/4 HANAVIQMLWERKMaintenance Planning PlantDefault to Planning Plant from reference technical object.
3PF2, WP2QMFEARBPLObject ID for Work CentreS/4 HANAQMFEARBPLObject ID for Work Centre

Value Mapping: Work Centre

If blank or cannot be mapped:

  1. If linked to Work Order, then use Work Order value
  2. If not linked to Work Order, then derive the Main Work Centre from the first 4 character of the mapped work Centre
  3. Otherwise, then default to technical object Work Centre.
4

PF2, WP2 

QMFE

OTGRP

Code Group - Object Parts

S/4 HANA

QMFE

OTGRP

Code Group - Object Parts

Value Mapping: Catalog Code Group and Code

5PF2, WP2QMFE

OTEIL

Part of Object

S/4 HANAQMFE

OTEIL

Part of Object

Value Mapping: Catalog Code Group and Code

6PF2, WP2QMFE

FEGRP

Damage – Code Group

S/4 HANAQMFE

FEGRP

Damage – Code Group

Value Mapping: Catalog Code Group and Code

7

PF2, WP2 

QMFE

FECOD

Problem or Damage Code

S/4 HANA

QMFE

FECOD

Problem or Damage Code

Direct Mapping

8PF2, WP2QMFE

FETXT

Notification Item Short Text

S/4 HANAQMFE

FETXT

Notification Item Short Text

Direct Mapping

9

PF2, WP2 

QMUR

URGRP

Code Group - Causes

S/4 HANA

QMUR

URGRP

Code Group - Causes

Value Mapping: Catalog Code Group and Code

10PF2, WP2QMUR

URCOD

Cause Code

S/4 HANAQMUR

URCOD

Cause Code

Value Mapping: Catalog Code Group and Code

11PF2, WP2QMUR

URTXT

Cause - Text

S/4 HANAQMUR

URTXT

Cause Text

Direct Mapping

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

Work Order

Old to new Work Order

Planner Group

Old to new Planner Group

Work Centre

Old to new Work Centre

Plant

Old to new Plant

Equipment

Old to new Equipment

Functional Location

Old to new Functional Location

Priority

Old to new Priority

Catalog Code Group and Code

Old to new Catalog Code Group and Code

Transformation Dependencies

List the steps that need to occur before transformation can commence

Item #Step DescriptionTeam Responsible
1

Ensure DCT tables completeness

SyWay Data Team

2

Ensure all Transformation mappings are up to date.

SyWay Data Team



Pre-Load Validation

Project Team

The following pre-load validations will be performed by the Project Team.

Completeness

TaskAction

Verify Record Count

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

Review and correct the errors.  Achieve a zero-error record count as much as possible. Raise defects for data remediated and requiring a correction in the source data.


Business

The following pre-load validations will be performed by the business.

Completeness

TaskAction

Verify Record Count

Business Data Owner/s 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

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

PostCutover

Configuration

List the Configurations required before loading can commence

Item #Configuration Item
1Notification Type
2Priority
3Maintenance Activity Type

Conversion Objects

Object #Preceding Object Conversion Approach

1002

Equipment

1003

Functional Location

1006

Work Centre

1010

Assembly

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

Invalid Data

Invalid data (Based on master data)

Check whether the master data is available in the system

Invalid Data

Invalid data (Based on non master data)

Review and analyses the errors. Take necessary action to correct the data if possible.

Configuration

Invalid Notification Type

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


Post-Load Validation

Project Team

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

SyWay A2D Data Team to verify that the Notification 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 Notification data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA.


Key Assumptions

  • Notification is in scope based on data design and any exception requested by business.
  • Data cleansing has met the required percentage threshold for the specified mock cycle and all preparation activities have 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