Fetching data from S_ALR_87013558 Report

[Former Member]

Hi Experts,

We want to execute S_ALR_87013558 report and extract values from this report. We are using SUBMIT statement to call this report. But the input screen using transaction code and Submit program are different. We want to extract values using List_from_memory function module. Moreover the program names are different in different servers for this tcode.

Regards,

Sibin

[Former Member]

Hi Sibin,

Agree with Saurabh... Please involve ABAP consultant to check possibility of how you can fetch data from S_ALR_87013558 report.

You can also check possibility of SAP note 1992411.

Regards

Tushar

[Former Member]

The input selection screen while executing tcode is different from the program. Moreover the program name differs in different servers. We want to fetch report dynamically.

Regards,

Sibin

[former_member195427]

Hi Sibin,

It looks like a custom program to fetch some predefined set of data/fields. You can discuss with your ABAPer only to help you out with it.

Regards

Saurabh

[Former Member]

Hi Saurabh,

Can you please provide table names from where data can be extracted directly for Budget, Actual and Committed values?

Regards,

Sibin

[former_member195427]

Hi Sibin,

You can use BPJA,BPGE for budget, COOI,COSS/COSP for commitment/actual.

OR

Use RPSCO for all.

Regards

Saurabh

[Former Member]

We tried RPSCO but the data is not matching. How to fetch values from COOI,COSS and COSP tables?

Regards,

Sibin

[former_member195427]

If you know which values/field values you need to extract,you can verify and extract it from the given tables.

COOI,COSS/COSP tables will require object number to extract data, Object number (OBJNR) for WBS/project,you can get from PRPS and PROJ respectively.Pass this object numbers from COOI and other tables and fetch the data which you require.

Regards

Saurabh

[Former Member]

Hi Sibin,

Why are the values not matching RPSCO table? did you check that - it should match if you are pulling the data correctly.

Please query the table for the same value type, version, Object Indicator and if any filter on value category.

this will match the report.

we can build custom reports based on RPSCO table, it is easy for consolidated values. if you need detailed break up based on Cost element you can go for COSS/ COSP or COOI.

hope it helps.

thanks.

[former_member195427]

Hi Sibin,

Instead of extracting values from S_ALR_87013558,why don't you extract values from tables RPSCO,COOI etc. That looks more easier option to me.

Moreover, you need to check with Abaper to find a other way around to fetch the data the way you are using.

Regards

Saurabh