SAP ABAP Table /RPM/TS_ITEM_D_DERIVED_ATT (Item/Initiative Attributes; derrived)
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_DERIVED_ATT   Table Relationship Diagram
Short Description Item/Initiative Attributes; derrived    
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 PRIORITY_ICON /RPM/TV_PRIORITY_ICON ICON CHAR 4   0   Priority *
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   Risk *
5 PHASE_ICON /RPM/TV_PHASE_ICON ICON CHAR 4   0   Phase *
6 PHASE_COLOR RPM_TV_STATUS_COLOR RPM_HTML_COLOR CHAR 7   0   Alert Object Color Status  
7 DERIVED_RISK RPM_TV_RISK_DERIVED NUMC3 NUMC 3   0   Derived Risk  
8 D_PLANSTART /RPM/TV_DP_PLAN_START DATUM DATS 8   0   Planned Start  
9 D_PLANFINISH /RPM/TV_DP_PLAN_FINISH DATUM DATS 8   0   Planned Finish  
10 D_ACTUALSTART /RPM/TV_DP_ACTUAL_START DATUM DATS 8   0   Actual Start  
11 D_ACTUALFINISH /RPM/TV_DP_ACTUAL_FINISH DATUM DATS 8   0   Actual Finish Date  
12 HEADC_ACTUAL RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
13 BEGDA_DEM /RPM/TV_PP_START_DEM DATUM DATS 8   0   Demand Planning Start  
14 ENDDA_DEM /RPM/TV_PP_END_DEM DATUM DATS 8   0   Demand Planning Period Finish Date  
15 BEGDA_FIN /RPM/TV_PP_START_FIN DATUM DATS 8   0   Financial Planning Period Start  
16 ENDDA_FIN /RPM/TV_PP_END_FIN DATUM DATS 8   0   Financial Plan Period Finish Date  
17 BUCKET_NAME /RPM/TV_BUCKET_NAME TEXT40 CHAR 40   0   Bucket Name  
18 BUCKET_ID /RPM/TV_BUCKET_ID   CHAR 24   0   Bucket ID  
19 PROPOSAL /RPM/TV_PROPOSAL XFELD CHAR 1   0   Proposal  
20 D_CHANGED_ON /RPM/TV_LAST_CHANGED_ON DATUM DATS 8   0   Changed On Date  
21 MASTER_ITEM_NAME /RPM/TV_MASTER_ITEM_NAME TEXT40 CHAR 40   0   Initiative Name  
22 MASTER_ITEM_ID /RPM/TV_MASTER_ITEM_ID   CHAR 24   0   Initiative ID  
23 HAS_CHILDREN /RPM/TV_ITEM_CHILDREN XFELD CHAR 1   0   Has Children  
24 BUDGET_ICON /RPM/TV_BUDGET_ICON ICON CHAR 4   0   Budget *
25 SCHEDULE_ICON /RPM/TV_SCHEDULE_ICON ICON CHAR 4   0   Schedule *
26 STAFFING_ICON /RPM/TV_STAFFING_ICON ICON CHAR 4   0   Staffing *
27 BUDGET_TOTAL /RPM/TV_BUDGET_TOTAL /RPM/CURR_16_2 CURR 16   2   Total Budget  
28 BUDGET_ANNUAL /RPM/TV_BUDGET_ANNUAL /RPM/CURR_16_2 CURR 16   2   Annual Budget  
29 PLANNED_COST /RPM/TV_PLANNED_COST /RPM/CURR_16_2 CURR 16   2   Planned Costs  
30 PLANNED_COST_YTD /RPM/TV_PLANNED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Planned Costs Year to Date  
31 ACTUAL_COST /RPM/TV_ACTUAL_COST /RPM/CURR_16_2 CURR 16   2   Actual Costs  
32 ACTUAL_COST_YTD /RPM/TV_ACTUAL_COST_YTD /RPM/CURR_16_2 CURR 16   2   Actual Cost Year to Day  
33 ACT_DECPT_NAME /RPM/TV_PHASE_T TEXT80 CHAR 80   0   Decision Point Name  
34 ACT_DECPT_STAT_TEXT /RPM/TV_STATUS_TEXT CHAR40 CHAR 40   0   Active Decision Point Status Text  
35 ACT_DECPT_STAT_ICON /RPM/TV_DECPT_STATUS_ICON ICON CHAR 4   0   Active Decision Point Status *
36 DECPT_INFO /RPM/TV_DECPT_INFO CHAR20 CHAR 20   0   Decision Point Info  
37 STATUS_GROUP /RPM/TV_ITEM_STATUS_GROUP /RPM/ITEM_STATUS_GROUP CHAR 4   0   Status Group  
38 FORECASTED_DURATION /RPM/TV_FORCASTED_DURATION   QUAN 4   0   Forecasted Duration  
39 PLANNED_DURATION /RPM/TV_PLANNED_DURATION   QUAN 4   0   Planned Duration  
40 ACTUAL_DURATION /RPM/TV_ACTUAL_DURATION   QUAN 4   0   Actual Duration  
41 ACT_PHASE_GUID DPR_TV_GUID DPR_GUID RAW 16   0   Application Object GUID  
42 WORKEFFORT_TOTAL /RPM/TV_WORK_EFFORT_TOTAL /RPM/DEC_26_2 DEC 26   2   Actual Effort  
43 WORKEFFORT_YTD /RPM/TV_WORK_EFFORT_YTD /RPM/DEC_26_2 DEC 26   2   Actual Work Effort Year-To-Date  
44 PLANNED_EFFORT /RPM/TV_PLAN_EFFORT /RPM/DEC_26_2 DEC 26   2   Planned Effort  
45 PLANNED_EFFORT_YTD /RPM/TV_PLAN_EFFORT_YTD /RPM/DEC_26_2 DEC 26   2   Planned Effort Year-To-Date  
46 ROI /RPM/TV_ROI /RPM/CURR_16_2 CURR 16   2   Return on Investment in % (manual)  
47 IRR /RPM/TV_IRR /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in % (manual)  
48 RISK_GROUP_D /RPM/RISK_GROUP_D RPM_RISK_GROUP NUMC 2   0   Risk Group Derived RPM_PROJ_RKGRP
49 RISK_D_ICON /RPM/TV_RISK_ICON_D ICON CHAR 4   0   Derived Risk *
50 PLANNED_DECISION_DATE /RPM/TV_PLAND_DDATE DATUM DATS 8   0   Planned Decision date  
51 ACTUAL_DECISION_DATE /RPM/TV_ACTUAL_DDATE DATUM DATS 8   0   Actual Decision Date  
52 FORECAST_DEC_DATE /RPM/TV_FORECAST_DDATE DATUM DATS 8   0   Forecasted Decision Date  
53 D_FORECASTED_START RPM_TV_DP_FORECAST_START DATS DATS 8   0   Forecasted Start  
54 D_FORECASTED_FINISH RPM_TV_DP_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
55 BUDGET_GROUP RPM_TV_BUDGET_GROUP RPM_BUDGET_GROUP NUMC 2   0   Budget Status Group RPM_PROJ_BDGRP
56 SCHEDULE_GROUP RPM_TV_SCHEDULE_GROUP RPM_SCHEDULE_GROUP NUMC 2   0   Schedule Status Group RPM_PROJ_SDGRP
57 STAFFING_GROUP RPM_TV_STAFFING_GROUP RPM_STAFFING_GROUP NUMC 2   0   Staffing Status Group RPM_PROJ_STGRP
58 PORTFOLIO_NAME /RPM/TV_PORTFOLIO_NAME TEXT40 CHAR 40   0   Portfolio Name  
59 PORTFOLIO_ID /RPM/TV_PORTFOLIO_ID   CHAR 24   0   Portfolio ID  
60 PLANNED_REVENUE /RPM/TV_PLANNED_REVENUE /RPM/CURR_16_2 CURR 16   2   Planned Revenues  
61 PLANNED_REV_YTD /RPM/TV_PLANNED_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Planned Revenues Year to Date  
62 ACTUAL_REVENUE /RPM/TV_ACTUAL_REVENUE /RPM/CURR_16_2 CURR 16   2   Actual Revenues  
63 ACTUAL_REV_YTD /RPM/TV_ACTUAL_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Actual Revenues Year to Day  
64 .INCLUDE       0   0   Financial KPIs  
65 NPV_PLAN /RPM/TV_NPV_PLAN /RPM/CURR_16_2 CURR 16   2   Net Present Value  
66 IRR_PLAN /RPM/TV_IRR_PLAN /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in %  
67 ROI_PLAN /RPM/TV_ROI_PLAN /RPM/CURR_16_2 CURR 16   2   Return on Investment in %  
68 PAYBACK_PLAN /RPM/TV_PAYBACK_PLAN /RPM/TD_PBP_PLAN NUMC 6   0   Payback Periods in Months  
69 ECV_PLAN /RPM/TV_ECV_PLAN /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value  
70 .INCLUDE       0   0   Customer fields for KPI derived attributes  
71 EA_DUMMY_KPI CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
72 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /RPM/TS_ITEM_D_DERIVED_ATT BUDGET_GROUP RPM_PROJ_BDGRP BUDGET_GROUP KEY 1 CN
2 /RPM/TS_ITEM_D_DERIVED_ATT RISK_GROUP RPM_PROJ_RKGRP RISK_GROUP KEY 1 CN
3 /RPM/TS_ITEM_D_DERIVED_ATT RISK_GROUP_D RPM_PROJ_RKGRP RISK_GROUP KEY 1 CN
4 /RPM/TS_ITEM_D_DERIVED_ATT SCHEDULE_GROUP RPM_PROJ_SDGRP SCHED_GROUP KEY 1 CN
5 /RPM/TS_ITEM_D_DERIVED_ATT STAFFING_GROUP RPM_PROJ_STGRP STAFFING_GROUP KEY 1 CN
History
Last changed by/on SAP  20141109 
SAP Release Created in 400