Versions Compared

Key

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

pagestatus
Percentage Progress | Vectors (Formerly: SP Percentage progress bar)
backgroundColor0052CC
percentage100

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to create 1078 Cost Element Groups (ie., Hierarchies) in S/4 HANA.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 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.

Image Added

Conversion Scope

The scope of this document covers the approach for converting active from Legacy Source Systems into creating a new Cost Element Groups into S/4HANA following the 1078-Cost element groups Master Data Design Standard. DD-FUN-050 Master Data Standard_1078-Cost element groups. This object's conversion from source to target is an approved DCT document.

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. However, according to KDD055,  this master data standard will be implemented in 4 core languages. 

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

Note: For other language requirements were not finalized while developing this document, refer to Jira ID # PDM 603.

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
SETHEADERTLANGUSPRASLanguage KeyLANG1O
SETHEADERTDESCRIPTSETTEXTShort Description of a SetCHAR40R
SETNODELINEIDSETLINESet Line CounterNUMC10R
SETNODESETNAMESETNAMENEWSet NameCHAR24O
SETNODESUBSETNAMESEBSETNAMESubordinate Set IDCHAR24O
SETLEAFSETNAMESETNAMENEWSet NameCHAR24O
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 planned, 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.

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

Data Privacy and Sensitivity

Extraction

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

The data exists. connects to the source and loads the data into . There are 3 methods:

N/A


Extraction

Perform full data extraction from relevant tables in the source

system(s).
  • Perform extraction through the application layer.
  • Only if ; cannot connect to the source, data is loaded to the repository from the provided source system extract/report.
  • 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 systems into Syniti Migrate. There will be no relevancy criteria is applied to the extracted records to identify the records that are , 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 data with Cost Element Groups with exception of some fields which require transformation as mentioned in the transformation rule.

    DCT Rules- 1 for Cost Element Groups with English language

    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-LANGULanguage key
    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 NameThis refers to the lowest set ID name in the hierarchy
    SETLEAF-VALFROMFrom ValueCost Elements assignment from a single value or range
    SETLEAF-VALTOTo ValueCost Elements assignment to

    DCT - 2 for Cost Element Groups descriptions will be collected on multiple languages (Other than English), hence a separate DCT will be used

    SETHEADERSETNAMESet NameBusiness to enter content as per data type and length permitted
    SETHEADERTLANGULanguage KeyBusiness to enter content as per data type and length permitted
    SETHEADERTDESCRIPTDescriptionBusiness to enter content as per data type and length permitted

    Extraction Dependencies

    Item #Step DescriptionTeam Responsible
    N/A


    Transformation

    The To prepare the data for Target, the Target fields are mapped to the applicable corresponding 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:(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. 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
    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
    1DCTTKA01KOKRSControlling AreaSAP S/4HANATKA01KOKRSControlling Area1:1
    2DCTSETHEADERSETCLASSSet ClassSAP S/4HANASETHEADERSECLASSSet ClassConstant value: '0102'
    3DCTSETHEADERSUBCLASSOrganizational Unit as Set SubclassSAP S/4HANASETHEADERSUBCLASSOrganizational Unit as Set SubclassSystem generates value in the background
    4DCTSETHEADERSETNAMESet NameSAP S/4HANASETHEADERSETNAMESet NameDirect mapping from DCT
    5DCTSETHEADERTLANGULanguage KeySAP S/4HANASETHEADERTLANGULanguage KeyDirect mapping from DCT
    6DCTSETHEADERTDESCRIPTShort Description of a SetSAP S/4HANASETHEADERTDESCRIPTShort Description of a SetDirect mapping from DCT
    7DCTSETNODELINEIDSet LineSAP S/4HANASETNODELINEIDSet LineDirect mapping from DCT
    8DCTSETNODESETNAMESet NameSAP S/4HANASETNODESETNAMESet NameDirect mapping from DCT
    9DCTSETNODESUBSETNAMESubordinate Set IDSAP S/4HANASETNODESUBSETNAMESubordinate Set IDDirect mapping from DCT
    10DCTSETLEAFSETNAMESet NameSAP S/4HANASETLEAFSETNAMESet NameDirect mapping from DCT
    11DCTSETLEAFVALFROMFrom ValueSAP S/4HANASETLEAFVALFROMFrom ValueDirect mapping from DCT
    12DCTSETLEAFVALTOTo ValueSAP S/4HANASETLEAFVALTOTo ValueDirect mapping 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 or product , for this object, the load file if the load must be done manuallytool 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

    Sample DCT attached is for reference.

    View file
    nameDCT - R2R-1078 Cost Element Groups.xlsx
    height250

    Image Added

    Export-1 will be used to update the group information

    Export-1: E1BPSET_HIER

    GROUPNAMEHIERLEVELVALCOUNTDESCRIPT












     Export-2 will be used to update the values in conjunction with the hierarchies

    Export-2: E1BP1113_VALUES
    VALFROMVALTO






    Export-3 will be used to update the descriptions of the Hierarchy for different languages

    <SETHEADER-SETNAME>

    <SETHEADER-LANGU>

    <SETHEADER-DESCRIPT>

    <SETHEADER-SETNAME>

    <SETHEADER-LANGU>

    <SETHEADER-DESCRIPT>

    <SETHEADER-SETNAME>

    <SETHEADER-LANGU>

    <SETHEADER-DESCRIPT>

    Note: actual load format and fields will be finalized during the design.

    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
    1067GL Account Operational COA (Incl. Secondary CElist 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
    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 in scope based on data design and any exception requested by business.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
    • LSMW load method will be finalized during the design phase


    See also

    Change log

    Change History
    limit10