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