| Status | Approved |
|---|---|
| Owner | |
| Stakeholders |
Purpose
The purpose of this document is to define the conversion approach to maintain the project status in S/4 HANA.
Project and WBS element status consists of System and user statuses which together controls business functions allowed on the object. In the SyWay solution there is integration between the status of the project in PS and the PPM Item.
Conversion Scope
The scope of this document covers the approach for converting active Project status from Legacy Source Systems into S/4HANA.
There are 2 group go-live as below:
- Group 1 go-live (1 July 2028) (Source System: PF2)
- Selection based on Company Code
- Group 2 go-live (1 Jan 2029) (Source System: WP2)
- Selection based on Company Code
Note: There is possibility to shift into 1 go live date, this option is currently still being considered.
Projects created in each group is treated separately.
Projects created for the go-live group in S/4 with Created status is to be released to allow WBS elements to be used, excludes template projects. Template project status changes are included in CNV-1019.
The status of Projects and WBS elements migrated from Legacy system is aligned with the status Legacy system.
Relevancy Criteria
The data from legacy system includes:
- Projects Definition migrated to S/4 Hana where
- Project System Status not Created or Released (Examples are Technically Complete or Locked) or
- Project User Status is Maintained
- WBS elements migrated to S/4 Hana where
- WBS System Status not Created or Released (Examples are Technically Complete or Locked) or
- WBS User Status is Maintained
- Projects in S/4 with system status Created
The data from legacy system excludes:
- Projects for Template projects
Before Posting Financials (Scenario 1):
Release projects created in the group with created status in S/4.
This will allow the posting of actuals and the settlement of cost where relevant by
- CNV-9031 Project-Actual GL Line Items (PNL-WBS for AuC)
- CNV-9032 GL Line Items (PNL Internal Order, Statistical/Opex WBS)
After Posting Financials (Scenario 2 and 3):
- WBS Elements created in CNV-1022 Portfolio Items - update WBS element status as per the status in legacy system
- This includes system and user status
- Projects Created in CNV-1022 Portfolio items - update project status as per the status in legacy system
- This includes system and user status
| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| WP2 | Project Definitions with Reference to PPM Items | S/4 | ||
| WP2 | WBS elements with Mapping from CNV-1026 | S/4 | ||
| PF2 | Project Definitions with Reference to PPM Items | S/4 | ||
| PF2 | WBS elements with Mapping from CNV-1026 | S/4 | ||
| S/4 | Projects with created status | S/4 |
Identification
Project Status
Select Object number from table PROJ for PSPID equals Legacy ID
Select Statuses from table JEST using Object Number
- Where JEST-INACT not equal to X
- excluding Created (I0001) or Released (I0002)
WBS Status
Select Object number from table PRPS for PSPHI equals Legacy ID
Select Statuses from table JEST using Object Number
- Where JEST-INACT not equal to X
- excluding Created (I0001) or Released (I0002)
S/4 Projects Status Created (excluding template projects)
Select Object number from table PROJ where PSPID <> T*
Select Statuses from table JEST using Object Number where status is Created (I0001)
Additional Information
Multi-language Requirement
Not Applicable
Document Management
Not Applicable
Legal Requirement
Not Applicable
Special Requirements
Not Applicable
Target Design
The technical design of the target for this conversion approach.
Project Level
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| PROJ | PSPID | PS_PSPID | Project Definition | CHAR | 24 | Mandatory |
| TJ02T | TXT04 | J_TEXT_04 | System Status Text | CHAR | 4 | Optional |
| TJ30T | TXT04 | J_TEXT_04 | User Status Text | CHAR | 4 | Optional |
| JEST | OBJNR | J_OBJNR | Object Number | CHAR | 22 | System Generated |
| JEST | STAT | J_STATUS | Status | CHAR | 5 | System Generated |
| JEST | INACT | J_INACT | Indicator Status is inactive | CHAR | 1 | System Generated |
| JEST | CHGNR | J_CHGNR | Change Number | NUMC | 3 | System Generated |
WBS Level
| Table | Field | Data Element | Field Description | Data Type | Length | Requirement |
|---|---|---|---|---|---|---|
| PRPS | POSID | PS_POSID | WBS ID | CHAR | 24 | Mandatory |
| TJ02T | TXT04 | J_TEXT_04 | System Status Text | CHAR | 4 | Optional |
| TJ30T | TXT04 | J_TEXT_04 | User Status Text | CHAR | 4 | Optional |
| JEST | OBJNR | J_OBJNR | Object Number | CHAR | 22 | System Generated |
| JEST | STAT | J_STATUS | Status | CHAR | 5 | System Generated |
| JEST | INACT | J_INACT | Indicator Status is inactive | CHAR | 1 | System Generated |
| JEST | CHGNR | J_CHGNR | Change Number | NUMC | 3 | System Generated |
Data Cleansing
All cleansing requirements dealt with in CNV-1024 Project Definition and CNV-1026 WBS - CAPEX, OPEX, Statistical
| ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
|---|
Conversion Process
The high-level process is represented by the diagram below:
Data Privacy and Sensitivity
Not ApplicableExtraction
Extract data from a source into Syniti Migrate. There are 2 possibilities:
- The data exists. Syniti Migrate. connects to the source and loads the data into Syniti Migrate.. There are 3 methods:
- Perform full data extraction from relevant tables in the source system(s).
- Perform extraction through the application layer.
- Only if Syniti Migrate.; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
- The data does not exist in source system but has already been captured in a Syniti DCT.
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 |
| 2 | Extract data from S/4 system based on relevancy rule | SyWay Data Team |
| 3 | Perform preliminary completeness check, data quality check. | SyWay Data Team |
| 4 | Raise issues as defects if Req # 1 to 2 are not met | SyWay Data Team |
| 5 | Repeat Req # 1 to 3 if required | SyWay Data Team |
Selection Screen
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value to be entered/set |
|---|
Data Collection Template (DCT)
No requirement for collection| Field Name | Field Description | Rule |
|---|
Extraction Dependencies
| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Successful Load of CNV-1022 Portfolio Items | SyWay Data Team |
| 2 | Successful load of CNV-1024 Project Definitions | SyWay Data Team |
| 3 | Successful load of CNV-1026 WBS CAPEX, OPEX, Statistical | SyWay Data Team |
Transformation
The Target fields are mapped to the applicable Legacy field that will be its source. This identifies the transformation activity required to allow Syniti Migrate
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 Syniti Migrate
- 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 | Execute Load and perform Transformation | Data team |
| 2 | Monitor the transformation progress and ensure performance and completion is within allowed timeframe | Data team |
| 3 | Review and Validate Error and Preload Reports | Data Team |
| 4 | Generate data load count. | Data team |
| 5 | Generate Load Files | Data Team |
| 6 | Log errors as defects, if any and address resolutions. Close defects. | Data team |
| 7 | Re-transform and re-validate the Pre-load reports if necessary. | Data team |
| 8 | Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off. | Business |
| 9 | Analyze and resolve any pre-load defects logged by business. | Data team |
| 10 | Repeat steps 7 to 10 if necessary | Data team |
| 11 | Proceed to pre-load validations | Data team |
Transformation Rules
The transformation is done in 3 Scenarios.
Scenario 1.
Update the status of projects in S/4 in Created Status- the below transformation assumes BAPI_BUS2001_SET_STATUS or transaction CNMASSSTATUS
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| S/4 | PROJ | PSPID | Project Definition | S/4 Hana | PROJ | PSPID | Project Definition | Copy from Source | |
| S/4 Hana | TJ02T | TXT04 | Status | Default to "REL" |
Scenario 2
Update the status of WBS elements migrated through CNV-1026 where mapping exists to legacy data. The below transformation assumes BAPI_BUS2054_SET_STATUS or transaction CNMASSSTATUS
The status from legacy may be mapped to either a system or a user status in S/4 Hana
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| PF2/WP2 | PRPS | POSID | WBS Element | S/4 Hana | PRPS | PSPID | WBS Element | Mapping Table Old WBS Element to New WBS | |
| PF2/WP2 | JEST | STATUS | Status | S/4 Hana | TJ02T | TXT04 | System Status | Mapping: Legacy_PRPS_Status where Legacy status has Hana_System_Status | |
| PF2/WP2 | JEST | STATUS | Status | S/4 Hana | TJ30T | TXT04 | User Status | Mapping: LLegacy_PRPS_Status where Legacy status has Hana_User_Status |
Scenario 3
Update the Project Definitions with Legacy ID's where for legacy data. The below transformation assumes BAPI_BUS2001_SET_STATUS or transaction CNMASSSTATUS
The status from legacy may be mapped to either a system or a user status in S/4 Hana
| Rule # | Source system | Source Table | Source Field | Source Description | Target System | Target Table | Target Field | Target Description | Transformation Logic |
|---|---|---|---|---|---|---|---|---|---|
| S/4 | PROJ | PSPID | Project Definition | S/4 Hana | PROJ | PSPID | Project Definition | Mapping Table Old WBS Element to New WBS | |
| PF2/WP2 | JEST | STATUS | Status | S/4 Hana | TJ02T | TXT04 | System Status | Mapping: Legacy_PRPS_Status where Legacy status has Hana_System_Status | |
| PF2/WP2 | JEST | STATUS | Status | S/4 Hana | TJ30T | TXT04 | User Status | Mapping: LLegacy_PRPS_Status where Legacy status has Hana_User_Status |
Transformation Mapping
| Mapping Table Name | Mapping Table Description |
|---|---|
| Legacy_PRPS_Status | Mapping System and User Status from Legacy Systems to S/4 Status Source System, Object Type (PD or WBS), Legacy Status (Number), Hana_System_Status (TXT04), Hana_User_Status (TXT04) |
WBS Elements | POSID: Old WBS Elements to New WBS Elements |
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Ensure all the fields that require value mapping, as stipulated in Section "Mapping tables", have the correct values mapped. | SyWay Data Team |
Pre-Load Validation
Project Team
The following is executed for each scenario separately as the releaseCompleteness
| Task | Action |
|---|---|
Verify Counts | Data team to verify the load count is the same as per identified identified from JEST. |
Accuracy
| Task | Action |
|---|---|
| Conversion Accuracy | SyWay I2M 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 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. |
Load
The load process includes:
- Execute the automated data load into target system for each scenario separately using load tool
- 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 | Load Scenario 1 using transaction using load tool | SyWay Data Team |
| 2 | Load 3 records for < > to validate if data is loaded successfully without errors | SyWay Data Team |
| 3 | Load 3 records for < > to validate if data is loaded successfully without errors | SyWay Data Team |
| 4 | Proceed with full load if steps 2 and 3 are validated | SyWay Data Team |
| 5 | Validate few records loaded by accessing Project Report | SyWay Data Team |
| 6 | Load Scenario 2 using transaction using load tool | SyWay Data Team |
| 7 | Load 3 records for < > to validate if data is loaded successfully without errors | SyWay Data Team |
| 8 | Load 3 records for < > to validate if data is loaded successfully without errors | SyWay Data Team |
| 9 | Proceed with full load if steps 7 and 8 are validated | SyWay Data Team |
| 10 | Validate few records loaded by accessing WBS Report | SyWay Data Team |
| 11 | Load Scenario 3 using transaction using load tool | SyWay Data Team |
| 12 | Load 3 records for < > to validate if data is loaded successfully without errors | SyWay Data Team |
| 13 | Load 3 records for < > to validate if data is loaded successfully without errors | SyWay Data Team |
| 14 | Proceed with full load if steps 12 and 13 are validated | SyWay Data Team |
| 15 | Validate few records loaded by accessing Project Report | SyWay Data Team |
| 16 | Generate post load report if step 18 is validated | SyWay Data Team |
| 17 | Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off. | SyWay Data Team |
Load Phase and Dependencies
The project status update may be required to be executed before and after the financial postings i
- CNV-9031 Project-Actual GL Line Items (PNL-WBS for AuC)
- CNV-9032 GL Line Items (PNL Internal Order, Statistical/Opex WBS)
Generation of the Load file to consider the Project Definitions loaded to S/4 based on the Go-Live Group.
There are 2 group go-live as below:
- Group 1 go-live (1 July 2028) (Source System: PF2)
- Group 2 go-live (1 Jan 2029) (Source System: WP2)
Note: There is possibility to shift into 1 go live date, this option is currently still being considered.
Configuration
| Item # | Configuration Item |
|---|---|
| 1 | WBS User Status |
| 2 | Project Profile |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| 1 | 1026 - WBS CAPEX, OPEX, STATISTICAL |
| 2 | 9031 - Project - Actual GL Line Items (PNL - WBS for AuC) |
| 3 | 9032 - GL Line Items (PNL - Internal Order, Statistical/ Opex WBS) |
Error Handling
| Error Type | Error Description | Action Taken |
|---|---|---|
| Invalid Data | Project Definition has not been created in S/4HANA hence status cannot be set | Review load of CNV-1022 |
| Invalid Data | WBS has not been created in S/4HANA hence WBS hence status cannot be set | Review load of CNV-1026 |
| System validation | Setting of new status not allowed due to active System / User Status | Correct upload data, review mapping rules |
Post-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
Verify Count | SyWay I2M Data Team to verify the record count created in target S/4 HANA by accessing post load reports or standard reports (CN41n) 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 | Verify that the Project Definition in target S/4 HANA were loaded correctly via Project Builder display and Reports like CN41N |
Business
Completeness
| Task | Action |
|---|---|
| Verify Project data - Project Definition | Extract data from PS report CN41N in S/4 Hana and compare with expected record counts |
Accuracy
| Task | Action |
|---|---|
| Verify Project data - Project Definition | Extract data from PS report CN41N in S/4 Hana |
| Reconcile | Post load report for projects with legacy project id's containing ECC Project and WBS System and User Status with S/4 Hana Project WBS element System and User Status |
Key Assumptions
- Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
- Project Status is in scope based on data design and any exception requested by business.
