SAP ABAP Table RPM_TS_PROJECT_BW (RPM project structure for BW extractor)

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_BW	Table Relationship Diagram
Short Description	RPM project structure for BW extractor

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	GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
2	EXTERNAL_ID	☐	CGPL_EXTID	CGPL_EXTID	CHAR	24	0	Project Planning: External Indentifier of an Element
3	PROJ_DESCRIPTION	☐	CGPL_TEXT1	TEXT40	CHAR	40	0	Language-Dependent Short Text
4	ACTUALSTART	☐	DATUM	DATUM	DATS	8	0	Date
5	ACTUALFINISH	☐	DATUM	DATUM	DATS	8	0	Date
6	PLANSTART	☐	DATUM	DATUM	DATS	8	0	Date
7	PLANFINISH	☐	DATUM	DATUM	DATS	8	0	Date
8	DELIVERY_DATE	☐	DATUM	DATUM	DATS	8	0	Date
9	ACTUAL_DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
10	PLAN_DURATION	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
11	DURATION_UNIT	☐	CGPL_DURATION_UNIT	MEINS	UNIT	3	0	Time Unit for Execution Duration	*
12	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category	RPM_PROJ_CAT
13	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory	*
14	PHASE	☐	RPM_PROJECT_PHASE	RPM_PROJECT_PHASE	NUMC	4	0	Stage	*
15	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group	*
16	PTEST	☐	RPM_TV_PROJECT_SIMULATION	XFELD	CHAR	1	0	Project Is Not Included in Portfolio Reporting
17	CTEST	☐	RPM_TV_PROJECT_SIMULATION	XFELD	CHAR	1	0	Project Is Not Included in Portfolio Reporting
18	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type	*
19	APSTAT	☐	RPM_PROJECT_APPST	RPM_PROJECT_APPST	NUMC	4	0	Project Approval Status	*
20	APSTAT_GROUP	☐	RPM_TV_PROJECT_APST_FIX	RPM_PROJECT_APST_FIX	CHAR	1	0	Project Approval Status Group
21	EXSTAT	☐	RPM_PROJECT_EXECSTAT	RPM_PROJECT_EXECSTAT	NUMC	4	0	Project Execution Status	*
22	EXSTAT_GROUP	☐	RPM_PROJECT_EXECSTAT_GROUP	RPM_PROJECT_EXECSTAT_GROUP	NUMC	4	0	Project Execution Status Group
23	PPRIO	☐	RPM_PROJECT_PRIORITY	NUMC4	NUMC	4	0	Project Priority
24	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
25	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
26	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
27	HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
28	BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
29	COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
30	COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
31	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
32	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
33	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
34	WAERS	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	TCURC
35	LOCATION	☐	RPM_TV_PROJECT_LOCATION	RPM_PROJECT_LOCATION	CHAR	4	0	Project Location	*
36	GEOGRAPHY	☐	RPM_TV_PROJECT_GEOGRAPHY	RPM_PROJECT_GEOGRAPHY	CHAR	4	0	Project Geography	*
37	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
38	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
39	POST_CODE	☐	POST_CODE	POST_CODE	CHAR	10	0	Postal Code	*
40	ACTUAL_HEADCOUNT	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
41	ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
42	PROPOSED	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
43	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
44	START_VARIANCE	☐	RPM_TV_DATE_VARIANCE		DEC	8	2	Date Variance
45	END_VARIANCE	☐	RPM_TV_DATE_VARIANCE		DEC	8	2	Date Variance
46	DUR_VARIANCE	☐	CGPL_DURATION	CGPL_DURATION	DEC	8	2	Duration of Execution
47	HEAD_VARIANCE	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
48	COST_VARIANCE	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
49	COST_TD_VARIANCE	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
50	ACTUAL_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
51	PLANNED_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
52	WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
53	BASELINE_START	☐	RPM_TV_BASELINE_START		DATS	8	0	Baseline Start
54	BASELINE_FINISH	☐	RPM_TV_BASELINE_FINISH		DATS	8	0	Baseline Finish
55	COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
56	COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
57	ANNUAL_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
58	IS_MASTER	☐	RPM_TV_IS_MASTER_PROJECT	CHAR1	CHAR	1	0	Master Project Flag
59	PARENT_ID	☐	RPM_TV_EXTID		CHAR	24	0	ID
60	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group	*
61	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group	*
62	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group	*
63	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
64	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group	*
65	PORTFL_ITEM_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
66	.INCLUDE	☐				0	0	ECV Chart Fields
67	AMOUNT1	☐			CURR	16	2
68	AMOUNT2	☐			CURR	16	2
69	AMOUNT3	☐			CURR	16	2
70	AMOUNT4	☐			CURR	16	2
71	AMOUNT5	☐			CURR	16	2
72	NUMBER1	☐			DEC	10	2
73	NUMBER2	☐			DEC	10	2
74	NUMBER3	☐			DEC	10	2
75	NUMBER4	☐			DEC	10	2
76	NUMBER5	☐			DEC	10	2
77	.INCLUDE	☐				0	0	Risk/Reward Chart Fields
78	AMOUNT6	☐			CURR	16	2
79	AMOUNT7	☐			CURR	16	2
80	AMOUNT8	☐			CURR	16	2
81	AMOUNT9	☐			CURR	16	2
82	AMOUNT10	☐			CURR	16	2
83	NUMBER6	☐			DEC	10	2
84	NUMBER7	☐			DEC	10	2
85	NUMBER8	☐			DEC	10	2
86	NUMBER9	☐			DEC	10	2
87	NUMBER10	☐			DEC	10	2
88	.INCLUDE	☐				0	0	Master Project Summary Fields
89	SUM_HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
90	SUM_BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
91	SUM_COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
92	SUM_COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
93	SUM_COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
94	SUM_COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
95	SUM_NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
96	SUM_CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	*
97	SUM_A_HEADCOUNT	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
98	SUM_A_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
99	SUM_P_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
100	SUM_WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
101	SUM_COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
102	SUM_COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
103	SUM_A_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
104	SUM_V_COST	☐	RPM_PROJ_VARIANCE_COST	CURR16	CURR	16	2	Total Variance of Project Planned Cost to Actual Cost
105	SUM_V_HEADCOUNT	☐	RPM_PROJ_VARIANCE_HEADCOUNT		DEC	10	2	Variance of Project Planned and Actual Headcount
106	SUM_V_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
107	SUM_V_COST_TD	☐	RPM_PROJ_VARIANCE_COST_TD	CURR16	CURR	16	2	YTD Variance of Project Planned Cost to Actual Cost
108	SUM_ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
109	AVG_PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
110	AVG_PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
111	.INCLUDE	☐				0	0
112	PRO_EXTERNAL_ID	☐	RPM_TV_EXTID		CHAR	24	0	ID
113	PRO_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RPM_TS_PROJECT_BW	CATEGORY	RPM_PROJ_CAT	CATEGORY	REF	1	CN
2	RPM_TS_PROJECT_BW	WAERS	TCURC	WAERS	KEY	1	CN

History

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