Change PS Report S_ALR_87013558

[Former Member]

Hi ,

I need to change S_ALR_87013558 report to include the Forecast Cost field (drilldown reporting to work order).

Add user field " Forecast Cost" (USRCURR13 data element ) in the S_ALR_87013558.

There is Note 454509 Customer enhancement for drilldown reports in project system.

Thanks in advance for any help.

Soufiène

[Rachel_Tang · Accepted solution]

Please see the R/3 online-documentation, section 'Project System-Project Information System-Commercial Project Reports-Hierarchy Reports: Costs, Revenues and Payments'.

Here you will find an example how to define your own reports using your own characteristics. When defining a report via transaction CJE1, various fields can be selected as characteristics in the standard.

However , the report you mention displays only figures:

a) that are updated to table RPSCO and

b) with a respective column definition.

For the field you want to add, it is not possible to be added with this way.

In this case, you have the option to use the exit EXIT_SAPLPS01_002.

Implementing customer-specific characteristics and key figures in the hierarchy reports requires EXIT_SAPLPS01_002 to be programmed accordingly.

You may see the example in SAP note 454509 you have found for further reference.

[Former Member · Accepted solution]

Hi Rachel,

Thank you for your response , i didn't understand the example in the note , they use three fields , in my case i need to add

Forecast cost (USRCURR13 data element).

Did i add the field in CI_RPSCO_X ?

Fill the table TKAF ?

and insert the following code in EXIT_SAPLPS01_002 ?

Data: lt_cust_rpsco_x like rpsco_x occurs 0 with header line.

Field-symbol: <rpsco_x>.

Loop at t_rpsco_x assigning <rpsco_x>.

lt_cust_rpsco_x = <rpsco_x>.

• calculate new key figure for reporting

lt_cust_rpsco_x-usrcurr13 = lt_cust_rpsco_x-wp08 / 2.

• add currency

???

• clear standard currency fields to prevent duplicate values

clear lt_cust_rpsco_x-wp00.

clear lt_cust_rpsco_x-wp01.

clear lt_cust_rpsco_x-wp02.

clear lt_cust_rpsco_x-wp03.

clear lt_cust_rpsco_x-wp04.

clear lt_cust_rpsco_x-wp05.

clear lt_cust_rpsco_x-wp06.

clear lt_cust_rpsco_x-wp07.

clear lt_cust_rpsco_x-wp08.

clear lt_cust_rpsco_x-wp09.

• mark up all customer specific entries

lt_cust_rpsco_x-id_corr = 'C'.

• append new fields into customer table

append lt_cust_rpsco_x.

Endloop.

• append lines of customer to standard table

append lines of lt_cust_rpsco_x[] to t_rpsco_x.

Thanks in advance

Soufiene

[Rachel_Tang · Accepted solution]

Your logic is basically correct, it should be understood as the following steps:

1. Add three new fields to the customer include of structure RPSCO_X

with transaction SE11.

2. Insert the following lines into table TKAF.

You can use the report of note 51971 to create an entry in table TKAF.

3. Enter the corresponding code into the user exit.

But I have never seen one used to add the data element USRCURR13 into the hierarchy reports, I think what you want to see is the user-field USR06/USR07 in the hierarchy reports? However, I need to say not all the fields could be displaied in hierarchy reports, even you could add it by the user-exit program without error but it will not be displaied in the report. Because hierarchy reports are totals value report and have their own logic to extract data from RPSCO, so only some of the related fields could be added. You may try to test for more times to see if the user-exit could work for your situation in your test system to have a better understanding.

[Former Member · Accepted solution]

Project managers need to have the forecasting information required to adequately manage their project.

Need to add customer user field 'Forecast Cost' (USR06 field ) in the S_ALR_87013558.

Need to pick up empty work orders at the lowest level of the drill down.

The new column of Forecast cost after Budget column . Same drill down capabilility - but only till WBS level.

I didn't understand the solution ?

Solution ?

In my case i need to add one new field USR06 ?

The corresponding code into the userexit is for the three fields in the example

but for me i need one new field .

I need to change the code ?

Could you send me the corresponding code.

Thanks in advance

Soufiene