Wants to develope the report of Budget, actual , Commitments & availa Bud

[Former Member]

Dear SAP Gurus,

I want to develope the singlr report as follows,

I/p : Project defn / Top WBSE

Out put:-

Against whole project,

- Total Original budget

- Total Actuals

- Total Commitments

- Total Assigned value

- Total Available budget

I found the Total Original budget (Field name :- WLGEV) & Total Actuals(Field name:- WTGES) from table BPGE, but could not able to find out other fileds.

Can anyone guide me for balance work ? (Note:- Please note that I need to find out overall value against the Project & not against the lower level WBSE)

Thanks & regards,

Pradip

[Former Member]

Hi,

Use the SAP Standard Report: S_ALR_87013558 - Budget/Actual/Commitment/Rem Plan/Assigned

Regards

Arpita

[Former Member]

Take 'Project for selection as PRPS_PSPHI

Select all WBSE ie PRPS-OBJNR for which PSPHI is same. This was you select all WBSE for a project.

=========================================================

For Actuals:

pass all PRPS-OBJNR obtained earlier in RPSCO-OBJNR. Put a filter of RPSCO-WRTTP=4 (value type=4).

In resulting lines do a sum of values in RPSCO-WLP01 to RPSCO-WLP12

==========================================================

For total commitments:

pass all PRPS-OBJNR obtained earlier in RPSCO-OBJNR. Put a filter of RPSCO-WRTTP=21 & 22 (value type=21 Commitments from Purchase Requisition

22 Purchase Order Commitment).

In resulting lines do a sum of values in RPSCO-WLP01 to RPSCO-WLP12

=========================================================

Assigned Values=sum of actual+ Rem commitment (assuming u don't have NWA)

======================================================

[Former Member]

Dear,

Go to s_alr_87013533>run >extra>report parameter>display forms>display change>move right hand screen to left>double click the blank form>select predefined element>select the form you want>confirm>extra>drildown display>select row column>Put cursor on new column>select>save selection>run report again

It will work