SAP ABAP Table RPM_TS_PROJECT_ARCH (RPM: Project data that can be changed externally)

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_ARCH	Table Relationship Diagram
Short Description	RPM: Project data that can be changed externally

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	PROJECT_GUID	☐	CGPL_PROJECT_GUID	CGPL_PROJECT_GUID	RAW	16	0	Project Planning: 16 Character GUID for Projects
2	EXTERNAL_ID	☐	RPM_TV_EXTID		CHAR	24	0	ID
3	PROJ_DESCRIPTION	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
4	ACTUALSTART	☐	CGPL_ACTUALSTART	BCOS_TSTMP	DEC	15	0	Actual Start Date
5	ACTUALFINISH	☐	CGPL_ACTUALFINISH	BCOS_TSTMP	DEC	15	0	Actual Finish Date
6	PLANSTART	☐	CGPL_PLANSTART	BCOS_TSTMP	DEC	15	0	Planned start date
7	PLANFINISH	☐	CGPL_PLANFINISH	BCOS_TSTMP	DEC	15	0	Planned Finish Date
8	COMPLETION	☐	CGPL_COMPLETION	CGPL_COMPLETION	NUMC	3	0	Percentage of Completion
9	MILESTONE	☐	CGPL_MILESTONE	CHAR1	CHAR	1	0	Milestone indicator
10	CONSTRAINT_TYPE	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
11	CONSTRAINT_TIME	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
12	LATEST_START	☐	CGPL_LATEST_START	BCOS_TSTMP	DEC	15	0	Latest start
13	LATEST_FINISH	☐	CGPL_LATEST_FINISH	BCOS_TSTMP	DEC	15	0	Latest finish date
14	PROJECT_DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
15	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
16	CONSTR_TYPE_FIN	☐	CGPL_CONSTRAINT	CGPL_CONSTRAINT	CHAR	1	0	Type of Scheduling Constraint
17	CONSTR_TIME_FIN	☐	CGPL_CONSTRAINT_TIME	BCOS_TSTMP	DEC	15	0	Constraint Date
18	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category	*
19	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory	RPM_PROJ_SUBCAT
20	PHASE	☐	RPM_PROJECT_PHASE	RPM_PROJECT_PHASE	NUMC	4	0	Stage	RPM_PROJ_PHASE
21	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group	RPM_PROJ_TYPE
22	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type	RPM_PROJ_TTYPE
23	APSTAT	☐	RPM_PROJECT_APPST	RPM_PROJECT_APPST	NUMC	4	0	Project Approval Status	RPM_PROJ_APST
24	EXSTAT	☐	RPM_PROJECT_EXECSTAT	RPM_PROJECT_EXECSTAT	NUMC	4	0	Project Execution Status	RPM_PROJ_EXST
25	PPRIO	☐	RPM_PROJECT_PRIORITY	NUMC4	NUMC	4	0	Project Priority
26	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
27	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
28	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
29	HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
30	BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
31	COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
32	COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
33	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
34	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
35	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
36	CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	TCURC
37	LOCATION	☐	RPM_TV_PROJECT_LOCATION	RPM_PROJECT_LOCATION	CHAR	4	0	Project Location	RPM_PROJ_LOCAT
38	GEOGRAPHY	☐	RPM_TV_PROJECT_GEOGRAPHY	RPM_PROJECT_GEOGRAPHY	CHAR	4	0	Project Geography	RPM_PROJ_GEOGR
39	ACTUAL_HEADCOUNT	☐	RPM_TV_HEADCOUNT		DEC	10	2	Actual Headcount
40	RPM_CHANGED_ON	☐	RPM_TV_TIMESTAMP	RPM_BCOS_TSTMP	DEC	15	0	Time Stamp
41	ACTUAL_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
42	PLANNED_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
43	WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
44	BASELINE_START	☐	RPM_TV_BASELINE_START		DATS	8	0	Baseline Start
45	BASELINE_FINISH	☐	RPM_TV_BASELINE_FINISH		DATS	8	0	Baseline Finish
46	COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
47	COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
48	ANNUAL_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
49	PERIODTYPE	☐	RPM_TV_AVLB_PERIOD	RPM_AVLB_PERIOD	NUMC	2	0	Period Type (Weekly/Monthly/Generic Interval)
50	UNIT	☐	RPM_TV_RESOURCE_AVAIL_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Project Resource Supply - Unit
51	DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
52	DEPENDENCY_COUNT	☐	RPM_TV_DEPENDENCY_COUNT	NUMC3	NUMC	3	0	Number of Project Dependencies.
53	DELETE_OK	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
54	PRIORITY_PRCNT	☐	RPM_PRIORITY_LIMIT_HIGH	NUMC4	NUMC	4	0	Project Priority: Upper Limit
55	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group	*
56	PRIORITY_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
57	BUDGET_PRCNT	☐	RPM_TV_BUDGET_LIMIT_HIGH	DECV03	DEC	3	0	Project Budget Status: Upper Limit
58	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group	*
59	BUDGET_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
60	SCHEDULE_PRCNT	☐	RPM_TV_SCHEDULE_LIMIT_HIGH	NUMC3	NUMC	3	0	Project Schedule Status: Upper Limit
61	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group	*
62	SCHEDULE_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
63	RISK_PRCNT	☐	RPM_RISK_LIMIT_HIGH	NUMC3	NUMC	3	0	Risk Group - Upper Limit
64	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
65	RISK_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
66	STAFFING_PRCNT	☐	RPM_TV_STAFFING_LIMIT_HIGH	NUMC3	NUMC	3	0	Project Staffing Status Group High Limit
67	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group	*
68	STAFFING_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
69	PHASE_ICON	☐	ICON_D	ICON	CHAR	4	0	Icon in text fields (substitute display, alias)	*
70	PHASE_COLOR	☐	RPM_TV_STATUS_COLOR	RPM_HTML_COLOR	CHAR	7	0	Alert Object Color Status
71	ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
72	PROPOSED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
73	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
74	VAR_COST	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
75	VAR_HEADCOUNT	☐	RPM_PROJ_VARIANCE_HEADCOUNT		DEC	10	2	Variance of Project Planned and Actual Headcount
76	VAR_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
77	VAR_STARTDATE	☐	RPM_PROJ_VAR_DAYS		DEC	8	0	Variance Start Date in Days
78	VAR_FINISHDATE	☐	RPM_PROJ_VAR_DAYS		DEC	8	0	Variance Start Date in Days
79	VAR_COST_TD	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
80	D_PLANSTART	☐	BEGDA	DATUM	DATS	8	0	Start Date
81	D_PLANFINISH	☐	ENDDA	DATUM	DATS	8	0	End Date
82	D_ACTUALSTART	☐	BEGDA	DATUM	DATS	8	0	Start Date
83	D_ACTUALFINISH	☐	ENDDA	DATUM	DATS	8	0	End Date
84	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
85	MASTER_PROJECT	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
86	PARENT_ID	☐	RPM_TV_EXTID		CHAR	24	0	ID
87	LEFT_ID	☐	RPM_TV_EXTID		CHAR	24	0	ID
88	RIGHT_ID	☐	RPM_TV_EXTID		CHAR	24	0	ID
89	LOC_GEOGRAPHY	☐	RPM_TV_PROJECT_GEOGRAPHY	RPM_PROJECT_GEOGRAPHY	CHAR	4	0	Project Geography	*
90	SUM_HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
91	SUM_BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
92	SUM_COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
93	SUM_COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
94	SUM_COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
95	SUM_COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
96	SUM_NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
97	SUM_CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	*
98	SUM_A_HEADCOUNT	☐	RPM_TV_HEADCOUNT		DEC	10	2	Actual Headcount
99	SUM_A_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
100	SUM_P_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
101	SUM_WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
102	SUM_COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
103	SUM_COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
104	SUM_A_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
105	SUM_V_COST	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
106	SUM_V_HEADCOUNT	☐	RPM_PROJ_VARIANCE_HEADCOUNT		DEC	10	2	Variance of Project Planned and Actual Headcount
107	SUM_V_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
108	SUM_V_COST_TD	☐	RPM_PROJ_VARIANCE_COST_TD	CURR16	CURR	16	2	YTD Variance of Project Planned Cost to Actual Cost
109	SUM_ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
110	AVG_PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
111	AVG_PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
112	.INCLUDE	☐				0	0
113	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RPM_TS_PROJECT_ARCH	APSTAT	RPM_PROJ_APST	APPST	REF	1	CN
2	RPM_TS_PROJECT_ARCH	CURRENCY	TCURC	WAERS	REF	1	CN
3	RPM_TS_PROJECT_ARCH	EXSTAT	RPM_PROJ_EXST	EXCST	REF	1	CN
4	RPM_TS_PROJECT_ARCH	GEOGRAPHY	RPM_PROJ_GEOGR	GEOGRAPHY	REF	1	CN
5	RPM_TS_PROJECT_ARCH	LOCATION	RPM_PROJ_LOCAT	LOCATION	REF	1	CN
6	RPM_TS_PROJECT_ARCH	PHASE	RPM_PROJ_PHASE	PHASE	REF	1	CN
7	RPM_TS_PROJECT_ARCH	PTYPE	RPM_PROJ_TYPE	PTYPE	KEY	1	CN
8	RPM_TS_PROJECT_ARCH	SUBCATEGORY	RPM_PROJ_SUBCAT	SUBCATEGORY	REF	1	CN
9	RPM_TS_PROJECT_ARCH	TTYPE	RPM_PROJ_TTYPE	TTYPE	REF	1	CN

History

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