SAP ABAP Table DPR_TS_CHECKLIST_ITEM_DAT (Checklist Item 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_ITEM_DAT	Table Relationship Diagram
Short Description	Checklist Item 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	.INCLUDE	☐				0	0	Checklist Item Attributes (External)
3	.INCLUDE	☐				0	0	Modifiable Attributes of Checklist Item
4	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
5	ACTUAL_FINISH	☐	DPR_TV_ACTUAL_FINISH		DATS	8	0	Actual Finish
6	SORT_NUMBER	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
7	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
8	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
9	MASTER_LANGUAGE	☐	DPR_TV_LANGU	SPRAS	LANG	1	0	Language Key	*
10	CHANGEABILITY	☐	DPR_TV_CHANGEABILITY_ITEM	DPR_CHANGEABILITY_ITEM	CHAR	1	0	Changeability of Checklist Items
11	OK	☐	DPR_TV_CHECKLIST_ITEM_OK	DPR_BOOLEAN	CHAR	1	0	OK
12	NOK	☐	DPR_TV_CHECKLIST_ITEM_NOK	DPR_BOOLEAN	CHAR	1	0	Not OK
13	NOT_RELEVANT	☐	DPR_TV_NOT_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Not Relevant
14	OBLIGATORY	☐	DPR_TV_OBLIGATORY	DPR_BOOLEAN	CHAR	1	0	Mandatory
15	APP_RELEVANT	☐	DPR_TV_APPROVAL_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Relevant for Approval
16	PROCESS	☐	DPR_TV_PROCESS	DPR_PROCESS	CHAR	15	0	Process	DPR_PROCESS
17	SEVERITY	☐	DPR_TV_SEVERITY	DPR_FMEA_RATING	DEC	2	0	Severity
18	OCCURENCE	☐	DPR_TV_OCCURENCE	DPR_FMEA_RATING	DEC	2	0	Occurrence
19	DETECTION	☐	DPR_TV_DETECTION	DPR_FMEA_RATING	DEC	2	0	Detection
20	DESCRIPTION	☐	DPR_TV_NAME	TEXT40	CHAR	40	0	Project Element Name
21	CONSTR_TYPE_FIN	☐	DPR_TV_FINISH_CONSTRAINT	DPR_FINISH_CONSTRAINT	CHAR	1	0	Constraint on Finish Date
22	FINISH_DATE_FIX	☐	DPR_TV_FINISH_DATE_FIX		DATS	8	0	Fixed Predefined Finish Date
23	STAT_PROFILE_CLI	☐	DPR_TV_STAT_PROFILE_CLI	J_STSMA	CHAR	8	0	Status Profile Template	TJ21
24	FORECASTED_FINISH	☐	DPR_TV_FORECASTED_FINISH		DATS	8	0	Forecasted Finish Date
25	EXTENDED_ATTRIBUTES	☐	DPR_TS_CHCKLST_I_EXTENDED_ATTR		STRU	0	0
26	EA_DUMMY	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
27	.INCLUDE	☐				0	0
28	.INCLUDE	☐				0	0	Non-Modifiable Attributes of Checklist Item
29	GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
30	VERSION_NUMBER	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
31	SCHEDULED_FINISH	☐	DPR_TV_SCHEDULED_FINISH		DATS	8	0	Calculated Finish Date
32	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
33	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
34	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
35	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
36	SCHEDULED_FINISH_LATE	☐	DPR_TV_SCHEDULED_FINISH_LATE		DATS	8	0	Latest Finish Date
37	RPN	☐	DPR_TV_RPN	DPR_RPN	DEC	4	0	Risk Priority Number
38	.INCLUDE	☐				0	0	Development Projects: Status (External)
39	OBJNR	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
40	ISTAT	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
41	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
42	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
43	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
44	TXT04	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
45	TXT30	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
46	STATTXT	☐	DPR_TV_STATUS_TXT		STRG	0	0	Concatenated Status Text of an Object
47	GUID_CHAR	☐	DPR_TV_OBJECT_GUID_CHAR	SYSUUID_C	CHAR	32	0	Unique Object Key
48	CREATED_BY_NAME	☐	DPR_TV_CREATED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Created the Project Element
49	CHANGED_BY_NAME	☐	DPR_TV_CHANGED_BY_NAME	TEXT80	CHAR	80	0	Name of Person Who Last Changed the Project Element
50	PROCESS_TEXT	☐	DPR_TV_TEXT	DPR_TEXT	CHAR	40	0	Object Name
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	CL_ITEM_ID	☐	DPR_TV_CHECKLIST_ITEM_ID		CHAR	24	0	Checklist Item Number
54	.INCLU-INT	☐				0	0	Checklist Item in Internal Display
55	GUIDINT	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
56	EXTERNAL_IDINT	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
57	.INCLUDE	☐				0	0	Project Planning: Projects and Activities Include Structure
58	PROJECT_GUIDINT	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
59	OBJECT_TYPEINT	☐	CGPL_OBJECT_TYPE	CHAR3	CHAR	3	0	Object Type in Project Planning
60	PRIORITYINT	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
61	ACTUALSTARTINT	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
62	ACTUALFINISHINT	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
63	PLANSTARTINT	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
64	PLANFINISHINT	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
65	COMPLETIONINT	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
66	MILESTONEINT	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
67	CONSTRAINT_TYPEINT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
68	CONSTRAINT_TIMEINT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
69	CREATED_BYINT	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
70	CREATED_ONINT	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
71	CREATED_IN_BWINT	☐	CGPL_CREATED_BW	CHAR1	CHAR	1	0	Transfer Object to BW
72	CHANGED_BYINT	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
73	CHANGED_ONINT	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
74	UPDATED_IN_BWINT	☐	CGPL_UPDATED_BW	CHAR1	CHAR	1	0	Current Object in BW
75	BWIDENTIFIERINT	☐	CGPL_BWIDENTIFIER	CGPL_BWIDENTIFIER	NUMC	8	0	Project Planning - BW Identification
76	PLANGROUPINT	☐	CGPL_SEM_PLGRP		CHAR	4	0	Planning Profile Group
77	LATEST_STARTINT	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
78	LATEST_FINISHINT	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
79	TOTAL_FLOATINT	☐	CGPL_TOTAL_FLOAT	CGPL_FLOAT	DEC	8	2	Total Float
80	DURATIONINT	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
81	DURATION_UNITINT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
82	CALENDAR_IDINT	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	*
83	CONSTR_TYPE_FININT	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
84	CONSTR_TIME_FININT	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
85	APPLICATIONINT	☐	CGPL_APPLICATION_TYPE	CGPL_APPLICATION_TYPE	CHAR	3	0	Application in Project Planning	*
86	FORECAST_STARTINT	☐	CGPL_FORECAST_START	BCOS_TSTMP	DEC	15	0	Forecast Start
87	FORECAST_FINISHINT	☐	CGPL_FORECAST_FINISH	BCOS_TSTMP	DEC	15	0	Forecast Finish
88	.INCLUDE	☐				0	0	Include for Processing Status
89	PROC_STATUS_OWNINT	☐	DPR_TV_PROC_STATUS_OWN	DPR_PROC_STATUS	CHAR	2	0	Object Processing Status
90	PROC_STATUS_SUPINT	☐	DPR_TV_PROC_STATUS_SUP	DPR_PROC_STATUS	CHAR	2	0	Processing Status of Higher-Level Object
91	.INCLUDE	☐				0	0	Include for Checklist Item Attributes
92	CL_ITEM_IDINT	☐	DPR_TV_CHECKLIST_ITEM_ID		CHAR	24	0	Checklist Item Number
93	SORT_NUMBERINT	☐	DPR_TV_SORT_NUMBER		NUMC	5	0	Sort Number
94	VERSION_NUMBERINT	☐	CGPL_TV_VERSION	CGPL_VERSION	CHAR	24	0	Version Number
95	GROUPINGINT	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
96	SEARCH_FIELDINT	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
97	MASTER_LANGUAGEINT	☐	DPR_TV_LANGU	SPRAS	LANG	1	0	Language Key	*
98	TEMPLATE_GUIDINT	☐	DPR_TV_ENTITY_GUID	DPR_ENTITY_GUID	RAW	16	0	Application Object GUID (Entity with Conversion Exit)	DPR_CHECKLIST_I
99	CHANGEABILITYINT	☐	DPR_TV_CHANGEABILITY_ITEM	DPR_CHANGEABILITY_ITEM	CHAR	1	0	Changeability of Checklist Items
100	OKINT	☐	DPR_TV_CHECKLIST_ITEM_OK	DPR_BOOLEAN	CHAR	1	0	OK
101	NOKINT	☐	DPR_TV_CHECKLIST_ITEM_NOK	DPR_BOOLEAN	CHAR	1	0	Not OK
102	NOT_RELEVANTINT	☐	DPR_TV_NOT_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Not Relevant
103	OBLIGATORYINT	☐	DPR_TV_OBLIGATORY	DPR_BOOLEAN	CHAR	1	0	Mandatory
104	APP_RELEVANTINT	☐	DPR_TV_APPROVAL_RELEVANT	DPR_BOOLEAN	CHAR	1	0	Relevant for Approval
105	PROCESSINT	☐	DPR_TV_PROCESS	DPR_PROCESS	CHAR	15	0	Process	DPR_PROCESS
106	SEVERITYINT	☐	DPR_TV_SEVERITY	DPR_FMEA_RATING	DEC	2	0	Severity
107	OCCURENCEINT	☐	DPR_TV_OCCURENCE	DPR_FMEA_RATING	DEC	2	0	Occurrence
108	DETECTIONINT	☐	DPR_TV_DETECTION	DPR_FMEA_RATING	DEC	2	0	Detection
109	RPNINT	☐	DPR_TV_RPN	DPR_RPN	DEC	4	0	Risk Priority Number
110	STAT_PROFILE_CLIINT	☐	DPR_TV_STAT_PROFILE_CLI	J_STSMA	CHAR	8	0	Status Profile Template	*
111	SCHEDULE_INDINT	☐	PPM_SCHEDULE_INDICATOR	PPM_SCHEDULE_INDICATOR	CHAR	1	0	Status of Scheduling Data
112	.INCLUDE	☐				0	0	Include for Extended Attributes of Checklist Item
113	EA_DUMMYINT	☐	DPR_TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced Proj. Mgmt Attributes
114	.INCLUDE	☐				0	0
115	STATUS	☐	DPR_TT_STATUS_EXT		TTYP	0	0
116	TEXTS	☐	DPR_TT_TEXT_EXT		TTYP	0	0
117	TASKS	☐	DPR_TT_TASK_DAT		TTYP	0	0
118	DOCUMENTS	☐	DPR_TT_DOCUMENT_DAT		TTYP	0	0
119	OBJECT_LINKS	☐	DPR_TT_OBJLINK_DAT		TTYP	0	0
120	PARTICIPANT_LINKS	☐	DPR_TT_ENTITY_LINK_DAT		TTYP	0	0
121	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_CHECKLIST_ITEM_DAT	PRIORITY	CGPL_PRIO	PRIORITY	KEY
2	DPR_TS_CHECKLIST_ITEM_DAT	PRIORITYINT	CGPL_PRIO	PRIORITY	KEY
3	DPR_TS_CHECKLIST_ITEM_DAT	PROCESS	DPR_PROCESS	PROCESS
4	DPR_TS_CHECKLIST_ITEM_DAT	PROCESSINT	DPR_PROCESS	PROCESS
5	DPR_TS_CHECKLIST_ITEM_DAT	STAT_PROFILE_CLI	TJ21	STSMA	REF	1	CN
6	DPR_TS_CHECKLIST_ITEM_DAT	TEMPLATE_GUIDINT	DPR_CHECKLIST_I	GUID	REF	1	CN

History

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