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.
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 will primarily be used to release maintenance orders, enabling material staging, permit processing, and job scheduling, while preventing further structural changes to planning data.
Some of the key information required to support Maintenance Planning Buckets is not consistently maintained in the source systems.
There are currently two categories of 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 cutover activities and triggered via batch jobs, which will be owned by the core Functional team..
That said, to support data continuity, 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 Work Orders - can correctly reference the appropriate target Maintenance Planning Bucket.
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.
The data from legacy system includes:
The data from legacy system excludes:
Note: Open Legacy Work Order (AUFK-AUFNR) Criteria: System Status (JEST-STAT) <> TECO (Technically Completed)
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 |
Maintenance Planning Bucket does not have multi language support. Maintenance Planning Bucket text will be migrated using EN logon.
Not Applicable
Not Applicable
Not Applicable
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 | MAINTENANCEPLANNINGPLANT | IWERK | Maintenance Planning Plant | CHAR | 4 | Mandatory |
| IMR__VH | MAINTENANCEREVISION | 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 the Maintenance Planning Bucket | CHAR | 40 | Mandatory |
| IMR__VH | MAINTPLANNINGBUCKETDESCRIPTION | EAM_PLNGBKTLABEL | Description of the Maintenance Planning Bucket | CHAR | 40 | Mandatory |
Note: Each Maintenance Planning Bucket will correspond to one Maintenance Event.
| 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)
The following represents the high-level process for DCT:
Collection will be done manually in the Data Collection Template for the following scenarios:
Collection will be done manually in the Data Collection Template for the following scenarios:
Extract data from a source into Advanced Data Migration and Management (ADMM) . There are 2 possibilities:
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.
| 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 Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|---|---|---|---|
| Not Applicable |
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. Ensure that it does not include any of below characters: |
| MAINTPLANNINGBUCKETDESCRIPTION | Description of the Maintenance Planning Bucket | Mandatory. Ensure that it does not include any of below characters: |
| zMAINTPLNGBUCKETSTARTDATE | Start Date of the Maintenance Planning Bucket | Mandatory.
|
| zMAINTPLNGBUCKETSTARTTIME | Start Time of the Maintenance Planning Bucket | Mandatory.
|
| zMAINTPLNGBUCKETENDDATE | End Date of the Maintenance Planning Bucket | Mandatory.
Note: "Go-Live" = "Migration Date" during Mocks |
| zMAINTPLNGBUCKETENDTIME | End Time of the Maintenance Planning Bucket | Mandatory.
|
| 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)
| Item # | Step Description | Team Responsible |
|---|---|---|
| Not Applicable |
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:
| 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 | - | - | - | S/4 Hana | EAM_PLNGBKT | MAINTPLANNINGBUCKETUUID | UUID in X form (binary) | System Generated | |
| 2 | DCT | - | MAINTENANCEPLANNINGPLANT | Maintenance Planning Plant | S/4 Hana | EAM_PLNGBKT | MAINTENANCEPLANNINGPLANT | Maintenance Planning 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 | 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 |
| 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 | 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 | 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.
| 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.
| 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 |
| 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. |
| 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. |
| 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. |
| 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) |
The load process includes:
Note: A custom load program is required and is to be developed by the SyWay Development Team.
| 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
| Item # | Configuration Item |
|---|---|
| 1 | T001W-Plants/Branches |
| 2 | T399I-Planning Plant |
| 3 | TC24-Person responsible for the work center |
| 4 | TJ02-System status |
| 5 | IMAINTEVTYPEVH-Maintenance Event Type |
| Object # | Preceding Object Conversion Approach |
|---|---|
| Not Applicable |
| 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 Person Responsible | 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 |
| 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.). |
| 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. |
| 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. |
| 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. |
Any additional key assumptions.
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
