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

Compare with Current View Page History

« Previous Version 70 Next »

Purpose

The purpose of this document is to define the conversion approach to create the WBS - CAPEX, OPEX, Statistical in S/4 HANA.

In SAP, a WBS element (Work Breakdown Structure element) is a key component in project structure. WBS elements are organized hierarchically and facilitates planning, execution, and control.


Conversion Scope

The scope of this document covers the approach for converting applicable active WBS - CAPEX, OPEX, Statistical from Legacy Source Systems into S/4HANA following the WBS - CAPEX, OPEX, Statistical Master Data Design Standard.

The DCT will contain transformed data from source system for Capital and Budget Managed Operating PS Project Definitions in scope for migration, enrichment will be necessary to produce properly formatted data load sheets for S/4 HANA. 

Relevancy Criteria

The data from legacy system to be included in the initial extract includes:

    1. The data from legacy system includes:

        1. Capital projects (e.g. Industrial, Facility, IT and R&I) open as at migration date postings in the agreed migration time or has AUC balance.
        2. Budgeted Operating projects (e.g. Budgeted Maintenance, Marketing, Demolition projects) open as at migration date with postings in the agreed migration time
        3. Closed Capital Projects with postings within the agreed timeframe.
        4. Closed Budgeted Operational projects with postings within the agreed time frame. 
        5. Specifically also included are IT and R&I Projects (open as at migration date and (closed projects with postings the agreed timeframe) with postings postings in the agreed migration time

      The data from legacy system excludes

        1. Project Definition in out of scope Company Codes
        2. Project Definitions in out of scope Plants.
        3. Project which has deletion indicator set.
        4. Project marked as closed and not included in 3, 4 and 5 above
        5. Non Budgeted Maintenance Projects.

Additionally WBS elements without any initial extract will be created in the DCT only, this includes - 

  1. WBS elements with no reference to PPM items
    1. For the Provisions (One project per company code per GBU)
    2. Intercompany recharge (One Level 1 WBS per Company Code, Level 2 WBS per Trading Company Code)

List of source systems and approximate number of records


SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2Relevant WBS elements
S/4 HanaTBD
WP2Relevant WBS elements
S/4 HanaTBD
DCT

S/4 HanaTBD

Inter-company recharge WBS elements are replicated to other S/4 Hana instances as per business process, refer ERP-165 - Getting issue details... STATUS for development. 


Identification Logic

In principal any WBS element belonging

Capital project is a project that has any WBS elements with a Investment Profile. PRPS-IMPRF

Budgeted Opex is any other project that has any WBS elements with budget.  WBS has entry in BPGE for value type 41

IT Project is a project that has a WBS element one of the following criteria

  • in WP2 user field 1 starting with IT  PRPS-USR00
  • in PF2 user field 2 starts with IT    PRPS-USR01
  • has a WBS element Family is SBS IS or IT

R&I Project is a project meeting one of the following criteria, 

  •  in PF2 Project ID starts with R-   PROJ-PSPID
  • in WP2 Project ID starts with RR   PROJ-PSPID
  • has a WBS element with WEGO ID field filled  PRPS-ZZ_WEGO_ID
  • has a WBS element family indicated as R&I or R&I Others

Industrial projects 

  • Capital project is a project that has any WBS elements with a Investment Profile. PRPS-IMPRF
  • Budgeted Opex is any other project that has any WBS elements with budget.  WBS has entry in BPGE for value type 41
  • has a WBS element family indicated as GEC, Regular,RegAffairs, ING or Others

Facilities Projects

  • Capital project is a project that has any WBS elements with a Investment Profile. PRPS-IMPRF
  • Budgeted Opex is any other project that has any WBS elements with budget.  WBS has entry in BPGE for value type 41
  • has a WBS element family indicated as Facilities



Additional Information

Multi-language Requirement

The WBS element name is maintained in a single language only, no translation required.

Document Management

Not required.

Legal Requirement

Not applicable

Special Requirements

Not applicable


Target Design

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirement
PRPSPOSIDPS_POSIDWBS elementCHAR24Mandatory
PRPSPOST1PS_POST1DescriptionCHAR40Mandatory
PRPSVERNRPS_VERNRNo. of Person Resp.NUMC8Mandatory
PRPSASTNRPS_ASTNRApplicant no.NUMC8Mandatory
PRPSPBUKRPS_PBUKRCompany codeCHAR4

Mandatory

PRPSPKOKRPS_PKOKRControlling areaCHAR4

System Generated

PRPSPRCTRPRCTRProfit CenterCHAR10

Mandatory

PRPSPRARTPS_PRARTProject TypeCHAR2Mandatory
PRPSPLAKZPS_PLAKZPlanning ElementCHAR1System Generated
PRPSBELKZPS_BELKZAcct asst elem.CHAR1

Conditional

PRPSFAKKZPS_FAKKZBilling ElementCHAR1

Conditional

PRPSAKOKRPS_AKOKRCA req. cost centerCHAR4Mandatory
PRPSAKSTL

PS_AKSTL

Request. cost centerCHAR10Mandatory
PRPSABUKRPS_ABUKRRequesting co. codeCHAR4Mandatory
PRPSFKSTLPS_FKSTLResponsible CCCHAR10Mandatory
PRPSFKOKRPS_FKOKRCA resp. cost centerCHAR4Mandatory
PRPSFABKLFABKLFactory CalendarCHAR2System Generated
PRPSPWPOSPS_PWPOSCurrencyCUKY5System Generated
PRPSWERKSWERKS_DPlantCHAR4

Mandatory

PRPSSLWID
Field keyCHAR

System Generated

PRPSUSR08USR08Expected Capitalization DateDAT8

Conditional

PRPSUSR10USR10Cross SystemCHAR1

Conditional

PRPSSCOPESCOPE_CVObject classCHAR2

System Generated

PRPSXSTATPS_XSTATStatisticalCHAR1

Conditional

PRPSKOSTLPS_KOSTLCCtr posted actualCHAR10

Conditional

PRPSIMPRFIM_PROFILInvestment ProfileCHAR6

Conditional

PRPSFUNC_AREAFKBERFunctional AreaCHAR16

Mandatory

PRPSPSPHIPS_PSPIDProject DefinitionCHAR24Mandatory
PRPSSTUFEPS_STUFELevelCHAR3Mandatory
PRHIUPPS_PHIUPWBS_UPNUMC8

System Generated

PRHILEFTPS_PHILEWBS_LEFTNUMC8

System Generated

PRPSZX01
CAPEX/ OPEXCHAR10

Conditional

PRPSZX02
Maintenance event CHAR40

Conditional

PRPSZX03
Trading company codeCHAR4

Conditional


Data Cleansing

Some Data cleansing tasks are set out in CNV-1024 which deals with projects.


IDCriticalityError Message/Report DescriptionRuleOutputSource System

1

C3

Projects with no actuals / Commitment in agreed timeframe

If the projects do not have any actual or commitments in the past year, and is not used as account assignment on open maintenance orders then set the projects should have status CLSD (CJ20N)

Identifies Old project which can be  closed

WP2/PF2

2C2Open WBS elements, not relevant for migration, with assigned maintenance orders.

An open WBS element which does not fall  within the scope of migration (not a Capex Projects, IT Projects, R&I Projects and Budgeted OPEX project) and has assigned open maintenance orders.

Maintenance orders to be closed or after migration will have assignment and  settlement rules to cost centersWP2/PF2
3C1Open Projects where WBS Family is empty

An open project which falls in the scope of selection where the WBS Family cannot be determined.

Users to update the WBS Family field on open projects.WP2/PF2
4C3Projects with locked/on hold status

Open projects with active status as per selection criteria

Users to close projects based on existing project statusWP2/PF2

Open Projects without posting since selected financial year

Selection

Selection Option for Start Fiscal year.


Identify projects going to PPM, using the logic for WBS element relevancy, from prep report ZACTIVE_PROJECT_OPEN_CLOSED = OPEN

Returns projects with NO entries for WBS elements in tables COSS and COSP where fiscal year is greater or equal to selected fiscal year.


COSS-OBJNR = WBS element Object number and GJAHR greater or equal to selected fiscal year.  If any records returned then continue to next Project definitions.

COSP-OBJNR = WBS element Object number and GJAHR greater or equal to selected fiscal year.  If any records returned then continue to next Project definitions.


Output

Project Number (PROJ-PSPID)

Project Description (PROJ-POST1)

Company Code (PROJ-VBUKR)

Profit Center (PROJ-PRCTR)

Responsible Person (PROJ-VERNA)

Applicant (PROJ-ASTNA)

Global Business Unit (PROJ-ZZGBU)


Open WBS elements, not relevant for migration, with assigned maintenance orders

Selection

This is done for Open Projects Only which fall within the company codes relevant for migration

Identify projects not going to PPM, using the logic for WBS element relevancy, from prep report ZACTIVE = FALSE


For projects not going to PPM we determine open WBS elements not PPM relevant..

Select Orders from AUFK

Order Category = 30

Deletion Flag is Blank

Closed is Blank

PSPEL = Not PPM Relevant WBS elements


Output

Project Number (PROJ-PSPID)

Project Description (PROJ-POST1)

WBS Number (PRPS-POSID)

Profit Center (PROJ-PRCTR)

Order Number (AUFK-AUFNR)

Company Code (AUFK-BUKRS)

Plant (AUFK-WERKS)

Technical completion date (AUFK-DAT2)


Open Projects where WBS Family is empty

 Selection

This is done for Open Projects, where deletion flag is empty, which fall within the scope of migration but which does not have WBS Family 

For PF2 from PROJ-ZZFAMIL = ''

For WP2 From PRPS-Z_FAMIL = ''


Output

Project Number (PROJ-PSPID)

Project Description (PROJ-POST1)

Company Code (PROJ-VBUKR)

Profit Center (PROJ-PRCTR)

Responsible Person (PROJ-VERNA)

Applicant (PROJ-ASTNA)

Global Business Unit (PROJ-ZZGBU)

Investment Reason (PROJ-ZZ_IZWEK), display text from T087J


Open Projects with locked status

 Selection

Identify projects going to PPM, using the logic for WBS element relevancy, from prep report ZACTIVE_PROJECT_OPEN_CLOSED = OPEN with status locked, on hold, or user status locked.

Using project definition object number select from JEST-STAT = Master-data Locked I0065 OR Time Locked E0001 OR Commitment Locked E0002

 

Output

Project Number (PROJ-PSPID)

Project Description (PROJ-POST1)

Company Code (PROJ-VBUKR)

Profit Center (PROJ-PRCTR)

Responsible Person (PROJ-VERNA)

Applicant (PROJ-ASTNA)

Global Business Unit (PROJ-ZZGBU)

System Status (JEST-STAT) display text from TJ02T for statuses starting with I

User Status (JEST-STAT) display text from TJ30T-TXT30, where STSMA=ZPS00001 for statuses starting with E






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 (or cannot be converted from its current state).  The data is manually collected by the business directly in Syniti Migrate. This is to be conducted using DCT (Data Collection Template) in Syniti Migrate

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

1

Confirm scope and extraction approach for each ECC source systems WP2, PF2 (direct DB or manual extract)

Data Team (I2M), Data Team (Syniti)

2

Establish and validate Syniti connectivity to both ECC source systems

Technical / Basis Team, Data Team (Syniti)

3

Perform full data extraction from relevant SAP WBS elements from both source systems WP2, PF2

Data Team (Syniti)

4

Extract WBS via the application layer for additional validations for Manual Data Collection using DCTs

Data Team (I2M)

5

Apply agreed Relevancy Criteria to filter only applicable WBS records for S/4HANA

Data Team (I2M), Data Team (Syniti)

6

In case of restricted access or connectivity issues, receive pre-extracted reports/files from source system team and upload to Syniti Migrate manually

Data Team (I2M), Data Team (Syniti)

8

Perform data quality checks on extracted records (e.g., missing fields, invalid dates, incorrect formats)

Data Team (I2M), Data Team (Syniti)

9

Review and approve extracted data sample sets from each source system before transformation begins

Business / Functional Team

Selection Screen

Not applicable
Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





Data Collection Template (DCT)

Target Ready Data Collection Template will be created for data with exception of some fields which require transformation as mentioned in the transformation rule.

WBS - CAPEX, OPEX, Statistical Project Based DCT Rules:  Used for Provision and Recharge Projects

Link DCT to the DCT 1024 from Conversion specification https://wiki.syensqo.com/display/public/ER/CNV-1024+Project+Definition

Field NameField DescriptionRule
PSPHIProject Definition

Project ID assigned to the WBS elements. Refer table PROJ-PSPHI for allowed values. 

Dropdown values from DCT1024 - PSPHI

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

POSIDWBS element

Unique Identifier for the WBS Element, as per project coding mask F-000000-00-00-XX-XX-XX


Internal Information

Validation required, WBS Element ID must begin with the same Current Number for Project.

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

POST1Description

40 character description of the WBSE.

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

VERNRNo. of Person Resp.

This field represents the position of the Person Responsible for a WBS Element. It will be derived from the Project Definition and can be overwritten.

Dropdown values from TCJ04-PS_VERNR

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

ASTNRApplicant no.

This field represent the position of the Project Financial Controller. It will be derived from the Project Definition and can be overwritten.

Dropdown values from TCJ05-ASTNR.

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

PRCTRProfit Center

In Syway, Profit Center represent a plant or a site or generic for GBU. It will be derived from the Project Definition and can be overwritten.

Dropdown values from CEPC-PRCTR

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

PRARTProject Type

It is an attribute that serve as classification field that help to define the nature, purpose, and governance of a WBS element. They are useful for reporting, controlling, and compliance alignment.


Internal Information 

Dropdown values from TCJ1-PRART.

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

BELKZAcct asst elem.

Tooltip : This indicator enables financial posting on the WBS element.


Internal Information

It will be checked in below conditions-
2. For WBS elements governed by Operational, Statistical & Recharge project profiles, activation of this checkbox is mandatory for all level 2 WBS elements.

It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template where required and blank when not.

FAKKZBilling Element

Tooltip:  This indicator enables for revenue postings.  Required at level 2 for Intercompany Recharge projects

Internal Information

Only relevant for project profile of project maintained in  PSPHI is a Recharge Project

AKSTLRequest. cost center

The Requesting Cost Center that owns the asset.  Required only if the Requesting Cost Center is different to the Responsible Cost Center.

If filled the Requesting Cost center must be in same company code as the Responcible Cost Center. 

This Cost Centre is automatically copied to AUC.


Refer master data table field CSKS-KOSTL for allowed values.


A preload check is to be done to confirm that the Company Code of the Request. cost center is equal to the company code to the Company Code of the Responsible Cost Center's (FKSTL) Company Code.

FKSTLResponsible CC

Cost Center responsible for delivery of work.

Refer master data table field CSKS-KOSTL for allowed values.

It is a Required Field: Required for all account assigned WBS elements. Preload Check to be done to confirm that this is field in the Data Collection Template when required.

WERKSPlant

Plant represent a site of the WBS element. Mandatory for all WBS elements.

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

USR10Cross SystemThis checkbox field, will be selected when inter-company services are needed for a WBS element.
KOSTLCCtr posted actual

This field represents the receiver Cost Center of actual cost for financial posting on the statistical WBS element.

This field is optional and available only on statistical WBS elements

- WBS elements of project with Project Profile "ZPS0001" where Project Type is Capital Lease
- WBS elements of project with Project Profile "ZPS0003" i.e. Statistical Expense.

Dropdown values from KOSTL

FUNC_AREAFunctional AreaFunctional Area is an organisational unit used to classify expenses based on their purpose or function.
Dropdown values from TFKB-FKBER.
STUFELevelIn a project, WBS elements are structured across multiple levels to form a tree-like hierarchy for better project controlling and monitoring.
UPWBS_UP

This field represents the immediate superior WBS element required for establishing parent-child relationships in the WBS hierarchy, this is a required field for level 2 WBS elements. Can only be a WBS element within the same Project As per project coding mask F-000000-00-00-XX-XX-XX


Internal Information

Can only be a WBS element within the same project.

It is a Required Field for level 2 and lower: Preload Check to be done to confirm that this is field in the Data Collection Template when required.

LEFTWBS_LEFT

This field represents the left-adjacent WBS element in the same hierarchy level required for navigating sibling relationships within a WBS hierarchy. Can only be a WBS element within the same Project. As per project coding mask F-000000-00-00-XX-XX-XX

Internal Information

Can only be a WBS element within the same project.

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

ZX03Trading company code

Tooltip:  This field will be applicable when Project Type = Intercompany Recharge. Mandatory at Level 2 WBS to determine the trading company for intercompany recharges


Internal Information
Dropdown values from T001-BURKS.


WBS - CAPEX, OPEX, Statistical ECC Extracted Data DCT Rules: Where WBS elements have ECC source data

Field NameField DescriptionRule
PSPHIProject Definition

Project ID assigned to the WBS elements.


Internal Information

This is a display only field with legacy project ID from Preparation report

Refer table PROJ-PSPHI for allowed values. 

Dropdown values from PROJ-PSPHI 

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

POSIDWBS element

Unique Identifier for the WBS Element, as per project coding mask A-000000-00-00-XX-XX-XX


Internal Information

This is a display only field PRPS-POSID from Preparation report

Validation required, WBS Element ID must begin with the same Current Number for Project.


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

POST1Description

40 character description of the WBSE.


Internal Information

Display only field,  PRPS-POST1, description from Preparation report

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

VERNRNo. of Person Resp.

This field represents the position of the Person Responsible for a WBS Element. It will be derived from the Project Definition and can be overwritten.


Internal Information

Display only field,  the PRPS-VERNR responsible person from Preparation report

Dropdown values from TCJ04-PS_VERNR

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

ASTNRApplicant no.

This field represent the position of the Project Financial Controller. It will be derived from the Project Definition and can be overwritten.


Internal Information

Display only field from Legacy PRPS-ASTNR, applicant from Preparation report

Dropdown values from TCJ05-ASTNR.

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

PRCTRProfit Center

In Syway, Profit Center represent a plant or a site or generic for GBU. It will be derived from the Project Definition and can be overwritten.

Dropdown values from CEPC-PRCTR


Internal Information

Display only field from Legacy PRPS-PRCTR, applicant from Preparation report


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

LEG_IZWEKLegacy Investment Reason

Display only field to help user select the correct project type

Internal Information

Display only field to help user select the correct project typefrom Legacy PRPS-IZWEK, investment reason from Preparation report

Display key and text using T087J from ECC

LEG_PRARTLegacy Project Type

Display only field to help user select the correct project type

Internal Information

Display only field from Legacy PRPS-PRART, project type from Preparation report

Display key and text from TCJI from ECC


PRARTProject Type

It is an attribute that serve as classification field that help to define the nature, purpose, and governance of a WBS element. They are useful for reporting, controlling, and compliance alignment.
Dropdown values from TCJ1-PRART.


Internal Information

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

BELKZAcct asst elem.

This indicator enables financial posting on the WBS element.


Internal Information

Display only field from Legacy PRPS-BELKZ, account assignment from Preparation report.


It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template where required and blank when not.

FAKKZBilling Element

Only relevant for project profile of project maintained in  PSPHI is a Recharge Project

Internal Information

Display only field, value is always false.


AKSTLRequest. cost center

The Requesting Cost Center that owns the asset.  Required only if the Requesting Cost Center is different to the Responsible Cost Center.

If filled the Requesting Cost center must be in same company code as the Responcible Cost Center. 

This Cost Centre is automatically copied to AUC.


Internal Information

Display only field from Legacy PRPS-AKSTL, 

Refer master data table field CSKS-KOSTL for allowed values.


FKSTLResponsible CC

Cost Center responsible for delivery of work.

Refer master data table field CSKS-KOSTL for allowed values.


Internal Information

Display only field from Legacy PRPS-FKSTL,


 

It is a Required Field: Required for all account assigned WBS elements. Preload Check to be done to confirm that this is field in the Data Collection Template when required.

WERKSPlant

Plant represent a site of the WBS element. Mandatory for all WBS elements.


Internal Information

Display only field from Legacy PRPS-WERKS,


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



LEG_USR08


Legacy Date WBS date field

Display only field to help user select the correct Expected Captillzation Date


Internal Information

Display only field from Legacy PRPS-USR08/USR09

LEG_PLSEZ


Legacy Project End Date

Display only field to help user select the correct Expected Captillzation Date


Internal Information

Display only field from Legacy PRPS-USR08/USR09

USR08Expected Capitalization Date

Expected Capitalization date marks the anticipated execution of the AUC final settlement, restricted to WBS elements with Investment Profile.

Date Field.

Internal Information

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


USR10Cross SystemThis checkbox field, will be selected when inter-company services are needed for a WBS element.
KOSTLCCtr posted actual

This field represents the receiver Cost Center of actual cost for financial posting on the statistical WBS element.


This field is optional and available only statistical WBS elements

  • WBS elements of project with Project Profile "ZPS0001" where Project Type is Capital Lease
    - WBS elements of project with Project Profile "ZPS0003" i.e. Statistical Expense.

Internal Information

Display only field from PRPS-KOSTL


Dropdown values from KOSTL

IMPRFInvestment Profile

Investment Profile on WBS element is used to enable auto generation of AuC w.r.t. predefined asset class.

Applicable for CAPEX projects (with Project Profile ZPS0001) 
- at Level 3 WBS elements if the CAPEX field is selected and project type is not "Capital Spares"
- at level 2 WBS element if the CAPEX field is selected and project type is "Capital Spares"
Investment Profile can not be changed once WBS is settled.


Internal Information

Display only field from PRPS-IMPRF


Dropdown values from TAPRF-IVPRO for allowed values.

Preload validation required to ensure field is filled when required.

FUNC_AREAFunctional Area

Functional Area is an organisational unit used to classify expenses based on their purpose or function.


Internal Information

Preload validation required to ensure field is filled when required.

Dropdown values from TFKB-FKBER.

STUFELevel

In a project, WBS elements are structured across multiple levels to form a tree-like hierarchy for better project controlling and monitoring.

Internal Information

Display only level based on the PREP report


UPWBS_UP

Tooltip:This field represents the immediate superior WBS element required for establishing parent-child relationships in the WBS hierarchy, this is a required field for level 2 WBS elements. Can only be a WBS element within the same Project 


It is a Required Field for level 2 and lower: Preload Check to be done to confirm that this is field in the Data Collection Template when required.

Internal Information

Display only Parent based on the PREP report



LEFTWBS_LEFT

This field represents the left-adjacent WBS element in the same hierarchy level required for navigating sibling relationships within a WBS hierarchy. Can only be a WBS element within the same Project.


Internal Information

Display only Left from the PREP report

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

ZX01CAPEX / OPEX

This field identifies expense is CAPEX or OPEX.


Internal Information

Display only level based on the PREP report

Drop down field selection will allow any of CAPEX, OPEX or blank entry.

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

ZX02Maintenance event

This field is used to determine the settlement rule receiver for the relevant maintenance Work Order.

This field is used to determine the settlement rule receiver for the relevant maintenance Work Order. This field will be applicable for projects with Project Profile ZPS0001 & ZPS0002 at level 3 & 4 WBS element.


Internal Information

Data source for this field will be T352R-REVNR. 




WBS - CAPEX, OPEX, Statistical ECC Extracted Data DCT Rules: PPM relevant.  Used for Direct Asset Purchase, Capital Lease and Capital Spares

Field NameField DescriptionRule
PSPHIProject Definition

Project ID assigned to the WBS elements. Refer table PROJ-PSPHI for allowed values. 

Dropdown values from DCT1024 - PSPHI

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

POSIDWBS element

Unique Identifier for the WBS Element, as per project coding mask F-000000-00-00-XX-XX-XX


Internal Information

Validation required, WBS Element ID must begin with the same Current Number for Project.

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

POST1Description

40 character description of the WBSE.

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

VERNRNo. of Person Resp.

This field represents the position of the Person Responsible for a WBS Element. It will be derived from the Project Definition and can be overwritten.

Dropdown values from TCJ04-PS_VERNR

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

ASTNRApplicant no.

This field represent the position of the Project Financial Controller. It will be derived from the Project Definition and can be overwritten.

Dropdown values from TCJ05-ASTNR.

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

PRCTRProfit Center

In Syway, Profit Center represent a plant or a site or generic for GBU. It will be derived from the Project Definition


Internal Information

Display only read from related PPM Item Profit center field

Dropdown values from CEPC-PRCTR

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

PRARTProject Type

It is an attribute that serve as classification field that help to define the nature, purpose, and governance of a WBS element. They are useful for reporting, controlling, and compliance alignment.


Internal Information 

Dropdown values from TCJ1-PRART.

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

BELKZAcct asst elem.

Tooltip : This indicator enables financial posting on the WBS element.


Internal Information

It will be checked in below conditions-
2. For WBS elements governed by Operational, Statistical & Recharge project profiles, activation of this checkbox is mandatory for all level 2 WBS elements.

It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template where required and blank when not.

FAKKZBilling Element

Tooltip:  This indicator enables for revenue postings.  Required at level 2 for Intercompany Recharge projects

Internal Information

Only relevant for project profile of project maintained in  PSPHI is a Recharge Project

AKSTLRequest. cost center

Tooltip

Requesting Cost Center that owns the asset. The reqc CC must be in same company code as the resp CC. This CC is automatically copied to AUC.


Internal Information

Refer master data table field CSKS-KOSTL for allowed values.


A preload check is to be done to confirm that the Company Code of the Request. cost center is equal to the company code to the Company Code of the Responsible Cost Center's (FKSTL) Company Code.

FKSTLResponsible CC

Cost Center responsible for delivery of work.


Internal Information

Refer master data table field CSKS-KOSTL for allowed values.

It is a Required Field: Required for all account assigned WBS elements. Preload Check to be done to confirm that this is field in the Data Collection Template when required.

WERKSPlant

Plant represent a site of the WBS element. Mandatory for all WBS elements.


Internal Information

Display only read from related PPM Item plant field

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

USR10Cross SystemThis checkbox field, will be selected when inter-company services are needed for a WBS element.
KOSTLCCtr posted actual

Tooltip

This field represents the receiver Cost Center of actual cost for any actual financial posting on the statistical WBS element.
This field is relevant for WBS element with Project Type Capital Lease

Internal Information

Dropdown values from KOSTL

IMPRFInvestment Profile

Tooltip

Investment Profile on WBS element is used to enable auto generation of AuC w.r.t. predefined asset class.

- at level 2 WBS element if the CAPEX field is selected and project type is "Capital Spares"
Investment Profile can not be changed once WBS is settled.


Internal Information

Dropdown values from TAPRF-IVPRO for allowed values.

Preload validation required to ensure field is filled when required.

FUNC_AREAFunctional AreaFunctional Area is an organisational unit used to classify expenses based on their purpose or function.
Dropdown values from TFKB-FKBER.
STUFELevelIn a project, WBS elements are structured across multiple levels to form a tree-like hierarchy for better project controlling and monitoring.
UPWBS_UP

This field represents the immediate superior WBS element required for establishing parent-child relationships in the WBS hierarchy, this is a required field for level 2 WBS elements. Can only be a WBS element within the same Project As per project coding mask F-000000-00-00-XX-XX-XX


Internal Information

Can only be a WBS element within the same project.

It is a Required Field for level 2 and lower: Preload Check to be done to confirm that this is field in the Data Collection Template when required.

LEFTWBS_LEFT

This field represents the left-adjacent WBS element in the same hierarchy level required for navigating sibling relationships within a WBS hierarchy. Can only be a WBS element within the same Project. As per project coding mask F-000000-00-00-XX-XX-XX

Internal Information

Can only be a WBS element within the same project.

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

ZX01CAPEX / OPEX

This field identifies expense is CAPEX or OPEX.
For Direct Asset Purchase, Capital Lease and Capital Spares this indicator is mandatory at level 2 WBS elements.


Internal Information

Drop down field selection will allow any of CAPEX, OPEX or blank entry.


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

ZX02Maintenance event

This field is used to determine the settlement rule receiver for the relevant maintenance Work Order.

This field is used to determine the settlement rule receiver for the relevant maintenance Work Order. This field will be applicable for projects with Project Profile ZPS0001 & ZPS0002 at level 3 & 4 WBS element.


Internal Information

Data source for this field will be T352R-REVNR. 





In conjunction with DCT business user will be provided with Person Responsible / Applicant list for reference.


Extraction Dependencies

Item #Step DescriptionTeam Responsible


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

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


Transformation Rules


Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1PF2/WP2PRPSPOSIDWBS elementS/4 HanaPRPSPOSIDWBS elementFor sourceWBS element numbering is based on the rules set out in section Parent/Number/Level  Determination  below.
2DCTPRPSPOSIDWBS elementS/4 HanaPRPSPOSIDWBS elementManually copy from Non ECC source
3PF2/WP2PRPSPOST1DescriptionS/4 HanaPRPSPOST1DescriptionCopy from source to target system
4DCTPRPSPOST1DescriptionS/4 HanaPRPSPOST1DescriptionManually copy from Non ECC source
5PF2/WP2PRPSVERNRNo. of Person Resp.S/4 HanaPRPSVERNRNo. of Person Resp.Value Mapping: Responsible Person to new Person Responsible Position ID
6DCTPRPSVERNRNo. of Person Resp.S/4 HanaPRPSVERNRNo. of Person Resp.Manually copy from Non ECC source
7PF2/WP2PRPSASTNRApplicant no.S/4 HanaPRPSASTNRApplicant no.Value Mapping: Applicant to new Applicant Position ID
8DCTPRPSASTNRApplicant no.S/4 HanaPRPSASTNRApplicant no.Manually copy from Non ECC source
9PF2/WP2PRPSPBUKRCompany codeS/4 HanaPRPSPBUKRCompany codeValue Mapping: Old to New Company Code
10DCT


S/4 HanaPRPSPBUKRCompany codeIf Source of WBS is construct then Copy from Project Definition using target PSPHI
11All


S/4 HanaPRPSPKOKRControlling areaDefault to "CO01"
12PF2/WP2PRPSPRCTRProfit CenterS/4 HanaPRPSPRCTRProfit CenterValue Mapping:  Old to New Profit Centre
13DCTPRPSPRCTRProfit CenterS/4 HanaPRPSPRCTRProfit CenterManually copy from Non ECC source
14ALLPRPSPRARTProject TypeS/4 HanaPRPSPRARTProject TypeManually copy from Non ECC source
15PF2/WP2PRPSBELKZAcct asst elem.S/4 HanaPRPSBELKZAcct asst elem.Copy from source to target system
16DCTPRPSBELKZAcct asst elem.S/4 HanaPRPSBELKZAcct asst elem.Manually copy from Non ECC source
17AllPRPSFAKKZBilling ElementS/4 HanaPRPSFAKKZBilling ElementManually copy from Non ECC source

All


S/4 HanaPRPSAKOKRCA req. cost centerDefault to "CO01"

PF2/WP2PRPSAKSTLRequest. cost centerS/4 HanaPRPSAKSTLRequest. cost centerValue Mapping:  Old to New Cost Centre

DCTPRPSAKSTLRequest. cost centerS/4 HanaPRPSAKSTLRequest. cost center

Manually copy from Non ECC source

If Blank then Copy from FKSTL


ALL


S/4 HanaPRPSABUKRRequesting co. codeDefault from Cost Center using AKSTL
18PF2/WP2PRPSFKSTLResponsible CCS/4 HanaPRPSFKSTLResponsible CCValue Mapping:  Old to New Cost Centre
19DCTPRPSFKSTLResponsible CCS/4 HanaPRPSFKSTLResponsible CCManually copy from Non ECC source
20All


S/4 HanaPRPSFKOKRCA resp. cost centerDefault to "CO01"
21All


S/4 HanaPRPSFABKLFactory CalendarCopy Factory Calendar from Plant using Field WERKS
22PF2/WP2PRPSPWPOSCurrencyS/4 HanaPRPSPWPOSCurrencyCopy from Project Definition
23DCT


S/4 HanaPRPSPWPOSCurrencyCopy from Project Definition
24PF2/WP2PRPSWERKSPlantS/4 HanaPRPSWERKSPlantValue Mapping:  Old to New Plant
25DCTPRPSWERKSPlantS/4 HanaPRPSWERKSPlantManually copy from Non ECC source
26ALLPRPSUSR08Expected Capitalization DateS/4 HanaPRPSUSR08Expected Capitalization DateManually copy from Non ECC source
27ALLPRPSUSR10Cross SystemS/4 HanaPRPSUSR10Cross SystemManually copy from Non ECC source
28ALL


S/4 HanaPRPSSCOPEObject classCopy from Project Definition
29ALL


S/4 HanaPRPSXSTATStatistical

Set to X for WBS Elements of Project Profile ZPS0003

Set to X for WBS elements with Project Type 16

30DCTPRPSKOSTLCCtr posted actualS/4 HanaPRPSKOSTLCCtr posted actualManually copy from Non ECC source
31PF2/WP2PRPSIMPRFInvestment ProfileS/4 HanaPRPSIMPRFInvestment ProfileValue Mapping: Old to new Investment Profile
32DCTPRPSIMPRFInvestment ProfileS/4 HanaPRPSIMPRFInvestment ProfileManually copy from Non ECC source
33PF2/WP2


S/4 HanaPRPSFUNC_AREAFunctional AreaCopy from Project Definition PROJ-FUNC_AREA
34DCTPRPSFUNC_AREAFunctional AreaS/4 HanaPRPSFUNC_AREAFunctional AreaManually copy from Non ECC source
35PF2/WP2PRPSPSPHIProject DefinitionS/4 HanaPRPSPSPHIProject DefinitionNew Project definition is determined by selecting PSPID from PROJ -  USR00 for source PSPHI
36DCTPRPSPSPHIProject DefinitionS/4 HanaPRPSPSPHIProject DefinitionManually copy from Non ECC source
37ALLPRPSSTUFELevelS/4 HanaPRPSSTUFELevelManually copy from Non ECC source
38ALLPRPSUPWBS_UPS/4 HanaPRPSPRHI-UPWBS_UPManually copy from Non ECC source
39ALLPRPSLEFTWBS_LEFTS/4 HanaPRPSPRHI-LEFTWBS_LEFTManually copy from Non ECC source
40ALLPRPSZX01Capex / OPEXS/4 HanaPRPSZX01CAPEX/ OPEXManually copy from Non ECC source
41ALLPRPSZX02Maintenance event S/4 HanaPRPSZX02Maintenance event Manually copy from Non ECC source
42ALLPRPSZX03Trading company codeS/4 HanaPRPSZX03Trading company codeManually copy from Non ECC source

List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.


The following does not apply to WBS elements created directly in the DCT.

  • The transformation of WBS element structure from the legacy systems is changed from a multi-level structure to a formal phase based approach with adherence to pre-approved project structures across all project types.


  • To facilitate this only WBS elements flagged account assignment from PF2/WP2 will be created and assigned to the project structures in S/4 which has already created during PPM item creation (CNV-1022), (relevancy criteria for migration is the same), while a mapping of all WBS elements, including non-account assignment objects will be provided.   


The following is executed for WBS elements across a single project at a time.

Parent/Number/Level Determination

1. Target Structure, use mapping table between Item type and Project template to use as basis for the maintenance of the project strucutre.

1.1. Level 3 WBS elements to be assigned to the WBS element from the mapping table

1.1.1 Source AUC - From source system select all WBS elements for the project Investment Profiles 

Loop by Source AUC  WBS element assigning if count is >0

TARGET - PRHI-UP = PARENT from 1 above.

Target - PSPNR = Parent PSPNR + .01 (incrementing by .01 for each subsequent WBS element (such that first would be A.0000001.01 second A.0000001.02 and so forth)

TARGET - PRPH-LEFT = Empty for first WBS at level, after that, previous WBS at same level 

Target - STUFE = PARENT STUFE +1.

Target - CAPEX / OPEX = CAPEX


 Lower Levels  -  For each SOURCE AUC  see if any lower level WBS elements with account assignment active and Settlement receiver object is a WBS element in subsequent levels taking note that the relationship may be more than level lower.  This is done using PSHI where SOURCE AUC WBS element is maintained in up.

Loop by Source CHILD  WBS element assigning 

TARGET - PRPH-UP = TARGET from 1.1 above.

TARGET - PSPNR = PRPNR from 1.1.2 above + .01 (incrementing by .01 for each subsequent WBS element (such that first would be A.0000001.01.01 second A.0000001.01.02 and so forth)

TARGET - PRPH-LEFT = Empty for first WBS at level, after that, previous WBS at same level 

TARGET - STUFE= PARENT STUFE +1.



1.1.2   Source Opex - Any WBS elements which have not been assigned to the structure is now assigned to PARENT WBS from 1.1  This takes care of situations where there is no Capital settlements in the parent child relationships but where postings exist.

Loop at SOURCE OPEX WBS element - assigning 

TARGET - PRHI-UP = PARENT from 1 above.

Target - PSPNR = Parent PSPNR + .01 (increments continue )

TARGET - STUFE= PARENT STUFE +1.

Target - CAPEX / OPEX = OPEX


Transformation Mapping


Mapping Table NameMapping Table Description
T001Value Mapping: Currency From Company Code
Company CodeValue Mapping: BUKRS: Old Company Code to New Company Code
Controlling AreaValue Mapping:  Old to New Controlling Area
Cost CentreValue Mapping:  Old to New Cost Centre
PlantValue Mapping:  Old Plant to New Plant
Profit CenterValue Mapping:  Old to New Profit Centre
ApplicantValue Mapping: Applicant to new Applicant Position ID
Person ResponsibleValue Mapping Responsible Person to new Person Responsible Position ID
Investment ProfileValue Mapping: Investment Profile Old to New

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. Mapping tables, have the correct values mapped and imported into tool.Syway Data Team
2Person Responsible and Applicant Position ID interface has been executedSyway Data Team


Pre-Load Validation

Project Team



Completeness

TaskAction

Verify Record Count

SyWay I2M Data Team 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.

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
  5. WBS Ids aligned with different number ranges per instance.

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.

Business

Completeness

TaskAction

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

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


Load

The load process includes:

  1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
  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

1

Load using transaction CNMASSCREATE or Migration cockpit

Data Team

2

Load 3 records for < > to validate if data is loaded successfully without errors

Data Team

3

Load 3 records for < > to validate if data is loaded successfully without errors

Data Team

4

Proceed with full load if steps 2 and 3 are validated

Data Team

5

Validate few records loaded by accessing CN41N report

Data Team

6

Generate post load report if step 5 is validated

Data Team

Load Phase and Dependencies

Configuration


Item #Configuration Item
1Project Coding Mask
2Company Code
3Controlling Area
4Project Type
5Factory Calendar
6Currency Code
7Plant
8Investment Profile
9Functional Area
10Define Tolerance Limits
11WBS Status Profile
12Settlement Profile
13Budget Profile
14Project Profile
15Validations and Substitutions

Conversion Objects

Object #Preceding Object Conversion Approach
1022Portfolio Item
1024Project Definition
1074Cost Center

Error Handling


Error TypeError DescriptionAction Taken
Invalid DataProject Definition does not existCorrect upload data, review load of CNV-1024 
Invalid DataWBS Element already existCorrect upload data.
Invalid DataPerson Responsible does not existCorrect upload data
Invalid DataApplicant does not existCorrect upload data
Duplicate RecordsMore than one WBS element per Provision type per company code/plant based on project typeRemove Duplicate values from DCT
Duplicate RecordsTrading partner is filled and appears more than once per Recharge ProjectRemove Duplicate values from DCT
System ValidationAll standard WBS element validations to be adhered toCorrect upload data


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 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 table PROJ 

Business

Completeness

TaskAction
Verify template Project data - Project Definition Extract data from PS report CN41N in S/4 Hana

Accuracy

TaskAction
Verify template Project data - Project Definition Extract data from PS report CN41N in S/4 Hana


Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • WBS - CAPEX, OPEX, Statistical is in scope based on data design and any exception requested by business.
  • The DCT should validate the project WBS coding mask numbering as per the SAP instance config.
  • Validation / substitution might required to switched off at the time of load.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 70) Apr 23, 2026 11:34 KOHN-ext, Jacob
v. 88 Apr 23, 2026 11:07 KOHN-ext, Jacob
v. 87 Apr 23, 2026 06:13 KOHN-ext, Jacob
v. 86 Apr 22, 2026 13:02 KOHN-ext, Jacob
v. 85 Apr 22, 2026 10:39 KOHN-ext, Jacob
v. 84 Apr 22, 2026 09:35 KOHN-ext, Jacob
v. 83 Apr 22, 2026 09:26 KOHN-ext, Jacob
v. 82 Apr 21, 2026 12:52 KOHN-ext, Jacob
v. 81 Mar 11, 2026 12:05 KOHN-ext, Jacob
v. 80 Mar 11, 2026 11:55 KOHN-ext, Jacob

Go to Page History

  • No labels