Question Re: Checklist Item Table in Product Lifecycle Management Q&A

Checklist Item Table

Former Member — Thu, 21 Aug 2014 03:00:36 GMT

Hi,

We are tring to find out tables which contains the relationship between Checklist Item, Checklist, Phase and Project Definition so that I can output a report of 'checklist items under phases of a project'. We've checked table DRP_PROJECT, DPR_CHECKLIST_I, CGPL_HIERARCHY and get nothing. Can you tell us which tables we can use here to get the relationship and text of project element?

Regards

Yemi

Re: Checklist Item Table

Former Member — Thu, 21 Aug 2014 14:29:05 GMT

You are on the right track. You will have to use the GUID to find the relationships. The text of project elements are stored in CGPL_TEXT. If you are using BI for your reports you should be able use the standard extractors. See link below.

Attributes for Checklist Item - BI Content for Project Management - SAP Library

Re: Checklist Item Table

Former Member — Fri, 22 Aug 2014 08:09:31 GMT

Hi, Lashan

I understand the relationship of project elements in table CGPL_HIERARCHY now and find the description of project elements by mapping field GUID in both tables.

Then I want to connect the project/phase/checklist item number with their relationship. But in table DPR_PROJECT or DPR_CHECKLIST_I, the field GUID doesn't match with that in table CGPL_HIERARCHY. Is the field GUID mapping in table DPR* and CGPL*?

Regards

Yemi