SAP ABAP Table RPM_TS_PROJECT_OPERATIONALS (Project Template Overview)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ RPM_PROJECT (Package) RPM Application Object Project

Basic Data

Table Category	INTTAB	Structure
Structure	RPM_TS_PROJECT_OPERATIONALS	Table Relationship Diagram
Short Description	Project Template Overview

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	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category	*
2	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory	*
3	EXTERNAL_ID	☐	RPM_TV_PROJECT_ID		CHAR	24	0	Project ID
4	PROJ_DESCRIPTION	☐	RPM_TV_PROJ_DESCRIPTION	TEXT40	CHAR	40	0	Item Name
5	.INCLUDE	☐				0	0	Project attributes
6	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group	*
7	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type	*
8	.INCLUDE	☐				0	0	Project attributes
9	APSTAT	☐	RPM_PROJECT_APPST	RPM_PROJECT_APPST	NUMC	4	0	Project Approval Status	RPM_PROJ_APST
10	PPRIO	☐	RPM_PROJECT_PRIORITY	NUMC4	NUMC	4	0	Project Priority
11	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
12	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
13	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
14	HEADC	☐	RPM_PROJECT_HEADCOUNT_PLAN		DEC	10	2	Project Planned Headcount
15	BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
16	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
17	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
18	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
19	CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	TCURC
20	LOCATION	☐	RPM_TV_PROJECT_LOCATION	RPM_PROJECT_LOCATION	CHAR	4	0	Project Location	RPM_PROJ_LOCAT
21	GEOGRAPHY	☐	RPM_TV_PROJECT_GEOGRAPHY	RPM_PROJECT_GEOGRAPHY	CHAR	4	0	Project Geography	RPM_PROJ_GEOGR
22	.INCLUDE	☐				0	0	Project attributes
23	PHASE	☐	RPM_PROJECT_PHASE	RPM_PROJECT_PHASE	NUMC	4	0	Stage	*
24	EXSTAT	☐	RPM_PROJECT_EXECSTAT	RPM_PROJECT_EXECSTAT	NUMC	4	0	Project Execution Status	RPM_PROJ_EXST
25	COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
26	COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
27	RPM_CHANGED_ON	☐	RPM_TV_TIMESTAMP	RPM_BCOS_TSTMP	DEC	15	0	Time Stamp
28	ACTUAL_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
29	PLANNED_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
30	WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
31	BASELINE_START	☐	RPM_TV_BASELINE_START		DATS	8	0	Baseline Start
32	BASELINE_FINISH	☐	RPM_TV_BASELINE_FINISH		DATS	8	0	Baseline Finish
33	COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
34	COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
35	ANNUAL_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
36	.INCLUDE	☐				0	0
37	.INCLUDE	☐				0	0	RPM: Proj atts derived from externally modifiable attributes
38	D_PLANSTART	☐	RPM_TV_PLANNED_BEGDA	DATUM	DATS	8	0	Planned Start Date
39	D_PLANFINISH	☐	RPM_TV_PLANNED_ENDDA	DATUM	DATS	8	0	Planned Finish Date
40	D_ACTUALSTART	☐	RPM_TV_ACTUAL_BEGDA	DATUM	DATS	8	0	Actual Start Date
41	D_ACTUALFINISH	☐	RPM_TV_ACTUAL_ENDDA	DATUM	DATS	8	0	Actual Finish Date
42	.INCLUDE	☐				0	0	RPM: Proj atts derived from externally modifiable attributes
43	RISK_PRCNT	☐	RPM_RISK_LIMIT_HIGH	NUMC3	NUMC	3	0	Risk Group - Upper Limit
44	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
45	RISK_ICON	☐	RPM_TV_RISK_ICON	ICON	CHAR	4	0	Project Risk	*
46	ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
47	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
48	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
49	LOC_GEOGRAPHY	☐	RPM_TV_PROJECT_GEOGRAPHY	RPM_PROJECT_GEOGRAPHY	CHAR	4	0	Project Geography	*
50	DEPENDENCY_COUNT	☐	RPM_TV_DEPENDENCY_COUNT	NUMC3	NUMC	3	0	Number of Project Dependencies.
51	DEPENDENCY_GROUP	☐	RPM_TV_DEPENDENCY_STATUS	RPM_DEPENDENCY_STATUS	NUMC	4	0	Dependency Status
52	DEPENDENCY_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
53	DEPEND_ICONNAME	☐	ICONNAME	ICONNAME	CHAR	30	0	Name of an Icon
54	DEPENDENCY_TEXT	☐	RPM_TV_DP_STATGRP_T	TEXT30	CHAR	30	0	Dependency:Status Indicator Text
55	.INCLUDE	☐				0	0	RPM: Proj atts derived from externally modifiable attributes
56	PRIORITY_PRCNT	☐	RPM_PRIORITY_LIMIT_HIGH	NUMC4	NUMC	4	0	Project Priority: Upper Limit
57	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group	*
58	PRIORITY_ICON	☐	RPM_TV_PRIORITY_ICON	ICON	CHAR	4	0	Priority	*
59	BUDGET_PRCNT	☐	RPM_TV_BUDGET_LIMIT_HIGH	DECV03	DEC	3	0	Project Budget Status: Upper Limit
60	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group	*
61	BUDGET_ICON	☐	RPM_TV_BUDGET_ICON	ICON	CHAR	4	0	Project Budget	*
62	SCHEDULE_PRCNT	☐	RPM_TV_SCHEDULE_LIMIT_HIGH	NUMC3	NUMC	3	0	Project Schedule Status: Upper Limit
63	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group	*
64	SCHEDULE_ICON	☐	RPM_TV_SCHEDULE_ICON	ICON	CHAR	4	0	Project Schedule	*
65	STAFFING_PRCNT	☐	RPM_TV_SCHEDULE_LIMIT_HIGH	NUMC3	NUMC	3	0	Project Schedule Status: Upper Limit
66	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group	*
67	STAFFING_ICON	☐	RPM_TV_STAFFING_ICON	ICON	CHAR	4	0	Project Staffing	*
68	PHASE_ICON	☐	RPM_TV_PHASE_ICON	ICON	CHAR	4	0	Stage	*
69	PHASE_COLOR	☐	RPM_TV_STATUS_COLOR	RPM_HTML_COLOR	CHAR	7	0	Alert Object Color Status
70	VAR_COST	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
71	VAR_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
72	VAR_HEADCOUNT	☐	RPM_PROJ_VARIANCE_HEADCOUNT		DEC	10	2	Variance of Project Planned and Actual Headcount
73	VAR_STARTDATE	☐	RPM_PROJ_VAR_DAYS		DEC	8	0	Variance Start Date in Days
74	VAR_FINISHDATE	☐	RPM_PROJ_VAR_DAYS_FINISH		DEC	8	0	Variance Finish Date in Days
75	VAR_COST_TD	☐	RPM_PROJ_VARIANCE_COST_TD	CURR16	CURR	16	2	YTD Variance of Project Planned Cost to Actual Cost
76	MASTER_PROJECT	☐	RPM_TV_IS_MASTER_PROJECT	CHAR1	CHAR	1	0	Master Project Flag
77	.INCLUDE	☐				0	0	Node neighbor IDs
78	PARENT_ID	☐	RPM_TV_PARENT_EXTID		CHAR	24	0	Parent ID
79	LEFT_ID	☐	RPM_TV_LEFT_EXTID		CHAR	24	0	Left ID
80	RIGHT_ID	☐	RPM_TV_RIGHT_EXTID		CHAR	24	0	Right ID
81	.INCLUDE	☐				0	0
82	.INCLUDE	☐				0	0	Master Project Summary Fields
83	SUM_HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
84	SUM_BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
85	SUM_COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
86	SUM_COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
87	SUM_COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
88	SUM_COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
89	SUM_NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
90	SUM_CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	*
91	SUM_A_HEADCOUNT	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
92	SUM_A_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
93	SUM_P_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
94	SUM_WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
95	SUM_COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
96	SUM_COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
97	SUM_A_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
98	SUM_V_COST	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
99	SUM_V_HEADCOUNT	☐	RPM_PROJ_VARIANCE_HEADCOUNT		DEC	10	2	Variance of Project Planned and Actual Headcount
100	SUM_V_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
101	SUM_V_COST_TD	☐	RPM_PROJ_VARIANCE_COST_TD	CURR16	CURR	16	2	YTD Variance of Project Planned Cost to Actual Cost
102	SUM_ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
103	AVG_PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
104	AVG_PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RPM_TS_PROJECT_OPERATIONALS	APSTAT	RPM_PROJ_APST	APPST	REF	1	CN
2	RPM_TS_PROJECT_OPERATIONALS	CURRENCY	TCURC	WAERS	REF	1	CN
3	RPM_TS_PROJECT_OPERATIONALS	EXSTAT	RPM_PROJ_EXST	EXCST	REF	1	CN
4	RPM_TS_PROJECT_OPERATIONALS	GEOGRAPHY	RPM_PROJ_GEOGR	GEOGRAPHY	REF	1	CN
5	RPM_TS_PROJECT_OPERATIONALS	LOCATION	RPM_PROJ_LOCAT	LOCATION	REF	1	CN

History

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