SAP ABAP Table DPR_TS_CHECKLIST_ITEM_PRT (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_PRT   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 FULLNAME BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
3 .INCLUDE       0   0   Checklist Item Attributes (External)  
4 .INCLUDE       0   0   Modifiable Attributes of Checklist Item  
5 PRIORITY CGPL_PRIORITY NUMC3 NUMC 3   0   Priority CGPL_PRIO
6 ACTUAL_FINISH DPR_TV_ACTUAL_FINISH   DATS 8   0   Actual Finish  
7 SORT_NUMBER DPR_TV_SORT_NUMBER   NUMC 5   0   Sort Number  
8 GROUPING DPR_TV_GROUPING   CHAR 40   0   Grouping  
9 SEARCH_FIELD DPR_TV_SEARCH_FIELD   CHAR 40   0   Search Field  
10 MASTER_LANGUAGE DPR_TV_LANGU SPRAS LANG 1   0   Language Key *
11 CHANGEABILITY DPR_TV_CHANGEABILITY_ITEM DPR_CHANGEABILITY_ITEM CHAR 1   0   Changeability of Checklist Items  
12 OK DPR_TV_CHECKLIST_ITEM_OK DPR_BOOLEAN CHAR 1   0   OK  
13 NOK DPR_TV_CHECKLIST_ITEM_NOK DPR_BOOLEAN CHAR 1   0   Not OK  
14 NOT_RELEVANT DPR_TV_NOT_RELEVANT DPR_BOOLEAN CHAR 1   0   Not Relevant  
15 OBLIGATORY DPR_TV_OBLIGATORY DPR_BOOLEAN CHAR 1   0   Mandatory  
16 APP_RELEVANT DPR_TV_APPROVAL_RELEVANT DPR_BOOLEAN CHAR 1   0   Relevant for Approval  
17 PROCESS DPR_TV_PROCESS DPR_PROCESS CHAR 15   0   Process DPR_PROCESS
18 SEVERITY DPR_TV_SEVERITY DPR_FMEA_RATING DEC 2   0   Severity  
19 OCCURENCE DPR_TV_OCCURENCE DPR_FMEA_RATING DEC 2   0   Occurrence  
20 DETECTION DPR_TV_DETECTION DPR_FMEA_RATING DEC 2   0   Detection  
21 DESCRIPTION DPR_TV_NAME TEXT40 CHAR 40   0   Project Element Name  
22 CONSTR_TYPE_FIN DPR_TV_FINISH_CONSTRAINT DPR_FINISH_CONSTRAINT CHAR 1   0   Constraint on Finish Date  
23 FINISH_DATE_FIX DPR_TV_FINISH_DATE_FIX   DATS 8   0   Fixed Predefined Finish Date  
24 STAT_PROFILE_CLI DPR_TV_STAT_PROFILE_CLI J_STSMA CHAR 8   0   Status Profile Template TJ21
25 FORECASTED_FINISH DPR_TV_FORECASTED_FINISH   DATS 8   0   Forecasted Finish Date  
26 EXTENDED_ATTRIBUTES DPR_TS_CHCKLST_I_EXTENDED_ATTR   STRU 0   0    
27 EA_DUMMY DPR_TV_EA_DUMMY CHAR1 CHAR 1   0   Dummy Data Element for Enhanced Proj. Mgmt Attributes  
28 .INCLUDE       0   0    
29 .INCLUDE       0   0   Non-Modifiable Attributes of Checklist Item  
30 GUID DPR_TV_GUID DPR_GUID RAW 16   0   Application Object GUID  
31 VERSION_NUMBER CGPL_TV_VERSION CGPL_VERSION CHAR 24   0   Version Number  
32 SCHEDULED_FINISH DPR_TV_SCHEDULED_FINISH   DATS 8   0   Calculated Finish Date  
33 CREATED_BY CGPL_CREATED_BY USNAM CHAR 12   0   Name of Person Who Created Object  
34 CREATED_ON CGPL_CREATED_ON DATUM DATS 8   0   Date on Which the Object was Created  
35 CHANGED_BY CGPL_CHANGED_BY USNAM CHAR 12   0   Name of Person Who Changed Object  
36 CHANGED_ON CGPL_CHANGED_ON DATUM DATS 8   0   Date on Which Object Was Last Changed  
37 SCHEDULED_FINISH_LATE DPR_TV_SCHEDULED_FINISH_LATE   DATS 8   0   Latest Finish Date  
38 RPN DPR_TV_RPN DPR_RPN DEC 4   0   Risk Priority Number  
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 GUID_CHAR DPR_TV_OBJECT_GUID_CHAR SYSUUID_C CHAR 32   0   Unique Object Key  
49 CREATED_BY_NAME DPR_TV_CREATED_BY_NAME TEXT80 CHAR 80   0   Name of Person Who Created the Project Element  
50 CHANGED_BY_NAME DPR_TV_CHANGED_BY_NAME TEXT80 CHAR 80   0   Name of Person Who Last Changed the Project Element  
51 PROCESS_TEXT DPR_TV_TEXT DPR_TEXT CHAR 40   0   Object Name  
52 THRESHOLD_TEXT EVE_TV_THRESHOLD_DESCRIPTION EVE_DESCRIPTION CHAR 40   0   Threshold Value Description  
53 SEVERITY_TEXT EVE_TV_SEVERITY_DESCRIPTION EVE_DESCRIPTION CHAR 40   0   Severity of Threshold Value Description  
54 CL_ITEM_ID DPR_TV_CHECKLIST_ITEM_ID   CHAR 24   0   Checklist Item Number  
55 .INCLU-INT       0   0   Checklist Item in Internal Display  
56 GUIDINT DPR_TV_GUID DPR_GUID RAW 16   0   Application Object GUID  
57 EXTERNAL_IDINT CGPL_EXTID CGPL_EXTID CHAR 24   0   Project Planning: External Indentifier of an Element  
58 .INCLUDE       0   0   Project Planning: Projects and Activities Include Structure  
59 PROJECT_GUIDINT CGPL_PROJECT_GUID CGPL_PROJECT_GUID RAW 16   0   Project Planning: 16 Character GUID for Projects  
60 OBJECT_TYPEINT CGPL_OBJECT_TYPE CHAR3 CHAR 3   0   Object Type in Project Planning  
61 PRIORITYINT CGPL_PRIORITY NUMC3 NUMC 3   0   Priority CGPL_PRIO
62 ACTUALSTARTINT CGPL_ACTUALSTART BCOS_TSTMP DEC 15   0   Actual Start Date  
63 ACTUALFINISHINT CGPL_ACTUALFINISH BCOS_TSTMP DEC 15   0   Actual Finish Date  
64 PLANSTARTINT CGPL_PLANSTART BCOS_TSTMP DEC 15   0   Planned start date  
65 PLANFINISHINT CGPL_PLANFINISH BCOS_TSTMP DEC 15   0   Planned Finish Date  
66 COMPLETIONINT CGPL_COMPLETION CGPL_COMPLETION NUMC 3   0   Percentage of Completion  
67 MILESTONEINT CGPL_MILESTONE CHAR1 CHAR 1   0   Milestone indicator  
68 CONSTRAINT_TYPEINT CGPL_CONSTRAINT CGPL_CONSTRAINT CHAR 1   0   Type of Scheduling Constraint  
69 CONSTRAINT_TIMEINT CGPL_CONSTRAINT_TIME BCOS_TSTMP DEC 15   0   Constraint Date  
70 CREATED_BYINT CGPL_CREATED_BY USNAM CHAR 12   0   Name of Person Who Created Object  
71 CREATED_ONINT CGPL_CREATED_ON DATUM DATS 8   0   Date on Which the Object was Created  
72 CREATED_IN_BWINT CGPL_CREATED_BW CHAR1 CHAR 1   0   Transfer Object to BW  
73 CHANGED_BYINT CGPL_CHANGED_BY USNAM CHAR 12   0   Name of Person Who Changed Object  
74 CHANGED_ONINT CGPL_CHANGED_ON DATUM DATS 8   0   Date on Which Object Was Last Changed  
75 UPDATED_IN_BWINT CGPL_UPDATED_BW CHAR1 CHAR 1   0   Current Object in BW  
76 BWIDENTIFIERINT CGPL_BWIDENTIFIER CGPL_BWIDENTIFIER NUMC 8   0   Project Planning - BW Identification  
77 PLANGROUPINT CGPL_SEM_PLGRP   CHAR 4   0   Planning Profile Group  
78 LATEST_STARTINT CGPL_LATEST_START BCOS_TSTMP DEC 15   0   Latest start  
79 LATEST_FINISHINT CGPL_LATEST_FINISH BCOS_TSTMP DEC 15   0   Latest finish date  
80 TOTAL_FLOATINT CGPL_TOTAL_FLOAT CGPL_FLOAT DEC 8   2   Total Float  
81 DURATIONINT CGPL_DURATION CGPL_DURATION DEC 8   2   Duration of Execution  
82 DURATION_UNITINT CGPL_DURATION_UNIT MEINS UNIT 3   0   Time Unit for Execution Duration *
83 CALENDAR_IDINT WFCID WFCID CHAR 2   0   Factory Calendar *
84 CONSTR_TYPE_FININT CGPL_CONSTRAINT CGPL_CONSTRAINT CHAR 1   0   Type of Scheduling Constraint  
85 CONSTR_TIME_FININT CGPL_CONSTRAINT_TIME BCOS_TSTMP DEC 15   0   Constraint Date  
86 APPLICATIONINT CGPL_APPLICATION_TYPE CGPL_APPLICATION_TYPE CHAR 3   0   Application in Project Planning *
87 FORECAST_STARTINT CGPL_FORECAST_START BCOS_TSTMP DEC 15   0   Forecast Start  
88 FORECAST_FINISHINT CGPL_FORECAST_FINISH BCOS_TSTMP DEC 15   0   Forecast Finish  
89 .INCLUDE       0   0   Include for Processing Status  
90 PROC_STATUS_OWNINT DPR_TV_PROC_STATUS_OWN DPR_PROC_STATUS CHAR 2   0   Object Processing Status  
91 PROC_STATUS_SUPINT DPR_TV_PROC_STATUS_SUP DPR_PROC_STATUS CHAR 2   0   Processing Status of Higher-Level Object  
92 .INCLUDE       0   0   Include for Checklist Item Attributes  
93 CL_ITEM_IDINT DPR_TV_CHECKLIST_ITEM_ID   CHAR 24   0   Checklist Item Number  
94 SORT_NUMBERINT DPR_TV_SORT_NUMBER   NUMC 5   0   Sort Number  
95 VERSION_NUMBERINT CGPL_TV_VERSION CGPL_VERSION CHAR 24   0   Version Number  
96 GROUPINGINT DPR_TV_GROUPING   CHAR 40   0   Grouping  
97 SEARCH_FIELDINT DPR_TV_SEARCH_FIELD   CHAR 40   0   Search Field  
98 MASTER_LANGUAGEINT DPR_TV_LANGU SPRAS LANG 1   0   Language Key *
99 TEMPLATE_GUIDINT DPR_TV_ENTITY_GUID DPR_ENTITY_GUID RAW 16   0   Application Object GUID (Entity with Conversion Exit) DPR_CHECKLIST_I
100 CHANGEABILITYINT DPR_TV_CHANGEABILITY_ITEM DPR_CHANGEABILITY_ITEM CHAR 1   0   Changeability of Checklist Items  
101 OKINT DPR_TV_CHECKLIST_ITEM_OK DPR_BOOLEAN CHAR 1   0   OK  
102 NOKINT DPR_TV_CHECKLIST_ITEM_NOK DPR_BOOLEAN CHAR 1   0   Not OK  
103 NOT_RELEVANTINT DPR_TV_NOT_RELEVANT DPR_BOOLEAN CHAR 1   0   Not Relevant  
104 OBLIGATORYINT DPR_TV_OBLIGATORY DPR_BOOLEAN CHAR 1   0   Mandatory  
105 APP_RELEVANTINT DPR_TV_APPROVAL_RELEVANT DPR_BOOLEAN CHAR 1   0   Relevant for Approval  
106 PROCESSINT DPR_TV_PROCESS DPR_PROCESS CHAR 15   0   Process DPR_PROCESS
107 SEVERITYINT DPR_TV_SEVERITY DPR_FMEA_RATING DEC 2   0   Severity  
108 OCCURENCEINT DPR_TV_OCCURENCE DPR_FMEA_RATING DEC 2   0   Occurrence  
109 DETECTIONINT DPR_TV_DETECTION DPR_FMEA_RATING DEC 2   0   Detection  
110 RPNINT DPR_TV_RPN DPR_RPN DEC 4   0   Risk Priority Number  
111 STAT_PROFILE_CLIINT DPR_TV_STAT_PROFILE_CLI J_STSMA CHAR 8   0   Status Profile Template *
112 SCHEDULE_INDINT PPM_SCHEDULE_INDICATOR PPM_SCHEDULE_INDICATOR CHAR 1   0   Status of Scheduling Data  
113 .INCLUDE       0   0   Include for Extended Attributes of Checklist Item  
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 DOCUMENTS DPR_TT_DOCUMENT_PRT   TTYP 0   0    
140 OBJECT_LINKS DPR_TT_OBJLINK_PRT   TTYP 0   0    
141 PARTICIPANT_LINKS DPR_TT_ENTITY_LINK_PRT   TTYP 0   0    
142 COLLABORATIONS DPR_TT_COLL_LINK_PRT   TTYP 0   0    
143 RESPONSIBLES DPR_TT_RESPONSIBLE_DAT   TTYP 0   0    
144 TASKS_FLAT DPR_TT_TASK_PRT_FLAT   TTYP 0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 DPR_TS_CHECKLIST_ITEM_PRT PRIORITY CGPL_PRIO PRIORITY KEY    
2 DPR_TS_CHECKLIST_ITEM_PRT PRIORITYINT CGPL_PRIO PRIORITY KEY    
3 DPR_TS_CHECKLIST_ITEM_PRT PROCESS DPR_PROCESS PROCESS    
4 DPR_TS_CHECKLIST_ITEM_PRT PROCESSINT DPR_PROCESS PROCESS    
5 DPR_TS_CHECKLIST_ITEM_PRT STAT_PROFILE_CLI TJ21 STSMA REF 1 CN
6 DPR_TS_CHECKLIST_ITEM_PRT TEMPLATE_GUIDINT DPR_CHECKLIST_I GUID REF 1 CN
History
Last changed by/on SAP  20141109 
SAP Release Created in 450