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

Compare with Current View Page History

« Previous Version 22 Next »

Status

20%

Owner
Stakeholders

Purpose

The purpose of this document is to define the conversion approach for RE-FX Contract and Lease Management (CLM) master data in SyWay S/4 HANA. 

The main object of RE-FX migration is Lease contract master data and conditions. Due to the technical structure of RE-FX, there are also several tightly connected migration objects such as Business Partners  (i.e., Vendors), Right of Use (RoU) Assets & their balances, GL Liability balances and Lease related Purchase Orders. The scope of this conversion specification is the Lease contract master records. Migration of Lease contracts are however dependent on the other objects mentioned above to migrate Lease contracts and their balances completely and accurately, hence the dependent objects are also identified in this conversion specification.

The data migration activities for RE-FX is going to be managed via an ETL approach defined in the data migration strategy

Group entities currently using SAP ECC shall use S/4 HANA CLM for IFRS 16 Lease Accounting in SyWay. S/4 HANA CLM provides a standardized framework, single source of truth and processes for a streamlined management of lease contracts across all Syensqo group entities directly in S/4 HANA.

Conversion Scope

The scope of this document covers the approach for converting active IFRS 16 Lease Contracts from Legacy Source Systems into S/4HANA following the DD-FUN-050 Master Data  Standard_1076-RE-FX Contract.xlsx Standard. The BPML process for RE-FX contracts will be followed as below

Level-1Level-2Level-3Level-4




9. Finance

9.5 Perform Transactional Accounting9.5.6 Perform Lease Accounting9.5.6.2 Manage Finance Lease Contracts
9.5.6.3 Manage Lease Contract Adjustments
9.5.6.4 Manage Lease Contract Terminations
9.7 Perform Financial Close9.7.1 Period-End Close9.7.1.11 Manage Real Estate Close
9.12 Perform Financial Reporting9.12.1 Perform Operational Reporting9.12.1.4 Perform Operational Reporting for Lease Accounting


The data from legacy system includes:

  1. IFRS 16 Lease-in and Lease-out contracts - Lease contract master data and Condition values
  2. Lease Liabilities - Short Term and Long Term Lease Liability Balances
  3. Accrued Lease Liability - Intermediatory Lease liability balance
  4. Business Partners - Vendor & Customer Business Partner master data with a specific RE-FX role
  5. Purchase Orders for Leases - Open POs with remaining Quantity

The data from legacy system excludes:

  1. Inactive Lease Contracts
  2. Deactivated ROU Assets
  3. Lease contracts will be ended as of go-live date


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx.

No. of Records

PF2RE-FX Lease Contracts (Lease-In and Lease-Out)1,781S/4 HANAWill be same as Source, unless any new contracts and/or deactivation before Go-live
WP2RE-FX Lease Contracts (Lease-In and Lease-Out)2,022S/4 HANAWill be same as Source, unless any new contracts and/or deactivation before Go-live

Additional Information

Multi-language Requirement

RE-FX Lease Contracts 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: Other language requirements were not finalized while developing this document, refer to Jira ID # PDM XXX.

Document Management

N/A

Legal Requirement

There are no legal requirements relevant to data migration of RE-FX Lease Contracts

Special Requirements

N/A

Target Design

The technical design of the target for this conversion approach.

TableFieldData ElementField DescriptionData TypeLengthRequirement
VICNCNBUKRS
Company CodeCHAR4Mandatory
VICNCNRECNNR
Contract NumberCHAR13Mandatory
VICNCNRECNTYPE
Contract TypeCHAR4Mandatory
VICNCNRECNTXT
Contract DescriptionCHAR80Optional
VICNCNRELEVANTEVAL
Valuation RelevanceCHAR10Optional
VICNCN

Purchasing Document


VICNCNRECNTXTOLD
Number of Old ContractCHAR20Optional
VICNCNRECNCNCURR
CurrencyCHAR5Optional
VICNCNKEY_ID
Line IDCHAR2Mandatory
VICNCNTERM_NO
Term NumberCHAR4Optional
VICNCNOBJTYPECN
Business Object Type of ContractCHAR2Optional
VICNCNOBJDCN
ID Part of Contract ObjectCHAR45Optional
VICNCNXCNSUBJECT
Name for Contract TermText60Optional
VICERULEACCTOBJNR
Account Assignment ObjectCHAR45Mandatory
VICERULECNSUBJECTTYPE
Type of Contract ObjectCHAR6Optional

















































































































Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System
DC-1Medium
Terminated or concluded lease contracts must be closed and all related postings need to be completed.Data cleansing to deactivate and exclude terminated or concluded contractsSAP ECC
DC-2Medium
Lease - Suspense account balances to be clearedThe balances are to be closed to 0 for any terminated or concluded contracts. Open items are to be cleared as much as possible.SAP ECC



Conversion Process

The high-level ETL process is illustrate by the diagram below. Note: DCT is not applicable for this object 1076. DCT is shown in table below, for reference only.

Process

Activity

Extract

Extract involves collecting data from the source.

The source is a SAP system, Extract means to pull the required data from source systems into repository using Syniti ADMM.  There are 2 steps for this method:

  1. Perform full data extraction from relevant RE-FX tables in the source system(s).
  2. Apply Relevancy criteria for filtering the data that will be applicable according to Target Design.

Transform

There are 2 steps of Transform activities that can happen in ADMM:

  1. Perform mapping and data transformation rules.  Some data will need to be mapped to the to-be values and/or updated according to the rules as per design requirement in target system.
  2. Prepare load-ready data in the structure and format that is required for loading via SAP Data Migration Cockpit or any other standard tool.  This step also produces the load data ready for business to perform Pre-load Data Validation.

Load

This process includes:

  1. Execute the automated data load into target S4HANA system using load tool. 
  2. Once the data is loaded to target system, it will be extracted and prepared for Post Load Data Validation.

Data Privacy and Sensitivity

N/A


Extraction

The RE-FX Lease contract master data records shall be extracted from SAP ECC and migrated using the 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 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 Migrate. This is to be conducted using DCT (Data Collection Template) in Syniti Migrate. Note: DCT is not applicable for this object 1076

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 DescriptionTeam Responsible
1

Extract all active and released RE-FX Lease Contracts from table VICNCN in PF2 and WP2.

Syniti team
2

Extract Object data of RE-FX Lease Contracts from table VIBDCNSUBJECT in PF2 and WP2

Syniti team
3Extract Organizational data of RE-FX Lease Contracts from table VITMOA in PF2 and WP2Syniti team
4

Extract Posting Terms data of RE-FX Lease Contracts from table VITMPY in PF2 and WP2

Syniti team
5

Extract Frequency Terms data of RE-FX Lease Contracts from table VITMRH in PF2 and WP2

Syniti team
6

Extract Business Partner (aka Vendors) data of RE-FX Lease Contracts from table VIBPOBJREL in PF2 and WP2

Syniti team
7

Extract Conditions data of RE-FX Lease Contracts from table VICDCOND in PF2 and WP2

Syniti team
8

Extract Valuation Rules data of RE-FX Lease Contracts from table VICERULE in PF2 and WP2

Syniti 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 NameField DescriptionRule












Extraction Dependencies

Item #Step DescriptionTeam Responsible
ED-1RoU Assets of contracts that are retired will not be migrated Data Team
ED-2

Contracts which are already concluded and no longer valuated shall not be migrated however their assets shall only be migrated if the asset is still in use

Data Team
ED-3Total NBV of the RoU assets are to be compared with total RoU Asset GL balance for each of the ledgersData Team
ED-4Total lease liabilities of the downloaded list of contracts are to be compared that they match the total short and long term lease liabilities in GL for each of the ledgersData Team


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 DescriptionTeam Responsible













Transformation Rules

Rule #Source systemSource TableSource FieldSource DescriptionTarget SystemTarget TableTarget FieldTarget DescriptionTransformation Logic









































List of Custom Target Reports for this object is maintained here: Conversion Specification - Custom Reports Register.

Transformation Mapping

Mapping Table NameMapping Table Description








Transformation Dependencies

List the steps that need to occur before transformation can commence
Item #Step DescriptionTeam Responsible













Pre-Load Validation

Project Team

Completeness

TaskAction





Accuracy

TaskAction





Business

Completeness

TaskAction





Accuracy

TaskAction





Load

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 DescriptionTeam Responsible













Load Phase and Dependencies

Configuration

Item #Configuration Item
1Company Code
2Contract Types
3Valuation Rules
4Conditions and Condition Purpose
5Contract Object Types
6Tax Type and Tax Group
7Valuation Relevance
8ROU Asset Classes
9Fixed Asset - Legacy Transfer Date
10ROU Assets Number Ranges
11Contract Number Ranges
12Business Partners with specific Role
13GL Accounts
14Cost Centres, Profit Centres and Functional Area
15Discounted Interest Rates

Conversion Objects

Object #Preceding Object Conversion Approach

list 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










Post-Load Validation

Project Team

Completeness

TaskAction





Accuracy

TaskAction





Business

Completeness

TaskAction





Accuracy

TaskAction





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.


See also

Change log

Version Published Changed By Comment
CURRENT (v. 22) Apr 08, 2026 15:45 PARA-ext, Anil
v. 118 Mar 30, 2026 17:52 PARA-ext, Anil
v. 117 Feb 13, 2026 15:17 PARA-ext, Anil
v. 116 Feb 11, 2026 12:35 PARA-ext, Anil
v. 115 Dec 08, 2025 12:23 PARA-ext, Anil
v. 114 Dec 08, 2025 09:00 PARA-ext, Anil
v. 113 Dec 05, 2025 19:28 PARA-ext, Anil
v. 112 Dec 05, 2025 16:02 PARA-ext, Anil
v. 111 Dec 05, 2025 15:59 PARA-ext, Anil
v. 110 Dec 05, 2025 12:07 PARA-ext, Anil

Go to Page History

  • No labels