Manually Upload Current Year Fixed Asset Sap Hana

ASSET Master Upload

The purpose of this document is to provide brief overview on Asset Main Data upload process in the SAP system. This document is for the consultants who are doing first fourth dimension Asset Chief Data Upload. At the time of upload they face a lot of doubts, question as how to carry out the upload in the system. This is a very bones document for Asset Master Data upload.

Video : youtube.com/watch?v=NFQj8YbM2AE

There are 2 kinds of Asset Master Upload during cut over. Mid Twelvemonth and Year End.

Beneath is the scope of the blog.

1. Year End Upload/Midyear Upload
2. Asset Master/Transaction Data reset
3. Files for Yr End Upload
4. Files for Mid Year Upload
5. Pre-checks.
6. Reconciliation
7. Tips
8. Asset Balance Upload
9. FAQs

In this certificate we volition focus on Midyear upload equally this process cover year end upload too.

1. Year Stop Upload/Midyear Upload

• Setting of Engagement in the organisation.

This is the almost important footstep for Asset Master Information upload. If you have midyear upload, for eastward.one thousand. 28.02.2019, y'all have to mention this engagement in the system. Please see below screenshot.

In one case the appointment is mentioned in higher up screen, set the twelvemonth and Menstruum. Please come across below screenshot. One time you lot put the year and period, Depreciation field for electric current twelvemonth in AS91 is activated. This will exist explained in coming screens. We have provided yr as 2019 and menstruation every bit 2.

• Uploading of Asset Chief Data through AS91. Avails Acquired earlier 01.01.2019

When you are uploading Nugget Master Information in midyear, get-go upload all assets acquired before 01.01.2019. This will have 3 fields. Cumulative Conquering value, Accumulated Ordinary Depreciation and Ordinary Depreciation Posted. It ways Cumulative Acquisition value and Accumulated Ordinary Depreciation will take values till 31.12.2018. For depreciation from 01.01.2019 to 28.02.2019 will be posted in Ordinary Depreciation Posted.

Enter Asset Class and Company lawmaking.

Enter all details every bit per your requirement.

Date 'Capitalized On' is most important date. This will come from legacy file. This engagement is mandatory and you cannot upload without this. After you enter all Chief Data details, click on takeover box in below field.

Enter Value in Cumulative Acquisition value and Accumulated Depreciation equally shown beneath.

Enter Ordinary Depreciation for 01.01.2019 to 28.02.2019 in below field. This Ord. Dep. Posted field is activated when Mid Year date is provided in above steps.

• Uploading of Asset Primary Information through AS91. Assets Acquired On or Subsequently 01.01.2019

In this scenario, all the steps will be same as below. Only Capitalization date will differ.

Capitalization date in below screen will exist 01.01.2019 or any engagement later on than this.

When you put the date of 2019, below screen volition announced. All fields are blurred. You cannot enter whatever amount here. Click on Transactions field shown in below screen.

In below screen, enter Nugget Value date, Transaction type and Corporeality in book depreciation. If you have more depreciation area, enter in all areas. Hither we are but entering in 01. Click on save push. Transactions means all assets purchased on or after 01.01.2019 and this have to be entered every bit shown beneath.

In this manner Asset master is uploaded in SAP during cutting over. If yous find any mismatch in the values, y'all tin can erase and re-upload the data in the organisation.

2. Asset Master/Transaction Data reset

What if in last moment its identified that entire Asset Primary/Transaction data uploaded are incorrect? Zippo to worry. Reset asset data for respective company lawmaking as shown in below screenshot.

Path – Financial Accounting (New) – Asset Accounting – Preparing for Production Startup – Tools – Reset Company Code

If y'all select line item, information technology will delete all transaction information. If yous do not select, it will delete all Primary/Transaction data.

Proper approvals to exist taken before deleting this information.

Once data are deleted, post GL entries through ABF1L tcode. Refer my blog for ABF1L

https://blogs.sap.com/2019/03/thirteen/asset-reconciliation-account-posting/

three. Files for Yr End Upload

Please note below points for Year Terminate Upload.

• Only one file is required from customer for the twelvemonth end.
• In amount column it volition take
  • Acquisition amount and
  • Accumulated depreciation.

Year end uploads is very elementary.

4. Files for Mid Year Upload

Delight note below points for Mid Year Upload.

• 2 files will exist required for Mid year upload from the client.
• 1st  for year end. In our case it will be 31.12.2018. This file will have all asset acquired till 31.12.2018 This file volition have 3 amounts.
  • Conquering cost,
  • Accumulated Depreciation and
  • Depreciation posted for 2 period
• 2nd file for 2019 acquisition. This should have Acquisition date and below amounts
  • Acquisition amount,
  • Ordinary Depreciation posted for 2 months.

five. Pre-checks.

Earlier carrying out AS91, beneath items should be verified.

• Depreciation keys are created.
• Asset Class are unlocked.
• Cost Centers are created.
• Configuration is moved to production.
• GLs are maintained in AO90.
• GLs are created.
• Price Centers are unblocked.
• Correct uploads dates and periods are maintained in SPRO.
• Cheque AJRW and AJAB settings are verified. This is very important. While upload any error is received kickoff check this.
• Program to upload the asset master is ready. Test data are uploaded.
• …….and could be many more than.

half dozen. Reconciliation

Adopting right reconciliation approach is very essential. If reconciled with correct approach, will save lot of time. Else it would crave few days to consummate this activity. Please note below points for reconciliation:

• Reconcile at Asset Course level outset. This will give clear moving picture as which form are not tallying and where to drill downwards.
• Reconcile at Toll heart level post Asset Course reconciliation above.
• Reconcile at Asset level mail service cost center reconciliation to a higher place.
• Brainwash in a higher place approach to user as it will relieve time.

7. Tips

• Put quondam asset number in Inventory number field for tracking.
• Do not tick Negative values while uploading. This will prevent uploads of Negative NBV Asset.
• Request separate file for Sub Number assets.
• Upload Nugget Balance using ABF1L transaction lawmaking instead of OASV.

8. Asset Balance Upload

• Do non use OASV to upload Asset remainder.
• Utilize ABF1L to upload Asset Residue.
• ABF1L tin can also exist used to post entries in future.
• ABF1L allows to post entries in Asset Recon. Account.

Please refer my blog https://blogs.sap.com/2019/03/13/asset-reconciliation-account-posting/ for detail steps.

9. FAQs

Q What is the difference between year end and mid twelvemonth upload?

A  Year end upload is pretty simpler. It will have merely ane file template to upload. Mid Year Upload volition have ii files templates.

Q What additional details are required in Mid Year Upload?

A  Mid year upload requires below additional detail

– Depreciation posted for current Fiscal Year along with Cost, Accumulated Dep.

– Asset Purchased during the current year.

Q What are the tcode for upload of asset master?

A AS91 to Create, AS92 to change and AS93 to display Asset Main

Q What additional settings are required for mid twelvemonth upload

A In SPRO, yous need to maintain Period of electric current fiscal twelvemonth till which you will upload the closing residual.

Q What happens when yous maintain  the period in SPRO?

A Depreciation Amount field gets activated in AS91 when you maintain the period in SPRO

Q What if Asset Master upload fails and tomorrow is go live?

A  First Reset nugget master data at company lawmaking level. Path – Financial Accounting (New) – Asset Bookkeeping – Preparing for Production Startup – Tools – Reset Company Code

And then Post entries in ABF1L

Q Does ABF1L allows posting in Reconciliation Account?

A Yes. No need to utilise OASV.

Q How to reconcile the data uploaded with file?

A Adopt systematic approach. Brainstorm with Macro level, then Mid and then at micro level. Macro is at asset class level. Tally your data in File with SAP data at asset class level.

Q At time of first upload, sometime organization throws error. How to handle that?

A Check AJRW or AJAB or if Depreciation surface area is blocked.

Q What is the all-time tool to upload the asset master?

A  LSMW is best tool to upload the Nugget Master in ECC.

Q What is the pre-checks for Asset Upload?

A There are many but some important ones are below

Cost/Profit Centre Created and Agile

GL created and not blocked.

Internal order created and active

Configuration is completed

Dep Keys are created

Nugget Class are created.

Dep surface area are unblocked at Asset Class level

Templates are ready and filled correctly.

Templates are properly Explained to Client

Q What if few avails are created in other asset grade?

A Either delete or block if for future use.

Q How to avoid Major corrigendum in Asset Upload?

A Upload few assets in each asset class and transport for customer review. After blessing, upload remaining nugget.

Q How to create a link between Legacy and SAP data?

A Update inventory number field in SAP with Legacy asset number. This may aid in correcting, changing or reconciling the information.

Q How to upload assets having negative value?

A Check neg values allowed in dep area in nugget master. Upload.

Q How to handle sub numbers?

A Create split up LSMW for sub number. Ask client to provide separate file for assets have sub numbers.

Q When you lot upload asset master, GL entries are also posted in FI?

A No. Only asset balances are uploaded. Nothing is posted in FI

Q How GL entries are posted?

A GL entries are posted through OASV or ABF1L.

Q How AUC is posted?

A Project system volition upload WBS values and settle to AUC. No activeness from Finance.

Q Later go live tin we upload missed assets?

A Yes. Merely accept proper approval from higher management

Q How to receive the file from client?

A Avoid file exchange on email. Tell client to upload file in client. Ser the SOP for this

Q Which Transaction Type is used for Electric current Year Acquisition?

A Transaction Type 100

Q What is the Default Depreciation Primal for AUC?

A 0000 should exist the default depreciation key

I hope this certificate is helpful to you.

Regards

Zunaid

Other Blogs

1. Why choosing SAP Profile as a career could be all-time decision for anyone?

https://blogs.sap.com/2021/08/xviii/why-choosing-sap-contour-every bit-a-career-could-exist-all-time-decision-for-anyone/

2. FI – SD Integration – VKOA – Understanding Menstruum – SAP ECC

https://blogs.sap.com/2020/11/12/fi-sd-integration-understanding-concept-sap-ecc/

3. IDOC Management – Mass Change – WLF_IDOC, Foreground Processing and other IDOC Activities.

https://blogs.sap.com/2020/08/04/idoc-mass-change-mass-processing-wlf_idoc/

4. SAP ' Z Process Re-Engineering' – Heighten the productivity of the implemented solution

https://blogs.sap.com/2020/08/03/enhance-the-productivity-of-the-implemented-solution-sap-process-re-applied science./

5. LSMW Recording for Transaction Data – FB01

https://blogs.sap.com/2020/06/26/lsmw-for-transaction-data-fb01/

6. SAP FICO Data Migration – Global Execution, Planning and Approach

https://blogs.sap.com/2020/06/01/sap-fico-information-migration-global-execution/

7. LTMC S/4HANA replacing LSMW – Migration cockpit – Data Migration

https://blogs.sap.com/2020/01/18/ltmc-s-4-hana-replacing-lsmw/

8. S/4 Hana – House Depository financial institution, Bank Account and Account ID Overview

https://blogs.sap.com/2019/10/18/s4-hana-house-banking concern-bank-business relationship-and-account-id-overview./

9. AUC Automated Creation from WBS – S/4 HANA

https://blogs.sap.com/2019/09/27/auc-automatic-creation-from-wbs-s4-hana/

10. S/4HANA Finance – New vs Old transaction lawmaking

https://blogs.sap.com/2019/09/23/sap-hana-new-vs-sometime-transaction-code./

11. Profit Center – Assignment/Removal of Company code and Activation

https://blogs.sap.com/2019/07/17/profit-center-assignmentremoval-of-visitor-code-and-activation/

12. SAP S/4HANA Finance – New Additions, Features and Functionality

https://blogs.sap.com/2019/03/26/sap-s4-hana-features/

13. AS91 – Nugget Master Upload

https://blogs.sap.com/2019/03/25/as91-asset-master-upload./

14. Asset Reconciliation Account Posting ABF1L- No OAMK, OASV

https://blogs.sap.com/2019/03/13/asset-reconciliation-account-posting/

15. Mass Upload Functionality – SAP

https://blogs.sap.com/2019/03/12/mass-upload-functionality-sap/

16. Fiori App List

blogs.sap.com/2021/11/25/fiori-app-list-south-4hana/

mooregreder.blogspot.com

Source: https://blogs.sap.com/2019/03/25/as91-asset-master-upload./

Share this post