SAP ABAP View /RPM/V_ITEM_DB (xRPM 4.0 Item Attributes Database View)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ /RPM/OBJECTS (Package) xRPM Business Objects

Basic Data

View Type	D	Database View
Database View	/RPM/V_ITEM_DB
Short Description	xRPM 4.0 Item Attributes Database View
Root table	/RPM/ITEM_D	Operational item persisted data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	/RPM/ITEM_D	/RPM/ITEM_D
2	/RPM/ITEM_D_DER
3	CGPL_TEXT
4	RPM_PROJ_SUBCT_T

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	/RPM/ITEM_D	CLIENT	JL	EQ				0	0
2	/RPM/ITEM_D_DER	CLIENT	JR	EQ			AND	0	0
3	/RPM/ITEM_D	GUID	JL	EQ				0	0
4	/RPM/ITEM_D_DER	GUID	JR	EQ			AND	0	0
5	/RPM/ITEM_D	CLIENT	JL	EQ				0	0
6	CGPL_TEXT	CLIENT	JR	EQ			AND	0	0
7	/RPM/ITEM_D	GUID	JL	EQ				0	0
8	CGPL_TEXT	GUID	JR	EQ			AND	0	0
9	/RPM/ITEM_D_DER	CLIENT	JL	EQ				0	0
10	CGPL_TEXT	CLIENT	JR	EQ			AND	0	0
11	/RPM/ITEM_D_DER	GUID	JL	EQ				0	0
12	CGPL_TEXT	GUID	JR	EQ			AND	0	0
13	/RPM/ITEM_D	VERSION_ITEM		EQ	' '		AND	0	0
14	/RPM/ITEM_D	ITEM_CLASS		NE	'1'		AND	0	0
15	/RPM/ITEM_D	ITEM_CLASS		NE	'4'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	/RPM/ITEM_D	CLIENT		☐	MANDT	☐	Client
2	GUID	/RPM/ITEM_D	GUID		☐	/RPM/TV_GUID	☐	Guid for application objects
3	EXTERNAL_ID	/RPM/ITEM_D	EXTERNAL_ID		☐	/RPM/TV_EXTID	☐	Business Object ID
4	PORTFOLIO_GUID	/RPM/ITEM_D	PORTFOLIO_GUID		☐	/RPM/TV_GUID	☐	Guid for application objects
5	PARENT_GUID	/RPM/ITEM_D	PARENT_GUID		☐	/RPM/TV_GUID	☐	Guid for application objects
6	CATEGORY	/RPM/ITEM_D	CATEGORY		☐	RPM_PROJECT_CATEGORY	☐	Category
7	SUBCATEGORY	/RPM/ITEM_D	SUBCATEGORY		☐	RPM_PROJ_SUBCATEGORY	☐	Subcategory
8	PHASE	/RPM/ITEM_D	PHASE		☐	RPM_PROJECT_PHASE	☐	Stage
9	PTYPE	/RPM/ITEM_D	PTYPE		☐	RPM_PROJECTTYPE	☐	Group
10	TTYPE	/RPM/ITEM_D	TTYPE		☐	RPM_PROJECT_TECHTYPE	☐	Technology Type
11	RISKA	/RPM/ITEM_D	RISKA		☐	RPM_PROJECT_RISK_ASSESED	☐	Assessed Project Risk
12	PROBT	/RPM/ITEM_D	PROBT		☐	RPM_PROJECT_PROB_TECH	☐	Probability of Technical Success
13	PROBC	/RPM/ITEM_D	PROBC		☐	RPM_PROJECT_PROB_COMM	☐	Probability of Commercial Success
14	HEADC	/RPM/ITEM_D	HEADC		☐	RPM_PROJECT_HEADCOUNT	☐	Actual Headcount
15	COSTD	/RPM/ITEM_D	COSTD		☐	RPM_PROJECT_COST_DEVELOPMENT	☐	Development Cost
16	COSTL	/RPM/ITEM_D	COSTL		☐	RPM_PROJECT_COST_LAUNCH	☐	Launch Cost
17	NPV	/RPM/ITEM_D	NPV		☐	RPM_PROJECT_NPV	☐	Net Present Value (manual)
18	CURRENCY	/RPM/ITEM_D	CURRENCY		☐	RPM_TV_CURRENCY	☐	Currency key
19	LOCATION	/RPM/ITEM_D	LOCATION		☐	RPM_TV_PROJECT_LOCATION	☐	Project Location
20	GEOGRAPHY	/RPM/ITEM_D	GEOGRAPHY		☐	RPM_TV_PROJECT_GEOGRAPHY	☐	Project Geography
21	RPM_CHANGED_ON	/RPM/ITEM_D	RPM_CHANGED_ON		☐	RPM_TV_TIMESTAMP	☐	Time Stamp
22	PERIODTYPE	/RPM/ITEM_D	PERIODTYPE		☐	/RPM/TV_PERIOD_TYPE	☐	Financial Period Breakdown
23	UNIT	/RPM/ITEM_D	UNIT		☐	RPM_TV_UNIT	☐	Unit
24	FORECAST_START	/RPM/ITEM_D	FORECAST_START		☐	RPM_TV_FORECAST_START	☐	Forecasted Start
25	PLANNED_START	/RPM/ITEM_D	PLANNED_START		☐	RPM_TV_PLAN_START	☐	Planned Start Date
26	ACTUAL_START	/RPM/ITEM_D	ACTUAL_START		☐	RPM_TV_ACTUAL_START	☐	Actual Start Date
27	FORECAST_FINISH	/RPM/ITEM_D	FORECAST_FINISH		☐	RPM_TV_FORECAST_FINISH	☐	Forecasted Finish Date
28	PLANNED_FINISH	/RPM/ITEM_D	PLANNED_FINISH		☐	RPM_TV_PLAN_FINISH	☐	Planned Finish Date
29	ACTUAL_FINISH	/RPM/ITEM_D	ACTUAL_FINISH		☐	RPM_TV_ACTUAL_FINISH	☐	Actual Finish Date
30	ESCALATION	/RPM/ITEM_D	ESCALATION		☐	RPM_TV_ESCALATION	☐	Escalation Flag
31	ITEM_TYPE	/RPM/ITEM_D	ITEM_TYPE		☐	/RPM/TV_ITEM_ID	☐	Type
32	PORTFL_ITEM_GUID	/RPM/ITEM_D	PORTFL_ITEM_GUID		☐	RPM_TV_GUID	☐	Guid for application objects
33	ECV	/RPM/ITEM_D	ECV		☐	RPM_TV_ECV	☐	Expected Commercial Value (manual)
34	PRIORITY_GROUP	/RPM/ITEM_D	PRIORITY_GROUP		☐	RPM_PRIORITY_GROUP	☐	Priority Group
35	CHANGED_BY	/RPM/ITEM_D	CHANGED_BY		☐	RPM_TV_CHANGED_BY	☐	Last Changed By
36	RISK_PRCNT	/RPM/ITEM_D_DER	RISK_PRCNT		☐	RPM_RISK_LIMIT_HIGH	☐	Risk Group - Upper Limit
37	RISK_GROUP	/RPM/ITEM_D_DER	RISK_GROUP		☐	RPM_RISK_GROUP	☐	Risk Group Assessed
38	RISK_ICON	/RPM/ITEM_D_DER	RISK_ICON		☐	RPM_TV_RISK_ICON	☐	Project Risk
39	DERIVED_RISK	/RPM/ITEM_D_DER	DERIVED_RISK		☐	RPM_TV_RISK_DERIVED	☐	Derived Risk
40	HEADC_ACTUAL	/RPM/ITEM_D_DER	HEADC_ACTUAL		☐	RPM_PROJECT_HEADCOUNT	☐	Actual Headcount
41	PRIORITY_ICON	/RPM/ITEM_D_DER	PRIORITY_ICON		☐	RPM_TV_PRIORITY_ICON	☐	Priority
42	PHASE_ICON	/RPM/ITEM_D_DER	PHASE_ICON		☐	RPM_TV_PHASE_ICON	☐	Stage
43	PHASE_COLOR	/RPM/ITEM_D_DER	PHASE_COLOR		☐	RPM_TV_STATUS_COLOR	☐	Alert Object Color Status
44	CHANGED_ON	/RPM/ITEM_D_DER	CHANGED_ON		☐	RPM_TV_TIMESTAMP	☐	Time Stamp
45	LANGU	CGPL_TEXT	LANGU		☐	LANGU	☐	Language Key
46	TEXT_GUID	CGPL_TEXT	TEXT_GUID		☐	SYSUUID_X	☐	UUID in X form (binary)
47	TEXT1	CGPL_TEXT	TEXT1		☐	CGPL_TEXT1	☐	Language-Dependent Short Text
48	TEXTU	CGPL_TEXT	TEXTU		☐	CGPL_TEXTU	☐	Project Planning: Short Text in Capital Letters
49	VERSION_ITEM	/RPM/ITEM_D	VERSION_ITEM		☐	RPM_TV_VERSION_FLAG	☐	Project Version Flag
50	ITEM_CLASS	/RPM/ITEM_D	ITEM_CLASS		☐	/RPM/TV_ITEM_CLASS	☐	Item Classification
51	MASTER_ITEM_GUID	/RPM/ITEM_D	MASTER_ITEM_GUID		☐	RPM_TV_GUID	☐	Guid for application objects
52	CAP_PERIODTYPE	/RPM/ITEM_D	CAP_PERIODTYPE		☐	/RPM/TV_CAP_PERIOD_TYPE	☐	Capacity Period Breakdown
53	STATUS	/RPM/ITEM_D	STATUS		☐	/RPM/TV_STATUS_COMMON	☐	Status
54	TEXT	RPM_PROJ_SUBCT_T	TEXT		☐	RPM_PROJ_SUBCATEGORY_TEXT	☐	Portfolio Item Subcategory Text

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	400