SAP ABAP Table RPM_TS_PROJLIST (Project List)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ RPM_INTEGRATION_PROJECT (Package) RPM Project Integration

Basic Data

Table Category	INTTAB	Structure
Structure	RPM_TS_PROJLIST	Table Relationship Diagram
Short Description	Project 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	PROJECTID	☐	PS_PSPID	PS_PSPID	CHAR	24	0	Project definition
2	DESCRIPTION	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
3	.INCLUDE	☐				0	0	RPM: Project data that can be changed externally
4	EXTERNAL_ID	☐	RPM_TV_PROJECT_ID		CHAR	24	0	Project ID
5	PROJ_DESCRIPTION	☐	RPM_TV_PROJ_DESCRIPTION	TEXT40	CHAR	40	0	Item Name
6	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
7	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
8	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
9	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
10	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
11	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
12	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
13	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
14	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
15	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
16	PROJECT_DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
17	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
18	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
19	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
20	.INCLUDE	☐				0	0	Project attributes
21	.INCLUDE	☐				0	0	Project attributes
22	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category	RPM_PROJ_CAT
23	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory	RPM_PROJ_SUBCAT
24	PHASE	☐	RPM_PROJECT_PHASE	RPM_PROJECT_PHASE	NUMC	4	0	Stage	RPM_PROJ_PHASE
25	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group	RPM_PROJ_TYPE
26	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type	RPM_PROJ_TTYPE
27	APSTAT	☐	RPM_PROJECT_APPST	RPM_PROJECT_APPST	NUMC	4	0	Project Approval Status	RPM_PROJ_APST
28	EXSTAT	☐	RPM_PROJECT_EXECSTAT	RPM_PROJECT_EXECSTAT	NUMC	4	0	Project Execution Status	RPM_PROJ_EXST
29	PPRIO	☐	RPM_PROJECT_PRIORITY	NUMC4	NUMC	4	0	Project Priority
30	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
31	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
32	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
33	HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
34	BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
35	COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
36	COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
37	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
38	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
39	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
40	CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	TCURC
41	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	DPR_LOCATION
42	GEOGRAPHY	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	DPR_AREA
43	ACTUAL_HEADCOUNT	☐	RPM_TV_HEADCOUNT		DEC	10	2	Actual Headcount
44	RPM_CHANGED_ON	☐	RPM_TV_TIMESTAMP	RPM_BCOS_TSTMP	DEC	15	0	Time Stamp
45	ACTUAL_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
46	PLANNED_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
47	WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
48	BASELINE_START	☐	RPM_TV_BASELINE_START		DATS	8	0	Baseline Start
49	BASELINE_FINISH	☐	RPM_TV_BASELINE_FINISH		DATS	8	0	Baseline Finish
50	COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
51	COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
52	ANNUAL_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
53	PERIODTYPE	☐	RPM_TV_AVLB_PERIOD	RPM_AVLB_PERIOD	NUMC	2	0	Period Type (Weekly/Monthly/Generic Interval)
54	UNIT	☐	RPM_TV_RESOURCE_AVAIL_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Project Resource Supply - Unit
55	VERSION	☐	RPM_TV_VERSION_TYPE	RPM_VERSION_TYPE	CHAR	1	0	Project Version Type
56	ITEM_TYPE	☐	/RPM/TV_ITEM_ID	/RPM/TD_ITEM_TYPE	CHAR	15	0	Type	*
57	PORTFL_ITEM_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
58	ESCALATION	☐	RPM_TV_ESCALATION	XFELD	CHAR	1	0	Escalation Flag
59	FORECAST_START	☐	RPM_TV_FORECAST_START	DATS	DATS	8	0	Forecasted Start
60	PLANNED_START	☐	RPM_TV_PLAN_START	DATS	DATS	8	0	Planned Start Date
61	ACTUAL_START	☐	RPM_TV_ACTUAL_START		DATS	8	0	Actual Start Date
62	FORECAST_FINISH	☐	RPM_TV_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
63	PLANNED_FINISH	☐	RPM_TV_PLAN_FINISH	DATS	DATS	8	0	Planned Finish Date
64	ACTUAL_FINISH	☐	RPM_TV_ACTUAL_FINISH		DATS	8	0	Actual Finish Date
65	PORTFOLIO_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
66	PARENT_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
67	ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
68	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group	*
69	CHANGED_BY	☐	UNAME	UNAME	CHAR	12	0	User Name
70	VERSION_ITEM	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
71	ITEM_CLASS	☐	/RPM/TV_ITEM_CLASS	/RPM/TD_ITEM_CLASS	CHAR	1	0	Item Classification
72	MASTER_ITEM_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
73	STATUS	☐	/RPM/TV_STATUS_COMMON	/RPM/TD_STATUS_COMMON	CHAR	5	0	Status	*
74	CAP_PERIODTYPE	☐	/RPM/TV_CAP_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Capacity Period Breakdown	*
75	ACT_DPCPT_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
76	DISCOUNT_RATE	☐	/RPM/TV_DISCOUNT_RATE	/RPM/DEC_5_2	DEC	5	2	Discount Rate
77	INITIATIVE_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
78	FRCST_BGT_TOTAL	☐	/RPM/TV_FORECASTED_BUDGT_TOTAL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Budget Total
79	FRCST_BGTANNUAL	☐	/RPM/TV_FORECASTED_BUDGT_ANNL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Budget Annual
80	FRCST_COSTTOTAL	☐	/RPM/TV_FORECASTED_COST_TOTAL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Cost Total
81	FRCST_COST_YTD	☐	/RPM/TV_FORECASTED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Cost YTD
82	TEMPLATE_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
83	IS_GLOBAL	☐	/RPM/TV_GLOBAL	XFELD	CHAR	1	0	Global Template
84	.INCLUDE	☐				0	0	Item Detail Customer Fields
85	EA_DUMMY	☐	/RPM/TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced xRPM Attributes
86	.INCLUDE	☐				0	0
87	.INCLUDE	☐				0	0	RPM: Proj atts derived from externally modifiable attributes
88	.INCLUDE	☐				0	0	Project atts derived from externally modifiable attributes
89	PRIORITY_PRCNT	☐	RPM_PRIORITY_LIMIT_HIGH	NUMC4	NUMC	4	0	Project Priority: Upper Limit
90	PRIORITY_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
91	BUDGET_PRCNT	☐	RPM_TV_BUDGET_LIMIT_HIGH	DECV03	DEC	3	0	Project Budget Status: Upper Limit
92	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group	*
93	BUDGET_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
94	SCHEDULE_PRCNT	☐	RPM_TV_SCHEDULE_LIMIT_HIGH	NUMC3	NUMC	3	0	Project Schedule Status: Upper Limit
95	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group	*
96	SCHEDULE_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
97	RISK_PRCNT	☐	RPM_RISK_LIMIT_HIGH	NUMC3	NUMC	3	0	Risk Group - Upper Limit
98	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
99	RISK_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
100	STAFFING_PRCNT	☐	RPM_TV_STAFFING_LIMIT_HIGH	NUMC3	NUMC	3	0	Project Staffing Status Group High Limit
101	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group	*
102	STAFFING_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
103	PHASE_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
104	PHASE_COLOR	☐	RPM_TV_STATUS_COLOR	RPM_HTML_COLOR	CHAR	7	0	Alert Object Color Status
105	PROPOSED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
106	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
107	VAR_COST	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
108	VAR_HEADCOUNT	☐	RPM_PROJ_VARIANCE_HEADCOUNT		DEC	10	2	Variance of Project Planned and Actual Headcount
109	VAR_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
110	VAR_STARTDATE	☐	RPM_PROJ_VAR_DAYS		DEC	8	0	Variance Start Date in Days
111	VAR_FINISHDATE	☐	RPM_PROJ_VAR_DAYS		DEC	8	0	Variance Start Date in Days
112	VAR_COST_TD	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
113	D_PLANSTART	☐	BEGDA	DATUM	DATS	8	0	Start Date
114	D_PLANFINISH	☐	ENDDA	DATUM	DATS	8	0	End Date
115	D_ACTUALSTART	☐	BEGDA	DATUM	DATS	8	0	Start Date
116	D_ACTUALFINISH	☐	ENDDA	DATUM	DATS	8	0	End Date
117	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
118	MASTER_PROJECT	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
119	LOC_GEOGRAPHY	☐	RPM_TV_PROJECT_GEOGRAPHY	RPM_PROJECT_GEOGRAPHY	CHAR	4	0	Project Geography	*
120	DEPENDENCY_COUNT	☐	RPM_TV_DEPENDENCY_COUNT	NUMC3	NUMC	3	0	Number of Project Dependencies.
121	DEPENDENCY_GROUP	☐	RPM_TV_DEPENDENCY_STATUS	RPM_DEPENDENCY_STATUS	NUMC	4	0	Dependency Status
122	DEPENDENCY_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
123	DEPEND_ICONNAME	☐	ICONNAME	ICONNAME	CHAR	30	0	Name of an Icon
124	DEPENDENCY_TEXT	☐	RPM_TV_DP_STATGRP_T	TEXT30	CHAR	30	0	Dependency:Status Indicator Text
125	DELETE_OK	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
126	BPS_LINKED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
127	FICO_LINKED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
128	.INCLUDE	☐				0	0	Master Project Summary Fields
129	SUM_HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
130	SUM_BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
131	SUM_COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
132	SUM_COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
133	SUM_COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
134	SUM_COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
135	SUM_NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
136	SUM_CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	*
137	SUM_A_HEADCOUNT	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
138	SUM_A_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
139	SUM_P_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
140	SUM_WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
141	SUM_COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
142	SUM_COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
143	SUM_A_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
144	SUM_V_COST	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
145	SUM_V_HEADCOUNT	☐	RPM_PROJ_VARIANCE_HEADCOUNT		DEC	10	2	Variance of Project Planned and Actual Headcount
146	SUM_V_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
147	SUM_V_COST_TD	☐	RPM_PROJ_VARIANCE_COST_TD	CURR16	CURR	16	2	YTD Variance of Project Planned Cost to Actual Cost
148	SUM_ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
149	AVG_PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
150	AVG_PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
151	.INCLUDE	☐				0	0
152	.INCLUDE	☐				0	0	Node neighbor IDs
153	PARENT_ID	☐	RPM_TV_PARENT_EXTID		CHAR	24	0	Parent ID
154	LEFT_ID	☐	RPM_TV_LEFT_EXTID		CHAR	24	0	Left ID
155	RIGHT_ID	☐	RPM_TV_RIGHT_EXTID		CHAR	24	0	Right ID
156	ITEM_DER	☐	/RPM/TS_ITEM_D_DERIVED_ATT		STRU	0	0
157	PRIORITY_ICON	☐	/RPM/TV_PRIORITY_ICON	ICON	CHAR	4	0	Priority	*
158	RISK_PRCNT	☐	RPM_RISK_LIMIT_HIGH	NUMC3	NUMC	3	0	Risk Group - Upper Limit
159	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
160	RISK_ICON	☐	/RPM/TV_RISK_ICON	ICON	CHAR	4	0	Risk	*
161	PHASE_ICON	☐	/RPM/TV_PHASE_ICON	ICON	CHAR	4	0	Phase	*
162	PHASE_COLOR	☐	RPM_TV_STATUS_COLOR	RPM_HTML_COLOR	CHAR	7	0	Alert Object Color Status
163	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
164	D_PLANSTART	☐	/RPM/TV_DP_PLAN_START	DATUM	DATS	8	0	Planned Start
165	D_PLANFINISH	☐	/RPM/TV_DP_PLAN_FINISH	DATUM	DATS	8	0	Planned Finish
166	D_ACTUALSTART	☐	/RPM/TV_DP_ACTUAL_START	DATUM	DATS	8	0	Actual Start
167	D_ACTUALFINISH	☐	/RPM/TV_DP_ACTUAL_FINISH	DATUM	DATS	8	0	Actual Finish Date
168	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
169	BEGDA_DEM	☐	/RPM/TV_PP_START_DEM	DATUM	DATS	8	0	Demand Planning Start
170	ENDDA_DEM	☐	/RPM/TV_PP_END_DEM	DATUM	DATS	8	0	Demand Planning Period Finish Date
171	BEGDA_FIN	☐	/RPM/TV_PP_START_FIN	DATUM	DATS	8	0	Financial Planning Period Start
172	ENDDA_FIN	☐	/RPM/TV_PP_END_FIN	DATUM	DATS	8	0	Financial Plan Period Finish Date
173	BUCKET_NAME	☐	/RPM/TV_BUCKET_NAME	TEXT40	CHAR	40	0	Bucket Name
174	BUCKET_ID	☐	/RPM/TV_BUCKET_ID		CHAR	24	0	Bucket ID
175	PROPOSAL	☐	/RPM/TV_PROPOSAL	XFELD	CHAR	1	0	Proposal
176	D_CHANGED_ON	☐	/RPM/TV_LAST_CHANGED_ON	DATUM	DATS	8	0	Changed On Date
177	MASTER_ITEM_NAME	☐	/RPM/TV_MASTER_ITEM_NAME	TEXT40	CHAR	40	0	Initiative Name
178	MASTER_ITEM_ID	☐	/RPM/TV_MASTER_ITEM_ID		CHAR	24	0	Initiative ID
179	HAS_CHILDREN	☐	/RPM/TV_ITEM_CHILDREN	XFELD	CHAR	1	0	Has Children
180	BUDGET_ICON	☐	/RPM/TV_BUDGET_ICON	ICON	CHAR	4	0	Budget	*
181	SCHEDULE_ICON	☐	/RPM/TV_SCHEDULE_ICON	ICON	CHAR	4	0	Schedule	*
182	STAFFING_ICON	☐	/RPM/TV_STAFFING_ICON	ICON	CHAR	4	0	Staffing	*
183	BUDGET_TOTAL	☐	/RPM/TV_BUDGET_TOTAL	/RPM/CURR_16_2	CURR	16	2	Total Budget
184	BUDGET_ANNUAL	☐	/RPM/TV_BUDGET_ANNUAL	/RPM/CURR_16_2	CURR	16	2	Annual Budget
185	PLANNED_COST	☐	/RPM/TV_PLANNED_COST	/RPM/CURR_16_2	CURR	16	2	Planned Costs
186	PLANNED_COST_YTD	☐	/RPM/TV_PLANNED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Costs Year to Date
187	ACTUAL_COST	☐	/RPM/TV_ACTUAL_COST	/RPM/CURR_16_2	CURR	16	2	Actual Costs
188	ACTUAL_COST_YTD	☐	/RPM/TV_ACTUAL_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Cost Year to Day
189	ACT_DECPT_NAME	☐	/RPM/TV_PHASE_T	TEXT80	CHAR	80	0	Decision Point Name
190	ACT_DECPT_STAT_TEXT	☐	/RPM/TV_STATUS_TEXT	CHAR40	CHAR	40	0	Active Decision Point Status Text
191	ACT_DECPT_STAT_ICON	☐	/RPM/TV_DECPT_STATUS_ICON	ICON	CHAR	4	0	Active Decision Point Status	*
192	DECPT_INFO	☐	/RPM/TV_DECPT_INFO	CHAR20	CHAR	20	0	Decision Point Info
193	STATUS_GROUP	☐	/RPM/TV_ITEM_STATUS_GROUP	/RPM/ITEM_STATUS_GROUP	CHAR	4	0	Status Group
194	FORECASTED_DURATION	☐	/RPM/TV_FORCASTED_DURATION		QUAN	4	0	Forecasted Duration
195	PLANNED_DURATION	☐	/RPM/TV_PLANNED_DURATION		QUAN	4	0	Planned Duration
196	ACTUAL_DURATION	☐	/RPM/TV_ACTUAL_DURATION		QUAN	4	0	Actual Duration
197	ACT_PHASE_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
198	WORKEFFORT_TOTAL	☐	/RPM/TV_WORK_EFFORT_TOTAL	/RPM/DEC_26_2	DEC	26	2	Actual Effort
199	WORKEFFORT_YTD	☐	/RPM/TV_WORK_EFFORT_YTD	/RPM/DEC_26_2	DEC	26	2	Actual Work Effort Year-To-Date
200	PLANNED_EFFORT	☐	/RPM/TV_PLAN_EFFORT	/RPM/DEC_26_2	DEC	26	2	Planned Effort
201	PLANNED_EFFORT_YTD	☐	/RPM/TV_PLAN_EFFORT_YTD	/RPM/DEC_26_2	DEC	26	2	Planned Effort Year-To-Date
202	ROI	☐	/RPM/TV_ROI	/RPM/CURR_16_2	CURR	16	2	Return on Investment in % (manual)
203	IRR	☐	/RPM/TV_IRR	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in % (manual)
204	RISK_GROUP_D	☐	/RPM/RISK_GROUP_D	RPM_RISK_GROUP	NUMC	2	0	Risk Group Derived	*
205	RISK_D_ICON	☐	/RPM/TV_RISK_ICON_D	ICON	CHAR	4	0	Derived Risk	*
206	PLANNED_DECISION_DATE	☐	/RPM/TV_PLAND_DDATE	DATUM	DATS	8	0	Planned Decision date
207	ACTUAL_DECISION_DATE	☐	/RPM/TV_ACTUAL_DDATE	DATUM	DATS	8	0	Actual Decision Date
208	FORECAST_DEC_DATE	☐	/RPM/TV_FORECAST_DDATE	DATUM	DATS	8	0	Forecasted Decision Date
209	D_FORECASTED_START	☐	RPM_TV_DP_FORECAST_START	DATS	DATS	8	0	Forecasted Start
210	D_FORECASTED_FINISH	☐	RPM_TV_DP_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
211	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group	*
212	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group	*
213	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group	*
214	PORTFOLIO_NAME	☐	/RPM/TV_PORTFOLIO_NAME	TEXT40	CHAR	40	0	Portfolio Name
215	PORTFOLIO_ID	☐	/RPM/TV_PORTFOLIO_ID		CHAR	24	0	Portfolio ID
216	PLANNED_REVENUE	☐	/RPM/TV_PLANNED_REVENUE	/RPM/CURR_16_2	CURR	16	2	Planned Revenues
217	PLANNED_REV_YTD	☐	/RPM/TV_PLANNED_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Revenues Year to Date
218	ACTUAL_REVENUE	☐	/RPM/TV_ACTUAL_REVENUE	/RPM/CURR_16_2	CURR	16	2	Actual Revenues
219	ACTUAL_REV_YTD	☐	/RPM/TV_ACTUAL_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Revenues Year to Day
220	.INCLUDE	☐				0	0	Financial KPIs
221	NPV_PLAN	☐	/RPM/TV_NPV_PLAN	/RPM/CURR_16_2	CURR	16	2	Net Present Value
222	IRR_PLAN	☐	/RPM/TV_IRR_PLAN	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in %
223	ROI_PLAN	☐	/RPM/TV_ROI_PLAN	/RPM/CURR_16_2	CURR	16	2	Return on Investment in %
224	PAYBACK_PLAN	☐	/RPM/TV_PAYBACK_PLAN	/RPM/TD_PBP_PLAN	NUMC	6	0	Payback Periods in Months
225	ECV_PLAN	☐	/RPM/TV_ECV_PLAN	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value
226	.INCLUDE	☐				0	0	Customer fields for KPI derived attributes
227	EA_DUMMY_KPI	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
228	.INCLUDE	☐				0	0
229	RPM_PROJECT_STKHLDR	☐	RPM_TT_PROJ_STKHLD_WITH_BUPA		TTYP	0	0
230	RPM_PROJECT_STKHLDR_DER	☐	RPM_TT_PROJ_STKHLD_DERIVED		TTYP	0	0
231	PROJECT_SHORT_TEXT	☐	RPM_TT_SHORT_TEXT		TTYP	0	0
232	DEPENDENCIES	☐	RPM_TT_PROJ_DEPENDENCY		TTYP	0	0
233	PROJECTMGR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
234	RESOURCEMGR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
235	CELLTAB	☐	LVC_T_STYL		TTYP	0	0
236	DRDN_CAT	☐	INT4	INT4	INT4	10	0	Natural number
237	DRDN_SUBCAT	☐	INT4	INT4	INT4	10	0	Natural number
238	CHANGE_ROLE	☐	RPM_FLAG	RPM_FLAG	CHAR	1	0	Flag
239	CHANGE_RESOURCE	☐	RPM_FLAG	RPM_FLAG	CHAR	1	0	Flag
240	CHANGE_TEAM	☐	RPM_FLAG	RPM_FLAG	CHAR	1	0	Flag
241	CHANGE_TASK	☐	RPM_FLAG	RPM_FLAG	CHAR	1	0	Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RPM_TS_PROJLIST	APSTAT	RPM_PROJ_APST	APPST	REF	1	CN
2	RPM_TS_PROJLIST	CATEGORY	RPM_PROJ_CAT	CATEGORY	KEY	1	CN
3	RPM_TS_PROJLIST	CURRENCY	TCURC	WAERS	REF	1	CN
4	RPM_TS_PROJLIST	EXSTAT	RPM_PROJ_EXST	EXCST	REF	1	CN
5	RPM_TS_PROJLIST	GEOGRAPHY	DPR_AREA	AREA	REF	1	CN
6	RPM_TS_PROJLIST	LOCATION	DPR_LOCATION	LOCATION	REF	1	CN
7	RPM_TS_PROJLIST	PHASE	RPM_PROJ_PHASE	PHASE	REF	1	CN
8	RPM_TS_PROJLIST	PTYPE	RPM_PROJ_TYPE	PTYPE	KEY	1	CN
9	RPM_TS_PROJLIST	SUBCATEGORY	RPM_PROJ_SUBCAT	SUBCATEGORY	REF	1	CN
10	RPM_TS_PROJLIST	TTYPE	RPM_PROJ_TTYPE	TTYPE	REF	1	CN

History

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