| Status |
| ||||||
| Owner | Soumen Laru | ||||||
| Stakeholders |
Purpose
The purpose of this document is to define the conversion approach of Profit Centre Group (Alternate and Std Hierarchy)s into S/4 HANA.
The document details out the field list, extraction criteria, scoping, mapping of Profit Centre Group (Alt, Std Hierarchy)s.
Note: Profit Centre Standard and Alternate hierarchies will be constructed newly based on the new organizational design. Therefore, even though extracting and transforming of source hierarchy is an option, that will not be used. Instead, a DCT( Data Construction Template) will be used to collect the new hierarchy details.
As per the current implementation approach, any alternative hierarchies, if applicable, will be uploaded exclusively through the Manage Global Hierarchies application and not via LSMW. Should there be a requirement to upload any alternative hierarchy using LSMW, this specification is designed to accommodate such a scenario. At this stage, there is no anticipated requirement for the inclusion of alternative hierarchies within the migration scope.
Conversion Scope
Profit Centre Group (Alt, Std Hierarchy)s 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| Source | Scope | Source Approx No. of Records | Target System | Target Approx No. of Records |
|---|---|---|---|---|
| PF2 | Profit Centre Group (Alt, Std Hierarchy) | N/A | S4HANA | TBD |
| WP2 | Profit Centre Group (Alt, Std Hierarchy) | N/A | S4HANA | TBD |
Additional Information
Multi-language Requirement
In the Syensqo Profit Centre Group (Alt, Std Hierarchy)s, 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 Centre Group (Alt, Std Hierarchy)s 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 Centre Group (Alt, Std Hierarchy)s.
Document Management
Legal Requirement
Special Requirements
Target Design
The technical design of the target for this conversion approach.
| Table | Field | Data Element | Field Label | Data Type | Length | Syensqo 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 |
| SETHEADER | SETCLASS | SETCLASS | Set Class | CHAR | 4 | R |
| SETHEADER | SUBCLASS | SETSUBCLS | Sub class org unit | CHAR | 12 | O |
| SETHEADER | SETNAME | SETNAMENEW | Set Name | CHAR | 24 | R |
| SETHEADERT | LANGU | SPRAS | Language Key | CHAR | 1 | R |
| SETHEADERT | DESCRIPT | SETTEXT | Description | CHAR | 40 | R |
| SETNODE | LINEID | SETLINE | Set Line Counter | NUMC | 10 | R |
| SETNODE | SETNAME | SETNAMENEW | Parent Group Name | CHAR | 24 | R |
| SETNODE | SUBSETNAME | SUBSETNAME | Child Group Name | CHAR | 24 | C |
| SETLEAF | SETNAME | SUBSETNAME | Group Node Name | CHAR | 24 | O |
| SETLEAF | VALFROM | VALFROM | (Profit Centre) From Value | CHAR | 40 | O |
| SETLEAF | VALTO | VALTO | (Profit Centre) To Value | CHAR | 40 | O |
Data Cleansing
ID | Criticality | Error Message/Report Description | Rule | Output | Source System |
1. | N/A |
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 Centre Group (Alt, Std Hierarchy)s based on the collection template | Data team |
Selection Screen
| Selection Ref Screen | Parameter Name | Selection Type | Requirement | Value 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.
two DCT pages ( one for standard hierarchy and another for alternate )
Note: Constructed data will be imported into ADM Data Construction page.
There will be two pages -
1. Main page to contain the hierarchy details with EN Language key Description
2. Detailed Page will contain descriptions ( SETHEADERT-DESCRIPT ) of the SETHEADER-SETNAME in various languages as they are collected.
| Table Name | Field Name | Field description | Rule |
| CEPC | KOKRS | Controlling Aera | Default to 'CO01' |
| SETHEADER | SETCLASS | Set Class | Set to '0106' for Profit Centre Group |
| SETHEADER | SUBCLASS | Organizational Unit as Set Subclass | Default to 'CO01' |
| SETHEADER | SETNAME | Set Name | The standard hierarchy will be organized via the following structure: - GBU / Company Code / Plant / Function The standard hierarchy will only include authorization relevant dimensions for cost centers. All reporting dimension can be covered via alternative (flexible) hierarchies |
| SETHEADERT | LANGU | Language key | As they are collected |
| SETHEADERT | DESCRIPT | Description | Group description |
| SETNODE | LINEID | Line Number | This will contain the level of the hierarchy nodes ( will do in exact hierarchy form ) - example is given in Load section. |
| SETNODE | SETNAME_SETNODE | Parent Group Name | The code of the parent group. If node 2, it refers to node 1. If node 1 : no reference. |
| SETNODE | SUBSETNAME | Child Group Name | The code of the child group. If node 1, it refers to node 2. If node 2 : no reference as it will be directly profit center values. For the values, refer to the field Set Name. |
| SETLEAF | SETNAME_SETLEAF | Group Node Name | Changes based on the length of the item/package. |
| SETLEAF | VALFROM | (Profit Centre) From Value | Profit Centre Value ( Optional in DCT and profit centres will be assigned to Hierarchy node in Profit Centre DCT part of CNV-1073 Profit Centre ) |
| SETLEAF | VALTO | (Profit Centre) To Value | Profit Centre Value ( Optional in DCT and profit centres will be assigned to Hierarchy node in Profit Centre DCT part of CNV-1073 Profit Centre ) |
Descriptions will be collected on multiple languages and therefore a detail page to created and linked to the main page
| Table Name | Field Name | Field description | Rule |
| SETHEADER | SETNAME | Set Name | The standard hierarchy will be organized via the following structure: - GBU / Company Code / Plant / Function The standard hierarchy will only include authorization relevant dimensions for cost centers. All reporting dimension can be covered via alternative (flexible) hierarchies |
| SETHEADERT | LANGU | Language Key | Language Key of the Text |
| SETHEADERT | DESCRIPT | Description | Group description |
Please refer to the below sample file of DCT as an example
| CEPC | SETHEADER | SETHEADER | SETHEADER | SETHEADERT | SETHEADERT | SETNODE | SETNODE | SETNODE | SETLEAF | SETLEAF | SETLEAF |
| KOKRS | SETCLASS | SUBCLASS | SETNAME | LANGU | DESCRIPT | LINEID | SETNAME_SETNODE | SUBSETNAME | SETNAME_SETLEAF | VALFROM | VALTO |
| Controlling Area | Set Class | Organizational Unit as Set Subclass | Set Name | Language key | Description | Line Number | Parent Group Name | Child Group Name | Group Node Name | (Profit Centre) From Value | (Profit Centre) To Value |
| CO01 | 0106 | CO01 | |||||||||
| CO01 | 0106 | CO01 | SQCCH | E | Syensqo Headquarter | 0 | |||||
| CO01 | 0106 | CO01 | SQCCHEU | E | Syensqo Europe | 1 | SQCCH | SQCCHEU | |||
| CO01 | 0106 | CO01 | SQCCHEUBE | E | Syensqo Belgium | 2 | SQCCHEU | SQCCHEUBE | |||
| CO01 | 0106 | CO01 | SQCCHEUFR | E | Syensqo France | 2 | SQCCHEU | SQCCHEUFR | |||
| CO01 | 0106 | CO01 | SQCCHEUFRPA | E | Syensqo Paris | 3 | SQCCHEUFR | SQCCHEUFRPA | |||
| CO01 | 0106 | CO01 | SQCCHEUFRLE | E | Syensqo Leon | 3 | SQCCHEUFR | SQCCHEUFRLE | SQCCHEUFRLE | PC1234 | PC1234 |
| CO01 | 0106 | CO01 | SQCCHEUFRLE | E | Syensqo Leon | 3 | SQCCHEUFR | SQCCHEUFRLE | SQCCHEUFRLE | PC1235 | PC1235 |
| CO01 | 0106 | CO01 | SQCCHEUDK | E | Syensqo Denmark | 2 | SQCCHEU | SQCCHEUDK | |||
| CO01 | 0106 | CO01 | SQCCHEUDKCHG | E | Syensqo Copenhagen | 3 | SQCCHEUDK | SQCCHEUDKCHG |
Extraction Dependencies
Item # | Step description | Team responsible |
1. | N/A |
Transformation
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:
- Prepare target-ready data in the target structure and format that is required for loading via prescribed Load Tool in the load section.
- 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 Cost Centre Group (Alt, Std Hierarchy) Object | Data team |
3. | Go to Process Area Launch and Process the Object - Cost Centre Group (Alt, Std Hierarchy) Object | 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
As this data object will be collected in the DCT template, all the fields to be imported and load file will be prepared with as-is copy. No change in the field value to be done.
| Rule # | Source system | Source Table | Source Field | Source description | Target system | Target Table | Target Field | Target description | Transformation logic |
| 1 | DCT/ECC | SETHEADER | SETCLASS | Set Class | S/4HANA | SETHEADER | SETCLASS | Set Class | Copy From DCT as-is |
| 3 | DCT/ECC | SETHEADER | SETNAME | Set Name | S/4HANA | SETHEADER | SETNAME | Set Name | Copy From DCT as-is |
| 3 | DCT/ECC | SETHEADERT | LANGU | Language Key | S/4HANA | SETHEADER | LANGU | Language key | Copy From DCT as-is |
| 4 | DCT/ECC | SETHEADERT | DESCRIPT | Description | S/4HANA | SETHEADERT | DESCRIPT | Description | Copy From DCT as-is |
| 5 | DCT/ECC | SETNODE | LINEID | Set Line | S/4HANA | SETNODE | LINEID | Set Line | Copy From DCT as-is |
| 6 | DCT/ECC | SETNODE | SETNAME | Parent Group Name | S/4HANA | SETNODE | SETNAME | Parent Group Name | Copy From DCT as-is |
| 7 | DCT/ECC | SETNODE | SUBSETNAME | Child Group Name | S/4HANA | SETNODE | SUBSETNAME | Child Group Name | Copy From DCT as-is |
| 8 | DCT/ECC | SETLEAF | SETNAME | Group Node Name | S/4HANA | SETLEAF | SETNAME | Group Node Name | Copy From DCT as-is |
| 9 | DCT/ECC | SETLEAF | VALFROM | Profit Centre ( From Value ) | S/4HANA | SETLEAF | VALFROM | Valid-From Date | Copy From DCT as-is |
| 10 | DCT/ECC | SETLEAF | VALTO | Profit Centre ( To Value ) | S/4HANA | SETLEAF | VALTO | Valid-To Date | Copy From DCT as-is |
Transformation Mapping
Mapping Table Name | Mapping Table Description |
N/A |
Transformation Dependencies
List the steps that need to occur before transformation can commence| Item # | Step Description | Team Responsible |
|---|---|---|
| 1 | Ensure all the fields and values are imported into ADM Construction page correctly | Data Team |
Pre-Load Validation
Project Team
Completeness
Task | Action |
Generation of | Mandatory field check.
|
Record Count | Record Count
|
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. |
Business
Completeness
| Task | Action |
|---|---|
| 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
| Task | Action |
|---|---|
| Conversion accuracy | Verify Profit Centre Group (Alt, Std Hierarchy)s are transformed accurately as per endorsed transformation/mapping rules. Review error reports in tool for any mismatch or missing transformed values. In legacy system, execute ECC tcode SE16N to display table SETHEADER, SETLEAF and SETNODE ( with SETCLASS = '0106' ) to confirm copied fields are accurately copied. ( If applicable) |
Load
Loading of standard hierarchy: Load Template is different from the data collection template. Loading of standard hierarchy will be done using LSMW with Idoc ( PROFITCENTERGROUP_CREATE_01) as the technology behind.
Loading of Alternate hierarchy: Loading of alternate hierarchy will be done using LSMW with Idoc ( PROFITCENTERGROUP_CREATE_01) as the technology behind. However, some fiori based app will be explored to check if that could be used for upload alternate hierarchy. In this option, loading is done using either the "Manage Global Hierarchies" (F2918) or "Manage Flexible Hierarchies" (F2759) app in your Fiori launchpad.
Loading of Descriptions in various Languages: Loading of descriptions in various languages will be done using tcode SE63.
Three exports views will be required to upload this object.
Export view 1.
Please generate an export view for the load template as in the table below, details of mapping of fields between DCT to load template.
LNIND = H for the record where DCT field SETNAME is empty
LNIND = L for all the other lines
Parent = DCT Field SETNAME_SETNODE
VALU1 = DCT Field SUBSETNAME
VALU2 = DCT Field LINEID
VALU3 = 0 for standard hierarchy and count of VALFROM for combination of other fields ( LNIND, Parent, VALU1, VALU2 )
VALU4 = DCT Field DESCRIPT
LNIND | Parent | VALU1 | VALU2 | VALU3 | VALU4 |
H | <Controlling area - KOKRS> | ||||
L | <SETHEADER-SETNAME> | <SETHEADER-SETNAME> | 0 | 0 | <SETHEADERT-DESCRIPT> |
L | <SETNODE-SETNAME> | <SETNODE-SUBSETNAME> | <SETNODE-LINEID> E.G 1 | 0 | <SETHEADERT-DESCRIPT> |
L | <SETNODE-SETNAME> | <SETNODE-SUBSETNAME> | <SETNODE-LINEID> E.G 2 | 0 | <SETHEADERT-DESCRIPT> |
L | <SSETNODE-SETNAME> | <SETNODE-SUBSETNAME> | <SETNODE-LINEID> E.G 3 | 0 | <SETHEADERT-DESCRIPT> |
L | <SETNODE-SETNAME> | <SETNODE-SUBSETNAME> | <SETNODE-LINEID> E.G 4 | 0 | <SETHEADERT-DESCRIPT> |
L | <SETNODE-SETNAME> | <SETNODE-SUBSETNAME> | <SETNODE-LINEID> E.G 4 | 0 | <SETHEADERT-DESCRIPT> |
L | <SETNODE-SETNAME> | <SETNODE-SUBSETNAME> | <SETNODE-LINEID> E.G 3 | 0 | <SETHEADERT-DESCRIPT> |
L | <SETNODE-SETNAME> | <SETNODE-SUBSETNAME> | <SETNODE-LINEID> E.G 4 | 0 | <SETHEADERT-DESCRIPT> |
L | <SETNODE-SETNAME> | <SETNODE-SUBSETNAME> | <SETNODE-LINEID> E.G 4 | 0 | <SETHEADERT-DESCRIPT> |
Export view 2.
Generate 2nd export view containing below columns. This view will contain the profit centres to be assigned to the hierarchy node.
This view is created for the non-blank entries from SETLEAF.
SETNAME | VALFROM | VALTO |
<SETLEAF-SETNAME> | <SETLEAF-VALFROM> | <SETLEAF-VALTO> |
<SETLEAF-SETNAME> | <SETLEAF-VALFROM> | <SETLEAF-VALTO> |
<SETLEAF-SETNAME> | <SETLEAF-VALFROM> | <SETLEAF-VALTO> |
Export view 3.
Generate 3rd view containing the descriptions of the Hierarchy for different languages.
SETNAME | LANGUAGE | DESCRIPTION |
<SETHEADER-SETNAME> | <SETHEADER-LANGU> | <SETHEADER-DESCRIPT> |
<SETHEADER-SETNAME> | <SETHEADER-LANGU> | <SETHEADER-DESCRIPT> |
<SETHEADER-SETNAME> | <SETHEADER-LANGU> | <SETHEADER-DESCRIPT> |
Note: Description translation data which will be given in the export view 3, 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.
Note: 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)
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 Group (Alt, Std Hierarchy) Object using Migration Cockpit Object for Profit Centre Group (Alt, Std Hierarchy) 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. | Before uploading your SAP profit center hierarchy, the standard hierarchy itself must be maintained and exist within the Controlling Area in SAP. You need to create and assign your controlling area to the standard hierarchy's top node, then add lower-level nodes to form the tree structure. This can be done in the SAP Fiori Launchpad using the activity "Define Profit Center Standard Hierarchy in Controlling" or the "Manage Profit Center Groups" app. |
Conversion Objects
| Object # | Preceding Object Conversion Approach |
|---|---|
| N/A |
Error Handling
Error type | Error description | Action taken |
Post-Load Validation
Project Team
Completeness
| Task | Action |
|---|---|
| Reconciliation of Record Count | Check Record count between DCT, Preload file and target extracted data from tables SETHEADER, SETHEADERT,SETNODE, SETLEAF. A Summary report to be added in the post-load report |
Accuracy
| Task | Action |
|---|---|
| Check values in key fields for accuracy | Refer to the post-load file and Manual check of the Loaded data using KCH3 ( or KCH5N) and SE16N (tables SETHEADER, SETHEADERT, SETNODE, SETLEAF) |
Business
Completeness
| Task | Action |
|---|---|
| Record Count Check | Business to check Post-Load File and Summary report in post-load |
Accuracy
| Task | Action |
|---|---|
| Spot check | Spot check some sample records from the post-load report to be picked for checking in SAP transaction code KCH3 ( Or KCH5N) 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
| Change History | ||
|---|---|---|
|
Workflow history
| Workflow Report | ||||||
|---|---|---|---|---|---|---|
|