SAP ABAP Table DPR_BW_DATE (Dev. Projects: Extract Structure Date Attributes)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-BW (Application Component) BW Interface
     ⤷ DEVELOPMENT_PROJECTS_BW (Package) Project Management - BW Extractor

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_BW_DATE	Table Relationship Diagram
Short Description	Dev. Projects: Extract Structure Date Attributes

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	GUID	☑	CGPL_GUID16	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16-Character GUID for Projects and Activts
2	DATE_SET	☐	DPR_TV_DATE_SET	DPR_TYPE	CHAR	15	0	Date Type	*
3	PRO_CATEGORY	☐	DPR_TV_PRO_CATEGORY	DPR_PROJECT_CATEGORY	CHAR	1	0	Project Category	*
4	PRO_TYPE	☐	DPR_TV_PRO_TYPE	DPR_TYPE	CHAR	15	0	Project Type	*
5	PRO_EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
6	TEXT1	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
7	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
8	ACTUALSTARTDATE	☐	DPR_TV_ACTUAL_START		DATS	8	0	Actual Start
9	ACTUALFINISHDATE	☐	DPR_TV_ACTUALFINISHDATE		DATS	8	0	Actual Finish
10	PLANSTARTDATE	☐	DPR_TV_PLANSTARTDATE		DATS	8	0	Planned Start
11	PLANFINISHDATE	☐	DPR_TV_PLANFINISHDATE		DATS	8	0	Planned Finish
12	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
13	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
14	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
15	CONSTRAINTDATE	☐	DPR_TV_CONSTRAINTDATE		DATS	8	0	Constraint Date
16	PLANGROUP	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
17	LATEST_STARTDATE	☐	DPR_TV_LATEST_STARTDATE		DATS	8	0	Latest Start Date
18	LATESTFINISHDATE	☐	DPR_TV_LATEST_FINISHDATE		DATS	8	0	Latest Finish Date
19	TOTAL_FLOAT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
20	DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
21	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
22	CALENDAR_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
23	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
24	CONSTR_FINDATE	☐	DPR_TV_CONSTRAINTDATE		DATS	8	0	Constraint Date
25	WORK_EFFORT	☐	DPR_TV_WORK	DPR_WORK	QUAN	9	2	Work
26	WORK_UNIT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
27	WORK_EFFORT_BW	☐	DPR_BW_TV_WORK_EFFORT		QUAN	9	2	Work in Project Time Unit
28	WORK_UNIT_BW	☐	DPR_BW_TV_WORK_EFFORT_UNIT	MEINS	UNIT	3	0	Project Time Unit for Work	*
29	BEG_DATE	☐	DPR_TV_START_DATE	DATS	DATS	8	0	Start Date
30	END_DATE	☐	DPR_TV_FINISH_DATE	DATS	DATS	8	0	Finish Date
31	.INCLUDE	☐				0	0	DPR: Date Fields
32	DZONE	☐	DPR_TV_DZONE	TZNZONE	CHAR	6	0	DPR: Time Zone	*
33	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
34	ACT_WORK_EFFORT	☐	DPR_TV_ACT_WORK	DPR_WORK_LONG	QUAN	16	3	Confirmation (Insternal Display)
35	ACT_WORK_UNIT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
36	ACTWORKEFFORT_BW	☐	DPR_BW_TV_ACT_WORK_EFFORT	DPR_WORK_LONG	QUAN	16	3	Confirmed Time in the Project Time Unit
37	ACT_WORK_UNIT_BW	☐	DPR_BW_TV_ACT_WORK_EFFORT_UNIT	MEINS	UNIT	3	0	Project Time Unit for Confirmed Time	*
38	REM_WORK_EFFORT	☐	DPR_TV_REM_WORK	DPR_WORK_LONG	QUAN	16	3	Remaining Work
39	REM_WORK_UNIT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
40	REMWORKEFFORT_BW	☐	DPR_BW_TV_REM_WORK_EFFORT	DPR_WORK_LONG	QUAN	16	3	Remaining Work Time in Project Time Unit
41	REM_WORK_UNIT_BW	☐	DPR_BW_TV_REM_WORK_EFFORT_UNIT	MEINS	UNIT	3	0	Project Time Unit for Remaining Work Time	*
42	DQ_PROJECT_GUID	☐	DPR_BW_DQ_DS_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Select. Field of DataSource for Delta Queue - Project GUID
43	DQ_PHASE_GUID	☐	DPR_BW_DQ_DS_PHASE_GUID	CGPL_PROJECT_GUID	RAW	16	0	Select. Field of DataSource for Delta Queue -Parent Obj.GUID
44	DQ_OBJECT_GUID	☐	DPR_BW_DQ_DS_OBJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Select. Field of DataSource for Delta Queue - Appl. Obj.GUID
45	DQ_ENTITY_GUID	☐	DPR_BW_DQ_DS_ENTITY_GUID	CGPL_PROJECT_GUID	RAW	16	0	Selection Field of DataSource for Delta Queue - Entity GUID
46	FORECASTED_STRT	☐	DPR_TV_FORECASTED_START		DATS	8	0	Forecasted Start Date
47	FORECASTED_FIN	☐	DPR_TV_FORECASTED_FINISH		DATS	8	0	Forecasted Finish Date

History

Last changed by/on	SAP	20141109
SAP Release Created in	200