SAP ABAP Table /RPM/TS_WHATIFITEM_DASH_EXT (Structure Type Dashboard (External Display))

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ /RPM/UI_LOGIC (Package) RPM UI Logic for ABAP WD

Basic Data

Table Category	INTTAB	Structure
Structure	/RPM/TS_WHATIFITEM_DASH_EXT	Table Relationship Diagram
Short Description	Structure Type Dashboard (External Display)

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	.INCLUDE	☐				0	0	Common Dashboard Attributes
2	.INCLUDE	☐				0	0	Technical Fields of Dashboard
3	OBJECT_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
4	ROOT_OBJECT_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
5	PARENT_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
6	TEMPLATE_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
7	OBJECT_TYPE	☐	/RPM/OBJECT_TYPE	/RPM/OBJECT_TYPE	CHAR	15	0	Object Type	*
8	PARENT_TYPE	☐	/RPM/OBJECT_TYPE	/RPM/OBJECT_TYPE	CHAR	15	0	Object Type	*
9	.INCLUDE	☐				0	0	External IDs of Dashboards
10	OBJECT_GUID_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
11	ROOT_OBJECT_GUID_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
12	PARENT_GUID_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
13	OBJECT_GUID_TXT	☐	/RPM/TV_SHARED_DESCRIPTION	TEXT40	CHAR	40	0	Name
14	.INCLUDE	☐				0	0	Text Fields
15	FIELD_TEXT_1	☐			CHAR	255	0
16	FIELD_TEXT_2	☐			CHAR	255	0
17	FIELD_TEXT_3	☐			CHAR	255	0
18	FIELD_TEXT_4	☐			CHAR	255	0
19	FIELD_TEXT_5	☐			CHAR	255	0
20	FIELD_TEXT_6	☐			CHAR	255	0
21	FIELD_TEXT_7	☐			CHAR	255	0
22	FIELD_TEXT_8	☐			CHAR	255	0
23	FIELD_TEXT_9	☐			CHAR	255	0
24	FIELD_TEXT_10	☐			CHAR	255	0
25	FIELD_TEXT_11	☐			CHAR	255	0
26	FIELD_TEXT_12	☐			CHAR	255	0
27	FIELD_TEXT_13	☐			CHAR	255	0
28	FIELD_TEXT_14	☐			CHAR	255	0
29	FIELD_TEXT_15	☐			CHAR	255	0
30	FIELD_TEXT_16	☐			CHAR	255	0
31	FIELD_TEXT_17	☐			CHAR	255	0
32	FIELD_TEXT_18	☐			CHAR	255	0
33	FIELD_TEXT_19	☐			CHAR	255	0
34	FIELD_TEXT_20	☐			CHAR	255	0
35	.INCLUDE	☐				0	0	GIFs replacing content of fields of the Attribute Structure
36	INDICATOR_1	☐			STRG	0	0
37	INDICATOR_2	☐			STRG	0	0
38	INDICATOR_3	☐			STRG	0	0
39	INDICATOR_4	☐			STRG	0	0
40	INDICATOR_5	☐			STRG	0	0
41	INDICATOR_6	☐			STRG	0	0
42	INDICATOR_7	☐			STRG	0	0
43	INDICATOR_8	☐			STRG	0	0
44	INDICATOR_9	☐			STRG	0	0
45	INDICATOR_10	☐			STRG	0	0
46	INDICATOR_11	☐			STRG	0	0
47	INDICATOR_12	☐			STRG	0	0
48	INDICATOR_13	☐			STRG	0	0
49	INDICATOR_14	☐			STRG	0	0
50	INDICATOR_15	☐			STRG	0	0
51	INDICATOR_16	☐			STRG	0	0
52	INDICATOR_17	☐			STRG	0	0
53	INDICATOR_18	☐			STRG	0	0
54	INDICATOR_19	☐			STRG	0	0
55	INDICATOR_20	☐			STRG	0	0
56	.INCLUDE	☐				0	0	Tooltips for the icon fields on a dashboard
57	TOOLTIP_1	☐			STRG	0	0
58	TOOLTIP_2	☐			STRG	0	0
59	TOOLTIP_3	☐			STRG	0	0
60	TOOLTIP_4	☐			STRG	0	0
61	TOOLTIP_5	☐			STRG	0	0
62	TOOLTIP_6	☐			STRG	0	0
63	TOOLTIP_7	☐			STRG	0	0
64	TOOLTIP_8	☐			STRG	0	0
65	TOOLTIP_9	☐			STRG	0	0
66	TOOLTIP_10	☐			STRG	0	0
67	TOOLTIP_11	☐			STRG	0	0
68	TOOLTIP_12	☐			STRG	0	0
69	TOOLTIP_13	☐			STRG	0	0
70	TOOLTIP_14	☐			STRG	0	0
71	TOOLTIP_15	☐			STRG	0	0
72	TOOLTIP_16	☐			STRG	0	0
73	TOOLTIP_17	☐			STRG	0	0
74	TOOLTIP_18	☐			STRG	0	0
75	TOOLTIP_19	☐			STRG	0	0
76	TOOLTIP_20	☐			STRG	0	0
77	.INCLUDE	☐				0	0	Data Fields of Dashboard
78	.INCLUDE	☐				0	0	Data Fields of Dashboard
79	PROJ_DESCRIPTION	☐	RPM_TV_PROJ_DESCRIPTION	TEXT40	CHAR	40	0	Item Name
80	EXTERNAL_ID	☐	/RPM/TV_EXTID		CHAR	24	0	Business Object ID
81	ITEM_TYPE	☐	/RPM/TV_ITEM_ID	/RPM/TD_ITEM_TYPE	CHAR	15	0	Type	*
82	FORECAST_START	☐	RPM_TV_FORECAST_START	DATS	DATS	8	0	Forecasted Start
83	FORECAST_FINISH	☐	RPM_TV_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
84	PLANNED_START	☐	RPM_TV_PLAN_START	DATS	DATS	8	0	Planned Start Date
85	PLANNED_FINISH	☐	RPM_TV_PLAN_FINISH	DATS	DATS	8	0	Planned Finish Date
86	ACTUAL_FINISH	☐	DPR_TV_ACTUAL_FINISH		DATS	8	0	Actual Finish
87	ACTUAL_START	☐	DPR_TV_ACTUAL_START		DATS	8	0	Actual Start
88	STATUS	☐	/RPM/TV_STATUS_COMMON	/RPM/TD_STATUS_COMMON	CHAR	5	0	Status	*
89	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group	*
90	ITEM_CLASS	☐	/RPM/TV_ITEM_CLASS	/RPM/TD_ITEM_CLASS	CHAR	1	0	Item Classification
91	VERSION_ITEM	☐	/RPM/TV_VERSION_ITEM	XFELD	CHAR	1	0	Version Item Indicator
92	STAFFING	☐	DPR_TV_STAFFING_INDICATOR		NUMC	3	0	Key Figure: Staffing Status
93	CHANGED_BY	☐	/RPM/TV_CHANGED_BY	XUBNAME	CHAR	12	0	Changed by user	*
94	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category	*
95	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory	*
96	PHASE	☐	RPM_PROJECT_PHASE	RPM_PROJECT_PHASE	NUMC	4	0	Stage	*
97	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group	*
98	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type	*
99	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
100	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
101	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
102	HEADC	☐	/RPM/PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Headcount
103	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
104	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
105	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
106	CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	*
107	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	*
108	GEOGRAPHY	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	*
109	PERIODTYPE	☐	/RPM/TV_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Financial Period Breakdown	*
110	CAP_PERIODTYPE	☐	/RPM/TV_CAP_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Capacity Period Breakdown	*
111	UNIT	☐	/RPM/TV_TIME_UNIT	MEINS	UNIT	3	0	Time Unit	*
112	ESCALATION	☐	RPM_TV_ESCALATION	XFELD	CHAR	1	0	Escalation Flag
113	ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
114	DISCOUNT_RATE	☐	/RPM/TV_DISCOUNT_RATE	/RPM/DEC_5_2	DEC	5	2	Discount Rate
115	FRCST_BGT_TOTAL	☐	/RPM/TV_FORECASTED_BUDGT_TOTAL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Budget Total
116	FRCST_BGTANNUAL	☐	/RPM/TV_FORECASTED_BUDGT_ANNL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Budget Annual
117	FRCST_COSTTOTAL	☐	/RPM/TV_FORECASTED_COST_TOTAL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Cost Total
118	FRCST_COST_YTD	☐	/RPM/TV_FORECASTED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Cost YTD
119	CPRO_TEMPLATE	☐	DPR_TV_BAPI_GUID_PROJECT	SYSUUID_C	CHAR	32	0	GUID for Project in BAPI Interface
120	.INCLUDE	☐				0	0	Item/Initiative Attributes; derrived
121	PRIORITY_ICON	☐	/RPM/TV_PRIORITY_ICON	ICON	CHAR	4	0	Priority	*
122	RISK_PRCNT	☐	RPM_RISK_LIMIT_HIGH	NUMC3	NUMC	3	0	Risk Group - Upper Limit
123	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	RPM_PROJ_RKGRP
124	RISK_ICON	☐	/RPM/TV_RISK_ICON	ICON	CHAR	4	0	Risk	*
125	PHASE_ICON	☐	/RPM/TV_PHASE_ICON	ICON	CHAR	4	0	Phase	*
126	PHASE_COLOR	☐	RPM_TV_STATUS_COLOR	RPM_HTML_COLOR	CHAR	7	0	Alert Object Color Status
127	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
128	D_PLANSTART	☐	/RPM/TV_DP_PLAN_START	DATUM	DATS	8	0	Planned Start
129	D_PLANFINISH	☐	/RPM/TV_DP_PLAN_FINISH	DATUM	DATS	8	0	Planned Finish
130	D_ACTUALSTART	☐	/RPM/TV_DP_ACTUAL_START	DATUM	DATS	8	0	Actual Start
131	D_ACTUALFINISH	☐	/RPM/TV_DP_ACTUAL_FINISH	DATUM	DATS	8	0	Actual Finish Date
132	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
133	BEGDA_DEM	☐	/RPM/TV_PP_START_DEM	DATUM	DATS	8	0	Demand Planning Start
134	ENDDA_DEM	☐	/RPM/TV_PP_END_DEM	DATUM	DATS	8	0	Demand Planning Period Finish Date
135	BEGDA_FIN	☐	/RPM/TV_PP_START_FIN	DATUM	DATS	8	0	Financial Planning Period Start
136	ENDDA_FIN	☐	/RPM/TV_PP_END_FIN	DATUM	DATS	8	0	Financial Plan Period Finish Date
137	BUCKET_NAME	☐	/RPM/TV_BUCKET_NAME	TEXT40	CHAR	40	0	Bucket Name
138	BUCKET_ID	☐	/RPM/TV_BUCKET_ID		CHAR	24	0	Bucket ID
139	PROPOSAL	☐	/RPM/TV_PROPOSAL	XFELD	CHAR	1	0	Proposal
140	D_CHANGED_ON	☐	/RPM/TV_LAST_CHANGED_ON	DATUM	DATS	8	0	Changed On Date
141	MASTER_ITEM_NAME	☐	/RPM/TV_MASTER_ITEM_NAME	TEXT40	CHAR	40	0	Initiative Name
142	MASTER_ITEM_ID	☐	/RPM/TV_MASTER_ITEM_ID		CHAR	24	0	Initiative ID
143	HAS_CHILDREN	☐	/RPM/TV_ITEM_CHILDREN	XFELD	CHAR	1	0	Has Children
144	BUDGET_ICON	☐	/RPM/TV_BUDGET_ICON	ICON	CHAR	4	0	Budget	*
145	SCHEDULE_ICON	☐	/RPM/TV_SCHEDULE_ICON	ICON	CHAR	4	0	Schedule	*
146	STAFFING_ICON	☐	/RPM/TV_STAFFING_ICON	ICON	CHAR	4	0	Staffing	*
147	BUDGET_TOTAL	☐	/RPM/TV_BUDGET_TOTAL	/RPM/CURR_16_2	CURR	16	2	Total Budget
148	BUDGET_ANNUAL	☐	/RPM/TV_BUDGET_ANNUAL	/RPM/CURR_16_2	CURR	16	2	Annual Budget
149	PLANNED_COST	☐	/RPM/TV_PLANNED_COST	/RPM/CURR_16_2	CURR	16	2	Planned Costs
150	PLANNED_COST_YTD	☐	/RPM/TV_PLANNED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Costs Year to Date
151	ACTUAL_COST	☐	/RPM/TV_ACTUAL_COST	/RPM/CURR_16_2	CURR	16	2	Actual Costs
152	ACTUAL_COST_YTD	☐	/RPM/TV_ACTUAL_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Cost Year to Day
153	ACT_DECPT_NAME	☐	/RPM/TV_PHASE_T	TEXT80	CHAR	80	0	Decision Point Name
154	ACT_DECPT_STAT_TEXT	☐	/RPM/TV_STATUS_TEXT	CHAR40	CHAR	40	0	Active Decision Point Status Text
155	ACT_DECPT_STAT_ICON	☐	/RPM/TV_DECPT_STATUS_ICON	ICON	CHAR	4	0	Active Decision Point Status	*
156	DECPT_INFO	☐	/RPM/TV_DECPT_INFO	CHAR20	CHAR	20	0	Decision Point Info
157	STATUS_GROUP	☐	/RPM/TV_ITEM_STATUS_GROUP	/RPM/ITEM_STATUS_GROUP	CHAR	4	0	Status Group
158	FORECASTED_DURATION	☐	/RPM/TV_FORCASTED_DURATION		QUAN	4	0	Forecasted Duration
159	PLANNED_DURATION	☐	/RPM/TV_PLANNED_DURATION		QUAN	4	0	Planned Duration
160	ACTUAL_DURATION	☐	/RPM/TV_ACTUAL_DURATION		QUAN	4	0	Actual Duration
161	ACT_PHASE_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
162	WORKEFFORT_TOTAL	☐	/RPM/TV_WORK_EFFORT_TOTAL	/RPM/DEC_26_2	DEC	26	2	Actual Effort
163	WORKEFFORT_YTD	☐	/RPM/TV_WORK_EFFORT_YTD	/RPM/DEC_26_2	DEC	26	2	Actual Work Effort Year-To-Date
164	PLANNED_EFFORT	☐	/RPM/TV_PLAN_EFFORT	/RPM/DEC_26_2	DEC	26	2	Planned Effort
165	PLANNED_EFFORT_YTD	☐	/RPM/TV_PLAN_EFFORT_YTD	/RPM/DEC_26_2	DEC	26	2	Planned Effort Year-To-Date
166	ROI	☐	/RPM/TV_ROI	/RPM/CURR_16_2	CURR	16	2	Return on Investment in % (manual)
167	IRR	☐	/RPM/TV_IRR	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in % (manual)
168	RISK_GROUP_D	☐	/RPM/RISK_GROUP_D	RPM_RISK_GROUP	NUMC	2	0	Risk Group Derived	RPM_PROJ_RKGRP
169	RISK_D_ICON	☐	/RPM/TV_RISK_ICON_D	ICON	CHAR	4	0	Derived Risk	*
170	PLANNED_DECISION_DATE	☐	/RPM/TV_PLAND_DDATE	DATUM	DATS	8	0	Planned Decision date
171	ACTUAL_DECISION_DATE	☐	/RPM/TV_ACTUAL_DDATE	DATUM	DATS	8	0	Actual Decision Date
172	FORECAST_DEC_DATE	☐	/RPM/TV_FORECAST_DDATE	DATUM	DATS	8	0	Forecasted Decision Date
173	D_FORECASTED_START	☐	RPM_TV_DP_FORECAST_START	DATS	DATS	8	0	Forecasted Start
174	D_FORECASTED_FINISH	☐	RPM_TV_DP_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
175	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group	RPM_PROJ_BDGRP
176	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group	RPM_PROJ_SDGRP
177	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group	RPM_PROJ_STGRP
178	PORTFOLIO_NAME	☐	/RPM/TV_PORTFOLIO_NAME	TEXT40	CHAR	40	0	Portfolio Name
179	PORTFOLIO_ID	☐	/RPM/TV_PORTFOLIO_ID		CHAR	24	0	Portfolio ID
180	PLANNED_REVENUE	☐	/RPM/TV_PLANNED_REVENUE	/RPM/CURR_16_2	CURR	16	2	Planned Revenues
181	PLANNED_REV_YTD	☐	/RPM/TV_PLANNED_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Revenues Year to Date
182	ACTUAL_REVENUE	☐	/RPM/TV_ACTUAL_REVENUE	/RPM/CURR_16_2	CURR	16	2	Actual Revenues
183	ACTUAL_REV_YTD	☐	/RPM/TV_ACTUAL_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Revenues Year to Day
184	.INCLUDE	☐				0	0	Financial KPIs
185	NPV_PLAN	☐	/RPM/TV_NPV_PLAN	/RPM/CURR_16_2	CURR	16	2	Net Present Value
186	IRR_PLAN	☐	/RPM/TV_IRR_PLAN	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in %
187	ROI_PLAN	☐	/RPM/TV_ROI_PLAN	/RPM/CURR_16_2	CURR	16	2	Return on Investment in %
188	PAYBACK_PLAN	☐	/RPM/TV_PAYBACK_PLAN	/RPM/TD_PBP_PLAN	NUMC	6	0	Payback Periods in Months
189	ECV_PLAN	☐	/RPM/TV_ECV_PLAN	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value
190	.INCLUDE	☐				0	0	Customer fields for KPI derived attributes
191	EA_DUMMY_KPI	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
192	.INCLUDE	☐				0	0
193	.INCLUDE	☐				0	0
194	VERSION	☐			STRG	0	0
195	SCENARIO_INCLUDE	☐	/RPM/TV_SCEN_INCL	XFELD	CHAR	1	0	Scenario Include Flag
196	CHECK_BOX	☐			NUMC	2	0
197	PROJ_DESC_FLAG	☐			NUMC	2	0
198	VERSION_FLAG	☐	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_WHATIFITEM_DASH_EXT	BUDGET_GROUP	RPM_PROJ_BDGRP	BUDGET_GROUP	KEY	1	CN
2	/RPM/TS_WHATIFITEM_DASH_EXT	RISK_GROUP	RPM_PROJ_RKGRP	RISK_GROUP	KEY	1	CN
3	/RPM/TS_WHATIFITEM_DASH_EXT	RISK_GROUP_D	RPM_PROJ_RKGRP	RISK_GROUP	KEY	1	CN
4	/RPM/TS_WHATIFITEM_DASH_EXT	SCHEDULE_GROUP	RPM_PROJ_SDGRP	SCHED_GROUP	KEY	1	CN
5	/RPM/TS_WHATIFITEM_DASH_EXT	STAFFING_GROUP	RPM_PROJ_STGRP	STAFFING_GROUP	KEY	1	CN

History

Last changed by/on	SAP	20141109
SAP Release Created in	500_702