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

Compare with Current View Page History

« Previous Version 14 Next »

Status

  Approved

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach for Cost Element Groups into S/4 HANA. Cost Element Group is the process used to group together any cost elements for a specific purpose mainly reporting and overheads allocation. 

Currently, the cost element groups utilized in the legacy systems with a basic and single dimension sets  with similar characteristics are grouped together for reporting and overhead allocation purpose.

In S/4, Cost Element groups will be organized in a tree like structure to group all similar types of cost elements together. Grouping it makes it easier to report and allocate costs in a single source of transaction. These groups will be created under specific controlling area and can be updated or changed when the purpose of their use changes. The new GL account (CoA) design in S/4 will govern the development of Cost Element Groups. As a result, even if the the CE Groups are extracted from the legacy systems, they will not be migrated into S/4 instead, the new CE groups will be created in accordance with the MDS and the new group details will be collected through a Data Collection Templates (DCT).

The hierarchy below is for reference and is expected to be created similar CE hierarchy in the target system.


Conversion Scope

The scope of this document covers the approach for creating a new Cost Element Groups into S/4HANA following the 1078-Cost element groups Master Data Design Standard.

The data from legacy system includes: N/A

The data from legacy system excludes: N/A 


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2Cost Element Groups6338S/4HANATBA
WP2Cost Element Groups2182S/4HANATBA

Additional Information

Multi-language Requirement

Cost Element Groups will primarily be managed in English

Document Management

N/A

Legal Requirement

N/A

Special Requirements

N/A

Target Design

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLength

Requirement

R = Required : Mandatory field.

S = System: System generates the value

O = Optional: Not Mandatory

SETHEADERSETCLASSSETCLASSSet ClassCHAR4S
SETHEADERSUBCLASSSETSUBCLSOrganizational Unit as Set SubclassCHAR12S
SETHEADERSETNAMESETNAMENEWSet NameCHAR24R
SETHEADERTDESCRIPTSETTEXTShort Description of a SetCHAR40R
SETNODELINEIDSETLINESet Line CounterNUMC10R
SETNODESETNAMESETNAMENEWSet NameCHAR24O
SETNODESUBSETNAMESEBSETNAMESubordinate Set IDCHAR24O
SETLEAFVALFROMSETVALMINFrom ValueCHAR40R
SETLEAFVALTOSETVALMAXTo ValueCHAR40R


Data Cleansing

Data Cleansing is not relevant for this object because the entire Chart of Accounts will be afresh designed in S/4HANA

IDCriticalityError Message/Report DescriptionRuleOutputSource System
N/A




Conversion Process

The high-level process is represented by the diagram below. Although source extraction is incorporated in the process flow, no relevancy or extraction rules are implemented. The Data team will collect the new cost element groups using the DCT, and an ETL process will be followed to the Target loads.

image-2025-6-9_14-37-29.png

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

Data Privacy and Sensitivity

N/A


Extraction

Perform full data extraction from relevant tables in the source systems into Syniti Migrate. There will be no relevancy criteria is applied to the extracted records, The DCT is applicable for the Target loads.

Extraction Run Sheet

Req #Requirement DescriptionTeam Responsible
1.The new cost element groups will be collected using the Data Collection Template (DCT)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 Cost Element Groups with exception of some fields which require transformation as mentioned in the transformation rule.

DCT Rules for 1078 Cost Element Groups

Field NameField DescriptionRule
TKA01-KOKRSControlling AreaDefaults to 'XXXX'
SETHEADER-SECLASSSet ClassThis field set to be '0102' for Cost Element Group
SETHEADER-SUBCLASSOrganizational Unit as Set SubclassThis field is system generated and defaults to 'XXXX' as a Chart of Accounts
SETHEADER-SETNAMESet NameCO01_CE - Cost Element Group Main Hierarchy ID
SETHEADERT-DESCRIPTShort Description of a SetDescription for Cost Element Group Main Hierarchy ID
SETNODE-LINEIDSet LineThis refers to the Hierarchy root node. 
SETNODE-SETNAMESet NameThis will only updates when there is a subset to the main CE group. If not, this wont be updated in SETNODE. 
SETNODE-SUBSETNAMESubordinate Set IDThis refers to the lowest set ID of the main group
SETLEAF-SETNAMESet NameName of the lowest node of the hierarchy to which a cost elements is assigned
SETLEAF-VALFROMFrom ValueCost Elements assignment from a single value or range
SETLEAF-VALTOTo ValueCost Elements assignment to

Extraction Dependencies

Item #Step DescriptionTeam Responsible
N/A


Transformation

To prepare the data for Target, the Target fields are mapped to the corresponding Legacy field (in this case, DCT) 

  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. 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
1Obtain DCT Sign-off from BusinessR2R Data Team
2Generate Load FilesR2R Data Team
3Monitor the transformation progress and ensure that performance and completion are within the allowed timelinesR2R Data Team
4Review and Validate Error and Preload ReportsR2R Data Team
5Log defects for any kind of errors and address resolutionR2R Data Team
6Re-transform the pre-load files, validate and ready for load (This step is applicable If step 5 is active, else No)R2R Data Team
7Proceed for final loadsR2R Data Team


Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic
1SAP ECC (DCT)TKA01KOKRSControlling AreaSAP S/4HANATKA01KOKRSControlling Area1:1
2SAP ECC (DCT)SETHEADERSECLASSSet ClassSAP S/4HANASETHEADERSECLASSSet ClassConstant value: '0102'
3SAP ECC (DCT)SETHEADERSUBCLASSOrganizational Unit as Set SubclassSAP S/4HANASETHEADERSUBCLASSOrganizational Unit as Set SubclassSystem generates value in the background
4SAP ECC (DCT)SETHEADERSETNAMESet NameSAP S/4HANASETHEADERSETNAMESet NameGet from DCT
5SAP ECC (DCT)SETHEADERDESCRIPTShort Description of a SetSAP S/4HANASETHEADERDESCRIPTShort Description of a SetGet from DCT
6SAP ECC (DCT)SETNODELINEIDSet LineSAP S/4HANASETNODELINEIDSet LineGet from DCT
7SAP ECC (DCT)SETNODESETNAMESet NameSAP S/4HANASETNODESETNAMESet NameGet from DCT
8SAP ECC (DCT)SETNODESUBSETNAMESubordinate Set IDSAP S/4HANASETNODESUBSETNAMESubordinate Set IDGet from DCT
9SAP ECC (DCT)SETLEAFSETNAMESet NameSAP S/4HANASETLEAFSETNAMESet NameGet from DCT
10SAP ECC (DCT)SETLEAFVALFROMFrom ValueSAP S/4HANASETLEAFVALFROMFrom ValueGet from DCT
11SAP ECC (DCT)SETLEAFVALTOTo ValueSAP S/4HANASETLEAFVALTOTo ValueGet from DCT

Transformation Mapping

Mapping Table NameMapping Table Description
N/A

Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible
1Ensure DCT completenessR2R Data Team
2Value Mappings are according to the latest designR2R Data Team


Pre-Load Validation

Project Team

Completeness

TaskAction
Verify Record CountR2R 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

R2R Data Team to ensure that all fields listed below pass the checks:

  1. Mandatory Fields
  2. Field and Value Mapping Correctness
  3. Null Checks
  4. Text Length Checks
  5. Hierarchy Nodes
Review Error ReportsReview 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.

Business

Completeness

TaskAction
Verify Record CountBusiness Data Owner/s to verify that the total number of relevant records from the the DCT is equal to the total number of records in the Preload and Load Sheets.

Accuracy

TaskAction
Conversion AccuracyBusiness 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, for this object, the load tool will be LSMW with Import method IDOC and Basic Type - COSTELEMENTGROUP_CREATE01.
  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
1Go to <Load tool>R2R Data Team
2Load 1 or 2 records for "Create Cost Element Groups" to validate if data is loaded successfully without errorsR2R Data Team
3Proceed with full load if step 2 is successful and validatedR2R Data Team
4Validate few records loaded by accessing standard transactions or tables from S/4HNA E.g. KAH3 or FIORI: Manage Cost Element GroupsR2R Data Team
5Generate post load report if step 4 is validatedR2R Data Team


Load Phase and Dependencies

Configuration

Item #Configuration Item
1Controlling Area
2Chart of Accounts
3General Ledger Accounts

Conversion Objects

Object #Preceding Object Conversion Approach
1067General Ledger Accounts (COA)

Error Handling

Error TypeError DescriptionAction Taken
ConfigurationData update is unsuccessful (ex. Invalid Cost Element), system provides opportunity to review the incorrectly populated data and these need to be analysed and correctedConsult Functional team to expedite and fix the error in the system


Post-Load Validation

Project Team

Completeness

TaskAction

Verify Count

R2R Data Team to verify the record count created in target S/4 HANA by accessing post load reports using 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 Cost Element Groups in target S/4 HANA are loaded correctly via load program and validate post load reports using standard t.code KAH3 or database tables SETHEADER, SETHEADERT, SETNODE and SETLEAF from S/4 HANA.


Business

Completeness

TaskAction

Verify Count

Download Post Load Reports from load program and verify that the record count loaded in the target S/4 HANA is the same count as of the approved load file.


Accuracy

TaskAction
Conversion AccuracyVerify that the Cost Element Groups in target S/4 HANA are loaded correctly via load program and validate post load reports using standard t.code KAH3 or database tables SETHEADER, SETHEADERT, SETNODE and SETLEAF from S/4 HANA.


Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • Data values in DCT are target ready data unless a specific transformation rule is stated for that field in the transformation rules
  • Basic required configuration to be completed prior to this conversation
  • LSMW load program will be processed in foreground


See also

Change log

Version Published Changed By Comment
CURRENT (v. 14) Oct 07, 2025 10:49 PARA-ext, Anil
v. 27 Sept 30, 2025 11:53 PARA-ext, Anil
v. 26 Sept 30, 2025 11:29 PARA-ext, Anil
v. 25 Sept 30, 2025 10:07 PARA-ext, Anil
v. 24 Sept 29, 2025 22:51 PILLAY-ext, Lawrence
v. 23 Sept 29, 2025 09:28 GARCIA-ext, Angel Luis
v. 22 Sept 25, 2025 18:39 PARA-ext, Anil
v. 21 Sept 25, 2025 13:56 PARA-ext, Anil
v. 20 Sept 19, 2025 09:58 PARA-ext, Anil
v. 19 Sept 17, 2025 12:55 PARA-ext, Anil

Go to Page History

  • No labels