Skip to Content
author's profile photo Former Member
Former Member

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

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!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2005 at 05:30 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 21, 2005 at 03:06 AM
    10

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 20, 2005 at 04:13 AM

    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'.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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!

  • Posted on Oct 21, 2005 at 05:27 AM

    Hi,

    look table rpsco: field wrttp

    wrttp           description
    
    41              budget 
    11              (Statistical)actual
    22              Purchase Order Commitment 

    ___

    disposable = 41 -11 - 22.

    regards Andreas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2005 at 11:53 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.