PPM - Database table for Project calculated Start and Finish date in PPM

[former_member301510]

Hi Experts,

I know this looks a basic query but for me it is not.

I am looking an exact database table for Calculate start and finish dates, Start and finish constraint dates of a project definition in PPM project.

In fact, Planned start and finish date are visible in table CGPL_PROJECT but those dates are not same as mentioned in Project definition.

[former_member301510]

Correcting my statement.

In fact, Planned start and finish date are visible in table CGPL_PROJECT but those dates are not same as mentioned in Project definition.

- As I said, those fields are empty.

[judith_gabriel · Accepted solution]

Dear Sandeep,

You can find the information in table CGPL_PROJECT in the following fields:

Constraint dates and types are stored in:
CONSTRAINT_TYPE
CONSTRAINT_TIME

CONSTR_TYPE_FIN
CONSTR_TIME_FIN

The calculated dates are stored in fields PLANSTART and PLANFINISH.


Best regards,
Judith

[former_member301510 · Accepted solution]

Thanks Judith.

I know all those fields and table but those fields are empty, even the dates are maintained in PPM Project.

That is where I am confused.

Please refer the attached screen shots.

Regards,

project-dates-view.jpg

synchronization-mapping.jpg

[former_member301510]

Thanks Judith for your support.

I got the answer as referring in Snote 2546715.

Regards,

[judith_gabriel]

Dear Sandeep,

The attached screenshot of table CGPL_PROJECT is referring to the phase and not to the project-definition. The project-header has object-type DPO - while the phase has object-type PPO.


Best regards,
Judith

[former_member301510]

Dear Judith,

Thanks for your response.

As suggested, I could able to find start and finish date with object type DPO in CGPL_PROJECT.

The project finish date in table is correct but start date is getting displaying one day prior i.e. 13.11.2019 whereas, I mentioned in project as 14.11.2019.

Attached screenshot.

Please suggest.

Regards,

cgpl-project.jpg