SAP ABAP Table DPR_TS_XML_PROJECT_DATA_TYPE (Complex Data Type ProjectDataType from XML Procedure)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PRO-EXT-PMT (Application Component) External Project Management Tools
     ⤷ DEVELOPMENT_PROJECTS_XML (Package) Project Management: XML Services

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_XML_PROJECT_DATA_TYPE	Table Relationship Diagram
Short Description	Complex Data Type ProjectDataType from XML Procedure

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	NUMBER	☐	DPR_TV_NUMBER	CGPL_EXTID	CHAR	24	0	Number
2	.INCLUDE	☐				0	0	Project Definition Attributes (External)
3	.INCLUDE	☐				0	0	Modifiable Project Definition Attributes
4	PROJECT_ID	☐	DPR_TV_PROJECT_ID	CGPL_EXTID	CHAR	24	0	Project Number
5	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
6	CONSTRAINT_TYPE	☐	DPR_TV_START_CONSTRAINT	DPR_START_CONSTRAINT	CHAR	1	0	Constraint on Start Date
7	START_DATE_FIX	☐	DPR_TV_START_DATE_FIX		DATS	8	0	Fixed Start Date
8	CALENDAR_ID	☐	DPR_TV_CALENDAR_ID	WFCID	CHAR	2	0	Calendar	TFACD
9	CONSTR_TYPE_FIN	☐	DPR_TV_FINISH_CONSTRAINT	DPR_FINISH_CONSTRAINT	CHAR	1	0	Constraint on Finish Date
10	FINISH_DATE_FIX	☐	DPR_TV_FINISH_DATE_FIX		DATS	8	0	Fixed Predefined Finish Date
11	PRO_TYPE	☐	DPR_TV_PRO_TYPE	DPR_TYPE	CHAR	15	0	Project Type	DPR_PRO_TYPE
12	CAUSE	☐	DPR_TV_CAUSE	DPR_CAUSE	CHAR	15	0	Reason for Project	DPR_CAUSE
13	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
14	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
15	MASTER_LANGUAGE	☐	DPR_TV_LANGU	SPRAS	LANG	1	0	Language Key	T002
16	TEMPLATE_ADMIN_ID	☐	DPR_TV_TEMPLATE_ADMIN_ID	BU_PARTNER	CHAR	10	0	Template Responsible	*
17	CUSTOMER_ID	☐	DPR_TV_CUSTOMER_ID	BU_PARTNER	CHAR	10	0	Customer Number	BUT000
18	SOLD_TO_PARTY_ID	☐	DPR_TV_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-to Party Number	*
19	DESCRIPTION	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
20	RESP_ORG_UNIT	☐	DPR_TV_RESP_ORGANIZATION	HROBJID	NUMC	8	0	Organization Responsible	*
21	STAT_PROFILE_PRO	☐	DPR_TV_STAT_PROFILE_PRO	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
22	ACT_WRK_EFFORT_EXT	☐	DPR_TV_ACT_WORK_EXT	DPR_WORK	QUAN	9	2	Confirmation
23	ACT_WRK_UNIT_EXT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
24	PERIODTYPE	☐	DPR_TV_PERIOD_TYPE	DPR_PERIOD_TYPE	NUMC	2	0	Period Type (Weekly/Monthly/Generic Interval)
25	ALLOCATION_UNIT	☐	DPR_TV_ALLOCATION_UNIT	MEINS	UNIT	3	0	Distribution Unit	*
26	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
27	FORECASTED_START	☐	DPR_TV_FORECASTED_START		DATS	8	0	Forecasted Start Date
28	FORECASTED_FINISH	☐	DPR_TV_FORECASTED_FINISH		DATS	8	0	Forecasted Finish Date
29	SORT_OVERALL	☐	DPR_TV_SORT_OVERALL	CHAR1	CHAR	1	0	Sort Mode
30	ACTUAL2PLAN	☐	DPR_TV_ACTUAL2PLAN	DPR_ACTUAL2PLAN	CHAR	1	0	Overwrite Planned Dates by Actual Dates
31	EXTENDED_ATTRIBUTES	☐	DPR_TS_PROJECT_EXTENDED_ATTR		STRU	0	0
32	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
33	.INCLUDE	☐				0	0
34	.INCLUDE	☐				0	0	Non-Modifiable Project Definition Attributes
35	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
36	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
37	SCHEDULED_START	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
38	SCHEDULED_FINISH	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
39	CREATED_BY	☐	DPR_TV_CREATED_BY	XUBNAME	CHAR	12	0	Created By	*
40	CREATED_BY_NAME	☐	DPR_TV_CREATED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Created the Project Element
41	CREATED_ON	☐	DPR_TV_CREATED_ON_DATE		DATS	8	0	Created On
42	CHANGED_BY	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
43	CHANGED_BY_NAME	☐	DPR_TV_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Last Changed the Project Element
44	CHANGED_ON	☐	DPR_TV_CHANGED_ON_DATE		DATS	8	0	Changed On
45	PRO_CATEGORY	☐	DPR_TV_PRO_CATEGORY	DPR_PROJECT_CATEGORY	CHAR	1	0	Project Category	DPR_PRO_CATEG
46	TEMPLATE_ADMIN_NAME	☐	DPR_TV_TEMPLATE_ADMIN_NAME	TEXT80	CHAR	80	0	Name of Person Responsible for Template
47	TEMPLATE_ID	☐	DPR_TV_PRO_TEMPLATE_ID	CGPL_EXTID	CHAR	24	0	Project Template Number
48	RELEASE_DATE	☐	DPR_TV_RELEASE_DATE	DATS	DATS	8	0	Release Date
49	RESCHEDULE	☐	DPR_TV_RESCHEDULE	DPR_BOOLEAN	CHAR	1	0	Rescheduling Required
50	LAST_CHANGE_DATE	☐	DPR_TV_LAST_CHANGE_DATE		DATS	8	0	Date of Last Change
51	LAST_CHANGE_TIME	☐	DPR_TV_LAST_CHANGE_TIME		TIMS	6	0	Last Changed at
52	LAST_CHANGED_BY	☐	DPR_TV_LAST_CHANGED_BY	USNAM	CHAR	12	0	User Who Changed Project Data Last
53	LAST_CHANGED_BY_NAME	☐	DPR_TV_LAST_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Changed Project Data Last
54	PRO_TYPE_TEXT	☐	DPR_TV_PRO_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Project Type Text
55	CAUSE_TEXT	☐	DPR_TV_CAUSE_TEXT	DPR_TEXT	CHAR	40	0	Description of Project Reason
56	.INCLUDE	☐				0	0	Development Projects: Status (External)
57	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
58	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
59	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
60	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
61	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
62	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
63	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
64	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
65	CUSTOMER_NAME	☐	DPR_TV_CUSTOMER_NAME	TEXT80	CHAR	80	0	Customer
66	SOLD_TO_PARTY_NAME	☐	DPR_TV_SOLD_TO_PARTY_NAME	TEXT80	CHAR	80	0	Sold-to Party
67	GUID_CHAR	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
68	CALENDER_TEXT	☐	SC_TXTFAC	TEXT40	CHAR	40	0	Factory calendar name
69	.INCLUDE	☐				0	0	ID and Description of Reponsible Organization
70	RESP_ORG_U_SHORT	☐	DPR_TV_ORG_UNIT	CHAR12	CHAR	12	0	Responsible Organizational Unit
71	RESP_ORG_U_STEXT	☐	DPR_TV_TEXT	DPR_TEXT	CHAR	40	0	Object Name
72	ACT_WRK_UNIT_EXT_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
73	ACT_WRK_UNIT_EXT_MSEHL	☐	DPR_TV_ACT_WRK_UNIT_MSEHL	TEXT30	CHAR	30	0	Description of Unit of Measurement for Confirmation
74	THRESHOLD_TEXT	☐	EVE_TV_THRESHOLD_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Threshold Value Description
75	SEVERITY_TEXT	☐	EVE_TV_SEVERITY_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Severity of Threshold Value Description
76	AREA	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	*
77	AREA_TEXT	☐	DPR_TV_AREA_TEXT	TEXT30	CHAR	30	0	Area Text
78	LOCATION_TEXT	☐	DPR_TV_LOCATION_TEXT	TEXT30	CHAR	30	0	Location Text
79	DURATION	☐	DPR_TV_DURATION		QUAN	4	0	Processing Time
80	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
81	DURATION_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
82	LONGTEXT	☐	DPR_TV_LONG_TEXT		STRG	0	0	Object Description (Long Text)
83	PERSON_RESPONSIBLE	☐	DPR_TV_PERSON_RESPONSIBLE		CHAR	150	0	Responsible
84	ROLE_RESPONSIBLE	☐	DPR_TV_ROLE_RESPONSIBLE	DPR_TEXT	CHAR	40	0	Responsible Role
85	ROLE_RESPONSIBLE_EXTID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_XML_PROJECT_DATA_TYPE	CALENDAR_ID	TFACD	IDENT
2	DPR_TS_XML_PROJECT_DATA_TYPE	CAUSE	DPR_CAUSE	CAUSE	KEY	1	CN
3	DPR_TS_XML_PROJECT_DATA_TYPE	CUSTOMER_ID	BUT000	PARTNER	KEY	1	CN
4	DPR_TS_XML_PROJECT_DATA_TYPE	MASTER_LANGUAGE	T002	SPRAS	KEY	1	CN
5	DPR_TS_XML_PROJECT_DATA_TYPE	PRIORITY	CGPL_PRIO	PRIORITY	KEY	1	CN
6	DPR_TS_XML_PROJECT_DATA_TYPE	PRO_CATEGORY	DPR_PRO_CATEG	PRO_CATEGORY	KEY	1	CN
7	DPR_TS_XML_PROJECT_DATA_TYPE	PRO_TYPE	DPR_PRO_TYPE	PRO_TYPE	KEY	1	CN
8	DPR_TS_XML_PROJECT_DATA_TYPE	STAT_PROFILE_PRO	TJ21	STSMA	REF	1	CN

History

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