Apply data transformation from PRPS

Unique Identifier for the Item, system generated number. In SyWay, the prefix "A" indicates a Capex item/project, "E" denotes Opex, and "R" represents R&I.
For China instance a new number range will be defined.

Unique Identifier for the Item's parent Bucket. In SyWay it is the ID of the L3 bucket where item is assigned

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

Item types define the structure and behavior of the portfolio item. In Syway item types will be based on the function and number of phases of the project. Refer configuration table field /RPM/ITEM_TYPE- ITEM_TYPE for allowed values.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

40 character description of the PPM Item

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

Represents status of an item (from Customizing). Refer configuration table field /RPM/ITEM_STATUS- STATUS against ITEM_TYPE for the allowed values of the selected Item Type.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

Baseline start date of the item/ project used for planning within the portfolio/ bucket.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

Expected Delivery Date. Baseline finish date of the item/ project used for planning within the portfolio/ bucket.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

In Syway, "Category" represents the business driver. It is a dropdown field with customizable values. Refer configuration table field RPM_PROJ_CAT-CATEGORY for the allowed values.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

In Syway, "Sub Category" represents the rationale behind the investment/expense for the item/project. This is a dropdown field whose values are configurable and depend on the selected "Category". Refer configuration table field RPM_PROJ_SUBCAT- SUBCATEGORY against the selected field RPM_PROJ_SUBCAT- CATEGORY.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

Represents Company code; the legal entity in which the Syway Project will be executed. Refer configuration table field V_DPR_AREA- AREA for the allowed values.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

In SyWay, investment category is a mandatory field to define the drivers for the project Growth/ Sustenance. Field content from /SYQ/T_INV_CAT

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

The Capex spending range used for reporting the project size i.e. XS, S, M, L & XL.  Field content from /SYQ/T_SPND_RNGE

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

This field indicates confidential projects. Access will be restricted if selection is "Yes"

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

This field represent Position of the Person Responsible for WBS elements (Project Manager) and is mandatory for all SyWay business functions. Manually selected from the drop-down list. Refer configuration table field TCJ04-PS_VERNR for field validation.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

This field represent Position of the Project Financial Controller for a project and is mandatory for all SyWay business functions. Manually selected from the drop-down list. Refer configuration table field TCJ05-ASTNR for field validation.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

Profit centre is required on PPM Item to create Project in SAP PS automatically. Refer master table field CEPC-PRCTR for Profit center list.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

In Syway, "Investment Reason" represent the detailed investment/ expense reason. This is a dropdown field and depend on the selected "Sub Category" Field content from /SYQ/T_INV_REASON

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

This field represent Archetype of the R&I PPM item. N/A for IS & IT PPM Items.  Refer configuration table field RPM_PROJ_TYPE- PTYPE against the selected field RPM_PROJ_TYPE- CATEGORY.  Field content from /SYQ/T_ARCHETYPE

Conditional based on Category

Plant represent a site of the PPM Item. Mandatory for all PPM Items.

It is a Required Field: Preload Check to be done to confirm that this field is filled the Data Collection Template

1

Ensure DCT is collected for Item

Data Team

2

Perform preliminary completeness check

Data Team

3

Raise issues as defects if Req # 1 to 2 are not met

Data Team

4

Repeat Req # 1 to 3 if required

Data Team

1

Obtain DCT Sign-off from Business

Data Team

2

Execute and Load and perform Transformation 

Data Team

3

Monitor the transformation progress and ensure performance and completion is within allowed timeframe

Data team

4

Review and Validate Error and Preload Reports

Data Team

5

Generate data load count.

Data team

6

Generate Load Files

Data Team

7

Log errors as defects, if any and address resolutions. Close defects.

Data team

8

Re-transform and re-validate the Pre-load reports if necessary.

Data team

9

Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off.

Business

10

Analyse and resolve any pre-load defects logged by business.

Data team

11

Repeat steps 7 to 10 if necessary

Data team

12

Proceed to pre-load validations

Data team

Apply first successful rule

If any WBS elements has IT. PRPS-USER0 starts with IT then Z009

If PROJ-PSPID start with RR* then Z004

IF PROJ-ZINV = B4 Then Z011

IF PROJ-ZINV = B3 Then Z012

IF PROJ-ZINV = B1, H1, or H2 Then Z013

IF PROJ-PSPID 4&5 Character of Project ID is /J: Then Z001

If PROJ-PSPID 4&5 Character of Project ID is /M: then Z002

f PROJ-PSPID 4&5 Character of Project ID is /C: then Z003

If no WBS elements is Capital, PRPS-IMPRF then Item type PRPS-Z010

Copy source to target

Value Mapping 

Item

Item

Item

Item

Item

Copy from source, format YYYYMMDD

Item

Item

Copy from Source

Item

Item

Item

Item

Item

Apply first successful rule

If PROJ-PSPID start with R-* then Z004

Investment Reason = H0 then Z009

IF PROJ-ZINV = B4 Then Z011

IF PROJ-ZINV = B3 Then Z012

IF PROJ-ZINV = B1, B5, H1, or H2 Then Z013

IF PROJ-PSPID 4&5 Character of Project ID is /J: Then Z001

If PROJ-PSPID 4&5 Character of Project ID is /M: then Z002

f PROJ-PSPID 4&5 Character of Project ID is /C: then Z003

If no WBS elements is Capital, PRPS-IMPRF="" then Item type PRPS-Z010

Copy source to target

Item

Item

Item

Item

Item

Copy from source, format YYYYMMDD

Item

Item

Copy from Source

Item

Item

Item

Item

Item

Default to Syensqo

1

Ensure all the fields that require value mapping, as stipulated. Mapping tables, have the correct values mapped and imported into tool.

Data Team 

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 (DCT) data.

Verify Record Count

Business Data Owner/s to verify that the total number of relevant records from the DCT is equal to the total number of records in the Preload and Load Sheets.

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

1073

Profit Centre

Invalid Data

Invalid Portfolio

Validate DCT default content

Invalid Data

Invalid Bucket ID (Parent ID does not exist)

Correct upload data

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

Conversion Accuracy

Verify that the Bucket Hierarchy in target S/4 HANA were loaded correctly via Standard Portfolio Item display and table /RPM/ITEM_D

Extract Item details from Item App in S/4 Hana