SAP ABAP Table /RPM/TS_ITEM_API_REP (Portfolio Item Attributes for Reporting)
Hierarchy
☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ /RPM/REPORTING (Package) xRPM Reporting
Basic Data
Table Category INTTAB    Structure 
Structure /RPM/TS_ITEM_API_REP   Table Relationship Diagram
Short Description Portfolio Item Attributes for Reporting    
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 GUID RPM_TV_GUID RPM_GUID RAW 16   0   Guid for application objects  
2 PORTFL_ITEM_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 PORTFOLIO_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
5 PARENT_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
6 PROJ_DESCRIPTION RPM_TV_PROJ_DESCRIPTION TEXT40 CHAR 40   0   Item Name  
7 CHANGED_BY UNAME UNAME CHAR 12   0   User Name  
8 ITEM_TYPE /RPM/TV_ITEM_ID /RPM/TD_ITEM_TYPE CHAR 15   0   Type /RPM/ITEM_TYPE
9 CATEGORY RPM_PROJECT_CATEGORY RPM_PROJECT_CATEGORY NUMC 4   0   Category RPM_PROJ_CAT
10 SUBCATEGORY RPM_PROJ_SUBCATEGORY RPM_SUBCATEGORY NUMC 4   0   Subcategory RPM_PROJ_SUBCAT
11 PHASE RPM_PROJECT_PHASE RPM_PROJECT_PHASE NUMC 4   0   Stage RPM_PROJ_PHASE
12 PTYPE RPM_PROJECTTYPE RPM_PROJECTTYPE NUMC 4   0   Group RPM_PROJ_TYPE
13 TTYPE RPM_PROJECT_TECHTYPE RPM_PROJECT_TECHTYPE NUMC 4   0   Technology Type RPM_PROJ_TTYPE
14 HEADC /RPM/PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Headcount  
15 COSTD RPM_PROJECT_COST_DEVELOPMENT /RPM/CURR_16_2 CURR 16   2   Development Cost  
16 COSTL RPM_PROJECT_COST_LAUNCH /RPM/CURR_16_2 CURR 16   2   Launch Cost  
17 NPV RPM_PROJECT_NPV /RPM/CURR_16_2 CURR 16   2   Net Present Value (manual)  
18 CURRENCY RPM_TV_CURRENCY WAERS CUKY 5   0   Currency key /RPM/CURRENCY
19 LOCATION DPR_TV_LOCATION DPR_LOCATION CHAR 4   0   Location DPR_LOCATION
20 GEOGRAPHY DPR_TV_AREA DPR_AREA CHAR 4   0   Area DPR_AREA
21 PERIODTYPE /RPM/TV_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Financial Period Breakdown /RPM/PERIOD_TYPE
22 UNIT /RPM/TV_TIME_UNIT MEINS UNIT 3   0   Time Unit /RPM/CAP_UNITS
23 ESCALATION RPM_TV_ESCALATION XFELD CHAR 1   0   Escalation Flag  
24 FORECAST_START RPM_TV_FORECAST_START DATS DATS 8   0   Forecasted Start  
25 PLANNED_START RPM_TV_PLAN_START DATS DATS 8   0   Planned Start Date  
26 ACTUAL_START RPM_TV_ACTUAL_START   DATS 8   0   Actual Start Date  
27 FORECAST_FINISH RPM_TV_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
28 PLANNED_FINISH RPM_TV_PLAN_FINISH DATS DATS 8   0   Planned Finish Date  
29 ACTUAL_FINISH RPM_TV_ACTUAL_FINISH   DATS 8   0   Actual Finish Date  
30 ECV RPM_TV_ECV /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value (manual)  
31 PRIORITY_GROUP RPM_PRIORITY_GROUP RPM_PRIORITY_GROUP NUMC 2   0   Priority Group RPM_PROJ_PRGRP
32 ITEM_CLASS /RPM/TV_ITEM_CLASS /RPM/TD_ITEM_CLASS CHAR 1   0   Item Classification  
33 STATUS /RPM/TV_STATUS_COMMON /RPM/TD_STATUS_COMMON CHAR 5   0   Status /RPM/STATUS
34 CAP_PERIODTYPE /RPM/TV_CAP_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Capacity Period Breakdown /RPM/PERIOD_TYPE
35 DAYS_UNTIL_PLAN_FINISH /RPM/TV_D_LEFT_PLAN_FINISH   INT4 10   0   Days Until Finish  
36 DAYS_UNTIL_NEXT_DECISION /RPM/TV_D_LEFT_NEXT_DECISION   INT4 10   0   Days Until Next Decision  
37 DISCOUNT_RATE /RPM/TV_DISCOUNT_RATE /RPM/DEC_5_2 DEC 5   2   Discount Rate  
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 RISKA /RPM/TV_PROJECT_RISKA   DEC 4   0   Assessed Project Risk  
43 PROBT /RPM/TV_PROJECT_PROBT   DEC 4   0   Probability of Technical Success  
44 PROBC /RPM/TV_PROJECT_PROBC   DEC 4   0   Probability of Commercial Success  
45 RISK_PRCNT /RPM/TV_RISK_LIMIT_HIGH   DEC 4   0   Risk Group - Upper Limit  
46 RISK_GROUP RPM_RISK_GROUP RPM_RISK_GROUP NUMC 2   0   Risk Group Assessed *
47 DERIVED_RISK /RPM/TV_DERIVED_RISK   DEC 4   0   Derived Risk  
48 D_PLANSTART /RPM/TV_PLAN_START DATUM DATS 8   0   Planned Start  
49 D_PLANFINISH /RPM/TV_PLAN_FINISH DATUM DATS 8   0   Planned Finish  
50 D_ACTUALSTART /RPM/TV_ACTUAL_START DATUM DATS 8   0   Actual Start  
51 D_ACTUALFINISH /RPM/TV_ACTUAL_FINISH DATUM DATS 8   0   Actual Finish Date  
52 HEADC_ACTUAL RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
53 BEGDA_DEM /RPM/TV_PP_START_DEM DATUM DATS 8   0   Demand Planning Start  
54 ENDDA_DEM /RPM/TV_PP_END_DEM DATUM DATS 8   0   Demand Planning Period Finish Date  
55 BEGDA_FIN /RPM/TV_PP_START_FIN DATUM DATS 8   0   Financial Planning Period Start  
56 ENDDA_FIN /RPM/TV_PP_END_FIN DATUM DATS 8   0   Financial Plan Period Finish Date  
57 BUCKET_NAME /RPM/TV_BUCKET_NAME TEXT40 CHAR 40   0   Bucket Name  
58 BUCKET_ID /RPM/TV_BUCKET_ID   CHAR 24   0   Bucket ID  
59 PROPOSAL /RPM/TV_PROPOSAL XFELD CHAR 1   0   Proposal  
60 MASTER_ITEM_NAME /RPM/TV_MASTER_ITEM_NAME TEXT40 CHAR 40   0   Initiative Name  
61 MASTER_ITEM_ID /RPM/TV_MASTER_ITEM_ID   CHAR 24   0   Initiative ID  
62 HAS_CHILDREN /RPM/TV_ITEM_CHILDREN XFELD CHAR 1   0   Has Children  
63 BUDGET_TOTAL /RPM/TV_BUDGET_TOTAL /RPM/CURR_16_2 CURR 16   2   Total Budget  
64 BUDGET_ANNUAL /RPM/TV_BUDGET_ANNUAL /RPM/CURR_16_2 CURR 16   2   Annual Budget  
65 PLANNED_COST /RPM/TV_PLANNED_COST /RPM/CURR_16_2 CURR 16   2   Planned Costs  
66 PLANNED_COST_YTD /RPM/TV_PLANNED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Planned Costs Year to Date  
67 ACTUAL_COST /RPM/TV_ACTUAL_COST /RPM/CURR_16_2 CURR 16   2   Actual Costs  
68 ACTUAL_COST_YTD /RPM/TV_ACTUAL_COST_YTD /RPM/CURR_16_2 CURR 16   2   Actual Cost Year to Day  
69 ACT_DECPT_NAME /RPM/TV_PHASE_T TEXT80 CHAR 80   0   Decision Point Name  
70 ACT_DECPT_STAT_TEXT /RPM/TV_STATUS_TEXT CHAR40 CHAR 40   0   Active Decision Point Status Text  
71 DECPT_INFO /RPM/TV_DECPT_INFO CHAR20 CHAR 20   0   Decision Point Info  
72 STATUS_GROUP /RPM/TV_ITEM_STATUS_GROUP /RPM/ITEM_STATUS_GROUP CHAR 4   0   Status Group  
73 FORECASTED_DURATION /RPM/TV_FORCASTED_DURATION   QUAN 4   0   Forecasted Duration  
74 PLANNED_DURATION /RPM/TV_PLANNED_DURATION   QUAN 4   0   Planned Duration  
75 ACTUAL_DURATION /RPM/TV_ACTUAL_DURATION   QUAN 4   0   Actual Duration  
76 WORKEFFORT_TOTAL /RPM/TV_WORKEFFORT_TOTAL /RPM/DEC_26_8 DEC 26   8   Actual Effort  
77 WORKEFFORT_YTD /RPM/TV_WORKEFFORT_YTD /RPM/DEC_26_8 DEC 26   8   Work Effort Year-to-Date  
78 PLANNED_EFFORT /RPM/TV_PLANNED_EFFORT /RPM/DEC_26_8 DEC 26   8   Planned Effort  
79 PLANNED_EFFORT_YTD /RPM/TV_PLANNED_EFFORT_YTD /RPM/DEC_26_8 DEC 26   8   Planned Effort Year-to-Date  
80 ROI /RPM/TV_ROI /RPM/CURR_16_2 CURR 16   2   Return on Investment in % (manual)  
81 IRR /RPM/TV_IRR /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in % (manual)  
82 RISK_GROUP_D /RPM/RISK_GROUP_D RPM_RISK_GROUP NUMC 2   0   Risk Group Derived *
83 PLANNED_DECISION_DATE /RPM/TV_PLAND_DDATE DATUM DATS 8   0   Planned Decision date  
84 ACTUAL_DECISION_DATE /RPM/TV_ACTUAL_DDATE DATUM DATS 8   0   Actual Decision Date  
85 FORECAST_DEC_DATE /RPM/TV_FORECAST_DDATE DATUM DATS 8   0   Forecasted Decision Date  
86 D_FORECASTED_START RPM_TV_FORECAST_START DATS DATS 8   0   Forecasted Start  
87 D_FORECASTED_FINISH RPM_TV_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
88 BUDGET_GROUP RPM_TV_BUDGET_GROUP RPM_BUDGET_GROUP NUMC 2   0   Budget Status Group *
89 SCHEDULE_GROUP RPM_TV_SCHEDULE_GROUP RPM_SCHEDULE_GROUP NUMC 2   0   Schedule Status Group *
90 STAFFING_GROUP RPM_TV_STAFFING_GROUP RPM_STAFFING_GROUP NUMC 2   0   Staffing Status Group *
91 PORTFOLIO_NAME /RPM/TV_PORTFOLIO_NAME TEXT40 CHAR 40   0   Portfolio Name  
92 PORTFOLIO_ID /RPM/TV_PORTFOLIO_ID   CHAR 24   0   Portfolio ID  
93 PLANNED_REVENUE /RPM/TV_PLANNED_REVENUE /RPM/CURR_16_2 CURR 16   2   Planned Revenues  
94 PLANNED_REV_YTD /RPM/TV_PLANNED_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Planned Revenues Year to Date  
95 ACTUAL_REVENUE /RPM/TV_ACTUAL_REVENUE /RPM/CURR_16_2 CURR 16   2   Actual Revenues  
96 ACTUAL_REV_YTD /RPM/TV_ACTUAL_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Actual Revenues Year to Day  
97 .INCLUDE       0   0   Financial KPIs  
98 NPV_PLAN /RPM/TV_NPV_PLAN /RPM/CURR_16_2 CURR 16   2   Net Present Value  
99 IRR_PLAN /RPM/TV_IRR_PLAN /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in %  
100 ROI_PLAN /RPM/TV_ROI_PLAN /RPM/CURR_16_2 CURR 16   2   Return on Investment in %  
101 PAYBACK_PLAN /RPM/TV_PAYBACK_PLAN /RPM/TD_PBP_PLAN NUMC 6   0   Payback Periods in Months  
102 ECV_PLAN /RPM/TV_ECV_PLAN /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value  
103 .INCLUDE       0   0   Customer fields for KPI derived attributes  
104 EA_DUMMY_KPI CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
105 .INCLUDE       0   0    
106 .INCLUDE       0   0   Item Detail Customer Fields  
107 EA_DUMMY /RPM/TV_EA_DUMMY CHAR1 CHAR 1   0   Dummy Data Element for Enhanced xRPM Attributes  
108 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /RPM/TS_ITEM_API_REP CAP_PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
2 /RPM/TS_ITEM_API_REP CATEGORY RPM_PROJ_CAT CATEGORY KEY    
3 /RPM/TS_ITEM_API_REP CURRENCY /RPM/CURRENCY CURRENCY REF 1 CN
4 /RPM/TS_ITEM_API_REP GEOGRAPHY DPR_AREA AREA REF 1 CN
5 /RPM/TS_ITEM_API_REP ITEM_TYPE /RPM/ITEM_TYPE ITEM_TYPE KEY 1 CN
6 /RPM/TS_ITEM_API_REP LOCATION DPR_LOCATION LOCATION REF 1 CN
7 /RPM/TS_ITEM_API_REP PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
8 /RPM/TS_ITEM_API_REP PHASE RPM_PROJ_PHASE PHASE REF 1 CN
9 /RPM/TS_ITEM_API_REP PRIORITY_GROUP RPM_PROJ_PRGRP PRIORITY_GROUP KEY 1 CN
10 /RPM/TS_ITEM_API_REP PTYPE RPM_PROJ_TYPE PTYPE KEY 1 CN
11 /RPM/TS_ITEM_API_REP STATUS /RPM/STATUS STATUS KEY 1 CN
12 /RPM/TS_ITEM_API_REP SUBCATEGORY RPM_PROJ_SUBCAT SUBCATEGORY REF 1 CN
13 /RPM/TS_ITEM_API_REP TTYPE RPM_PROJ_TTYPE TTYPE REF 1 CN
14 /RPM/TS_ITEM_API_REP UNIT /RPM/CAP_UNITS UNIT REF    
History
Last changed by/on SAP  20141109 
SAP Release Created in 500_702