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 Para

 

Stakeholders

Purpose

The purpose of this document is to define the conversion approach of activity types into S4HANA. Activity types describe the activity produced in a cost centre within a controlling area. At SyWay, activity types are used to quantify the cost of the services that a department provides to other areas or to production orders, projects or activities in manufacturing, research and development, IT projects etc.

The scope of this conversion spec refers to the migration of Activity types into S/4HANA system. 

Conversion Scope

The scope of this document covers the approach for creating a new Activity Types into S/4HANA following the MDS DD-FUN-050 Master Data Standard_1071-Activity Types, which will be listed as part of scope list with new numbering will be in scope of migration. This object's conversion from source to target is an approved DCT document. Therefore, relevancy rules are not applicable for this object as it uses DCT approach with full construct design.

List of source systems and approximate number of records. Note: Target records are expected to be lower after finalization of the design.List of source systems and approximate number of records 

SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2Activity Types8994S/4HANATBA~ 2570 ~
WP2Activity Types1099S/4HANATBA~ 350 ~

Additional Information

Multi-language Requirement

Activity Types will primarily be managed in English. However, other language requirements were not confirmed while developing this document, according to KDD055, this master data standard will be implemented in 4 core languages. 

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

 Note: Other language requirements were not finalized while developing this document, refer to Jira ID # PDM 604.

Document Management

N/A

Legal Requirement

N/A

Special Requirements

N/A

Target Design

The technical design of the target for this conversion approach. 

Table

Field

Data Element

Field Description

Data Type

Length

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.

CSLAKOKRSKOKRSControlling AreaCHARR
CSLALSTARLSTARActivity TypeCHAR6R
CSLADATABDATABValid-from DateDateDATE8R
CSLADATBIDATBIValid-to DateDateDATE8R
CSLALANGULANGULanguage in Which Texts Are SavedCHAR80    O
CSLTKTEXTKTEXTNameCHAR20    R
CSLACSLTLTEXTLTEXTDescriptionCHAR40    R
CSLALEINH_ISOLEINH_ISOActivity Unit (ISO Format)UNIT3     R
CSLALATYPLATYPActivity Type CategoryCHAR1R
CSLALATYPILATYPIVariant Activity Type CategoryCHAR1O
CSLAKSTTYKSTTYValid Cost Centre CategoriesCHAR8     R
CSLAAUSEH_ISOAUSEH_ISOOutput Unit (ISO Format)UNIT3     O
CSLAAUSFKAUSFKOutput FactorDEC5     O
CSLAVKSTAVKSTAAllocation Cost ElementCHAR10    C
CSLASPRKZSPRKZLock IndicatorCHAR1     O
CSLAFIXVOFIXVOPredistribution of Fixed CostsCHAR1     O
CSLATARKZTARKZPrice IndicatorCHAR3     O
CSLAYRATEYRATEPrice Calc. w. Period-Based Avg. PricesCHAR1     O
CSLATARKZ_ICO_TARKZ_IActual Price IndicatorCHAR3     O
CSLAMANISTCO_MANISTActual Quantity SetCHAR1     O
CSLAMANPLANCO_MANPLANPlan Quantity SetCHAR1     O


Data Cleansing

Data Cleansing is not relevant for this object because the entire Activity types will be afresh designed in S/4HANA. If any cleansing is deemed necessary, it will be performed outside of the system, as a result, the cleansed Activity Types will be populated directly in the Data Collection Template (DCT).

Report

ID

Criticality


Error Message/Report Description

Rule

Output

Source System

N/A

Can load, but business process will fail

Lock any Activity Type not being used for last 5 years

TBD

PF2 / PI2 / WP2

Conversion Process 

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

Image Removed

Data Privacy and Sensitivity

Extraction

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







Conversion Process 

Although source extraction is planned, no relevancy or extraction rules are implemented. The Data team will collect the new Activity Types manually in the DCT to support the To-Be design, and an ETL process will be followed to the Target loads.

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.

  1. Syniti Migrate connects to the sources.
  2. An initial extract of the relevant Activity Types will be made available to assist business with any standardization.

Extraction Run Sheet

Req #

Requirement description

Team responsible

1.      

The new Activity Types will be collected using the Data Collection Template (DCT)

R2R 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 Activity Types with exception of some fields which require transformation as mentioned in the transformation rule.

DCT - 1 for Activity Types with English language


Table & Field Name

Field description

Rule

CSLA - KOKRSControlling Area

Defaults to 'XXXX' (XXXX will be finalized after config item)

CSLA - LSTAR

Activity Types


CSLA - DATABValid-from Date

First Day of fiscal period when the activity type is created

CSLA - DATBIValid-to Date

Set to be '31.12.9999'

CSLA - LANGULanguage in Which Texts Are Saved


CSLT - KTEXTName


CSLT - LTEXTDescription


CSLA - LEINHActivity Unit (ISO Format)


CSLA - LATYPActivity Type Category

Set to be '3'

CSLA - LATYPIVariant Activity Type Category

Set to be '2'

CSLA - KSTTYValid Cost Centre Categories


CSLA - AUSEHOutput Unit (ISO Format)


CSLA - AUSFKOutput Factor


CSLA - VKSTAAllocation Cost Element

Choose an appropriate secondary cost element, there will be a relationship of 1:1 in between the activity type and the secondary cost element

CSLA - SPRKZLock Indicator


CSLA - FIXVOPredistribution of Fixed Costs


CSLA - TARKZPrice Indicator

Set to be '1'

CSLA - YRATEPrice Calc. w. Period-Based Avg. Prices


CSLA - TARKZ_IActual Price Indicator

Set to be '5'

CSLA - MANISTActual Quantity Set


CSLA - MANPLANPlan Quantity Set


DCT - 2 for Activity Types that use a language other than English. Activity types with Descriptions will be collected in multiple languages, hence a separate DCT will be used

Field Name

Field description

Rule
CSLT-KOKRSControlling AreaDefaults to 'XXXX' (XXXX will be finalized after config item)
CSLT - LSTARActivity Types
CSLT - SPRASLanguage KeyInput Language Key, ex: If Chinese, CN
CSLT-DATBIValid toSet to be '31.12.9999'
CSLT - KTEXTNameEnter content as per data type and length permitted
CSLT - LTEXTDescriptionEnter content as per data type and length permitted

Extraction Dependencies

Item #

Step description

Team responsible

N/A  



Transformation

To prepare the data for Target, the Target fields are mapped to the corresponding Legacy field (DCT will be the source for this object) 

  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 description

Team responsible

1.      

Obtain DCT Sign-off from Business

R2R Data Team

2.      

Generate Load Files

R2R Data Team

3.      

Monitor the transformation progress and ensure that performance and completion are within the allowed timelines

R2R Data Team

4.      

Review and Validate Error and Preload Reports

R2R Data Team

5.      

Log defects for any kind of errors and address resolution

R2R Data Team

6.      

Re-transform the pre-load files, validate and ready for load (This step is applicable If step 5 is active, else No)

R2R Data Team

7.      

Proceed for final loads

R2R Data Team

Transformation Rules

Rule #
  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 Activity Types 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 Name

Field description

Rule

CEPC-PRCTR

Activity Type

Business to enter content as per data type and length permitted

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 ECC 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. ECC 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
1ECCDCTCSSLCSLAKOKRSControlling AreaS4HANAS/4HANACSSLCSLAKOKRSControlling AreaDefault to 'XXXX'
2ECCDCTCSSLCSLALSTARActivity TypeS4HANAS/4HANACSSLCSLALSTARActivity TypeDirect mapping from DCT
3ECCDCTCSSLCSLADATABValid-from DateS4HANAS/4HANACSSLCSLADATABValid-from DateDirect mapping from DCT
4ECCDCTCSSLCSLADATBIValid-to DateS4HANAS/4HANACSSLCSLADATBIValid-to DateSet to '31.12.9999'
5ECCDCTCSSLCSLALANGULanguage in Which Texts Are SavedS4HANAS/4HANACSSLCSLALANGULanguage in Which Texts Are SavedDirect mapping from DCT
6ECCDCTCSSLCSLTNAMEKTEXTNameS4HANAS/4HANACSSLCSLTNAMENameDirect mapping from DCT
7ECCDCTCSSLCSLTLTEXTDescriptionS4HANAS/4HANACSSLCSLTLTEXTDescriptionDirect mapping from DCT
8ECCDCTCSSLCSLALEINH_ISOActivity Unit (ISO Format)S4HANAS/4HANACSSLCSLALEINH_ISOActivity Unit (ISO Format)Direct mapping from DCT
9ECCDCTCSSLCSLALATYPActivity Type CategoryS4HANAS/4HANACSSLCSLALATYPActivity Type CategoryDirect mapping from DCT
10ECCDCTCSSLCSLALATYPIVariant Activity Type CategoryS4HANAS/4HANACSSLCSLALATYPIVariant Activity Type CategoryDirect mapping from DCT
11ECCDCTCSSLCSLAKSTTYValid Cost Center CategoriesS4HANAS/4HANACSSLCSLAKSTTYValid Cost Center CategoriesDirect mapping from DCT
12ECCDCTCSSLCSLAAUSEH_ISOOutput Unit (ISO Format)S4HANAS/4HANACSSLCSLAAUSEH_ISOOutput Unit (ISO Format)Direct mapping from DCT
13ECCDCTCSSLCSLAAUSFKOutput FactorS4HANAS/4HANACSSLCSLAAUSFKOutput FactorDirect mapping from DCT
14ECCDCTCSSLCSLAVKSTAAllocation Cost ElementS4HANAS/4HANACSSLCSLAVKSTAAllocation Cost ElementDirect mapping from DCT
15ECCDCTCSSLCSLASPRKZLock IndicatorS4HANAS/4HANACSSLCSLASPRKZLock IndicatorDirect mapping from DCT
16ECCDCTCSSLCSLAFIXVORedistribution of Fixed CostsS4HANAS/4HANACSSLCSLAFIXVORedistribution of Fixed CostsDirect mapping from DCT
17ECCDCTCSSLCSLATARKZPrice IndicatorS4HANAS/4HANACSSLCSLATARKZPrice IndicatorDirect mapping from DCT
18ECCDCTCSSLCSLAYRATEPrice Calc. w. Period-Based Avg. PricesS4HANAS/4HANACSSLCSLAYRATEPrice Calc. w. Period-Based Avg. PricesDirect mapping from DCT
19ECCDCTCSSLCSLATARKZ_IActual Price IndicatorS4HANAS/4HANACSSLCSLATARKZ_IActual Price IndicatorDirect mapping from DCT
20ECCDCTCSSLCSLAMANISTActual Quantity SetS4HANAS/4HANACSSLCSLAMANISTActual Quantity SetDirect mapping from DCT
21ECCDCTCSSLCSLAMANPLANPlan Quantity SetS4HANAS/4HANACSSLCSLAMANPLANPlan Quantity SetDirect mapping from DCT

Transformation Mapping

Mapping Table Name

Mapping Table Description

Activity Type

Mapping of ECC Profit Center to target system value

Person Responsible

Mapping of ECC Person Responsible to New Person Responsible

User ID

Mapping of ECC User ID

Types

Old to New Activity Types

Hierarchy Group

Mapping of ECC 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 TeamDCT completenessR2R Data Team
2

Value Mappings are according to the target design in

2

Ensure Activity Type hierarchies are loaded into target S/4HANA

R2R Data Team


Pre-Load Validation

Project Team

Completeness


Task

Action

Generation of
Pre-load reports

Mandatory field check.
Activity Types are mapped to new values

Activity Type Hierarchy Mapped to new values

Person Responsible / HR positions mapped to new values

Record Count

Confirm the record counts in preload summary report

Total Records: 

Valid Records:

Invalid Records:

Accuracy

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


Task

Action

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. Filed Length Checks
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

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 regionConfirm the Preload File contains all the records in scope of migration ( Based on list of Activity Types mapped from old to new ) 
Record CountBusiness Data Owner/s 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
AccuracyBusiness Data Owner/s to verify that all the data in the load table/file is accurate
Verify Activity Types are transformed accurately
as per endorsed transformation / mapping rules (and signed-off DCT data).

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

In ECC system, execute ECC tcode SE16N to display table to confirm copied fields are accurately copied. 

If any of the sum is different, raise defect and flag the relevant record as error.


Load

Activity types will be migrated using the SAP tool 'Migration Cockpit', Object: Activity Type used for this specific import. Migration template is attached as a reference.

1071_Source data for CO - Activity type.xml

view

Load

Loading of the activity types will be done using migration cockpit object for activity type

view-file
name1071_Source data for CO - Activity type (2).xml
height250
View file
name
Source data for CO - Activity type.xlsx
height250

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 Activity Type. i.e., SAP Migration Cockpit. 
  2. Once the data is 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) Data Validation 

Load Run Sheet


Generate post load reports in tool.

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 Activity Type Object using Migration Cockpit Object for Activity Type Upload

are obtained

R2R Data team5

2

Ensure the

load tools are transported into the correct tool instance

R2R Data team

3

Go to <Load tool>

R2R

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.

4

Load 1 or 2 records for "Activity Types" to validate if data is loaded successfully without errors

R2R Data team

5

Proceed with full load if step 4 is successful and validated

R2R Data team

6

Validate few records loaded by accessing standard transactions or tables from S/4HNA E.g. KL03 or FIORI: Manage Activity Types

R2R Data team

7

Generate post load report if step 4 is validated

R2R Data team


Load Phase and Dependencies

Pre-Cut over

Configuration

Item #

Configuration item

1.      

Controlling Area

2.      

Standard Hierarchy is Maintained

3.      

Currencies (currency keys, decimal places in currencies)Secondary Cost Elements

 Conversion Objects

Object #Preceding Object Conversion Approach
1067GL Account Operational COA (Incl. Secondary CE)N/A

Error Handling


Error type

Error description

Action taken

P

Posting period is blocked for posting

Review project / cutover plan and ensure posting periods can be opened for postings

Activity Type does not exist

Activity Type does not exist in company code

Ensure the Activity Type mapping is correct and or create the Activity Type if it is valid

Configuration

Invalid Secondary Cost Element

System provides opportunity to review the incorrectly populated data and these need to be analysed and corrected

Consult Functional team to expedite and fix the error in the system

Configuration

Invalid Cost Centre Categories

System provides opportunity to review the incorrectly populated data and these need to be analysed and corrected

Consult Functional team to expedite and fix the error in the system

Configuration

Invalid Activity Type Categories

System provides opportunity to review the incorrectly populated data and these need to be analysed and corrected

Consult 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

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

Post-load reports will have the same structure as the load file and some additional columns as required to facilitate the post load validation.

Leverage on tool to create a Post Load report that reports S/4HANA loaded records along with the ECC values side-by-side to allow for 100% check of all these fields in the shortest possible time.

Any mismatch will be reported under the Post Load - Error report.
TaskAction
Check values in key fields for accuracy
Conversion Accuracy

Verify that the Activity Types in target S/4 HANA are loaded correctly via load program and validate post load reports using standard t.code KL03 / KL13 or database tables CSLA 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
Spot checksBusiness should choose some Activity Types and perform comprehensive check of the fields in S/4 HANA
Conversion AccuracyVerify that the Cost Element Groups Activity Types in target S/4 HANA are loaded correctly via load program and validate post load reports using standard t.code KAH3 KL03 / KL13 or database tables SETHEADER, SETHEADERT, SETNODE and SETLEAF from CSLA / CSLT 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

Change log

Change History
limit10

Workflow history

Workflow Report
parent@self
hideheadertrue
typeapprovals