Project System Costs: budget/actual/commt/rem.plan/assd

[Former Member]

Hi all,

I'm trying to obtain the following information from PS report "s_alr_87013558" :

budget (I actually have it from table RPSCO1)

actual

commitment

remaining order plan costs

assigned

I've tried very hard to get this info from the logical database PSJ but I can't find it. I really need help on this, so I'll appreciate your comments. Regards!!

[Former Member · Accepted solution]

Hi Charli,

You can the info as following.

(1) Actual RPSCO WRTTP = '04'

(2) Commitment from table COOI against object numner of PS object

(3)Assigned - Actual + commitment

(4)Remaining - Budget - actual

[Former Member]

Hi, did u get ur project reports going...need help here.

Can u please provide me more info on project system. reporting

geting data in a structure, extracting data from PS,

and standard report modification. or creating new report,

modify structure overview,etc

Thank you.

Nasim Mahmud.

nasim1293@gmail.com

[andreas_mann3]

Hi,

look table rpsco: field wrttp

wrttp           description

41              budget 
11              (Statistical)actual
22              Purchase Order Commitment 

___

disposable = 41 -11 - 22.

regards Andreas

[Former Member]

I do not know from where you get the labels like

actual

commitment

remaining order plan costs

assigned

Instead, please look at the output in Transaction CJ31 which gives values for

Budget, Current Budget, Distributed, Distributable, Assigned, Planned , Released etc.

All these values can be derived from entries in table BPJA for the object number OBJNR and different values for field VORGA.

In my last post I used ‘KBUD’ as value for field VORGA. This gives total Budget. If you use different values for VORGA you will get the other values like current budget, distributed budget etc.

[Former Member]

This is how we retrieve current total project budget without using Logical database.

1: Input is project name PROJ-PSPID. Get value of field PROJ-PSPNR

SELECT PSPNR FROM PROJ WHERE PSPID = PROJECTNAME.

2: From table PRPS use this PSPNR value to obtain value of PRPS-OBJNR.

SELECT SINGLE * FROM PRPS WHERE PSPHI = PROJ-PSPNR.

3: Use this value in table BPJA and get the budget in the field BPJA-WTJHR.

SELECT SINGLE * FROM BPJA WHERE OBJNR = PRPS-OBJNR AND

VORGA = 'KBUD'.

[Former Member]

Thank you for the information Sudhir. But I already hace this value as I explained. The values I need are :

actual

commitment

remaining order plan costs

assigned

Do you know how to extract this info from the database?

Thank you!