Skip to Content
avatar image
Former Member

How to generate fixed asset report wherein serial no. of the asset s

Dear All,

Request you to adz how to generate fixed asset report wherein serial no. of the asset can also be viewed .

Please Treat it as an Urgent request.

Thanks&Regards,

Kumar.D

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 11, 2007 at 12:00 PM

    hi,

    You can see any standard reports from S_ALR_87011963 to 87011970. from this report you can select the 0014(cost center/Serial No.)or 0022(company code/account determination/serial no) in Sort version, then Execute u will get the serial no. wise report

    don't forgot to assign points

    sai krishna

    null

    Message was edited by:

    sai krishna

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      u can create the sort version through T. code OAVI and select new entries give the name for your sort version, give the table name ANLAV and field Name SERNR.

      like the above you can create the sort versions, by the time of report execution u can select the your required sort version.

      This may be 100% solve your problum, please assighn the points and close the issue.

      regards

      sai krishna

  • avatar image
    Former Member
    Aug 16, 2007 at 01:44 PM

    Hi,

    I have checked some of the standard reports in SAP - Asset Balances / Inventory list etc., but Serial number is not listed in any of the reports.

    I suggest that you develop a ABAP query / ABAP custom report to get the Serial number of the Asset from Asset Master.

    Thanks

    Murali.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 16, 2007 at 01:57 PM

    HI,

    Standard Reports do not provide for Serial No. field but i think the purpose can be served by extracting the details from Table ANLA through SE16/SE11. Field for Serial No. is SERNR. In Se16 Goto Userparamets in the Settings and check the radio button ALV Grid Diplay.

    Hope this will help.

    Thanks & Best Regards,

    Vijay

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 11, 2007 at 05:53 PM

    Dear Kumar,

    Standard Reports do not provide for Serial No. field but i think the purpose can be served by extracting the details from Table ANLA through SE16/SE11. Field for Serial No. is SERNR. In Se16 Goto Userparamets in the Settings and check the radio button ALV Grid Diplay.

    summary of steps involved in this are as follows:

    1)Create asset master data (for AUC and Final asset)-AS01

    2)Create internal order-KO01

    3)Enter budget for internal order-KO22

    4)Create purchase order- ME21N

    5)Post goods receipt-MIGO

    6)Invoice verification-MIRO

    7)Settlement of capex orders to AUC-KO88 or KO8G

    8)Settlement of AUC to asset - AIAB

    Hope this infirmation will helps you

    Prem

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Just follow the OSS note that I posted above. That will let you add the serial number field to any standard fixed asset report. You can also use the same procedure to add any user defined field as well.

  • avatar image
    Former Member
    Dec 03, 2007 at 09:36 AM

    It is very simple ,When you create the asset through AS01,in general segment there is one option Under the a/c determination,serial number

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      hI PRAMOD,

      If u create on serial number in asset master it will not flow automatically the reports, without creating sort varient, please check.