SAP ABAP Table RPM_TS_PROJECT_DB_INT (RPM Structure: Project attributes stored in the database)

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_DB_INT	Table Relationship Diagram
Short Description	RPM Structure: Project attributes stored in the database

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
3	EXTERNAL_ID	☐	/RPM/TV_EXTID		CHAR	24	0	Business Object ID
4	RPM_PROJECT	☐	RPM_TS_PROJECT_ATT		STRU	0	0
5	.INCLUDE	☐				0	0	Project attributes
6	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category
7	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory
8	PHASE	☐	RPM_PROJECT_PHASE	RPM_PROJECT_PHASE	NUMC	4	0	Stage
9	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group
10	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type
11	APSTAT	☐	RPM_PROJECT_APPST	RPM_PROJECT_APPST	NUMC	4	0	Project Approval Status
12	EXSTAT	☐	RPM_PROJECT_EXECSTAT	RPM_PROJECT_EXECSTAT	NUMC	4	0	Project Execution Status
13	PPRIO	☐	RPM_PROJECT_PRIORITY	NUMC4	NUMC	4	0	Project Priority
14	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
15	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
16	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
17	HEADC	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
18	BUDGT	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
19	COSTF	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
20	COSTA	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
21	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
22	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
23	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
24	CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key
25	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location
26	GEOGRAPHY	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area
27	ACTUAL_HEADCOUNT	☐	RPM_TV_HEADCOUNT		DEC	10	2	Actual Headcount
28	RPM_CHANGED_ON	☐	RPM_TV_TIMESTAMP	RPM_BCOS_TSTMP	DEC	15	0	Time Stamp
29	ACTUAL_WORK	☐	RPM_TV_ACTUAL_WORK		DEC	10	2	Actual Work
30	PLANNED_WORK	☐	RPM_TV_PLANNED_WORK		DEC	10	2	Planned Work
31	WORK_UNITS	☐	RPM_TV_ALLOCATION_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Assignment Unit
32	BASELINE_START	☐	RPM_TV_BASELINE_START		DATS	8	0	Baseline Start
33	BASELINE_FINISH	☐	RPM_TV_BASELINE_FINISH		DATS	8	0	Baseline Finish
34	COSTF_TD	☐	RPM_PROJECT_COST_FORECAST	CURR16	CURR	16	2	Planned Cost
35	COSTA_TD	☐	RPM_PROJECT_COST_ACTUAL	CURR16	CURR	16	2	Actual Cost
36	ANNUAL_BUDGET	☐	RPM_PROJECT_BUDGET_PLAN	CURR16	CURR	16	2	Budget
37	PERIODTYPE	☐	RPM_TV_AVLB_PERIOD	RPM_AVLB_PERIOD	NUMC	2	0	Period Type (Weekly/Monthly/Generic Interval)
38	UNIT	☐	RPM_TV_RESOURCE_AVAIL_UNIT	RPM_ALLOCATION_UNIT	CHAR	3	0	Project Resource Supply - Unit
39	VERSION	☐	RPM_TV_VERSION_TYPE	RPM_VERSION_TYPE	CHAR	1	0	Project Version Type
40	ITEM_TYPE	☐	/RPM/TV_ITEM_ID	/RPM/TD_ITEM_TYPE	CHAR	15	0	Type
41	PORTFL_ITEM_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
42	ESCALATION	☐	RPM_TV_ESCALATION	XFELD	CHAR	1	0	Escalation Flag
43	FORECAST_START	☐	RPM_TV_FORECAST_START	DATS	DATS	8	0	Forecasted Start
44	PLANNED_START	☐	RPM_TV_PLAN_START	DATS	DATS	8	0	Planned Start Date
45	ACTUAL_START	☐	RPM_TV_ACTUAL_START		DATS	8	0	Actual Start Date
46	FORECAST_FINISH	☐	RPM_TV_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
47	PLANNED_FINISH	☐	RPM_TV_PLAN_FINISH	DATS	DATS	8	0	Planned Finish Date
48	ACTUAL_FINISH	☐	RPM_TV_ACTUAL_FINISH		DATS	8	0	Actual Finish Date
49	PORTFOLIO_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
50	PARENT_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
51	ECV	☐	RPM_TV_ECV	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value (manual)
52	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group
53	CHANGED_BY	☐	UNAME	UNAME	CHAR	12	0	User Name
54	VERSION_ITEM	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
55	ITEM_CLASS	☐	/RPM/TV_ITEM_CLASS	/RPM/TD_ITEM_CLASS	CHAR	1	0	Item Classification
56	MASTER_ITEM_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
57	STATUS	☐	/RPM/TV_STATUS_COMMON	/RPM/TD_STATUS_COMMON	CHAR	5	0	Status
58	CAP_PERIODTYPE	☐	/RPM/TV_CAP_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Capacity Period Breakdown
59	ACT_DPCPT_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
60	DISCOUNT_RATE	☐	/RPM/TV_DISCOUNT_RATE	/RPM/DEC_5_2	DEC	5	2	Discount Rate
61	INITIATIVE_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
62	FRCST_BGT_TOTAL	☐	/RPM/TV_FORECASTED_BUDGT_TOTAL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Budget Total
63	FRCST_BGTANNUAL	☐	/RPM/TV_FORECASTED_BUDGT_ANNL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Budget Annual
64	FRCST_COSTTOTAL	☐	/RPM/TV_FORECASTED_COST_TOTAL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Cost Total
65	FRCST_COST_YTD	☐	/RPM/TV_FORECASTED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Cost YTD
66	TEMPLATE_GUID	☐	/RPM/TV_GUID		RAW	16	0	Guid for application objects
67	IS_GLOBAL	☐	/RPM/TV_GLOBAL	XFELD	CHAR	1	0	Global Template
68	.INCLUDE	☐				0	0	Item Detail Customer Fields
69	EA_DUMMY	☐	/RPM/TV_EA_DUMMY	CHAR1	CHAR	1	0	Dummy Data Element for Enhanced xRPM Attributes
70	.INCLUDE	☐				0	0
71	RPM_PROJECT_STKHLDR	☐	RPM_TT_PROJ_STKHLD_WITH_BUPA		TTYP	0	0
72	DEPENDENCIES_INT	☐	RPM_TT_PROJ_DEPENDENCY_INT		TTYP	0	0
73	ITEM_DER	☐	/RPM/TS_ITEM_D_DERIVED_ATT		STRU	0	0
74	PRIORITY_ICON	☐	/RPM/TV_PRIORITY_ICON	ICON	CHAR	4	0	Priority
75	RISK_PRCNT	☐	RPM_RISK_LIMIT_HIGH	NUMC3	NUMC	3	0	Risk Group - Upper Limit
76	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed
77	RISK_ICON	☐	/RPM/TV_RISK_ICON	ICON	CHAR	4	0	Risk
78	PHASE_ICON	☐	/RPM/TV_PHASE_ICON	ICON	CHAR	4	0	Phase
79	PHASE_COLOR	☐	RPM_TV_STATUS_COLOR	RPM_HTML_COLOR	CHAR	7	0	Alert Object Color Status
80	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
81	D_PLANSTART	☐	/RPM/TV_DP_PLAN_START	DATUM	DATS	8	0	Planned Start
82	D_PLANFINISH	☐	/RPM/TV_DP_PLAN_FINISH	DATUM	DATS	8	0	Planned Finish
83	D_ACTUALSTART	☐	/RPM/TV_DP_ACTUAL_START	DATUM	DATS	8	0	Actual Start
84	D_ACTUALFINISH	☐	/RPM/TV_DP_ACTUAL_FINISH	DATUM	DATS	8	0	Actual Finish Date
85	HEADC_ACTUAL	☐	RPM_PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Actual Headcount
86	BEGDA_DEM	☐	/RPM/TV_PP_START_DEM	DATUM	DATS	8	0	Demand Planning Start
87	ENDDA_DEM	☐	/RPM/TV_PP_END_DEM	DATUM	DATS	8	0	Demand Planning Period Finish Date
88	BEGDA_FIN	☐	/RPM/TV_PP_START_FIN	DATUM	DATS	8	0	Financial Planning Period Start
89	ENDDA_FIN	☐	/RPM/TV_PP_END_FIN	DATUM	DATS	8	0	Financial Plan Period Finish Date
90	BUCKET_NAME	☐	/RPM/TV_BUCKET_NAME	TEXT40	CHAR	40	0	Bucket Name
91	BUCKET_ID	☐	/RPM/TV_BUCKET_ID		CHAR	24	0	Bucket ID
92	PROPOSAL	☐	/RPM/TV_PROPOSAL	XFELD	CHAR	1	0	Proposal
93	D_CHANGED_ON	☐	/RPM/TV_LAST_CHANGED_ON	DATUM	DATS	8	0	Changed On Date
94	MASTER_ITEM_NAME	☐	/RPM/TV_MASTER_ITEM_NAME	TEXT40	CHAR	40	0	Initiative Name
95	MASTER_ITEM_ID	☐	/RPM/TV_MASTER_ITEM_ID		CHAR	24	0	Initiative ID
96	HAS_CHILDREN	☐	/RPM/TV_ITEM_CHILDREN	XFELD	CHAR	1	0	Has Children
97	BUDGET_ICON	☐	/RPM/TV_BUDGET_ICON	ICON	CHAR	4	0	Budget
98	SCHEDULE_ICON	☐	/RPM/TV_SCHEDULE_ICON	ICON	CHAR	4	0	Schedule
99	STAFFING_ICON	☐	/RPM/TV_STAFFING_ICON	ICON	CHAR	4	0	Staffing
100	BUDGET_TOTAL	☐	/RPM/TV_BUDGET_TOTAL	/RPM/CURR_16_2	CURR	16	2	Total Budget
101	BUDGET_ANNUAL	☐	/RPM/TV_BUDGET_ANNUAL	/RPM/CURR_16_2	CURR	16	2	Annual Budget
102	PLANNED_COST	☐	/RPM/TV_PLANNED_COST	/RPM/CURR_16_2	CURR	16	2	Planned Costs
103	PLANNED_COST_YTD	☐	/RPM/TV_PLANNED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Costs Year to Date
104	ACTUAL_COST	☐	/RPM/TV_ACTUAL_COST	/RPM/CURR_16_2	CURR	16	2	Actual Costs
105	ACTUAL_COST_YTD	☐	/RPM/TV_ACTUAL_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Cost Year to Day
106	ACT_DECPT_NAME	☐	/RPM/TV_PHASE_T	TEXT80	CHAR	80	0	Decision Point Name
107	ACT_DECPT_STAT_TEXT	☐	/RPM/TV_STATUS_TEXT	CHAR40	CHAR	40	0	Active Decision Point Status Text
108	ACT_DECPT_STAT_ICON	☐	/RPM/TV_DECPT_STATUS_ICON	ICON	CHAR	4	0	Active Decision Point Status
109	DECPT_INFO	☐	/RPM/TV_DECPT_INFO	CHAR20	CHAR	20	0	Decision Point Info
110	STATUS_GROUP	☐	/RPM/TV_ITEM_STATUS_GROUP	/RPM/ITEM_STATUS_GROUP	CHAR	4	0	Status Group
111	FORECASTED_DURATION	☐	/RPM/TV_FORCASTED_DURATION		QUAN	4	0	Forecasted Duration
112	PLANNED_DURATION	☐	/RPM/TV_PLANNED_DURATION		QUAN	4	0	Planned Duration
113	ACTUAL_DURATION	☐	/RPM/TV_ACTUAL_DURATION		QUAN	4	0	Actual Duration
114	ACT_PHASE_GUID	☐	DPR_TV_GUID	DPR_GUID	RAW	16	0	Application Object GUID
115	WORKEFFORT_TOTAL	☐	/RPM/TV_WORK_EFFORT_TOTAL	/RPM/DEC_26_2	DEC	26	2	Actual Effort
116	WORKEFFORT_YTD	☐	/RPM/TV_WORK_EFFORT_YTD	/RPM/DEC_26_2	DEC	26	2	Actual Work Effort Year-To-Date
117	PLANNED_EFFORT	☐	/RPM/TV_PLAN_EFFORT	/RPM/DEC_26_2	DEC	26	2	Planned Effort
118	PLANNED_EFFORT_YTD	☐	/RPM/TV_PLAN_EFFORT_YTD	/RPM/DEC_26_2	DEC	26	2	Planned Effort Year-To-Date
119	ROI	☐	/RPM/TV_ROI	/RPM/CURR_16_2	CURR	16	2	Return on Investment in % (manual)
120	IRR	☐	/RPM/TV_IRR	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in % (manual)
121	RISK_GROUP_D	☐	/RPM/RISK_GROUP_D	RPM_RISK_GROUP	NUMC	2	0	Risk Group Derived
122	RISK_D_ICON	☐	/RPM/TV_RISK_ICON_D	ICON	CHAR	4	0	Derived Risk
123	PLANNED_DECISION_DATE	☐	/RPM/TV_PLAND_DDATE	DATUM	DATS	8	0	Planned Decision date
124	ACTUAL_DECISION_DATE	☐	/RPM/TV_ACTUAL_DDATE	DATUM	DATS	8	0	Actual Decision Date
125	FORECAST_DEC_DATE	☐	/RPM/TV_FORECAST_DDATE	DATUM	DATS	8	0	Forecasted Decision Date
126	D_FORECASTED_START	☐	RPM_TV_DP_FORECAST_START	DATS	DATS	8	0	Forecasted Start
127	D_FORECASTED_FINISH	☐	RPM_TV_DP_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
128	BUDGET_GROUP	☐	RPM_TV_BUDGET_GROUP	RPM_BUDGET_GROUP	NUMC	2	0	Budget Status Group
129	SCHEDULE_GROUP	☐	RPM_TV_SCHEDULE_GROUP	RPM_SCHEDULE_GROUP	NUMC	2	0	Schedule Status Group
130	STAFFING_GROUP	☐	RPM_TV_STAFFING_GROUP	RPM_STAFFING_GROUP	NUMC	2	0	Staffing Status Group
131	PORTFOLIO_NAME	☐	/RPM/TV_PORTFOLIO_NAME	TEXT40	CHAR	40	0	Portfolio Name
132	PORTFOLIO_ID	☐	/RPM/TV_PORTFOLIO_ID		CHAR	24	0	Portfolio ID
133	PLANNED_REVENUE	☐	/RPM/TV_PLANNED_REVENUE	/RPM/CURR_16_2	CURR	16	2	Planned Revenues
134	PLANNED_REV_YTD	☐	/RPM/TV_PLANNED_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Planned Revenues Year to Date
135	ACTUAL_REVENUE	☐	/RPM/TV_ACTUAL_REVENUE	/RPM/CURR_16_2	CURR	16	2	Actual Revenues
136	ACTUAL_REV_YTD	☐	/RPM/TV_ACTUAL_REVENUE_YTD	/RPM/CURR_16_2	CURR	16	2	Actual Revenues Year to Day
137	.INCLUDE	☐				0	0	Financial KPIs
138	NPV_PLAN	☐	/RPM/TV_NPV_PLAN	/RPM/CURR_16_2	CURR	16	2	Net Present Value
139	IRR_PLAN	☐	/RPM/TV_IRR_PLAN	/RPM/CURR_16_2	CURR	16	2	Internal Rate of Return in %
140	ROI_PLAN	☐	/RPM/TV_ROI_PLAN	/RPM/CURR_16_2	CURR	16	2	Return on Investment in %
141	PAYBACK_PLAN	☐	/RPM/TV_PAYBACK_PLAN	/RPM/TD_PBP_PLAN	NUMC	6	0	Payback Periods in Months
142	ECV_PLAN	☐	/RPM/TV_ECV_PLAN	/RPM/CURR_16_2	CURR	16	2	Expected Commercial Value
143	.INCLUDE	☐				0	0	Customer fields for KPI derived attributes
144	EA_DUMMY_KPI	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
145	.INCLUDE	☐				0	0
146	VERSION_DER	☐	RPM_TS_PROJECT_VER_BW		STRU	0	0
147	VERSION_GUID_H	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
148	VERSION_TYPE	☐	/RPM/TV_VERSION_TYPE	/RPM/TD_VERSION_TYPE	CHAR	2	0	xRPM 4.0 Version Type
149	VERSION_ID	☐	/RPM/TV_VERSION_ID		CHAR	24	0	Version Information ID
150	ORIGINAL_GUID_H	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
151	ORIGINAL_GUID_D	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
152	MASTER_GUID	☐	RPM_TV_GUID	RPM_GUID	RAW	16	0	Guid for application objects
153	MASTER_TYPE	☐	/RPM/TV_CONTEXT_TYPE	CHAR2	CHAR	2	0	Version Context Type
154	NAME	☐	RPM_TV_PROJ_DESCRIPTION	TEXT40	CHAR	40	0	Item Name
155	VALID_TO	☐	DATUM	DATUM	DATS	8	0	Date
156	RPM_CREATED_ON	☐	/RPM/TV_CREATED_ON	DATUM	DATS	8	0	Review creation date
157	RPM_ILINKS	☐	/RPM/TT_ITEM_ILINKS		TTYP	0	0

History

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