SAP ABAP Table /RPM/ITEM_D_DER (Project data)

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

Table Category	TRANSP	Transparent table
Transparent table	/RPM/ITEM_D_DER	Table Relationship Diagram
Short Description	Project data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☑	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects	RPM_PROJECT
3	.INCLUDE	☐				0	0	Item/Initiative Attributes; derived
4	RISK_PRCNT	☐	RPM_RISK_LIMIT_HIGH	NUMC3	NUMC	3	0	Risk Group - Upper Limit
5	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
6	RISK_ICON	☐	RPM_TV_RISK_ICON	ICON	CHAR	4	0	Project Risk	*
7	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
8	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
9	PRIORITY_ICON	☐	RPM_TV_PRIORITY_ICON	ICON	CHAR	4	0	Priority	*
10	PHASE_ICON	☐	RPM_TV_PHASE_ICON	ICON	CHAR	4	0	Stage	*
11	PHASE_COLOR	☐	RPM_TV_STATUS_COLOR	RPM_HTML_COLOR	CHAR	7	0	Alert Object Color Status
12	CHANGED_ON	☐	RPM_TV_TIMESTAMP	RPM_BCOS_TSTMP	DEC	15	0	Time Stamp
13	BUDGET_ICON	☐	/RPM/TV_BUDGET_ICON	ICON	CHAR	4	0	Budget	*
14	SCHEDULE_ICON	☐	/RPM/TV_SCHEDULE_ICON	ICON	CHAR	4	0	Schedule	*
15	STAFFING_ICON	☐	/RPM/TV_STAFFING_ICON	ICON	CHAR	4	0	Staffing	*
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	CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	*
23	PROPOSAL	☐	/RPM/TV_PROPOSAL	XFELD	CHAR	1	0	Proposal
24	STATUS_GROUP	☐	/RPM/TV_ITEM_STATUS_GROUP	/RPM/ITEM_STATUS_GROUP	CHAR	4	0	Status Group
25	ACT_PHASE_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
26	WORKEFFORT_TOTAL	☐	/RPM/TV_WORKEFFORT_TOTAL	/RPM/DEC_26_8	DEC	26	8	Actual Effort
27	WORKEFFORT_YTD	☐	/RPM/TV_WORKEFFORT_YTD	/RPM/DEC_26_8	DEC	26	8	Work Effort Year-to-Date
28	PLANNED_EFFORT	☐	/RPM/TV_PLANNED_EFFORT	/RPM/DEC_26_8	DEC	26	8	Planned Effort
29	PLANNED_EFRTYTD	☐	/RPM/TV_PLANNED_EFFORT_YTD	/RPM/DEC_26_8	DEC	26	8	Planned Effort Year-to-Date
30	ROI	☐	/RPM/TV_ROI	/RPM/CURR_16_2	CURR	16	2	Return on Investment in % (manual)
31	IRR	☐	/RPM/TV_IRR	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in % (manual)
32	RISK_GROUP_D	☐	/RPM/RISK_GROUP_D	RPM_RISK_GROUP	NUMC	2	0	Risk Group Derived	*
33	RISK_D_ICON	☐	/RPM/TV_RISK_ICON_D	ICON	CHAR	4	0	Derived Risk	*
34	FORCTED_DURATION	☐	/RPM/TV_FORCASTED_DURATION		QUAN	4	0	Forecasted Duration
35	PLANNED_DURATION	☐	/RPM/TV_PLANNED_DURATION		QUAN	4	0	Planned Duration
36	ACTUAL_DURATION	☐	/RPM/TV_ACTUAL_DURATION		QUAN	4	0	Actual Duration
37	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group	*
38	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group	*
39	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group	*
40	PLANNED_REVENUE	☐	/RPM/TV_PLANNED_REVENUE	/RPM/CURR_16_2	CURR	16	2	Planned Revenues
41	PLANNED_REV_YTD	☐	/RPM/TV_PLANNED_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Revenues Year to Date
42	ACTUAL_REVENUE	☐	/RPM/TV_ACTUAL_REVENUE	/RPM/CURR_16_2	CURR	16	2	Actual Revenues
43	ACTUAL_REV_YTD	☐	/RPM/TV_ACTUAL_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Revenues Year to Day
44	.INCLUDE	☐				0	0	Financial KPIs
45	NPV_PLAN	☐	/RPM/TV_NPV_PLAN	/RPM/CURR_16_2	CURR	16	2	Net Present Value
46	IRR_PLAN	☐	/RPM/TV_IRR_PLAN	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in %
47	ROI_PLAN	☐	/RPM/TV_ROI_PLAN	/RPM/CURR_16_2	CURR	16	2	Return on Investment in %
48	PAYBACK_PLAN	☐	/RPM/TV_PAYBACK_PLAN	/RPM/TD_PBP_PLAN	NUMC	6	0	Payback Periods in Months
49	ECV_PLAN	☐	/RPM/TV_ECV_PLAN	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value
50	.INCLUDE	☐				0	0	Customer fields for KPI derived attributes
51	EA_DUMMY_KPI	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
52	.INCLUDE	☐				0	0
53	.INCLUDE	☐				0	0	Customer fields for item detail derived attributes
54	EA_DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
55	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/RPM/ITEM_D_DER	GUID	RPM_PROJECT	GUID	KEY	1	C

History

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