| Status | Approved |
|---|---|
| Owner | |
| Stakeholders | ERGUIZA-ext, Pinky Love PUN-ext, Eddy JOSHI-ext, Aditya VILARES, ines LEIGHTON-ext, Dean @STEFANESCU-ext, Aurelia MOUSSA-ext, Eva |
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:
- All Open Notifications (Source System Status: Outstanding, In Process (TJ02T-TXT04 = OSNO or NOPR)
- Assigned to active legacy Functional Location (IFLOT-TPLNR) (Source System Status Not any of these: Inactive, Delete (TJ02T-TXT04 = INAC or DLFL))
- 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))
- Notifications having Maintenance Plant (QMEL-ARBPLWERK) in scope - Refer to Value Mapping: Plant (Maintenance Plant = Yes)
- 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:
- Notification with Source System Status Notification completed status (TJ02T-TXT04 = NOCO)
- 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.
| Source | Scope | Source Approx No. of Records | Target System | Target 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
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| QMEL | QMNUM | QMNUM | Notification Number | CHAR | 12 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | QMART | QMART | Notification Type | CHAR | 2 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | QMTXT | QMTXT | Short Text | CHAR | 40 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | ARTPR | ARTPR | Priority Type | CHAR | 2 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | PRIOK | PRIOK | Priority | CHAR | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | ERNAM | ERNAM | Reported By | CHAR | 12 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | ERDAT | ERDAT | Date on Which Record Was Created | DATS | 8 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | AENAM | AENAM | Name of Person Who Changed Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMEL | AEDAT | AEDAT | Changed On | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMEL | MZEIT | MZEIT | Time of Notification | TIMS | 6 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | QMDAT | QMDAT | Date of Notification | DATS | 8 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | QMNAM | QMNAM | Name of Person Reporting Notification | CHAR | 12 | Mandatory | Conditional | Mandatory | Mandatory | Mandatory |
| QMEL | STRMN | STRMN | Required Start Date | DATS | 8 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | STRUR | STRUR | Required Start Time | TIMS | 6 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | LTRMN | LTRMN | Required End Date | DATS | 8 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | LTRUR | LTRUR | Requested End Time | TIMS | 6 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | AUFNR | AUFNR | Order Number | CHAR | 12 | Conditional | System | Conditional | Conditional | Not used |
| QMEL | MATNR | MATNR | Material Number | CHAR | 18 | Not used | Not used | Not used | Mandatory | Not used |
| QMEL | MATKL | MATKL | Material Group | CHAR | 9 | Not used | Not used | Not used | Mandatory | Not used |
| QMEL | OBJNR | QMOBJNR | Object Number for Status Management | CHAR | 22 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | RBNR | RBNR | Catalog Profile | CHAR | 9 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | RBNRI | RBNRI | Origin of Notifications Catalog Profile | CHAR | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | INDTX | INDLTX | Object Long Text Available | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMEL | KZMLA | KZMLA | Primary language indicator for text segment | CHAR | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | HERKZ | HERKZ | Origin of Notification | CHAR | 2 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | BEZDT | BEZDT | Notification Reference Date | DATS | 8 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | BEZUR | BEZUR_D | Notification Reference Time | TIMS | 6 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | AEZEIT | AEZEIT | Time of Change | TIMS | 6 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | ERZEIT | ERZEIT | Time, at Which Record Was Added | TIMS | 6 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMEL | QMKAT | QMKAT | Catalog Type - Coding | CHAR | 1 | Mandatory | System | Mandatory | Mandatory | Mandatory |
| QMEL | QMGRP | QMGRP | Code Group - Coding | CHAR | 8 | Mandatory | System | Mandatory | Mandatory | Mandatory |
| QMEL | QMCOD | QMCOD | Coding | CHAR | 4 | Mandatory | System | Mandatory | Mandatory | Mandatory |
| QMEL | CROBJTY | CR_OBJTY | Object types of the CIM resource | CHAR | 2 | Mandatory | Mandatory | Mandatory | Not used | Not used |
| QMEL | ARBPL | LGWID | Object ID of the Work Center | NUMC | 8 | Mandatory | Mandatory | Mandatory | Not used | Not used |
| QMEL | ARBPLWERK | QARBPWERKS | Plant for Work Center | CHAR | 4 | Mandatory | Mandatory | Mandatory | Not used | Not used |
| QMEL | MGEIN | MGEIN | Unit of Measure | UNIT | 3 | Not used | Not used | Not used | Mandatory | Not used |
| QMEL | SERIALNR | GERNR | Serial Number | CHAR | 18 | Not used | Not used | Not used | Conditional | Not used |
| QMEL | TZONSO | TZONSO | Time Zone for Notification | CHAR | 6 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| PSP_NR | PS_POSNR | WBS Element | NUMC | 8 | Not used | Not used | Mandatory | Not used | Not used | |
| QMEL | PHASE | QM_PHASE | Notification Processing Phase | CHAR | 1 | Mandatory | Mandatory | Mandatory | Not used | Not used |
| QMIH | IWERK | IWERK | Maintenance Planning Plant | CHAR | 4 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMIH | ILOAN | ILOAN | Location and account assignment for technical object | CHAR | 12 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| ILOAI | ILOAI | ILOA Individual | CHAR | 1 | Mandatory | Mandatory | Mandatory | Not used | Mandatory | |
| QMIH | EQUNR | EQUNR | Equipment number | CHAR | 18 | Conditional | Conditional | Conditional | Not used | Conditional |
| QMIH | BAUTL | BAUTL | Assembly | CHAR | 18 | Mandatory | Mandatory | Mandatory | Not used | Mandatory |
| ILOA | TPLNR | TPLNR | Functional Location | CHAR | 30 | Mandatory | ||||
| QMIH | MSAUS | MSAUS | Breakdown Indicator | CHAR | 1 | Conditional | Not used | Not used | Not used | Not used |
| QMIH | AUSVN | AUSVN | Start of Malfunction (Date) | DATS | 8 | Conditional | Not used | Conditional | Not used | Not used |
| QMIH | AUSBS | AUSBS | End of Malfunction (Date) | DATS | 8 | Conditional | Not used | Conditional | Not used | Not used |
| QMIH | AUZTV | AUZTV | Start of Malfunction (Time) | TIMS | 6 | Conditional | Not used | Conditional | Not used | Not used |
| QMIH | AUZTB | AUZTB | End of Malfunction (Time) | TIMS | 6 | Conditional | Not used | Conditional | Not used | Not used |
| QMIH | AUSZT | AUSZT | Breakdown Duration | FLTP | 16(16) | Conditional | Not used | Conditional | Not used | Not used |
| QMIH | MAUEH | MAUEH | Unit for Breakdown Duration | UNIT | 3 | Conditional | Not used | Conditional | Not used | Not used |
| QMIH | AUSWK | AUSWK | Effect on Operation | CHAR | 1 | Mandatory | Mandatory | Mandatory | Not used | Conditional |
| QMIH | INGRP | INGRP | Planner Group for Customer Service and Plant Maintenance | CHAR | 3 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMIH | WARPL | WARPL | Maintenance Plan | CHAR | 12 | Not used | Conditional | Not used | Not used | Not used |
| QMIH | ABNUM | ABNUM | Maintenance Plan Call Number | INT4 | 10 | Not used | Conditional | Not used | Not used | Not used |
| QMIH | WAPOS | WAPOS | Maintenance item | CHAR | 16 | Not used | Conditional | Not used | Not used | Not used |
| QMIH | SCREENTY | SCRTP | Scenario or Subscreen Category | CHAR | 4 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMIH | PLNTY | PLNTY | Task List Type | CHAR | 1 | Not used | Conditional | Not used | Not used | Not used |
| QMIH | PLNNR | PLNNR | Key for Task List Group | CHAR | 8 | Not used | Conditional | Not used | Not used | Not used |
| QMIH | PLNAL | PLNAL | Group Counter | CHAR | 2 | Not used | Conditional | Not used | Not used | Not used |
2.Notification Header Long Text Header
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| STXH | TDOBJECT | TDOBJECT | Texts: application object | CHAR | 10 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXH | TDNAME | TDOBNAME | Name | CHAR | 70 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXH | TDID | TDID | Text ID | CHAR | 4 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXH | TDSPRAS | SPRAS | Language Key | LANG | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
3.Notification Header Long Text Line
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| STXL | TDOBJECT | TDOBJECT | Texts: application object | CHAR | 10 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | TDNAME | TDOBNAME | Name | CHAR | 70 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | TDID | TDID | Text ID | CHAR | 4 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | TDSPRAS | SPRAS | Language Key | LANG | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | CLUSTD_TAG | TDFORMAT | Tag column | CHAR | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | ROWCOUNT | ROWCOUNT | Row number | NUMC | 10 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | TXLINE | TDLINE | Text Line | CHAR | 72 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
4.Notification Item
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| QMFE | QMNUM | QMNUM | Notification Number | CHAR | 12 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMFE | FENUM | FELFD | Item Number in Item Record | NUMC | 4 | Mandatory | Conditional | Conditional | Conditional | Conditional |
| QMFE | ERNAM | ERNAM | Name of Person who Created the Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | ERDAT | ERDAT | Date on Which Record Was Created | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | AENAM | AENAM | Name of Person Who Changed Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | AEDAT | AEDAT | Changed On | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | FETXT | FETXT | Notification Item Short Text | CHAR | 40 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | FEKAT | FEKAT | Catalog Type - Problems/Defects | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | FEGRP | FEGRP | Code Group - Problem | CHAR | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | FECOD | FECOD | Problem or Damage Code | CHAR | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | FEVER | QVERSNR | Version Number | CHAR | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | OTKAT | OTKAT | Catalog Type - Object Parts | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | OTGRP | OTGRP | Code Group - Object Parts | CHAR | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | OTEIL | OTEIL | Part of Object | CHAR | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | OTVER | QVERSNR | Version Number | CHAR | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | BAUTL | BAUTL | Assembly | CHAR | 18 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | INDTX | INDLTX | Object Long Text Available | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | KZMLA | KZMLA | Primary language indicator for text segment | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | ERZEIT | ERZEIT | Time, at Which Record Was Added | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | AEZEIT | AEZEIT | Time of Change | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | ANZFEHLER | QANZFEHL4 | Number of Defects Found | INT4 | 10 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMFE | AUTKZ | QAUTKZ | Data Record Created with Function 'Create with Copy Model' | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
Note: Each Notification Header can have many Notification Items
5.Notification Item Long Text Header
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| STXH | TDOBJECT | TDOBJECT | Texts: application object | CHAR | 10 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXH | TDNAME | TDOBNAME | Name | CHAR | 70 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXH | TDID | TDID | Text ID | CHAR | 4 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXH | TDSPRAS | SPRAS | Language Key | LANG | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
6.Notification Item Long Text Line
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| STXL | TDOBJECT | TDOBJECT | Texts: application object | CHAR | 10 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | TDNAME | TDOBNAME | Name | CHAR | 70 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | TDID | TDID | Text ID | CHAR | 4 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | TDSPRAS | SPRAS | Language Key | LANG | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | CLUSTD_TAG | TDFORMAT | Tag column | CHAR | 1 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | ROWCOUNT | ROWCOUNT | Row number | NUMC | 10 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| STXL | TXLINE | TDLINE | Text Line | CHAR | 72 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
7. Notification - Causes
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| QMEL | QMNUM | QMNUM | Notification Number | CHAR | 12 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMUR | FENUM | FELFD | Item Number in Item Record | NUMC | 4 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMUR | URNUM | URNUM | Sequential Number for Cause | NUMC | 4 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMUR | ERNAM | ERNAM | Name of Person who Created the Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | ERDAT | ERDAT | Date on Which Record Was Created | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | AENAM | AENAM | Name of Person Who Changed Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | AEDAT | AEDAT | Changed On | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | URTXT | URSTX | Cause Text | CHAR | 40 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | URKAT | URKAT | Catalog Type - Causes | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | URGRP | URGRP | Code Group - Causes | CHAR | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | URCOD | URCOD | Cause Code | CHAR | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | URVER | QVERSNR | Version Number | CHAR | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| INDTX | INDLTX | Object Long Text Available | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional | |
| QMUR | KZMLA | KZMLA | Primary language indicator for text segment | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | ERZEIT | ERZEIT | Time, at Which Record Was Added | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | AEZEIT | AEZEIT | Time of Change | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | QURNUM | QURNUM | Sort Number for Cause | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMUR | AUTKZ | QAUTKZ | Data Record Created with Function 'Create with Copy Model' | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
8. Notification - Task
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| QMEL | QMNUM | QMNUM | Notification Number | CHAR | 12 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMSM | MANUM | MANUM | Sequential Task Number | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | MNKAT | MAKAT | Catalog Type - Tasks | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | MNGRP | MAGRP | Code Group - Tasks | CHAR | 8 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | MNCOD | MNCOD | Task Code | CHAR | 4 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | MNVER | QVERSNR | Version Number | CHAR | 6 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | FOLGEACT | QMFOLACT | Follow-Up Action for Task | CHAR | 8 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | FOLACTPROT | QMFOAPROT | Log for Follow-Up Action | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | MATXT | MATXT | Short Text for Task | CHAR | 40 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | ERNAM | ERNAM | Name of Person who Created the Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | ERDAT | ERDAT | Date on Which Record Was Created | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | AENAM | AENAM | Name of Person Who Changed Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | AEDAT | AEDAT | Changed On | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | PSTER | PSTER | Planned Start Date | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | PETER | PETER | Planned finish date | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | OBJNR | QMOBJNR | Object Number for Status Management | CHAR | 22 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | INDTX | INDLTX | Object Long Text Available | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | KZMLA | KZMLA | Primary language indicator for text segment | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | PSTUR | PSTUR | Planned Start Time for Task | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | PETUR | PETUR | Planned Finish Time for Task | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | ERLNAM | QMSMERLNAM | Person Who Completed the Task | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | ERLDAT | QMSMERLDAT | Date on Which the Task Was Completed | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | ERLZEIT | QMSMERLTIM | Time at Which Task Was Completed | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | WDVDAT | QMSMWDVDAT | Date on Which Task Was Resubmitted | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | FENUM | FELFD | Item Number in Item Record | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | URNUM | URNUM | Sequential Number for Cause | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | ERZEIT | ERZEIT | Time, at Which Record Was Added | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | AEZEIT | AEZEIT | Time of Change | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | PARVW | QMSM_PARVW | Function of Person Responsible for Task | CHAR | 2 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | PARNR | QMSM_PARNR | Person Responsible for Task (Partner Number) | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | QSMNUM | QSMNUM | Sort Number for Task | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | AUTKZ | QAUTKZ | Data Record Created with Function 'Create with Copy Model' | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Not used |
| QMSM | KZACTIONBOX | QNKZACTIONBOX | Created Using Action Box | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| FUNKTION | QNFUNKTION | Keys for Function in Action Box | CHAR | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
9. Notification - Activity
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement (Notif. Type Y1) | Requirement (Notif. Type Y2) | Requirement (Notif. Type Y3) | Requirement (Notif. Type Y4) | Requirement (Notif. Type Y5) |
|---|---|---|---|---|---|---|---|---|---|---|
| QMEL | QMNUM | QMNUM | Notification Number | CHAR | 12 | Mandatory | Mandatory | Mandatory | Mandatory | Mandatory |
| QMMA | MANUM | AKNUM | Consecutive Number of Activity | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | FENUM | FELFD | Item Number in Item Record | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | URNUM | URNUM | Sequential Number for Cause | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | MNKAT | MFKAT | Catalog Type - Activities | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | MNGRP | MFGRP | Code Group - Activities | CHAR | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | MNCOD | MFCOD | Activity Code | CHAR | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | MNVER | QVERSNR | Version Number | CHAR | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | MATXT | MFTEXT | Activity Text | CHAR | 40 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | ERNAM | ERNAM | Name of Person who Created the Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | ERDAT | ERDAT | Date on Which Record Was Created | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | AENAM | AENAM | Name of Person Who Changed Object | CHAR | 12 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | AEDAT | AEDAT | Changed On | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | MAKLS | MAKLS | Task Class | CHAR | 18 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | KLAKZ | KLAKZ | Indicator: Classification exists | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | PSTER | PSTERMA | Start Date | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | PETER | PETERMA | End Date | DATS | 8 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | INDTX | INDLTX | Object Long Text Available | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | KZMLA | KZMLA | Primary language indicator for text segment | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | PSTUR | PSTURMA | Start Time of Activity | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | PETUR | PETURMA | End Time of Activity | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | ERZEIT | ERZEIT | Time, at Which Record Was Added | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | AEZEIT | AEZEIT | Time of Change | TIMS | 6 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | QMANUM | QMANUM | Sort Number for Activity | NUMC | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | AUTKZ | QAUTKZ | Data Record Created with Function 'Create with Copy Model' | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | KZACTIONBOX | QNKZACTIONBOX | Created Using Action Box | CHAR | 1 | Conditional | Conditional | Conditional | Conditional | Conditional |
| QMMA | FUNKTION | QNFUNKTION | Keys for Function in Action Box | CHAR | 4 | Conditional | Conditional | Conditional | Conditional | Conditional |
Data Cleansing
| ID | Criticality | Error Message/Report Description | Rule | Output | Source 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:
| 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:
| 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: | 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: | 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: | 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: | 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 incorrect | Notification 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 . There are 2 possibilities:
- The data exists. connects to the source and loads the data into . There are 3 methods:
- Perform full data extraction from relevant tables in the source system(s).
- Perform extraction through the application layer.
- Only if cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
- The data does not exist (or cannot be converted from its current state). The data is manually collected by the business directly in . This is to be conducted using DCT (Data Collection Template) in
The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target loads
Extraction Run Sheet
| Req # | Requirement Description | Team Responsible |
|---|---|---|
| 1 | Extract data from source system based on relevancy rule | SyWay Data Team |
Selection Screen
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| Not Applicable |
Data Collection Template (DCT)
No DCT will be used for Notification.
Notification DCT Rules
| Field Name | Field Description | Rule |
|---|---|---|
Not applicable |
Extraction Dependencies
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Relevancy Criteria for Catalog Profile | SyWay A2D Data Team |
| 2 | Relevancy Criteria for Catalog Code Groups & Codes | SyWay A2D Data Team |
| 3 | Relevancy Criteria for Characteristics | SyWay A2D Data Team |
| 4 | Relevancy Criteria for Class | SyWay A2D Data Team |
| 5 | Relevancy Criteria for Construction Type | SyWay A2D Data Team |
| 6 | Relevancy Criteria for Equipment | SyWay A2D Data Team |
| 7 | Relevancy Criteria for Functional Location | SyWay A2D Data Team |
| 8 | Relevancy Criteria for Maintenance Plan and Item | SyWay A2D Data Team |
| 9 | Relevancy Criteria for Revision | SyWay A2D Data Team |
| 10 | Relevancy Criteria for Task List | SyWay A2D Data Team |
| 11 | Relevancy 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:
- Perform value mapping and data transformation rules.
- Legacy values are mapped to the to-be values (this could include a default value)
- Values are transformed according to the rules defined in Advanced Data Migration and Management (ADMM)
- 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 Description | Team 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 Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation 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 |
| 3 | PF2, WP2 | QMEL | QMART | Notification Type | S/4 HANA | QMEL | QMART | Notification Type | Value Mapping: Notification Type |
| 4 | PF2, WP2 | QMEL | QMTXT | Short Text | S/4 HANA | QMEL | QMTXT | Short Text | Direct Mapping. Only if notification does not exist for PM01 Work Order, default to: Work Order Description |
| 5 | PF2, WP2 | QMEL | EQUNR | Equipment Number | S/4 HANA | QMEL | EQUNR | Equipment 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. |
| 6 | PF2, WP2 | QMEL | TPLNR | Functional Location | S/4 HANA | IFLO | TPLNR | Functional 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. |
| 7 | PF2, WP2 | QMIH | INGRP | Planner Group | S/4 HANA | VIQML | INGRP | Planner Group | Value Mapping: Planner Group If blank or cannot be mapped, and if linked to Work Order, then use Work Order value. |
| 8 | PF2, WP2 | CRHD | ARBPL | Work Centre | S/4 HANA | CRHD | ARBPL | Work Centre | Value Mapping: Work Centre |
| 9 | PF2, WP2 | CRHD | WERKS | Work Centre plant | S/4 HANA | CRHD | WERKS | Work Centre plant | Value Mapping: Plant (Maintenance Plant = Yes) |
| 10 | PF2, WP2 | QMEL | QMDAT | Notification Date | S/4 HANA | QMEL | QMDAT | Notification Date | Direct Mapping. If notification does not exist for PM01 Work Order, default to: Work Order Basic Start Date |
| 11 | PF2, WP2 | QMEL | MZEIT | Notification Time | S/4 HANA | QMEL | MZEIT | Notification Time | Direct Mapping. Only if notification does not exist for PM01 Work Order, default to: 00:00:00 |
| 12 | PF2, WP2 | QMEL | ERNAM | Reported By | S/4 HANA | QMEL | ERNAM | Reported By | Direct Mapping. Only if notification does not exist for PM01 Work Order, default to: Migration User ID (Name) |
| 13 | PF2, WP2 | QMEL | STRMN | Required Start Date | S/4 HANA | QMEL | STRMN | Required Start Date | If 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. |
| 14 | PF2, WP2 | QMEL | LTRMN | Required End Date | S/4 HANA | QMEL | LTRMN | Required End Date | If 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 |
| 15 | PF2, WP2 | QMEL | PRIOK | Priority | S/4 HANA | QMEL | PRIOK | Priority | Value Mapping: Priority Only if notification does not exist for PM01 Work Order, default to: Low |
| 16 | PF2, WP2 | QMEL | QMGRP | Code Group | S/4 HANA | QMEL | QMGRP | Code Group | Direct Mapping. |
| 17 | PF2, WP2 | QMEL | QMCOD | Coding | S/4 HANA | QMEL | QMCOD | Coding | Direct Mapping. |
| 18 | PF2, WP2 | QMEL | RBNR | Catalog Profile | S/4 HANA | QMEL | RBNR | Catalog Profile | Derive from Functional Location |
| 19 | - | - | - | - | Issue Permit | If Notification is assigned to Work Order then default to “X”. | |||
| 20 | PF2, WP2 | QMIH | ILART | Maintenance Activity Type | S/4 HANA | QMIH | ILART | Maintenance Activity Type | Derive from AFIH-ILART |
| 21 | PF2, WP2 | QMIH | MSAUS | Breakdown Indicator | S/4 HANA | QMIH | MSAUS | Breakdown Indicator | Direct Mapping. |
| 22 | PF2, WP2 | QMIH | AUSVN | Malfunct. Start Date | S/4 HANA | QMIH | AUSVN | Malfunct. Start Date | Direct Mapping. |
| 23 | PF2, WP2 | QMIH | AUZTV | Malfunct. Start Time | S/4 HANA | QMIH | AUZTV | Malfunct. Start Time | Direct Mapping. |
| 24 | PF2, WP2 | QMIH | AUSBS | Malfunct. End Date | S/4 HANA | QMIH | AUSBS | Malfunct. End Date | Direct Mapping. |
| 25 | PF2, WP2 | QMIH | AUZTB | Malfunct. End Time | S/4 HANA | QMIH | AUZTB | Malfunct. End Time | Direct Mapping. |
| 26 | PF2, WP2 | QMIH | AUSZT | Breakdown Duration | S/4 HANA | QMIH | AUSZT | Breakdown Duration | Direct Mapping. |
| 27 | PF2, WP2 | QMIH | MAUEH | Breakdown Unit | S/4 HANA | QMIH | MAUEH | Breakdown Unit | Direct Mapping. |
2.Notification Header Long Text Header Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4HANA | STXH | TDOBJECT | Texts: application object | Default to "QMEL" |
| 2 | PF2, WP2 | QMEL | QMNUM | Notification Number | S/4HANA | STXH | TDNAME | Name | Value Mapping: Notification |
| 3 | - | - | - | S/4HANA | STXH | TDID | Text ID | Default to 'LTXT' | |
| 4 | PF2, WP2 | STXH | SPRAS | Language Key | S/4HANA | STXH | SPRAS | Language Key | Direct Mapping |
3.Notification Header Long Text Line Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4HANA | STXL | TDOBJECT | Texts: application object | Default to "QMEL" |
| 2 | PF2, WP2 | QMEL | QMNUM | Notification Number | S/4HANA | STXL | TDNAME | Name | Value Mapping: Notification |
| 3 | - | - | - | - | S/4HANA | STXL | TDID | Text ID | Default to 'LTXT' |
| 4 | PF2, WP2 | STXL | SPRAS | Language Key | S/4HANA | STXL | SPRAS | Language Key | Direct Mapping |
| 5 | - | - | - | - | S/4HANA | STXL | CLUSTD_TAG | Tag column | Default to "*" |
| 6 | PF2, WP2 | STXL | ROWCOUNT | Row number | S/4HANA | STXL | ROWCOUNT | Row number | Direct Mapping |
| 7 | PF2, WP2 | STXL | TXLINE | Text Line | S/4HANA | STXL | TXLINE | Text Line | Direct Mapping |
4.Notification Item Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PF2, WP2 | QMFE | QMNUM | Notification Number | S/4 HANA | QMEL | QMNUM | Notification Number | System (Internal numbering). |
| 2 | PF2, WP2 | QMFE | IWERK | Maintenance Planning Plant | S/4 HANA | VIQML | WERK | Maintenance Planning Plant | Default to Planning Plant from reference technical object. |
| 3 | PF2, WP2 | QMFE | ARBPL | Object ID for Work Centre | S/4 HANA | QMFE | ARBPL | Object ID for Work Centre | Value Mapping: Work Centre If blank or cannot be mapped:
|
| 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 |
| 5 | PF2, WP2 | QMFE | OTEIL | Part of Object | S/4 HANA | QMFE | OTEIL | Part of Object | Value Mapping: Catalog Code Group and Code |
| 6 | PF2, WP2 | QMFE | FEGRP | Damage – Code Group | S/4 HANA | QMFE | 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 |
| 8 | PF2, WP2 | QMFE | FETXT | Notification Item Short Text | S/4 HANA | QMFE | FETXT | Notification Item Short Text | Direct Mapping |
Note: Each Notification Header can have many Notification Items
5.Notification Item Long Text Header Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4HANA | STXH | TDOBJECT | Texts: application object | Default to "QMFE" |
| 2 | PF2, WP2 | QMEL | QMNUM | Notification Number | S/4HANA | STXH | TDNAME | Name | Value Mapping: Notification |
| 3 | - | - | - | - | S/4HANA | STXH | TDID | Text ID | Default to 'LTXT' |
| 4 | PF2, WP2 | STXH | SPRAS | Language Key | S/4HANA | STXH | SPRAS | Language Key | Direct Mapping |
| 5 | - | - | - | - | S/4HANA | STXH | CLUSTD_TAG | Tag column | Default to "*" |
| 6 | PF2, WP2 | STXH | ROWCOUNT | Row number | S/4HANA | STXH | ROWCOUNT | Row number | Direct Mapping |
| 7 | PF2, WP2 | STXH | TXLINE | Text Line | S/4HANA | STXH | TXLINE | Text Line | Direct Mapping |
6.Notification Item Long Text Line Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - | - | S/4HANA | STXL | TDOBJECT | Texts: application object | Default to "QMFE" |
| 2 | PF2, WP2 | QMEL | QMNUM | Notification Number | S/4HANA | STXL | TDNAME | Name | Value Mapping: Notification |
| 3 | - | - | - | - | S/4HANA | STXL | TDID | Text ID | Default to 'LTXT' |
| 4 | PF2, WP2 | STXL | SPRAS | Language Key | S/4HANA | STXL | SPRAS | Language Key | Direct Mapping |
| 5 | - | - | - | - | S/4HANA | STXL | CLUSTD_TAG | Tag column | Default to "*" |
| 6 | PF2, WP2 | STXL | ROWCOUNT | Row number | S/4HANA | STXL | ROWCOUNT | Row number | Direct Mapping |
| 7 | PF2, WP2 | STXL | TXLINE | Text Line | S/4HANA | STXL | TXLINE | Text Line | Direct Mapping |
7. Notification - Causes Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PF2, WP2 | QMUR | QMNUM | Notification Number | S/4 HANA | QMUR | QMNUM | Notification Number | System (Internal numbering) |
| 2 | PF2, WP2 | QMUR | QMNUM | Notification Number | S/4HANA | QMUR | QMNUM | Notification Number | System (Internal numbering) |
| 3 | PF2, WP2 | QMUR | FENUM | Item Number in Item Record | S/4HANA | QMUR | FENUM | Item Number in Item Record | System (Internal numbering) |
| 4 | PF2, WP2 | QMUR | URNUM | Sequential Number for Cause | S/4HANA | QMUR | URNUM | Sequential Number for Cause | System (Internal numbering) |
| 5 | PF2, WP2 | QMUR | ERNAM | Name of Person who Created the Object | S/4HANA | QMUR | ERNAM | Name of Person who Created the Object | Direct Mapping |
| 6 | PF2, WP2 | QMUR | ERDAT | Date on Which Record Was Created | S/4HANA | QMUR | ERDAT | Date on Which Record Was Created | Direct Mapping |
| 7 | PF2, WP2 | QMUR | AENAM | Name of Person Who Changed Object | S/4HANA | QMUR | AENAM | Name of Person Who Changed Object | Direct Mapping |
| 8 | PF2, WP2 | QMUR | AEDAT | Changed On | S/4HANA | QMUR | AEDAT | Changed On | Direct Mapping |
| 9 | PF2, WP2 | QMUR | URTXT | Cause Text | S/4HANA | QMUR | URTXT | Cause Text | Direct Mapping |
| 10 | PF2, WP2 | QMUR | URKAT | Catalog Type - Causes | S/4HANA | QMUR | URKAT | Catalog Type - Causes | Value Mapping: Catalog Code Group and Code |
| 11 | PF2, WP2 | QMUR | URGRP | Code Group - Causes | S/4HANA | QMUR | URGRP | Code Group - Causes | Value Mapping: Catalog Code Group and Code |
| 12 | PF2, WP2 | QMUR | URCOD | Cause Code | S/4HANA | QMUR | URCOD | Cause Code | Value Mapping: Catalog Code Group and Code |
| 13 | PF2, WP2 | QMUR | URVER | Version Number | S/4HANA | QMUR | URVER | Version Number | Direct Mapping |
| 14 | PF2, WP2 | QMUR | INDTX | Object Long Text Available | S/4HANA | QMUR | INDTX | Object Long Text Available | Direct Mapping |
| 15 | PF2, WP2 | QMUR | KZMLA | Primary language indicator for text segment | S/4HANA | QMUR | KZMLA | Primary language indicator for text segment | Direct Mapping |
| 16 | PF2, WP2 | QMUR | ERZEIT | Time, at Which Record Was Added | S/4HANA | QMUR | ERZEIT | Time, at Which Record Was Added | Direct Mapping |
| 17 | PF2, WP2 | QMUR | AEZEIT | Time of Change | S/4HANA | QMUR | AEZEIT | Time of Change | Direct Mapping |
| 18 | PF2, WP2 | QMUR | QURNUM | Sort Number for Cause | S/4HANA | QMUR | QURNUM | Sort Number for Cause | Direct Mapping |
| 19 | PF2, WP2 | QMUR | AUTKZ | Data Record Created with Function 'Create with Copy Model' | S/4HANA | QMUR | AUTKZ | Data Record Created with Function 'Create with Copy Model' | Direct Mapping |
8. Notification - Task Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PF2, WP2 | QMSM | QMNUM | Notification Number | S/4HANA | QMSM | QMNUM | Notification Number | System (Internal numbering) |
| 2 | PF2, WP2 | QMSM | MANUM | Sequential Task Number | S/4HANA | QMSM | MANUM | Sequential Task Number | System (Internal numbering) |
| 3 | PF2, WP2 | QMSM | MNKAT | Catalog Type - Tasks | S/4HANA | QMSM | MNKAT | Catalog Type - Tasks | Direct Mapping |
| 4 | PF2, WP2 | QMSM | MNGRP | Code Group - Tasks | S/4HANA | QMSM | MNGRP | Code Group - Tasks | Direct Mapping |
| 5 | PF2, WP2 | QMSM | MNCOD | Task Code | S/4HANA | QMSM | MNCOD | Task Code | Direct Mapping |
| 6 | PF2, WP2 | QMSM | MNVER | Version Number | S/4HANA | QMSM | MNVER | Version Number | Direct Mapping |
| 7 | PF2, WP2 | QMSM | FOLGEACT | Follow-Up Action for Task | S/4HANA | QMSM | FOLGEACT | Follow-Up Action for Task | Direct Mapping |
| 8 | PF2, WP2 | QMSM | FOLACTPROT | Log for Follow-Up Action | S/4HANA | QMSM | FOLACTPROT | Log for Follow-Up Action | Direct Mapping |
| 9 | PF2, WP2 | QMSM | MATXT | Short Text for Task | S/4HANA | QMSM | MATXT | Short Text for Task | Direct Mapping |
| 10 | PF2, WP2 | QMSM | ERNAM | Name of Person who Created the Object | S/4HANA | QMSM | ERNAM | Name of Person who Created the Object | Direct Mapping |
| 11 | PF2, WP2 | QMSM | ERDAT | Date on Which Record Was Created | S/4HANA | QMSM | ERDAT | Date on Which Record Was Created | Direct Mapping |
| 12 | PF2, WP2 | QMSM | AENAM | Name of Person Who Changed Object | S/4HANA | QMSM | AENAM | Name of Person Who Changed Object | Direct Mapping |
| 13 | PF2, WP2 | QMSM | AEDAT | Changed On | S/4HANA | QMSM | AEDAT | Changed On | Direct Mapping |
| 14 | PF2, WP2 | QMSM | PSTER | Planned Start Date | S/4HANA | QMSM | PSTER | Planned Start Date | Direct Mapping |
| 15 | PF2, WP2 | QMSM | PETER | Planned finish date | S/4HANA | QMSM | PETER | Planned finish date | Direct Mapping |
| 16 | PF2, WP2 | QMSM | OBJNR | Object Number for Status Management | S/4HANA | QMSM | OBJNR | Object Number for Status Management | Direct Mapping |
| 17 | PF2, WP2 | QMSM | INDTX | Object Long Text Available | S/4HANA | QMSM | INDTX | Object Long Text Available | Direct Mapping |
| 18 | PF2, WP2 | QMSM | KZMLA | Primary language indicator for text segment | S/4HANA | QMSM | KZMLA | Primary language indicator for text segment | Direct Mapping |
| 19 | PF2, WP2 | QMSM | PSTUR | Planned Start Time for Task | S/4HANA | QMSM | PSTUR | Planned Start Time for Task | Direct Mapping |
| 20 | PF2, WP2 | QMSM | PETUR | Planned Finish Time for Task | S/4HANA | QMSM | PETUR | Planned Finish Time for Task | Direct Mapping |
| 21 | PF2, WP2 | QMSM | ERLNAM | Person Who Completed the Task | S/4HANA | QMSM | ERLNAM | Person Who Completed the Task | Direct Mapping |
| 22 | PF2, WP2 | QMSM | ERLDAT | Date on Which the Task Was Completed | S/4HANA | QMSM | ERLDAT | Date on Which the Task Was Completed | Direct Mapping |
| 23 | PF2, WP2 | QMSM | ERLZEIT | Time at Which Task Was Completed | S/4HANA | QMSM | ERLZEIT | Time at Which Task Was Completed | Direct Mapping |
| 24 | PF2, WP2 | QMSM | WDVDAT | Date on Which Task Was Resubmitted | S/4HANA | QMSM | WDVDAT | Date on Which Task Was Resubmitted | Direct Mapping |
| 25 | PF2, WP2 | QMSM | FENUM | Item Number in Item Record | S/4HANA | QMSM | FENUM | Item Number in Item Record | Direct Mapping |
| 26 | PF2, WP2 | QMSM | URNUM | Sequential Number for Cause | S/4HANA | QMSM | URNUM | Sequential Number for Cause | Direct Mapping |
| 27 | PF2, WP2 | QMSM | ERZEIT | Time, at Which Record Was Added | S/4HANA | QMSM | ERZEIT | Time, at Which Record Was Added | Direct Mapping |
| 28 | PF2, WP2 | QMSM | AEZEIT | Time of Change | S/4HANA | QMSM | AEZEIT | Time of Change | Direct Mapping |
| 29 | PF2, WP2 | QMSM | PARVW | Function of Person Responsible for Task | S/4HANA | QMSM | PARVW | Function of Person Responsible for Task | Direct Mapping |
| 30 | PF2, WP2 | QMSM | PARNR | Person Responsible for Task (Partner Number) | S/4HANA | QMSM | PARNR | Person Responsible for Task (Partner Number) | Direct Mapping |
| 31 | PF2, WP2 | QMSM | QSMNUM | Sort Number for Task | S/4HANA | QMSM | QSMNUM | Sort Number for Task | Direct Mapping |
| 32 | PF2, WP2 | QMSM | AUTKZ | Data Record Created with Function 'Create with Copy Model' | S/4HANA | QMSM | AUTKZ | Data Record Created with Function 'Create with Copy Model' | Direct Mapping |
| 33 | PF2, WP2 | QMSM | KZACTIONBOX | Created Using Action Box | S/4HANA | QMSM | KZACTIONBOX | Created Using Action Box | Direct Mapping |
| 34 | PF2, WP2 | QMSM | FUNKTION | Keys for Function in Action Box | S/4HANA | QMSM | FUNKTION | Keys for Function in Action Box | Direct Mapping |
9. Notification - Activity Transformation Rule
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | PF2, WP2 | QMMA | QMNUM | Notification Number | S/4HANA | QMMA | QMNUM | Notification Number | System (Internal numbering) |
| 2 | PF2, WP2 | QMMA | MANUM | Consecutive Number of Activity | S/4HANA | QMMA | MANUM | Consecutive Number of Activity | System (Internal numbering) |
| 3 | PF2, WP2 | QMMA | FENUM | Item Number in Item Record | S/4HANA | QMMA | FENUM | Item Number in Item Record | Direct Mapping |
| 4 | PF2, WP2 | QMMA | URNUM | Sequential Number for Cause | S/4HANA | QMMA | URNUM | Sequential Number for Cause | Direct Mapping |
| 5 | PF2, WP2 | QMMA | MNKAT | Catalog Type - Activities | S/4HANA | QMMA | MNKAT | Catalog Type - Activities | Direct Mapping |
| 6 | PF2, WP2 | QMMA | MNGRP | Code Group - Activities | S/4HANA | QMMA | MNGRP | Code Group - Activities | Direct Mapping |
| 7 | PF2, WP2 | QMMA | MNCOD | Activity Code | S/4HANA | QMMA | MNCOD | Activity Code | Direct Mapping |
| 8 | PF2, WP2 | QMMA | MNVER | Version Number | S/4HANA | QMMA | MNVER | Version Number | Direct Mapping |
| 9 | PF2, WP2 | QMMA | MATXT | Activity Text | S/4HANA | QMMA | MATXT | Activity Text | Direct Mapping |
| 10 | PF2, WP2 | QMMA | ERNAM | Name of Person who Created the Object | S/4HANA | QMMA | ERNAM | Name of Person who Created the Object | Direct Mapping |
| 11 | PF2, WP2 | QMMA | ERDAT | Date on Which Record Was Created | S/4HANA | QMMA | ERDAT | Date on Which Record Was Created | Direct Mapping |
| 12 | PF2, WP2 | QMMA | AENAM | Name of Person Who Changed Object | S/4HANA | QMMA | AENAM | Name of Person Who Changed Object | Direct Mapping |
| 13 | PF2, WP2 | QMMA | AEDAT | Changed On | S/4HANA | QMMA | AEDAT | Changed On | Direct Mapping |
| 14 | PF2, WP2 | QMMA | MAKLS | Task Class | S/4HANA | QMMA | MAKLS | Task Class | Direct Mapping |
| 15 | PF2, WP2 | QMMA | KLAKZ | Indicator: Classification exists | S/4HANA | QMMA | KLAKZ | Indicator: Classification exists | Direct Mapping |
| 16 | PF2, WP2 | QMMA | PSTER | Start Date | S/4HANA | QMMA | PSTER | Start Date | Direct Mapping |
| 17 | PF2, WP2 | QMMA | PETER | End Date | S/4HANA | QMMA | PETER | End Date | Direct Mapping |
| 18 | PF2, WP2 | QMMA | INDTX | Object Long Text Available | S/4HANA | QMMA | INDTX | Object Long Text Available | Direct Mapping |
| 19 | PF2, WP2 | QMMA | KZMLA | Primary language indicator for text segment | S/4HANA | QMMA | KZMLA | Primary language indicator for text segment | Direct Mapping |
| 20 | PF2, WP2 | QMMA | PSTUR | Start Time of Activity | S/4HANA | QMMA | PSTUR | Start Time of Activity | Direct Mapping |
| 21 | PF2, WP2 | QMMA | PETUR | End Time of Activity | S/4HANA | QMMA | PETUR | End Time of Activity | Direct Mapping |
| 22 | PF2, WP2 | QMMA | ERZEIT | Time, at Which Record Was Added | S/4HANA | QMMA | ERZEIT | Time, at Which Record Was Added | Direct Mapping |
| 23 | PF2, WP2 | QMMA | AEZEIT | Time of Change | S/4HANA | QMMA | AEZEIT | Time of Change | Direct Mapping |
| 24 | PF2, WP2 | QMMA | QMANUM | Sort Number for Activity | S/4HANA | QMMA | QMANUM | Sort Number for Activity | Direct Mapping |
| 25 | PF2, WP2 | QMMA | AUTKZ | Data Record Created with Function 'Create with Copy Model' | S/4HANA | QMMA | AUTKZ | Data Record Created with Function 'Create with Copy Model' | Direct Mapping |
| 26 | PF2, WP2 | QMMA | KZACTIONBOX | Created Using Action Box | S/4HANA | QMMA | KZACTIONBOX | Created Using Action Box | Direct Mapping |
| 27 | PF2, WP2 | QMMA | FUNKTION | Keys for Function in Action Box | S/4HANA | QMMA | FUNKTION | Keys for Function in Action Box | Direct Mapping |
List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.
Transformation Mapping
| Mapping Table Name | Mapping 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 |
Notification Type | Old to new Notification Type |
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 Description | Team 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
Completeness
| Task | Action |
|---|---|
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
| Task | Action |
|---|---|
Conversion Accuracy | SyWay A2D Data Team to verify that all fields below meet pass the 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
Completeness
| Task | Action |
|---|---|
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
| Task | Action |
|---|---|
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:
- Execute the automated data load into target system using load tool or product the load file if the load must be done manually
- 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 Description | Team 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
| Item # | Configuration Item |
|---|---|
| 1 | Notification Type |
| 2 | Priority |
| 3 | Maintenance Activity Type |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
1002 | Equipment |
1003 | Functional Location |
1006 | Work Centre |
1010 | Assembly |
Error Handling
| Error Type | Error Description | Action 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
Completeness
| Task | Action |
|---|---|
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
| Task | Action |
|---|---|
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
Completeness
| Task | Action |
|---|---|
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
| Task | Action |
|---|---|
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.
See also
Change log
Workflow history
| Title | Last Updated By | Updated | Status | |
|---|---|---|---|---|
| There are no pages at the moment. | ||||
