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

Compare with Current View Page History

« Previous Version 44 Next »

Status

80%

OwnerSoumen Laru
Stakeholders

Purpose

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

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. 

Note:  All the Profit Centres to be migrated will be collected.  Therefore, Profit Centres are not going to be extracted from source and details given below is given for information purpose only. 

SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2Profit Centre6,423S4HANATBD
WP2Profit Centre5,768S4HANATBD

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
CEPCKHINRPHINRProfit center areaCHAR12Profit center areaR
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
CEPCTKTEXTKTEXTNameCHAR20Profit Center NameR
CEPCTLTEXTLTEXT Long TextCHAR40Profit Center Long TextR
CEPCTMCTXTMCTXTProfit Center TextCHAR20Profit Center TextO


Data Cleansing

Note: Cleansing is applicable only for business and as the data for this object is collected, cleansing is not relevant for data conversion. It just helps business to reduce the mapping requirements. 

ID

Criticality


Error Message/Report Description

Rule

Output

Source System

1.      

Not Critical

Lock any Profit Centre not being used for last 5 years

Select BSEG-BUKRS, BSEG-PRCTR from BSEG where  BSEG-GJAHR >= 2020 and BUKRS in Company code value mapping source company codes ( )

Report


PF2 / WP2

Conversion Process 

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

Note: When Data Source denotes DCT, no relevancy and extract rules to be applied in Syniti tool. DCT records will be collected by business Data Consultant. 

Data Privacy and Sensitivity


Extraction

 Extraction Run Sheet

Req #

Requirement description

Team responsible

1.      

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

Data team


Selection Screen

Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set
N/A




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 and will be used by the data collectors.

Note: Constructed data will be imported into ADM Data Construction page.

There will be two pages -

  1. Main page to contain the Profit Centre details with EN Language key Description

  2. Detailed Page will contain descriptions in various languages as they are collected.


Table NameField NameField descriptionRule
CEPCPRCTRProfit CenterThis field must be 5 digits. It must follow the naming convention described in governance rules applied
CEPCDATBIValid To Date31.12.9999  by default. If a PC has a end date : this field can be updated with the accurate values. Select Last day of a month period at least (not a date during a period).
CEPCKOKRSControlling Area1 unique value for all PC. 
CEPCDATABValid-From DateDate of the creation of the Prof.center during the run. Date of the go live for the ones Mass loaded as part of the Syway cut over
CEPCVERAKPerson Responsible for Profit CenterChanges if organization change within the GBS. 
CEPCVERAK_USERUser Responsible for the Profit CenterChanges if organization change within the GBS or turn over
CEPCWAERSCurrency KeyCurrency of the company code.
CEPCLAND1Country KeyCollected as required
CEPCNAME1Name 1Changes if plant name changes or if GBS department changes
CEPCNAME2Name 2Collected as required
CEPCNAME3Name 3Collected as required
CEPCNAME4Name 4Collected as required
CEPCORT01CityCollected as required
CEPCORT02DistrictCollected as required
CEPCSTRASStreet and House NumberCollected as required
CEPCPFACHPO BoxCollected as required
CEPCPSTLZPostal CodeCollected as required
CEPCPSTL2P.O. Box Postal CodeCollected as required
CEPCSPRASLanguage KeyCollected as required
CEPCTELBXTelebox numberCollected as required
CEPCTELF1First telephone numberCollected as required
CEPCTELF2Second telephone numberCollected as required
CEPCTELFXFax NumberCollected as required
CEPCTELTXTeletex numberCollected as required
CEPCTELX1Telex numberCollected as required
CEPCKHINRProfit center areaCollected as required
CEPCBUKRSCompany CodeCollected as required
CEPCTXJCDTax JurisdictionCollected as required
CEPCREGIORegion (State, Province, County)Collected as required
CEPCLOGSYSTEMLogical SystemCollected as required
CEPCLOCK_INDLock indicatorCase to tick if a Profit center must be blocked for posting : obsolete PC or PC created by mistake.


Descriptions will be collected on multiple languages and therefore a detail page to created and linked to the main page


Table NameField NameField descriptionRule
CEPCKOKRSControlling Area1 unique value for all PC. 
CEPCPRCTRProfit CenterThis field must be 5 digits. It must follow the naming convention described in governance rules applied
CEPCTDATBIValid To Date
CEPCTSPRASLanguage KeyIn the Syensqo Profit centers, the following four language keys must be maintained:
 - English (EN)
 - French (FR)
 - Italian (IT)
 - Chinese (ZN)

Additionally, fill in the  name and description for the language key;
CEPCTKTEXTNameMax Length: 20
CEPCTLTEXTLong TextMax Length: 40
CEPCTMCTXTProfit Center TextMax Length: 20

Extraction Dependencies


Item #

Step description

Team responsible

1.      

N/A



Transformation

The Target fields are mapped to the applicable DCT field that will be its source.  

Note:  as this object is DCT, the mapping rule for all the fields is 'Copy'  as described in the transform rule section. However, some reports are to be created and executed to ensure integrity in the data collected in DCT as described in 'Pre-load Data Validation' section. 

This step identifies the transformation activity required to allow  to make the data Target ready:

  1. Prepare target-ready data in the target structure and format that is required for loading via prescribed Load Tool in the load section.
  2. Produce the preload reports as requested in the 'Preload Data Validation' section. 

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 CenterCopy From DCT as-is 
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 CodeCopy From DCT as-is 
27DCT/ECCCEPCKHINRProfit center areaS/4HANACEPCKHINRProfit center areaCopy From DCT as-is 
28DCT/ECCCEPCTXJCDTax JurisdictionS/4HANACEPCTXJCDTax JurisdictionCopy From DCT as-is
29DCT/ECCCEPCREGIORegion (State, Province, County)S/4HANACEPCREGIORegion (State, Province, County)Copy From DCT as-is
30DCT/ECCCEPCLOCK_INDLock indicatorS/4HANACEPCLOCK_INDLock indicatorCopy 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

Note: No Mapping applicable here as this data object is a collect object. 

Mapping Table Name

Mapping Table Description

N/A


Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Ensure all the fields and values are imported into ADM Construction page correctlyData 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 not blank
  • Profit Centre Hierarchy not blank
  • Person Responsible / HR positions not blank
  • Company Code not empty

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

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

Loading will be done through migration cockpit and therefore, data from the transformation export view to be exported into the load file format.

export views to be prepared based on the field list from the load template attached. 

Source data for CO - Profit center (2).xml


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_DCT, 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) 

Additional export view for the descriptions in additional languages to be created as is from detail page DCT

Note:  Description translation will be loaded using tcode SE63.  LSMW will be created based on the tcode SE63 to enable mass upload of this data. However, further checks will be done to check if some Fiori App could be used for uploading. 

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