SAP ABAP Table DPR_TS_CHECKLIST_PRT (Checklist Data)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	DPR_TS_CHECKLIST_PRT	Table Relationship Diagram
Short Description	Checklist Data

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	IS_TEMPLATE	☐	DPR_TV_IS_TEMPLATE	CHAR1	CHAR	1	0	Template (Yes/No)
2	FULLNAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
3	.INCLUDE	☐				0	0	Checklist Header in External Display
4	.INCLUDE	☐				0	0	Modifiable Attributes of Checklist Header
5	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority
6	CHECKLIST_ID	☐	DPR_TV_CHECKLIST_ID		CHAR	24	0	Number of Checklist
7	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
8	CLH_TYPE	☐	DPR_TV_CLH_TYPE	DPR_TYPE	CHAR	15	0	Checklist Type	DPR_CLH_TYPE
9	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
10	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
11	MASTER_LANGUAGE	☐	DPR_TV_LANGU	SPRAS	LANG	1	0	Language Key	*
12	TEMPLATE_ADMIN_ID	☐	DPR_TV_TEMPLATE_ADMIN_ID	BU_PARTNER	CHAR	10	0	Template Responsible	*
13	CHANGEABILITY	☐	DPR_TV_CHANGEABILITY	DPR_CHANGEABILITY	CHAR	1	0	Changeability
14	NOT_RELEVANT	☐	DPR_TV_NOT_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Not Relevant
15	DESCRIPTION	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
16	STAT_PROFILE_CLH	☐	DPR_TV_STAT_PROFILE_CLH	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
17	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
18	EXTENDED_ATTRIBUTES	☐	DPR_TS_CHCKLST_H_EXTENDED_ATTR		STRU	0	0
19	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
20	.INCLUDE	☐				0	0
21	.INCLUDE	☐				0	0	Non-Modifiable Attributes of Checklist Header
22	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
23	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
24	CREATED_BY	☐	DPR_TV_CREATED_BY	XUBNAME	CHAR	12	0	Created By	*
25	CREATED_BY_NAME	☐	DPR_TV_CREATED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Created the Project Element
26	CREATED_ON	☐	DPR_TV_CREATED_ON_DATE		DATS	8	0	Created On
27	CHANGED_BY	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
28	CHANGED_BY_NAME	☐	DPR_TV_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Last Changed the Project Element
29	CHANGED_ON	☐	DPR_TV_CHANGED_ON_DATE		DATS	8	0	Changed On
30	RESOLUTION_DATE	☐	DPR_TV_RESOLUTION_DATE_EXT		DATS	8	0	Resolution Date
31	RESOLUTION_TIME	☐	DPR_TV_RESOLUTION_TIME_EXT		CHAR	8	0	Resolution Time
32	RESOLVED_BY	☐	DPR_TV_RESOLVED_BY	XUBNAME	CHAR	12	0	Name of Person Who Resolved the Checklist Reference	*
33	RESOLUTION_USER_NAME	☐	DPR_TV_RESOLVED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Resolved the Checklist Reference
34	LAST_CHANGED_BY	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
35	LAST_CHANGED_BY_NAME	☐	DPR_TV_LAST_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Changed Project Data Last
36	LAST_CHANGE_DATE	☐	DPR_TV_LAST_CHANGE_DATE		DATS	8	0	Date of Last Change
37	LAST_CHANGE_TIME	☐	DPR_TV_LAST_CHANGE_TIME		TIMS	6	0	Last Changed at
38	GUID_CHAR	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
39	.INCLUDE	☐				0	0	Development Projects: Status (External)
40	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
41	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
42	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
43	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
44	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
45	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
46	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
47	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
48	TEMPLATE_ADMIN_NAME	☐	DPR_TV_TEMPLATE_ADMIN_NAME	TEXT80	CHAR	80	0	Name of Person Responsible for Template
49	CLH_TYPE_TEXT	☐	DPR_TV_CLH_TYPE_TEXT	DPR_TEXT	CHAR	40	0	Checklist Type Text
50	TEMPLATE_ID	☐	DPR_TV_CLH_TEMPLATE_ID	CGPL_EXTID	CHAR	24	0	Checklist Template Number
51	THRESHOLD_TEXT	☐	EVE_TV_THRESHOLD_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Threshold Value Description
52	SEVERITY_TEXT	☐	EVE_TV_SEVERITY_DESCRIPTION	EVE_DESCRIPTION	CHAR	40	0	Severity of Threshold Value Description
53	IS_ISSUE_LIST	☐	DPR_TV_IS_ISSUE_LIST	BOOLE	CHAR	1	0	Issue List
54	AREA	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	*
55	AREA_TEXT	☐	DPR_TV_AREA_TEXT	TEXT30	CHAR	30	0	Area Text
56	.INCLU-INT	☐				0	0	Checklist Header in Internal Display
57	GUIDINT	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
58	EXTERNAL_IDINT	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
59	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
60	PROJECT_GUIDINT	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
61	OBJECT_TYPEINT	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
62	PRIORITYINT	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
63	ACTUALSTARTINT	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
64	ACTUALFINISHINT	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
65	PLANSTARTINT	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
66	PLANFINISHINT	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
67	COMPLETIONINT	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
68	MILESTONEINT	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
69	CONSTRAINT_TYPEINT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
70	CONSTRAINT_TIMEINT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
71	CREATED_BYINT	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
72	CREATED_ONINT	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
73	CREATED_IN_BWINT	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
74	CHANGED_BYINT	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
75	CHANGED_ONINT	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
76	UPDATED_IN_BWINT	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
77	BWIDENTIFIERINT	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
78	PLANGROUPINT	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
79	LATEST_STARTINT	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
80	LATEST_FINISHINT	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
81	TOTAL_FLOATINT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
82	DURATIONINT	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
83	DURATION_UNITINT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
84	CALENDAR_IDINT	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
85	CONSTR_TYPE_FININT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
86	CONSTR_TIME_FININT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
87	APPLICATIONINT	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
88	FORECAST_STARTINT	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
89	FORECAST_FINISHINT	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
90	.INCLUDE	☐				0	0	Include for Processing Status
91	PROC_STATUS_OWNINT	☐	DPR_TV_PROC_STATUS_OWN	DPR_PROC_STATUS	CHAR	2	0	Object Processing Status
92	PROC_STATUS_SUPINT	☐	DPR_TV_PROC_STATUS_SUP	DPR_PROC_STATUS	CHAR	2	0	Processing Status of Higher-Level Object
93	.INCLUDE	☐				0	0	Include for Checklist Header Attributes
94	CHECKLIST_IDINT	☐	DPR_TV_CHECKLIST_ID		CHAR	24	0	Number of Checklist
95	VERSION_NUMBERINT	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
96	SORT_NUMBERINT	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
97	CLH_TYPEINT	☐	DPR_TV_CLH_TYPE	DPR_TYPE	CHAR	15	0	Checklist Type	DPR_CLH_TYPE
98	GROUPINGINT	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
99	SEARCH_FIELDINT	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
100	MASTER_LANGUAGEINT	☐	DPR_TV_LANGU	SPRAS	LANG	1	0	Language Key	*
101	TEMPLATE_ADMININT	☐	DPR_TV_TEMPLATE_ADMIN	SYSUUID	RAW	16	0	Template Responsible
102	TEMPLATE_GUIDINT	☐	DPR_TV_ENTITY_GUID	DPR_ENTITY_GUID	RAW	16	0	Application Object GUID (Entity with Conversion Exit)	DPR_CHECKLIST_H
103	RESOLVED_ONINT	☐	DPR_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
104	RESOLVED_BYINT	☐	DPR_TV_RESOLVED_BY	XUBNAME	CHAR	12	0	Name of Person Who Resolved the Checklist Reference	*
105	CHANGEABILITYINT	☐	DPR_TV_CHANGEABILITY	DPR_CHANGEABILITY	CHAR	1	0	Changeability
106	NOT_RELEVANTINT	☐	DPR_TV_NOT_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Not Relevant
107	LAST_CHANGED_ONINT	☐	DPR_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
108	LAST_CHANGED_BYINT	☐	DPR_TV_CHANGED_BY	XUBNAME	CHAR	12	0	Last Changed By	*
109	STAT_PROFILE_CLHINT	☐	DPR_TV_STAT_PROFILE_CLH	J_STSMA	CHAR	8	0	Status Profile Template	*
110	SCHEDULE_INDINT	☐	PPM_SCHEDULE_INDICATOR	PPM_SCHEDULE_INDICATOR	CHAR	1	0	Status of Scheduling Data
111	PRO_TYPE_REFINT	☐	DPR_TV_PRO_TYPE_REF	DPR_TYPE	CHAR	15	0	Project Type for Determining Text Language	*
112	LOCATIONINT	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
113	.INCLUDE	☐				0	0	Include for Extended Attributes of Checklist Header
114	EA_DUMMYINT	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
115	.INCLUDE	☐				0	0
116	.INCLUDE	☐				0	0	Object header data
117	SHOW_PROJECT	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
118	SHOW_PHASE	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
119	SHOW_TASK	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
120	SHOW_CHECKLIST	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
121	SHOW_CHECKLIST_ITEM	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
122	SHOW_CHECKLIST_STATUS	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
123	SHOW_PROJECT_STATUS	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
124	SHOW_PHASE_STATUS	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
125	SHOW_PHASE_DATES	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
126	PROJECT_NAME	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
127	PROJECT_STATUS	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
128	PHASE_NAME	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
129	PHASE_START	☐	DPR_TV_SCHEDULED_START		DATS	8	0	Calculated Start Date
130	PHASE_FINISH	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
131	PHASE_STATUS	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
132	CHECKLIST_NAME	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
133	CHECKLIST_STATUS	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
134	CHECKLIST_ITEM_NAME	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
135	TASK_NAME	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
136	PATH	☐	DPR_TV_PATH_STRING		CHAR	250	0	Hierarchy Path
137	STATUS	☐	DPR_TT_STATUS_EXT		TTYP	0	0
138	TEXTS	☐	DPR_TT_TEXT_EXT		TTYP	0	0
139	ITEMS	☐	DPR_TT_CHECKLIST_ITEM_PRT		TTYP	0	0
140	DOCUMENTS	☐	DPR_TT_DOCUMENT_PRT		TTYP	0	0
141	OBJECT_LINKS	☐	DPR_TT_OBJLINK_PRT		TTYP	0	0
142	PARTICIPANT_LINKS	☐	DPR_TT_ENTITY_LINK_PRT		TTYP	0	0
143	COLLABORATIONS	☐	DPR_TT_COLL_LINK_PRT		TTYP	0	0
144	RESPONSIBLES	☐	DPR_TT_RESPONSIBLE_DAT		TTYP	0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DPR_TS_CHECKLIST_PRT	CLH_TYPE	DPR_CLH_TYPE	CLH_TYPE
2	DPR_TS_CHECKLIST_PRT	CLH_TYPEINT	DPR_CLH_TYPE	CLH_TYPE	REF	1	CN
3	DPR_TS_CHECKLIST_PRT	PRIORITYINT	CGPL_PRIO	PRIORITY	KEY
4	DPR_TS_CHECKLIST_PRT	STAT_PROFILE_CLH	TJ21	STSMA	REF	1	CN
5	DPR_TS_CHECKLIST_PRT	TEMPLATE_GUIDINT	DPR_CHECKLIST_H	GUID	REF	1	CN

History

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