SAP ABAP Table DPR_TS_XML_EXT (Fields for cProjects XML File)

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_EXT	Table Relationship Diagram
Short Description	Fields for cProjects XML File

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	.INCLUDE	☐				0	0	Modifiable cProjects Attributes
2	ACTUAL_FINISH	☐	DPR_TV_ACTUAL_FINISH		DATS	8	0	Actual Finish
3	ACTUAL_START	☐	DPR_TV_ACTUAL_START		DATS	8	0	Actual Start
4	ACT_WRK_EFFORT_EXT	☐	DPR_TV_ACT_WORK_EXT	DPR_WORK	QUAN	9	2	Confirmation
5	ACT_WRK_UNIT_EXT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
6	APP_RELEVANT	☐	DPR_TV_APPROVAL_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Relevant for Approval
7	BEG_DATE	☐	BEGDA	DATUM	DATS	8	0	Start Date
8	BEG_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9	CALENDAR_ID	☐	DPR_TV_CALENDAR_ID	WFCID	CHAR	2	0	Calendar	TFACD
10	CAND_IN_WORKLIST	☐	DPR_TV_CANDIDATE_IN_WORKLIST	DPR_BOOLEAN	CHAR	1	0	Role Is Displayed in Candidate Manager's Worklist
11	CAUSE	☐	DPR_TV_CAUSE	DPR_CAUSE	CHAR	15	0	Reason for Project	DPR_CAUSE
12	CHANGEABILITY	☐	DPR_TV_CHANGEABILITY	DPR_CHANGEABILITY	CHAR	1	0	Changeability
13	CLH_TYPE	☐	DPR_TV_CLH_TYPE	DPR_TYPE	CHAR	15	0	Checklist Type	DPR_CLH_TYPE
14	COMMENTARY	☐	DPR_TV_COMMENTARY		STRG	0	0	Comment
15	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
16	CONF_GUID	☐	DPR_TV_CONF_GUID		RAW	16	0	GUID of a Confirmation Document
17	CURRENCY	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
18	CUSTOMER_ID	☐	DPR_TV_CUSTOMER_ID	BU_PARTNER	CHAR	10	0	Customer Number	BUT000
19	C_OBJID	☐	HROBJID	HROBJID	NUMC	8	0	Object ID	*
20	DESCRIPTION	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
21	DETECTION	☐	DPR_TV_DETECTION	DPR_FMEA_RATING	DEC	2	0	Detection
22	DURATION	☐	DPR_TV_DURATION		QUAN	4	0	Processing Time
23	END_DATE	☐	ENDDA	DATUM	DATS	8	0	End Date
24	END_TMSTMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
25	ENTITY_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
26	ENTITY_TYPE	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
27	EXTERNAL_ID	☐	DPR_TV_TASK_ID		CHAR	24	0	Task Number
28	FINISH_DATE_FIX	☐	DPR_TV_FINISH_DATE_FIX		DATS	8	0	Fixed Predefined Finish Date
29	FLG_MAN_REM_WORK	☐	DPR_TV_MAN_REM_WORK	DPR_BOOLEAN	CHAR	1	0	Enter Remaining Work Manually
30	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
31	LAG_UNIT	☐	CGPL_LAG_UNIT	MEINS	UNIT	3	0	Unit of Interval of Time Between Project Elements	*
32	LONGTEXT	☐	DPR_TV_LONG_TEXT		STRG	0	0	Object Description (Long Text)
33	MASTER_LANGUAGE	☐	DPR_TV_LANGU	SPRAS	LANG	1	0	Language Key	T002
34	MILESTONE	☐	DPR_TV_MILESTONE	DPR_BOOLEAN	CHAR	1	0	Milestone Indicator
35	NOK	☐	DPR_TV_CHECKLIST_ITEM_NOK	DPR_BOOLEAN	CHAR	1	0	Not OK
36	NOT_RELEVANT	☐	DPR_TV_NOT_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Not Relevant
37	NUMBER	☐	DPR_TV_NUMBER	CGPL_EXTID	CHAR	24	0	Number
38	OBLIGATORY	☐	DPR_TV_OBLIGATORY	DPR_BOOLEAN	CHAR	1	0	Mandatory
39	OCCURENCE	☐	DPR_TV_OCCURENCE	DPR_FMEA_RATING	DEC	2	0	Occurrence
40	OK	☐	DPR_TV_CHECKLIST_ITEM_OK	DPR_BOOLEAN	CHAR	1	0	OK
41	PARTICIPANT_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
42	PARTICIPANT_ROLE	☐	DPR_TV_PARTICIPANT_ROLE	DPR_PARTICIPANT_ROLE	CHAR	15	0	Role Type for Projects	DPR_PART_ROLE
43	PARTICIPANT_ROLE_TEXT	☐	DPR_TV_PARTICIPANT_ROLE_TEXT	DPR_TEXT	CHAR	40	0	Name of Role Type
44	PARTNER_ROLE	☐	DPR_TV_BU_ROLE	BU_RLTYP	CHAR	6	0	BP Role	*
45	PHA_TYPE	☐	DPR_TV_PHA_TYPE	DPR_TYPE	CHAR	15	0	Phase Type	DPR_PHA_TYPE
46	PREDEC_TASK	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
47	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
48	PROCESS	☐	DPR_TV_PROCESS	DPR_PROCESS	CHAR	15	0	Process	DPR_PROCESS
49	PRO_TYPE	☐	DPR_TV_PRO_TYPE	DPR_TYPE	CHAR	15	0	Project Type	DPR_PRO_TYPE
50	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	*
51	REM_WRK_EFFORT_EXT	☐	DPR_TV_REM_WORK_EXT	DPR_WORK	QUAN	9	2	Remaining Work
52	REM_WRK_UNIT_EXT	☐	DPR_TV_REM_WRK_UNIT	MEINS	UNIT	3	0	Unit for Remaining Work	*
53	RESPONSIBLE	☐	DPR_TV_RESPONSIBILITY	DPR_BOOLEAN	CHAR	1	0	Responsibility
54	RESP_ORG_UNIT	☐	DPR_TV_RESP_ORGANIZATION	HROBJID	NUMC	8	0	Organization Responsible	*
55	REVENUE_RATE	☐	DPR_TV_REVENUE_RATE_MANUAL	PREIS	CURR	11	2	Different Revenue
56	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
57	SEVERITY	☐	DPR_TV_SEVERITY	DPR_FMEA_RATING	DEC	2	0	Severity
58	SOLD_TO_PARTY_ID	☐	DPR_TV_SOLD_TO_PARTY_ID	BU_PARTNER	CHAR	10	0	Sold-to Party Number	*
59	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
60	START_DATE_FIX	☐	DPR_TV_START_DATE_FIX		DATS	8	0	Fixed Start Date
61	STAT_PROFILE_CLH	☐	DPR_TV_STAT_PROFILE_CLH	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
62	STAT_PROFILE_CLI	☐	DPR_TV_STAT_PROFILE_CLI	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
63	STAT_PROFILE_PHA	☐	DPR_TV_STAT_PROFILE_PHA	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
64	STAT_PROFILE_PRO	☐	DPR_TV_STAT_PROFILE_PRO	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
65	STAT_PROFILE_PRT	☐	DPR_TV_STAT_PROFILE_PRT	J_STSMA	CHAR	8	0	Status Profile Template	*
66	STAT_PROFILE_TSK	☐	DPR_TV_STAT_PROFILE_TSK	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
67	TEMPLATE_ADMIN_ID	☐	DPR_TV_TEMPLATE_ADMIN_ID	BU_PARTNER	CHAR	10	0	Template Responsible	*
68	TIME_LAG	☐	CGPL_TIME_LAG	CGPL_TIME_LAG	DEC	8	2	Offset Between Project Elements
69	TIME_UNIT	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	*
70	TSK_TYPE	☐	DPR_TV_TSK_TYPE	DPR_TYPE	CHAR	15	0	Task Type	DPR_TSK_TYPE
71	VACANT	☐	DPR_TV_VACANT	DPR_BOOLEAN	CHAR	1	0	Vacant Checkbox of Role
72	WORK_EFFORT	☐	DPR_TV_WORK	DPR_WORK	QUAN	9	2	Work
73	WORK_UNIT	☐	DPR_TV_WORK_UNIT	MEINS	UNIT	3	0	Unit for Work	*
74	.INCLUDE	☐				0	0	Non-Modifiable cProjects Attributes
75	ACT_WRK_UNIT_EXT_MSEHL	☐	DPR_TV_ACT_WRK_UNIT_MSEHL	TEXT30	CHAR	30	0	Description of Unit of Measurement for Confirmation
76	ACT_WRK_UNIT_EXT_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
77	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
78	CALENDER_TEXT	☐	SC_TXTFAC	TEXT40	CHAR	40	0	Factory calendar name
79	CAUSE_TEXT	☐	DPR_TV_CAUSE_TEXT	DPR_TEXT	CHAR	40	0	Description of Project Reason
80	CHANGED_BY	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
81	CHANGED_BY_NAME	☐	DPR_TV_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Last Changed the Project Element
82	CHANGED_ON	☐	DPR_TV_CHANGED_ON_DATE		DATS	8	0	Changed On
83	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
84	CITY_POSTAL_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
85	CLH_TYPE_TEXT	☐	DPR_TV_CLH_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Checklist Type Text
86	COUNTRY	☐	LANDX50	TEXT50	CHAR	50	0	Country Name (Max. 50 Characters)
87	CREATED_BY	☐	DPR_TV_CREATED_BY	XUBNAME	CHAR	12	0	Created By	*
88	CREATED_BY_NAME	☐	DPR_TV_CREATED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Created the Project Element
89	CREATED_ON	☐	DPR_TV_CREATED_ON_DATE		DATS	8	0	Created On
90	CUSTOMER_NAME	☐	DPR_TV_CUSTOMER_NAME	TEXT80	CHAR	80	0	Customer
91	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	T006
92	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
93	EMPLOYEE_ID	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
94	FAX	☐	AD_FXNMBR	CHAR30	CHAR	30	0	Fax number: dialling code+number
95	FULL_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
96	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
97	GUID_CHAR	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
98	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
99	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
100	LAST_CHANGED_BY	☐	DPR_TV_LAST_CHANGED_BY	USNAM	CHAR	12	0	User Who Changed Project Data Last
101	LAST_CHANGED_BY_NAME	☐	DPR_TV_LAST_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Changed Project Data Last
102	LAST_CHANGE_DATE	☐	DPR_TV_LAST_CHANGE_DATE		DATS	8	0	Date of Last Change
103	LAST_CHANGE_TIME	☐	DPR_TV_LAST_CHANGE_TIME		TIMS	6	0	Last Changed at
104	MIRRORED_TASK	☐	DPR_TV_MIRRORED_TASK	DPR_BOOLEAN	CHAR	1	0	Mirrored Task
105	ORGA_NAME1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
106	ORGA_NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
107	ORGA_NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
108	ORGA_NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
109	ORGA_POSTAL_CODE	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
110	PERSON_RESPONSIBLE	☐	DPR_TV_PERSON_RESPONSIBLE		CHAR	150	0	Responsible
111	PHA_TYPE_TEXT	☐	DPR_TV_PHA_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Phase Type Text
112	PHONE	☐	AD_TLNMBR	CHAR30	CHAR	30	0	Telephone no.: dialling code+number
113	POBOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
114	PROCESS_TEXT	☐	DPR_TV_PROCESS_TEXT	DPR_TEXT	CHAR	40	0	Process Description
115	PRO_CATEGORY	☐	DPR_TV_PRO_CATEGORY	DPR_PROJECT_CATEGORY	CHAR	1	0	Project Category	DPR_PRO_CATEG
116	PRO_TYPE_TEXT	☐	DPR_TV_PRO_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Project Type Text
117	RELEASE_DATE	☐	DPR_TV_RELEASE_DATE	DATS	DATS	8	0	Release Date
118	REM_WRK_UNIT_EXT_MSEHL	☐	DPR_TV_REM_WRK_UNIT_MSEHL	TEXT30	CHAR	30	0	Description of Unit of Measurement for Remaining Work
119	REM_WRK_UNIT_EXT_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
120	RESCHEDULE	☐	DPR_TV_RESCHEDULE	DPR_BOOLEAN	CHAR	1	0	Rescheduling Required
121	RESOLUTION_DATE	☐	DPR_TV_RESOLUTION_DATE_EXT		DATS	8	0	Resolution Date
122	RESOLUTION_TIME	☐	DPR_TV_RESOLUTION_TIME_EXT		CHAR	8	0	Resolution Time
123	RESOLUTION_USER_NAME	☐	DPR_TV_RESOLVED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Resolved the Checklist Reference
124	RESOLVED_BY	☐	DPR_TV_RESOLVED_BY	XUBNAME	CHAR	12	0	Name of Person Who Resolved the Checklist Reference	*
125	RESP_ORG_U_SHORT	☐	DPR_TV_ORG_UNIT	CHAR12	CHAR	12	0	Responsible Organizational Unit
126	RESP_ORG_U_STEXT	☐	DPR_TV_TEXT	DPR_TEXT	CHAR	40	0	Object Name
127	ROLE_RESPONSIBLE	☐	DPR_TV_ROLE_RESPONSIBLE	DPR_TEXT	CHAR	40	0	Responsible Role
128	ROLE_RESPONSIBLE_EXTID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
129	RPN	☐	DPR_TV_RPN	DPR_RPN	DEC	4	0	Risk Priority Number
130	SCHEDULED_FINISH	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
131	SCHEDULED_FINISH_LATE	☐	DPR_TV_SCHEDULED_FINISH_LATE		DATS	8	0	Latest Finish Date
132	SCHEDULED_START	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
133	SCHEDULED_START_LATE	☐	DPR_TV_SCHEDULED_START_LATE		DATS	8	0	Latest Start Date
134	SEVERITY_TEXT	☐	EVE_TV_SEVERITY_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Severity of Threshold Value Description
135	SOLD_TO_PARTY_NAME	☐	DPR_TV_SOLD_TO_PARTY_NAME	TEXT80	CHAR	80	0	Sold-to Party
136	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
137	STATUS_TEXT	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
138	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
139	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
140	TEMPLATE_ADMIN_NAME	☐	DPR_TV_TEMPLATE_ADMIN_NAME	TEXT80	CHAR	80	0	Name of Person Responsible for Template
141	TEMPLATE_ID	☐	DPR_TV_PRO_TEMPLATE_ID	CGPL_EXTID	CHAR	24	0	Project Template Number
142	THRESHOLD_TEXT	☐	EVE_TV_THRESHOLD_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Threshold Value Description
143	TOTAL_FLOAT	☐	DPR_TV_TOTAL_FLOAT		QUAN	8	0	Total Float
144	TSK_TYPE_TEXT	☐	DPR_TV_TSK_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Text for Task Type
145	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
146	WORK_UNIT_MSEHL	☐	DPR_TV_WORK_UNIT_MSEHL	TEXT30	CHAR	30	0	Description of Unit of Measure for Work
147	WORK_UNIT_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
148	EXTENDEDATTRIBUTES	☐	DPR_TT_XML_EXT_ATTRS_TYPE		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_XML_EXT	CALENDAR_ID	TFACD	IDENT	KEY	1	CN
2	DPR_TS_XML_EXT	CAUSE	DPR_CAUSE	CAUSE	KEY	1	CN
3	DPR_TS_XML_EXT	CLH_TYPE	DPR_CLH_TYPE	CLH_TYPE
4	DPR_TS_XML_EXT	CUSTOMER_ID	BUT000	PARTNER	KEY	1	CN
5	DPR_TS_XML_EXT	DURATION_UNIT	T006	MSEHI
6	DPR_TS_XML_EXT	MASTER_LANGUAGE	T002	SPRAS	KEY	1	CN
7	DPR_TS_XML_EXT	PARTICIPANT_ROLE	DPR_PART_ROLE	PARTICIPANT_ROLE
8	DPR_TS_XML_EXT	PHA_TYPE	DPR_PHA_TYPE	PHA_TYPE	REF	1	CN
9	DPR_TS_XML_EXT	PRIORITY	CGPL_PRIO	PRIORITY	KEY	1	CN
10	DPR_TS_XML_EXT	PROCESS	DPR_PROCESS	PROCESS
11	DPR_TS_XML_EXT	PRO_CATEGORY	DPR_PRO_CATEG	PRO_CATEGORY	KEY	1	CN
12	DPR_TS_XML_EXT	PRO_TYPE	DPR_PRO_TYPE	PRO_TYPE	KEY	1	CN
13	DPR_TS_XML_EXT	STAT_PROFILE_CLH	TJ21	STSMA	REF	1	CN
14	DPR_TS_XML_EXT	STAT_PROFILE_CLI	TJ21	STSMA	REF	1	CN
15	DPR_TS_XML_EXT	STAT_PROFILE_PHA	TJ21	STSMA	REF	1	CN
16	DPR_TS_XML_EXT	STAT_PROFILE_PRO	TJ21	STSMA	REF	1	CN
17	DPR_TS_XML_EXT	STAT_PROFILE_TSK	TJ21	STSMA	REF	1	CN
18	DPR_TS_XML_EXT	TSK_TYPE	DPR_TSK_TYPE	TSK_TYPE	KEY

History

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