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

[Former Member]

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

[saikrishna_vallurupalli · Accepted solution]

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

[Former Member · Accepted solution]

I recently posted this to a similar question. Please look at OSS note #335065. It tells you how to add additional fields including user defined fields into standard FI-AA reports.

[saikrishna_vallurupalli · Accepted solution]

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

[Former Member]

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

[saikrishna_vallurupalli]

hI PRAMOD,

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

[Former Member]

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

[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.

[Former Member]

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

[Former Member]

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.