Hello ERP Financials, SAP ERP Financials  – Asset Accounting and SAP ERP Financials – Controlling Community

I would like to present a short knowledge article in the backdrop of legal requirements / one of the SAP limitations. This requirement might be there in many other countries, however, I have faced this during Indian implementations / rollouts

During Audit, the companies are required to provide a detail of the fixed assets acquired during the current fiscal year in a designated format. The details requested are quite logical like

  – Fixed asset no

  – Description

  – Type of asset (represented by asset class in SAP)

  – Date of acquisition

  – Date of capitalization

  – Purchased from (Vendor)

  – etc

Almost all this information is captured either in the asset master or in the transaction. One can juggle around SAP tables and download the information into excel. However, that involves manual work.

One limitation that crops up here is that asset master shows the Vendor from whom the asset is acquired. However, it shows only the 1st Vendor from whom the asset is acquired. If there are subsequent additions from different vendor OR the asset is acquired at the same time from two different vendors, this poses a challenge. Hence, to overcome this limitation and to automate the process of data extraction, I would like to present an approach (with sample code), attached along with this document

One can extend the code as needed. Hope this document helps and people dont have to reinvent the whole wheel again!!

Br, Ajay Maheshwari

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Pankaj Bhalerao

    Hello Ajay Sir,

    Thank you for sharing this document, expecting the same requirement in current project.

    Thank you very much….

    Regards,

    Pankaj Bhalerao.

    (0) 
  2. Lakshmi Kumari Sama

    Hello Ajay,

    As usual good document and i didnt find more words to say anything 🙂

    Expecting more and more articles from your end.

    Thanks & Regards,

    Lakshmi S

    (0) 
  3. Gaurav Soni

    Dear Ajay,

    I just checked this thread but couldn’t find the code herewith

    Can you please reply on the thread with the sample code

    Thank you,
    Gaurav Soni

    (0) 

Leave a Reply