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

OwnerSoumen Laru
Stakeholders

Purpose

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

The document details out the field list, extraction criteria, scoping, mapping of cost centre object

  

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.Cost Centres will be extracted from Source and based on the list of cost centres from the cost centre mapping sheet, target cost centre data file will be 

Conversion Scope

Profit Centres 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 

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
NU
CEPCVERAK_USERVERAPC_USERUser Responsible for the Profit CenterCHAR12SAP user ID of the responsible person.
C
NU
CEPCWAERSWAERSCurrency KeyCUKY5Currency used in the Profit Center.
Will follow the legal entity one. 
R
NU
CEPCLAND1LAND1Country KeyCHAR3Country code related to the Profit Center's location.
O
C
CEPCNAME1NAME1_GPName 1CHAR35First line of the name or company name of the Profit Center.
Description of the Profit center. 
R
NU
CEPCNAME2NAME2_GPName 2CHAR35Second line of the name or company name.
O
NU
CEPCNAME3NAME3_GPName 3CHAR35Third line of the name or additional details.
O
NU
CEPCNAME4NAME4_GPName 4CHAR35Fourth line of the name or additional details.
O
NU
CEPCORT01ORT01_GPCityCHAR35City name in the Profit Center address.
O
C
CEPCORT02ORT02_GPDistrictCHAR35District or region in the address.
O
C
CEPCSTRASSTRAS_GPStreet and House NumberCHAR35Street name and house number of the Profit Center location.
O
NU
CEPCPFACHPFACHPO BoxCHAR10PO Box address.
O
NU
CEPCPSTLZPSTLZPostal CodeCHAR10Postal code for the street address.
O
NU
CEPCPSTL2PSTL2P.O. Box Postal CodeCHAR10Postal code associated with the PO Box.
O
NU
CEPCSPRASSPRASLanguage KeyLANG1Language key used in texts and descriptions.
O
R
CEPCTELBXTELBXTelebox numberCHAR15Telebox number (rarely used).
O
NU
CEPCTELF1TELF1First telephone numberCHAR16Primary contact phone number.
O
NU
CEPCTELF2TELF2Second telephone numberCHAR16Secondary contact phone number.
O
NU
CEPCTELFXTELFXFax NumberCHAR31Fax number.
O
NU
CEPCTELTXTELTXTeletex numberCHAR30Teletex number (obsolete).
O
NU
CEPCTELX1TELX1Telex numberCHAR30Telex number (obsolete).
O
NU
CEPCKHINRPHINRProfit center areaCHAR12Profit center areaNU
CEPCBUKRSBUKRSCompany CodeCHAR4Associated company code for reporting.
O
NU
CEPCTXJCDTXJCDTax JurisdictionCHAR15Tax jurisdiction code used for tax reporting.
C
NU
CEPCREGIOREGIORegion (State, Province, County)CHAR3State or regional subdivision (used in address).
O
NU
CEPCLOCK_INDLOCK_INDLock indicatorCHAR1Indicates if the Profit Center is locked for processing.
If locked : no posting possible.
C
CEPCT
CEPCCEPCTKTEXTKTEXTName#N/A
KTEXT
PCA_TEMPLATEPCA_TEMPLATETemplate for Formula Planning in Profit CentersCHAR10Reference template used for planning purposes in Profit Centers.C
KTEXTNameCHAR
20Profit Center NameR
CEPCTLTEXTLTEXT Long Text
#N/A
CHAR40Profit Center Long TextR
CEPCTMCTXTMCTXTProfit Center Text
#N/A
CHAR20Profit Center Text
O
R


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. 

Criticality

Report

ID

Error Message/Report Description

Rule

ID

Criticality


Error Message/Report Description

Rule

Output

Source System

1.      

Can load, but business process will fail

Lock any Profit Centre not being used for last 5 years

TBD

PF2 / WP2

Note: Cleansing mau not be necessary as the ex

N/A 







Conversion Process 

The high-level

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

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

  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 Profit Centres 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

 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
CEPCLAND1Country KeyCollected as required
CEPCORT01CityCollected as required
CEPCORT02DistrictCollected as required
CEPCSPRASLanguage KeyCollected as required
CEPCKHINRProfit center areaCollected 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
8DCT/ECCCEPCLAND1Country KeyS/4HANACEPCLAND1Country KeyCopy From DCT as-is
13DCT/ECCCEPCORT01CityS/4HANACEPCORT01CityCopy From DCT as-is
14DCT/ECCCEPCORT02DistrictS/4HANACEPCORT02DistrictCopy From DCT as-is
19DCT/ECCCEPCSPRASLanguage KeyS/4HANACEPCSPRASLanguage KeyCopy From DCT as-is
27DCT/ECCCEPCKHINRProfit center areaS/4HANACEPCKHINRProfit center areaCopy From DCT as-is 
30DCT/ECCCEPCLOCK_INDLock indicatorS/4HANACEPCLOCK_INDLock indicator

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

Profit Centre

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 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:

  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 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 CenterApply Mapping of Employee 
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 CodeCompany Code Mapping File to be used 
27DCT/ECCCEPCTXJCDTax JurisdictionS/4HANACEPCTXJCDTax JurisdictionCopy From DCT as-is
28DCT/ECCCEPCREGIORegion (State, Province, County)S/4HANACEPCREGIORegion (State, Province, County)Copy From DCT as-is
29DCT/ECCCEPCLOCK_INDLock indicatorS/4HANACEPCLOCK_INDLock indicatorCopy From DCT as-is
30DCT/ECCCEPCPCA_TEMPLATETemplate for Formula Planning in Profit CentersS/4HANACEPCPCA_TEMPLATETemplate for Formula Planning in Profit CentersCopy From DCT as-is
31DCT/ECCCEPCTKTEXTNameS/4HANACEPCTKTEXTNameCopy From DCT as-is
32DCT/ECCCEPCTLTEXT Long TextS/4HANACEPCTLTEXT Long 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

Profit Centre

Mapping of legacy Profit Center to target system value

Person Responsible

Mapping of legacy Person Responsible to New Person Responsible

User ID

Mapping of legacy User ID

Hierarchy Group

N/A

Mapping of Legacy 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.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 are mapped to new valuesnot blank
  • Profit Centre Hierarchy Mapped to new valuesnot blank
  • Person Responsible / HR positions mapped to new valuesCompany Code is mapped based on Company Code Mappingnot blank

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

  • Total Records: To be Filled in Summary Report
  • Valid Records: To be Filled in Summary Report
  • Invalid Records: To be Filled in Summary 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

    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

    TaskActionVerify 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

    TaskActionConversion 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.

    In legacy system, execute ECC tcode SE16N to display table CEPC to confirm copied fields are accurately copied. ( If applicable)

    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. 

    View file
    nameSource data for CO - Profit center (2).xml
    height250
    View file
    nameSource data for CO - Profit center.xlsx
    height250

    Load


    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_ECCDCT, XXXX_S4HANA, XXXX_MATCH 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) 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

    Change History
    limit10

    Workflow history

    Workflow Report
    parent@self
    hideheadertrue
    typeapprovals