Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Purpose

The purpose of this document is to define the conversion approach to create Operative Project Definition (CAPEX, OPEX) in S/4 HANA.

Project Definition is the framework of the Work breakdown structure in SAP. Project Definition holds the default, header information such as Start and end date and scope of the Projects.

 As per Syensqo design below are the list of project scenarios.

CAPITAL/ Operational  Expense
Operational Expense
Statistical Expense
Intercompany Recharges
Provisional Expense

 As per Syensqo design below are the types of project.

Project TypeDescription
11Direct Asset Purchase
12Restructuring Provision
13Safety and Environment Provision
14IAS19 Provision
15Intercompany Recharge
16Capital Lease
17Industrial Projects
RINew Product Introduction
RIProduct & Process Improvement
RICustomer and business support
RIOPD Opportunity Development
18IT Project
19Turnaround Projects
20Contingency
21Variation
22Environmental Fines
23Social Fines
24Corruption Fines
25Waste
26Demolition - Recurring
27Demolition - Non -Recurring
28Marketing
29Budgeted Maintenance
30Continous Improvement
31Operational Performance improvement
32Site impact of Strikes
33Campaigns

Each SAP Project contain Project profile. Project profile contain default values and control parameters for processing objects and functions in the Project System.

Based on scenarios, PS Project can be automatically created from PPM item once stagegate 1 is approved or created manually independent of PPM. 

Below Project Profiles will be allowed for creation of Project definition directly without PPM item.
ZPS0003Statistical Expense
ZPS0004Intercompany Recharges
ZPS0005Provisional Expense
Applicable Project code as per design
Project IDDescription
ACoding Mask for Capital Projects
ECoding Mask for Internal/ Operational Projects
RCoding Mask for R&I Projects
TCoding Mask for Project Templates

Conversion Scope

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

Scope include:

  • Extracting existing active Project Definition (CAPEX, OPEX) from SAP ECC systems WP2 and PF2.
  • Applying transformation and cleansing logic via Syniti to conform with the S/4HANA data model.
  • Loading the transformed Project definition into SAP S/4HANA while ensuring data integrity, correct assignment to project profile as per project scenarios.

The conversion will ensure all projects are aligned to the defined project coding mask and relevant Organizational Units as designed for the target S/4HANA landscape.

 The data from legacy system includes:

All the projects below will be migrated from legacy source systems (PF2 and WP2) into S/4HANA –

  1. Active Capex / Opex Projects.

      2. 

The data from legacy system excludes:

  1. Old projects with no actuals or commitment
List of source systems and approximate number of records

In SAP PS, the project definition acts as a framework that provides a binding structure for organizational element of a project, such as Work Breakdown Structures. It serves as the top-level element for creating a project, defining default values for company code, plant, and responsible persons, and is essential for structuring, planning, and controlling all aspects of a project, from initiation to closure.


Conversion Scope

The scope of this document covers the approach for converting active Project Definition from Legacy Source Systems into S/4HANA following the Master Data Design Standard- Project Definition.

As per SyWay design, there are two ways to create an Operative Project definition based on the scenarios,

Scenario 1: PS Project definition with WBS element hierarchy (Level 1 & 2) can be automatically created from the approved PPM item once stage-gate 1 is approved. This process involves mapping the PPM item type to a predefined PS template project (created as per CVN-1019 Template Projects) with the Decision Flow Management settings in the SAP system. 

A project definition is automatically created for the specified PPM item types, using the corresponding project profile and applicable project coding mask. The conversion approach is defined  with in CNV-1022 Portfolio Item.

All project definition (new project profile ZPS0001, ZPS0002) relevant to PPM item type linking will be created from PPM items and is excluded from this conversion scope.

Scenario 2:  A project definition created manually independent of the PPM item, with the data being sourced using a DCT (Data Collection Template).

Conversion scope includes all projects that belong to Scenario 2, except statistical expense project. Statistical projects (with project profile ZPS0003 - Statistical Expense) are created as needed in S/4 Hana

Below project profiles are configured to allow the creation of a project definition directly in the Project System, without requiring integration with a Portfolio and Project Management (PPM) item. 

PS Project ProfilePRJIDPS Coding MaskDCT

ZPS0004 - Intercompany Recharges

F-000000-00-00-XX-XX-XXOne Project per CoCode 

ZPS0005 - Provisional Expense

F-000000-00-00-XX-XX-XXOne project per company code per GBU(profit centre)

The conversion will ensure all projects are aligned to the defined project coding mask and relevant Organizational Units as designed for the target S/4 Hana landscape. 

  

List of source systems and approximate number of records

SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

DCT

S/4 HanaTBD

Additional Information

Multi-language Requirement

Project definition, should be maintained in if available:

  - English (EN)
 - French (FR)
 - Italian (IT)
 - Chinese (ZN)

Document Management

Not Applicable

Legal Requirement

Not Applicable

Special Requirements

Not Applicable

Target Design

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirement
PROJPSPIDPS_PSPIDProject definitionCHAR24Mandatory
PROJPOST1PS_POST1DescriptionCHAR40Mandatory
PROJSTSPRPS_STSPRWBS status profileCHAR8System Generated
PROJVERNRPS_VERNRNo. of Person Resp.NUM8

Mandatory

PROJASTNRPS_ASTNRApplicant no.CHAR25

Mandatory

PROJVBUKRPS_VBUKRCompany codeCHAR4

Mandatory

PROJVKOKRPS_VKOKRControlling areaCHAR4

System Generated

PROJ


PRCTRPRCTRProfit CenterCHAR10

Mandatory

PROJPWHIEPS_PWHIEProject CurrencyCHAR5

System Generated

PROJPLFAZPS_PLFAZ_CHGStart dateDATS8

Mandatory

PROJPLSEZ

PS_PLSEZ_CHG

Finish dateDATS8

Conditional

PROJWERKSWERKS_DPlantCHAR4

Conditional

PROJ

KALIDFABKLFactory CalendarCHAR2

System Generated

PROJPROFLPROFIDPROJProject ProfileCHAR7

Mandatory

PROJBPROFBP_BPROFILBudget ProfileCHAR6

System Generated

PROJBESTAPS_BESTANDProject stockCHAR1

System Generated 

PROJ-XSTAT

PS_XSTAT

StatisticalCHAR1

Conditional

PROJPPROF

BP_PPROFIL

Planning ProfileCHAR6

System generated

PROJPLINTPLINTIntegrated PlanningCHAR1

System generated

PROJSLWIDSLWIDField keyCHAR7

System generated

PROJFUNC_AREAFKBERFunctional AreaCHAR16

Mandatory

PROJUSR00USRCHAR20Legacy Project IDCHAR20

Blank

PROJUSR01USRCHAR20Item TypeCHAR20

Blank

PROJUSR02USRCHAR10Need-to-knowCHAR10

Blank


Data Cleansing


IDCriticalityError Message/Report DescriptionRuleOutputSource System


C2

All active internal orders to be closed 


Report

WP2/PF2


list of internal order from AUFK, order category =select 01 with status = CRTD, REL, or Investment profile not blank (exclude status = CLSD), get OBJNR from AUFK, pass in COBRB, check for account assignment cat = WBS, CTR, ORD, GL. get list of all such internal order.


Conversion Process

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

Image Added

Data Privacy and Sensitivity

Not Applicable


Extraction

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

Ensure DCT is collected for Project Definition

Data Team (I2M), Data Team (Syniti)

2

Perform preliminary completeness check

Technical / Basis Team, Data Team (Syniti)

3

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

Data Team (Syniti)

4

Repeat Req # 1 to 3 if required)

Data Team (I2M), Data Team (Syniti)

Selection Screen

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



Data Collection Template (DCT)

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

DCT applicable to project created manually, with project profile, PROJ-PROFL

 -  Recharge Cost Collectors - Expense Project - Project profile ZPS0004
-  Provision Cost collectors - Expense Projects - Project Profile ZPS0005

Field NameField DescriptionRule
PSPIDProject definition

Unique Identifier for the project definition via coding mask starting with "F-000000".

1. Recharge Cost Collectors - Expense Project wth Project profile ZPS0004

2. Provision Cost collectors - Expense Projects with Project Profile ZPS0005

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

 POST1DescriptionShort description, Name of the Project
It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template
STSPRWBS status profile

Profile used to Control User Statuses. 

Automatically Inherited from the Project Profile. Change not allowed.

VERNRNo. of Person Resp.

Project Owner Position number Refer configuration table field TCJ04-PS_VERNR for data validation.
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. Refer configuration table field TCJ05-ASTNR for data validation.
It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template
VBUKRCompany code

Represents legal entity . Refer configuration table field T001-BURKS for data validation.

One project per company code per GBU(profit centre) for Provisional Project with profile ZPS0005

One project per company code for Recharge project with profile ZPS0004

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

PRCTRProfit Center

Profit Center represent a plant or a site or generic for GBU. Refer master data table field CEPC-PRCTR for allowed values.
One project per company code per GBU(profit centre) for Provisional Project with profile ZPS0005

PLFAZStart date

Planned Start date of the Project.

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

PLSEZFinish date

Planned finish date of the Project,

Conditional 

WERKSPlant

Plant represent a site of Project. Conditional 

PROFLProject Profile

The profiles contain default values and control parameters for processing objects and functions in the Project System.

Allowed Project Profiles for creation of Project definition:  
ZPS0004 - Recharge Projects
ZPS0005 - Provisional Projects

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

FUNC_AREAFunctional AreaRefer configuration table field TFKB-FKBER for allowed values."
It is a Required Field: Preload Check to be done to confirm that this is field in the Data Collection Template

Instance

Instance where the project definition is to be loaded.

(Field required in DCT)

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

Extraction Dependencies

Item #Step DescriptionTeam Responsible


Not Applicable

Data Team


Transformation

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
8Re-transform and re-validate the Pre-load reports if necessary.Data Team
9Validate the transformed file as part of pre-load validation, raise data defects or provide the pre-load sign-off.Business
10Analyze and resolve any pre-load defects logged by business.Data Team
11Repeat steps 7 to 10 if necessaryData Team
12Proceed to pre-load validationsData Team


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

DCT
PSPIDProject definitionS/4PROJ PSPIDProject ID

Mapping from source


DCT
USR00Legacy Project IDS/4PROJ USR00Legacy Project ID

Blank


DCT
USR01Item TypeS/4PROJ USR01Item Type

Blank


DCT
USR02Need-to-knowS/4PROJ USR02Need-to-know

Blank


DCT
 POST1DescriptionS/4PROJPOST1DescriptionCopy from source

DCT


S/4PROJSTSPRWBS status profileInherit from Project Profile

DCT
VERNRNo. of Person Resp.S/4PROJVERNRNo. of Person Resp.

Copy from source 



DCT
ASTNRApplicant no.S/4PROJASTNRApplicant no.Copy from source

DCT
VBUKRCompany codeS/4PROJVBUKRCompany codeMapping from source:  Company Code  Old to new

DCT


S/4PROJVKOKRControlling areaDefault from project profile

DCT
PRCTRProfit CenterS/4PROJPRCTRProfit CenterMapping from source:  Profit Center Old to new

DCT


S/4PROJPWHIEProject CurrencyMapping from Company Code

DCT
PLFAZStart dateS/4PROJPLFAZStart dateCopy from source

DCT
PLSEZFinish dateS/4PROJPLSEZFinish dateCopy from source

DCT


S/4PROJKALIDFactory CalendarMapping from Plant

DCT
PROFLProject ProfileS/4PROJPROFLProject ProfileCopy from source

DCT


S/4PROJBPROFBudget ProfileInherit from Project Profile

DCT


S/4PROJBESTAProject stockInherit from Project Profile

DCT


S/4PROJPPROFPlanning ProfileInherit from Project Profile

DCT


S/4PROJPLINTIntegrated PlanningInherit from Project Profile

DCT
FUNC_AREAFunctional AreaS/4PROJFUNC_AREAFunctional AreaCopy from source


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

The standard upload template to be used for Project Definition (Project Details template) upload in S/4 Hana.

Standard Upload template

Transformation Mapping


Mapping Table NameMapping Table Description
Company CodeValue Mapping: Old to New Company Code
T001Value Mapping: Currency From Company Code
PlantValue Mapping: Old Plant to New
Profit CenterValue Mapping:  Profit Center Old to New

Person Responsible /

Applicant

New Position to person name

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible

Ensure all the fields and values are imported into ADM Construction page correctlyData Team

Profit centers has been created (CEPC)


Pre-Load Validation

Project Team

Completeness

TaskAction
Generation of
Pre-load report
Check all the required fields

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. Project 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
1Controlling Area 
2Company Code 
3Factory Calendar
4Currency Code
5Project Profile
6Budget Profile
7Planning Profile
8Functional Area
9Profile for WBS scheduling
10Project Coding Mask
11Settlement Profile

Conversion Objects

Object #Preceding Object Conversion Approach
1073Profit Centre

Error Handling


Error TypeError DescriptionAction Taken
Invalid DataProject Definition already existCorrect upload data
Invalid DataNo. of Person Resp. does not existCorrect upload data
Invalid DataApplicant no. does not existCorrect upload data
Invalid DataProfit Centre does not exist Correct upload data
Invalid DataCompany Code does not existCorrect upload data
Invalid DataFunctional area does not existCorrect upload data
Invalid DataTwo projects per company code not allowed for project with project profile ZPS0004 - Intercompany RechargesCorrect 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
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2 and WP2

All Active Capex / Opex Projects, 

S/4HANA

Additional Information

Multi-language Requirement

Document Management

As per CNV-1025

Legal Requirement

Special Requirements

Target Design

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirementPROJPSPIDPS_PSPIDProject definitionCHAR24MandatoryPROJPOST1PS_POST1DescriptionCHAR40MandatoryPROJSTSPRPS_STSPRWBS status profileCHAR8System GeneratedPROJVERNRPS_VERNRNo. of Person Resp.NUM8

Mandatory

PROJASTNRPS_ASTNRApplicant no.CHAR25

Mandatory

PROJVBUKRPS_VBUKRCompany codeCHAR4

Mandatory

PROJVKOKRPS_VKOKRControlling areaCHAR4

Mandatory

PROJ

PRCTRPRCTRProfit CenterCHAR10

Mandatory

PROJPWHIEPS_PWHIEProject CurrencyCHAR5

Mandatory

PROJPLFAZPS_PLFAZ_CHGStart dateDATS8

Mandatory

PROJPLSEZ

PS_PLSEZ_CHG

Finish dateDATS8

Conditional

PROJWERKSWERKS_DPlantCHAR4

Conditional

PROJ

KALIDFABKLFactory CalendarCHAR2

System Generated

PROJPROFLPROFIDPROJProject ProfileCHAR7

Mandatory

PROJBPROFBP_BPROFILBudget ProfileCHAR6

Mandatory

PROJBESTAPS_BESTANDProject stockCHAR1

Mandatory

PROJ-XSTAT

PS_XSTAT

StatisticalCHAR1

Conditional

PROJPPROF

BP_PPROFIL

Planning ProfileCHAR6

System generated

PROJPLINTPLINTIntegrated PlanningCHAR1

Mandatory

PROJFUNC_AREAFKBERFunctional AreaCHAR16

Mandatory

PROJZLEGACYID?Legacy Project IDCHAR

Conditional

Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System

1024-001

C1

Active project in current year

 Active projects in needs to be reflected in SAP S/4

Active projects

WP2/PF2

1024-002

C2

Closed project that have cost in current year

WP2/PF2

1024-003

C3

Old projects with no actuals / commitment

If the old projects do not have any actual (and/or) commitments in the past year, set the project to status CLSD (CJ20N)

Old project set to closed

WP2/PF2

1024-004

C4

Project with AUC that created <= 2017 there's no movement in FY2023 - FY2024 and haven't been capitalized for long period

- Review AUC asset that there's no movement (changes) for the year 2023-2024

- Review Project with WBS that linked to the asset. If there's no further cost expected, TECO WBS

- Run settlement to capitalized AUC(CJ88)

Only genuine Project WBS with AUC is outstanding and no AUC not capitalized for closed/TECO Capex Project WBS

WP2/PF2

Conversion Process

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

Image Removed

Data Privacy and Sensitivity

Extraction

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

  1. The data exists. connects to the source and loads the data into . 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 ; 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 . This is to be conducted using DCT (Data Collection Template) in

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

1024-001

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

Data Team (I2M), Data Team (Syniti)

1024-002

Establish and validate Syniti connectivity to both ECC source systems

Technical / Basis Team, Data Team (Syniti)

1024-003

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

Data Team (Syniti)

1024-004

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

Data Team (I2M)

1024-005

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

Data Team (I2M), Data Team (Syniti)

1024-006

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)

1024-008

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

Data Team (I2M), Data Team (Syniti)

1024-009

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

Business / Functional Team

Selection Screen

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.

DCT Rules

Field NameField DescriptionRulePSPIDProject definitionUnique Identifier for the Project, system generated number.  In SyWay,  Projects which are created without PPM item will have Prefix, "F" denotes Operational Expense Projects.
Separate MDS for Project Templates. Ones created via PPM item will inherit its number from PPM item  POST1DescriptionShort description, Name of the Project
If Created via PPM Item, this field will be copied from PPM itemSTSPRWBS status profileProfile used to Control User Statuses. This will be derived from the configurationVERNRNo. of Person Resp.Project Owner Position number Refer configuration table field TCJ04-PS_VERNR for data validation.
Inherited if created Project is created via PPM item field Person Responsible Position IDASTNRApplicant no.This field represent the position of the Project Financial Controller. Refer configuration table field TCJ05-ASTNR for data validation.
Inherited if the project is created via PPM item field - Project Financial Controller Position ID.VBUKRCompany codeRepresents legal entity . Refer configuration table field T001-BURKS for data validation.
Inherited if created Project is created via PPM item field AreaVKOKRControlling areaControlling Area is a self-contained organizational unit used for internal cost accounting, Default from Project ProfilePRCTRProfit CenterProfit Center represent a plant or a site or generic for GBU. Refer master data table field CEPC-PRCTR for allowed values.
Inherited if Project is created via PPM item field Profit CentrePWHIEProject CurrencyCurrency of the Project derived from the Company codePLFAZStart datePlanned Start date of the Project. Inherited if created Project is created via PPM itemPLSEZFinish datePlanned finish date of the Project, Entered if known. Inherited if created Project is created via PPM itemWERKSPlantPlant represent a site of Project.  Not need for the groupwide expense projects
Inherited if created Project is created via PPM item field PlantKALIDFactory CalendarDerived from the Plant. Refer configuration table field TFACD-IDENT for allowed values.PROFLProject ProfileThe profiles contain default values and control parameters for processing objects and functions in the Project System. Below Project Profiles will be allowed for creation of Project definition directly without PPM item
ZPS0003
ZPS0004
ZPS0005
Inherited from Template if created Project is created via PPM itemBPROFBudget ProfileThe budget profile brings together the control parameters for budgeting Such as Time horizon, Currency Translation, availability control. This will be inherited from the Project profileBESTAProject stock

This field determines the behavior of the stock for Project. The Field will be automatically determined from Project Profile. Once set it cannot be changed.

No Project Stock will be used

XSTATStatisticalIndicator to specify whether a WBS element is only for statistical purposes or whether it may carry actual costs. Mandatory for Statistical Projects with Project profile ZPS0003PROFLPlanning ProfileProfile which control parameters for cost planning. This is derived from Project profilePLINTIntegrated PlanningThis indicator specifies whether an order/project participates in integrated planning or not. Derived from project profile. FUNC_AREAFunctional AreaFunctional Area will be maintained manually
Refer configuration table field TFKB-FKBER for allowed values."
Default from Template where applicableZLEGACYIDLegacy Project IDLegacy system Project ID, updated for migrated Projects Otherwise must be blank
Inherited if created Project is created via PPM item

Extraction Dependencies

Item #Step DescriptionTeam Responsible

Transformation

The Target fields are mapped to the applicable Legacy field that will be its source, this is a 3-way activity involving the Business, Functional team and Data team. This identifies the transformation activity required to allow 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
  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

Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic

Transformation Mapping

Mapping Table NameMapping Table Description

Transformation Dependencies

List the steps that need to occur before transformation can commenceItem #Step DescriptionTeam Responsible

Pre-Load Validation

Project Team

Completeness

TaskAction

Accuracy

TaskAction

Business

Completeness

TaskAction

Accuracy

TaskAction

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

Load Phase and Dependencies

Configuration

Item #Configuration Item

Conversion Objects

Object #Preceding Object Conversion Approachlist the exact title of the conversion object of only the immediate predecessor – this will then confirm the DDD (Data Dependency Diagram)

Error Handling

Error TypeError DescriptionAction Taken

Post-Load Validation

Project Team

Completeness

TaskAction

Accuracy

TaskAction

Business

Completeness

TaskAction

Accuracy

Action
Task


Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • Project Definition is in scope based on data design and any exception requested by business.
  • The DCT should validate the project 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

Change History
limit10