You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 18 Next »

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:

  1. Projects Definition migrated to S/4 Hana where
    1. Project System Status not Created or Released (Examples are Technically Complete or Locked) or
    2. Project User Status is Maintained
  2. WBS elements migrated to S/4 Hana where
    1. WBS System Status not Created or Released (Examples are Technically Complete or Locked) or
    2. WBS User Status is Maintained
  3. Projects in S/4 with system status Created 

The data from legacy system excludes:

  1. 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 


After Posting Financials (Scenario 2 and 3):

  1. WBS Elements created in CNV-1022 Portfolio Items - update WBS element status as per the status in legacy system
    1. This includes system and user status
  2. Projects Created in CNV-1022 Portfolio items - update project status as per the status in legacy system
    1. This includes system and user status




List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

WP2Project Definitions with Reference to PPM Items
S/4
WP2WBS elements with Mapping from CNV-1026
S/4
PF2Project Definitions with Reference to PPM Items
S/4
PF2WBS elements with Mapping from CNV-1026
S/4
S/4Projects 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

  1. Where JEST-INACT not equal to X
  2. 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

  1. Where JEST-INACT not equal to X
  2. 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

TableFieldData ElementField DescriptionData TypeLengthRequirement
PROJPSPIDPS_PSPIDProject DefinitionCHAR24Mandatory
TJ02TTXT04J_TEXT_04System Status TextCHAR4Optional
TJ30TTXT04J_TEXT_04User Status TextCHAR4Optional
JESTOBJNRJ_OBJNRObject NumberCHAR22System Generated
JESTSTATJ_STATUSStatusCHAR5System Generated
JESTINACTJ_INACTIndicator Status is inactiveCHAR1System Generated
JESTCHGNRJ_CHGNRChange NumberNUMC3System Generated

WBS Level

TableFieldData ElementField DescriptionData TypeLengthRequirement
PRPSPOSIDPS_POSIDWBS IDCHAR24Mandatory
TJ02TTXT04J_TEXT_04System Status TextCHAR4Optional
TJ30TTXT04J_TEXT_04User Status TextCHAR4Optional
JESTOBJNRJ_OBJNRObject NumberCHAR22System Generated
JESTSTATJ_STATUSStatusCHAR5System Generated
JESTINACTJ_INACTIndicator Status is inactiveCHAR1System Generated
JESTCHGNRJ_CHGNRChange NumberNUMC3System Generated


Data Cleansing

All cleansing requirements dealt with in CNV-1024 Project Definition and CNV-1026 WBS - CAPEX, OPEX, Statistical

IDCriticalityError Message/Report DescriptionRuleOutputSource System



Conversion Process

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

Data Privacy and Sensitivity

Not Applicable


Extraction

Extract data from a source into Syniti Migrate. There are 2 possibilities:

  1. The data exists. Syniti Migrate. connects to the source and loads the data into Syniti Migrate.. There are 3 methods:
    1. Perform full data extraction from relevant tables in the source system(s).
    2. Perform extraction through the application layer.
    3. Only if Syniti Migrate.; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
  2. The data does not exist 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 DescriptionTeam Responsible
1Extract data from source system based on relevancy ruleSyWay Data Team
2Extract data from S/4 system based on relevancy ruleSyWay Data Team
3Perform 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 ScreenParameter NameSelection TypeRequirementValue to be entered/set


Data Collection Template (DCT)

No requirement for collection
Field NameField DescriptionRule

Extraction Dependencies

Item #Step DescriptionTeam Responsible
1Successful Load of CNV-1022 Portfolio ItemsSyWay Data Team
2Successful load of CNV-1024 Project DefinitionsSyWay Data Team
3Successful load of CNV-1026 WBS CAPEX, OPEX, StatisticalSyWay 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:

  1. Perform value mapping and data transformation rules.
    1. Legacy values are mapped to the to-be values (this could include a default value)
    2. Values are transformed according to the rules defined in Syniti Migrate
  2. Prepare target-ready data in the structure and format that is required for loading via prescribed Load Tool. This step also produces the load data ready for business to perform Pre-load Data Validation

Transformation Run Sheet

Item #Step DescriptionTeam Responsible
1Execute Load and perform Transformation Data team
2Monitor the transformation progress and ensure performance and completion is within allowed timeframeData team
3Review and Validate Error and Preload ReportsData Team
4Generate data load count.Data team
5Generate Load FilesData Team
6Log errors as defects, if any and address resolutions. Close defects.Data team
7Re-transform and re-validate the Pre-load reports if necessary.Data team
8Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off.Business
9Analyze and resolve any pre-load defects logged by business.Data team
10Repeat steps 7 to 10 if necessaryData team
11Proceed to pre-load validationsData 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 systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

S/4PROJPSPIDProject DefinitionS/4 HanaPROJPSPIDProject DefinitionCopy from Source





S/4 HanaTJ02TTXT04StatusDefault 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 systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

PF2/WP2PRPSPOSIDWBS ElementS/4 HanaPRPSPSPIDWBS ElementMapping Table Old WBS Element to New WBS

PF2/WP2JESTSTATUSStatusS/4 HanaTJ02TTXT04System StatusMapping: Legacy_PRPS_Status where Legacy status has Hana_System_Status

PF2/WP2JESTSTATUSStatusS/4 HanaTJ30TTXT04User StatusMapping:  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 systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

S/4PROJPSPIDProject DefinitionS/4 HanaPROJPSPIDProject DefinitionMapping Table Old WBS Element to New WBS

PF2/WP2JESTSTATUSStatusS/4 HanaTJ02TTXT04System StatusMapping: Legacy_PRPS_Status where Legacy status has Hana_System_Status

PF2/WP2JESTSTATUSStatusS/4 HanaTJ30TTXT04User StatusMapping:  LLegacy_PRPS_Status where Legacy status has Hana_User_Status


Transformation Mapping

Mapping Table NameMapping 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 DescriptionTeam Responsible
1Ensure 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 release 

Completeness

TaskAction

Verify Counts

Data team to verify the load count is the same as per identified identified from JEST.


Accuracy

TaskAction
Conversion Accuracy

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

TaskAction

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

TaskAction

Conversion Accuracy

Business Data Owner/s to verify that all the data in the load table/file is accurate as per endorsed transformation/mapping rules.


Load

The load process includes:

  1. Execute the automated data load into target system for each scenario separately using load tool
  2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation

Load Run Sheet

Item #Step DescriptionTeam Responsible
1Load Scenario 1 using transaction using load tool SyWay Data Team
2Load 3 records for < > to validate if data is loaded successfully without errorsSyWay Data Team
3Load 3 records for < > to validate if data is loaded successfully without errorsSyWay Data Team
4Proceed with full load if steps 2 and 3 are validatedSyWay Data Team
5Validate few records loaded by accessing Project ReportSyWay Data Team
6

Load Scenario 2 using transaction using load tool

SyWay Data Team
7Load 3 records for < > to validate if data is loaded successfully without errorsSyWay Data Team
8Load 3 records for < > to validate if data is loaded successfully without errorsSyWay Data Team
9Proceed with full load if steps 7 and 8 are validatedSyWay Data Team
10Validate few records loaded by accessing WBS ReportSyWay Data Team
11

Load Scenario 3 using transaction using load tool

SyWay Data Team
12Load 3 records for < > to validate if data is loaded successfully without errorsSyWay Data Team
13Load 3 records for < > to validate if data is loaded successfully without errorsSyWay Data Team
14Proceed with full load if steps 12 and 13 are validatedSyWay Data Team
15Validate few records loaded by accessing Project ReportSyWay Data Team
16Generate post load report if step 18 is validatedSyWay 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


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
1WBS User Status
2Project Profile

Conversion Objects

Object #Preceding Object Conversion Approach
11026 - WBS CAPEX, OPEX, STATISTICAL
29031 - Project - Actual GL Line Items (PNL - WBS for AuC)
39032 - GL Line Items (PNL - Internal Order, Statistical/ Opex WBS)

Error Handling

Error TypeError DescriptionAction Taken
Invalid DataProject Definition has not been created in S/4HANA hence status cannot be setReview load of CNV-1022
Invalid DataWBS has not been created in S/4HANA hence WBS hence status cannot be setReview load of CNV-1026
System validationSetting of new status not allowed due to active System / User StatusCorrect upload data, review mapping rules


Post-Load Validation

Project Team

Completeness

TaskAction

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

TaskAction

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

TaskAction
Verify Project data - Project Definition Extract data from PS report CN41N in S/4 Hana and compare with expected record counts

Accuracy

TaskAction
Verify Project data - Project Definition Extract data from PS report CN41N in S/4 Hana
ReconcilePost 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.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 18) Feb 10, 2026 15:29 KOHN-ext, Jacob
v. 26 Jan 16, 2026 10:25 KOHN-ext, Jacob
v. 25 Jan 09, 2026 10:17 KOHN-ext, Jacob
v. 24 Dec 17, 2025 12:20 KOHN-ext, Jacob
v. 23 Dec 17, 2025 12:19 KOHN-ext, Jacob
v. 22 Dec 17, 2025 11:39 KOHN-ext, Jacob
v. 21 Dec 17, 2025 08:55 KOHN-ext, Jacob
v. 20 Dec 10, 2025 15:36 KOHN-ext, Jacob
v. 19 Dec 10, 2025 15:32 KOHN-ext, Jacob
v. 18 Dec 10, 2025 15:15 KOHN-ext, Jacob

Go to Page History

  • No labels