Question Re: Identifying Phases in cProjects in Product Lifecycle Management Q&A

Identifying Phases in cProjects

Former Member — Wed, 22 Jun 2011 11:08:05 GMT

Hi all,

I want to be able to extract a list of all our cProjects projects (4000+) and see what is the current phase for each project.

I have looked in the SE16 table DPR_PHASE but unfortunately the GUID and PHASE_ID columns have been inherited from the number hardcoded into the Project Template and so are not unique. So using that table is not an option as I can't identify which row relates to which project.

Is there another table I can use which does hold unique values?

Thanks in advance,

Kathy

Re: Identifying Phases in cProjects

Former Member — Wed, 22 Jun 2011 13:45:55 GMT

Hi,

in DPR_PHASE the GUID is the key so is unique.

If you want to know the active phase fpr each project, you can select from DPR_PHASE where PROC_STATUS_OWN = '10' (Released) or '11 (Released (Processing has begun)).

To know the related project, you can use BAPI_BUS2173_GET_DETAIL, with phase_guid = guid of table DPR_PHASE looking at table ET_SUPERIOR_OBJECT where there is the project guid and id.

Bye,

Luca

Re: Identifying Phases in cProjects

Former Member — Fri, 09 Sep 2011 08:09:53 GMT

Thanks for your reply.

That did help although I've still not got to the bottom of the issue. However, it's become a low priority now so I'm closing the thread.