SAP ABAP Table /RPM/TS_ITEM_PFS (Structure for Item Printing Fact Sheet)
Hierarchy
☛ CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   ⤷ PPM-PFM (Application Component) Portfolio Management
     ⤷ /RPM/UI_LOGIC (Package) RPM UI Logic for ABAP WD
Basic Data
Table Category INTTAB    Structure 
Structure /RPM/TS_ITEM_PFS   Table Relationship Diagram
Short Description Structure for Item Printing Fact Sheet    
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   RAW 16   0   Guid for application objects  
2 PORTFL_ITEM_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
3 .INCLUDE       0   0   Item/Initiative Detail Internal Attributes  
4 .INCLUDE       0   0   Portfolio object key attributes  
5 EXTERNAL_ID /RPM/TV_EXTID   CHAR 24   0   Business Object ID  
6 PORTFOLIO_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
7 PARENT_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
8 PROJ_DESCRIPTION RPM_TV_PROJ_DESCRIPTION TEXT40 CHAR 40   0   Item Name  
9 CHANGED_BY /RPM/TV_CHANGED_BY XUBNAME CHAR 12   0   Changed by user *
10 RPM_CHANGED_ON /RPM/TV_TIMESTAMP /RPM/TD_BCOS_TSTMP DEC 15   0   TimeStamp  
11 ITEM_TYPE /RPM/TV_ITEM_ID /RPM/TD_ITEM_TYPE CHAR 15   0   Type /RPM/ITEM_TYPE
12 .INCLUDE       0   0   Item/Initiative Business Data  
13 .INCLUDE       0   0   Item/Initiative Attributes  
14 CATEGORY RPM_PROJECT_CATEGORY RPM_PROJECT_CATEGORY NUMC 4   0   Category RPM_PROJ_CAT
15 SUBCATEGORY RPM_PROJ_SUBCATEGORY RPM_SUBCATEGORY NUMC 4   0   Subcategory RPM_PROJ_SUBCAT
16 PHASE RPM_PROJECT_PHASE RPM_PROJECT_PHASE NUMC 4   0   Stage RPM_PROJ_PHASE
17 PTYPE RPM_PROJECTTYPE RPM_PROJECTTYPE NUMC 4   0   Group RPM_PROJ_TYPE
18 TTYPE RPM_PROJECT_TECHTYPE RPM_PROJECT_TECHTYPE NUMC 4   0   Technology Type RPM_PROJ_TTYPE
19 RISKA RPM_PROJECT_RISK_ASSESED NUMC3 NUMC 3   0   Assessed Project Risk  
20 PROBT RPM_PROJECT_PROB_TECH NUMC3 NUMC 3   0   Probability of Technical Success  
21 PROBC RPM_PROJECT_PROB_COMM NUMC3 NUMC 3   0   Probability of Commercial Success  
22 HEADC /RPM/PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Headcount  
23 COSTD RPM_PROJECT_COST_DEVELOPMENT /RPM/CURR_16_2 CURR 16   2   Development Cost  
24 COSTL RPM_PROJECT_COST_LAUNCH /RPM/CURR_16_2 CURR 16   2   Launch Cost  
25 NPV RPM_PROJECT_NPV /RPM/CURR_16_2 CURR 16   2   Net Present Value (manual)  
26 CURRENCY RPM_TV_CURRENCY WAERS CUKY 5   0   Currency key /RPM/CURRENCY
27 LOCATION DPR_TV_LOCATION DPR_LOCATION CHAR 4   0   Location DPR_LOCATION
28 GEOGRAPHY DPR_TV_AREA DPR_AREA CHAR 4   0   Area DPR_AREA
29 PERIODTYPE /RPM/TV_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Financial Period Breakdown /RPM/PERIOD_TYPE
30 UNIT /RPM/TV_TIME_UNIT MEINS UNIT 3   0   Time Unit /RPM/CAP_UNITS
31 ESCALATION RPM_TV_ESCALATION XFELD CHAR 1   0   Escalation Flag  
32 FORECAST_START RPM_TV_FORECAST_START DATS DATS 8   0   Forecasted Start  
33 PLANNED_START RPM_TV_PLAN_START DATS DATS 8   0   Planned Start Date  
34 ACTUAL_START RPM_TV_ACTUAL_START   DATS 8   0   Actual Start Date  
35 FORECAST_FINISH RPM_TV_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
36 PLANNED_FINISH RPM_TV_PLAN_FINISH DATS DATS 8   0   Planned Finish Date  
37 ACTUAL_FINISH RPM_TV_ACTUAL_FINISH   DATS 8   0   Actual Finish Date  
38 ECV RPM_TV_ECV /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value (manual)  
39 PRIORITY_GROUP RPM_PRIORITY_GROUP RPM_PRIORITY_GROUP NUMC 2   0   Priority Group RPM_PROJ_PRGRP
40 ITEM_CLASS /RPM/TV_ITEM_CLASS /RPM/TD_ITEM_CLASS CHAR 1   0   Item Classification  
41 MASTER_ITEM_GUID RPM_TV_GUID RPM_GUID RAW 16   0   Guid for application objects  
42 STATUS /RPM/TV_STATUS_COMMON /RPM/TD_STATUS_COMMON CHAR 5   0   Status /RPM/STATUS
43 VERSION_ITEM /RPM/TV_VERSION_ITEM XFELD CHAR 1   0   Version Item Indicator  
44 CAP_PERIODTYPE /RPM/TV_CAP_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Capacity Period Breakdown /RPM/PERIOD_TYPE
45 DAYS_UNTIL_PLAN_FINISH /RPM/TV_D_LEFT_PLAN_FINISH   INT4 10   0   Days Until Finish  
46 DAYS_UNTIL_NEXT_DECISION /RPM/TV_D_LEFT_NEXT_DECISION   INT4 10   0   Days Until Next Decision  
47 DISCOUNT_RATE /RPM/TV_DISCOUNT_RATE /RPM/DEC_5_2 DEC 5   2   Discount Rate  
48 INITIATIVE_GUID RPM_TV_GUID RPM_GUID RAW 16   0   Guid for application objects  
49 ACT_DPCPT_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
50 FRCST_BGT_TOTAL /RPM/TV_FORECASTED_BUDGT_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Total  
51 FRCST_BGTANNUAL /RPM/TV_FORECASTED_BUDGT_ANNL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Annual  
52 FRCST_COSTTOTAL /RPM/TV_FORECASTED_COST_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost Total  
53 FRCST_COST_YTD /RPM/TV_FORECASTED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost YTD  
54 TEMPLATE_GUID /RPM/TV_GUID   RAW 16   0   Guid for application objects  
55 .INCLUDE       0   0   Item/Initiative Attributes; derrived  
56 PRIORITY_ICON /RPM/TV_PRIORITY_ICON ICON CHAR 4   0   Priority *
57 RISK_PRCNT RPM_RISK_LIMIT_HIGH NUMC3 NUMC 3   0   Risk Group - Upper Limit  
58 RISK_GROUP RPM_RISK_GROUP RPM_RISK_GROUP NUMC 2   0   Risk Group Assessed RPM_PROJ_RKGRP
59 RISK_ICON /RPM/TV_RISK_ICON ICON CHAR 4   0   Risk *
60 PHASE_ICON /RPM/TV_PHASE_ICON ICON CHAR 4   0   Phase *
61 PHASE_COLOR RPM_TV_STATUS_COLOR RPM_HTML_COLOR CHAR 7   0   Alert Object Color Status  
62 DERIVED_RISK RPM_TV_RISK_DERIVED NUMC3 NUMC 3   0   Derived Risk  
63 D_PLANSTART /RPM/TV_DP_PLAN_START DATUM DATS 8   0   Planned Start  
64 D_PLANFINISH /RPM/TV_DP_PLAN_FINISH DATUM DATS 8   0   Planned Finish  
65 D_ACTUALSTART /RPM/TV_DP_ACTUAL_START DATUM DATS 8   0   Actual Start  
66 D_ACTUALFINISH /RPM/TV_DP_ACTUAL_FINISH DATUM DATS 8   0   Actual Finish Date  
67 HEADC_ACTUAL RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
68 BEGDA_DEM /RPM/TV_PP_START_DEM DATUM DATS 8   0   Demand Planning Start  
69 ENDDA_DEM /RPM/TV_PP_END_DEM DATUM DATS 8   0   Demand Planning Period Finish Date  
70 BEGDA_FIN /RPM/TV_PP_START_FIN DATUM DATS 8   0   Financial Planning Period Start  
71 ENDDA_FIN /RPM/TV_PP_END_FIN DATUM DATS 8   0   Financial Plan Period Finish Date  
72 BUCKET_NAME /RPM/TV_BUCKET_NAME TEXT40 CHAR 40   0   Bucket Name  
73 BUCKET_ID /RPM/TV_BUCKET_ID   CHAR 24   0   Bucket ID  
74 PROPOSAL /RPM/TV_PROPOSAL XFELD CHAR 1   0   Proposal  
75 D_CHANGED_ON /RPM/TV_LAST_CHANGED_ON DATUM DATS 8   0   Changed On Date  
76 MASTER_ITEM_NAME /RPM/TV_MASTER_ITEM_NAME TEXT40 CHAR 40   0   Initiative Name  
77 MASTER_ITEM_ID /RPM/TV_MASTER_ITEM_ID   CHAR 24   0   Initiative ID  
78 HAS_CHILDREN /RPM/TV_ITEM_CHILDREN XFELD CHAR 1   0   Has Children  
79 BUDGET_ICON /RPM/TV_BUDGET_ICON ICON CHAR 4   0   Budget *
80 SCHEDULE_ICON /RPM/TV_SCHEDULE_ICON ICON CHAR 4   0   Schedule *
81 STAFFING_ICON /RPM/TV_STAFFING_ICON ICON CHAR 4   0   Staffing *
82 BUDGET_TOTAL /RPM/TV_BUDGET_TOTAL /RPM/CURR_16_2 CURR 16   2   Total Budget  
83 BUDGET_ANNUAL /RPM/TV_BUDGET_ANNUAL /RPM/CURR_16_2 CURR 16   2   Annual Budget  
84 PLANNED_COST /RPM/TV_PLANNED_COST /RPM/CURR_16_2 CURR 16   2   Planned Costs  
85 PLANNED_COST_YTD /RPM/TV_PLANNED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Planned Costs Year to Date  
86 ACTUAL_COST /RPM/TV_ACTUAL_COST /RPM/CURR_16_2 CURR 16   2   Actual Costs  
87 ACTUAL_COST_YTD /RPM/TV_ACTUAL_COST_YTD /RPM/CURR_16_2 CURR 16   2   Actual Cost Year to Day  
88 ACT_DECPT_NAME /RPM/TV_PHASE_T TEXT80 CHAR 80   0   Decision Point Name  
89 ACT_DECPT_STAT_TEXT /RPM/TV_STATUS_TEXT CHAR40 CHAR 40   0   Active Decision Point Status Text  
90 ACT_DECPT_STAT_ICON /RPM/TV_DECPT_STATUS_ICON ICON CHAR 4   0   Active Decision Point Status *
91 DECPT_INFO /RPM/TV_DECPT_INFO CHAR20 CHAR 20   0   Decision Point Info  
92 STATUS_GROUP /RPM/TV_ITEM_STATUS_GROUP /RPM/ITEM_STATUS_GROUP CHAR 4   0   Status Group  
93 FORECASTED_DURATION /RPM/TV_FORCASTED_DURATION   QUAN 4   0   Forecasted Duration  
94 PLANNED_DURATION /RPM/TV_PLANNED_DURATION   QUAN 4   0   Planned Duration  
95 ACTUAL_DURATION /RPM/TV_ACTUAL_DURATION   QUAN 4   0   Actual Duration  
96 ACT_PHASE_GUID DPR_TV_GUID DPR_GUID RAW 16   0   Application Object GUID  
97 WORKEFFORT_TOTAL /RPM/TV_WORK_EFFORT_TOTAL /RPM/DEC_26_2 DEC 26   2   Actual Effort  
98 WORKEFFORT_YTD /RPM/TV_WORK_EFFORT_YTD /RPM/DEC_26_2 DEC 26   2   Actual Work Effort Year-To-Date  
99 PLANNED_EFFORT /RPM/TV_PLAN_EFFORT /RPM/DEC_26_2 DEC 26   2   Planned Effort  
100 PLANNED_EFFORT_YTD /RPM/TV_PLAN_EFFORT_YTD /RPM/DEC_26_2 DEC 26   2   Planned Effort Year-To-Date  
101 ROI /RPM/TV_ROI /RPM/CURR_16_2 CURR 16   2   Return on Investment in % (manual)  
102 IRR /RPM/TV_IRR /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in % (manual)  
103 RISK_GROUP_D /RPM/RISK_GROUP_D RPM_RISK_GROUP NUMC 2   0   Risk Group Derived RPM_PROJ_RKGRP
104 RISK_D_ICON /RPM/TV_RISK_ICON_D ICON CHAR 4   0   Derived Risk *
105 PLANNED_DECISION_DATE /RPM/TV_PLAND_DDATE DATUM DATS 8   0   Planned Decision date  
106 ACTUAL_DECISION_DATE /RPM/TV_ACTUAL_DDATE DATUM DATS 8   0   Actual Decision Date  
107 FORECAST_DEC_DATE /RPM/TV_FORECAST_DDATE DATUM DATS 8   0   Forecasted Decision Date  
108 D_FORECASTED_START RPM_TV_DP_FORECAST_START DATS DATS 8   0   Forecasted Start  
109 D_FORECASTED_FINISH RPM_TV_DP_FORECAST_FINISH DATS DATS 8   0   Forecasted Finish Date  
110 BUDGET_GROUP RPM_TV_BUDGET_GROUP RPM_BUDGET_GROUP NUMC 2   0   Budget Status Group RPM_PROJ_BDGRP
111 SCHEDULE_GROUP RPM_TV_SCHEDULE_GROUP RPM_SCHEDULE_GROUP NUMC 2   0   Schedule Status Group RPM_PROJ_SDGRP
112 STAFFING_GROUP RPM_TV_STAFFING_GROUP RPM_STAFFING_GROUP NUMC 2   0   Staffing Status Group RPM_PROJ_STGRP
113 PORTFOLIO_NAME /RPM/TV_PORTFOLIO_NAME TEXT40 CHAR 40   0   Portfolio Name  
114 PORTFOLIO_ID /RPM/TV_PORTFOLIO_ID   CHAR 24   0   Portfolio ID  
115 PLANNED_REVENUE /RPM/TV_PLANNED_REVENUE /RPM/CURR_16_2 CURR 16   2   Planned Revenues  
116 PLANNED_REV_YTD /RPM/TV_PLANNED_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Planned Revenues Year to Date  
117 ACTUAL_REVENUE /RPM/TV_ACTUAL_REVENUE /RPM/CURR_16_2 CURR 16   2   Actual Revenues  
118 ACTUAL_REV_YTD /RPM/TV_ACTUAL_REVENUE_YTD /RPM/CURR_16_2 CURR 16   2   Actual Revenues Year to Day  
119 .INCLUDE       0   0   Financial KPIs  
120 NPV_PLAN /RPM/TV_NPV_PLAN /RPM/CURR_16_2 CURR 16   2   Net Present Value  
121 IRR_PLAN /RPM/TV_IRR_PLAN /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in %  
122 ROI_PLAN /RPM/TV_ROI_PLAN /RPM/CURR_16_2 CURR 16   2   Return on Investment in %  
123 PAYBACK_PLAN /RPM/TV_PAYBACK_PLAN /RPM/TD_PBP_PLAN NUMC 6   0   Payback Periods in Months  
124 ECV_PLAN /RPM/TV_ECV_PLAN /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value  
125 .INCLUDE       0   0   Customer fields for KPI derived attributes  
126 EA_DUMMY_KPI CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
127 .INCLUDE       0   0    
128 .INCLUDE       0   0   Item Detail Customer Fields  
129 EA_DUMMY /RPM/TV_EA_DUMMY CHAR1 CHAR 1   0   Dummy Data Element for Enhanced xRPM Attributes  
130 .INCLUDE       0   0    
131 SHORT_TEXT /RPM/TV_SHORT_TEXT   STRG 0   0   Description  
132 COMMENTS /RPM/TV_COMMENTS   STRG 0   0   Comments  
133 .INCLUDE       0   0   Item Printing Texts  
134 ITEM_TYPE_T /RPM/TV_ITEM_TYPE_T TEXT80 CHAR 80   0   Item Type Text  
135 CATEGORY_T RPM_PROJECT_CATEGORY_TEXT TEXT30 CHAR 30   0   Portfolio Item Category Text  
136 SUBCATEGORY_T RPM_PROJ_SUBCATEGORY_TEXT TEXT30 CHAR 30   0   Portfolio Item Subcategory Text  
137 PTYPE_T RPM_PROJECTTYPE_TEXT TEXT30 CHAR 30   0   Portfolio Item Group Text  
138 TTYPE_T RPM_PROJECT_TTYPE_TEXT TEXT30 CHAR 30   0   Project Technology Type Text  
139 PHASE_T RPM_PROJECT_PHASE_TEXT TEXT30 CHAR 30   0   Portfolio Item Stage Text  
140 LOCATION_T DPR_TV_LOCATION_TEXT TEXT30 CHAR 30   0   Location Text  
141 GEOGRAPHY_T RPM_TV_PROJECT_GEOGRAPHY_T TEXT30 CHAR 30   0   Project Geography Text  
142 CURR_T LTEXT TEXT40 CHAR 40   0   Long Text  
143 PERIODTYPE_T /RPM/TV_PERIOD_TYPE_T TEXT80 CHAR 80   0   Period Type Text  
144 CAP_PERIODTYPE_T /RPM/TV_PERIOD_TYPE_T TEXT80 CHAR 80   0   Period Type Text  
145 STATUS_GROUP_T /RPM/TV_STATUS_GRP CHAR20 CHAR 20   0   Item Status Group  
146 STATUS_T /RPM/TV_STATUS_T CHAR40 CHAR 40   0   Status Text  
147 MSEHL MSEHL TEXT30 CHAR 30   0   Unit of Measurement Text (Maximum 30 Characters)  
148 PRIORITY_GROUP_T RPM_PRIORITY_GROUP_T TEXT30 CHAR 30   0   Project Priority Group Text  
149 RISK_ICON_T ICONQUICK ICONTEXT CHAR 30   0   Quickinfo for an icon  
150 PHASE_ICON_T ICONQUICK ICONTEXT CHAR 30   0   Quickinfo for an icon  
151 BUDGET_ICON_T ICONQUICK ICONTEXT CHAR 30   0   Quickinfo for an icon  
152 STAFFING_ICON_T ICONQUICK ICONTEXT CHAR 30   0   Quickinfo for an icon  
153 SCHEDULE_ICON_T ICONQUICK ICONTEXT CHAR 30   0   Quickinfo for an icon  
154 PRIORITY_ICON_T ICONQUICK ICONTEXT CHAR 30   0   Quickinfo for an icon  
155 DEC_STATUS_T /RPM/TV_STATUS_T CHAR40 CHAR 40   0   Status Text  
156 STATUS_PROFILE_T TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
157 RISK_D_ICON_T ICONQUICK ICONTEXT CHAR 30   0   Quickinfo for an icon  
158 STATUS_ICON_T ICONQUICK ICONTEXT CHAR 30   0   Quickinfo for an icon  
159 INI_STATUS_T DPR_TV_STATUS_TXT   STRG 0   0   Concatenated Status Text of an Object  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /RPM/TS_ITEM_PFS BUDGET_GROUP RPM_PROJ_BDGRP BUDGET_GROUP KEY 1 CN
2 /RPM/TS_ITEM_PFS CAP_PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
3 /RPM/TS_ITEM_PFS CATEGORY RPM_PROJ_CAT CATEGORY REF 1 CN
4 /RPM/TS_ITEM_PFS CURRENCY /RPM/CURRENCY CURRENCY REF 1 CN
5 /RPM/TS_ITEM_PFS GEOGRAPHY DPR_AREA AREA REF 1 CN
6 /RPM/TS_ITEM_PFS ITEM_TYPE /RPM/ITEM_TYPE ITEM_TYPE KEY 1 CN
7 /RPM/TS_ITEM_PFS LOCATION DPR_LOCATION LOCATION REF 1 CN
8 /RPM/TS_ITEM_PFS PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
9 /RPM/TS_ITEM_PFS PHASE RPM_PROJ_PHASE PHASE REF 1 CN
10 /RPM/TS_ITEM_PFS PRIORITY_GROUP RPM_PROJ_PRGRP PRIORITY_GROUP KEY 1 CN
11 /RPM/TS_ITEM_PFS PTYPE RPM_PROJ_TYPE PTYPE KEY 1 CN
12 /RPM/TS_ITEM_PFS RISK_GROUP RPM_PROJ_RKGRP RISK_GROUP KEY 1 CN
13 /RPM/TS_ITEM_PFS RISK_GROUP_D RPM_PROJ_RKGRP RISK_GROUP KEY 1 CN
14 /RPM/TS_ITEM_PFS SCHEDULE_GROUP RPM_PROJ_SDGRP SCHED_GROUP KEY 1 CN
15 /RPM/TS_ITEM_PFS STAFFING_GROUP RPM_PROJ_STGRP STAFFING_GROUP KEY 1 CN
16 /RPM/TS_ITEM_PFS STATUS /RPM/STATUS STATUS KEY 1 CN
17 /RPM/TS_ITEM_PFS SUBCATEGORY RPM_PROJ_SUBCAT SUBCATEGORY REF 1 CN
18 /RPM/TS_ITEM_PFS TTYPE RPM_PROJ_TTYPE TTYPE REF 1 CN
19 /RPM/TS_ITEM_PFS UNIT /RPM/CAP_UNITS UNIT REF    
History
Last changed by/on SAP  20141109 
SAP Release Created in 450