SAP ABAP Table DPR_TS_TASK_DAT_FLAT (Task Data (Flat List))

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_TASK_DAT_FLAT	Table Relationship Diagram
Short Description	Task Data (Flat List)

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	LEVEL	☐			CHAR	3	0
2	IS_TEMPLATE	☐	DPR_TV_IS_TEMPLATE	CHAR1	CHAR	1	0	Template (Yes/No)
3	.INCLUDE	☐				0	0	Task in External Display
4	.INCLUDE	☐				0	0	Modifiable Task Attributes
5	EXTERNAL_ID	☐	DPR_TV_TASK_ID		CHAR	24	0	Task Number
6	ACTUAL_START	☐	DPR_TV_ACTUAL_START		DATS	8	0	Actual Start
7	ACTUAL_FINISH	☐	DPR_TV_ACTUAL_FINISH		DATS	8	0	Actual Finish
8	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
9	CONSTRAINT_TYPE	☐	DPR_TV_START_CONSTRAINT	DPR_START_CONSTRAINT	CHAR	1	0	Constraint on Start Date
10	START_DATE_FIX	☐	DPR_TV_START_DATE_FIX		DATS	8	0	Fixed Start Date
11	DURATION	☐	DPR_TV_DURATION		QUAN	4	0	Processing Time
12	CALENDAR_ID	☐	DPR_TV_CALENDAR_ID	WFCID	CHAR	2	0	Calendar	*
13	CONSTR_TYPE_FIN	☐	DPR_TV_FINISH_CONSTRAINT	DPR_FINISH_CONSTRAINT	CHAR	1	0	Constraint on Finish Date
14	FINISH_DATE_FIX	☐	DPR_TV_FINISH_DATE_FIX		DATS	8	0	Fixed Predefined Finish Date
15	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
16	TSK_TYPE	☐	DPR_TV_TSK_TYPE	DPR_TYPE	CHAR	15	0	Task Type	DPR_TSK_TYPE
17	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
18	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
19	OBLIGATORY	☐	DPR_TV_OBLIGATORY	DPR_BOOLEAN	CHAR	1	0	Mandatory
20	APP_RELEVANT	☐	DPR_TV_APPROVAL_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Relevant for Approval
21	PROCESS	☐	DPR_TV_PROCESS	DPR_PROCESS	CHAR	15	0	Process	DPR_PROCESS
22	WORK_EFFORT	☐	DPR_TV_WORK	DPR_WORK	QUAN	9	2	Work
23	WORK_UNIT	☐	DPR_TV_WORK_UNIT	MEINS	UNIT	3	0	Unit for Work	*
24	DESCRIPTION	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
25	MILESTONE	☐	DPR_TV_MILESTONE	DPR_BOOLEAN	CHAR	1	0	Milestone Indicator
26	STAT_PROFILE_TSK	☐	DPR_TV_STAT_PROFILE_TSK	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
27	ACT_WRK_EFFORT_EXT	☐	DPR_TV_ACT_WORK_EXT	DPR_WORK	QUAN	9	2	Confirmation
28	ACT_WRK_UNIT_EXT	☐	DPR_TV_ACT_WRK_UNIT	MEINS	UNIT	3	0	Confirmation Unit	*
29	REM_WRK_EFFORT_EXT	☐	DPR_TV_REM_WORK_EXT	DPR_WORK	QUAN	9	2	Remaining Work
30	REM_WRK_UNIT_EXT	☐	DPR_TV_REM_WRK_UNIT	MEINS	UNIT	3	0	Unit for Remaining Work	*
31	FLG_MAN_REM_WORK	☐	DPR_TV_MAN_REM_WORK	DPR_BOOLEAN	CHAR	1	0	Enter Remaining Work Manually
32	RATE	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	*
33	REVENUE_RATE	☐	DPR_TV_REVENUE_RATE_MANUAL	PREIS	CURR	11	2	Different Revenue
34	CURRENCY	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
35	COST_RATE	☐	DPR_TV_COST_RATE_MANUAL	PREIS	CURR	11	2	Different Costs
36	CURRENCY_COST	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
37	TIME_UNIT	☐	DPR_TV_TIME_UNIT_MANUAL	MEINS	UNIT	3	0	Activity Unit for Deviating Costs and Revenues	*
38	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
39	FORECASTED_START	☐	DPR_TV_FORECASTED_START		DATS	8	0	Forecasted Start Date
40	FORECASTED_FINISH	☐	DPR_TV_FORECASTED_FINISH		DATS	8	0	Forecasted Finish Date
41	EXTENDED_ATTRIBUTES	☐	DPR_TS_TASK_EXTENDED_ATTR		STRU	0	0
42	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
43	.INCLUDE	☐				0	0
44	.INCLUDE	☐				0	0
45	.INCLUDE	☐				0	0	Non-Modifiable Task Attributes
46	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
47	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
48	SCHEDULED_START	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
49	SCHEDULED_FINISH	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
50	CREATED_BY	☐	DPR_TV_CREATED_BY	XUBNAME	CHAR	12	0	Created By	*
51	CREATED_BY_NAME	☐	DPR_TV_CREATED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Created the Project Element
52	CREATED_ON	☐	DPR_TV_CREATED_ON_DATE		DATS	8	0	Created On
53	CHANGED_BY	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
54	CHANGED_BY_NAME	☐	DPR_TV_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Last Changed the Project Element
55	CHANGED_ON	☐	DPR_TV_CHANGED_ON_DATE		DATS	8	0	Changed On
56	SCHEDULED_START_LATE	☐	DPR_TV_SCHEDULED_START_LATE		DATS	8	0	Latest Start Date
57	SCHEDULED_FINISH_LATE	☐	DPR_TV_SCHEDULED_FINISH_LATE		DATS	8	0	Latest Finish Date
58	TOTAL_FLOAT	☐	DPR_TV_TOTAL_FLOAT		QUAN	8	0	Total Float
59	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
60	GUID_CHAR	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
61	.INCLUDE	☐				0	0	Development Projects: Status (External)
62	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
63	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
64	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
65	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
66	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
67	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
68	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
69	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
70	TSK_TYPE_TEXT	☐	DPR_TV_TSK_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Text for Task Type
71	CALENDER_TEXT	☐	SC_TXTFAC	TEXT40	CHAR	40	0	Factory calendar name
72	PROCESS_TEXT	☐	DPR_TV_PROCESS_TEXT	DPR_TEXT	CHAR	40	0	Process Description
73	WORK_UNIT_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
74	WORK_UNIT_MSEHL	☐	DPR_TV_WORK_UNIT_MSEHL	TEXT30	CHAR	30	0	Description of Unit of Measure for Work
75	ACT_WRK_UNIT_EXT_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
76	ACT_WRK_UNIT_EXT_MSEHL	☐	DPR_TV_ACT_WRK_UNIT_MSEHL	TEXT30	CHAR	30	0	Description of Unit of Measurement for Confirmation
77	REM_WRK_UNIT_EXT_MSEHT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
78	REM_WRK_UNIT_EXT_MSEHL	☐	DPR_TV_REM_WRK_UNIT_MSEHL	TEXT30	CHAR	30	0	Description of Unit of Measurement for Remaining Work
79	THRESHOLD_TEXT	☐	EVE_TV_THRESHOLD_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Threshold Value Description
80	SEVERITY_TEXT	☐	EVE_TV_SEVERITY_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Severity of Threshold Value Description
81	MIRRORED_TASK	☐	DPR_TV_MIRRORED_TASK	DPR_BOOLEAN	CHAR	1	0	Mirrored Task
82	DURATION_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
83	COST_RATE_DEF	☐	DPR_TV_COST_VALUE	PREIS	CURR	11	2	Cost per Activity Unit
84	REVENUE_RATE_DEF	☐	DPR_TV_REVENUE_VALUE	PREIS	CURR	11	2	Revenues per Activity Unit
85	SUMMARY_TASK	☐	DPR_TV_SUMMARY_TASK	DPR_BOOLEAN	CHAR	1	0	Summary Task
86	TASK_ID	☐	DPR_TV_TASK_ID		CHAR	24	0	Task Number
87	TIME_UNIT_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
88	CURRENCY_TEXT	☐	MSEHT	TEXT10	CHAR	10	0	Unit of Measurement Text (Maximum 10 Characters)
89	LAST_CHANGED_TIMESTAMP	☐	DPR_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
90	.INCLU-INT	☐				0	0	Task Attributes (Internal)
91	GUIDINT	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
92	EXTERNAL_IDINT	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
93	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
94	PROJECT_GUIDINT	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
95	OBJECT_TYPEINT	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
96	PRIORITYINT	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
97	ACTUALSTARTINT	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
98	ACTUALFINISHINT	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
99	PLANSTARTINT	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
100	PLANFINISHINT	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
101	COMPLETIONINT	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
102	MILESTONEINT	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
103	CONSTRAINT_TYPEINT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
104	CONSTRAINT_TIMEINT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
105	CREATED_BYINT	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
106	CREATED_ONINT	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
107	CREATED_IN_BWINT	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
108	CHANGED_BYINT	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
109	CHANGED_ONINT	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
110	UPDATED_IN_BWINT	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
111	BWIDENTIFIERINT	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
112	PLANGROUPINT	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
113	LATEST_STARTINT	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
114	LATEST_FINISHINT	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
115	TOTAL_FLOATINT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
116	DURATIONINT	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
117	DURATION_UNITINT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
118	CALENDAR_IDINT	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
119	CONSTR_TYPE_FININT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
120	CONSTR_TIME_FININT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
121	APPLICATIONINT	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
122	FORECAST_STARTINT	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
123	FORECAST_FINISHINT	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
124	.INCLUDE	☐				0	0	Include for Processing Status
125	PROC_STATUS_OWNINT	☐	DPR_TV_PROC_STATUS_OWN	DPR_PROC_STATUS	CHAR	2	0	Object Processing Status
126	PROC_STATUS_SUPINT	☐	DPR_TV_PROC_STATUS_SUP	DPR_PROC_STATUS	CHAR	2	0	Processing Status of Higher-Level Object
127	.INCLUDE	☐				0	0	Include for Task Attributes
128	TASK_IDINT	☐	DPR_TV_TASK_ID		CHAR	24	0	Task Number
129	SORT_NUMBERINT	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
130	VERSION_NUMBERINT	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
131	TSK_TYPEINT	☐	DPR_TV_TSK_TYPE	DPR_TYPE	CHAR	15	0	Task Type	DPR_TSK_TYPE
132	GROUPINGINT	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
133	SEARCH_FIELDINT	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
134	OBLIGATORYINT	☐	DPR_TV_OBLIGATORY	DPR_BOOLEAN	CHAR	1	0	Mandatory
135	APP_RELEVANTINT	☐	DPR_TV_APPROVAL_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Relevant for Approval
136	PROCESSINT	☐	DPR_TV_PROCESS	DPR_PROCESS	CHAR	15	0	Process	DPR_PROCESS
137	WORK_EFFORTINT	☐	DPR_TV_WORK	DPR_WORK	QUAN	9	2	Work
138	WORK_UNITINT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
139	STAT_PROFILE_TSKINT	☐	DPR_TV_STAT_PROFILE_TSK	J_STSMA	CHAR	8	0	Status Profile Template	*
140	ACT_WORK_EFFORTINT	☐	DPR_TV_ACT_WORK	DPR_WORK_LONG	QUAN	16	3	Confirmation (Insternal Display)
141	ACT_WORK_UNITINT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
142	ACT_WRK_UNIT_EXTINT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
143	REM_WORK_EFFORTINT	☐	DPR_TV_REM_WORK	DPR_WORK_LONG	QUAN	16	3	Remaining Work
144	REM_WORK_UNITINT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
145	REM_WRK_UNIT_EXTINT	☐	DPR_TV_UNIT	MEINS	UNIT	3	0	Unit	*
146	FLG_MAN_REM_WORKINT	☐	DPR_TV_MAN_REM_WORK	DPR_BOOLEAN	CHAR	1	0	Enter Remaining Work Manually
147	CONF_GUIDINT	☐	DPR_TV_CONF_GUID		RAW	16	0	GUID of a Confirmation Document
148	MIRRORED_TASKINT	☐	DPR_TV_MIRRORED_TASK	DPR_BOOLEAN	CHAR	1	0	Mirrored Task
149	SCHEDULE_INDINT	☐	PPM_SCHEDULE_INDICATOR	PPM_SCHEDULE_INDICATOR	CHAR	1	0	Status of Scheduling Data
150	SCHED_BEHAVIOURINT	☐	DPR_TV_SCHED_BEHAVIOUR	DPR_SCHEDULE_BEHAVIOUR	CHAR	1	0	Scheduling Behavior
151	SUMMARY_TASKINT	☐	DPR_TV_SUMMARY_TASK	DPR_BOOLEAN	CHAR	1	0	Summary Task
152	RATEINT	☐	DPR_TV_RATE	DPR_RATE_TYPE	CHAR	15	0	Cost Rate/Revenue Rate for Project Costing	*
153	REVENUE_RATEINT	☐	DPR_TV_REVENUE_RATE_MANUAL	PREIS	CURR	11	2	Different Revenue
154	CURRENCYINT	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
155	COST_RATEINT	☐	DPR_TV_COST_RATE_MANUAL	PREIS	CURR	11	2	Different Costs
156	CURRENCY_COSTINT	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
157	TIME_UNITINT	☐	DPR_TV_TIME_UNIT_MANUAL	MEINS	UNIT	3	0	Activity Unit for Deviating Costs and Revenues	*
158	CANC_REM_WORKINT	☐	DPR_TV_CANC_REM_WORK	DPR_WORK_LONG	QUAN	16	3	Remaining Work Before Task Is Canceled
159	.INCLUDE	☐				0	0	Include for Extended Attributes for Task
160	EA_DUMMYINT	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
161	.INCLUDE	☐				0	0
162	.INCLUDE	☐				0	0
163	STATUS	☐	DPR_TT_STATUS_EXT		TTYP	0	0
164	TEXTS	☐	DPR_TT_TEXT_EXT		TTYP	0	0
165	DOCUMENTS	☐	DPR_TT_DOCUMENT_DAT		TTYP	0	0
166	OBJECT_LINKS	☐	DPR_TT_OBJLINK_DAT		TTYP	0	0
167	SKILLS	☐	DPR_TT_SKILL_DAT		TTYP	0	0
168	PARTICIPANT_LINKS	☐	DPR_TT_ENTITY_LINK_DAT		TTYP	0	0
169	COLLABORATIONS	☐	DPR_TT_COLL_LINK_DAT		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_TASK_DAT_FLAT	PRIORITY	CGPL_PRIO	PRIORITY	KEY	1	CN
2	DPR_TS_TASK_DAT_FLAT	PRIORITYINT	CGPL_PRIO	PRIORITY	KEY
3	DPR_TS_TASK_DAT_FLAT	PROCESS	DPR_PROCESS	PROCESS
4	DPR_TS_TASK_DAT_FLAT	PROCESSINT	DPR_PROCESS	PROCESS
5	DPR_TS_TASK_DAT_FLAT	STAT_PROFILE_TSK	TJ21	STSMA	REF	1	CN
6	DPR_TS_TASK_DAT_FLAT	TSK_TYPE	DPR_TSK_TYPE	TSK_TYPE	KEY
7	DPR_TS_TASK_DAT_FLAT	TSK_TYPEINT	DPR_TSK_TYPE	TSK_TYPE	KEY

History

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