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

[ashwinipingle]

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

[ashwinipingle]

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

[ravi_ekambaram]

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

[ashwinipingle]

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.

[judith_gabriel]

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

[ashwinipingle]

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.