SAP ABAP Table /RPM/TS_TEMPLATE_D_DATA (SAP Field Configuration Item Template Data)

Hierarchy

☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ /RPM/API (Package) xRPM External Interfaces

Basic Data

Table Category	INTTAB	Structure
Structure	/RPM/TS_TEMPLATE_D_DATA	Table Relationship Diagram
Short Description	SAP Field Configuration Item Template Data

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	.INCLUDE	☐				0	0	Externally Modifiable Item Template Attributes
2	FORECAST_START	☐	RPM_TV_FORECAST_START	DATS	DATS	8	0	Forecasted Start
3	PLANNED_START	☐	RPM_TV_PLAN_START	DATS	DATS	8	0	Planned Start Date
4	ACTUAL_START	☐	RPM_TV_ACTUAL_START		DATS	8	0	Actual Start Date
5	FORECAST_FINISH	☐	RPM_TV_FORECAST_FINISH	DATS	DATS	8	0	Forecasted Finish Date
6	PLANNED_FINISH	☐	RPM_TV_PLAN_FINISH	DATS	DATS	8	0	Planned Finish Date
7	ACTUAL_FINISH	☐	RPM_TV_ACTUAL_FINISH		DATS	8	0	Actual Finish Date
8	CATEGORY	☐	RPM_PROJECT_CATEGORY	RPM_PROJECT_CATEGORY	NUMC	4	0	Category	RPM_PROJ_CAT
9	SUBCATEGORY	☐	RPM_PROJ_SUBCATEGORY	RPM_SUBCATEGORY	NUMC	4	0	Subcategory	RPM_PROJ_SUBCAT
10	PTYPE	☐	RPM_PROJECTTYPE	RPM_PROJECTTYPE	NUMC	4	0	Group	RPM_PROJ_TYPE
11	TTYPE	☐	RPM_PROJECT_TECHTYPE	RPM_PROJECT_TECHTYPE	NUMC	4	0	Technology Type	RPM_PROJ_TTYPE
12	RISKA	☐	RPM_PROJECT_RISK_ASSESED	NUMC3	NUMC	3	0	Assessed Project Risk
13	PROBT	☐	RPM_PROJECT_PROB_TECH	NUMC3	NUMC	3	0	Probability of Technical Success
14	PROBC	☐	RPM_PROJECT_PROB_COMM	NUMC3	NUMC	3	0	Probability of Commercial Success
15	CURRENCY	☐	RPM_TV_CURRENCY	WAERS	CUKY	5	0	Currency key	/RPM/CURRENCY
16	PERIODTYPE	☐	/RPM/TV_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Financial Period Breakdown	/RPM/PERIOD_TYPE
17	UNIT	☐	/RPM/TV_TIME_UNIT	MEINS	UNIT	3	0	Time Unit	/RPM/CAP_UNITS
18	ESCALATION	☐	RPM_TV_ESCALATION	XFELD	CHAR	1	0	Escalation Flag
19	COSTD	☐	RPM_PROJECT_COST_DEVELOPMENT	/RPM/CURR_16_2	CURR	16	2	Development Cost
20	COSTL	☐	RPM_PROJECT_COST_LAUNCH	/RPM/CURR_16_2	CURR	16	2	Launch Cost
21	NPV	☐	RPM_PROJECT_NPV	/RPM/CURR_16_2	CURR	16	2	Net Present Value (manual)
22	PRIORITY_GROUP	☐	RPM_PRIORITY_GROUP	RPM_PRIORITY_GROUP	NUMC	2	0	Priority Group	RPM_PROJ_PRGRP
23	CAP_PERIODTYPE	☐	/RPM/TV_CAP_PERIOD_TYPE	/RPM/TD_PERIOD_TYPE	NUMC	2	0	Capacity Period Breakdown	/RPM/PERIOD_TYPE
24	HEADC	☐	/RPM/PROJECT_HEADCOUNT	/RPM/DEC_10_2	DEC	10	2	Headcount
25	DISCOUNT_RATE	☐	/RPM/TV_DISCOUNT_RATE	/RPM/DEC_5_2	DEC	5	2	Discount Rate
26	LOCATION	☐	DPR_TV_LOCATION	DPR_LOCATION	CHAR	4	0	Location	DPR_LOCATION
27	GEOGRAPHY	☐	DPR_TV_AREA	DPR_AREA	CHAR	4	0	Area	DPR_AREA
28	STATUS	☐	/RPM/TV_TEMPLATE_STATUS	/RPM/TD_TEMPLATE_STATUS	CHAR	5	0	Template Status
29	FRCST_BGT_TOTAL	☐	/RPM/TV_FORECASTED_BUDGT_TOTAL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Budget Total
30	FRCST_BGTANNUAL	☐	/RPM/TV_FORECASTED_BUDGT_ANNL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Budget Annual
31	FRCST_COSTTOTAL	☐	/RPM/TV_FORECASTED_COST_TOTAL	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Cost Total
32	FRCST_COST_YTD	☐	/RPM/TV_FORECASTED_COST_YTD	/RPM/CURR_16_2	CURR	16	2	Portfolio Item Forecasted Cost YTD
33	IS_GLOBAL	☐	/RPM/TV_IS_GLOBAL	XFELD	CHAR	1	0	Global Template
34	CPRO_TEMPLATE_ID	☐	DPR_TV_PROJECT_ID	CGPL_EXTID	CHAR	24	0	Project Number
35	WORKEFFORT_TOTAL	☐	/RPM/TV_WORK_EFFORT_TOTAL	/RPM/DEC_26_2	DEC	26	2	Actual Effort
36	WORKEFFORT_YTD	☐	/RPM/TV_WORK_EFFORT_YTD	/RPM/DEC_26_2	DEC	26	2	Actual Work Effort Year-To-Date
37	PLANNED_EFFORT	☐	/RPM/TV_PLAN_EFFORT	/RPM/DEC_26_2	DEC	26	2	Planned Effort
38	PLANNED_EFFORT_YTD	☐	/RPM/TV_PLAN_EFFORT_YTD	/RPM/DEC_26_2	DEC	26	2	Planned Effort Year-To-Date
39	.INCLUDE	☐				0	0	Item Template Non Modifiable Attributes
40	RISK_GROUP	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
41	RISK_GROUP_D	☐	RPM_RISK_GROUP	RPM_RISK_GROUP	NUMC	2	0	Risk Group Assessed	*
42	DERIVED_RISK	☐	RPM_TV_RISK_DERIVED	NUMC3	NUMC	3	0	Derived Risk
43	BEGDA_DEM	☐	/RPM/TV_PP_START_DEM	DATUM	DATS	8	0	Demand Planning Start
44	ENDDA_DEM	☐	/RPM/TV_PP_END_DEM	DATUM	DATS	8	0	Demand Planning Period Finish Date
45	BEGDA_FIN	☐	/RPM/TV_PP_START_FIN	DATUM	DATS	8	0	Financial Planning Period Start
46	ENDDA_FIN	☐	/RPM/TV_PP_END_FIN	DATUM	DATS	8	0	Financial Plan Period Finish Date
47	PROPOSAL	☐	/RPM/TV_PROPOSAL	XFELD	CHAR	1	0	Proposal
48	BUCKET_NAME	☐	/RPM/TV_BUCKET_NAME	TEXT40	CHAR	40	0	Bucket Name
49	BUCKET_ID	☐	/RPM/TV_BUCKET_ID		CHAR	24	0	Bucket ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/RPM/TS_TEMPLATE_D_DATA	CAP_PERIODTYPE	/RPM/PERIOD_TYPE	PERIODTYPE	KEY	1	CN
2	/RPM/TS_TEMPLATE_D_DATA	CATEGORY	RPM_PROJ_CAT	CATEGORY	REF	1	CN
3	/RPM/TS_TEMPLATE_D_DATA	CURRENCY	/RPM/CURRENCY	CURRENCY	REF	1	CN
4	/RPM/TS_TEMPLATE_D_DATA	GEOGRAPHY	DPR_AREA	AREA	REF	1	CN
5	/RPM/TS_TEMPLATE_D_DATA	LOCATION	DPR_LOCATION	LOCATION	REF	1	CN
6	/RPM/TS_TEMPLATE_D_DATA	PERIODTYPE	/RPM/PERIOD_TYPE	PERIODTYPE	KEY	1	CN
7	/RPM/TS_TEMPLATE_D_DATA	PRIORITY_GROUP	RPM_PROJ_PRGRP	PRIORITY_GROUP	KEY	1	CN
8	/RPM/TS_TEMPLATE_D_DATA	PTYPE	RPM_PROJ_TYPE	PTYPE	KEY	1	CN
9	/RPM/TS_TEMPLATE_D_DATA	SUBCATEGORY	RPM_PROJ_SUBCAT	SUBCATEGORY	REF	1	CN
10	/RPM/TS_TEMPLATE_D_DATA	TTYPE	RPM_PROJ_TTYPE	TTYPE	REF	1	CN
11	/RPM/TS_TEMPLATE_D_DATA	UNIT	/RPM/CAP_UNITS	UNIT	REF

History

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