Skip to Content

Need to find the task start and finish dates in SAP PPM 5.0

Hello,

I need to get the Actual Start and Finish dates of specific tasks from projects in SAP PPM 5.0. I tried to check CGPL_PROJECT however find that this table is not getting populated properly. Are there any other tables which can give me this quick information ?

I first got the GUID of a sample project and found an entry for DPO type in CGPL_PROJECT.

However I am not finding any entry for PPO type for this GUID.

Also the Project GUID column in CGPL_PROJECT contains 000000000000000000000000 for all records.

Best Regards,

Ashwini Pingle

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • May 22 at 12:48 PM

    Hello Ashwini,

    You can get the task related dates in table CGPL_TASK and other information in DPR_TASK. For project details you need to refer to DPR_PROJECT & CGPL_PROJECT.

    To get project GUID you can use FM 'DPR_GET_GUID_BY_ID_FROM_DB' or try double clicking a line item in table DPR_PROJECT, you will see unconverted value.


    Regards,
    Ravi

    Add comment
    10|10000 characters needed characters exceeded

    • In our case, the table CGPL_TASK does not contain the actual start and finish dates. Is there any logic to the storage of data in these tables? I am interested in data from tables into a query.

  • May 22 at 12:30 PM

    Dear Ashwini,

    You can use BAPI BAPI_BUS2175_GET_DETAIL to get the details (including actual start/finish dates) of the task.



    Best regards,

    Judith

    Add comment
    10|10000 characters needed characters exceeded

    • Is there a possibility of finding the database table which holds the actual start and end dates? In our case, CGPL_TASK is empty for the actual dates columns.

  • May 23 at 01:09 PM

    Hello Judith,

    I found following 2 pages

    https://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=464696706

    https://wiki.scn.sap.com/wiki/display/PLM/Report++ZDPR_LEAN

    Based on what I researched today in our database, I am getting a feeling that we may not be able to get the dates information directly from tables using query and that we need to use the BAPI instead. I am wondering why such a design? All I want is the actual start and end dates of a particular task from the projects of a specific projecttype. Will this information be not available directly?

    Best Regards,

    Ashwini Pingle

    Add comment
    10|10000 characters needed characters exceeded