SAP ABAP Table DPR_TS_CTRLPLAN_V_DAT (Control Plan Version Data)
Hierarchy
CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   PPM-PRO-CPL (Application Component) Control Plan
     DEVELOPMENT_PROJECTS_CTRL_PLAN (Package) Project Management - Control Plans
Basic Data
Table Category INTTAB    Structure 
Structure DPR_TS_CTRLPLAN_V_DAT   Table Relationship Diagram
Short Description Control Plan Version 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   Control Plan: Version Attributes (External)  
3 .INCLUDE       0   0   Control Plan Version Attributes (Not Modifiable Externally)  
4 GUID DPR_TV_GUID DPR_GUID RAW 16   0   Application Object GUID  
5 EXTERNAL_ID CGPL_EXTID CGPL_EXTID CHAR 24   0   Project Planning: External Indentifier of an Element  
6 LAST_CHANGE_DATE DPR_TV_LAST_CHANGE_DATE   DATS 8   0   Date of Last Change  
7 LAST_CHANGE_TIME DPR_TV_LAST_CHANGE_TIME   TIMS 6   0   Last Changed at  
8 .INCLUDE       0   0   Project Planning: Projects and Activities Include Structure  
9 PROJECT_GUID CGPL_PROJECT_GUID CGPL_PROJECT_GUID RAW 16   0   Project Planning: 16 Character GUID for Projects  
10 OBJECT_TYPE CGPL_OBJECT_TYPE CHAR3 CHAR 3   0   Object Type in Project Planning  
11 PRIORITY CGPL_PRIORITY NUMC3 NUMC 3   0   Priority CGPL_PRIO
12 ACTUALSTART CGPL_ACTUALSTART BCOS_TSTMP DEC 15   0   Actual Start Date  
13 ACTUALFINISH CGPL_ACTUALFINISH BCOS_TSTMP DEC 15   0   Actual Finish Date  
14 PLANSTART CGPL_PLANSTART BCOS_TSTMP DEC 15   0   Planned start date  
15 PLANFINISH CGPL_PLANFINISH BCOS_TSTMP DEC 15   0   Planned Finish Date  
16 COMPLETION CGPL_COMPLETION CGPL_COMPLETION NUMC 3   0   Percentage of Completion  
17 MILESTONE CGPL_MILESTONE CHAR1 CHAR 1   0   Milestone indicator  
18 CONSTRAINT_TYPE CGPL_CONSTRAINT CGPL_CONSTRAINT CHAR 1   0   Type of Scheduling Constraint  
19 CONSTRAINT_TIME CGPL_CONSTRAINT_TIME BCOS_TSTMP DEC 15   0   Constraint Date  
20 CREATED_BY CGPL_CREATED_BY USNAM CHAR 12   0   Name of Person Who Created Object  
21 CREATED_ON CGPL_CREATED_ON DATUM DATS 8   0   Date on Which the Object was Created  
22 CREATED_IN_BW CGPL_CREATED_BW CHAR1 CHAR 1   0   Transfer Object to BW  
23 CHANGED_BY CGPL_CHANGED_BY USNAM CHAR 12   0   Name of Person Who Changed Object  
24 CHANGED_ON CGPL_CHANGED_ON DATUM DATS 8   0   Date on Which Object Was Last Changed  
25 UPDATED_IN_BW CGPL_UPDATED_BW CHAR1 CHAR 1   0   Current Object in BW  
26 BWIDENTIFIER CGPL_BWIDENTIFIER CGPL_BWIDENTIFIER NUMC 8   0   Project Planning - BW Identification  
27 PLANGROUP CGPL_SEM_PLGRP   CHAR 4   0   Planning Profile Group  
28 LATEST_START CGPL_LATEST_START BCOS_TSTMP DEC 15   0   Latest start  
29 LATEST_FINISH CGPL_LATEST_FINISH BCOS_TSTMP DEC 15   0   Latest finish date  
30 TOTAL_FLOAT CGPL_TOTAL_FLOAT CGPL_FLOAT DEC 8   2   Total Float  
31 DURATION CGPL_DURATION CGPL_DURATION DEC 8   2   Duration of Execution  
32 DURATION_UNIT CGPL_DURATION_UNIT MEINS UNIT 3   0   Time Unit for Execution Duration *
33 CALENDAR_ID WFCID WFCID CHAR 2   0   Factory Calendar *
34 CONSTR_TYPE_FIN CGPL_CONSTRAINT CGPL_CONSTRAINT CHAR 1   0   Type of Scheduling Constraint  
35 CONSTR_TIME_FIN CGPL_CONSTRAINT_TIME BCOS_TSTMP DEC 15   0   Constraint Date  
36 APPLICATION CGPL_APPLICATION_TYPE CGPL_APPLICATION_TYPE CHAR 3   0   Application in Project Planning *
37 FORECAST_START CGPL_FORECAST_START BCOS_TSTMP DEC 15   0   Forecast Start  
38 FORECAST_FINISH CGPL_FORECAST_FINISH BCOS_TSTMP DEC 15   0   Forecast Finish  
39 .INCLUDE       0   0   Include for Processing Status  
40 PROC_STATUS_OWN DPR_TV_PROC_STATUS_OWN DPR_PROC_STATUS CHAR 2   0   Object Processing Status  
41 PROC_STATUS_SUP DPR_TV_PROC_STATUS_SUP DPR_PROC_STATUS CHAR 2   0   Processing Status of Higher-Level Object  
42 .INCLUDE       0   0   Development Projects: Status (External)  
43 OBJNR CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
44 ISTAT J_ISTAT J_ISTAT CHAR 5   0   System status *
45 ESTAT J_ESTAT J_ESTAT CHAR 5   0   User Status *
46 STSMA J_STSMA J_STSMA CHAR 8   0   Status Profile *
47 SPRAS SPRAS SPRAS LANG 1   0   Language Key *
48 TXT04 J_TXT04 TEXT4 CHAR 4   0   Individual status of an object (short form)  
49 TXT30 J_TXT30 TEXT30 CHAR 30   0   Object status  
50 STATTXT DPR_TV_STATUS_TXT   STRG 0   0   Concatenated Status Text of an Object  
51 GUID_CHAR DPR_TV_OBJECT_GUID_CHAR SYSUUID_C CHAR 32   0   Unique Object Key  
52 CREATED_BY_NAME DPR_TV_CREATED_BY_NAME TEXT80 CHAR 80   0   Name of Person Who Created the Project Element  
53 CHANGED_BY_NAME DPR_TV_CHANGED_BY_NAME TEXT80 CHAR 80   0   Name of Person Who Last Changed the Project Element  
54 .INCLUDE       0   0   Control Plan: Version Attributes (Externally Modifiable)  
55 .INCLUDE       0   0   Control Plan: Structure Versions  
56 VERSION DPR_TV_CP_VERSION DPR_CP_VERSION CHAR 10   0   Control Plan Version  
57 VERSION_NUMBER CGPL_TV_VERSION CGPL_VERSION CHAR 24   0   Version Number  
58 CATEGORY DPR_TV_CP_STAGE DPR_STAGE CHAR 15   0   Control Plan Stage/Category  
59 PART_ID DPR_TV_CP_PART_ID DPR_CP_PART_ID CHAR 40   0   Part Number/Last Change Status  
60 PART_TEXT DPR_TV_CP_PART_TEXT DPR_CP_PART_TEXT CHAR 40   0   Name and Description of Product/Process to Be Monitored  
61 SUPPLIER_TEXT DPR_TV_CP_SUPPLIER_TEXT DPR_CP_SUPPLIER_TEXT CHAR 40   0   Vendor Location  
62 SUPPLIER_ID DPR_TV_CP_SUPPLIER_ID DPR_CP_SUPPLIER_ID CHAR 20   0   Identification Key of Vendor in Control Plan  
63 KEY_CONTACT DPR_TV_CP_KEY_CONTACT DPR_CP_KEY_CONTACT CHAR 40   0   Control Plan: Contact Person/Telephone  
64 CORE_TEAM DPR_TV_CP_CORE_TEAM DPR_CP_CORE_TEAM CHAR 40   0   Core Team in Control Plan  
65 SUPPLIER_INFO DPR_TV_CP_SUPPLIER_INFO DPR_CP_SUPPLIER_INFO CHAR 40   0   Release of Date and Person Responsible  
66 APPROVED_ON_1 DPR_TV_CP_APPROVED_DT DATS DATS 8   0   Date for Further Release in the Control Plan (if Required)  
67 RELEASED_ON DPR_TV_CP_RELEASED_DT DATS DATS 8   0   Date of First Release in Control Plan  
68 REL_BY_CUST_1 DPR_TV_CP_CUSTOMER_DT DATS DATS 8   0   Date of Release by Customer Development/Quality  
69 REL_BY_CUST_2 DPR_TV_CP_CUSTOMER_DT DATS DATS 8   0   Date of Release by Customer Development/Quality  
70 APPROVED_ON_2 DPR_TV_CP_APPROVED_DT DATS DATS 8   0   Date for Further Release in the Control Plan (if Required)  
71 STAT_PROFILE_CP DPR_TV_STAT_PROFILE_CP J_STSMA CHAR 8   0   Status Profile Template *
72 OBJ_GENERATED DPR_TV_CP_OBJECTS_GENERATED CHAR1 CHAR 1   0   Objects in Control Plan Were Generated (BAdI)  
73 .INCLUDE       0   0   Include for Extended Attributes for Control Plan Version  
74 EA_DUMMY DPR_TV_EA_DUMMY CHAR1 CHAR 1   0   Dummy Data Element for Enhanced Proj. Mgmt Attributes  
75 .INCLUDE       0   0    
76 DESCRIPTION CGPL_TEXT1 TEXT40 CHAR 40   0   Language-Dependent Short Text  
77 .INCLU-INT       0   0   Attributes for Version Definition in Control Plan (Internal)  
78 GUIDINT DPR_TV_GUID DPR_GUID RAW 16   0   Application Object GUID  
79 EXTERNAL_IDINT CGPL_EXTID CGPL_EXTID CHAR 24   0   Project Planning: External Indentifier of an Element  
80 .INCLUDE       0   0   Project Planning: Projects and Activities Include Structure  
81 PROJECT_GUIDINT CGPL_PROJECT_GUID CGPL_PROJECT_GUID RAW 16   0   Project Planning: 16 Character GUID for Projects  
82 OBJECT_TYPEINT CGPL_OBJECT_TYPE CHAR3 CHAR 3   0   Object Type in Project Planning  
83 PRIORITYINT CGPL_PRIORITY NUMC3 NUMC 3   0   Priority CGPL_PRIO
84 ACTUALSTARTINT CGPL_ACTUALSTART BCOS_TSTMP DEC 15   0   Actual Start Date  
85 ACTUALFINISHINT CGPL_ACTUALFINISH BCOS_TSTMP DEC 15   0   Actual Finish Date  
86 PLANSTARTINT CGPL_PLANSTART BCOS_TSTMP DEC 15   0   Planned start date  
87 PLANFINISHINT CGPL_PLANFINISH BCOS_TSTMP DEC 15   0   Planned Finish Date  
88 COMPLETIONINT CGPL_COMPLETION CGPL_COMPLETION NUMC 3   0   Percentage of Completion  
89 MILESTONEINT CGPL_MILESTONE CHAR1 CHAR 1   0   Milestone indicator  
90 CONSTRAINT_TYPEINT CGPL_CONSTRAINT CGPL_CONSTRAINT CHAR 1   0   Type of Scheduling Constraint  
91 CONSTRAINT_TIMEINT CGPL_CONSTRAINT_TIME BCOS_TSTMP DEC 15   0   Constraint Date  
92 CREATED_BYINT CGPL_CREATED_BY USNAM CHAR 12   0   Name of Person Who Created Object  
93 CREATED_ONINT CGPL_CREATED_ON DATUM DATS 8   0   Date on Which the Object was Created  
94 CREATED_IN_BWINT CGPL_CREATED_BW CHAR1 CHAR 1   0   Transfer Object to BW  
95 CHANGED_BYINT CGPL_CHANGED_BY USNAM CHAR 12   0   Name of Person Who Changed Object  
96 CHANGED_ONINT CGPL_CHANGED_ON DATUM DATS 8   0   Date on Which Object Was Last Changed  
97 UPDATED_IN_BWINT CGPL_UPDATED_BW CHAR1 CHAR 1   0   Current Object in BW  
98 BWIDENTIFIERINT CGPL_BWIDENTIFIER CGPL_BWIDENTIFIER NUMC 8   0   Project Planning - BW Identification  
99 PLANGROUPINT CGPL_SEM_PLGRP   CHAR 4   0   Planning Profile Group  
100 LATEST_STARTINT CGPL_LATEST_START BCOS_TSTMP DEC 15   0   Latest start  
101 LATEST_FINISHINT CGPL_LATEST_FINISH BCOS_TSTMP DEC 15   0   Latest finish date  
102 TOTAL_FLOATINT CGPL_TOTAL_FLOAT CGPL_FLOAT DEC 8   2   Total Float  
103 DURATIONINT CGPL_DURATION CGPL_DURATION DEC 8   2   Duration of Execution  
104 DURATION_UNITINT CGPL_DURATION_UNIT MEINS UNIT 3   0   Time Unit for Execution Duration *
105 CALENDAR_IDINT WFCID WFCID CHAR 2   0   Factory Calendar *
106 CONSTR_TYPE_FININT CGPL_CONSTRAINT CGPL_CONSTRAINT CHAR 1   0   Type of Scheduling Constraint  
107 CONSTR_TIME_FININT CGPL_CONSTRAINT_TIME BCOS_TSTMP DEC 15   0   Constraint Date  
108 APPLICATIONINT CGPL_APPLICATION_TYPE CGPL_APPLICATION_TYPE CHAR 3   0   Application in Project Planning *
109 FORECAST_STARTINT CGPL_FORECAST_START BCOS_TSTMP DEC 15   0   Forecast Start  
110 FORECAST_FINISHINT CGPL_FORECAST_FINISH BCOS_TSTMP DEC 15   0   Forecast Finish  
111 .INCLUDE       0   0   Include for Processing Status  
112 PROC_STATUS_OWNINT DPR_TV_PROC_STATUS_OWN DPR_PROC_STATUS CHAR 2   0   Object Processing Status  
113 PROC_STATUS_SUPINT DPR_TV_PROC_STATUS_SUP DPR_PROC_STATUS CHAR 2   0   Processing Status of Higher-Level Object  
114 .INCLUDE       0   0   Control Plan: Structure Versions  
115 VERSIONINT DPR_TV_CP_VERSION DPR_CP_VERSION CHAR 10   0   Control Plan Version  
116 VERSION_NUMBERINT CGPL_TV_VERSION CGPL_VERSION CHAR 24   0   Version Number  
117 CATEGORYINT DPR_TV_CP_STAGE DPR_STAGE CHAR 15   0   Control Plan Stage/Category  
118 PART_IDINT DPR_TV_CP_PART_ID DPR_CP_PART_ID CHAR 40   0   Part Number/Last Change Status  
119 PART_TEXTINT DPR_TV_CP_PART_TEXT DPR_CP_PART_TEXT CHAR 40   0   Name and Description of Product/Process to Be Monitored  
120 SUPPLIER_TEXTINT DPR_TV_CP_SUPPLIER_TEXT DPR_CP_SUPPLIER_TEXT CHAR 40   0   Vendor Location  
121 SUPPLIER_IDINT DPR_TV_CP_SUPPLIER_ID DPR_CP_SUPPLIER_ID CHAR 20   0   Identification Key of Vendor in Control Plan  
122 KEY_CONTACTINT DPR_TV_CP_KEY_CONTACT DPR_CP_KEY_CONTACT CHAR 40   0   Control Plan: Contact Person/Telephone  
123 CORE_TEAMINT DPR_TV_CP_CORE_TEAM DPR_CP_CORE_TEAM CHAR 40   0   Core Team in Control Plan  
124 SUPPLIER_INFOINT DPR_TV_CP_SUPPLIER_INFO DPR_CP_SUPPLIER_INFO CHAR 40   0   Release of Date and Person Responsible  
125 APPROVED_ON_1INT DPR_TV_CP_APPROVED_DT DATS DATS 8   0   Date for Further Release in the Control Plan (if Required)  
126 RELEASED_ONINT DPR_TV_CP_RELEASED_DT DATS DATS 8   0   Date of First Release in Control Plan  
127 REL_BY_CUST_1INT DPR_TV_CP_CUSTOMER_DT DATS DATS 8   0   Date of Release by Customer Development/Quality  
128 REL_BY_CUST_2INT DPR_TV_CP_CUSTOMER_DT DATS DATS 8   0   Date of Release by Customer Development/Quality  
129 APPROVED_ON_2INT DPR_TV_CP_APPROVED_DT DATS DATS 8   0   Date for Further Release in the Control Plan (if Required)  
130 STAT_PROFILE_CPINT DPR_TV_STAT_PROFILE_CP J_STSMA CHAR 8   0   Status Profile Template *
131 OBJ_GENERATEDINT DPR_TV_CP_OBJECTS_GENERATED CHAR1 CHAR 1   0   Objects in Control Plan Were Generated (BAdI)  
132 .INCLUDE       0   0   Include for Extended Attributes for Control Plan Version  
133 EA_DUMMYINT DPR_TV_EA_DUMMY CHAR1 CHAR 1   0   Dummy Data Element for Enhanced Proj. Mgmt Attributes  
134 .INCLUDE       0   0    
135 .INCLUDE       0   0   Texts from Customizing for Control Plan Element  
136 STAGE_TEXT DPR_TV_TEXT DPR_TEXT CHAR 40   0   Object Name  
137 TOOL_TEXT DPR_TV_TEXT DPR_TEXT CHAR 40   0   Object Name  
138 PROCESS_TEXT DPR_TV_TEXT DPR_TEXT CHAR 40   0   Object Name  
139 CHA_PROCESS_TEXT DPR_TV_TEXT DPR_TEXT CHAR 40   0   Object Name  
140 CHA_PRODUCT_TEXT DPR_TV_TEXT DPR_TEXT CHAR 40   0   Object Name  
141 EVALUATION_TEXT DPR_TV_TEXT DPR_TEXT CHAR 40   0   Object Name  
142 FREQUENCE_TEXT DPR_TV_TEXT DPR_TEXT CHAR 40   0   Object Name  
143 STATUS DPR_TT_STATUS_EXT   TTYP 0   0    
144 TEXTS DPR_TT_TEXT_EXT   TTYP 0   0    
145 ITEMS DPR_TT_CTRLPLAN_I_DAT   TTYP 0   0    
146 OBJECT_LINKS DPR_TT_OBJLINK_DAT   TTYP 0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 DPR_TS_CTRLPLAN_V_DAT PRIORITY CGPL_PRIO PRIORITY KEY    
2 DPR_TS_CTRLPLAN_V_DAT PRIORITYINT CGPL_PRIO PRIORITY KEY    
History
Last changed by/on SAP  20141109 
SAP Release Created in 200