Status

OwnerSoumen Laru
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to migrate TB PY in S/4 HANA. This is the opening balance of FY '26 ( for Group 1 ) or  opening balance of FY '27 ( for group 2 )

Amounts in legacy involve document currency, local currency and group currency. All currencies will be loaded accordingly unless there is a change in company design where local / group currency changes. Rates are as per the historical postings unless specific requirement calls for a fixed rate eg. group currency rate for consolidation purposes. Offsetting gl accounts in legacy documents will not be considered in this migration scope, they will be migrated in other objects scope eg. GL open item or GL balances.

Conversion Scope

The scope of this document covers the approach for converting active TB CY (Current year) from Legacy Source Systems into S/4HANA following the target design requirements.

As per the current plan, there are two go-lives - Group 1 and Group 2. 

  1. Group 1 goes live on 1st July 2028 : TB Migration scope for this group is 1.5 Years worth of Balance starting from Opening Balance from January-2027
  2. Group 2 goes live on 1st January 2029 : TB Migration scope for this group is 1.5 Years worth of Balance starting from Opening Balance from January-2028

Trial balance of January is the opening balance of the relevant fiscal year and will be migrated as the prior year closing balance. Thereafter, a carry forward of TB will be carried out by business after migration completion. In other words, migration posting date of the opening balance of January-2027 will be 31-12-2026 and migration posting date of the opening balance of January-2028 will be 31-12-2027.


List of source systems and approximate number of records 
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2TB PY
S4HANA
WP2TB PY
S4HANA

Additional Information

  • Balance Sheet migration strategy is different based on the below GL Types -

    • Non-Open item managed Balance Sheet Account

    • Open Item managed Balance Sheet Account

    • Reconciliation (Control) Accounts (including Inventory Account)


  • Balance Sheet Account balances will be migrated as a two-step process -

  • Opening Balance as on 31st December '26

  • Year to date movement - Migrate year to date movement for each month until 31st December '26 for Group 1 company codes and until 31st June for Group 2 countries. 


  • Balance of Reconciliation accounts, GL open item accounts and Inventory accounts will not be migrated against actual GL on 31st March/YTD. Instead, below take on account will be posted, and the actual account will be posted only on the cutover month end against subledger postings/open item postings.

    • ZZ00000001 (TBD)      GL Balance Take-On Account ( TB Migration Account )
    • ZZ00000002 (TBD)       Legacy GL Open Item offset Take on Account

    • ZZ00000003 (TBD)       Legacy Data AR Take on Account

    • ZZ00000004 (TBD)       Legacy Data AP Take on Account

    • ZZ00000005 (TBD)       Legacy Data Inventory Take on Account

    • ZZ00000006 (TBD)       Legacy Data Assets Take on Account

Following illustrations show how TB and Sub-Ledger Financial data migration will be carried out. 

AP Open Item migration with Respect to TB

GL Open Item Migration with Respect to TB

Inventory Stock migration with Respect to TB

Fixed Asset Migration with Respect to TB

WBS AUC Balance Migration With Respect to TB 

Multi-language Requirement

Summarize Multi-language Requirement/s, if any

Document Management

Summarize Document Management requirement, if any

Legal Requirement

Summarize Legal Requirement/s, if any

Special Requirements

Specify any special requirements or considerations that may impact the data conversion process based on specific locations, regulatory compliance or system limitations. Clearly outline any regional or localization requirements such as country-specific data formats, legal reporting obligations or industry standards that must be adhered to (e.g., localization rules for countries like China).

If the data conversion involves third-party systems or external data sources, such as Icertis, describe any additional requirements related to data mapping, transformation logic, validation rules or security measures that must be followed.


In ECC, parallel accounting was based on account approach.

e.g



Parallel accounting in target S4 is ledger based approach. In ledger-based approach assigns each principle to its own dedicated ledger with a 1:1 ratio between ledgers and principles.  The migration strategy typically involves a conversion from an existing classic G/L (often using the account approach) to the new G/L, then to S/4HANA.

for the same example above, migration to be done into local GAAP and IFRS ledger as below


Therefore, accounts as illustrated above need to be migrated through ledger-specific postings. (e.g FB01L instead of FB01). 

For the transfer of open items and Balance carryforward, the following applies:

  • You can only manage open items in common accounts because the transfer of open items always applies to all ledgers and is not specific to individual ledgers.

  • You have to transfer balances carried forward for individual ledgers, that is

    • Common accounts to all ledgers

    • Valuation-specific (parallel) accounts to the respective ledgers. 


A list of accounts to be identified for which IFRS GAAP to be posted against directly using IFRS ledger selection like done in tcode FB01L. 

Target Design

With Functional input, document the technical design of the target fields that are in the scope of this document.

The technical design of the target for this conversion approach. 

Table

Field

Data Element

Field Description

Data Type

Length (Decimals)

Requirement

ACDOCABUKRSBUKRSCompany CodeCHAR30    

Mandatory

Note: More details described in the Transformation Rules

ACDOCALDGRPLDGRPLedger GroupCHAR30    

Mandatory

Note: More details described in the Transformation Rules

ACDOCAXBLNRXBLNRReference Document NumberCHAR16    

Optional

Note: More details described in the Transformation Rules

ACDOCADOCLNDOCLNLine Item NumberNumber6     

Mandatory

Note: More details described in the Transformation Rules

ACDOCAHKONTHKONTG/L AccountCHAR30    

Mandatory

Note: More details described in the Transformation Rules

ACDOCAGKONTGKONTOffsetting AccountCHAR80    

Mandatory

Note: More details described in the Transformation Rules

ACDOCABLARTBLARTDocument TypeCHAR80    

Mandatory

Note: More details described in the Transformation Rules

ACDOCABUDATBUDATPosting DateDate

Mandatory

Note: More details described in the Transformation Rules

ACDOCABLDATBLDATDocument DateDate

Mandatory

Note: More details described in the Transformation Rules

ACDOCAWWERTWWERTTranslation DateDate

Optional

Note: More details described in the Transformation Rules

ACDOCAACC_PRINCIPLEACC_PRINCIPLEAccounting PrincipleCHAR80    

Optional

Note: More details described in the Transformation Rules

ACDOCABKTXTBKTXTHeader TextCHAR25    

Mandatory

Note: More details described in the Transformation Rules

ACDOCASGTXTSGTXTItem TextCHAR50    

Mandatory

Note: More details described in the Transformation Rules

ACDOCAWAERSWAERSTransaction CurrencyCHAR80    

Mandatory

Note: More details described in the Transformation Rules

ACDOCAWRBTRWRBTRAmountNumber23    

Mandatory

Note: More details described in the Transformation Rules

ACDOCAHWAERHWAERCompany Code CurrencyCHAR80    

Mandatory

Note: More details described in the Transformation Rules

ACDOCADMBTRDMBTRAmountNumber23    

Mandatory

Note: More details described in the Transformation Rules

ACDOCAHWAE2HWAE2Group CurrencyCHAR80    

Mandatory

Note: More details described in the Transformation Rules

ACDOCADMBE2DMBE2AmountNumber23    

Mandatory

Note: More details described in the Transformation Rules

ACDOCAHWAE3HWAE3Freely Defined CurrencyCHAR80    

Mandatory

Note: More details described in the Transformation Rules

ACDOCADMBE3DMBE3AmountNumber23    

Optional

Note: More details described in the Transformation Rules

ACDOCARASSCRASSCCompany ID of Trading PartnerCHAR80    

Optional

Note: More details described in the Transformation Rules

ACDOCAZUONRZUONRAssignment NumberCHAR18    

Mandatory

Note: More details described in the Transformation Rules

ACDOCARMVCTRMVCTTransaction TypeCHAR80    

Optional

Note: More details described in the Transformation Rules

ACDOCAPERNRPERNRPersonnel Number of EmployeeCHAR80    

Optional

Note: More details described in the Transformation Rules

ACDOCAVALUTVALUTValue DateDate

Optional

Note: More details described in the Transformation Rules

ACDOCAHBKIDHBKIDShort Key for House BankCHAR80    

Optional

Note: More details described in the Transformation Rules

ACDOCAHKTIDHKTIDID for Account DetailsCHAR80    

Optional

Note: More details described in the Transformation Rules

ACDOCAKOSTLKOSTLCost CenterCHAR80    

Conditional

Note: More details described in the Transformation Rules

ACDOCAPRCTRPRCTRProfit CenterCHAR80    

Conditional

Note: More details described in the Transformation Rules

ACDOCAFB_SEGMENTFB_SEGMENTSegmentCHAR80    

Optional

Note: More details described in the Transformation Rules

ACDOCAPSPNRPSPNRWBS ElementCHAR80    

Optional

Note: More details described in the Transformation Rules

ACDOCAAUFNRAUFNROrder NumberCHAR80    

Optional

Note: More details described in the Transformation Rules



Data Cleansing

All data cleansing should take place in the data source system as defined in this document, unless system limitations prevent it.

If data cleansing is managed outside of the source system (e.g. Syniti Migrate, 3rd Party Vendor, DCT), the necessary documentation must be produced and appended to this deliverable for sign-off.


ID

Criticality


Error Message/Report Description

Rule

Output

Source System

TBD






Conversion Process 

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

Summarize High-Level Process. Include diagrams, where applicable. Include information supporting details of Extract, Transform and Load specific to the Data Object

Data Privacy and Sensitivity

Summarize Data Privacy and Sensitivity Requirements, if any


Extraction

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

  1. The data exists. Syniti Migrate connects to the source and loads the data into Syniti Migrate. 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 Syniti Migrate; 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 Syniti MigrateThis is to be conducted using DCT (Data Collection Template) in Syniti Migrate

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 GLPCT, GLT0, COEP are extracted in tool according to the agreed cut-off date in the project plan

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

If applicable, this section will give the details on any selection screen parameters, including the parameter type, that are required to be entered to ensure consistent data extracts.
Selection Ref ScreenParameter NameSelection TypeRequirementValue to be entered/set





















Data Collection Template (DCT)

Target Ready Data Collection Template will be created for Data Object data with exception of some fields which require transformation as mentioned in the transformation rule.

<Object> DCT Rules

DCT is not applicable


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

List the steps that need to occur before extraction can commence


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 Syniti Migrate 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 Syniti Migrate
  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

Note: 

Periodic balances of GL Accounts to be read from GLPCT/GLT0.

Note: for Each GL balance in scope of migration, an offset line to be created with the same GL Account. 

For the Field mapping transformation rules, wherever Rule 1 and Rule 2 denoted in the transformation logic column, please note that Rule 1 applies to main line ( GL Balance line ) and Rule 2 applies to offset line.

Rule #

Source system

Source Table

Source Field

Source description

Target system

Target Table

Target Field

Target description

Transformation logic


1ECCBKPFBUKRSCompany CodeS/4HANAACDOCABUKRSCompany CodeMap Company Code from ECC to S4
2ECCBSISLDGRPLedger GroupS/4HANAACDOCALDGRPLedger GroupTo Be kept Blank
3ECCBSISXBLNRReference Document NumberS/4HANAACDOCAXBLNRReference Document NumberCopy as is
4ECCBSISDOCLNLine Item NumberS/4HANAACDOCADOCLNLine Item NumberCopy as is
5ECCBSISHKONTG/L AccountS/4HANAACDOCAHKONTG/L Account

Map Old GL Account to new GL Account

Note: For each Sub-ledger Accounts ( Fixed Asset, Customer, Vendor, GR/IR Open items, Inventory Accounts), standard mapping to be replaced with Take-on Accounts.  In the GL Account Mapping File, additional target mapping will be given to contain take-on account.

6ECCBSISGKONTOffsetting AccountS/4HANAACDOCAGKONTOffsetting AccountDefault to Migration GL Open Item Account. 
7ECCBKPFBLARTDocument TypeS/4HANAACDOCABLARTDocument TypeDefault to 'UE'
8ECCBKPFBLDATDocument DateS/4HANAACDOCABLDATDocument DateCopy as is
9ECCBSISWWERTTranslation DateS/4HANAACDOCAWWERTTranslation DateNot used
10ECCBSISACC_PRINCIPLEAccounting PrincipleS/4HANAACDOCAACC_PRINCIPLEAccounting PrincipleNot used
11ECCBKPFBKTXTHeader TextS/4HANAACDOCABKTXTHeader Text

Rule 1: Copy as is, for the Open item line 

Rule 2: Company Code ( BUKRS ), Fiscal Period( to be derived from ledger table) and Legacy GL Account

12ECCBSISSGTXTItem TextS/4HANAACDOCASGTXTItem TextCopy as is
13ECCBSISWAERSTransaction CurrencyS/4HANAACDOCAWAERSTransaction CurrencyCopy as is
14ECCBSISWRBTRAmountS/4HANAACDOCAWRBTR/TSLAmount

This is for currency type 00

Rule 1: Copy as is with Signage as '-' if the posting key is 50 or else '+'


Rule 2:  for offset line, please make the amount from debit to credit , credit to debit and apply above logic.

15ECCBSISHWAERCompany Code CurrencyS/4HANAACDOCAHWAERCompany Code CurrencyAutomatic
16ECCBSISDMBTRAmountS/4HANAACDOCADMBTR/HSLAmount

This is for currency type 10

Rule 1: Copy as is with Signage as '-' if the posting key is 50 or else '+'


Rule 2:  for offset line, please make the amount from debit to credit , credit to debit and apply above logic.

17ECCBSISHWAE2Group CurrencyS/4HANAACDOCAHWAE2Group CurrencyAutomatic ( TBD )
18ECCBSISDMBE2AmountS/4HANAACDOCADMBE2/KSLAmount

Group Currency 2

This is for currency type 30 ( Global currency / Group currency )

Note: Currently, legacy does not have group currency amount, the plan is let exchange to populate this.

Rule 1: Copy as is with Signage as '-' if the posting key is 50 or else '+'


Rule 2:  for offset line, please make the amount from debit to credit , credit to debit and apply above logic.

19ECCBSISHWAE3Freely Defined CurrencyS/4HANAACDOCAHWAE3Freely Defined CurrencyAutomatic
20ECCBSISDMBE3AmountS/4HANAACDOCADMBE3/VSLAmount

Group Currency 2

This is for currency type 31 ( Freely Defined currency type 2 )

Note: Currently, legacy does not have group currency amount, This is yet to be confirmed as to how this will be derived,

Rule 1: Copy as is with Signage as '-' if the posting key is 50 or else '+'


Rule 2:  for offset line, please make the amount from debit to credit , credit to debit and apply above logic.

21ECCBSISRASSCCompany ID of Trading PartnerS/4HANAACDOCARASSCCompany ID of Trading PartnerCopy as is
22ECCBSISZUONRAssignment NumberS/4HANAACDOCAZUONRAssignment Number

to be kept empty

23ECCBSISRMVCTTransaction TypeS/4HANAACDOCARMVCTTransaction Typeto be kept empty
25ECCBSISVALUTValue DateS/4HANAACDOCAVALUTValue Dateto be kept empty
26ECCBSISHBKIDShort Key for House BankS/4HANAACDOCAHBKIDShort Key for House Bankto be kept empty
27ECCBSISHKTIDID for Account DetailsS/4HANAACDOCAHKTIDID for Account Detailsto be kept empty
28ECCBSISKOSTLCost CenterS/4HANAACDOCAKOSTLCost CenterMap Old Cost Centre to New Cost Centre
29ECCBSISPRCTRProfit CenterS/4HANAACDOCAPRCTRProfit CenterMap Old Profit Centre to New Profit Centre
30ECCBSISFB_SEGMENTSegmentS/4HANAACDOCAFB_SEGMENTSegmentto be kept empty
31ECCBSISPSPNRWBS ElementS/4HANAACDOCAPSPNRWBS Elementto be kept empty
32ECCBSISAUFNROrder NumberS/4HANAACDOCAAUFNROrder Numberto be kept empty

How to derive profit centres for various GL balance components: 

  1. Inventory Balance Take-on Account:
    1. PF2:
      1. Stock balance data will be derived and structured at the profit centre level to ensure alignment with the target S/4HANA organisational structure.
      2. This dataset will provide stock balances at the material and plant level, which in turn will be mapped to the corresponding profit centres based on the material–plant–company code–profit centre mapping logic.
      3. The same distribution key (comprising Company Code, Profit Centre, and Stock Balance) will be applied to allocate the stock-related take-on GL account balances, derived from the source ECC GL balance data, ensuring accurate and consistent inventory take-on balances at the profit centre level.
    2. WP2:
      1. Stock balance data will be derived and structured at the profit centre level to ensure alignment with the target S/4HANA organisational structure.
      2. This dataset will provide stock balances at the material and plant level, which in turn will be mapped to the corresponding profit centres based on the material–plant–company code–profit centre mapping logic.
      3. The same distribution key (comprising Company Code, Profit Centre, and Stock Balance) will be applied to allocate the stock-related take-on GL account balances, derived from the source ECC GL balance data, ensuring accurate and consistent inventory take-on balances at the profit centre level.

Transformation Mapping

Use the exact name and reference this section in the “Transformation rules” above

Mapping Table Name

Mapping Table Description

Company Code

Mapping of legacy company codes to target system value

GL Account

Mapping of legacy GL accounts to target system value

Profit Centre

Mapping of legacy Profit Center to target system value

Business Partner

Mapping of legacy vendor accounts to target system value

Trading Partner

Mapping of legacy trading partners to target system value

Currency Key

Mapping of legacy currency keys to target system value

Special G/L Indicator

Mapping of legacy special GL indicator to target system value

Payment Block Key

Mapping of legacy payment block key to target system value

Payment Method

Mapping of legacy payment method to target system value

Open Purchase order cross references

Mapping of legacy PO to target system value

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 team




Pre-Load Validation

Project Team

The following pre-load validations will be performed by the Project Team.

Completeness


Task

Action

Generation of
Pre-load reports

Mandatory field check.
Based on S/4HANA target design fields, account field status groups and tax settings

Check if records have all mandatory fields filled and mapped, otherwise they should be flagged as error.


Check GL Accounts are extended to required company code

Field combination of SAKNR and BUKRS to be checked against SKB1.

Cost-Centre Validity Period

Check KOSTL against CSKS-DATBI>= Cut-Over Date ( Parameter Based )

Check signage of amount.

  1. Sum of total balance of combination fields BUKRS, SAKNR, PRCTR and KOSTL is zero for each currency types ( WRBTR, DMBTR, DMBE2 and DMBE3 ) 
  2. Total balance of All the accounts for each BUKRS is zero.

Reconciliation of total

Record Summation 

Check the sum of record count of the TB Balance ( PY )  in the load file is the same as source. The record count for TB Balance ( PY )  will be done on the group basis. The fields in the group are consist of: Company Code, GL Account, Profit Centre

Check Amount in Document Currency and Local Currency

Check the sum of the amount in Document Currency and Local Currency in load file is the same as source. If any of the sum is different, flag the record as error.


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. 
Review the data report to ensure mapping value is not missing in tool.
Capture errors in the Data Error report.



Business

The following pre-load validations will be performed by the business.

Completeness

TaskAction
Verify record count in Pre-load reports by region

In legacy system, execute report AP Line Item Display (t/code: FS10N ) with selection parameters stated in section 7.2. 

Group the output of the report by Company Code, GL Account and Profit Centre using subtotal function and compare the count in this report against the TB Balance ( PY )  count in the pre-load file.

The record count for TB Balance ( PY )  may also be done on the more granular level. The recommended granular level or the subtotal fields can consist of: Company Code, Vendor, Profit Centre, Document Currency Key, Company ID for Trading Partner.

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


Accuracy

TaskAction
Conversion accuracy

Verify TB Lines 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 report Trial Balance Display (t/code: FS10N ) with selection parameters.

If any of the sum is different, raise defect and flag the relevant record as error.
Business partner balance on Company code and profit center levelCheck the total open item amount on Business partner at Company Code and Profit center level, against the total in legacy by Document, Local and Group currency. Apply currency rules where applicable


oad

The load process includes:

  1. Execute the automated data load into target system using load tool or product the load file if the load must be done manually
  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 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 tool Trial Balance 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

Identify the phase as to “when” the load for this object will occur. <Pre-Cutover, Cutover, Post Cutover> and list the steps that need to occur before the load can commence

Configuration

List the Configurations required before loading can commence 

Item #

Configuration item

1.      

Company code-related configuration (posting period variant).

2.      

Finance posting (document types, document number ranges, special gl indicator)

3.      

Currencies (currency keys, decimal places in currencies)

 Conversion Objects

Object #Preceding Object Conversion Approach
1067GL Account Operational CoA (incl. secondary CE)
1073Profit center

Error Handling

The table below depicts some possible system errors for this data object during data load.  All data load error is to be logged as defect and managed within the Defect Management


Error type

Error description

Action taken

Posting Period Error

Posting period is blocked for posting

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

Profit Centre does not exist

Profit centre does not exist in company code

Ensure the profit centre mapping is correct and or create the profit centre if it is valid


Post-Load Validation

Project Team

The following post-load validations will be performed by the Project Team.

Completeness

TaskAction
Reconciliation of Record Count

Total number of records loaded for TB Balance ( PY )  will be generated in the Post-load reports in tool based on the target table and fields mentioned in section 3.

The reconciliation needs to be executed on the total number of ‘valid’ records and currency amount per company code in the source compared to total number of records and currency amount in S/4HANA

Record Count

Check the sum of record count of the open items in the load file is the same as S/4HANA. The record count for TB Balance ( PY )  will be done on the group basis. The fields in the group are consist of: Company Code, Vendor Account

Check Amount in Document Currency and Local Currency

Check on line item level that the sum of the amount in Document Currency and Local Currency in the load file is the same as posted in S/4HANA. If any of the sum is different, flag the record as error.


Accuracy

TaskAction
Check values in key fields for 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 legacy 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.




Business

The following post-load validations will be performed by the business.

Completeness

TaskAction
Record Count Check

Review the record count report from the Data Team and ensure it is correct by cross-checking with the record count confirmed during Pre-load Business Validations


Business may also run transaction code FAGLB03 – or equivalent report in Fiori App to display loaded TB Balance ( PY )  in S/4HANA and compare results against the pre-load reports generated from tool.

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 checkBusiness should choose some business partners and perform comprehensive check of open items, payment terms etc Such partners should have huge number of open items or be critical for payment runs in S4 or have certain complexity in conversion.


Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load. 
  • Data Object is in scope based on data design and any exception requested by business.

Any additional key assumptions.



Change log

Workflow history