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

Compare with Current View Page History

« Previous Version 26 Next »

Status

  Revision in Progress

OwnerMaytingsari Tjahjo
Stakeholders

Purpose

The purpose of this document is to define the conversion approach to migrate asset master (main and sub asset) and group asset from legacy systems to the S/4HANA.

Group asset in SAP is utilized to meet certain tax requirements of some countries (i.e. India), which require depreciation calculation on a higher asset level than the individual asset level. The depreciation rate is applied to the group asset value rather than individual asset value. Group asset is almost like a normal asset with Group Asset indicator and only tax depreciation area assigned.

This document consists of links to other documents that support conversion process such as Master Data Standard for Asset master.

050 - Master Data Standard - ERP Rebuild Implementation - Google Drive

Asset master consists of information of Fixed Assets Register including:

  • General information such as asset description name, asset class, account determination, capitalization date, etc. 
  • Time Dependent data – Assignment of related data by validity period (such as cost center, plant, location, etc)
  • Depreciation terms data - Depreciation keys, useful life and depreciation areas


Conversion Scope

The scope of this document covers the approach for converting active main and sub asset and group assets from Legacy Source Systems (PF2 and WP2) into S/4HANA following the Fixed Asset MDS (Master Data Standard).

Company code 5955 (India) is the only company code that have Group assets (There are 11 Group assets) These will be in scope for migration? (TBC). 

In the to-be solution, it is not planned to use group assets. Awaiting Mohamed A to advise on how we handle the 11 Group Assets (co code 5955 (India) if the to be solution we don't use Group Assets?

The data from legacy system includes:

  • Main and sub asset with:
    • Company codes and plants in scope
    • Active asset (field "Deactivation date" is blank) or asset that are deactivated in current year (field "Deactivation date" is current year)
    • Non-Asset under Construction.
  • Group assets with:
    • Company codes in scope
    • Active asset (field "Deactivation date" is blank) or asset that are deactivated in current year (field "Deactivation date" is current year)

Fully depreciated asset will be in scope for migration as the asset register may be retained for insurance purposes or tax depreciation purposes.

Time dependent data in main and sub assets and group assets have specific validity period. Only the current validity period of the time dependent data will be migrated

 All fixed asset master, inclusive of low value assets will be extracted, and relevancy rule applied as part of migration.

Relevancy rule:

  • Main and sub assets with all rules to be met:
    • Company code is in scope (Enterprise Structure Catalog - Google Sheets, worksheet "10. Company Code") AND
    • Plant is in scope if not Blank AND
    • Deactivation date is blank or current year AND
    • Indicator Asset is a group asset (ANLA-XANLGR) is NOT “X” AND
    • One of the 2 following criteria must be met:
      • Posted with values in one of the depreciation areas OR
      • Unposted in all depreciation areas and
        • Appeared in the settlement rules of CAPEX Projects or
        • Appeared in the account assignment category “A” in Open Purchase orders which are deemed relevant for migration

Follow up with Alex whether sub-number will be used or not.

 Group assets with all rules to be met: (To be confirmed whether Group Asset is in scope or not)

 The data from legacy system excludes:

  1. Assets under construction (AUC)


List of source systems and approximate number of records
SourceScope

Source Approx No. of Records

Target SystemTarget Approx

No. of Records

PF2

Relevant fixed asset master records extracted from the source system and transformed according to the target data into a pre-load reports.

140.300S/4HANA140.300

WP2

Relevant fixed asset master records extracted from the source system and transformed according to the target data into a pre-load reports.

143.098S/4HANA143.098

There will be 3 SAP boxes
a. CUI box (US, GB, DE)
b. China box (CN)
c. ROW (Rest of the World) box

Please refer to file "Enterprise Structure Catalog" (worksheet "10. Company code") to see which company codes belongs to which SAP boxes.

Enterprise Structure Catalog - Google Sheets

In terms of data migration, below is the guideline:
a. Non-CUI objects : Migration to CUI box by Syniti.
b. CUI objects : Manual cleansing/separate migration cockpit (Syniti is not certified)

Fixed asset is non CUI object hence migration to 3 SAP boxes are all done by Syniti.

Additional Information

Multi-language Requirement

It was decided to apply approach below:

  • Field “Description Line1” (ANLA-TXT50) = Migrate as it is from legacy system to S/4HANA (The description could be any languages (not only the 4 core languages but also any other non-core languages)).
  • Field “Description Line2” (ANLA-TXA50) = Migrate as it is from legacy system to S/4HANA (To be confirmed). In PF2 and WP2, the field "Description Line 2" is used to add information on the description of the asset when the Line 1 is not enough.

PF2:
Total active assets 140.092 

      • Desc Line 2 which is empty = 95.618
      • Desc Line 2 which is not empty = 44.474


 WP2:
Total active assets 142.669

      • Desc Line 2 which is empty = 63.524
      • Desc Line 2 which is not empty = 79.145

As currently many assets have field "Desc Line 2" is not equal to empty, hence to store the translation in English, instead of using Field "Description Line 2" (ANLA-TXA50), it's better to use field "Asset main no.text" (ANLH-ANLHTXT). To be confirmed by Functional Team.

Note: Currently the value of field "Description Line 1" and field "Asset main no. text" are majority the same. Ony for few assets, they are different. 

  • Field "Asset main no.text" (ANLH-ANLHTXT) must be in English (To be confirmed which field to be used to store description in English)

Document Management

N/A

Legal Requirement

N/A

Special Requirements




Target Design

The technical design of the target for this conversion approach.

Awaiting MDS Fixed Asset Master to be completed (due on 17 Oct)

TableFieldData ElementField DescriptionData TypeLengthRequirementNote

ANLA

BUKRS

BUKRS

Company Code

CHAR4MandatoryMust be valid company code in company code configuration (table T001)

ANLA

ANLKL

ANLKL

Asset Class

CHAR8Mandatory

Must be valid in asset class configuration (table ANKA). Retrieve the asset class description in English from table ANKT.

Please refer to file below for To-Be Asset Classes:

SyWay_asset_classes&fields - Google Sheets

ANLA

ANLN1ANLN1

Asset number

CHAR12System generated number

ANLA

ANLN2ANLN2

Asset sub-number

CHAR40000 (for main number)

ANLA

TXT50TXA50_ANLT

Description 1

CHAR50Mandatory

ANLA

TXA50TXA50_MORE

Description 2

CHAR50Optional (TBC) 

ANLH

ANLHTXTANLHTXT

Asset main no. text

CHAR50Optional (TBC) 

STXH

SPRASSPRAS

Language Key for Asset Long text

LANG1TBC 

ANLA

XLTXIDXLTXID

Indicator: Long text active

CHAR1TBCMust be X if long text content is populated

STXL

CLUSTDSTXLDUMMY2

Raw data long text

LRAW7902TBCField to populate long text content

ANLA

SERNRAM_SERNR

Serial number

CHAR18Optional

ANLA

MENGEAM_MENGE

Quantity

QUAN13OptionalMust be a number and equal or more than 1

ANLA

MEINSMEINS

Base unit of measure

UNIT3OptionalMust be populated if Quantity is populated

ANLA

INVNRINVNR_ANLA

Inventory Number

CHAR25Optional

RA02S

XHISTXHIST_AM

Manage historically

CHAR1Optional

ANLA

IVDATIVDAT_ANLA

Last Inventory on

DATS8OptionalMust be in date format (Anil-For each mock, can this be defaulted to mock date?)

ANLA

INKENINKEN

Include asset in inventory list

CHAR1OptionalCheckbox (Defaulted to “X”)

ANLA

INVZUINVZU_ANLA

Inventory Note

CHAR15Optional

ANLA

AKTIVAKTIVD

Capitalization date

DATS8OptionalMust be in date format

ANLA

ZUPERDZUPER

First Acquisition Date

NUMC3OptionalMust be in date format

ANLA

DEAKTDEAKT

Deactivation on

DATS8Optional

ANLZ

KOSTLKOSTL

Cost Centre

CHAR10MandatoryMust be valid in cost center

ANLZ

WERKSWERKS_D

Plant

CHAR4OptionalMust be valid in plant assigned to the company code configuration (Table T001K)

ANLZ

STORTSTORT

Location

CHAR10OptionalMust be valid Location (T499S-STAND) assigned to plant above in configuration (Table T499S)

ANLZ

RAUMNRAUMNR

Room

CHAR8Optional

ANLZ

KFZKZAM_KFZKZ

License Plate No. of Vehicle

CHAR15Optional

ANLZ

XSTILXSTIL

Asset shutdown indicator

CHAR1Optional

ANLA

ORD41ORD41

Evaluation group 1

CHAR4OptionalMust be valid in Evaluation group 1 in configuration (Tables T087) and Text (Table T087T)

ANLA

ORD42ORD42

Evaluation group 2

CHAR4Optional

ANLA

ORD43ORD43

Evaluation group 3

CHAR4Optional

ANLA

ORD44ORD44

Evaluation group 4

CHAR4Optional
ANLAGDLGRPGDLGRPEvaluation group 5CHAR8Optional

ANLA

IZWEKIZWEK

Investment reason

CHAR2Optional

ANLA

ANLUEANLUE

Asset Super Number

CHAR12Optional

ANLA

AIBN1AIBN1

Original asset number or Original Group Asset number

CHAR12Mandatory

If not blank, must be a valid combination of legacy company code and Asset no. in legacy system.

ANLA

AIBN2AIBN2

Original Sub-Asset

CHAR4Mandatory


ANLA

AIBDTAIBDT

Original Acquisition Date of AuC/ Transferred Asset

DATS8Optional

ANLA

URJHRURJHR

Fiscal Year of Original Acquisition

NUMC4Optional

ANLA

URWRTURWRT

Original Acquisition Value

CURR13Optional

ANLA 

POSNRAM_POSNR

WBS element

NUMC8Optional

ANLA-?

Equipment






There won't be any synchronization switched on between Fixed Assets and Equipments or the other way around. There would be a soft link between equipments and Fixed Assets where the equipment should store the asset ID for plant assets. There won't be a link from Fixed Assets to the equipment hence this has been descoped. (Awaiting Alex for the final decision on this)

ANLA

VMGLIVMGLI

Classification Key

CHAR4Optional

ANLV

VSARTVSART_ANLA

Insurance type

CHAR2Optional

ANLV

VSINDVSIND

Index series

CHAR5Optional

ANLB

AFABEAFABE_D

Depreciation area

NUMC2Mandatory

ANLB

AFASLAFASL

Depreciation Key

CHAR4Mandatory

ANLB

NDJARNDJAR

Useful Life

NUMC3MandatoryNumeric value less than 999

ANLB

NDPERNDPER

Useful Life (Period)

NUMC4MandatoryNumeric value (1-12)

ANLB

AFABGAFABG

Depreciation Start date

DATS8OptionalValid date format

ANLB

SCHRW_PROZSCHRW_PROZ

Scrap value %

DEC14OptionalNumeric value less than 100

ANLB

ANLGRANLGR

Group asset

CHAR12OptionalIf populated, must be valid Group Asset.

ANLB

INBDAINBDA

Operating Readiness

DATS8Optional


Below is the Migration Cockpit Template for Fixed Asset (Master Data and Balance):

Source data for Fixed asset (incl. balances and transactions).xlsx

Data Cleansing

IDCriticalityError Message/Report DescriptionRuleOutputSource System
1Can load but does not comply data standard

Report "Relevant assets (main and sub-assets) with "Last Inventory on Date" as Blank or <=DD.MM.YYYY" (Ask Pedro on the date)

As of 7 Aug 2025, the last inventory date in PF2 is 10.03.2025

As of 7 Aug 2025, the last inventory date in WP2 is 30.04.2025

Action item:

Business must update field "Last inventory on Date" otherwise the assets in this report must not be loaded to S/4HANA.


Rule 1: Company codes must be in scope.

Rule 2: Plants must be in scope.

Rule 3: Asset class is not Asset under Construction class.

Rule 4: Has field "Deactivation date" = BLANK or current year.

Rule 5: Has field "Last Inventory on Date" as blank or <=DD.MM.YYYY

Company code

Asset number

Asset Sub-Number

Asset Class

Description

Last Inventory On

Inventory Note

Cost center

Capitalization Date

PF2 and WP2
2Can load but does not comply data standard

Report "Unposted asset without any linked object"

Result:

The asset in this report must not be loaded to S/4HANA

Rule 1: Company codes must be in scope.

Rule 2: Asset class is not Asset under Construction class.

Rule 3: Has Deactivation date = BLANK or current year.

Rule 4A: Has capitalization date = BLANK or

Rule 4B:  Has capitalization date populated but no entry is found in ANLC (Asset Value Fields) table for the asset in all depreciation areas.

Rule 5: Does not appear in the settlement rule of any relevant cost objects1. or Line-item settlement type of Asset Under Construction (AUC) or assigned to any relevant open Purchase Orders.2.

Refer to following data objects:

  1. Object 1027 (WBS - CAPEX/OPEX Settlement Rule)
  2. Object 9045 (Open Purchase Orders)

Country

Company code

Asset number

Asset Sub-Number

Asset Class

Description

Deactivation date

GL Account

Capitalization date

Current NBV

Open PO flag

Projects/WBS/IO

PF2 and WP2


Fixed Asset Verification

This refers to Data Cleansing Report "Relevant assets (main and sub-assets) with "Last Inventory on Date" as Blank or <=DD.MM.YYYY"

To adhere to SyWay Accounting Policy for managing fixed asset and eliminate unused data, all assets migrated from legacy system to S/4HANA must have evidence of asset verification recorded in the "Last Inventory On date" field in Asset master.

Any assets to be migrated to S/4HANA without such evidence recorded will require business approvals.


Conversion Process

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


Process

Activity

Extract

Extract involves collecting data from the source.

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

a.     Perform full data extraction from relevant asset tables in the source system(s).

b.     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 standard Load 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 system using load tool.  Note: There may be some cases where the load is done manually as part of business activities. If there is any, the load steps will be specified in section "Load Run Sheet"

2.     Once the data is loaded to target system, it will be extracted out and prepared for Post Load Data Validation.

 Delta Data Management

Any main assets created in the legacy systems (PF2 and WP2) after the full extraction for Mock conversion will be re-extracted again from legacy systems (PF2 and WP2) for each mock or cutover rehearsals.

As data cleansing is performed in PF2 and WP2 to meet SYWAY design standard, each extraction will re-transform extracted data with on-going new unmapped legacy values discovered and mapped.

The transformed fixed assets will be combined with any other assets maintained in the Fixed Asset DCT (Data Collection Template) into the pre-load file for validation.

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

1.      

Extract all main assets from ANLA table in PF2 and WP2,

Data team

2.      

Apply Asset Relevancy criteria on the extracted records.

Data team

3.      

Extract Asset long text from STXH and STXL tables of asset master records in Req#2 in PF2 and WP2.

Data team

4.      

Extract time dependent data of asset master records in Req#2 above from ANLZ table in PF2 and WP2.

Data team

5.      

Extract depreciation terms data of the asset master in Req#2 from ANLB table in PF2 and WP2.

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

N/A

Extraction Dependencies

Item #Step DescriptionTeam Responsible
1.Data cleansing of legacy main assets in the source system to adhere to target design is completed.Business
2.Data cleansing of legacy assets where assets that are no longer physically exist will be assessed for retirement is accomplishedBusiness


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

1.      

Ensure all the fields that require value mapping, as stipulated in Section "Mapping tables", have the latest signed-off mapping files imported into Syniti Migrate.

Data team

2.      

Go to Process Area Launch and Process the Object – Fixed Asset

Data team

3.      

Launch the Objects to execute transformation.

Data team

4.      

Perform transformation for Group Assets and Main Assets extracted from PF2 and WP2 where target values will be derived from mapping tables.

Data team

5.      

Combine the transformed data of extracted main-asset (section "Extraction run sheet") and lease plan main assets populated in DCT (section "Data Collection Template")

Data team

6.      

Generate Pre-Load reports in Syniti Migrate.

Data team

7.      

Generate data load count in Syniti Migrate.

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 5 to 10 if necessary

Data team


Transformation Rules

List of all fields in the Target table field to be populated with values according to the Fixed Asset Master Data Standard to facilitate loading into target system.  

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

1.      

PF2 and WP2

ANLA-BUKRS

Company Code

S/4HANA

ANLA-BUKRS

Company Code

Map from source to target by using company code mapping table



2.      

PF2 and WP2

ANLA-ANLKL

Asset Class

S/4HANA

ANLA-ANLKL

Asset Class

Map from source to target via Asset Class mapping table



3.      

PF2 and WP2

ANLA-ANLN1

Asset number

S/4HANA

ANLA-ANLN1

Asset number

System generated number



4.      

PF2 and WP2

ANLA-ANLN2

Asset sub-number

S/4HANA

ANLA-ANLN2

Asset sub-number




5.      

PF2 and WP2

ANLA-TXT50

Description 1

S/4HANA

ANLA-TXT50

Description 1

Copy value from source to target system



6.      

PF2 and WP2

ANLA-TXA50

Description 2

S/4HANA

ANLA-TXA50

Description 2

Copy value from source to target system.



7.      

PF2 and WP2

STXH-SPRAS

Language Key for Asset Long text

S/4HANA

STXH-SPRAS

Language Key for Asset Long text

Target Language Key as per Logon language.



8.      

PF2 and WP2

ANLA-XLTXID

General long text

S/4HANA

ANLA-XLTXID

General long text

Copy value from source to target system.



9.      

PF2 and WP2

ANLA-SERNR

Serial number

S/4HANA

ANLA-SERNR

Serial number

Copy value from source to target system.



10.   

PF2 and WP2

ANLA-MENGE

Quantity

S/4HANA

ANLA-MENGE

Quantity

Copy value from source to target system.



11.   

PF2 and WP2

ANLA-MEINS

Base unit of measure

S/4HANA

ANLA-MEINS

Base unit of measure

Copy value from source to target system.



12.   

DCT or PF2 and WP2?

ANLA-INVNR

Inventory Number

S/4HANA

ANLA-INVNR

Inventory Number




13.   

PF2 and WP2

ANLA-XHIST

Manage historically

S/4HANA

ANLA-XHIST

Manage historically

Default “X” for all assets.



14.   

PF2 and WP2

ANLA-IVDAT

Last Inventory On

S/4HANA

ANLA-IVDAT

Last Inventory On




15.   

 PF2 and WP2

ANLA-INKEN

Include asset in inventory list

S/4HANA

ANLA-INKEN

Include asset in inventory list

Extract indicator (INKEN) from table ANKA in target system based on target asset class (ANLKL).



16.   

DCT or PF2 and WP2?

ANLA-INVZU

Inventory Note

S/4HANA

ANLA-INVZU

Inventory Note

Copy values from source to target system if maintained in DCT.



17.   

PF2 and WP2

ANLA-AKTIV

Capitalization date

S/4HANA

ANLA-AKTIV

Capitalization date

Copy values from source to target system.



18.   

PF2 and WP2

ANLA-ZUPER

First Acquisition Date

S/4HANA

ANLA-ZUPER

First Acquisition Date

First Acquisition Date – This will be defaulted with Capitalization date.



19.   

PF2 and WP2

ANLA-DEAKT

Deactivation Date

S/4HANA

ANLA-DEAKT

Deactivation Date

Leave as Blank.



20.   

PF2 and WP2

ANLZ-KOSTL

Cost Centre

S/4HANA

ANLZ-KOSTL

Cost Centre

Map from source (latest validity date) to target via Cost Centre mapping table.



21.   

PF2 and WP2

ANLZ-WERKS

Plant

S/4HANA

ANLZ-WERKS

Plant

Map from source (latest validity date) to target via Plant mapping table.



22.   

PF2 and WP2

ANLZ-STORT

Asset location

S/4HANA

ANLZ-STORT

Asset location

Map from source (latest validity date) to target via Location mapping table.



23.   

PF2 and WP2

ANLZ-RAUMN

Room

S/4HANA

ANLZ-RAUMN

Room

Copy value from source (latest validity date) to target system.



24.   

PF2 and WP2

ANLZ-KFZKZ

License Plate No. of Vehicle

S/4HANA

ANLZ-KFZKZ

License Plate No. of Vehicle

Copy value from source to target system.



25.   

PF2 and WP2

ANLZ-XSTIL

Shutdown indicator

S/4HANA

ANLZ-XSTIL

Shutdown indicator

Copy value from source (latest validity date) to target system.



26.   

PF2 and WP2

ANLA-ORD41

Evaluation group 1

S/4HANA

ANLA-ORD41

Evaluation group 1

Map from source (asset class) to target system via Evaluation Group 1 mapping table




PF2 and WP2ANLA-ORD42Evaluation group 2S/4HANAANLA-ORD42Evaluation group 2Map from source (asset class) to target system via Evaluation Group 2 mapping table

 

PF2 and WP2

ANLA-ORD42

Evaluation group 3

S/4HANA

ANLA-ORD43

Evaluation group 3

Map from source (asset class) to target system via Evaluation Group 3 mapping table



 

PF2 and WP2

ANLA-ORD44

Evaluation group 4

S/4HANA

ANLA-ORD44

Evaluation group 4

Map from source (asset class) to target system via Evaluation Group 4 mapping table



27.   

PF2 and WP2

ANLA-ANLUE

Asset Super Number

S/4HANA

ANLA-ANLUE

Asset Super Number




28.   

PF2 and WP2

ANLA-ANLN1

Asset Number

S/4HANA

 ANLA-AIBN1

 


Original asset number or Original Group Asset number





29.   

PF2 and WP2

ANLA-ANLN2

Asset Sub-Number

S/4HANA


ANLA-AIBN2


Original Sub-Asset

Original Asset sub-number – Populate this field with the legacy PF2 and WP2 Asset sub-number. 

 



30.   

PF2 and WP2

ANLA-AIBDT

Original Acquisition Date of AuC/ Transferred Asset

S/4HANA


ANLA-AIBDT

Original Acquisition Date of AuC/ Transferred Asset

Copy value from source to target system.



31.   

PF2 and WP2

ANLA-URJHR

Fiscal Year of Original Acquisition

S/4HANA

ANLA-URJHR

Fiscal Year of Original Acquisition

Copy value from source to target system.



32.   

PF2 and WP2

ANLA-URWRT

Original Acquisition Value

S/4HANA

ANLA-URWRT

Original Acquisition Value

Copy value from source to target system.



33.   

DCT

ANLA-POSNR

WBS element

S/4HANA


ANLA-POSNR


WBS element

Copy values from source to target system (Lease asset class).



34.   

PF2 and WP2

ANLB-AFABE

Depreciation area

S/4HANA

ANLB-AFABE

Depreciation area

Map from source to target via Depreciation area mapping table.



35.   

PF2 and WP2

ANLB-AFASL

Depreciation Key

S/4HANA

ANLB-AFASL

Depreciation Key

Map from source to target via Depreciation Key mapping table.



36.   

PF2 and WP2

ANLB- NDJAR

Useful Life

S/4HANA

ANLB- NDJAR

Useful Life

Useful life (Years) defaulted from the new asset class will be overwritten with the useful life from legacy system.



37.   

PF2 and WP2

ANLB- NDPER

Useful Life (Period)

S/4HANA

ANLB- NDPER

Useful Life (Period)

Useful life (Period) defaulted from the new asset class will be overwritten with the useful life from legacy system.



38.   

PF2 and WP2

ANLB- AFABG

Depreciation Start date

S/4HANA

ANLB- AFABG

Depreciation Start date

Depreciation start date defaulted from the Capitalization start date will be overwritten with depreciation start date from legacy system.



39.   

PF2 and WP2

ANLB-SCHRW_PROZ

Scrap value %

S/4HANA

ANLB-SCHRW_PROZ

Scrap value %

Copy value from source to target system.



40.   

PF2 and WP2

ANLB-ANLGR

Group asset

S/4HANA

ANLB- ANLGR

Group asset

Map from source to target via Group asset mapping table.



41.   

PF2 and WP2

ANLB-INBDA

Operating Readiness

S/4HANA

ANLB- INBDA

Operating Readiness

Copy value from source to target system.




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

Transformation Mapping

List of mapping tables where the legacy values will have to SyWay values.

Mapping Table NameMapping Table Description

Company code

Mapping of legacy company code to SyWay company code

Asset Class

Mapping of legacy asset Class to SyWay asset class

List of SyWay Asset Classes to be is stored in link below:

SyWay_asset_classes&fields - Google Sheets

Cost center

Mapping of legacy cost centre to SyWay cost centre

Internal Order

N/A. PF2 and WP2 do not use field Internal Order (ANLX-CAUFN)

Plant

Mapping of legacy plant code to SyWay plant code

Location

Mapping of legacy location to SyWay location

Room

Mapping of legacy room to SyWay room

Evaluation group 1 (EG1)

Mapping of legacy EG1 to SyWay EG1

Evaluation group 2 (EG2)

Mapping of legacy EG2 to SyWay EG2

Evaluation group 3 (EG3)

Mapping of legacy EG3 to SyWay EG3

Evaluation group 4 (EG4)

Mapping of legacy EG4 to SyWay EG4

Evaluation group 5 (EG5)

Mapping of legacy EG5 to SyWay EG5

Investment Reason

Mapping of legacy investment reason codes to SyWay investment reason codes

Asset Super Number

Mapping of legacy asset super number to SyWay asset super number

Classification KeyMapping of legacy classification key to SyWay classification key

Insurance Type

Mapping of legacy insurance type to SyWay insurance type

Depreciation area

Mapping of legacy depreciation areas to SyWay depreciation areas

Depreciation key

Mapping of legacy depreciation key to SyWay depreciation key

Group Assets

Mapping of legacy group asset to SyWay group asset (for India company code only)

Transformation Dependencies

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

1.      

Ensure all the fields that require value mapping, as stipulated in Section "Mapping tables", have the correct values mapped and imported into ADMM.

Data team





Pre-Load Validation

Project Team

Completeness

TaskAction

Generation of Pre-load reports

Pre-load reports will have same structure as of load file with additional columns/attributes if required by business to facilitate validations.

Main Assets:

There will be 3 Pre-load reports generated:  

1.   Asset Master Main data (General, Time-dependent, Allocations)

2.   Asset Depreciation terms data (Depreciation areas, Useful life by Depreciation area and Depreciation Keys)

3.   Asset Long Text (if any asset has relevant long text to be migrated) in logon languages


Reconciliation of record count

Main Assets

Total number of main Assets in the extract is compared against total number of main assets in the legacy system.

Less:   

1.     All main assets under companies and plant or cost centre NOT in Scope.

2.     Total number of AUCs in the legacy system.

3.     Non-Relevant records (Deactivated Main Assets, Main assets dropped via Relevancy criteria -refer section 2 Conversion Scope).

4.     Other constraints/errors.

Add:   New main assets populated in DCT

 Total Number of Records to load:

1.     Asset Master Main data :

2.     Asset Depreciation terms data: Total number of records for Main assets multiply by the number of depreciation areas defined in the Chart of Depreciation.


Compliance check

???



Accuracy

TaskAction

Mandatory field mapping and transformation

 

Obtain a list of the fields to be populated with values from mapping files (Refer to section "Mapping tables") and ensure all these fields contain S/4HANA values.

Review the data report to ensure mapping value is not missing in ADMM.

Capture errors in the Data Error report.


Business

Completeness

TaskAction

Verify record count in Pre-load reports by region

 

 In legacy system, execute Asset Balances report (S_ALR_87011963 – Asset Balances - by Asset Number) and ensure “Current book value” is selected to obtain a list of active posted assets to be migrated for the companies in scope for each region.

Compare the count in this report and assets populated in DCT against the count of main assets to be loaded in Pre-load.

Verify Relevancy rules applied

 

In Legacy system, execute Unposted Asset report (S_ALR_87012056 - Directory of Unposted Assets) to retrieve the list of unposted assets with deactivation date = Blank. These assets should not appear in the Pre-load report.

Leverage the List of Unposted Assets relevant for migration in ADMM for any unposted asset flagged as relevant for migration as the asset fulfils the Relevancy criteria. (Section "Conversion Scope").




Accuracy

TaskAction

Conversion accuracy

Verify all main assets are transformed accurately as per endorsed transformation/mapping rules.

Review List of Error reports in ADMM for any mismatch or missing transformed values.


Load

Data Loading will be done using the migration cockpit object and format of which is attached here:

Source data for Fixed asset (incl. balances and transactions).xml


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

1.      

Ensure the load tools are transported into the correct ADMM instance.

Data team

2.      

Ensure Pre-load sign-offs are obtained.

Data team

3.

Load main assets with capitalization date.


4.

Load main assets without any capitalization date as it requires a separate load tool.


5.     

Import the main asset numbers created in S/4HANA and use the original asset number and sub-number =’0’ to link the general long text in the load files to the correct asset number in S/4 HANA.

Data team

6.    

Load asset Long text using main asset number in S/4HANA.

Data team

7. 

Load asset Super number using main asset number in S/4HANA

Data team

8.   

Generate the post load reports in ADMM.

Data team

9. 

Log errors as defects, if any and address resolutions. Close defects.

Data team

10.

Resolve defects via data update or upload and re-generate post load reports if necessary.

Data team

11. 

Business to validate the post load files as part of post-load validation, raise data defects or provide the post-load sign-off.

Data team

12. 

Repeat steps 8 to 10 if necessary.

Data team


Load Phase and Dependencies

Pre Cutover is the phase as to when the load for this object will occur.

Configuration

Item #Configuration Item

1.      

Company code-related configuration (Chart of Depreciation per country, Plant, Location, Asset Class, Depreciation areas, Depreciation keys, Asset Number Range Interval).

2.      

 

 

Asset Data Transfer Configuration

·       Transfer date – Last day of the month prior to go-live

·       Legacy Data Transfer Status = In Preparation

·       Document type – “UE”    

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)
1074Cost Centre Master

Error Handling

Error TypeError DescriptionAction Taken

Configuration

Revaluation values in Depreciation area XX is not allowed.

Engage functional team to expedite and fix the error in the system by allowing Revaluations (Acquisition/Ord.Depreciation) to be posted to the impacted depreciation area/chart of depreciation in transaction code OADB

Invalid Data

Relevant cost centre is not valid in the validity of time dependent data in the Asset master to be loaded.

Check whether the validity of time dependent data in cost centre needs to be changed.





Post-Load Validation

Project Team

Completeness

TaskAction

Reconciliation of Total Record Count

Total number of records loaded for (Main Assets, Depreciation terms) will be generated in the Post-load reports in ADMM.

Main Assets

Total no. of Main assets in the Post Load report is compared against total number of main assets in the pre-load reports by region.

Less:   Any errors during load.

Mandatory fields check

Review the post load file and note the records that failed the mandatory fields check. Below are the mandatory fields:

·       Asset Class

·       Company Code

·       Description

·       Serial Number (for assets of certain classes) TBC

·       Cost Centre

·       Plant

Depreciation terms

·       Depreciation Key 

·       Useful Life Year (except for keys *000) and Period (except for keys *0000)

·       Ordinary Depreciation Start Date


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 ADMM to create a Post load report that reports S/4 HANA loaded records along with the legacy values side-by-side to allow for 100% check of all these fields in the shortest possible time.

Main Assets:

There will be 3 post load reports generated in ADMM for key fields comparison: 

1.     Asset Master data (General, Time-dependent, Allocations)

2.     Asset Depreciation terms data (Depreciation areas, Useful life and Depreciation Keys by Depreciation area)

3.     Asset Long Text (if any asset has relevant long text to be migrated) in logon languages

Any mismatch will be reported under the Post Load – Error report.







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.






Accuracy

TaskAction

Check accuracy of field values

Based on the field checks report from the Data Team, conduct a sample check to prove accuracy of the values in S/4 HANA against the source (Pre-load report or PF2 and WP2 system). Suggested sample size is 1 per company code, per asset class.






Key Assumptions

  • Master Data Standard is up to date as on the date of documenting this conversion approach and data load.
  • Fixed Asset is in scope based on data design and any exception requested by business.
  • Asset Master cleansing task is completed.
  • All assets flagged for deletion must be deactivated (i.e. populate the deactivation date field).

See also

Change log

Version Published Changed By Comment
CURRENT (v. 26) Apr 07, 2026 12:05 GOTTIPATI-ext, Madhu
v. 114 Apr 02, 2026 11:58 GOTTIPATI-ext, Madhu
v. 113 Apr 02, 2026 11:55 GOTTIPATI-ext, Madhu
v. 112 Feb 27, 2026 09:51 GOTTIPATI-ext, Madhu
v. 111 Feb 26, 2026 11:23 GOTTIPATI-ext, Madhu
v. 110 Jan 26, 2026 12:58 GOTTIPATI-ext, Madhu
v. 109 Jan 26, 2026 12:57 GOTTIPATI-ext, Madhu
v. 108 Jan 26, 2026 12:53 GOTTIPATI-ext, Madhu
v. 107 Dec 09, 2025 12:43 PILLAY-ext, Lawrence
v. 106 Nov 26, 2025 11:24 TJAHJO-ext, Maytingsari

Go to Page History

Workflow history

Title Last Updated By Updated Status  
There are no pages at the moment.

  • No labels