Dates for Project Definition 
Technical name: 0DPR_PROJECT_DATE
Technical Data
|
Type of DataSource |
Transaction Data |
|
Application Component |
Development Projects |
|
Available as of OLTP Release |
cProjects 2.0 |
|
Available as of PlugIn Release |
|
|
RemoteCube-Compatible |
No |
Use
This DataSource is used to extract project definition dates.
Delta Update
You can use this DataSource to perform a delta update. The data deleted in the source system is also removed in the BW system.
Origin Fields in the Extraction Structure
|
Field in Extraction Structure |
Description of Field in Extraction Structure |
Origin Table |
Field in Origin Table |
|
GUID |
Project Planning: 16-Character GUID for Projects and Activts |
DPR_PROJECT |
GUID |
|
DATE_SET |
Date Type |
<Extractor Logic> |
|
|
PRO_CATEGORY |
Project Category |
DPR_PROJECT |
PRO_CATEGORY |
|
PRO_TYPE |
Project Type |
DPR_PROJECT |
PRO_TYPE |
|
PRO_EXTERNAL_ID |
Project Planning: External Identifier of an Element |
CGPL_PROJECT |
EXTERNAL_ID |
|
TEXT1 |
Language-Dependent Short Text |
CGPL_TEXT |
TEXT1 |
|
PRIORITY |
Priority |
CGPL_PROJECT |
PRIORITY |
|
ACTUALSTARTDATE |
Actual Start Date |
CGPL_PROJECT |
ACTUALSTART |
|
ACTUALFINISHDATE |
Actual Finish Date |
CGPL_PROJECT |
ACTUALFINISH |
|
PLANSTARTDATE |
Planned Start Date |
CGPL_PROJECT |
PLANSTART |
|
PLANFINISHDATE |
Planned Finish Date |
CGPL_PROJECT |
PLANFINISH |
|
COMPLETION |
Degree of Processing in Percent |
CGPL_PROJECT |
COMPLETION |
|
MILESTONE |
Milestone Indicator |
CGPL_PROJECT |
MILESTONE |
|
CONSTRAINT_TYPE |
Type of Scheduling Constraint |
CGPL_PROJECT |
CONSTRAINT_TYPE |
|
CONSTRAINTDATE |
Constraint Date |
CGPL_PROJECT |
CONSTRAINT_TIME |
|
PLANGROUP |
Planning Profile Group |
CGPL_PROJECT |
PLANGROUP |
|
LATEST_STARTDATE |
Latest Start Date |
CGPL_PROJECT |
LATEST_START |
|
LATESTFINISHDATE |
Latest Finish Date |
CGPL_PROJECT |
LATEST_FINISH |
|
TOTAL_FLOAT |
Total Float |
CGPL_PROJECT |
TOTAL_FLOAT |
|
DURATION |
Duration of Execution |
CGPL_PROJECT |
DURATION |
|
DURATION_UNIT |
Time Unit for Execution Duration |
CGPL_PROJECT |
DURATION_UNIT |
|
CALENDAR_ID |
Factory Calendar |
CGPL_PROJECT |
CALENDAR_ID |
|
CONSTR_TYPE_FIN |
Type of Scheduling Constraint |
CGPL_PROJECT |
CONSTR_TYPE_FIN |
|
CONSTR_FINDATE |
Constraint Date |
CGPL_PROJECT |
CONSTR_TIME_FIN |
|
WORK_EFFORT |
Required Capacity |
<Not Relevant> |
|
|
WORK_UNIT |
Unit |
<Not Relevant> |
|
|
WORK_EFFORT |
Required Capacity in Project Unit |
<Not Relevant> |
|
|
WORK_UNIT_BW |
Project Time Unit for Required Capacity |
<Not Relevant> |
|
|
BEG_DATE |
Start Date |
<Extractor Logic> |
|
|
END_DATE |
End Date |
<Extractor Logic> |
|
|
DZONE |
DPR: Time Zone |
<System Variable> |
SY-ZONLO |
|
UPDMOD |
BW
Delta Process: |
<Extractor Logic> |
|
|
ACT_WORK_EFFORT |
Actual Required Capacity |
DPR_PROJECT |
ACT_WORK_EFFORT |
|
ACT_WORK_UNIT |
Unit |
DPR_PROJECT |
ACT_WORK_UNIT |
|
ACTWORKEFFORT_BW |
Actual Required Capacity in Project Unit |
<Extractor Logic> |
Actual Required Capacity (converted to project unit set in Customizing) |
|
ACT_WORK_UNIT_BW |
Project Time Unit for Actual Required Capacity |
<Extractor Logic> |
Unit (project unit set in Customizing) |
|
DQ_PROJECT_GUID |
DataSource Sel. Field for DeltaQueue: GUID of Project |
<Extractor Logic> |
|
|
DQ_PARENT_GUID |
DataSource Sel. Field for DeltaQueue: GUID of Parent Object |
<Extractor Logic> |
|
|
DQ_OBJECT_GUID |
DataSource Sel. Field for DeltaQueue: GUID of Application Object |
<Extractor Logic> |
|