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

Compare with Current View Page History

« Previous Version 14 Next »

Status

60%

OwnerSoumen Laru
Stakeholders

Purpose

The purpose of this document is to define the conversion approach of Profit Centres into S/4 HANA.  

The document details out the field list, extraction criteria, scoping, mapping of Profit Centre object.

Profit Centres will be constructed based on the target design and a DCT(Constructed data based on Data Collection Template) will be provided to Syniti for subsequent processing. Along with the DCT, a mapping file of legacy(ECC) to target(S4) will be provided for dependent master and transaction objects.

Conversion Scope

Profit Centres which will be listed as part of scope list with new numbering will be in scope of migration. 


List of source systems and approximate number of records 
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2Profit Centre6,423S4HANA
WP2Profit Centre5,768S4HANA

Additional Information

Multi-language Requirement

In the Syensqo Profit Centres, the following four language keys must be maintained:
 - English (EN)
 - French (FR)
 - Italian (IT)
 - Chinese (ZN)
Note: For certain countries it may be required to also maintain account descriptions for certain Profit Centres in local language as per regulatory requirement (e.g. Japanese) in the respective country. Such requests must be backed by supporting evidence of the underlying regulatory requirement.
Such data will be collected as part of DCT for the translation texts for Profit Centres.

Document Management

Legal Requirement

Special Requirements




Target Design

The technical design of the target for this conversion approach. 

TableFieldData Element Field LabelData TypeLengthRequirementSyensqo Requirement

R = Required : Mandatory field.
O = Optional: Not mandatory. If a value is entered it doesn't impact Business Process.
C = Conditional: Not mandatory. If a value is entered it impacts Business Process or Reporting.
S = System: System generates the value.
NU = Not Used
CEPCPRCTRPRCTRProfit CenterCHAR10Organizational unit in controlling used for internal reporting and responsibility accounting.
The Profit center represents in syensqo context either a Plant or a GBS 'non Plant'.

The Syensqo PC codification must follow the naming convention.  "1 + 4 ""
 Digit #1  = GBU Indicator
S=SPEC. POLYMERS or C=COMPOSITE MATERIALS or  N=NOVECARE or  T=TECHNOLOGY SOLUTIONS or  B=CBS

From digit 2 to 5  :  4 char.
Company Code OR Plant Code.  

Illustration : S1001
R
CEPCDATBIDATBIValid To DateDATS8Date until which the Profit Center is valid.R
CEPCKOKRSKOKRSControlling AreaCHAR4Identifies a self-contained organizational structure for which costs and revenues can be managed.

Only 1 controlling used for all legal entities. Same value across all systems (same in 3 boxes : Global instance + Composites + China).
R
CEPCDATABDATABValid-From DateDATS8Date from which the Profit Center is valid.R
CEPCVERAKVERAPCPerson Responsible for Profit CenterCHAR20Name or ID of the person responsible for managing the Profit Center.R
CEPCVERAK_USERVERAPC_USERUser Responsible for the Profit CenterCHAR12SAP user ID of the responsible person.C
CEPCWAERSWAERSCurrency KeyCUKY5Currency used in the Profit Center.
Will follow the legal entity one. 
R
CEPCLAND1LAND1Country KeyCHAR3Country code related to the Profit Center's location.O
CEPCNAME1NAME1_GPName 1CHAR35First line of the name or company name of the Profit Center.
Description of the Profit center. 
R
CEPCNAME2NAME2_GPName 2CHAR35Second line of the name or company name.O
CEPCNAME3NAME3_GPName 3CHAR35Third line of the name or additional details.O
CEPCNAME4NAME4_GPName 4CHAR35Fourth line of the name or additional details.O
CEPCORT01ORT01_GPCityCHAR35City name in the Profit Center address.O
CEPCORT02ORT02_GPDistrictCHAR35District or region in the address.O
CEPCSTRASSTRAS_GPStreet and House NumberCHAR35Street name and house number of the Profit Center location.O
CEPCPFACHPFACHPO BoxCHAR10PO Box address.O
CEPCPSTLZPSTLZPostal CodeCHAR10Postal code for the street address.O
CEPCPSTL2PSTL2P.O. Box Postal CodeCHAR10Postal code associated with the PO Box.O
CEPCSPRASSPRASLanguage KeyLANG1Language key used in texts and descriptions.O
CEPCTELBXTELBXTelebox numberCHAR15Telebox number (rarely used).O
CEPCTELF1TELF1First telephone numberCHAR16Primary contact phone number.O
CEPCTELF2TELF2Second telephone numberCHAR16Secondary contact phone number.O
CEPCTELFXTELFXFax NumberCHAR31Fax number.O
CEPCTELTXTELTXTeletex numberCHAR30Teletex number (obsolete).O
CEPCTELX1TELX1Telex numberCHAR30Telex number (obsolete).O
CEPCBUKRSBUKRSCompany CodeCHAR4Associated company code for reporting.O
CEPCTXJCDTXJCDTax JurisdictionCHAR15Tax jurisdiction code used for tax reporting.C
CEPCREGIOREGIORegion (State, Province, County)CHAR3State or regional subdivision (used in address).O
CEPCLOCK_INDLOCK_INDLock indicatorCHAR1Indicates if the Profit Center is locked for processing.
If locked : no posting possible.
C
CEPCPCA_TEMPLATEPCA_TEMPLATETemplate for Formula Planning in Profit CentersCHAR10Reference template used for planning purposes in Profit Centers.C
CEPCTKTEXTKTEXTName#N/A20Profit Center NameR
CEPCTLTEXTLTEXT Long Text#N/A40Profit Center Long TextR
CEPCTMCTXTMCTXTProfit Center Text#N/A20Profit Center TextO


Data Cleansing


ID

Criticality


Error Message/Report Description

Rule

Output

Source System

1.      

Can load, but business process will fail

Lock any Profit Centre not being used for last 5 years

TBD

Report


PF2 / WP2

Note: Cleansing mau not be necessary as the ex

Conversion Process 

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

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 description

Team responsible

1.      

Ensure source tables CEPC and CEPCT are extracted in tool according to the agreed cut-off date in the project plan

Ensure DCT is collected for the Profit Centres based on the collection template

Data team

2.      

Perform preliminary completeness check documented in section 5.2.8.1.1

Data team

3.      

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

Data team

4.      

Repeat Req # 1 to 3 if required

Data team

5.      

Report extraction result to person in charge of APOI conversion

Data 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 descriptionRule
CEPC-PRCTRProfit Centre
CEPC-DATBIValid To Date
CEPC-KOKRSControlling Area
CEPC-DATABValid-From Date
CEPC-VERAKPerson Responsible for Profit Center
CEPC-VERAK_USERUser Responsible for the Profit Center
CEPC-WAERSCurrency Key
CEPC-LAND1Country Key
CEPC-NAME1Name 1
CEPC-NAME2Name 2
CEPC-NAME3Name 3
CEPC-NAME4Name 4
CEPC-ORT01City
CEPC-ORT02District
CEPC-STRASStreet and House Number
CEPC-PFACHPO Box
CEPC-PSTLZPostal Code
CEPC-PSTL2P.O. Box Postal Code
CEPC-SPRASLanguage Key
CEPC-TELBXTelebox number
CEPC-TELF1First telephone number
CEPC-TELF2Second telephone number
CEPC-TELFXFax Number
CEPC-TELTXTeletex number
CEPC-TELX1Telex number
CEPC-BUKRSCompany Code
CEPC-TXJCDTax Jurisdiction
CEPC-REGIORegion (State, Province, County)
CEPC-LOCK_INDLock indicator
CEPC-PCA_TEMPLATETemplate for Formula Planning in Profit Centers
CEPCT-KTEXTName
CEPCT-LTEXT Long Text
CEPCT-MCTXTProfit Center Text


Suggestion to add:

Decimal validation - Check table TCURX for the document currency key and if Decimals (TCURX-CURRDEC) is ‘0’, validate that no decimal value is populated.


Extraction Dependencies


Item #

Step description

Team responsible

1.      

Any period / year end close activities have been fully completed

Business

2.      

Reconciliation for intercompany payables have been completed, and adjustment made in legacy SAP system

Business

3.      

Reconciliation of migrated Purchase Order is completed before the extraction of Accounts Payable Open Items

Business and Data



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 description

Team responsible

1.      

Ensure all the fields that require value mapping, as stipulated  Mapping tables, have the latest signed-off mapping files imported into toolMigrate.

Data team

2.      

In tool, select the Trial Balance object PY.

Data team

3.      

Go to Process Area Launch and Process the Object - Trial Balance object - R4 Trial Balance PY.

Data team

4.      

Launch the Objects to execute transformation.

Data team

5.      

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

Data team

6.      

Generate Pre-Load reports .

Data team

7.      

Generate data load count.

Data team

8.      

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

Data team

9.      

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

Data team

10.   

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

Business

11.   

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

Data team

12.   

Repeat steps 6 to 11 if necessary

Data team

13.   

Proceed to pre-load validations

Data team

Transformation Rules


Rule #Source systemSource TableSource FieldSource descriptionTarget systemTarget TableTarget FieldTarget descriptionTransformation logic
1DCT/ECCCEPCPRCTRProfit CenterS/4HANACEPCPRCTRProfit CenterCopy From DCT as-is
2DCT/ECCCEPCDATBIValid To DateS/4HANACEPCDATBIValid To DateCopy From DCT as-is
3DCT/ECCCEPCKOKRSControlling AreaS/4HANACEPCKOKRSControlling AreaCopy From DCT as-is
4DCT/ECCCEPCDATABValid-From DateS/4HANACEPCDATABValid-From DateCopy From DCT as-is
5DCT/ECCCEPCVERAKPerson Responsible for Profit CenterS/4HANACEPCVERAKPerson Responsible for Profit CenterApply Mapping of Employee 
6DCT/ECCCEPCVERAK_USERUser Responsible for the Profit CenterS/4HANACEPCVERAK_USERUser Responsible for the Profit CenterCopy From DCT as-is
7DCT/ECCCEPCWAERSCurrency KeyS/4HANACEPCWAERSCurrency KeyCopy From DCT as-is
8DCT/ECCCEPCLAND1Country KeyS/4HANACEPCLAND1Country KeyCopy From DCT as-is
9DCT/ECCCEPCNAME1Name 1S/4HANACEPCNAME1Name 1Copy From DCT as-is
10DCT/ECCCEPCNAME2Name 2S/4HANACEPCNAME2Name 2Copy From DCT as-is
11DCT/ECCCEPCNAME3Name 3S/4HANACEPCNAME3Name 3Copy From DCT as-is
12DCT/ECCCEPCNAME4Name 4S/4HANACEPCNAME4Name 4Copy From DCT as-is
13DCT/ECCCEPCORT01CityS/4HANACEPCORT01CityCopy From DCT as-is
14DCT/ECCCEPCORT02DistrictS/4HANACEPCORT02DistrictCopy From DCT as-is
15DCT/ECCCEPCSTRASStreet and House NumberS/4HANACEPCSTRASStreet and House NumberCopy From DCT as-is
16DCT/ECCCEPCPFACHPO BoxS/4HANACEPCPFACHPO BoxCopy From DCT as-is
17DCT/ECCCEPCPSTLZPostal CodeS/4HANACEPCPSTLZPostal CodeCopy From DCT as-is
18DCT/ECCCEPCPSTL2P.O. Box Postal CodeS/4HANACEPCPSTL2P.O. Box Postal CodeCopy From DCT as-is
19DCT/ECCCEPCSPRASLanguage KeyS/4HANACEPCSPRASLanguage KeyCopy From DCT as-is
20DCT/ECCCEPCTELBXTelebox numberS/4HANACEPCTELBXTelebox numberCopy From DCT as-is
21DCT/ECCCEPCTELF1First telephone numberS/4HANACEPCTELF1First telephone numberCopy From DCT as-is
22DCT/ECCCEPCTELF2Second telephone numberS/4HANACEPCTELF2Second telephone numberCopy From DCT as-is
23DCT/ECCCEPCTELFXFax NumberS/4HANACEPCTELFXFax NumberCopy From DCT as-is
24DCT/ECCCEPCTELTXTeletex numberS/4HANACEPCTELTXTeletex numberCopy From DCT as-is
25DCT/ECCCEPCTELX1Telex numberS/4HANACEPCTELX1Telex numberCopy From DCT as-is
26DCT/ECCCEPCBUKRSCompany CodeS/4HANACEPCBUKRSCompany CodeCompany Code Mapping File to be used 
27DCT/ECCCEPCTXJCDTax JurisdictionS/4HANACEPCTXJCDTax JurisdictionCopy From DCT as-is
28DCT/ECCCEPCREGIORegion (State, Province, County)S/4HANACEPCREGIORegion (State, Province, County)Copy From DCT as-is
29DCT/ECCCEPCLOCK_INDLock indicatorS/4HANACEPCLOCK_INDLock indicatorCopy From DCT as-is
30DCT/ECCCEPCPCA_TEMPLATETemplate for Formula Planning in Profit CentersS/4HANACEPCPCA_TEMPLATETemplate for Formula Planning in Profit CentersCopy From DCT as-is
31DCT/ECCCEPCTKTEXTNameS/4HANACEPCTKTEXTNameCopy From DCT as-is
32DCT/ECCCEPCTLTEXT Long TextS/4HANACEPCTLTEXT Long TextCopy From DCT as-is
33DCT/ECCCEPCTMCTXTProfit Center TextS/4HANACEPCTMCTXTProfit Center TextCopy From DCT as-is



Transformation Mapping

Mapping Table Name

Mapping Table Description

Profit Centre

Mapping of legacy Profit Center to target system value

Person Responsible

Mapping of legacy Person Responsible to New Person Responsible

User ID

Mapping of legacy User ID

Hierarchy Group

Mapping of Legacy Hierarchy Group to Hierarchy Group

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.Data Team
2

Ensure Profit Centre hierarchies are loaded into target S/4HANA

Data Team


Pre-Load Validation

Project Team

Completeness

Task

Action

Generation of
Pre-load reports

Mandatory field check.

  • Profit Centres are mapped to new values
  • Profit Centre Hierarchy Mapped to new values
  • Person Responsible / HR positions mapped to new values
  • Company Code is mapped based on Company Code Mapping

Record Count

Record Count

  • Confirm the record counts in preload summary report
    • Total Records: To be Filled in Summary Report
    • Valid Records: To be Filled in Summary Report
    • Invalid Records: To be Filled in Summary Report

Accuracy

Task

Action

Mandatory field mapping and transformation

Obtain a list of the fields to be populated with values from mapping files and ensure all these fields contain S/4HANA values. 
Review the data report to ensure mapping value is not missing in tool.
Capture errors in the Data Error report.

Business

Completeness

TaskAction
Verify record count in Pre-load reports by region

Confirm the Preload File contains all the records in scope of migration based on the DCT (Data Construction Template)


Accuracy

TaskAction
Conversion accuracy

Verify Profit Centres are transformed accurately as per endorsed transformation/mapping rules.

Review error reports in tool for any mismatch or missing transformed values.


Load

The load process includes:

  1. Execute the automated data load into target system using load tool or produce the load file if the loading of records to be done using LTMC cockpit object of Profit Centre. 
  2. Once the data is loaded to the target system, it will be extracted and prepared for Post Load Data Validation with side by side check of each fields in scope of the objects with fields to be displayed as XXXX_ECC, XXXX_S4HANA, XXXX_MATCH ( As TRUE or FALSE) with an additional column denoting fields not matching and status of loading in S/4HANA as LOADED_IN_S4HANA ( As TRUE or FALSE) 

Load Run Sheet


Item

Step description

Team responsible

1

Ensure the load tools are transported into the correct tool instance.

Data team

2

Ensure DCTs and all required mappings are submitted and complete

Data team

3

Ensure Pre-load sign-offs are obtained.

Data team

4

Execute upload of Profit Centre Object using Migration Cockpit Object for Profit Centre Upload

Data team

5

Generate the post load reports in tool.

Data team

6

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

Data team

7

Resolve defects by reupload and re-generate post load reports if necessary.

Data team

8

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

Business

9

Repeat steps 5 to 7 if necessary.

Data team



Load Phase and Dependencies

Configuration

Item #

Configuration item

1.      

Controlling Area

2.      

Standard Hierarchy is Maintained

 Conversion Objects

Object #Preceding Object Conversion Approach
1068Profit Centre Group (Alt, Std Hierarchy)

Error Handling


Error type

Error description

Action taken





Post-Load Validation

Project Team

Completeness

TaskAction
Reconciliation of Record Count

Check Record count between DCT, Preload file and target extracted data from tables CEPC and CEPCT.

A Summary report to be added in the post-load report


Accuracy

TaskAction
Check values in key fields for accuracy

Refer to the post-load file and Manual check of the Loaded data using KE53 and SE16N


Business

Completeness

TaskAction
Record Count Check

Business to check Post-Load File and Summary report in post-load


Accuracy

TaskAction
Open items totalsCheck business partner open item totals by Business partner, Company code, profit centre. Totals should be checked in Document, Local and Group currency.
Spot checkSpot check some sample records from the post-load report to be picked for checking in SAP transaction code KE53 to verify accuracy of the data. 


Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load. 
  • is in scope based on data design and any exception requested by business.

Change log

Version Published Changed By Comment
CURRENT (v. 14) Mar 13, 2026 01:27 LARU-ext, Soumen
v. 51 Mar 13, 2026 00:52 LARU-ext, Soumen
v. 50 Mar 13, 2026 00:44 LARU-ext, Soumen
v. 49 Oct 23, 2025 04:56 LARU-ext, Soumen
v. 48 Oct 12, 2025 14:22 LARU-ext, Soumen
v. 47 Sept 29, 2025 12:03 GARCIA-ext, Angel Luis
v. 46 Sept 29, 2025 09:25 GARCIA-ext, Angel Luis
v. 45 Sept 23, 2025 22:21 PILLAY-ext, Lawrence
v. 44 Sept 23, 2025 11:11 LARU-ext, Soumen
v. 43 Sept 23, 2025 09:33 LARU-ext, Soumen

Go to Page History

Workflow history

Title Last Updated By Updated Status  
There are no pages at the moment.

  • No labels