RPM_PROJECTTYPE

This field is display only and is filled with a sequential number when user adds a item record

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

Dropdown list from the Buckets maintained in CNV_1113 Portfolio Bucket Hierarchy

It is a Required Field: Preload Check to be done to confirm that this field is filled in 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 in the Data Collection Template

Short description of the PPM Item

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

Long Description, this field is used to provide a concise description of the PPM Item.

Entered where information is available

Represents status of an item

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 in 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 in 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 in the Data Collection Template

In Syway, Investment Reason is level-3 category of investment.

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 in the Data Collection Template

In SyWay, this field 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 in the Data Collection Template

Internal ID of Initiative where Item must be linked to Initiative

Dropdown list from the Initiatives maintained in CNV_1023 Portfolio Initiatives

This is an optional field

The Capex spending range used for reporting the project size.

Dropdown values from /SYQ/T_SPND_RNGE

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

GBU Market Hierarchy is a GBU-led Market segmentation, applied to both customer and product combination.

To be selected only for applicable PPM Items.

Dropdown values from  /SYQ/T_BU_DMN

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

Node of GBU Market Hierarchy used for reporting

To be selected only for applicable PPM Items

Dropdown values from  /SYQ/T_END_USR_MKT

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

Corporate-led Market segmentation used for reporting

To be selected only for applicable PPM Items.

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

In SyWay, Used to group items together for reporting where a budget allocation is made at an aggregated level, and actuals are collected against individual related items.

Reference to the product hierarchy node ( at any level) required for reporting.  

It is a required field when Item Type is related to either IS or R&I project.  

Refer table HRRP_NODE- NODEVALUE where HRRP_NODE- NODETYPE = N and HRYTYPE = MD01"

Preload Check to be done to confirm that this field is filled in the Data Collection Template when required.

To identify if the project is applicable for regulatory governance.

This is a dropdown field from /SYQ/T_EXPORT_CNTL

This is a required field: Preload Check to be done to confirm that this field is filled in the Data Collection Template

This field captures the justification for the relevance of export control (long text field).

This is a required field: Preload Check to be done to confirm that this field is filled in the Data Collection Template

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

Options are Yes/No

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

This field stores Position of the Project Owner for the PPM Item and is mandatory for all SyWay business functions. 

Refer configuration table field TCJ04-PS_VERNR for field validation.

Preload Check to be done to confirm that this field is filled in the Data Collection Template when required.

This field represent Position of the Project Financial Controller for a project and is mandatory for all SyWay business functions.

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 in the Data Collection Template

For the Risk managed project - this field define the risk magnitude at the start of project. 

This field is required to be maintained if Scoring Methodology = Risk  

This is a dropdown field /SYQ/T_RISK_MAGNITUDE

Preload Check to be done to confirm that this field is filled in the Data Collection Template when required.

For the Risk managed project - this field define the risk likelihood at the start of project. 

This field is required to be maintained if Scoring Methodology = Risk

This is a dropdown field /SYQ/T_RISK_LKLHD

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

For the Risk managed ongoing approved project - this field defines remaining risk magnitude. 

This field is required to be maintained if Scoring Methodology = Risk

This is a dropdown field  from /SYQ/T_RISK_MAGNITUDE

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

For the Risk managed ongoing approved project - this field defines remaining risk likelihood.

This field is required to be maintained if Scoring Methodology = Risk

This is a dropdown field from /SYQ/T_RISK_LKLHD

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

Impact of regulatory compliance on project delivery.

This field is required to be maintained if Scoring Methodology = Regulatory

This is a dropdown field from /SYQ/T_REG_MAGNITUDE

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

Probability of impact due to regulatory compliance.

This field is required to be maintained if Scoring Methodology = Regulatory

This is a dropdown field from /SYQ/T_REG_LKLHD

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

Regulatory defined deadline by which a project must commence.

This field is required to be maintained if Scoring Methodology = Regulatory

This is a dropdown field from /SYQ/T_REG_TIME_HORIZON

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

Stores the capitalization date for the purpose of "Depreciation forecast",

This date is mandatory for the Capital Projects Item types.  Item Types are  Z001,Z002, Z003, Z008, Z009, Z011

Preload Check to be done to confirm that this field is filled the Data Collection Template when required

Profit Centre represents the GBU/Plant where the project is performed., Profit centre on PPM item will be validated with the PC on the Parent Bucket to check they belong to the same group. This will ensure PPM items are created under correct GBU bucket.

Refer master table field CEPC-PRCTR for Profit center list. the Data Collection Template,  

It is a Required Field: Preload Check to be done to confirm that this field is filled, and is aligned with the PC on the Parent Bucket, first character of the Profit centers must match

This stores the WEGO project ID for reporting for R&I related projects in WEGO.

This is an optional field for migration

Used to group those PPM Items where the budget is drawn from the Budget provision Item.

Selection of existing Item Serial Numbers where the item type is Budget Provision

Field content to be verified in Preload check, field can contain only Item numbers of item type Budget Provision.

If IS or R&I PPM item is created with reference to a CRM Opportunity, the corresponding Opportunity ID will be entered.

This is an optional field.

This field represent Archetype of the R&I PPM item.

This is a dropdown field from /SYQ/T_ARCHETYPE

Preload Check to be done to confirm that this field is filled in the Data Collection Template when required.

This field provides input to the ranking of items in the prioritization dashboard. and is relevant across all PPM item types.

Legacy Project ID refers to the project identifier used in the previous SAP system before migration to the current S/4 HANA platform. It will be mandatory for the cutover projects only.

Preload Check to be done to confirm that this field is filled in the Data Collection Template when required.

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 in the Data Collection Template

Field to store the Idea number where this is known.

This is an optional field for migration

Use this checkbox if the project is eligible for government or institutional subsidies.

This is an optional field for migration

This field is used to provide a concise description of the Subsidy Relevance.  (This is a long text field)

Required If Subsidy field is selected.

Preload Check to be done to confirm that this field is filled in the Data Collection Template when required.

This field is used to provide key Assumptions related to projects.  (This is a long text field)

Conditional for Items where assumptions are to be maintained,

This is an optional field for migration

This field is used to provide details about key project variations.  (This is a long text field)

Conditional for Items where assumptions are to be maintained,

This is an optional field for migration

This field is used to provide additional details about project.  (This is a long text field)

This is an optional field for migration

Indicates the currently active Decision Point (Stage Gate) for the item.

To be selected if item is not initial phase

Drop down field from /RPM/ITEM_PHASE based on selected ITEM_TYPE

Instance where the item is to be loaded.

Unique Identifier Item serial numbers

It is a dropdown of the Item numbers maintained in the main DCT

Once the User selects the Item number the full list of Decision points relevant to the Item type is to be displayed.

System generated Parent ID of the Decision Point

This is a display only field

Name of the decision point, part of the customization and can't be changed.

This is a display only field

Unique Identifier Item serial numbers

It is a dropdown of the Item numbers maintained in the main DCT and marked as Need to Know.

Named user who should have read access to the Need to Know Item

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

Analyze 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

Global Default "SYENSQO"

Apply first successful rule

If PROJ-PSPID start with RR* then capture in DCT.

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

IF PROJ-ZINV = B4 Then Z011

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

Apply first successful rule only

If PROJ-PSPID start with R-then capture in DCT.

Investment Reason = H0 then Z009

IF PROJ-ZINV = B4 Then Z011

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

Copy from source, format YYYYMMDD

Value Mapping: Investment Reason

Based on the Category field

Value Mapping: Investment Reason

Based on the Category field

Value Mapping: Investment Reason

Based on the Category field

Copy from Source

If Legacy Project ID field is empty then

Value Mapping: Currency From Company Code
Company Code Currency from T001-WAERS where BUKRS = Target Geography

Value Mapping: Investment Reason

Based on the Category field

If CREATE_CPROJECT is active then field must be set.

Select PS_TEMPLATE from  /RPM/PSPTIT_MAP using ITEM_TYPE

If CREATE_CPROJECT is active then field must be set.

Select OBL_TYPE from  /RPM/PSPTIT_MAP using ITEM_TYPE

The List of decision points for each item is based on the item type as per 

Decision Point Name from RPM/PHASE_T using ITEM_TYPE and DECISION_ID

Decision point start status for preceding decision points /RPM/DP_STATUS-END_STATUS = X for ITEM_TYPE and PHASE_ID

Decision point start status for active decision point /RPM/DP_STATUS-START_STATUS = X for ITEM_TYPE and PHASE_ID 

Manually copy from Non ECC source

Manually copy from Non ECC source

Manually copy from Non ECC source

Manually copy from Non ECC source

Manually copy from Non ECC source

Default to activity "READ"

Manually copy from Non ECC source

Value Mapping: Position Name from Position

Value Mapping: Old Position ID  to New Position ID

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

 Generate post load report if step 5 is validated

Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off.

1073

Profit Centre

1019

Template Projects

Invalid Data

Invalid Portfolio

Validate DCT content

Invalid Data

Invalid Bucket ID (Parent ID does not exist)

Validate DCT content

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 Portfolio Item in target S/4 HANA were loaded correctly via Standard Portfolio Item display and table /RPM/ITEM_D

Conversion Accuracy

Verify that the Project Definition in target were created correctly as per project template using transaction CN41n

Conversion Accuracy

Verify that the WBS Structure  in target were created correctly as per project template using transaction CN41n

Extract Item details from Item App in S/4 Hana

Extract Project Definitions from Project Definitions App in S/4 Hana,  to be same as Item count