Important list of tables and the relatioship for cProjects .

[Former Member]

Hi,

Is a List of important tables and their relationship available for cPROJECTS ( Table name starts with DPR for EXAMPLE DPR_PROJECT, CGPL_HIERARCHY, DPR_PART, DPR_PART_DIST, DPR_BUPA_DIST ETC etc.)

I will appreciate a complete model, but at the least the important table will do as well.

My interest is to find out the Role demand and allocation piece in Cprojects.

[bjoern_panter]

Hi Aruna,

oh this is difficult. About Roles I guiess it is a combination of DPR_ENTITY and DPR_PART and DPR_TASK and some other data like CGPL_HIERARHCY.

I recommend not to use database table. There are nice BAPIs to receive the necessary information about all objects of project.

Regards

B

PS: or what is the reason of knowling the data model

[Former Member]

Thanks Björn,

The reason I would like to know is to create the BW data model for Resource(role) demand and allocation, The cProjects BW price dosen't deliver it by default( even in BI for NW04S ).

All I want to do is to model a Custom ODS and a Cube in similar line of 0RPM_DS07 and 0RPM_C05 respectively.

I have figured out the following in cProjects

0DPR_PART : Role master data

0DPR_PROJECT: pROJECT OR Item

CGPL_HIERARHCY : links the Role and project Guid for demand and the following contains the demand and the allocation

DPR_PART_DIST : demand distribution

DPR_BUPA_DIST : allocation distribution

But need concrete info on the whole thing.

Thanks