Status

OwnerMaytingsari Tjahjo
StakeholdersThe business stakeholders involved in making, reviewing, and endorsing this decision. Type @ to mention people by name
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.

This document consists of links to other documents that support conversion process such as Master Data Standard for Asset master. DD-FUN-050 Master Data Standard_1070-Fixed Assets (incl. Sub Assets) - Google Sheets

Asset master consists of information of Fixed Assets Register including:

  • General information such as asset description, 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 assets (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).

As per Global Process Design for S/4HANA:

  • The creation of additional sub-assets is not permitted; therefore, all sub-assets will be migrated as main asset.
  • Group Asset will not be used. Therefore, tax depreciation values of the group asset need to be embedded proportionally across all underlying individual assets making up the group assets. Note: Company code 5955 (India) is the only company code that have Group assets (There are 11 Group assets).

Relevancy rule:

The data from legacy system includes:

  • Main and sub assets with all rules below to be met:
    • Company code is in scope (Enterprise Structure Catalog - Google Sheets, worksheet "10. Company Code") AND
    • Non-AuC (Asset under Construction) AND
    • Non-RoU (Right-of-Use) asset 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 
  •  Group assets with all rules below to be met:


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

 The data from legacy system excludes:

  • Assets under construction (AUC)
  • RoU (Right-of-Use) Assets
  • Assets under Asset Class Shares (Shares will no longer be managed via FI-AA in S/4). The share balance that is currently stored in fixed asset (ECC) should become part of the GL balance loads (S4/HANA)
  • GBU Aroma and O&G (by using cost centers) (To Be Confirmed)

         

Below is the list of AUC classes:

Class   Short Text          Asset class description                           
ZARIEC01AUC INTANGIBLE      ASSET UNDER CONSTRUCTION INTANGIBLE               
ZARIEC02AUC - GROUP CAP. LEAIEC ONLY GROUP (CAPITAL LEASES)                   
ZARIEC03AUC - GROUP TURNAROUIEC ONLY GROUP (TURNAROUND)                       
ZATIEC00AUC - TANGIBLE      AUC - TANGIBLE                                    
ZATIEC01AUC - TANGIBLE (03) AUC - TANGIBLE (Special Reserves)                 
ZATIEC03AUC_Intangible (AT) AUC_Intangible (AT)                               
ZBEIEC00AUC tangible  (BE)  AUC_TANGIBLE (BE)                                 
ZBEIEC01AUC intangible (BE) AUC_INTANGIBLE (BE)                               
ZBEIEC02AUC cap. lease (BE) AUC_CAPITAL LEASES (BE)                           
ZBEIEC03AUC main repair (BE)AUC_MAIN REPAIRS TAD (BE)                         
ZBEIEC04AUC local (BE)      AUC_Local (BE)                                    
ZBEIEC05AUC intangible (BE) AUC_INTANGIBLE (BE) Development Cost              
ZBEIEC97Transfer AuC to FA DTransfer AuC to Finish Asset Dev Cost             
ZBEIEC98Transfer AuC to FA ITransfer AuC to Finish Asset Intangible           
ZBEIEC99Transfer AuC to FA  Transfer AuC to Finish Asset Tangible             
ZBGIEC02AUC - GROUP CAP. LEAIEC ONLY GROUP (CAPITAL LEASES)                   
ZBGIEC03AUC - GROUP TURNAROUIEC ONLY GROUP (TURNAROUND)                       
ZBGIEC04AUC - LOCAL         IEC ONLY LOCAL                                    
ZBGIEC98Transfer AuC to FA ITransfer AuC Intangible to Finish Asset           
ZBGIEC99Transfer AuC to FA TTransfer AuC Tangible to Finish Asset             
ZBRIEC00AUC TANGIBLE        ASSET UNDER CONSTRUCTION TANGIBLE                 
ZBRIEC01AUC INTANGIBLE      ASSET UNDER CONSTRUCTION INTANGIBLE.              
ZBRIEC02AUC - GROUP CAP. LEAIEC ONLY GROUP (CAPITAL LEASES)                   
ZBRIEC03AUC - GROUP TURNAROUIEC ONLY GROUP (TURNAROUND)                       
ZBRIEC04AUC - LOCAL         IEC ONLY LOCAL                                    
ZBRIEC98Transfer AuC to FA ITransfer AuC to Finish Asset Intangible           
ZBRIEC99Transfer AuC to FA  Transfer AuC to Finish Asset                      
ZCHIEC01AUC_Intangible (CH) AUC_Intangible (CH)                               
ZCLIEC00Tangible AUC        Tangible AUC                                      
ZCLIEC01Intangible AUC      Intangible AUC                                    
ZCLIEC03AUC major repairs   AUC for major repairs                             
ZCLIEC04AUC local needs     AUC for local needs                               
ZCLIEC05AUC dev.costs       AUC for development costs                         
ZCLIEC99Transfer AuC to FA  Transfer AuC to Finish Asset                      
ZCNIEC00AUC tangible        AUC_TANGIBLE                                      
ZCNIEC01AUC intangible      AUC_INTANGIBLE                                    
ZCNIEC02AUC cap. lease      AUC_CAPITAL LEASES                                
ZCNIEC03AUC main repair     AUC_MAIN REPAIRS TAD                              
ZCNIEC04AUC local           AUC_Local                                         
ZCNIEC05AUC Interest CapitalAUC Interest Capitalized                          
ZCNIEC06AUC Ohter           AUC Others                                        
ZCNIEC07AUC intangible (CN) AUC_INTANGIBLE (CN) Development Cost              
ZDEIEC00Tangible AuC        Tangible AuC                                      
ZDEIEC01Intangible AuC      Intangible AuC                                    
ZDEIEC03AUC main repair (DE)AUC_MAIN REPAIRS TAD (DE)                         
ZDEIEC05AUC intangible (DE) AUC_INTANG (DE) Develop Cost only Group           
ZDEIEC91Intangible AuC Ret. Intangible AuC Retirement                         
ZDEIEC96Special AUC (DE)    Special AUC TANGIBLE (DE)                         
ZDEIEC97Special AUC (DE)    Special AUC INTANGIBLE (DE)                       
ZDEIEC98Transfer AuC to FA ITransfer AuC Intangible to Finish Asset           
ZDEIEC99Transfer AuC to FA  Transfer AuC to Finish Asset                      
ZESIEC02AUC - GROUP CAP. LEAIEC ONLY GROUP (CAPITAL LEASES)                   
ZESIEC03AUC - GROUP TURNAROUIEC ONLY GROUP (TURNAROUND)                       
ZESIEC04AUC - LOCAL         IEC ONLY LOCAL                                    
ZESIEC05AUC intangible      AUC_INTANGIBLE (US) Development Cost              
ZESIEC98Transfer T AuC to FATransfer AuC Tangible to Finish Asset             
ZESIEC99Transfer T AuC to FATransfer AuC Tangible to Finish Asset             
ZFRIEC00AUC tangible  (FR)  AUC_Tangible (FR)                                 
ZFRIEC01AUC intangible (FR) AUC_Intangible (FR)                               
ZFRIEC02AUC cap. lease (FR) AUC_Capital leases (FR)                           
ZFRIEC03AUC main repair (FR)AUC_Main repairs (FR)                             
ZFRIEC04AuC only Local (FR) AuC_Only Local (FR)                               
ZFRIEC05AUC intangible (FR) AUC_INTANG (FR) Develop Cost only Group           
ZFRIEC06AuC only Group(FR)  AuC_Only Group Intangible(FR)                     
ZFRIEC07AuC only Local I(FR)AuC_Only Local Intangible(FR)                     
ZFRIEC13AUC main repair (FR)AUC_Main repairs (FR) - Local/Group               
ZFRIEC90AUC tang. RetirementAUC_Tangible (FR) RETIREMENT                      
ZFRIEC91AUC int. Retirement AUC_Intangible (FR) RETIREMENT                    
ZFRIEC92AUC Dev costs Retir.AUC_Intang. Develop Cost (FR) RETIREMENT          
ZFRIEC98Transfer AuC to FA ITransfer AuC to Finish Asset Intangible           
ZFRIEC99Transfer AuC to FA  Transfer AuC to Finish Asset Tangible             
ZGBIEC00AUC TANGIBLE  (UK)  AUC_TANGIBLE (UK)                                 
ZGBIEC01AUC_INTANGIBLE (UK) AUC_INTANGIBLE (UK) NOT USED                      
ZGBIEC02AUC_CAPITAL LEASES (AUC_CAPITAL LEASES (UK)                           
ZGBIEC03AUC_MAIN REPAIRS TADAUC_MAIN REPAIRS TAD (UK)                         
ZGBIEC04AUC local (UK)      AUC_Local (UK)                                    
ZGBIEC11AUC_INTANGIBLE (UK) AUC_INTANGIBLE (UK)                               
ZGBIEC90AUC_TANGIBLE Retire AUC_TANGIBLE (UK) RETIREMENT                      
ZGBIEC91AUC_INTANGIBLE RetirAUC_INTANGIBLE (UK) RETIREMENT                    
ZINIEC00AUC (Tangible)      Assets under Construction (Tangible)              
ZINIEC01AUC (Intangible)    Assets under Construction (Intangible)            
ZINIEC02AUC Capital Lease   Asset under Construction Capital Lease (IN)       
ZINIEC03AUC Major Repairs   Asset under Construction Major Repair (IN)        
ZINIEC05AUC intangible (IN) AUC_INTANGIBLE (IN) Development Cost              
ZINIEC98Transfer AuC to FA ITransfer AuC to Finish Asset Intangible           
ZINIEC99Transfer AuC to FA  Transfer AuC to Finish Asset Tangible             
ZITIEC00AUC tangible  (IT)  AUC_TANGIBLE (IT)                                 
ZITIEC01AUC intangible (IT) AUC_INTANGIBLE (IT)                               
ZITIEC02AUC cap. lease (IT) AUC_CAPITAL LEASES (IT)                           
ZITIEC03AUC main repair (IT)AUC_MAIN REPAIRS TAD (IT)                         
ZITIEC04AUC local (IT)      AUC_Local (IT)                                    
ZITIEC05AUC intangible (IT) AUC_INTANGIBLE (IT) Development Cost              
ZITIEC90AUC tangible Retire AUC_TANGIBLE (IT) RETIREMENT                      
ZITIEC91AUC intangible RetirAUC_INTANGIBLE (IT) RETIREMENT                    
ZITIEC92AUC Dev costs RetireAUC_INTANGIBLE (IT) Development Cost RETIREMENT   
ZITIEC97Transfer AuC to FA DTransfer AuC to Finish Asset Development costs    
ZITIEC98Transfer AuC to FA ITransfer AuC to Finish Asset Intangible           
ZITIEC99Transfer AuC to FA  Transfer AuC to Finish Asset                      
ZJPIEC04AUC - LOCAL         AUC ONLY LOCAL                                    
ZJPIEC05AUC intangible (JP) AUC_INTANGIBLE (JP) Development Cost              
ZKRIEC00AUC TANGIBLE        ASSET UNDER CONSTRUCTION TANGIBLE                 
ZKRIEC01AUC INTANGIBLE      ASSET UNDER CONSTRUCTION INTANGIBLE               
ZKRIEC04AUC Local Only(KR)  AUC_Local Only(KR)                                
ZKRIEC10AUC TANGIBLE(w/o IM)AUC-TANGIBLE(w/o IM)                              
ZKRIEC11AUC INTANG.(w/o IM) AUC INTABIBLE(w/o IM)                             
ZKRIEC98Transfer AuC to FA ITransfer AuC to Finish Asset Intangible           
ZKRIEC99Transfer AuC to FA  Transfer AuC to Finish Asset Tangible             
ZLUIEC00AUC tangible        AUC_TANGIBLE                                      
ZLUIEC01AUC intangible(LU)  AUC intangible(LU)                                
ZLUIEC02AUC cap. lease      AUC_CAPITAL LEASES                                
ZLUIEC03AUC main repair     AUC_MAIN REPAIRS TAD                              
ZLUIEC04AUC local           AUC_Local                                         
ZMXIEC00AUC_TANGIBLE        AUC_TANGIBLE                                      
ZMXIEC01AUC_INTANGIBLE      AUC_INTANGIBLE                                    
ZMXIEC02AUC_CAPITAL LEASES  AUC_CAPITAL LEASES                                
ZMXIEC03AUC_MAIN REPAIRS    AUC_MAIN REPAIRS                                  
ZMXIEC04AUC_Local           AUC_Local                                         
ZMXIEC05AUC Interest CapitalAUC Interest Capitalized                          
ZMXIEC06AUC Others          AUC Others                                        
ZMXIEC07AUC_INTAN Dev Cost  AUC_INTANGIBLE Development Cost                   
ZMXIEC99Transfer AuC to FA  Transfer AuC to Finish Asset Tangible             
ZNLIEC00AUC_TANGIBLE (NL)   AUC_TANGIBLE (NL)                                 
ZNLIEC01AUC_INTANGIBLE (NL) AUC_INTANGIBLE (NL)                               
ZNLIEC02AUC_CAPITAL LEASES  AUC_CAPITAL LEASES (NL)                           
ZNLIEC03AUC_MAIN REPAIRS TADAUC_MAIN REPAIRS TAD (NL)                         
ZNLIEC04AUC local (NL)      AUC_Local (NL)                                    
ZNLIEC90AUC_TANGIBLE (NL) R AUC_TANGIBLE (NL) RETIREMENT                      
ZNLIEC91AUC_INTANGIBLE (NL)RAUC_INTANGIBLE (NL) RETIREMENT                    
ZPTIEC02AuC ONLY GROUP (CAPIAuC ONLY GROUP (CAPITAL LEASES) (PT)              
ZPTIEC03AuC ONLY GROUP (TURNAuC ONLY GROUP (TURNAROUND) (PT)                  
ZPTIEC04AuC ONLY LOCAL (PT) AuC ONLY LOCAL (PT)                               
ZPTIEC05AUC intangible      AUC_INTANGIBLE Development Cost                   
ZPTIEC97Special AUC (PT)    Special AUC TANGIBLE (PT)                         
ZPTIEC98Special AUC (PT)    Special AUC INTANGIBLE (PT)                       
ZPTIEC99Transfer AuC to FA  Transfer AuC to Finish Asset                      
ZRUIE21SAUC TANG(08.04) Sale*** Deleted! Do not use **************************
ZRUIEC00AUC tangible  (RU)  AuC tangible constructed (investment measure)     
ZRUIEC02AUC.INTANG.(2)      AuC intangible purchased (investment measure)     
ZRUIEC05AUC.-DIRECT ACQUI-IMAuC tangible purchased (investment measure)       
ZRUIEC06AUC.-DIRECT ACQUI   AuC tangible purchased (not inv.m.) allows AIAB   
ZRUIEC07AUC tangible  (RU)  AuC for lands investment measure                  
ZRUIEC08AUC-DIRECT ACQ 08.04AuC tangible constructed (not inv.m.) allows AIAB 
ZRUIEC09AUC INTAN-DIRECT ACQAuC intangible purchased (not inv.m.) allows AIAB 
ZRUIEC21AUC TANGIBLE (08.04)AuC tangible purchased (not inv.m.) w/o AIAB      
ZRUIEC22AUC TANGIBLE (08.03)AuC tangible constructed (not inv.m.) w/o AIAB    
ZRUIEC29AUC Turnaround Cost AuC Turnaround Cost Capitalization                
ZRUIECXSAUC Lands Sales     AuC Lands Sales                                   
ZRUIE_01AUC. IN AREA 50     AuC tangible purchased for area 01 only           
ZRUIE_50AUC. IN AREA 50     AuC tangible constructed for area 50 only         
ZSAIEC02AUC cap. lease (KSA)AUC_CAPITAL LEASES (KSA)                          
ZSAIEC03AUC Interest Capt.  AUC Interest Captitalized (KSA)                   
ZSAIEC04AUC local (KSA)     AUC_Local (KSA)                                   
ZSAIEC05AUC intangible (KSA)AUC_INTANGIBLE (KSA) Development Cost             
ZSAIEC06AUC main repair/turnAUC main repair/turnaround                        
ZSAIEC09RETIREMENT TANG. AUCRETIREMENT TANGIBLE AUC                           
ZSAIEC10AUC TANGIBLE(w/o IM)AUC_TANGIBLE (w/o IM)                             
ZSAIEC11AUC INTANG (w/o IM) AUC_INTABIBLE (w/o IM)                            
ZSGIEC00AUC tangible        AUC_TANGIBLE                                      
ZSGIEC01AUC intangible      AUC_INTANGIBLE                                    
ZSGIEC02AUC cap. lease      AUC_CAPITAL LEASES                                
ZSGIEC03AUC main repair     AUC_MAIN REPAIRS TAD                              
ZSGIEC04AUC local           AUC_Local                                         
ZSGIEC05AUC Interest CapitalAUC Interest Capitalized                          
ZSGIEC06AUC Ohter           AUC Others                                        
ZSGIEC07AUC intangible (CN) AUC_INTANGIBLE (CN) Development Cost              
ZSGIEC98Transfer AuC to FA ITransfer AuC to Finish Asset Intangible           
ZSGIEC99Transfer AuC to FA  Transfer AuC to Finish Asset Tangible             
ZTHIEC02AUC cap. lease (TH) AUC_CAPITAL LEASES (TH)                           
ZTHIEC03AUC Interest Capt.  AUC Interest Captitalized (TH)                    
ZTHIEC04AUC local (TH)      AUC_Local (TH)                                    
ZTHIEC99Transfer AuC to FA  Transfer AuC to Finish Asset Tangible             
ZTWIEC00AUC tangible        AUC_TANGIBLE                                      
ZTWIEC01AUC intangible      AUC_INTANGIBLE                                    
ZTWIEC02AUC cap. lease      AUC_CAPITAL LEASES                                
ZTWIEC03AUC main repair     AUC_MAIN REPAIRS TAD                              
ZTWIEC04AUC local           AUC_Local                                         
ZTWIEC05AUC Interest CapitalAUC Interest Capitalized                          
ZTWIEC06AUC Ohter           AUC Others                                        
ZTWIEC07AUC intangible DevCoAUC_INTANGIBLE - Development Cost                 
ZUSIEC00AUC (Tangible)      Assets under Construction (Tangible)              
ZUSIEC01AUC (Intangible)    Assets under Construction (Intangible)            
ZUSIEC03AUC (Major Repairs) Assets under Construction Major Repairs           
ZUSIEC05AUC intangible      AUC_INTANGIBLE (US) Development Cost              
ZUSIEC98Transfer AuC to FA ITransfer AuC to Finish Asset Intangible           
ZUSIEC99Transfer AuC to FA  Transfer AuC to Finish Asset Tangible    

Below is the list of RoU asset classes. These RoU asset will be handled by object 1076.           

SystemAsset ClassDescription
WP2AC231001Leasing - Real Estate - Land
WP2AC233001Leasing - Real Estate - Office Building
WP2AC233002Leasing - Real Estate - Employee Lease Apartments
WP2AC233003Leasing - Real Estate - Storage Space
WP2AC234001Leasing - Real Estate - Cars
WP2AC234002Leasing - Real Estate - Railcars
WP2AC234003Leasing - Real Estate - Containers / Trailers
WP2AC234004Leasing - Real Estate - Other Vehicles
WP2AC235001Leasing - Real Estate - IT Hardware
WP2AC235002Leasing - Real Estate - Computers
WP2AC235003Leasing - Real Estate - Office Equipment
WP2AC235004Leasing - Real Estate - Others Tangible
WP2AC237001Leasing - Real Estate - Industrial Equipment
PF2ZLE23101Leasing - Real Estate - Land
PF2ZLE23301Leasing - Real Estate - Office Building
PF2ZLE23302Leasing - Real Estate - Employee Lease Apartments
PF2ZLE23303Leasing - Real Estate - Storage Space
PF2ZLE23401Leasing - Real Estate - Cars
PF2ZLE23402Leasing - Real Estate - Railcars
PF2ZLE23403Leasing - Real Estate - Containers / Trailers
PF2ZLE23404Leasing - Real Estate - Other Vehicles
PF2ZLE23501Leasing - Real Estate - IT Hardware
PF2ZLE23502Leasing - Real Estate - Computers
PF2ZLE23503Leasing - Real Estate - Office Equipment
PF2ZLE23504Leasing - Real Estate - Others Tangible
PF2ZLE23701Leasing - Real Estate - Industrial Equipment


Below is the list of Asset Class Shares in PF2. (WP2 does not have Asset Class Shares)

Class   Short Text          Asset class description                           
ZARFIN01Shares- Conso       Shares - Consolidated                             
ZARFIN02Shares- Non conso   Shares - Non consolidated                         
ZARFIN03Shares- Equity basedShares - Invest. in equity based value            
ZARFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZARFIN05Shares - Others     Shares - Others                                   
ZBEFIN01Shares- Conso       Shares - Consolidated                             
ZBEFIN02Shares- Non conso   Shares - Non consolidated                         
ZBEFIN03Shares- Equity basedShares - Invest. in equity based value            
ZBEFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZBEFIN05Shares - Others     Shares - Others                                   
ZBEFIN06Shares - AFS        Shares - AFS                                      
ZBGFIN01Shares- Conso       Shares - Consolidated                             
ZBGFIN02Shares- Non conso   Shares - Non consolidated                         
ZBGFIN03Shares- Equity basedShares - Invest. in equity based value            
ZBGFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZBGFIN05Shares - Others     Shares - Others                                   
ZBRFIN01Shares- Conso       Shares - Consolidated                             
ZBRFIN02Shares- Non conso   Shares - Non consolidated                         
ZBRFIN03Shares- Equity basedShares - Invest. in equity based value            
ZBRFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZBRFIN05Shares - Others     Shares - Others                                   
ZBRFIN12Investment and shareInvestment and shares-n/conso affiliates          
ZCHFIN01Shares- Conso       Shares - Consolidated                             
ZCHFIN02Shares- Non conso   Shares - Non consolidated                         
ZCHFIN03Shares- Equity basedShares - Invest. in equity based value            
ZCLFIN01Shares- Conso       Shares - Consolidated                             
ZCLFIN02Shares- Non conso   Shares - Non consolidated                         
ZCLFIN03Shares- Equity basedShares - Invest. in equity based value            
ZCLFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZCLFIN05Shares - Others     Shares - Others                                   
ZCNFIN01Shares- Conso       Shares - Consolidated                             
ZCNFIN02Shares- Non conso   Shares - Non consolidated                         
ZCNFIN03Shares- Equity basedShares - Invest. in equity based value            
ZCNFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZCNFIN05Shares - Others     Shares - Others                                   
ZCNFIN06Shares - AFS        Shares - AFS                                      
ZDEFIN01Shares - ConsolidateShares - Consolidated                             
ZDEFIN02Shares - Non consoliShares - Non consolidated                         
ZDEFIN03Shares -Equity basedShares -Equity based                              
ZDEFIN04Shares -Cies linked Shares -Cies linked by part.interest              
ZDEFIN05Shares -Others      Shares -Others                                    
ZDEFIN11Investment and shareInvestment and shares-conso affiliates            
ZDEFIN12Investment and shareInvestment and shares-n/conso affiliates          
ZDEFIN13Investment and shareInvestment and shares-n/conso affiliates          
ZDEFIN15Investment and shareInvestment and shares-n/conso affiliates          
ZEGFIN01Shares-Consolidated Shares-Consolidated                               
ZEGFIN02Shares-Non ConsolidaShares-Non Consolidated                           
ZEGFIN03Shares-Invest in EquShares-Invest in Equity Based Value               
ZEGFIN04Shares-Invest in ComShares-Invest in Comp linked by Part. Interest    
ZEGFIN05Shares-Others AllocaShares-Others Allocation to FPDIR                 
ZESFIN01Shares- Conso       Shares - Consolidated                             
ZESFIN02Shares- Non conso   Shares - Non consolidated                         
ZESFIN03Shares- Equity basedShares - Invest. in equity based value            
ZESFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZESFIN05Shares - Others     Shares - Others                                   
ZFIFIN01Shares- Conso       Shares - Consolidated                             
ZFIFIN02Shares- Non conso   Shares - Non consolidated                         
ZFIFIN03Shares- Equity basedShares - Invest. in equity based value            
ZFIFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZFIFIN05Shares - Others     Shares - Others                                   
ZFRFIN01Shares- Conso       Shares - Consolidated                             
ZFRFIN02Shares- Non conso   Shares - Non consolidated                         
ZFRFIN03Shares- Equity basedShares - Invest. in equity based value            
ZFRFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZFRFIN05Shares- Others      Shares - Others                                   
ZGBFIN01Shares- Conso       Shares - Consolidated                             
ZGBFIN02Shares- Non conso   Shares - Non consolidated                         
ZGBFIN03Shares- Equity basedShares - Invest. in equity based value            
ZGBFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZGBFIN05Shares - Others     Shares - Others                                   
ZINFIN05Shares - Others     Shares - Others                                   
ZITFIN01Shares- Conso       Shares - Consolidated                             
ZITFIN02Shares- Non conso   Shares - Non consolidated                         
ZITFIN03Shares- Equity basedShares - Invest. in equity based value            
ZITFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZITFIN05Shares - Others     Shares - Others                                   
ZITFIN06Shares - AFS        Shares - AFS                                      
ZJPFIN01Shares- Conso       Shares - Consolidated                             
ZJPFIN02Shares- Non conso   Shares - Non consolidated                         
ZJPFIN03Shares- Equity basedShares - Invest. in equity based value            
ZJPFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZJPFIN05Shares - Others     Shares - Others                                   
ZLUFIN01Shares- Conso       Shares - Consolidated                             
ZLUFIN02Shares- Non conso   Shares - Non consolidated                         
ZLUFIN03Shares- Equity basedShares - Invest. in equity based value            
ZLUFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZLUFIN05Shares - Others     Shares - Others                                   
ZMXFIN01Shares - ConsolidateShares - Consolidated                             
ZMXFIN02Shares - Non consoliShares - Non consolidated                         
ZMXFIN03Shares - Inv. in equShares - Invest. in equity based value            
ZMXFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZMXFIN05Shares - Others     Shares - Others                                   
ZNLFIN01Shares- Conso       Shares - Consolidated                             
ZNLFIN02Shares- Non conso   Shares - Non consolidated                         
ZNLFIN03Shares- Equity basedShares - Invest. in equity based value            
ZNLFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZNLFIN05Shares - Others     Shares - Others                                   
ZNLFIN13Investment and shareInvestment and shares-n/conso affiliates          
ZPTFIN01Shares - ConsolidateShares - Consolidated                             
ZPTFIN02Shares - Non consoliShares - Non consolidated                         
ZPTFIN03Shares - Invest. in Shares - Invest. in equity based value            
ZPTFIN04Shares - Invest. in Shares - Invest. in cies linked by part. Interest 
ZPTFIN05Shares - Others     Shares - Others                                   
ZSGFIN01Shares- Conso       Shares - Consolidated                             
ZSGFIN02Shares- Non conso   Shares - Non consolidated                         
ZSGFIN03Shares- Equity basedShares - Invest. in equity based value            
ZSGFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZSGFIN05Shares - Others     Shares - Others                                   
ZSGFIN06Shares - AFS        Shares - AFS                                      
ZTHFIN01Shares- Conso       Shares - Consolidated                             
ZTHFIN02Shares- Non conso   Shares - Non consolidated                         
ZTHFIN03Shares- Equity basedShares - Invest. in equity based value            
ZTHFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZTHFIN05Shares - Others     Shares - Others                                   
ZTWFIN01Shares- Conso       Shares - Consolidated                             
ZTWFIN02Shares- Non conso   Shares - Non consolidated                         
ZTWFIN03Shares- Equity basedShares - Invest. in equity based value            
ZTWFIN04Shares- Cies linked Shares - Invest. in cies linked by part. Interest 
ZTWFIN05Shares - Others     Shares - Others                                   
ZUSFIN01Shares-Consolidated Shares-Consolidated                               
ZUSFIN02Shares-Non ConsolidtShares-Non Consolidated                           
ZUSFIN03Shares-Equity Based Shares-Invest in Equity Based Value               
ZUSFIN04Shares-Comp Linked  Shares-Invest in Comp linked by Part. Interest    
ZUSFIN05Shares-Others-FPDIR Shares-Others Allocation to FPDIR                 
ZUSFIN33Shares-EquityBas.NoCShares-Invest in Equity Based Value (non-consolid)
ZUSFIN34Shares-equi earn affShares-Invest in Equity earn affiliates           
ZUSFIN35Shares-Invest AFS   Shares-Invest AFS                    


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. 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.
  • Field "Asset main no.text" (ANLH-ANLHTXT) must be in English 

Document Management

N/A

Legal Requirement

N/A

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.

N/A


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:

TableFieldData ElementField DescriptionData TypeLengthRequirementNote

ANLA

BUKRS

BUKRS

Company Code

CHAR4Mandatory

Must 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). 

ANLA

ANLN1ANLN1

Main Asset number

CHAR12System generated number

ANLA

ANLN2ANLN2

Asset sub-number

CHAR4

System generated number

The system automatically assigns sub-asset number 0 by default to every asset created. However, the creation of additional sub-assets/child assets is not permitted in the global process designs for S/4HANA.

All sub-assets will be migrated as main asset.

ANLA

TXT50TXA50_ANLT

Asset description

CHAR50MandatoryFor migrated assets, this field will be migrated as it is.

ANLA

TXA50TXA50_MORE

Additional asset description

CHAR50Conditional

For migrated assets, this field will be migrated as it is.

This field is only required if a meaningful description of the asset's nature goes beyond 50 chars and hence can't be captured in its full length in field ANLT-TXT50 due to field length constraints.

ANLH

ANLHTXTANLHTXT

Asset main no. text

CHAR50MandatoryFor migrated assets, this field shall be used to capture the English translation of the asset description

ANLA

XLTXIDXLTXID

Indicator: Long text active

CHAR1Not used

ANLA

SERNRAM_SERNR

Serial number

CHAR18ConditionalFor migrated assets, this field will be migrated as it is (As part of cleansing activities, business maintain a unique number in this field in ECC (PW2 and WP2) for capital spares that is equal to the serial number we maintain in the equipment)

ANLA

MENGEAM_MENGE

Quantity

QUAN13ConditionalFor migrated assets, quantities captured in the legacy systems shall be retained.

ANLA

MEINSMEINS

Base unit of measure

UNIT3Conditional

Must be populated if Quantity is populated

The unit of measure shall be set to 'EA' to facilitate quantity tracking on Fixed Assets for all assets except for:

- Intangible Assets
- AuC Assets
- RoU Assets

For assets of type 'Land and Building' an alternate unit of measure 'M2' can be maintained to track and use the size of the property for subsequent processes.

ANLA

INVNRINVNR_ANLA

Inventory Number

CHAR25Conditional

For migrated assets, the inventory number from the legacy systems shall be adopted for all assets except for capital spare Fixed Assets. For capital spares, the new equipment number from S/4HANA on which the Fixed Asset is installed must be maintained in this field. (This will be finalized by 24 Oct)

Below are the steps in sequence:

  1. Load Fixed Asset Master
  2. Load Equipment master
  3. For Capital Spares, assign Equipment number into field "Inventory Number" 

ANLA

IVDATIVDAT_ANLA

Last Inventory on

DATS8Conditional

This field is only relevant for all Fixed Assets except for:

- RoU Assets (exempted from physical inventory counts)
- AuC assets (exempted from physical inventory counts)

It captures the date of the last asset sighting as part of the physical inventory count process.

For migrated assets, the date from the legacy systems shall be adopted.

ANLA

INKENINKEN

Include asset in inventory list

CHAR1Conditional

For migrated assets, Checkbox (Defaulted to “X”)

This indicator shall be set by default for all Fixed Assets except for:

- RoU Assets (exempted from pyhical inventory counts)
- AuC assets (exempted from pyhical inventory counts)

All tangible Fixed Assets may be subjected to physical inventory counts. By setting this indicator, they will be included in SAP standard reports specifically designed for the physical inventory count process.

ANLA

INVZUINVZU_ANLA

Inventory Note

CHAR15Conditional

It captures the user ID of the person who last confirmed the physical existence of the Fixed Asset as part of the physical inventory count process.

For migrated assets, this field will be migrated as it is. This will be updated with the new target values as per S/4 design after the first inventory count cycle. 

ANLA

AKTIVAKTIVD

Capitalization date

DATS8Optional

For migrated assets, the values from the legacy system shall be adopted.

Must be in date format

ANLA

ZUPERDZUPER

First Acquisition Date

NUMC3Optional

For migrated assets, the values from the legacy system shall be adopted.

Must be in date format

ANLA

DEAKTDEAKT

Deactivation on

DATS8OptionalFor migrated assets retired in the fiscal year of a mid-year go-live (Group 1 Go live), the values from the legacy system shall be adopted.

ANLZ

KOSTLKOSTL

Cost Centre

CHAR10MandatoryMust be valid cost center

ANLZ

PRCTRPRCTR

Profit Centre

CHAR10System generated (TBC)

The profit center is derived from the cost center maintained in the asset master record.

The reason why this field is shown in asset master because segment reporting in FI-AA is activated as some new features in S/4 are only available if this feature is on. With this feature switched on, the profit center must be maintained in the Fixed Asset master. And also, to be able to report Fixed Asset registers by profit center going forward.

Must be valid profit center.

ANLZ

WERKSWERKS_D

Plant

CHAR4Mandatory

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

Plant is a mandatory reporting attribute maintained in the Fixed Asset master for all assets to facilitate the physical inventory count and tax determination processes. The following exceptions apply as the below types of assets do not form part of the physical inventory count process and do not require plant-based tax determination procedures:

- RoU assets (exempted from physical inventory counts)
- AuC assets (exempted from physical inventory counts)

ANLZ

STORTSTORT

Location

CHAR10Conditional or Optional? TBC

For migrated asset, location must be done based on a mapping table (old value in ECC to new value in S4). 

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


ANLZ

RAUMNRAUMNR

Room

CHAR8OptionalMigrate as it is

ANLZ

KFZKZAM_KFZKZ

License Plate No. of Vehicle

CHAR15OptionalMigrate as it is

ANLZ

XSTILXSTIL

Asset shutdown indicator

CHAR1OptionalMigrate as it is

ANLA

ORD41ORD41

Evaluation group 1

CHAR4Optional

Must be valid in Evaluation group 1 in configuration (Tables T087)

It will be migrated based on a mapping table of Evaluation Group 1

ANLA

ORD42ORD42

Evaluation group 2

CHAR4Optional

Must be valid in Evaluation group 2 in configuration (Tables T087)

It will be migrated based on a mapping table of Evaluation Group 2

ANLA

ORD43ORD43

Evaluation group 3

CHAR4Optional

Must be valid in Evaluation group 3 in configuration (Tables T087)

It will be migrated based on a mapping table of Evaluation Group 3

ANLA

ORD44ORD44

Evaluation group 4

CHAR4Optional

Must be valid in Evaluation group 4 in configuration (Tables T087)

It will be migrated based on a mapping table of Evaluation Group 4

ANLAGDLGRPGDLGRPEvaluation group 5CHAR8Not usedNo business requirement identified to use this field in S/4HANA.

ANLA

IZWEKIZWEK

Investment reason

CHAR2Not used

No business requirement identified to use this field in S/4 HANA.

ANLA

ANLUEANLUE

Asset Super Number

CHAR12Not usedNo business requirement identified at Syensqo to use this field.

ANLA

ZUAWADZUAWA

Key for sorting according to assignment numbers

CHAR3Not used

No business requirement identified at Syensqo to use this field.

ANLA

ANEQKANEQK

Indicator: Historical management

NUMC1Not used

No business requirement identified at Syensqo to use this field.

ANLA

LIFNRLIFNR

Account number of vendor (other key word)

CHAR10Optional 

It will be migrated based on a mapping table of Vendor, provided that the vendor is relevant for BP master creation in S/4HANA.

ANLA

AIBN1AIBN1

Original asset number or Original Group Asset number

CHAR12Mandatory

For migrated assets, the legacy asset number is captured in this field.

ANLA

AIBN2AIBN2

Original Sub-Asset

CHAR4Mandatory

For migrated assets, the legacy asset sub-number is captured in this field.

ANLA

AIBDTAIBDT

Original Acquisition Date of AuC/ Transferred Asset

DATS8Optional

Migrate as it is 

ANLA

URJHRURJHR

Fiscal Year of Original Acquisition

NUMC4Not usedNo business requirement identified at Syensqo to use this field.

ANLA

URWRTURWRT

Original Acquisition Value

CURR13Not usedNo business requirement identified at Syensqo to use this field.

ANLA 

POSNRAM_POSNR

WBS element

NUMC8Not used 

This field is not used due to reasons below:

a. It will lead to inconsistencies in terms of data governance as some Fixed Assets have it and others don't.

b. The asset could point to WBS elements that weren't migrated across to S/4 HANA as they are from closed projects. 

ANLA

VMGLIVMGLI

Classification Key

CHAR4Not used No business requirement identified at Syensqo to use this field in S/4 HANA.

ANLV

VSARTVSART_ANLA

Insurance type

CHAR2OptionalIt will be migrated based on a mapping table of insurance type

ANLV

VSINDVSIND

Index series

CHAR5OptionalIt will be migrated based on a mapping table of index series

ANLB

AFABEAFABE_D

Depreciation area

NUMC2System generated

ANLB

AFASLAFASL

Depreciation Key

CHAR4MandatoryIt will be migrated based on a mapping table of depreciation key

ANLB

NDJARNDJAR

Useful Life

NUMC3MandatoryMigrate as it is

ANLB

NDPERNDPER

Useful Life (Period)

NUMC4OptionalMigrate as it is

ANLB

AFABGAFABG

Depreciation Start date

DATS8OptionalMigrate as it is

ANLB

SCHRW_PROZSCHRW_PROZ

Scrap value %

DEC14Conditional

For legacy assets, scrap value percentages shall be adopted unless they are related to corporate (IFRS) depreciation areas. Scrap value percentages must not be used for the leading corporate (IFRS) depreciation areas (areas 01-04 and 99)

ANLB

ANLGRANLGR

Group asset

CHAR12Not used

No business requirement identified to use group assets in S/4 HANA.

Note: Legacy group assets will be split proportionally into the child asset's tax GAAP depreciation areas in ECC before migration to S/4HANA.

ANLB

INBDAINBDA

Operating Readiness

DATS8Not usedNo business requirement identified to use this field in S/4 HANA.


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

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.

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

Report "Unposted asset without any linked object"

Action item:

Business to review this list and take necessary action accordingly.


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
2C3 (Can load but does not comply data standard)

Any assets with an inventory date less than 5 years ago should be checked and potentially retired as part of the data cleansing exercise.

The field "Last Inventory on" date can be used for data cleansing prior to migration to identify aged assets that may no longer exist but haven't been written off.

Action item:

Business to review and retire obsolete Fixed Asset

Report for Assets (Main and Sub-assets) with "Last Inventory on Date" as Blank or less than 5 years ago. 

Cleansing report is created for businesses to do cleansing on a regular basis.

As the physical count date will always be 31 Oct, 
cleansing report will be created to list down assets that have an inventory date less than 1 Nov 2023 for PF2 and 1 Nov 2024 for WP2

For PF2:
Any assets with an inventory date less than 1 Nov 2023 should be checked and potentially retired as part of the data cleansing exercise

For WP2:
Any assets with an inventory date less than 1 Nov 2024 should be checked and potentially retired as part of the data cleansing exercise

Rule 1: Company must be in scope

Rule 2: Plant must be in scope

Rule 3: Asset class is not Asset under Construction and is not RoU asset and is not Group Asset

Rule 4: Has Deactivation date = BLANK.

Rule 5: Has Last Inventory on Date = BLANK or less than 5 years ago from Mock Conversion/Actual Cutover.

 

Region

Company code

Asset number

Sub-Number

Description

Last Inventory on

Inventory Note

Cost Centre

Cost center category

Profit center

Asset Class

GL Account

Capitalization Date

PF2 and WP2
3C1 (Cannot load)

Report "Fixed Assets with negative net book value"

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.


Country

Company code

Asset number

Asset Sub-Number

Asset Class

Description

Deactivation date

Capitalization date

Current NBV for each depreciation areas

Action item:

  • Business must review these assets whether to retire the assets or post the debit memo to bring it at least to zero
PF2 and WP2
4C2 (Can load, but business process will fail)

Report that shows Asset balance booked directly to GL (without posting to Fixed Asset subledger) (Transaction code ABST2)


Action item:

  • Create asset master and post asset acquisition or scrap the balance from GL.
PF2 and WP2
5C3 (Can load but does not comply data standard)

A soft link is required between equipment and Fixed Assets for capital spare parts. For Fixed Assets which represent capital spare parts, the ones that are in use in the plant will be linked to an equipment. 

For to-be design, we will not have dedicated asset class for “Capital Spares”

As part of cleansing activities, Business must identify manually which asset master which represent “Capital Spares”, after that for these assets, business must assign:

a. New S/4HANA equipment number into field "Inventory Number" in S/4HANA

b. Serial number of equipment number into field "Serial Number" in ECC (This is as preparation to migrate to S/4HANA)

Note: A2D team does not need to assign Fixed Asset number into Equipment master.



PF2 and WP2
6C3 (Can load but does not comply data standard)

Extract the asset description of field ANLA-TXT50 and ANLA-TXA50 for business to translate it into English


Action item:

  • Business to translate asset description into English.

7C2 (Can load, but business process will fail)

Scrap values must not be used for the leading corporate (IFRS) depreciation areas (depreciation area 01-04 and 99)

For legacy assets, scrap values shall be adopted unless they are related to corporate (IFRS) depreciation areas.

 


Action item:

  • Business to cleanse assets that have Scrap Value in S4/HANA target depreciation area 01-04 and 99

8C2 (Can load, but business process will fail)

Report to list down the group assets with the underlying active assets 

Rule 1: Company codes must be in scope.

Rule 2: Indicator Asset is a group asset (ANLA-XANLGR) is “X”

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

Result: List of group assets.

Extract the underlying assets by specifying the list of group assets in table ANLB


Action item:

  • Business to embed the tax depreciation values of the group asset proportionally across all underlying individual assets which make up the group assets.


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:

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


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

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 Migrate. This 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 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

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
N/A




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

N/A

Extraction Dependencies

List the steps that need to occur before extraction can commence

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


Copy value from source to target system.

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

Business rule in S4/HANA:

All asset sub numbers will be migrated as a regular asset number. System validation is created to prevent the use of sub-assets in S/4HANA.


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

Must be populated if Quantity is populated

The unit of measure shall be set to 'EA' to facilitate quantity tracking on Fixed Assets for all assets except for:

- Intangible Assets
- AuC Assets
- RoU Assets

For assets of type 'Land and Building' an alternate unit of measure 'M2' can be maintained.

Map from source to target via unit of measure mapping table

12.   

PF2 and WP2

ANLA

INVNR

Inventory Number

S/4HANA

ANLA

INVNR

Inventory Number

Copy value from source to target system for all assets except for capital spare fixed assets.

For capital spares, the new equipment number from S/4 HANA on which the Fixed Asset is installed must be maintained. This is still subject to DA review and endorsement. which will be finalized by 24 Oct.

Hence, object 1002 must be loaded first then this field will be updated with equipment number for capital spares.

14.   

PF2 and WP2

ANLA

IVDAT

Last Inventory On

S/4HANA

ANLA

IVDAT

Last Inventory On

Copy value from source to target system.

15.   

 PF2 and WP2

ANLA

INKEN

Include asset in inventory list

S/4HANA

ANLA

INKEN

Include asset in inventory list

Checkbox (Defaulted to “X”)

16.   

PF2 and WP2

ANLA

INVZU

Inventory Note

S/4HANA

ANLAINVZU

Inventory Note

Migrate with the existing values in the legacy system. This will be updated with the new target values as per S/4 design after the first inventory count cycle after go live.

17.   

PF2 and WP2

ANLA

AKTIV

Capitalization date

S/4HANA

ANLAAKTIV

Capitalization date

Copy values from source to target system.

18.   

PF2 and WP2

ANLA

ZUPER

First Acquisition Date

S/4HANA

ANLAZUPER

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

Copy value from source to target system.

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 to target system via Evaluation Group 1 mapping table

27.PF2 and WP2ANLAORD42Evaluation group 2S/4HANAANLAORD42Evaluation group 2Map from source to target system via Evaluation Group 2 mapping table

 28.

PF2 and WP2

ANLA

ORD43

Evaluation group 3

S/4HANA

ANLA

ORD43

Evaluation group 3

Map from source to target system via Evaluation Group 3 mapping table

 29.

PF2 and WP2

ANLA

ORD44

Evaluation group 4

S/4HANA

ANLA

ORD44

Evaluation group 4

Map from source to target system via Evaluation Group 4 mapping table

30.

PF2 and WP2

ANLA

ANLN1

Asset Number

S/4HANA

ANLA

 


AIBN1

Original asset number

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

31.

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. 

 

32.

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.

33.

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.

34.

PF2 and WP2

ANLA

URWRT

Original Acquisition Value

S/4HANA

ANLA

URWRT

Original Acquisition Value

Copy value from source to target system.

35.

PF2 and WP2

ANLB

AFABE

Depreciation area

S/4HANA

ANLB

AFABE

Depreciation area

Map from source to target via Depreciation area mapping table.

36.

PF2 and WP2

ANLB

AFASL

Depreciation Key

S/4HANA

ANLB

AFASL

Depreciation Key

Map from source to target via Depreciation Key mapping table.

37.

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.

38.

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.

39.

PF2 and WP2

ANLB

AFABG

Depreciation Start date

S/4HANA

ANLB

AFABGDepreciation Start date

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

40.

PF2 and WP2

ANLB

SCHRW

Asset scrap value

S/4HANA

ANLB

SCHRW

Asset scrap value

Copy value from source to target system unless they are related to corporate (IFRS) depreciation areas.

41.

PF2 and WP2

ANLB

SCHRW_PROZ

Scrap value %

S/4HANA

ANLB

SCHRW_PROZ

Scrap value %

Copy value from source to target system unless they are related to corporate (IFRS) depreciation areas.


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

Unit of measure

Mapping of legacy unit of measure to SyWay unit of measure

Cost center

Mapping of legacy cost centre to SyWay cost centre

Profit center

Mapping of legacy profit centre to SyWay profit centre

Plant

Mapping of legacy plant code to SyWay plant code

Location

Mapping of legacy location to SyWay location

Evaluation group 1 

Mapping of legacy EG1 to SyWay EG1

Evaluation group 2

Mapping of legacy EG2 to SyWay EG2

Evaluation group 3

Mapping of legacy EG3 to SyWay EG3

Evaluation group 4

Mapping of legacy EG4 to SyWay EG4

Insurance Type

Mapping of legacy insurance type to SyWay insurance type

Insurance Index Series

Mapping of legacy insurance index series to SyWay insurance index series

Depreciation area

Mapping of legacy depreciation areas to SyWay depreciation areas

Depreciation key

Mapping of legacy depreciation key to SyWay depreciation key

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

The following pre-load validations will be performed by the 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 2 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)

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

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


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

List the Configurations required before loading can commence

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 9A  

Conversion Objects

Object #Preceding Object Conversion Approach
1073Profit Centre
1074Cost Centre
1002Equipment

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 TypeError DescriptionAction Taken

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

The following post-load validations will be performed by the 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:

·       Company Code

·       Asset Class

·       Asset Description

·       Asset Main Number Text

·       Cost Centre

·       Profit Centre

Depreciation terms

·       Depreciation Key 

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



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 2 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)

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.


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

Insert links and references to other documents which are relevant when trying to understand this decision and its implications. Other decisions are often impacted, so it's good to list them here with links. Attachments are also possible but dangerous as they are static documents and not updated by their authors.

Change log

Workflow history