| Status |
| |
|---|---|---|
| Owner | ||
| Stakeholders |
Purpose
The purpose of this document is to define the conversion approach to create Maintenance Planning Bucket in S/4 HANA.
A Maintenance Planning Bucket is a logical container or grouping tool used by maintenance planners to organize and manage maintenance orders and notifications for a specific time period and scope. The scope of a planning bucket includes time, but also other important attributes of the maintenance jobs.
Conversion Scope
The scope of this document covers the approach for converting active Revision from Legacy Source Systems into Maintenance Planning Bucket in S/4HANA.
In Syensqo, Maintenance Planning Buckets
arewill primarily be used to release maintenance orders, enabling material staging, permit processing, and job scheduling, while preventing further structural changes to
theplanning data.
Some of the key information required to support Maintenance Planning Buckets is not consistently maintained in the source systems.
There are currently two types categories of revisions in the source systems:
- Event-Based
- Weekly revisions.
These revision types are typically distinguished by a Revision Type. However, this field is not used in the source systems, despite being a key identifier for differentiating revision behaviour. In addition, revision dates are not maintained even when the they are reused across open transactional data.
From a conversion perspective, the scope includes only the creation of Event-Based revisions into Event-Based Maintenance Planning Buckets. Weekly revisions will be handled during The conversion scope will include only the migration of Event-Based revisions into Maintenance Planning Buckets. Weekly revisions will be handled as part of cutover activities and triggered via batch jobs., which will be owned by the core Functional team..
That said, to support data continuityHowever, from a conversion perspective, the mapping from legacy revisions to target Maintenance Planning Buckets for Weekly revisions will still be maintained as part of conversion. This ensures that downstream objects - such as Notifications and Work Orders - can correctly map to reference the appropriate target Maintenance Planning Bucket.
The data from legacy system includes:
Given this, and considering the estimated data volume, this object will be fully constructed. However, a source system report will still be required to supplement specific information needed to support the target system requirements.
Thedata from legacy system includes:
Revisions with Event-Based Revision Type (T352R-REVTY = "Event-Based")- Revisions within Maintenance Planning Plants (T352R-IWERK) in scope (Value Mapping: Plant where Maintenance Plant = Yes)
The data from legacy system excludes:
- Completed Revisions (T352R-REVTY = "X")
- Revisions in the Past
- Start Date in the Past (T352R-REVBD < Migration Date)
- End Date in the Past (T352R-REVBD) < Migration Date
- Revisions with a Date of Revision End in the future, based on the following conditions:
- Populated Date of Revision Start (T352R-REVBD <> "") and Date of Revision End (T352R-REVED <> "")
- Date of Revision End (T352R-REVED) is in the future (T352R-REVED) > Migration Date (Value Mapping: OTH_Migration_Date Relevant Values A2D (using Object ID "9101" and Field Name = "T352R-REVED"))
- Revisions with Missing Date of Revision Start (T352R-REVBD = "") or Date of Revision End (T352R-REVED = "") with Open Legacy Work Order Assigned (AUFK-AUFNR)
The data from legacy system excludes:
- Completed Revisions (Indicator: Revisions Completed (T352R-REVTY = "X"))
- Revisions in the Past (Date of Revision End (T352R-REVED) < Migration Date (Value Mapping: OTH_Migration_Date Relevant Values A2D (using Object ID "9101" and Field Name = "T352R-REVED")
- Revisions with Missing Date of Revision Start (T352R-REVBD = "") or Date of Revision End (T352R-REVED = "") with NO Open Legacy Work Order Assigned (AUFK-AUFNR)
Note: Open Legacy Work Order (AUFK-AUFNR) Criteria: </Start CR0438> System Status (JEST-STAT) <> TECO (Technically Completed) With Active (JEST-INAC <> 'X') System Status (JEST-STAT) = Created (CRTD) or Released (REL) </End CR0438>
List of Tables to extract for this object is maintained here: Extract Table Register.
List of source systems and approximate number of records.
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| DCT | Maintenance Planning Bucket will be collected via DCT. An initial extract of all relevant Revisions will be provided in google sheet format to assist business in decision making on including any relevant Revision from PF2 and WP2 as Maintenance Planning Buckets. | 250 | S/4HANA | 250 |
| DCT | Maintenance Planning Bucket for plants which do not have data existing from PF2 and PF2 | 50 | S/4HANA | 50 |
Additional Information
Multi-language Requirement
Maintenance Planning Bucket does not have multi language support. Maintenance Planning Bucket text will be migrated using EN logon.
Document Management
Not Applicable
Legal Requirement
Not Applicable
Special Requirements
Not Applicable
Target Design
The technical design of the target for this conversion approach.
1. Maintenance Planning Bucket
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| EAM_PLNGBKT | MAINTENANCEPLANNINGBUCKET | EAM_PLNGBCKT_OBJNR | Object Number of Maintenance Planning Bucket | CHAR | 20 | System |
| EAM_PLNGBKT | MAINTENANCEPLANNINGPLANT | IWERK | Maintenance Planning Plant | CHAR | 4 | Mandatory |
| EAM_PLNGBKT | MAINTENANCEPLANT | WERKS_D | Plant | CHAR | 4 | Mandatory |
| EAM_PLNGBKT | MAINTPLNGBUCKETLABEL | EAM_PLNGBKTLABEL | Label used for identifying the Maintenance Planning Bucket | CHAR | 40 | Mandatory |
| EAM_PLNGBKT | MAINTPLANNINGBUCKETDESCRIPTION | EAM_PLNGBKTDESC | Description of the Maintenance Planning Bucket | CHAR | 40 | Mandatory |
| EAM_PLNGBKT | MAINTPLANNINGBUCKETTYPE | EAM_PLNGBKTTYPE | Maintenance Planning Bucket Type | CHAR | 3 | Mandatory |
| EAM_PLNGBKT | MAINTPLNGBUCKETSTARTDATETIME | EAM_PLNGBKTSTARTDATETIME | Start of the Maintenance Planning Bucket | DEC | 15 | Mandatory |
| EAM_PLNGBKT | MAINTPLNGBUCKETENDDATETIME | EAM_PLNGBKTENDDATETIME | End of the Maintenance Planning Bucket | DEC | 15 | Mandatory |
| EAM_PLNGBKT | MAINTENANCESYSTEMSTATUSCODE | J_STATUS | Object status | CHAR | 5 | Mandatory |
| EAM_PLNGBKT | MAINTENANCEEVENT | REVNI | Revision for Plant Maintenance and Customer Service | CHAR | 8 | System |
| EAM_PLNGBKT | PERSONRESPONSIBLE | EAM_PERSONRESP_CHAR8 | Person Responsible | CHAR | 8 | Conditional |
2. Maintenance Events
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| IMR__VH |
Source Approx No. of Records
No. of Records
Additional Information
Multi-language Requirement
Revision does not have multi language support. Revision text will be migrated using EN logon.
Document Management
Not Applicable
Legal Requirement
Not Applicable
Special Requirements
Not Applicable
Target Design
The technical design of the target for this conversion approach.
1. Maintenance Planning Bucket
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement | EAM_PLNGBKT | MAINTPLANNINGBUCKETUUID | SYSUUID_X | UUID in X form (binary) | 16 | 0 | EAM_PLNGBKT | MAINTPLANNINGBUCKETTYPE | EAM_PLNGBKTTYPE | Maintenance Planning Bucket Type | 3 | 0 | EAM_PLNGBKT
|---|---|---|---|---|---|---|
| MAINTENANCEPLANNINGPLANT | IWERK | Maintenance Planning Plant | CHAR | 4 | ||
| Mandatory | ||||||
| IMR__ | ||||||
| VH | ||||||
| MAINTENANCEREVISION | EAM_PLNGBKTLABEL | Label used for identifying the Maintenance Planning Bucket | 40 | 0 | ||
| REVNI | Revision for Plant Maintenance and Customer Service | CHAR | 8 | System | ||
| IMR__VH | MAINTENANCEEVENTTYPE | DIWPS_REVTY_CORE | Revision Type | CHAR | 2 | Mandatory |
| IMR__VH | MAINTPLNGBUCKETLABEL | REVTX | Label used for identifying | EAM_PLNGBKT | MAINTPLANNINGBUCKETDESCRIPTION | EAM_PLNGBKTDESC | Description of
| the Maintenance Planning Bucket | CHAR | 40 | ||||
| Mandatory | ||||||
| IMR_ | NROFMAINTPLNGBUCKETSINADVANCE | EAM|||||
| _ | Number of planning buckets the system will create in advance | 3 | 0 | |||
| VH | MAINTPLANNINGBUCKETDESCRIPTION | EAM_PLNGBKTLABEL | Description | EAM_PLNGBKT | MAINTPLNGBUCKETSTARTDATETIME | EAM_PLNGBKTSTARTDATETIME | Start
| of the Maintenance Planning Bucket | ||||||
| CHAR | ||||||
| 40 | EAM_PLNGBKT | MAINTPLNGBUCKETENDDATETIME | EAM_PLNGBKTENDDATETIME | End of the|||
| Mandatory |
Note: Each Maintenance Planning Bucket
will correspond to one Maintenance Event.
Data Cleansing
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
|---|---|---|---|---|---|
| 9101-001 | C2 | Missing Events-Based Revision Start and End Dates | Events-Based Revision as per Relevancy Criteria where either Start or End Date is not available
| Maintenance Planning Plant, Revision, Description, Date of Revision Start, Date of Revision End | PF2, WP2 |
| 9101-002 | C3 | Info Report: Non-Relevant Events-Based Revision (Will not be migrated) | Events-Based Revision of in scope Maintenance Plants and falls in any of the criteria below:
Note: These Revisions will not be not migrated. Where necessary, the business can set the Date of Revision End to a future date. | Maintenance Planning Plant, Revision, Description, Date of Revision Start, Date of Revision End, Indicator: Revisions Completed | PF2, WP2 |
Note: List of Cleansing is maintained here: Conversion Specs Register (DCT & Cleansing Report)
Conversion Process
The following represents the high-level process for DCT:
Collection will be done manually in the Data Collection Template for the following scenarios:
- For sites not on SAP-PF2 or WP2 systems
Collection will be done manually in the Data Collection Template for the following scenarios:
- Relevant Events-Based Revisions from PF2 and WP2 systems
Data Privacy and Sensitivity
Not ApplicableExtraction
Extract data from a source into Advanced Data Migration and Management (ADMM) . There are 2 possibilities:
- The data exists. connects to the source and loads the data into the repository. There are 3 methods:
- Perform full data extraction from relevant tables in the source system(s).
- Perform extraction through the application layer.
- Only if ADMM 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 the repository. This is to be conducted using DCT (Data Collection Template) in Advanced Data Migration and Management (ADMM).
The agreed Relevancy criteria is applied to the extracted records as reference point to identify the records that are applicable for the data construction in the DCT.
Extraction Run Sheet
| Req # | Requirement Description | Team Responsible |
|---|---|---|
1 | Extract data from source system based on relevancy rule | SyWay Data Team |
2 | Google Sheet report pre-populated with PF2 and WP2 information to be generated based on relevancy criteria. | SyWay Data Team |
Selection Screen
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| Not Applicable |
Data Collection Template (DCT)
Target Ready Data Collection Template will be created for Maintenance Planning Bucket data with exception of some fields which require transformation as mentioned in the transformation rule.
1. Maintenance Planning Bucket DCT Rules
| Field Name | Field Description | Rule |
|---|---|---|
| MAINTENANCEPLANNINGPLANT | Maintenance Planning Plant | Mandatory. Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes |
| zLegacyREVNR | Legacy Revision for Plant Maintenance and Customer Service | Mandatory.
|
| MAINTPLNGBUCKETLABEL | Label used for identifying the Maintenance Planning Bucket | Mandatory. The naming convention for Maintenance Planning Bucket will follow the structure: Structure: EVT_Year_Free Text
Example: EVT_2026_Shutdown 01 |
| MAINTPLANNINGBUCKETDESCRIPTION | Description of the Maintenance Planning Bucket | Mandatory. Ensure that it does not include any of below characters: |
| zMAINTPLNGBUCKETSTARTDATE |
Data Cleansing
1. Cost Centre (FI) as per Relevancy Criteria
1. Work Breakdown Structure (PS) as per Relevancy Criteria
1. Work Centre as per Relevancy Criteria
Revision as per Relevancy Criteria where either Start or End Date is not available
- With Start Date but No End Date
- With No Start Date but with End Date
Note: List of Cleansing is maintained here: Conversion Specs Register (DCT & Cleansing Report)
Conversion Process
The high-level process is represented by the diagrams below.
The following represents the high-level process for Source System Extraction:The following represents the high-level process for DCT:
Collection will be done manually in the Data Collection Template for the following scenarios:
- For sites not on SAP-PF2 or WP2 systems
Data Privacy and Sensitivity
Not ApplicableExtraction
Extract data from a source into the . There are 2 possibilities:
- The data exists. connects to the source and loads the data into the repository. 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 the repository. This is to be conducted using DCT (Data Collection Template) in Advanced Data Migration and Management (ADMM).
The agreed Relevancy criteria is applied to the extracted records to identify the records that are applicable for the Target Loads.
Extraction Run Sheet
Selection Screen
Data Collection Template (DCT)
Target Ready Data Collection Template will be created for Maintenance Planning Bucket data with exception of some fields which require transformation as mentioned in the transformation rule.1. Maintenance Planning Bucket DCT Rules
| Field Name | Field Description | Rule |
|---|---|---|
| IWERK | Maintenance Planning Plant | Mandatory. Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes |
| EAM_PLNGBKTLABEL | Label used for identifying the Maintenance Planning Bucket | Mandatory. XXXXX |
| EAM_PLNGBKTDESC | Description of the Maintenance Planning Bucket | Mandatory. XXXXX |
| EAM_PLNGBKTTYPE | Maintenance Planning Bucket Type | Mandatory. XXXXX |
| zEAM_PLNGBKTSTARTDATE | Start Date of the Maintenance Planning Bucket | Mandatory.
|
| zEAM_PLNGBKTSTARTTIMEzMAINTPLNGBUCKETSTARTTIME | Start Time of the Maintenance Planning Bucket | Mandatory.
|
| zEAM_PLNGBKTENDDATEzMAINTPLNGBUCKETENDDATE | End Date of the Maintenance Planning Bucket | Mandatory.
Note: "Go-Live" = "Migration Date" during Mocks |
| zMAINTPLNGBUCKETENDTIMEzEAM_PLNGBKTENDTIME | End Time of the Maintenance Planning Bucket | Mandatory.
|
Extraction Dependencies
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 ADMM 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
| ||
| PERSONRESPONSIBLE | Person Responsible | Conditional.
|
| MAINTENANCEEVENTTYPE | Maintenance Event Type | Mandatory.
|
2. Maintenance Planning Bucket (Old to New Mapping) DCT Rules
| Field Name | Field Description | Rule |
|---|---|---|
| zLegacyIWERK | Legacy Maintenance Planning Plant | Mandatory. Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes |
| zLegacyREVNR | Legacy Revision for Plant Maintenance and Customer Service | Mandatory.
|
| zRevisionType | Legacy Revision Type | Mandatory. Allowed Values:
|
| MAINTENANCEPLANNINGPLANT | Maintenance Planning Plant | Mandatory. Allowed values: List from Value Mapping - Plant where Maintenance Plant = Yes |
| MAINTPLNGBUCKETLABEL | Label used for identifying the Maintenance Planning Bucket | Mandatory.
|
| MAINTENANCEEVENT | Maintenance Event | Mandatory.
Note: This is a system-generated field and will be populated post data load to S/4 |
Note: List of DCTs is maintained here: Conversion Specs Register (DCT & Cleansing Report)
Extraction Dependencies
| Item # | Step Description | Team Responsible |
|---|---|---|
| Not Applicable |
Transformation
The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow ADMM 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 – Maintenance Planning Bucket | 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. Maintenance Planning Bucket
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | - | - | - |
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 – Maintenance Planning Bucket
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. Maintenance Planning Bucket (ECC)
| S/4 Hana | EAM_PLNGBKT |
Concatenate from source fields of ECC T352R:
REVBD (Date of revision start) + ", " + REVBZ (Time of revision start)
| MAINTPLANNINGBUCKETUUID | UUID in X form (binary) | System Generated Note: To be created using the Custom Load Program. Leave this field blank in the Preload file. | ||
| 2 | DCT | - | MAINTENANCEPLANNINGPLANT | Maintenance Planning Plant |
| S/4 Hana | EAM_PLNGBKT |
| MAINTENANCEPLANNINGPLANT |
| Maintenance Planning |
Concatenate from source fields of ECC T352R:
REVED (Date of revision start) + ", " + REVEZ (Time of revision start)
| Plant | Direct Mapping | ||||||||
| 3 | DCT | - | MAINTENANCEPLANNINGPLANT | Maintenance Planning Plant | S/4 Hana | EAM_PLNGBKT | MAINTENANCEPLANT | Plant | Direct Mapping |
| 4 | DCT | - | MAINTPLNGBUCKETLABEL | Label used for identifying the Maintenance Planning Bucket |
| S/4 Hana | EAM_PLNGBKT |
| MAINTPLNGBUCKETLABEL | Label used for identifying the Maintenance Planning Bucket | Direct Mapping |
| 5 | DCT |
| - |
| MAINTPLANNINGBUCKETDESCRIPTION | Description of the Maintenance Planning Bucket |
| S/4 Hana | EAM_PLNGBKT |
| MAINTPLANNINGBUCKETDESCRIPTION | Description of the Maintenance Planning Bucket | Direct Mapping |
| 6 |
| - | - | - | - | S/4 Hana | EAM_PLNGBKT |
| MAINTPLANNINGBUCKETTYPE | Maintenance Planning Bucket Type | Default to "STO" for Event Based Maintenance | ||
| 7 | DCT | - | zMAINTPLNGBUCKETSTARTDATE | Start Date of the Maintenance Planning Bucket |
| S/4 Hana |
| EAM_PLNGBKT |
| MAINTPLNGBUCKETSTARTDATETIME | Start of the Maintenance Planning |
| Bucket | If zMAINTPLNGBUCKETSTARTTIME does not have a value in DCT, default to 000000. Concatenate from source fields of DCT EAM_PLNGBKT:
| |||
| 8 | DCT | - | zMAINTPLNGBUCKETSTARTTIME | Start Time of the Maintenance Planning Bucket |
| 9 | DCT | - | zMAINTPLNGBUCKETENDDATE | End Date of the Maintenance Planning Bucket |
| S/4 Hana |
| EAM_PLNGBKT |
2. Maintenance Planning Bucket (DCT)
| MAINTPLNGBUCKETENDDATETIME | End of the Maintenance Planning Bucket | If zMAINTPLNGBUCKETENDTIME does not have a value in DCT, default to 235959. Concatenate from source fields of DCT EAM_PLNGBKT:
| ||
| 10 | DCT | - | zMAINTPLNGBUCKETENDTIME | End Time of the Maintenance Planning Bucket |
| 11 |
| - | - | - | - | S/4 Hana | EAM_PLNGBKT |
| MAINTENANCESYSTEMSTATUSCODE | Object status | Default to "I0002" for Released | ||
| 12 | - | - | - | - |
| S/4 Hana | EAM_PLNGBKT |
| MAINTENANCEEVENT |
| Revision for Plant Maintenance and Customer Service | System Generated Note: To be created using the Custom Load Program. Leave this field blank in the Preload file. | |||
| 13 | - | - | - | - |
| S/4 Hana | EAM_PLNGBKT |
| PERSONRESPONSIBLE |
| Person Responsible |
| Direct Mapping |
2. Maintenance Events
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DCT | - | MAINTENANCEPLANNINGPLANT | Maintenance Planning Plant |
| S/4 Hana |
| IMR__ |
| VH |
| MAINTENANCEPLANNINGPLANT |
| Maintenance Planning |
| Plant | Direct Mapping |
| 2 | - | - | - | - | S/4 Hana |
| IMR__ |
| VH |
| MAINTENANCEREVISION |
| Revision for Plant Maintenance and Customer Service | System Generated | ||||
| 3 | DCT | - | MAINTENANCEEVENTTYPE | Revision Type | S/4 Hana |
| IMR__ |
| VH |
Concatenate from source fields of ECC T352R:
REVBD (Date of revision start) + ", " + REVBZ (Time of revision start)
| MAINTENANCEEVENTTYPE | Revision Type | Direct Mapping | ||
| 4 | DCT | - | MAINTPLNGBUCKETLABEL | Label used for identifying the Maintenance Planning Bucket |
| S/4 Hana |
| IMR__ |
| VH |
| MAINTPLNGBUCKETLABEL | Label used for identifying |
| the Maintenance Planning Bucket |
Concatenate from source fields of ECC T352R:
REVED (Date of revision start) + ", " + REVEZ (Time of revision start)
Transformation Mapping
Transformation Dependencies
List the steps that need to occur before transformation can commence1
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
Verify Record Count
Data team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets.
Accuracy
Conversion Accuracy
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
Completeness
Verify Record Count
Business team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets.
Accuracy
Conversion Accuracy
Business to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules (and signed-off 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
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
Cutover
Configuration
Conversion Objects
Error Handling
| Direct Mapping | |||||||||
| 5 | DCT | - | MAINTPLANNINGBUCKETDESCRIPTION | Description of the Maintenance Planning Bucket | S/4 Hana | IMR__VH | MAINTPLANNINGBUCKETDESCRIPTION | Description of the Maintenance Planning Bucket | Direct Mapping |
Note: Each Maintenance Planning Bucket will correspond to one Maintenance Event.
List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
| OTH_Migration_Date Relevant Values A2D | Dates to be defaulted for A2D objects for each Migration Cycle |
| Plant | Old to New Plant Mapping |
| Maintenance Planning Bucket (Old to New Mapping) | Old Revision to Maintenance Planning Bucket Mapping |
List of Transformation Mappings with additional details is maintained here: Transformation Mappings.
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step 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 | Data team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets. |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | 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 team to verify that the total number of relevant records from the source systems is equal to the total number of records in the Preload and Load Sheets. |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Business to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules (and signed-off 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
Note: A custom load program is required and is to be developed by the SyWay Development Team.
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
Cutover
Configuration
| Item # | Configuration Item |
|---|---|
| 1 | T001W-Plants/Branches |
| 2 | T399I-Planning Plant |
| 3 | TJ02-System status |
| 4 | IMAINTEVTYPEVH-Maintenance Event Type |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| Not Applicable |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
| Configuration | Invalid Plant | Engage Functional team to expedite and fix the error in the system |
| Configuration | Invalid Planning Plant | Engage Functional team to expedite and fix the error in the system |
| Configuration | Invalid System Status | Engage Functional team to expedite and fix the error in the system |
| Configuration | Invalid Maintenance Maintenance Event Type | Engage Functional team to expedite and fix the error in the system |
Post-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Verify Count | Data team to verify the record count created in target S/4 HANA by accessing post load reports in dspMigrate or standard reports from S/4 HANA. |
Verify Logs | Check if there is data that failed to load and perform the necessary actions (e.g. register as post load issue, or attempt to load the record again, etc.). |
Accuracy
| Task | Action |
|---|---|
Conversion Accuracy | Data team to verify that the Measuring Point data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA. |
Business
Completeness
| 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 Measuring Point data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA. |
Key Assumptions
- Maintenance Planning Bucket 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.
- Data entries in DCT are target-ready data unless a specific transformation rule is stated for that field in the transformation rules.
- Weekly Revisions are not in Conversion Scope. However, to support the data conversion of downstream objects such as Work Orders, the mapping from legacy Weekly Revisions to target Maintenance Planning Buckets will still be maintained within the data value mapping.
- A Maintenance Planning Bucket can only contain a single Maintenance Event. Each revision in the source system will be linked to a single Maintenance Planning Bucket and each Maintenance Planning Bucket will correspond to one Maintenance Event.
See also
Maintenance Planning Bucket is managed using Fiori Application and the some of the data sits within CDS views.
Since this is a new functionality, references have been included below to support the conversion process.
1. General Information
2. Event Planning and Execution Objects
3. System Status
Post-Load Validation
Project Team
Completeness
Verify Count
Data team to verify the record count created in target S/4 HANA by accessing post load reports in dspMigrate or standard reports from S/4 HANA.
Verify Logs
Check if there is data that failed to load and perform the necessary actions (e.g. register as post load issue, or attempt to load the record again, etc.).
Accuracy
Conversion Accuracy
Data team to verify that the Measuring Point data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA.
Business
Completeness
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
Conversion Accuracy
Verify that the Measuring Point data in target S/4 HANA were loaded correctly via dspMigrate post load reports or standard reports from S/4 HANA.
Key Assumptions
- Maintenance Planning Bucket 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.
Change log
| Change History | ||
|---|---|---|
|
Workflow history
| Workflow Report | ||||||
|---|---|---|---|---|---|---|
|






