SAP ABAP View V_INM_INIT_DB (Initiative Attributes Database View)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_INM_INIT_DB
Short Description	Initiative Attributes Database View
Root table	INM_INITIATIVE	Initiative Master Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	INM_INITIATIVE	INM_INITIATIVE
2	/RPM/ITEM_D
3	/RPM/ITEM_D_DER
4	CGPL_TEXT
5	DPR_PROJECT
6	CGPL_PROJECT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	INM_INITIATIVE	CLIENT	JL	EQ				0	0
2	/RPM/ITEM_D	CLIENT	JR	EQ			AND	0	0
3	INM_INITIATIVE	ITEM_GUID	JL	EQ				0	0
4	/RPM/ITEM_D	GUID	JR	EQ			AND	0	0
5	INM_INITIATIVE	CLIENT	JL	EQ				0	0
6	CGPL_TEXT	CLIENT	JR	EQ			AND	0	0
7	INM_INITIATIVE	GUID	JL	EQ				0	0
8	CGPL_TEXT	GUID	JR	EQ			AND	0	0
9	INM_INITIATIVE	CLIENT	JL	EQ				0	0
10	/RPM/ITEM_D_DER	CLIENT	JR	EQ			AND	0	0
11	INM_INITIATIVE	ITEM_GUID	JL	EQ				0	0
12	/RPM/ITEM_D_DER	GUID	JR	EQ			AND	0	0
13	INM_INITIATIVE	CLIENT	JL	EQ				0	0
14	DPR_PROJECT	CLIENT	JR	EQ			AND	0	0
15	INM_INITIATIVE	DPR_GUID	JL	EQ				0	0
16	DPR_PROJECT	GUID	JR	EQ			AND	0	0
17	INM_INITIATIVE	CLIENT	JL	EQ				0	0
18	CGPL_PROJECT	CLIENT	JR	EQ			AND	0	0
19	INM_INITIATIVE	GUID	JL	EQ				0	0
20	CGPL_PROJECT	GUID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	INM_INITIATIVE	CLIENT		☐	MANDT	☐	Client
2	GUID	INM_INITIATIVE	GUID		☐	INM_TV_GUID	☐	Unique Identifier
3	EXTERNAL_ID	INM_INITIATIVE	EXTERNAL_ID		☐	INM_TV_EXTID	☐	Initiative ID
4	TEMPLATE_GUID	INM_INITIATIVE	TEMPLATE_GUID		☐	INM_TV_GUID	☐	Unique Identifier
5	IS_GLOBAL	INM_INITIATIVE	IS_GLOBAL		☐	INM_TV_GLOBAL	☐	Global Template
6	LAST_CHANGED_ON	INM_INITIATIVE	LAST_CHANGED_ON		☐	INM_TV_TIMESTAMP	☐	UTC Time Stamp in Short Form
7	LAST_CHANGED_BY	INM_INITIATIVE	LAST_CHANGED_BY		☐	INM_TV_UNAME	☐	User Name
8	PORTFOLIO_GUID	/RPM/ITEM_D	PORTFOLIO_GUID		☐	/RPM/TV_GUID	☐	Guid for application objects
9	PARENT_GUID	/RPM/ITEM_D	PARENT_GUID		☐	/RPM/TV_GUID	☐	Guid for application objects
10	CATEGORY	/RPM/ITEM_D	CATEGORY		☐	RPM_PROJECT_CATEGORY	☐	Category
11	SUBCATEGORY	/RPM/ITEM_D	SUBCATEGORY		☐	RPM_PROJ_SUBCATEGORY	☐	Subcategory
12	PHASE	/RPM/ITEM_D	PHASE		☐	RPM_PROJECT_PHASE	☐	Stage
13	PTYPE	/RPM/ITEM_D	PTYPE		☐	RPM_PROJECTTYPE	☐	Group
14	TTYPE	/RPM/ITEM_D	TTYPE		☐	RPM_PROJECT_TECHTYPE	☐	Technology Type
15	RISKA	/RPM/ITEM_D	RISKA		☐	RPM_PROJECT_RISK_ASSESED	☐	Assessed Project Risk
16	PROBT	/RPM/ITEM_D	PROBT		☐	RPM_PROJECT_PROB_TECH	☐	Probability of Technical Success
17	PROBC	/RPM/ITEM_D	PROBC		☐	RPM_PROJECT_PROB_COMM	☐	Probability of Commercial Success
18	HEADC	/RPM/ITEM_D	HEADC		☐	RPM_PROJECT_HEADCOUNT	☐	Actual Headcount
19	COSTD	/RPM/ITEM_D	COSTD		☐	RPM_PROJECT_COST_DEVELOPMENT	☐	Development Cost
20	COSTL	/RPM/ITEM_D	COSTL		☐	RPM_PROJECT_COST_LAUNCH	☐	Launch Cost
21	NPV	/RPM/ITEM_D	NPV		☐	RPM_PROJECT_NPV	☐	Net Present Value (manual)
22	CURRENCY	/RPM/ITEM_D	CURRENCY		☐	RPM_TV_CURRENCY	☐	Currency key
23	GEOGRAPHY	/RPM/ITEM_D	GEOGRAPHY		☐	RPM_TV_PROJECT_GEOGRAPHY	☐	Project Geography
24	RPM_CHANGED_ON	/RPM/ITEM_D	RPM_CHANGED_ON		☐	RPM_TV_TIMESTAMP	☐	Time Stamp
25	PERIODTYPE	/RPM/ITEM_D	PERIODTYPE		☐	/RPM/TV_PERIOD_TYPE	☐	Financial Period Breakdown
26	UNIT	/RPM/ITEM_D	UNIT		☐	RPM_TV_UNIT	☐	Unit
27	FORECAST_START	/RPM/ITEM_D	FORECAST_START		☐	RPM_TV_FORECAST_START	☐	Forecasted Start
28	PLANNED_START	/RPM/ITEM_D	PLANNED_START		☐	RPM_TV_PLAN_START	☐	Planned Start Date
29	ACTUAL_START	/RPM/ITEM_D	ACTUAL_START		☐	RPM_TV_ACTUAL_START	☐	Actual Start Date
30	FORECAST_FINISH	/RPM/ITEM_D	FORECAST_FINISH		☐	RPM_TV_FORECAST_FINISH	☐	Forecasted Finish Date
31	PLANNED_FINISH	/RPM/ITEM_D	PLANNED_FINISH		☐	RPM_TV_PLAN_FINISH	☐	Planned Finish Date
32	ACTUAL_FINISH	/RPM/ITEM_D	ACTUAL_FINISH		☐	RPM_TV_ACTUAL_FINISH	☐	Actual Finish Date
33	ESCALATION	/RPM/ITEM_D	ESCALATION		☐	RPM_TV_ESCALATION	☐	Escalation Flag
34	ITEM_TYPE	/RPM/ITEM_D	ITEM_TYPE		☐	/RPM/TV_ITEM_ID	☐	Type
35	PORTFL_ITEM_GUID	/RPM/ITEM_D	PORTFL_ITEM_GUID		☐	RPM_TV_GUID	☐	Guid for application objects
36	ECV	/RPM/ITEM_D	ECV		☐	RPM_TV_ECV	☐	Expected Commercial Value (manual)
37	PRIORITY_GROUP	/RPM/ITEM_D	PRIORITY_GROUP		☐	RPM_PRIORITY_GROUP	☐	Priority Group
38	CHANGED_BY	/RPM/ITEM_D	CHANGED_BY		☐	RPM_TV_CHANGED_BY	☐	Last Changed By
39	VERSION_ITEM	/RPM/ITEM_D	VERSION_ITEM		☐	RPM_TV_VERSION_FLAG	☐	Project Version Flag
40	ITEM_CLASS	/RPM/ITEM_D	ITEM_CLASS		☐	/RPM/TV_ITEM_CLASS	☐	Item Classification
41	MASTER_ITEM_GUID	/RPM/ITEM_D	MASTER_ITEM_GUID		☐	RPM_TV_GUID	☐	Guid for application objects
42	CAP_PERIODTYPE	/RPM/ITEM_D	CAP_PERIODTYPE		☐	/RPM/TV_CAP_PERIOD_TYPE	☐	Capacity Period Breakdown
43	INITIATIVE_GUID	/RPM/ITEM_D	INITIATIVE_GUID		☐	RPM_TV_GUID	☐	Guid for application objects
44	DISCOUNT_RATE	/RPM/ITEM_D	DISCOUNT_RATE		☐	/RPM/TV_DISCOUNT_RATE	☐	Discount Rate
45	ACT_DPCPT_GUID	/RPM/ITEM_D	ACT_DPCPT_GUID		☐	/RPM/TV_GUID	☐	Guid for application objects
46	FRCST_BGT_TOTAL	/RPM/ITEM_D	FRCST_BGT_TOTAL		☐	/RPM/TV_FORECASTED_BUDGT_TOTAL	☐	Portfolio Item Forecasted Budget Total
47	FRCST_BGTANNUAL	/RPM/ITEM_D	FRCST_BGTANNUAL		☐	/RPM/TV_FORECASTED_BUDGT_ANNL	☐	Portfolio Item Forecasted Budget Annual
48	FRCST_COSTTOTAL	/RPM/ITEM_D	FRCST_COSTTOTAL		☐	/RPM/TV_FORECASTED_COST_TOTAL	☐	Portfolio Item Forecasted Cost Total
49	FRCST_COST_YTD	/RPM/ITEM_D	FRCST_COST_YTD		☐	/RPM/TV_FORECASTED_COST_YTD	☐	Portfolio Item Forecasted Cost YTD
50	RISK_PRCNT	/RPM/ITEM_D_DER	RISK_PRCNT		☐	RPM_RISK_LIMIT_HIGH	☐	Risk Group - Upper Limit
51	RISK_GROUP	/RPM/ITEM_D_DER	RISK_GROUP		☐	RPM_RISK_GROUP	☐	Risk Group Assessed
52	RISK_ICON	/RPM/ITEM_D_DER	RISK_ICON		☐	RPM_TV_RISK_ICON	☐	Project Risk
53	DERIVED_RISK	/RPM/ITEM_D_DER	DERIVED_RISK		☐	RPM_TV_RISK_DERIVED	☐	Derived Risk
54	HEADC_ACTUAL	/RPM/ITEM_D_DER	HEADC_ACTUAL		☐	RPM_PROJECT_HEADCOUNT	☐	Actual Headcount
55	PRIORITY_ICON	/RPM/ITEM_D_DER	PRIORITY_ICON		☐	RPM_TV_PRIORITY_ICON	☐	Priority
56	PHASE_ICON	/RPM/ITEM_D_DER	PHASE_ICON		☐	RPM_TV_PHASE_ICON	☐	Stage
57	PHASE_COLOR	/RPM/ITEM_D_DER	PHASE_COLOR		☐	RPM_TV_STATUS_COLOR	☐	Alert Object Color Status
58	BUDGET_ICON	/RPM/ITEM_D_DER	BUDGET_ICON		☐	/RPM/TV_BUDGET_ICON	☐	Budget
59	SCHEDULE_ICON	/RPM/ITEM_D_DER	SCHEDULE_ICON		☐	/RPM/TV_SCHEDULE_ICON	☐	Schedule
60	STAFFING_ICON	/RPM/ITEM_D_DER	STAFFING_ICON		☐	/RPM/TV_STAFFING_ICON	☐	Staffing
61	BUDGET_TOTAL	/RPM/ITEM_D_DER	BUDGET_TOTAL		☐	/RPM/TV_BUDGET_TOTAL	☐	Total Budget
62	BUDGET_ANNUAL	/RPM/ITEM_D_DER	BUDGET_ANNUAL		☐	/RPM/TV_BUDGET_ANNUAL	☐	Annual Budget
63	PLANNED_COST	/RPM/ITEM_D_DER	PLANNED_COST		☐	/RPM/TV_PLANNED_COST	☐	Planned Costs
64	PLANNED_COST_YTD	/RPM/ITEM_D_DER	PLANNED_COST_YTD		☐	/RPM/TV_PLANNED_COST_YTD	☐	Planned Costs Year to Date
65	ACTUAL_COST	/RPM/ITEM_D_DER	ACTUAL_COST		☐	/RPM/TV_ACTUAL_COST	☐	Actual Costs
66	ACTUAL_COST_YTD	/RPM/ITEM_D_DER	ACTUAL_COST_YTD		☐	/RPM/TV_ACTUAL_COST_YTD	☐	Actual Cost Year to Day
67	PROPOSAL	/RPM/ITEM_D_DER	PROPOSAL		☐	/RPM/TV_PROPOSAL	☐	Proposal
68	ACT_PHASE_GUID	/RPM/ITEM_D_DER	ACT_PHASE_GUID		☐	DPR_TV_GUID	☐	Application Object GUID
69	WORKEFFORT_TOTAL	/RPM/ITEM_D_DER	WORKEFFORT_TOTAL		☐	/RPM/TV_WORKEFFORT_TOTAL	☐	Actual Effort
70	WORKEFFORT_YTD	/RPM/ITEM_D_DER	WORKEFFORT_YTD		☐	/RPM/TV_WORKEFFORT_YTD	☐	Work Effort Year-to-Date
71	PLANNED_EFFORT	/RPM/ITEM_D_DER	PLANNED_EFFORT		☐	/RPM/TV_PLANNED_EFFORT	☐	Planned Effort
72	PLANNED_EFRTYTD	/RPM/ITEM_D_DER	PLANNED_EFRTYTD		☐	/RPM/TV_PLANNED_EFFORT_YTD	☐	Planned Effort Year-to-Date
73	ROI	/RPM/ITEM_D_DER	ROI		☐	/RPM/TV_ROI	☐	Return on Investment in % (manual)
74	IRR	/RPM/ITEM_D_DER	IRR		☐	/RPM/TV_IRR	☐	Internal Rate of Return in % (manual)
75	RISK_GROUP_D	/RPM/ITEM_D_DER	RISK_GROUP_D		☐	/RPM/RISK_GROUP_D	☐	Risk Group Derived
76	RISK_D_ICON	/RPM/ITEM_D_DER	RISK_D_ICON		☐	/RPM/TV_RISK_ICON_D	☐	Derived Risk
77	FORCTED_DURATION	/RPM/ITEM_D_DER	FORCTED_DURATION		☐	/RPM/TV_FORCASTED_DURATION	☐	Forecasted Duration
78	PLANNED_DURATION	/RPM/ITEM_D_DER	PLANNED_DURATION		☐	/RPM/TV_PLANNED_DURATION	☐	Planned Duration
79	ACTUAL_DURATION	/RPM/ITEM_D_DER	ACTUAL_DURATION		☐	/RPM/TV_ACTUAL_DURATION	☐	Actual Duration
80	LANGU	CGPL_TEXT	LANGU		☐	LANGU	☐	Language Key
81	TEXT1	CGPL_TEXT	TEXT1		☐	CGPL_TEXT1	☐	Language-Dependent Short Text
82	CAUSE	DPR_PROJECT	CAUSE		☐	DPR_TV_CAUSE	☐	Reason for Project
83	GROUPING	DPR_PROJECT	GROUPING		☐	DPR_TV_GROUPING	☐	Grouping
84	LOCATION	DPR_PROJECT	LOCATION		☐	DPR_TV_LOCATION	☐	Location
85	RESP_ORG_UNIT	DPR_PROJECT	RESP_ORG_UNIT		☐	DPR_TV_RESP_ORGANIZATION	☐	Organization Responsible
86	OBJECT_TYPE	CGPL_PROJECT	OBJECT_TYPE		☐	CGPL_OBJECT_TYPE	☐	Object Type in Project Planning
87	CREATED_BY	CGPL_PROJECT	CREATED_BY		☐	CGPL_CREATED_BY	☐	Name of Person Who Created Object
88	CREATED_ON	CGPL_PROJECT	CREATED_ON		☐	CGPL_CREATED_ON	☐	Date on Which the Object was Created
89	TEXTU	CGPL_TEXT	TEXTU		☐	CGPL_TEXTU	☐	Project Planning: Short Text in Capital Letters

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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