Skip to Content
Author's profile photo Ranu Eugene

Asset Cutover process in sFin S4 Hana

Hi All,

 

Hope you people are doing great,I have jotted down the process of asset cut over assuming that prerequisites for asset upload are at place(All configuration for Asset in Sfin as there are many dicussion/document for the same).

 

 

Asset Cut over process has changed since inception of sFin S4 Hana.

 

Earlier we use to upload asset master data and take over value through AS91 and for posting any JV entry we use to use OASV.

 

Now in sFin S4 Hana the upload process has changed,OASV  T code has been removed from the system. In AS91 transaction type field has been removed.

 

A new T code has been introduced for uploading values for asset i.e ABLDT.

 

One can use AS91 to create asset master and then can use ABLDT for uploading the values of that asset only if there are few number of asset (which is not possible practically) and one cannot even make LSMW or BDC for the T code ABLDT so practically using AS91 and ABLDT is not possible in sFin.

 

For creation and uploading takeover values use BAPI_FIXEDASSET_OVERTAKE_CREATE, this BAPI will create the asset master as well as upload the values simultaneously(Of course you need to take help of ABAPER for mapping the fields of BAPI and making a z Tcode for uploading the asset).

 

Please find the attached file of BAPI.(BAPI Aset previous year and BAPI asset current year),I have attached .txt format as .xls format is not supported,please copy and paste n excel for having better understanding of the BAPI file.

 

Now when you upload Asset (if company is going live in mid-year) then the accounting entries will be as follows. If company is going live in year-end then there is no problem as there will not be any ordinary depreciation.

 

/wp-content/uploads/2016/09/asset_1037625.png

Here all the entries are fine except that the ordinary depreciation is not hitting the expense account (5 series ordinary deprecation account).

For doing this you need to create a JV using F-02

 

The entry should go according to cost center level and entry will be.

 

Ordinary Dep A/C  dr (5 series GL)

To Upload A/c (9 series GL)

 

 

Hope this will be helpful for all.

Any Suggestions or Critics will be highly appreciated as this will help me to Improve in Future.

Regards

Eugene

Assigned Tags

      62 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sanil Bhandari
      Sanil Bhandari

      Hi

      A confusion for most of the consultants on S/4HANA finance projects. This will really help many in the fraternity.

      Keep up the good work  Ranu Eugene Thanks for sharing

      Regards

      Sanil Bhandari

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Sanil,

      Thanks a lot for your kind words which keeps me motivating.

      Regards

      Eugene

      Author's profile photo Former Member
      Former Member

      Hi Ranu, As Sanil rightly said, New asset accounting really a grey area for many real-time consultants after S/4HANA Finance introduction. This document will throw more light on this area. Very information and useful. Keep sharing... BTW, I want to ask you one thing relating to NEW Asset Accounting as how you are dealing with different fiscal year variant in S/4 HANA Finance as we have this limitation that Non leading ledger fiscal year variant cannot be different with leading ledger fiscal year variant Regards Karthikeyan

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Karthikeyan,

      Thanks for your encouraging words.

      Well to be very frank I did not had this scenario(was lucky not to have 😉 ) but there is one note released by SAP I guess.

      SAP note 2220152 - Ledger approach and Asset Accounting (new): Non-calendar fiscal year variant for parallel valuation


      Regards

      Eugene

      Author's profile photo Abhay Parekh
      Abhay Parekh

      Thanks for sharing the document... It will help a lot in HANA implementation but one thing i would like that why SAP has not allowed to get LSMW,BDC for ABLDT.. Don't you think it wierd thing?? D

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Abhay,

      Thanks for encouraging words.

      Yes there is no LSMW or BDC for ABLDT which is bit weird.

      Regards

      Eugene

      Author's profile photo Arjun Malviya
      Arjun Malviya

      Great Document, Ranu... 🙂

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Thanks for your kind words. 🙂

      Regards

      Eugene

      Author's profile photo Bala Choda
      Bala Choda

      Great Ranu and appreciated the details.

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Thanks Bala for your kind and encouraging words.

      Regards
      Eugene

      Author's profile photo Bharathkumar Nallamalli
      Bharathkumar Nallamalli

      Thanks Ranu for sharing the knowledge. It really helps every one.
      I have a question.  As per my understanding, Data migration to S/4 Hana is required only in cases of migrating from Non SAP to S/4 Hana. But from ECC to S/4 Hana, data base can be migrated using SLT by Basis team. Correct me if I am wrong.

      Author's profile photo irala reddy
      irala reddy

      Hi Ranu

       

      Thanks for sharing this updates on S4HANA relating to Asset Accounting.

      It is a big draw back /grey Area to all FI Consultant  on upgrade from ECC 6.0 to SAP-S4 HANA in AA point of view.

      Uploading of AA Master data /cut over values is very big confusion/difficult process to all (not like earlier AS91)...just  Live with it...

       

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Irala,

       

      Thanks for your kind words.

      Yes you are absolutely right as this is big grey area and we have to live with it. 🙂

       

       

      Author's profile photo Ahmed Salman
      Ahmed Salman

      Great work Ranu, i'm stuck on asset uploading for two days. and you have said it is done using the BAPI, but i can't find the attached .txt file, was it removed?

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Salo,

       

      I think it has been removed.

       

      Regards,

      Eugene

      Author's profile photo TechEdge TechEdge
      TechEdge TechEdge

      Thank You

      Author's profile photo Shakir Shaikh
      Shakir Shaikh

      Good work Ranu ,it will be of great help to all those working in S4HANA projects.

      *** Just a minor correction , you have stated BAPI name as-

      ‘BAPI_FIXEDASSET_TAKEOVER_CREATE’ however its actually ‘BAPI_FIXEDASSET_OVRTAKE_CREATE.

      Additionally we can also refer below notes pertains to asset legacy upload :-

      • 2208321
      • 2235848
      • 2331123

       

      Kind Regards,

      Shakir

       

      Author's profile photo Former Member
      Former Member

      Hello Ranu,

      Hello togheter,

       

      thx very much for your comments. actual i am trying to migrate datas trough LSMW and the mentioned "BAPI_FIXEDASSET_OVERTAKE_CREATE" and it works fine. The only Problem is that i don´t know how to migrate the takeover values for more than one depreciation area simulataneously (there is only one target field). Can somebody help me ?

       

      Best regards

      Stefano

       

      Author's profile photo Former Member
      Former Member

       

      Hi Ranu

       

      Thanks for your sharing .

      Do you know whether can  i transfer legacy data directly from a Microsoft Excel file into S/4 System? i search this article and fellow its step & structure http://10.1.3.174:1080/saphelp/PLAINHTM/ZH/70/93a417ecf411d296400000e82debf7/frameset.htm

      but i meet some question without solving.I am not sure this t-code AS100 using normally in s/4,I expect  you to give me some suggestion as well as  using ‘BAPI_FIXEDASSET_OVRTAKE_CREATE.'

      thank you a lot and hoping your reply.

      Author's profile photo Former Member
      Former Member

      Hi Ranu,

       

      I can't find the attached files of BAPI.(BAPI Aset previous year and BAPI asset current year).

      Could you please send them to me on my personal mail hassan.randa@gmail.com

      Thanks in advance,

      Randa Hassan

      Author's profile photo Tathiana Elizabeth Serna Castillo
      Tathiana Elizabeth Serna Castillo

      Hello Randa,

      Were you able to receive the file? I was looking for it also...

      Regards,

      Ime

      Author's profile photo Maria Defago
      Maria Defago

      Hi Ranu,

      Very useful your information, thank you very much

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Maria,

       

      Thanks for your kind and encouraging words.

       

      Regards

      Eugene

      Author's profile photo KAPIL MEHTA
      KAPIL MEHTA

      Hi Ranu

      Thanks for sharing this knowledge article.

      I am executing BAPI_FIXEDASSET_OVRTAKE_CREATE and getting error message F5 611 "Acct determination for Additional accounts for Asset Accounting with keys not defined in ch/acts 1000 "

      Do you know why this error occurs ? I have done configuration as per note 2331123.

      Also what are settings required for IDoc in this process.

      Regards

      Kapil

      Author's profile photo Rohit Yadav
      Rohit Yadav

      Nice Information Ranu!!!

       

      Reagrds,

      Rohit Yadav

      Author's profile photo Monisa Nath
      Monisa Nath

       

       

       

      Hi Ranu,

       

      I can’t find the attached files of BAPI.(BAPI Aset previous year and BAPI asset current year).

      Could you please send them to me on my personal mail  manoj_020@yahoo.co.in.

      Thanks in advance,

      Regards

      Author's profile photo Former Member
      Former Member

      Hi Ranu,

       

      Very helpful information! I cannot see the attached document. Can somebody please send me these files : chemlal.amal@gmail.com

      Thank you in advance

      Amal

      Author's profile photo Mani VS
      Mani VS

      Hi Ranu,

      Thanks you so much for more useful and helpful information 🙂

      Please send me the txt and exl formats to my mail id Lnarayana2008@gmail.com. which will be more helpful for me.

       

      Regards,

      Lakshmi Narayana

       

       

      Author's profile photo Former Member
      Former Member

      Hi Ranu,

      Thanks a lot for  sharing such a wonderful information about the asset migration process in S4 Hana.

      Could you share the text file for uploading in my mentioned mail id - debadutta.bbsr@gmail.com.

      I would also request the forum ,if any one has the file please share.

       

      Regards,

      Deb

      Author's profile photo Former Member
      Former Member

      Hi Ranu,

      I am Using the BAPI as mentioned above but when we are mainatining values in Cumulative table  system is not updating the values.

      COuld you please send me the file of BAPI.(BAPI Aset previous year and BAPI asset current year) over my email ID please date.abhay@gmail.com

      Author's profile photo Former Member
      Former Member

      Could any one please help to know what is the difference between the BAPI Aset previous year and BAPI asset current year

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Abhay,

      When I created this document then I had attached the format files (BAPI Aset previous year and BAPI asset current year) in .xls and .txt but during migration of SCN from old version to new version the file got removed, so those two are names of files which I had attached.

       

      Hope it's clear now.

       

      Regards

      Eugene

      Author's profile photo Eudes Jesuino da Silva
      Eudes Jesuino da Silva

       

      Hi Ranu,

      Thanks you so much for information.

      I am currently using transaction AS100, it works correctly for load.
      Has anyone ever used it?

       

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Eudes,

      Thanks for update.

      Which version of S4HANA you are working on.

       

      Regards,

      Eugene

      Author's profile photo Former Member
      Former Member

      Hi Ranu,

      Really very useful your information on legacy asset upload  thank you very much

      Could you share the text/excel file for uploading in my mentioned mail id – abdul.aby@gmail.com

      Author's profile photo Ajay Gautam
      Ajay Gautam

       

      Hi Ranu,

      Really very useful your information on legacy asset upload. Thank you very much for sharing the information

      Could you share the text/excel file for uploading in my mentioned mail id – maheshwarichandan19@gmail.com

       

      thanks

      Author's profile photo Consultores Funcionais
      Consultores Funcionais

      Can you please send the file to ktnob@hotmail.com.

      I am supporting an Asset Data Migration during fiscal year for S4CORE 102 environment,

      Thanks a lot! Kind regards,

      Kirtan

      Author's profile photo Former Member
      Former Member

      Hi Ranu,

      Thanks a lot for sharing information about the asset migration process in S4 HANA.

      Could you share the text files for uploading on my email id – atifamin103@gmail.com

       

      Regards,

      Atif Amin

       

      Author's profile photo William Chi
      William Chi

      Hi Ranu,

      This is really helpful to understand how to upload asset value in S/4 Hana. Because im new in S/4 Hana. Btw, how can i find BAPI_FIXEDASSET_OVRTAKE_CREATE in SAP? and can you send to me the template to Jonah.William.Chi@gmail.com
      Thank you very much

      Regards,
      William

      Author's profile photo Monika Patel
      Monika Patel

      Greetings,  Requesting if you can attach/share the txt files mentioned in blog.

      Author's profile photo P VENKAT
      P VENKAT

      Great hardwork keep it all.

      Author's profile photo Erica Spinabelli
      Erica Spinabelli

      Thanks for the detailed information Ranu, can you please re-attach the file format you mentioned in first post?

       

      Thanks!
      Erica

      Author's profile photo Atul Bhatnagar
      Atul Bhatnagar

      Hi Ranu,

      Would it be possible for you to send me the file format. Thanks a lot for the article

      Author's profile photo Atul Bhatnagar
      Atul Bhatnagar

      Forgot to mention my email :    atul.bhatnagar@gmail.com

       

      Author's profile photo srinivas Naidu
      srinivas Naidu

      Very helpful information! I cannot see the attached document. Can somebody please send me these files : psdb2227@gmail.com 

       

      Thanks & Regards.

      Naidu

      Author's profile photo Mohamed Naushad
      Mohamed Naushad

      Hi All,

       

      Can any one share the file to mohamednau@gmail.com

      Author's profile photo Ahmed Ibrahim
      Ahmed Ibrahim

      thanks for blog

      Author's profile photo Sauvik Chatterjee
      Sauvik Chatterjee

      Hi, Pls. Share the file to souvikchatterjee@live.com.

      Great to study this and enriched from your valued effort and I heartily appreciate it.

      Author's profile photo Maria Eugenia Batistutti Centurion
      Maria Eugenia Batistutti Centurion

      Hola! Mi email es mebatistutti@hotmail.com

       

      Podrian enviarme el archivo a mi mail? Por favor, se los agradecería

      Author's profile photo JAGANATHAN RAJAGOPAL
      JAGANATHAN RAJAGOPAL

      nice presentation., can u share some pdf file relating the same to rjaganathangopal@yahoo.co.in

      Author's profile photo ITSS-SAP03 Hi-P
      ITSS-SAP03 Hi-P

      Hi Ranu, thanks for sharing.

      My question is, is it correct that not to transfer the balance in 9 series GL to other account(s) if the company code is going live at the end of year.

      I know that 9 series GLs are off-balance-sheet items. But before S/4 version (e.g. ECC or R/3), the 9 series GL will not be hit during the asset data migration. Therefore no balance will be kept on the 9 series GL.

      But in S/4, it seems the balance in 9 series GL have to be remained and what we could do is just exclude 9 series GL from the statutory report.

      Author's profile photo Functional Zensar
      Functional Zensar

      Dear Ranu,

       

      Very helpful information!

      Can someone please send me upload template to radhika_sun08@yahoo.com

       

      Thanks & Regards

      Radhika Sunalkar.

      Author's profile photo VACS Support
      VACS Support

      Hi...Where is the attachment?

      Author's profile photo RAKESH YEDAVALLI
      RAKESH YEDAVALLI

      Hi Ranu,

      This is a interesting read.. Thanks for sharing the info.

      Can you please send the the attachment to yedavallirakesh@gmail.com.

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      HI Rakesh,

      Please check your mail have shared the format.

       

      Regards,

      eugene

      Author's profile photo Boris Milanovic
      Boris Milanovic

      Dear Ranu,

      great post!

      Can someone please send attachment to boris.m.milanovic@gmail.com

      Tnx and Regards

      Boris

      Author's profile photo Ranu Eugene
      Ranu Eugene
      Blog Post Author

      Hi Boris,

      Thanks a lot for your kind words.

      Please check your mail.

       

      Regards,

      Eugene

      Author's profile photo Varun Kumar
      Varun Kumar

      Hello Ranu,

      I cant express in word that what a simplified method you have shared. Its really helpful to everyone and its really appteciated for your hard work. Keep it up.

      Can you please share that BAPI text file on "facebook.raj22@gmail.com"

      Regards,

      Raj

      Author's profile photo Priya Gupta
      Priya Gupta

      Hi Ranu,

      This is interesting and helpful. Thanks for sharing the info.

      Can you please send the attachment to priya.sapfi@gmail.com

       

      Thanks in advance

      Priya

      Author's profile photo Pradyumna Nayak
      Pradyumna Nayak

      Hi Ranu,

       

      Thanks for sharing the info.

      Can you please send the the attachment to mr.pradyumna@gmail.com

      Author's profile photo Sagar Dhange
      Sagar Dhange

      Hi Ranu,

      Can you please share the .txt file on email sdhange222@gmail.com?

      Author's profile photo Varun Kumar
      Varun Kumar

      Hello Ranu,

      I cant express in word that what a simplified method you have shared. Its really helpful to everyone and its really appreciated for your hard work. Keep it up.

      Can you please share that BAPI text file on "facebook.raj22@gmail.com"

      It's a very urgent please share text file on mail ID.

      Regards,

      Varun