Deleting Fixed Assets Master and Transaction Data in company code

 
Consider this:
You are carrying out a fixed asset migration during your implementation project, and needed to do several iterations of data loads, it may become necessary to delete one iteration in order to carry out another load. Three scenarios may arise:
 
1) You may need to delete only the asset transaction data and not the master data;
2) You may need to delete both the asset master data and transaction data.
3) You may need to reset only the posted depreciation.
 
This exercise of deletion of the asset data (transaction and master) normally happens before the company code is set to “productive” (meaning it must be in test status). It is not a good practice to do this exercise when the company code is productive. However, if for a reason it becomes necessary to carry this out when the company code is productive you can do so after temporarily resetting your company code. For example, I had to do this recently in a fiscal/financial year change project.
In this post, we will discuss the deletion of the fixed asset data in SAP in the scenarios listed above.
 
1. Resetting Asset Transaction Data Only
 
Here the task is to delete the asset transaction data only, without touching the master data. To reset the asset transaction data follow the menu path below.
 
IMG — Financial Accounting (New) — Asset Accounting — Preparing for Production Startup – Tools — Reset Company Code (use transaction OABL).
 

 
Company Code: This exercise is carried out at the company code level and not at the individual asset level of even at the asset class level.
 
Line items only: Flag this indicator if, you only want to delete the asset transaction data and not the fixed asset master data. The system, by this action will delete all transaction data of all fiscal years and on all fixed assets transaction tables (like ANEK, ANEP and ANEA).
 
Press enter after your selection.
 

 
Click on yes to continue.
 

 
Press enter to continue.
 

 
Note: If you go to the asset explorer, (AW01N) you still find assets under this company code, because the asset master data have not been deleted.
 
However, if you select one of those assets, the system will tell you that the asset has no value.
 

 

 
2. Resetting Both Transaction and Master Data
 
Now let see what happens if we run the same transaction without selecting the “Line items only” flag.
 

 
Go through the same process as above.
 

 
Now if you display the asset explorer, (AW01N) there will be no assets to display under this company code, this because the system in this case deletes both transaction and asset master data.
 

 
3. Reset Posted Depreciation
 
You may only want to reset the posted depreciation in the system and not anything else. It must be noted that by this process, just like in scenario “one” above, the reset only happens in the fixed assets module and the postings in the General Ledger are not affected. Meaning that after this process in the fixed assets sub ledger, differences will result between the accumulated depreciation of the fixed asset in the sub-ledger and the respective accounts the general ledger. This may be taken care of by making an adjusting entry in the General ledger.
 
We will discuss the process of making the General Ledger to be in line with the Sub ledger in a later post. When we discuss the legacy asset transfer, a similar scenario happens and we will address it at that time.
 
Follow the menu path below for the reset of posted depreciation.
 
IMG — Financial Accounting (New) — Asset Accounting — Preparing for Production Startup – Tools — Reset Posted Depreciation
 

 
Press enter to continue.
 

 
Click on yes to continue.
 

 
With this action, the posted depreciation for the selected company code has been reset.
 
4. Deleting Newly Created Assets That has no Posted Transactions
 
We have been discussing above, the deletion of assets where posted transactions exists. Now we discuss the relatively simple scenario of deleting asset master data that has no posted transactions.
 
To delete an asset master data that has no posted transaction use the menu path below:
 
Accounting — Financial Accounting — Fixed Assets – Asset – Delete – Asset (or use transaction AS06).
 

 
Click on delete.
 

 
Flag the “physically delete indicator”.
 

 
Select Yes.
 

 
Your asset is now deleted.
 
 
 
Please do share your thoughts on this topic. We would love to hear your comments and suggestions.
 
 
 
 
 
 
By the way you are invited to visit the SAP Store and other stores directly from here, or through the affiliate links on the left sidebar of the home page and blog posts, for the easiest way to buy your SAP Software and other cool products.
 
 
 
 

3 thoughts on “Deleting Fixed Assets Master and Transaction Data in company code

  1. I think this is among the most significant info for me. And i am glad reading your article. But want to remark on few general things, The site style is wonderful, the articles is really great : D. Good job, cheers

  2. Dear Sap Gurus
    I am From India
    I have created one interest indicator as (IC) OB46
    Interest arrear calculation also given
    last option that is No open item cleared with a payment
    All OBAC, OB81,OB83,OBV1

    All Done

    But when i execute from FINT i am not able to charge interest. Payment received after due date. Payment terms also given.

    But when i execute with other option in OB82
    Than document is comeing.
    What is the reason.

    Reply will be highly appricated.
    Suraj Gor

Leave a Reply

Your email address will not be published. Required fields are marked *