SAP ABAP Table /RPM/TS_ITEMS_DER_LIST (Item Data for Dashboard)
Hierarchy
☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ /RPM/OBJECTS (Package) xRPM Business Objects
Basic Data
Table Category INTTAB    Structure 
Structure /RPM/TS_ITEMS_DER_LIST   Table Relationship Diagram
Short Description Item Data for Dashboard    
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 dashboard Attributes without currency  
2 RISK_PRCNT RPM_RISK_LIMIT_HIGH NUMC3 NUMC 3   0   Risk Group - Upper Limit  
3 RISK_GROUP RPM_RISK_GROUP RPM_RISK_GROUP NUMC 2   0   Risk Group Assessed RPM_PROJ_RKGRP
4 RISK_ICON RPM_TV_RISK_ICON ICON CHAR 4   0   Project Risk *
5 DERIVED_RISK RPM_TV_RISK_DERIVED NUMC3 NUMC 3   0   Derived Risk  
6 HEADC_ACTUAL RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
7 PRIORITY_ICON RPM_TV_PRIORITY_ICON ICON CHAR 4   0   Priority *
8 PHASE_ICON RPM_TV_PHASE_ICON ICON CHAR 4   0   Stage *
9 PHASE_COLOR RPM_TV_STATUS_COLOR RPM_HTML_COLOR CHAR 7   0   Alert Object Color Status  
10 CHANGED_ON RPM_TV_TIMESTAMP RPM_BCOS_TSTMP DEC 15   0   Time Stamp  
11 BUDGET_ICON /RPM/TV_BUDGET_ICON ICON CHAR 4   0   Budget *
12 SCHEDULE_ICON /RPM/TV_SCHEDULE_ICON ICON CHAR 4   0   Schedule *
13 STAFFING_ICON /RPM/TV_STAFFING_ICON ICON CHAR 4   0   Staffing *
14 BUDGET_TOTAL /RPM/TV_BUDGET_TOTAL /RPM/CURR_16_2 CURR 16   2   Total Budget  
15 BUDGET_ANNUAL /RPM/TV_BUDGET_ANNUAL /RPM/CURR_16_2 CURR 16   2   Annual Budget  
16 PLANNED_COST /RPM/TV_PLANNED_COST /RPM/CURR_16_2 CURR 16   2   Planned Costs  
17 PLANNED_COST_YTD /RPM/TV_PLANNED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Planned Costs Year to Date  
18 ACTUAL_COST /RPM/TV_ACTUAL_COST /RPM/CURR_16_2 CURR 16   2   Actual Costs  
19 ACTUAL_COST_YTD /RPM/TV_ACTUAL_COST_YTD /RPM/CURR_16_2 CURR 16   2   Actual Cost Year to Day  
20 PROPOSAL /RPM/TV_PROPOSAL XFELD CHAR 1   0   Proposal  
21 STATUS_GROUP /RPM/TV_ITEM_STATUS_GROUP /RPM/ITEM_STATUS_GROUP CHAR 4   0   Status Group  
22 BUDGET_GROUP RPM_TV_BUDGET_GROUP RPM_BUDGET_GROUP NUMC 2   0   Budget Status Group RPM_PROJ_BDGRP
23 SCHEDULE_GROUP RPM_TV_SCHEDULE_GROUP RPM_SCHEDULE_GROUP NUMC 2   0   Schedule Status Group RPM_PROJ_SDGRP
24 STAFFING_GROUP RPM_TV_STAFFING_GROUP RPM_STAFFING_GROUP NUMC 2   0   Staffing Status Group RPM_PROJ_STGRP
25 FORCTED_DURATION /RPM/TV_FORCASTED_DURATION   QUAN 4   0   Forecasted Duration  
26 PLANNED_DURATION /RPM/TV_PLANNED_DURATION   QUAN 4   0   Planned Duration  
27 ACTUAL_DURATION /RPM/TV_ACTUAL_DURATION   QUAN 4   0   Actual Duration  
28 WORKEFFORT_TOTAL /RPM/TV_WORKEFFORT_TOTAL /RPM/DEC_26_8 DEC 26   8   Actual Effort  
29 WORKEFFORT_YTD /RPM/TV_WORKEFFORT_YTD /RPM/DEC_26_8 DEC 26   8   Work Effort Year-to-Date  
30 PLANNED_EFFORT /RPM/TV_PLANNED_EFFORT /RPM/DEC_26_8 DEC 26   8   Planned Effort  
31 PLANNED_EFRTYTD /RPM/TV_PLANNED_EFFORT_YTD /RPM/DEC_26_8 DEC 26   8   Planned Effort Year-to-Date  
32 PLANNED_REVENUE /RPM/TV_PLANNED_REVENUE /RPM/CURR_16_2 CURR 16   2   Planned Revenues  
33 PLANNED_REV_YTD /RPM/TV_PLANNED_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Planned Revenues Year to Date  
34 ACTUAL_REVENUE /RPM/TV_ACTUAL_REVENUE /RPM/CURR_16_2 CURR 16   2   Actual Revenues  
35 ACTUAL_REV_YTD /RPM/TV_ACTUAL_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Actual Revenues Year to Day  
36 .INCLUDE       0   0   Financial KPIs  
37 NPV_PLAN /RPM/TV_NPV_PLAN /RPM/CURR_16_2 CURR 16   2   Net Present Value  
38 IRR_PLAN /RPM/TV_IRR_PLAN /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in %  
39 ROI_PLAN /RPM/TV_ROI_PLAN /RPM/CURR_16_2 CURR 16   2   Return on Investment in %  
40 PAYBACK_PLAN /RPM/TV_PAYBACK_PLAN /RPM/TD_PBP_PLAN NUMC 6   0   Payback Periods in Months  
41 ECV_PLAN /RPM/TV_ECV_PLAN /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value  
42 .INCLUDE       0   0   Customer fields for KPI derived attributes  
43 EA_DUMMY_KPI CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
44 .INCLUDE       0   0    
45 DECSION_ID /RPM/TV_EXTID   CHAR 24   0   Business Object ID  
46 TEXT1 CGPL_TEXT1 TEXT40 CHAR 40   0   Language-Dependent Short Text  
47 LANGU LANGU SPRAS LANG 1   0   Language Key *
48 .INCLUDE       0   0   Operational item persisted data  
49 CLIENT MANDT MANDT CLNT 3   0   Client *
50 GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
51 .INCLUDE       0   0   Item Detail Attributes  
52 .INCLUDE       0   0   Portfolio object key attributes  
53 EXTERNAL_ID /RPM/TV_EXTID   CHAR 24   0   Business Object ID  
54 PORTFOLIO_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
55 PARENT_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
56 CATEGORY RPM_PROJECT_CATEGORY RPM_PROJECT_CATEGORY NUMC 4   0   Category *
57 SUBCATEGORY RPM_PROJ_SUBCATEGORY RPM_SUBCATEGORY NUMC 4   0   Subcategory *
58 PHASE RPM_PROJECT_PHASE RPM_PROJECT_PHASE NUMC 4   0   Stage *
59 PTYPE RPM_PROJECTTYPE RPM_PROJECTTYPE NUMC 4   0   Group *
60 TTYPE RPM_PROJECT_TECHTYPE RPM_PROJECT_TECHTYPE NUMC 4   0   Technology Type *
61 RISKA RPM_PROJECT_RISK_ASSESED NUMC3 NUMC 3   0   Assessed Project Risk  
62 PROBT RPM_PROJECT_PROB_TECH NUMC3 NUMC 3   0   Probability of Technical Success  
63 PROBC RPM_PROJECT_PROB_COMM NUMC3 NUMC 3   0   Probability of Commercial Success  
64 HEADC RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
65 COSTD RPM_PROJECT_COST_DEVELOPMENT /RPM/CURR_16_2 CURR 16   2   Development Cost  
66 COSTL RPM_PROJECT_COST_LAUNCH /RPM/CURR_16_2 CURR 16   2   Launch Cost  
67 NPV RPM_PROJECT_NPV /RPM/CURR_16_2 CURR 16   2   Net Present Value (manual)  
68 CURRENCY RPM_TV_CURRENCY WAERS CUKY 5   0   Currency key *
69 LOCATION RPM_TV_PROJECT_LOCATION RPM_PROJECT_LOCATION CHAR 4   0   Project Location *
70 GEOGRAPHY RPM_TV_PROJECT_GEOGRAPHY RPM_PROJECT_GEOGRAPHY CHAR 4   0   Project Geography *
71 RPM_CHANGED_ON RPM_TV_TIMESTAMP RPM_BCOS_TSTMP DEC 15   0   Time Stamp  
72 PERIODTYPE /RPM/TV_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Financial Period Breakdown *
73 UNIT RPM_TV_UNIT MEINS UNIT 3   0   Unit *
74 FORECAST_START RPM_TV_FORECAST_START DATS DATS 8   0   Forecasted Start  
75 PLANNED_START RPM_TV_PLAN_START DATS DATS 8   0   Planned Start Date  
76 ACTUAL_START RPM_TV_ACTUAL_START   DATS 8   0   Actual Start Date  
77 FORECAST_FINISH RPM_TV_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
78 PLANNED_FINISH RPM_TV_PLAN_FINISH DATS DATS 8   0   Planned Finish Date  
79 ACTUAL_FINISH RPM_TV_ACTUAL_FINISH   DATS 8   0   Actual Finish Date  
80 ESCALATION RPM_TV_ESCALATION XFELD CHAR 1   0   Escalation Flag  
81 ITEM_TYPE /RPM/TV_ITEM_ID /RPM/TD_ITEM_TYPE CHAR 15   0   Type *
82 PORTFL_ITEM_GUID RPM_TV_GUID RPM_GUID RAW 16   0   Guid for application objects  
83 ECV RPM_TV_ECV /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value (manual)  
84 PRIORITY_GROUP RPM_PRIORITY_GROUP RPM_PRIORITY_GROUP NUMC 2   0   Priority Group *
85 CHANGED_BY RPM_TV_CHANGED_BY XUBNAME CHAR 12   0   Last Changed By *
86 VERSION_ITEM RPM_TV_VERSION_FLAG CHAR1 CHAR 1   0   Project Version Flag  
87 ITEM_CLASS /RPM/TV_ITEM_CLASS /RPM/TD_ITEM_CLASS CHAR 1   0   Item Classification  
88 MASTER_ITEM_GUID RPM_TV_GUID RPM_GUID RAW 16   0   Guid for application objects  
89 STATUS /RPM/TV_STATUS_COMMON /RPM/TD_STATUS_COMMON CHAR 5   0   Status *
90 CAP_PERIODTYPE /RPM/TV_CAP_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Capacity Period Breakdown *
91 INITIATIVE_GUID RPM_TV_GUID RPM_GUID RAW 16   0   Guid for application objects  
92 DISCOUNT_RATE /RPM/TV_DISCOUNT_RATE /RPM/DEC_5_2 DEC 5   2   Discount Rate  
93 ACT_DPCPT_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
94 FRCST_BGT_TOTAL /RPM/TV_FORECASTED_BUDGT_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Total  
95 FRCST_BGTANNUAL /RPM/TV_FORECASTED_BUDGT_ANNL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Annual  
96 FRCST_COSTTOTAL /RPM/TV_FORECASTED_COST_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost Total  
97 FRCST_COST_YTD /RPM/TV_FORECASTED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost YTD  
98 TEMPLATE_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
99 IS_GLOBAL /RPM/TV_GLOBAL XFELD CHAR 1   0   Global Template  
100 .INCLUDE       0   0   Item Detail Customer Fields  
101 EA_DUMMY /RPM/TV_EA_DUMMY CHAR1 CHAR 1   0   Dummy Data Element for Enhanced xRPM Attributes  
102 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /RPM/TS_ITEMS_DER_LIST BUDGET_GROUP RPM_PROJ_BDGRP BUDGET_GROUP KEY 1 CN
2 /RPM/TS_ITEMS_DER_LIST RISK_GROUP RPM_PROJ_RKGRP RISK_GROUP KEY 1 CN
3 /RPM/TS_ITEMS_DER_LIST SCHEDULE_GROUP RPM_PROJ_SDGRP SCHED_GROUP KEY 1 CN
4 /RPM/TS_ITEMS_DER_LIST STAFFING_GROUP RPM_PROJ_STGRP STAFFING_GROUP KEY 1 CN
History
Last changed by/on SAP  20141109 
SAP Release Created in