SAP ABAP Table INM_TS_INITIATIVE_DATA_UI (Initiative UI structure without CI include)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-CF (Application Component) Common Functions
     ⤷ INM_UI_LOGIC (Package) PPM Cross Application UI Objects

Basic Data

Table Category	INTTAB	Structure
Structure	INM_TS_INITIATIVE_DATA_UI	Table Relationship Diagram
Short Description	Initiative UI structure without CI include

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	GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
2	CREATED_ON	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
3	CREATED_BY	☐	CGPL_CREATED_BY	USNAM	CHAR	12	0	Name of Person Who Created Object
4	CHANGED_ON	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
5	CHANGED_BY	☐	CGPL_CHANGED_BY	USNAM	CHAR	12	0	Name of Person Who Changed Object
6	LAST_CHANGED_ON	☐	INM_TV_TIMESTAMP	BCOS_TSTMP	DEC	15	0	UTC Time Stamp in Short Form
7	LAST_CHANGED_BY	☐	INM_TV_UNAME	UNAME	CHAR	12	0	User Name
8	NO_OF_ITEMS	☐	INM_TV_NO_OF_ITEMS		INT4	10	0	Number of Items
9	ITEM_GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
10	BUCKET_NAME	☐	/RPM/TV_BUCKET_NAME	TEXT40	CHAR	40	0	Bucket Name
11	BUCKET_ID	☐	/RPM/TV_BUCKET_ID		CHAR	24	0	Bucket ID
12	PRIORITY_ICON	☐	/RPM/TV_PRIORITY_ICON	ICON	CHAR	4	0	Priority	*
13	RISK_ICON	☐	/RPM/TV_RISK_ICON	ICON	CHAR	4	0	Risk	*
14	RISK_D_ICON	☐	/RPM/TV_RISK_ICON_D	ICON	CHAR	4	0	Derived Risk	*
15	PROPOSAL	☐	/RPM/TV_PROPOSAL	XFELD	CHAR	1	0	Proposal
16	BUDGET_TOTAL	☐	/RPM/TV_BUDGET_TOTAL	/RPM/CURR_16_2	CURR	16	2	Total Budget
17	BUDGET_ANNUAL	☐	/RPM/TV_BUDGET_ANNUAL	/RPM/CURR_16_2	CURR	16	2	Annual Budget
18	PLANNED_COST	☐	/RPM/TV_PLANNED_COST	/RPM/CURR_16_2	CURR	16	2	Planned Costs
19	PLANNED_COST_YTD	☐	/RPM/TV_PLANNED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Costs Year to Date
20	ACTUAL_COST	☐	/RPM/TV_ACTUAL_COST	/RPM/CURR_16_2	CURR	16	2	Actual Costs
21	ACTUAL_COST_YTD	☐	/RPM/TV_ACTUAL_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Cost Year to Day
22	SCHEDULE_ICON	☐	/RPM/TV_SCHEDULE_ICON	ICON	CHAR	4	0	Schedule	*
23	STAFFING_ICON	☐	/RPM/TV_STAFFING_ICON	ICON	CHAR	4	0	Staffing	*
24	BUDGET_ICON	☐	/RPM/TV_BUDGET_ICON	ICON	CHAR	4	0	Budget	*
25	ACT_DECPT_STAT_ICON	☐	/RPM/TV_DECPT_STATUS_ICON	ICON	CHAR	4	0	Active Decision Point Status	*
26	DAYS_UNTIL_PLAN_FINISH	☐	/RPM/TV_D_LEFT_PLAN_FINISH		INT4	10	0	Days Until Finish
27	DAYS_UNTIL_NEXT_DECISION	☐	/RPM/TV_D_LEFT_NEXT_DECISION		INT4	10	0	Days Until Next Decision
28	FORECASTED_DURATION	☐	INM_ON_FORECAST_DURATION		QUAN	4	2	Forecasted Duration
29	PLANNED_DURATION	☐	INM_ON_PLANNED_DURATION		QUAN	4	2	Planned Duration
30	ACTUAL_DURATION	☐	INM_ON_ACTUAL_DURATION		QUAN	4	2	Actual Duration
31	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
32	ACT_PHASE_NAME	☐	INM_TV_PHASE_NAME	TEXT40	CHAR	40	0	Phase Name
33	ACT_PHASE_GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
34	ACT_PHASE_STAT_TEXT	☐	INM_TV_ACT_P_STATUSTXT	CHAR30	CHAR	30	0	Active Phase Status Text Long
35	WORKEFFORT_TOTAL	☐	/RPM/TV_WORKEFFORT_TOTAL	/RPM/DEC_26_8	DEC	26	8	Actual Effort
36	WORKEFFORT_YTD	☐	/RPM/TV_WORKEFFORT_YTD	/RPM/DEC_26_8	DEC	26	8	Work Effort Year-to-Date
37	PLANNED_EFFORT	☐	/RPM/TV_PLANNED_EFFORT	/RPM/DEC_26_8	DEC	26	8	Planned Effort
38	PLANNED_EFFORT_YTD	☐	/RPM/TV_PLANNED_EFFORT_YTD	/RPM/DEC_26_8	DEC	26	8	Planned Effort Year-to-Date
39	ACT_DPCPT_GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
40	ACT_DECPT_NAME	☐	/RPM/TV_PHASE_T	TEXT80	CHAR	80	0	Decision Point Name
41	ACT_DECPT_STAT_TEXT	☐	/RPM/TV_STATUS_TEXT	CHAR40	CHAR	40	0	Active Decision Point Status Text
42	DECPT_INFO	☐	/RPM/TV_DECPT_INFO	CHAR20	CHAR	20	0	Decision Point Info
43	D_PLANSTART	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
44	D_PLANFINISH	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
45	D_ACTUALSTART	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
46	D_ACTUALFINISH	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
47	D_FORECASTED_START	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
48	D_FORECASTED_FINISH	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
49	ACTUAL_DECISION_DATE	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
50	FORCASTED_DECISION_DATE	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
51	PLANNED_DECISION_DATE	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
52	DPR_GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
53	SYSTEM_STATUS	☐	J_ISTAT	J_ISTAT	CHAR	5	0	System status	*
54	USER_STATUS	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
55	STATUS_TEXT_SHORT	☐	J_TXT04	TEXT4	CHAR	4	0	Individual status of an object (short form)
56	STATUS_TEXT_LONG	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
57	RESP_ORG_U_SHORT	☐	DPR_TV_ORG_UNIT	CHAR12	CHAR	12	0	Responsible Organizational Unit
58	RESP_ORG_U_STEXT	☐	DPR_TV_TEXT	DPR_TEXT	CHAR	40	0	Object Name
59	EXTERNAL_ID	☐	INM_TV_EXTID		CHAR	24	0	Initiative ID
60	DESCRIPTION	☐	INM_TV_NAME	TEXT40	CHAR	40	0	Name or Short Text
61	TEMPLATE_GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
62	VERSION	☐	INM_TV_VERSION	XFELD	CHAR	1	0	Initiative Version
63	PORTFOLIO_GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
64	PARENT_GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
65	INITIATIVE_TYPE	☐	INM_TV_INITIATIVE_TYPE	/RPM/TD_ITEM_TYPE	CHAR	15	0	Initiative Type	/RPM/ITEM_TYPE
66	FORECAST_START	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
67	PLANNED_START	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
68	ACTUAL_START	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
69	FORECAST_FINISH	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
70	PLANNED_FINISH	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
71	ACTUAL_FINISH	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
72	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category	RPM_PROJ_CAT
73	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory	RPM_PROJ_SUBCAT
74	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group	RPM_PROJ_TYPE
75	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type	RPM_PROJ_TTYPE
76	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
77	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
78	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
79	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
80	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
81	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
82	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
83	CURRENCY	☐	WAERS_CURC	WAERS	CUKY	5	0	Currency Key	/RPM/CURRENCY
84	PERIODTYPE	☐	/RPM/TV_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Financial Period Breakdown	/RPM/PERIOD_TYPE
85	UNIT	☐	/RPM/TV_TIME_UNIT	MEINS	UNIT	3	0	Time Unit	/RPM/CAP_UNITS
86	ESCALATION	☐	RPM_TV_ESCALATION	XFELD	CHAR	1	0	Escalation Flag
87	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group	RPM_PROJ_PRGRP
88	CAP_PERIODTYPE	☐	RPM_TV_PERIOD_DISP	CHAR20	CHAR	20	0	Portfolio Mgmt: Period Description
89	HEADC	☐	/RPM/PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Headcount
90	DISCOUNT_RATE	☐	/RPM/TV_DISCOUNT_RATE	/RPM/DEC_5_2	DEC	5	2	Discount Rate
91	ROI	☐	/RPM/TV_ROI	/RPM/CURR_16_2	CURR	16	2	Return on Investment in % (manual)
92	IRR	☐	/RPM/TV_IRR	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in % (manual)
93	ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
94	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	RPM_PROJ_RKGRP
95	RISK_GROUP_D	☐	/RPM/RISK_GROUP_D	RPM_RISK_GROUP	NUMC	2	0	Risk Group Derived	RPM_PROJ_RKGRP
96	BEGDA_DEM	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
97	ENDDA_DEM	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
98	BEGDA_FIN	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
99	ENDDA_FIN	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
100	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
101	RESP_ORG_UNIT	☐	DPR_TV_RESP_ORGANIZATION	HROBJID	NUMC	8	0	Organization Responsible	*
102	GROUPING	☐	DPR_TV_GROUPING		CHAR	40	0	Grouping
103	SEARCH_FIELD	☐	DPR_TV_SEARCH_FIELD		CHAR	40	0	Search Field
104	PRIORITY	☐	DNOT_PRIORITY_STXT	DNOE_STXT	CHAR	20	0	Priority Short Text
105	AREA	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	DPR_AREA
106	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	DPR_LOCATION
107	RELEASE_DATE	☐	DPR_TV_BAPI_EXT_DATE	CHAR10	CHAR	10	0	External Date for BAPI Interface
108	STSMA	☐	J_STSMA	J_STSMA	CHAR	8	0	Status Profile	*
109	CAUSE	☐	INM_TV_REASON	DPR_CAUSE	CHAR	15	0	Reason	DPR_CAUSE
110	RESPONSIBLE_ROLE	☐	DPR_TV_PART_ROLE_DESCRIPTION	TEXT40	CHAR	40	0	Language-Dependent Short Text for Role (Participant)
111	RESPONSIBLE_ROLE_GUID	☐	/RPM/TV_GUID_CHAR	SYSUUID_C	CHAR	32	0	Guid in character type
112	RESPONSIBLE_NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
113	INITIATIVE_TYPE_TEXT	☐	/RPM/TV_ITEM_TYPE_T	TEXT80	CHAR	80	0	Item Type Text
114	BUDGET_ICON_TEXT	☐	RPM_TV_BUDGET_GROUP_T	TEXT30	CHAR	30	0	Project Budget Status Group Text
115	SCHEDULE_ICON_TEXT	☐	RPM_TV_SCHEDULE_GROUP_T	TEXT30	CHAR	30	0	Project Schedule Status Text
116	STAFFING_ICON_TEXT	☐	RPM_TV_STAFFING_GROUP_T	TEXT30	CHAR	30	0	Project Staffing Status Text
117	RISK_GROUP_ICON_TEXT	☐	RPM_TV_RISK_GROUP_T		CHAR	30	0	Risk Group Assessed Text
118	RISK_GROUP_D_ICON_TEXT	☐	RPM_TV_RISK_GROUP_D_T		CHAR	30	0	Risk Group Derived Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	INM_TS_INITIATIVE_DATA_UI	AREA	DPR_AREA	AREA	KEY
2	INM_TS_INITIATIVE_DATA_UI	CATEGORY	RPM_PROJ_CAT	CATEGORY	KEY
3	INM_TS_INITIATIVE_DATA_UI	CAUSE	DPR_CAUSE	CAUSE	KEY	1	CN
4	INM_TS_INITIATIVE_DATA_UI	CURRENCY	/RPM/CURRENCY	CURRENCY	KEY
5	INM_TS_INITIATIVE_DATA_UI	INITIATIVE_TYPE	/RPM/ITEM_TYPE	ITEM_TYPE	KEY	1	CN
6	INM_TS_INITIATIVE_DATA_UI	LOCATION	DPR_LOCATION	LOCATION	KEY
7	INM_TS_INITIATIVE_DATA_UI	PERIODTYPE	/RPM/PERIOD_TYPE	PERIODTYPE	KEY
8	INM_TS_INITIATIVE_DATA_UI	PRIORITY_GROUP	RPM_PROJ_PRGRP	PRIORITY_GROUP	KEY
9	INM_TS_INITIATIVE_DATA_UI	PTYPE	RPM_PROJ_TYPE	PTYPE	KEY
10	INM_TS_INITIATIVE_DATA_UI	RISK_GROUP	RPM_PROJ_RKGRP	RISK_GROUP	KEY	1	CN
11	INM_TS_INITIATIVE_DATA_UI	RISK_GROUP_D	RPM_PROJ_RKGRP	RISK_GROUP	KEY	1	CN
12	INM_TS_INITIATIVE_DATA_UI	SUBCATEGORY	RPM_PROJ_SUBCAT	SUBCATEGORY	KEY
13	INM_TS_INITIATIVE_DATA_UI	TTYPE	RPM_PROJ_TTYPE	TTYPE	KEY
14	INM_TS_INITIATIVE_DATA_UI	UNIT	/RPM/CAP_UNITS	UNIT	KEY

History

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