Skip to Content

BW Report for ECC Asset history Sheet

Hi, we are in the process of building Bex report for Asset History sheet in ECC(

S_ALR_87011990), Since it is a standard ECC report, I think, SAP Business Content BW model and BEx report would fit into the business closely.

I am looking at the metadata repository for the asset history sheet in BW, noticed that several Bex queries with name Asset history sheet. I am not sure which one is the correct match to ECC report.

I assume that, the ones highlighted in red are the appropriate ones, can you please confirm it? also if you have any SAP documents on implementing Asset history sheet in BW, please share with me.



gwbjx.png (22.3 kB)
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Posted on Feb 15, 2017 at 01:03 PM

    Hi Sreekanth,

    0FIAA_MC1 and 0FIAA_MDS2 both are the multi providers. What all the Info providers and MPs you had installed as part of Asset Management.

    Try to install the queries in DEV system and Check the query design which suits your requirement. If any of the fields are missing you can enhance the queries as per the business need.

    - try to execute the Asset History Sheet (S_ALR_87011990) by activating the SQL trace and find out the source tables so that you can easily get the idea which info provider can be used. Regards KP

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 03, 2017 at 05:20 PM

    Hi Prashant, I understand your points. There was already custom implementation with respect to the Tables and used in the S_ALR_87011990 report. It was not working for Posted depreciations by period. We couldn't fix this issue, decided to go with Standard ECC extractors, infoproviders and Queries from business content. I am in the process of installing the above objects mentioned, the test can be properly checked in the UAT to meet all the cases. So I was expecting an advice in the forum before I get too much into the development and testing.

    my objective is, the above Standard business content of BW can fulfill what S_ALR_87011990 can provide in ECC?

    Add comment
    10|10000 characters needed characters exceeded