SAP ABAP View V_DPR_PROJECT (View for CGPL_PROJECT and DPR_PROJECT)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-STR (Application Component) Structure
     ⤷ DEVELOPMENT_PROJECTS_PROJECT (Package) Project Management - Projects

Basic Data

View Type	D	Database View
Database View	V_DPR_PROJECT
Short Description	View for CGPL_PROJECT and DPR_PROJECT
Root table	CGPL_PROJECT	Project Planning: Attribute Table for Project Headers

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CGPL_PROJECT	CGPL_PROJECT
2	DPR_PROJECT
3	CGPL_ENTITY

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CGPL_PROJECT	CLIENT	JL	EQ				0	0
2	DPR_PROJECT	CLIENT	JR	EQ			AND	0	0
3	CGPL_PROJECT	GUID	JL	EQ				0	0
4	DPR_PROJECT	GUID	JR	EQ			AND	0	0
5	CGPL_ENTITY	CLIENT	JL	EQ				0	0
6	CGPL_PROJECT	CLIENT	JR	EQ			AND	0	0
7	CGPL_ENTITY	GUID	JL	EQ				0	0
8	CGPL_PROJECT	GUID	JR	EQ			AND	0	0
9	CGPL_ENTITY	APPLICATION		EQ	'DPR'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	CGPL_ENTITY	CLIENT		☐	MANDT	☐	Client
2	GUID	CGPL_ENTITY	GUID		☐	CGPL_GUID16	☐	Project Planning: 16-Character GUID for Projects and Activts
3	VERSION	CGPL_ENTITY	VERSION		☐	CGPL_TV_VERSION	☐	Version Number
4	EXTERNAL_ID	CGPL_ENTITY	EXTERNAL_ID		☐	CGPL_TV_EXT_ID	☐	Identification of Entities
5	OBJECT_TYPE	CGPL_ENTITY	OBJECT_TYPE		☐	CGPL_OBJECT_TYPE	☐	Object Type in Project Planning
6	PRIORITY	CGPL_PROJECT	PRIORITY		☐	CGPL_PRIORITY	☐	Priority
7	INTERNAL	CGPL_ENTITY	INTERNAL		☐	BOOLE_D	☐	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
8	*	DPR_PROJECT	*		☐		☐
9	-	DPR_PROJECT	CLIENT		☐	MANDT	☐	Client
10	-	DPR_PROJECT	GUID		☐	DPR_TV_ENTITY_GUID	☐	Application Object GUID (Entity with Conversion Exit)
11	PROC_STATUS_OWN	DPR_PROJECT	PROC_STATUS_OWN		☐	DPR_TV_PROC_STATUS_OWN	☐	Object Processing Status
12	PROC_STATUS_SUP	DPR_PROJECT	PROC_STATUS_SUP		☐	DPR_TV_PROC_STATUS_SUP	☐	Processing Status of Higher-Level Object
13	PROJECT_ID	DPR_PROJECT	PROJECT_ID		☐	DPR_TV_PROJECT_ID	☐	Project Number
14	-	DPR_PROJECT	VERSION_NUMBER		☐	CGPL_TV_VERSION	☐	Version Number
15	PRO_CATEGORY	DPR_PROJECT	PRO_CATEGORY		☐	DPR_TV_PRO_CATEGORY	☐	Project Category
16	PRO_TYPE	DPR_PROJECT	PRO_TYPE		☐	DPR_TV_PRO_TYPE	☐	Project Type
17	CAUSE	DPR_PROJECT	CAUSE		☐	DPR_TV_CAUSE	☐	Reason for Project
18	GROUPING	DPR_PROJECT	GROUPING		☐	DPR_TV_GROUPING	☐	Grouping
19	SEARCH_FIELD	DPR_PROJECT	SEARCH_FIELD		☐	DPR_TV_SEARCH_FIELD	☐	Search Field
20	-	DPR_PROJECT	MASTER_LANGUAGE		☐	DPR_TV_MASTER_LANGUAGE	☐	Text Language
21	TEMPLATE_ADMIN	DPR_PROJECT	TEMPLATE_ADMIN		☐	DPR_TV_TEMPLATE_ADMIN	☐	Template Responsible
22	-	DPR_PROJECT	TEMPLATE_GUID		☐	DPR_TV_ENTITY_GUID	☐	Application Object GUID (Entity with Conversion Exit)
23	-	DPR_PROJECT	RELEASED_ON		☐	DPR_TV_TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
24	RESCHEDULE	DPR_PROJECT	RESCHEDULE		☐	DPR_TV_RESCHEDULE	☐	Rescheduling Required
25	SCHEDULE_IND	DPR_PROJECT	SCHEDULE_IND		☐	PPM_SCHEDULE_INDICATOR	☐	Status of Scheduling Data
26	SCHEDULE_TYPE	DPR_PROJECT	SCHEDULE_TYPE		☐	DPR_TV_SCHEDULE_TYPE	☐	Scheduling Type
27	SCHED_BEHAVIOUR	DPR_PROJECT	SCHED_BEHAVIOUR		☐	DPR_TV_SCHED_BEHAVIOUR	☐	Scheduling Behavior
28	SUMMARY_TASKS	DPR_PROJECT	SUMMARY_TASKS		☐	DPR_TV_SUMMARY_TASKS	☐	Task Nodes Are Summary Tasks
29	PERIODTYPE	DPR_PROJECT	PERIODTYPE		☐	DPR_TV_PERIOD_TYPE	☐	Period Type (Weekly/Monthly/Generic Interval)
30	ALLOCATION_UNIT	DPR_PROJECT	ALLOCATION_UNIT		☐	DPR_TV_ALLOCATION_UNIT	☐	Distribution Unit
31	LOCATION	DPR_PROJECT	LOCATION		☐	DPR_TV_LOCATION	☐	Location
32	CUSTOMER	DPR_PROJECT	CUSTOMER		☐	BU_PARTNER_GUID	☐	Business Partner GUID
33	SOLD_TO_PARTY	DPR_PROJECT	SOLD_TO_PARTY		☐	BU_PARTNER_GUID	☐	Business Partner GUID
34	LAST_CHANGED_ON	DPR_PROJECT	LAST_CHANGED_ON		☐	DPR_TV_TIMESTAMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
35	-	DPR_PROJECT	LAST_CHANGED_BY		☐	DPR_TV_LAST_CHANGED_BY	☐	User Who Changed Project Data Last
36	SORT_OVERALL	DPR_PROJECT	SORT_OVERALL		☐	DPR_TV_SORT_OVERALL	☐	Sort Mode
37	-	DPR_PROJECT	PLVAR		☐	PLVAR	☐	Plan Version
38	-	DPR_PROJECT	OTYPE		☐	OTYPE	☐	Object Type
39	-	DPR_PROJECT	RESP_ORG_UNIT		☐	DPR_TV_RESP_ORGANIZATION	☐	Organization Responsible
40	-	DPR_PROJECT	STAT_PROFILE_PRO		☐	DPR_TV_STAT_PROFILE_PRO	☐	Status Profile Template
41	-	DPR_PROJECT	ACT_WORK_EFFORT		☐	DPR_TV_ACT_WORK	☐	Confirmation (Insternal Display)
42	-	DPR_PROJECT	ACT_WORK_UNIT		☐	DPR_TV_UNIT	☐	Unit
43	-	DPR_PROJECT	ACT_WRK_UNIT_EXT		☐	DPR_TV_UNIT	☐	Unit
44	-	DPR_PROJECT	CONF_GUID		☐	DPR_TV_CONF_GUID	☐	GUID of a Confirmation Document
45	ACTUAL2PLAN	DPR_PROJECT	ACTUAL2PLAN		☐	DPR_TV_ACTUAL2PLAN	☐	Overwrite Planned Dates by Actual Dates
46	-	DPR_PROJECT	EA_DUMMY		☐	DPR_TV_EA_DUMMY	☐	Dummy Data Element for Enhanced Proj. Mgmt Attributes

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

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

History

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