SAP ABAP Table /RPM/TS_ITEM_D_DATA (Item/Initiative Business 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_ITEM_D_DATA   Table Relationship Diagram
Short Description Item/Initiative Business 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   Item/Initiative Attributes  
2 CATEGORY RPM_PROJECT_CATEGORY RPM_PROJECT_CATEGORY NUMC 4   0   Category RPM_PROJ_CAT
3 SUBCATEGORY RPM_PROJ_SUBCATEGORY RPM_SUBCATEGORY NUMC 4   0   Subcategory RPM_PROJ_SUBCAT
4 PHASE RPM_PROJECT_PHASE RPM_PROJECT_PHASE NUMC 4   0   Stage RPM_PROJ_PHASE
5 PTYPE RPM_PROJECTTYPE RPM_PROJECTTYPE NUMC 4   0   Group RPM_PROJ_TYPE
6 TTYPE RPM_PROJECT_TECHTYPE RPM_PROJECT_TECHTYPE NUMC 4   0   Technology Type RPM_PROJ_TTYPE
7 RISKA RPM_PROJECT_RISK_ASSESED NUMC3 NUMC 3   0   Assessed Project Risk  
8 PROBT RPM_PROJECT_PROB_TECH NUMC3 NUMC 3   0   Probability of Technical Success  
9 PROBC RPM_PROJECT_PROB_COMM NUMC3 NUMC 3   0   Probability of Commercial Success  
10 HEADC /RPM/PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Headcount  
11 COSTD RPM_PROJECT_COST_DEVELOPMENT /RPM/CURR_16_2 CURR 16   2   Development Cost  
12 COSTL RPM_PROJECT_COST_LAUNCH /RPM/CURR_16_2 CURR 16   2   Launch Cost  
13 NPV RPM_PROJECT_NPV /RPM/CURR_16_2 CURR 16   2   Net Present Value (manual)  
14 CURRENCY RPM_TV_CURRENCY WAERS CUKY 5   0   Currency key /RPM/CURRENCY
15 LOCATION DPR_TV_LOCATION DPR_LOCATION CHAR 4   0   Location DPR_LOCATION
16 GEOGRAPHY DPR_TV_AREA DPR_AREA CHAR 4   0   Area DPR_AREA
17 PERIODTYPE /RPM/TV_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Financial Period Breakdown /RPM/PERIOD_TYPE
18 UNIT /RPM/TV_TIME_UNIT MEINS UNIT 3   0   Time Unit /RPM/CAP_UNITS
19 ESCALATION RPM_TV_ESCALATION XFELD CHAR 1   0   Escalation Flag  
20 FORECAST_START RPM_TV_FORECAST_START DATS DATS 8   0   Forecasted Start  
21 PLANNED_START RPM_TV_PLAN_START DATS DATS 8   0   Planned Start Date  
22 ACTUAL_START RPM_TV_ACTUAL_START   DATS 8   0   Actual Start Date  
23 FORECAST_FINISH RPM_TV_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
24 PLANNED_FINISH RPM_TV_PLAN_FINISH DATS DATS 8   0   Planned Finish Date  
25 ACTUAL_FINISH RPM_TV_ACTUAL_FINISH   DATS 8   0   Actual Finish Date  
26 ECV RPM_TV_ECV /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value (manual)  
27 PRIORITY_GROUP RPM_PRIORITY_GROUP RPM_PRIORITY_GROUP NUMC 2   0   Priority Group RPM_PROJ_PRGRP
28 ITEM_CLASS /RPM/TV_ITEM_CLASS /RPM/TD_ITEM_CLASS CHAR 1   0   Item Classification  
29 MASTER_ITEM_GUID RPM_TV_GUID RPM_GUID RAW 16   0   Guid for application objects  
30 STATUS /RPM/TV_STATUS_COMMON /RPM/TD_STATUS_COMMON CHAR 5   0   Status /RPM/STATUS
31 VERSION_ITEM /RPM/TV_VERSION_ITEM XFELD CHAR 1   0   Version Item Indicator  
32 CAP_PERIODTYPE /RPM/TV_CAP_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Capacity Period Breakdown /RPM/PERIOD_TYPE
33 DAYS_UNTIL_PLAN_FINISH /RPM/TV_D_LEFT_PLAN_FINISH   INT4 10   0   Days Until Finish  
34 DAYS_UNTIL_NEXT_DECISION /RPM/TV_D_LEFT_NEXT_DECISION   INT4 10   0   Days Until Next Decision  
35 DISCOUNT_RATE /RPM/TV_DISCOUNT_RATE /RPM/DEC_5_2 DEC 5   2   Discount Rate  
36 INITIATIVE_GUID RPM_TV_GUID RPM_GUID RAW 16   0   Guid for application objects  
37 ACT_DPCPT_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
38 FRCST_BGT_TOTAL /RPM/TV_FORECASTED_BUDGT_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Total  
39 FRCST_BGTANNUAL /RPM/TV_FORECASTED_BUDGT_ANNL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Annual  
40 FRCST_COSTTOTAL /RPM/TV_FORECASTED_COST_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost Total  
41 FRCST_COST_YTD /RPM/TV_FORECASTED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost YTD  
42 TEMPLATE_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
43 .INCLUDE       0   0   Item/Initiative Attributes; derrived  
44 PRIORITY_ICON /RPM/TV_PRIORITY_ICON ICON CHAR 4   0   Priority *
45 RISK_PRCNT RPM_RISK_LIMIT_HIGH NUMC3 NUMC 3   0   Risk Group - Upper Limit  
46 RISK_GROUP RPM_RISK_GROUP RPM_RISK_GROUP NUMC 2   0   Risk Group Assessed RPM_PROJ_RKGRP
47 RISK_ICON /RPM/TV_RISK_ICON ICON CHAR 4   0   Risk *
48 PHASE_ICON /RPM/TV_PHASE_ICON ICON CHAR 4   0   Phase *
49 PHASE_COLOR RPM_TV_STATUS_COLOR RPM_HTML_COLOR CHAR 7   0   Alert Object Color Status  
50 DERIVED_RISK RPM_TV_RISK_DERIVED NUMC3 NUMC 3   0   Derived Risk  
51 D_PLANSTART /RPM/TV_DP_PLAN_START DATUM DATS 8   0   Planned Start  
52 D_PLANFINISH /RPM/TV_DP_PLAN_FINISH DATUM DATS 8   0   Planned Finish  
53 D_ACTUALSTART /RPM/TV_DP_ACTUAL_START DATUM DATS 8   0   Actual Start  
54 D_ACTUALFINISH /RPM/TV_DP_ACTUAL_FINISH DATUM DATS 8   0   Actual Finish Date  
55 HEADC_ACTUAL RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
56 BEGDA_DEM /RPM/TV_PP_START_DEM DATUM DATS 8   0   Demand Planning Start  
57 ENDDA_DEM /RPM/TV_PP_END_DEM DATUM DATS 8   0   Demand Planning Period Finish Date  
58 BEGDA_FIN /RPM/TV_PP_START_FIN DATUM DATS 8   0   Financial Planning Period Start  
59 ENDDA_FIN /RPM/TV_PP_END_FIN DATUM DATS 8   0   Financial Plan Period Finish Date  
60 BUCKET_NAME /RPM/TV_BUCKET_NAME TEXT40 CHAR 40   0   Bucket Name  
61 BUCKET_ID /RPM/TV_BUCKET_ID   CHAR 24   0   Bucket ID  
62 PROPOSAL /RPM/TV_PROPOSAL XFELD CHAR 1   0   Proposal  
63 D_CHANGED_ON /RPM/TV_LAST_CHANGED_ON DATUM DATS 8   0   Changed On Date  
64 MASTER_ITEM_NAME /RPM/TV_MASTER_ITEM_NAME TEXT40 CHAR 40   0   Initiative Name  
65 MASTER_ITEM_ID /RPM/TV_MASTER_ITEM_ID   CHAR 24   0   Initiative ID  
66 HAS_CHILDREN /RPM/TV_ITEM_CHILDREN XFELD CHAR 1   0   Has Children  
67 BUDGET_ICON /RPM/TV_BUDGET_ICON ICON CHAR 4   0   Budget *
68 SCHEDULE_ICON /RPM/TV_SCHEDULE_ICON ICON CHAR 4   0   Schedule *
69 STAFFING_ICON /RPM/TV_STAFFING_ICON ICON CHAR 4   0   Staffing *
70 BUDGET_TOTAL /RPM/TV_BUDGET_TOTAL /RPM/CURR_16_2 CURR 16   2   Total Budget  
71 BUDGET_ANNUAL /RPM/TV_BUDGET_ANNUAL /RPM/CURR_16_2 CURR 16   2   Annual Budget  
72 PLANNED_COST /RPM/TV_PLANNED_COST /RPM/CURR_16_2 CURR 16   2   Planned Costs  
73 PLANNED_COST_YTD /RPM/TV_PLANNED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Planned Costs Year to Date  
74 ACTUAL_COST /RPM/TV_ACTUAL_COST /RPM/CURR_16_2 CURR 16   2   Actual Costs  
75 ACTUAL_COST_YTD /RPM/TV_ACTUAL_COST_YTD /RPM/CURR_16_2 CURR 16   2   Actual Cost Year to Day  
76 ACT_DECPT_NAME /RPM/TV_PHASE_T TEXT80 CHAR 80   0   Decision Point Name  
77 ACT_DECPT_STAT_TEXT /RPM/TV_STATUS_TEXT CHAR40 CHAR 40   0   Active Decision Point Status Text  
78 ACT_DECPT_STAT_ICON /RPM/TV_DECPT_STATUS_ICON ICON CHAR 4   0   Active Decision Point Status *
79 DECPT_INFO /RPM/TV_DECPT_INFO CHAR20 CHAR 20   0   Decision Point Info  
80 STATUS_GROUP /RPM/TV_ITEM_STATUS_GROUP /RPM/ITEM_STATUS_GROUP CHAR 4   0   Status Group  
81 FORECASTED_DURATION /RPM/TV_FORCASTED_DURATION   QUAN 4   0   Forecasted Duration  
82 PLANNED_DURATION /RPM/TV_PLANNED_DURATION   QUAN 4   0   Planned Duration  
83 ACTUAL_DURATION /RPM/TV_ACTUAL_DURATION   QUAN 4   0   Actual Duration  
84 ACT_PHASE_GUID DPR_TV_GUID DPR_GUID RAW 16   0   Application Object GUID  
85 WORKEFFORT_TOTAL /RPM/TV_WORK_EFFORT_TOTAL /RPM/DEC_26_2 DEC 26   2   Actual Effort  
86 WORKEFFORT_YTD /RPM/TV_WORK_EFFORT_YTD /RPM/DEC_26_2 DEC 26   2   Actual Work Effort Year-To-Date  
87 PLANNED_EFFORT /RPM/TV_PLAN_EFFORT /RPM/DEC_26_2 DEC 26   2   Planned Effort  
88 PLANNED_EFFORT_YTD /RPM/TV_PLAN_EFFORT_YTD /RPM/DEC_26_2 DEC 26   2   Planned Effort Year-To-Date  
89 ROI /RPM/TV_ROI /RPM/CURR_16_2 CURR 16   2   Return on Investment in % (manual)  
90 IRR /RPM/TV_IRR /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in % (manual)  
91 RISK_GROUP_D /RPM/RISK_GROUP_D RPM_RISK_GROUP NUMC 2   0   Risk Group Derived RPM_PROJ_RKGRP
92 RISK_D_ICON /RPM/TV_RISK_ICON_D ICON CHAR 4   0   Derived Risk *
93 PLANNED_DECISION_DATE /RPM/TV_PLAND_DDATE DATUM DATS 8   0   Planned Decision date  
94 ACTUAL_DECISION_DATE /RPM/TV_ACTUAL_DDATE DATUM DATS 8   0   Actual Decision Date  
95 FORECAST_DEC_DATE /RPM/TV_FORECAST_DDATE DATUM DATS 8   0   Forecasted Decision Date  
96 D_FORECASTED_START RPM_TV_DP_FORECAST_START DATS DATS 8   0   Forecasted Start  
97 D_FORECASTED_FINISH RPM_TV_DP_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
98 BUDGET_GROUP RPM_TV_BUDGET_GROUP RPM_BUDGET_GROUP NUMC 2   0   Budget Status Group RPM_PROJ_BDGRP
99 SCHEDULE_GROUP RPM_TV_SCHEDULE_GROUP RPM_SCHEDULE_GROUP NUMC 2   0   Schedule Status Group RPM_PROJ_SDGRP
100 STAFFING_GROUP RPM_TV_STAFFING_GROUP RPM_STAFFING_GROUP NUMC 2   0   Staffing Status Group RPM_PROJ_STGRP
101 PORTFOLIO_NAME /RPM/TV_PORTFOLIO_NAME TEXT40 CHAR 40   0   Portfolio Name  
102 PORTFOLIO_ID /RPM/TV_PORTFOLIO_ID   CHAR 24   0   Portfolio ID  
103 PLANNED_REVENUE /RPM/TV_PLANNED_REVENUE /RPM/CURR_16_2 CURR 16   2   Planned Revenues  
104 PLANNED_REV_YTD /RPM/TV_PLANNED_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Planned Revenues Year to Date  
105 ACTUAL_REVENUE /RPM/TV_ACTUAL_REVENUE /RPM/CURR_16_2 CURR 16   2   Actual Revenues  
106 ACTUAL_REV_YTD /RPM/TV_ACTUAL_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Actual Revenues Year to Day  
107 .INCLUDE       0   0   Financial KPIs  
108 NPV_PLAN /RPM/TV_NPV_PLAN /RPM/CURR_16_2 CURR 16   2   Net Present Value  
109 IRR_PLAN /RPM/TV_IRR_PLAN /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in %  
110 ROI_PLAN /RPM/TV_ROI_PLAN /RPM/CURR_16_2 CURR 16   2   Return on Investment in %  
111 PAYBACK_PLAN /RPM/TV_PAYBACK_PLAN /RPM/TD_PBP_PLAN NUMC 6   0   Payback Periods in Months  
112 ECV_PLAN /RPM/TV_ECV_PLAN /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value  
113 .INCLUDE       0   0   Customer fields for KPI derived attributes  
114 EA_DUMMY_KPI CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
115 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /RPM/TS_ITEM_D_DATA BUDGET_GROUP RPM_PROJ_BDGRP BUDGET_GROUP KEY 1 CN
2 /RPM/TS_ITEM_D_DATA CAP_PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
3 /RPM/TS_ITEM_D_DATA CATEGORY RPM_PROJ_CAT CATEGORY REF 1 CN
4 /RPM/TS_ITEM_D_DATA CURRENCY /RPM/CURRENCY CURRENCY REF 1 CN
5 /RPM/TS_ITEM_D_DATA GEOGRAPHY DPR_AREA AREA REF 1 CN
6 /RPM/TS_ITEM_D_DATA LOCATION DPR_LOCATION LOCATION REF 1 CN
7 /RPM/TS_ITEM_D_DATA PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
8 /RPM/TS_ITEM_D_DATA PHASE RPM_PROJ_PHASE PHASE REF 1 CN
9 /RPM/TS_ITEM_D_DATA PRIORITY_GROUP RPM_PROJ_PRGRP PRIORITY_GROUP KEY 1 CN
10 /RPM/TS_ITEM_D_DATA PTYPE RPM_PROJ_TYPE PTYPE KEY 1 CN
11 /RPM/TS_ITEM_D_DATA RISK_GROUP RPM_PROJ_RKGRP RISK_GROUP KEY 1 CN
12 /RPM/TS_ITEM_D_DATA RISK_GROUP_D RPM_PROJ_RKGRP RISK_GROUP KEY 1 CN
13 /RPM/TS_ITEM_D_DATA SCHEDULE_GROUP RPM_PROJ_SDGRP SCHED_GROUP KEY 1 CN
14 /RPM/TS_ITEM_D_DATA STAFFING_GROUP RPM_PROJ_STGRP STAFFING_GROUP KEY 1 CN
15 /RPM/TS_ITEM_D_DATA STATUS /RPM/STATUS STATUS KEY 1 CN
16 /RPM/TS_ITEM_D_DATA SUBCATEGORY RPM_PROJ_SUBCAT SUBCATEGORY REF 1 CN
17 /RPM/TS_ITEM_D_DATA TTYPE RPM_PROJ_TTYPE TTYPE REF 1 CN
18 /RPM/TS_ITEM_D_DATA UNIT /RPM/CAP_UNITS UNIT REF    
History
Last changed by/on SAP  20141109 
SAP Release Created in 400