SAP ABAP Table INM_TS_INITIATIVE_DASH_ATT (Data Fields of Dashboard)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-CF (Application Component) Common Functions
     ⤷ INM_INITIATIVE (Package) Initiative

Basic Data

Table Category	INTTAB	Structure
Structure	INM_TS_INITIATIVE_DASH_ATT	Table Relationship Diagram
Short Description	Data Fields of Dashboard

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	DESCRIPTION	☐	INM_TV_NAME	TEXT40	CHAR	40	0	Name or Short Text
2	EXTERNAL_ID	☐	INM_TV_EXTID		CHAR	24	0	Initiative ID
3	INITIATIVE_TYPE	☐	INM_TV_INITIATIVE_TYPE	/RPM/TD_ITEM_TYPE	CHAR	15	0	Initiative Type	*
4	CREATED_ON	☐	CGPL_CREATED_ON	DATUM	DATS	8	0	Date on Which the Object was Created
5	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
6	CHANGED_ON	☐	CGPL_CHANGED_ON	DATUM	DATS	8	0	Date on Which Object Was Last Changed
7	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
8	LAST_CHANGED_ON	☐	INM_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form
9	LAST_CHANGED_BY	☐	INM_TV_UNAME	UNAME	CHAR	12	0	User Name
10	NO_OF_ITEMS	☐	INM_TV_NO_OF_ITEMS		INT4	10	0	Number of Items
11	FORECAST_START	☐	RPM_TV_FORECAST_START	DATS	DATS	8	0	Forecasted Start
12	PLANNED_START	☐	RPM_TV_PLAN_START	DATS	DATS	8	0	Planned Start Date
13	ACTUAL_START	☐	RPM_TV_ACTUAL_START		DATS	8	0	Actual Start Date
14	FORECAST_FINISH	☐	RPM_TV_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
15	PLANNED_FINISH	☐	RPM_TV_PLAN_FINISH	DATS	DATS	8	0	Planned Finish Date
16	ACTUAL_FINISH	☐	RPM_TV_ACTUAL_FINISH		DATS	8	0	Actual Finish Date
17	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category	*
18	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory	*
19	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group	*
20	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type	*
21	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
22	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
23	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
24	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
25	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
26	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
27	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
28	CURRENCY	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	*
29	PERIODTYPE	☐	/RPM/TV_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Financial Period Breakdown	*
30	UNIT	☐	/RPM/TV_TIME_UNIT	MEINS	UNIT	3	0	Time Unit	*
31	ESCALATION	☐	RPM_TV_ESCALATION	XFELD	CHAR	1	0	Escalation Flag
32	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group	*
33	CAP_PERIODTYPE	☐	/RPM/TV_CAP_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Capacity Period Breakdown	*
34	HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
35	DISCOUNT_RATE	☐	/RPM/TV_DISCOUNT_RATE	/RPM/DEC_5_2	DEC	5	2	Discount Rate
36	ROI	☐	/RPM/TV_ROI	/RPM/CURR_16_2	CURR	16	2	Return on Investment in % (manual)
37	IRR	☐	/RPM/TV_IRR	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in % (manual)
38	ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
39	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
40	RISK_GROUP_D	☐	/RPM/RISK_GROUP_D	RPM_RISK_GROUP	NUMC	2	0	Risk Group Derived	*
41	BEGDA_DEM	☐	/RPM/TV_PP_START_DEM	DATUM	DATS	8	0	Demand Planning Start
42	ENDDA_DEM	☐	/RPM/TV_PP_END_DEM	DATUM	DATS	8	0	Demand Planning Period Finish Date
43	BEGDA_FIN	☐	/RPM/TV_PP_START_FIN	DATUM	DATS	8	0	Financial Planning Period Start
44	ENDDA_FIN	☐	/RPM/TV_PP_END_FIN	DATUM	DATS	8	0	Financial Plan Period Finish Date
45	.INCLUDE	☐				0	0	Project Non Modifiable Attributes
46	DPR_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
47	SYSTEM_STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
48	USER_STATUS	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
49	STATUS_TEXT_SHORT	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
50	STATUS_TEXT_LONG	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
51	RESP_ORG_U_SHORT	☐	DPR_TV_ORG_UNIT	CHAR12	CHAR	12	0	Responsible Organizational Unit
52	RESP_ORG_U_STEXT	☐	DPR_TV_TEXT	DPR_TEXT	CHAR	40	0	Object Name
53	.INCLUDE	☐				0	0	Externally Modifiable Project Attributes
54	RESP_ORG_UNIT	☐	DPR_TV_RESP_ORGANIZATION	HROBJID	NUMC	8	0	Organization Responsible	*
55	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
56	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
57	PRIORITY	☐	CGPL_PRIORITY	NUMC3	NUMC	3	0	Priority	CGPL_PRIO
58	AREA	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	DPR_AREA
59	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	DPR_LOCATION
60	RELEASE_DATE	☐	DPR_TV_RELEASE_DATE	DATS	DATS	8	0	Release Date
61	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
62	CAUSE	☐	INM_TV_REASON	DPR_CAUSE	CHAR	15	0	Reason	DPR_CAUSE
63	RESPONSIBLE_ROLE	☐	DPR_TV_PART_ROLE_DESCRIPTION	TEXT40	CHAR	40	0	Language-Dependent Short Text for Role (Participant)
64	RESPONSIBLE_ROLE_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
65	RESPONSIBLE_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
66	.INCLUDE	☐				0	0	Item Non Modifiable Attributes
67	ITEM_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
68	BUCKET_NAME	☐	/RPM/TV_BUCKET_NAME	TEXT40	CHAR	40	0	Bucket Name
69	BUCKET_ID	☐	/RPM/TV_BUCKET_ID		CHAR	24	0	Bucket ID
70	PRIORITY_ICON	☐	/RPM/TV_PRIORITY_ICON	ICON	CHAR	4	0	Priority	*
71	RISK_ICON	☐	/RPM/TV_RISK_ICON	ICON	CHAR	4	0	Risk	*
72	RISK_D_ICON	☐	/RPM/TV_RISK_ICON_D	ICON	CHAR	4	0	Derived Risk	*
73	PROPOSAL	☐	/RPM/TV_PROPOSAL	XFELD	CHAR	1	0	Proposal
74	BUDGET_TOTAL	☐	/RPM/TV_BUDGET_TOTAL	/RPM/CURR_16_2	CURR	16	2	Total Budget
75	BUDGET_ANNUAL	☐	/RPM/TV_BUDGET_ANNUAL	/RPM/CURR_16_2	CURR	16	2	Annual Budget
76	PLANNED_COST	☐	/RPM/TV_PLANNED_COST	/RPM/CURR_16_2	CURR	16	2	Planned Costs
77	PLANNED_COST_YTD	☐	/RPM/TV_PLANNED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Costs Year to Date
78	ACTUAL_COST	☐	/RPM/TV_ACTUAL_COST	/RPM/CURR_16_2	CURR	16	2	Actual Costs
79	ACTUAL_COST_YTD	☐	/RPM/TV_ACTUAL_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Cost Year to Day
80	SCHEDULE_ICON	☐	/RPM/TV_SCHEDULE_ICON	ICON	CHAR	4	0	Schedule	*
81	STAFFING_ICON	☐	/RPM/TV_STAFFING_ICON	ICON	CHAR	4	0	Staffing	*
82	BUDGET_ICON	☐	/RPM/TV_BUDGET_ICON	ICON	CHAR	4	0	Budget	*
83	ACT_DECPT_STAT_ICON	☐	/RPM/TV_DECPT_STATUS_ICON	ICON	CHAR	4	0	Active Decision Point Status	*
84	DAYS_UNTIL_PLAN_FINISH	☐	/RPM/TV_D_LEFT_PLAN_FINISH		INT4	10	0	Days Until Finish
85	DAYS_UNTIL_NEXT_DECISION	☐	/RPM/TV_D_LEFT_NEXT_DECISION		INT4	10	0	Days Until Next Decision
86	FORCTED_DURATION	☐	/RPM/TV_FORCASTED_DURATION		QUAN	4	0	Forecasted Duration
87	PLANNED_DURATION	☐	/RPM/TV_PLANNED_DURATION		QUAN	4	0	Planned Duration
88	ACTUAL_DURATION	☐	/RPM/TV_ACTUAL_DURATION		QUAN	4	0	Actual Duration
89	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
90	ACT_PHASE_NAME	☐	INM_TV_PHASE_NAME	TEXT40	CHAR	40	0	Phase Name
91	ACT_PHASE_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
92	ACT_PHASE_STAT_TEXT	☐	INM_TV_ACT_P_STATUSTXT	CHAR30	CHAR	30	0	Active Phase Status Text Long
93	WORKEFFORT_TOTAL	☐	/RPM/TV_WORKEFFORT_TOTAL	/RPM/DEC_26_8	DEC	26	8	Actual Effort
94	WORKEFFORT_YTD	☐	/RPM/TV_WORKEFFORT_YTD	/RPM/DEC_26_8	DEC	26	8	Work Effort Year-to-Date
95	PLANNED_EFFORT	☐	/RPM/TV_PLANNED_EFFORT	/RPM/DEC_26_8	DEC	26	8	Planned Effort
96	PLANNED_EFFORT_YTD	☐	/RPM/TV_PLANNED_EFFORT_YTD	/RPM/DEC_26_8	DEC	26	8	Planned Effort Year-to-Date
97	ACT_DPCPT_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
98	ACT_DECPT_NAME	☐	/RPM/TV_PHASE_T	TEXT80	CHAR	80	0	Decision Point Name
99	ACT_DECPT_STAT_TEXT	☐	/RPM/TV_STATUS_TEXT	CHAR40	CHAR	40	0	Active Decision Point Status Text
100	DECPT_INFO	☐	/RPM/TV_DECPT_INFO	CHAR20	CHAR	20	0	Decision Point Info
101	D_PLANSTART	☐	/RPM/TV_DP_PLAN_START	DATUM	DATS	8	0	Planned Start
102	D_PLANFINISH	☐	/RPM/TV_DP_PLAN_FINISH	DATUM	DATS	8	0	Planned Finish
103	D_ACTUALSTART	☐	/RPM/TV_DP_ACTUAL_START	DATUM	DATS	8	0	Actual Start
104	D_ACTUALFINISH	☐	/RPM/TV_DP_ACTUAL_FINISH	DATUM	DATS	8	0	Actual Finish Date
105	D_FORECASTED_START	☐	RPM_TV_DP_FORECAST_START	DATS	DATS	8	0	Forecasted Start
106	D_FORECASTED_FINISH	☐	RPM_TV_DP_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
107	ACTUAL_DECISION_DATE	☐	/RPM/ACTUAL_DECISION_DATE		DATS	8	0	Actual Decision Date
108	FORCASTED_DECISION_DATE	☐	/RPM/FORECAST_DECISION_DATE		DATS	8	0	Forecasted Decision Date
109	PLANNED_DECISION_DATE	☐	/RPM/PLANNED_DECISION_DATE		DATS	8	0	Planned Decision Date
110	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group	RPM_PROJ_BDGRP
111	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group	RPM_PROJ_STGRP
112	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group	RPM_PROJ_SDGRP
113	PORTFOLIO_NAME	☐	/RPM/TV_PORTFOLIO_NAME	TEXT40	CHAR	40	0	Portfolio Name
114	PORTFOLIO_ID	☐	/RPM/TV_PORTFOLIO_ID		CHAR	24	0	Portfolio ID
115	PLANNED_REVENUE	☐	/RPM/TV_PLANNED_REVENUE	/RPM/CURR_16_2	CURR	16	2	Planned Revenues
116	PLANNED_REV_YTD	☐	/RPM/TV_PLANNED_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Revenues Year to Date
117	ACTUAL_REVENUE	☐	/RPM/TV_ACTUAL_REVENUE	/RPM/CURR_16_2	CURR	16	2	Actual Revenues
118	ACTUAL_REV_YTD	☐	/RPM/TV_ACTUAL_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Revenues Year to Day
119	.INCLUDE	☐				0	0	Financial KPIs
120	NPV_PLAN	☐	/RPM/TV_NPV_PLAN	/RPM/CURR_16_2	CURR	16	2	Net Present Value
121	IRR_PLAN	☐	/RPM/TV_IRR_PLAN	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in %
122	ROI_PLAN	☐	/RPM/TV_ROI_PLAN	/RPM/CURR_16_2	CURR	16	2	Return on Investment in %
123	PAYBACK_PLAN	☐	/RPM/TV_PAYBACK_PLAN	/RPM/TD_PBP_PLAN	NUMC	6	0	Payback Periods in Months
124	ECV_PLAN	☐	/RPM/TV_ECV_PLAN	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value
125	.INCLUDE	☐				0	0	Customer fields for KPI derived attributes
126	EA_DUMMY_KPI	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
127	.INCLUDE	☐				0	0
128	.INCLUDE	☐				0	0
129	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	INM_TS_INITIATIVE_DASH_ATT	AREA	DPR_AREA	AREA	KEY	1	CN
2	INM_TS_INITIATIVE_DASH_ATT	BUDGET_GROUP	RPM_PROJ_BDGRP	BUDGET_GROUP	KEY	1	CN
3	INM_TS_INITIATIVE_DASH_ATT	CAUSE	DPR_CAUSE	CAUSE	KEY	1	CN
4	INM_TS_INITIATIVE_DASH_ATT	LOCATION	DPR_LOCATION	LOCATION	KEY	1	CN
5	INM_TS_INITIATIVE_DASH_ATT	PRIORITY	CGPL_PRIO	PRIORITY	KEY	1	CN
6	INM_TS_INITIATIVE_DASH_ATT	SCHEDULE_GROUP	RPM_PROJ_SDGRP	SCHED_GROUP	KEY	1	CN
7	INM_TS_INITIATIVE_DASH_ATT	STAFFING_GROUP	RPM_PROJ_STGRP	STAFFING_GROUP	KEY	1	CN

History

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