SAP ABAP Table /RPM/TS_ITEM_D_API_UI (Portfolio Item Attributes; ext (incl. UI fields; without CI))
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_API_UI   Table Relationship Diagram
Short Description Portfolio Item Attributes; ext (incl. UI fields; without CI)    
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_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
2 PORTFL_ITEM_GUID /RPM/TV_GUID_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
3 EXTERNAL_ID /RPM/TV_EXTID   CHAR 24   0   Business Object ID  
4 PORTFOLIO_GUID /RPM/TV_GUID_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
5 PARENT_GUID /RPM/TV_GUID_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
6 PROJ_DESCRIPTION RPM_TV_PROJ_DESCRIPTION TEXT40 CHAR 40   0   Item Name  
7 CHANGED_BY UNAME UNAME CHAR 12   0   User Name  
8 RPM_CHANGED_ON /RPM/TV_TIMESTAMP /RPM/TD_BCOS_TSTMP DEC 15   0   TimeStamp  
9 ITEM_TYPE /RPM/TV_ITEM_ID /RPM/TD_ITEM_TYPE CHAR 15   0   Type /RPM/ITEM_TYPE
10 ITEM_TYPE_TEXT /RPM/TV_ITEM_TYPE_T TEXT80 CHAR 80   0   Item Type Text  
11 CATEGORY RPM_PROJECT_CATEGORY RPM_PROJECT_CATEGORY NUMC 4   0   Category RPM_PROJ_CAT
12 SUBCATEGORY RPM_PROJ_SUBCATEGORY RPM_SUBCATEGORY NUMC 4   0   Subcategory RPM_PROJ_SUBCAT
13 PHASE RPM_PROJECT_PHASE RPM_PROJECT_PHASE NUMC 4   0   Stage RPM_PROJ_PHASE
14 PTYPE RPM_PROJECTTYPE RPM_PROJECTTYPE NUMC 4   0   Group RPM_PROJ_TYPE
15 TTYPE RPM_PROJECT_TECHTYPE RPM_PROJECT_TECHTYPE NUMC 4   0   Technology Type RPM_PROJ_TTYPE
16 RISKA RPM_PROJECT_RISK_ASSESED NUMC3 NUMC 3   0   Assessed Project Risk  
17 PROBT RPM_PROJECT_PROB_TECH NUMC3 NUMC 3   0   Probability of Technical Success  
18 PROBC RPM_PROJECT_PROB_COMM NUMC3 NUMC 3   0   Probability of Commercial Success  
19 HEADC /RPM/PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Headcount  
20 COSTD RPM_PROJECT_COST_DEVELOPMENT /RPM/CURR_16_2 CURR 16   2   Development Cost  
21 COSTL RPM_PROJECT_COST_LAUNCH /RPM/CURR_16_2 CURR 16   2   Launch Cost  
22 NPV RPM_PROJECT_NPV /RPM/CURR_16_2 CURR 16   2   Net Present Value (manual)  
23 CURRENCY RPM_TV_CURRENCY WAERS CUKY 5   0   Currency key /RPM/CURRENCY
24 LOCATION DPR_TV_LOCATION DPR_LOCATION CHAR 4   0   Location DPR_LOCATION
25 GEOGRAPHY DPR_TV_AREA DPR_AREA CHAR 4   0   Area DPR_AREA
26 PERIODTYPE /RPM/TV_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Financial Period Breakdown /RPM/PERIOD_TYPE
27 UNIT /RPM/TV_TIME_UNIT MEINS UNIT 3   0   Time Unit /RPM/CAP_UNITS
28 ESCALATION RPM_TV_ESCALATION XFELD CHAR 1   0   Escalation Flag  
29 PLANNED_START DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
30 PLANNED_FINISH DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
31 FORECAST_START DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
32 FORECAST_FINISH DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
33 ACTUAL_START DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
34 ACTUAL_FINISH DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
35 ECV RPM_TV_ECV /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value (manual)  
36 PRIORITY_GROUP RPM_PRIORITY_GROUP RPM_PRIORITY_GROUP NUMC 2   0   Priority Group RPM_PROJ_PRGRP
37 ITEM_CLASS /RPM/TV_ITEM_CLASS /RPM/TD_ITEM_CLASS CHAR 1   0   Item Classification  
38 MASTER_ITEM_GUID /RPM/TV_GUID_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
39 STATUS /RPM/TV_STATUS_COMMON /RPM/TD_STATUS_COMMON CHAR 5   0   Status /RPM/STATUS
40 VERSION_ITEM /RPM/TV_VERSION_ITEM XFELD CHAR 1   0   Version Item Indicator  
41 CAP_PERIODTYPE /RPM/TV_CAP_PERIOD_TYPE /RPM/TD_PERIOD_TYPE NUMC 2   0   Capacity Period Breakdown /RPM/PERIOD_TYPE
42 DAYS_UNTIL_PLAN_FINISH /RPM/TV_D_LEFT_PLAN_FINISH   INT4 10   0   Days Until Finish  
43 DAYS_UNTIL_NEXT_DECISION /RPM/TV_D_LEFT_NEXT_DECISION   INT4 10   0   Days Until Next Decision  
44 DISCOUNT_RATE /RPM/TV_DISCOUNT_RATE /RPM/DEC_5_2 DEC 5   2   Discount Rate  
45 INITIATIVE_GUID /RPM/TV_GUID_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
46 ACT_DPCPT_GUID /RPM/TV_GUID_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
47 FRCST_BGT_TOTAL /RPM/TV_FORECASTED_BUDGT_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Total  
48 FRCST_BGTANNUAL /RPM/TV_FORECASTED_BUDGT_ANNL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Budget Annual  
49 FRCST_COSTTOTAL /RPM/TV_FORECASTED_COST_TOTAL /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost Total  
50 FRCST_COST_YTD /RPM/TV_FORECASTED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Portfolio Item Forecasted Cost YTD  
51 TEMPLATE_GUID /RPM/TV_GUID_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
52 PRIORITY_ICON /RPM/TV_PRIORITY_ICON ICON CHAR 4   0   Priority *
53 RISK_PRCNT RPM_RISK_LIMIT_HIGH NUMC3 NUMC 3   0   Risk Group - Upper Limit  
54 RISK_GROUP RPM_RISK_GROUP RPM_RISK_GROUP NUMC 2   0   Risk Group Assessed *
55 RISK_ICON /RPM/TV_RISK_ICON ICON CHAR 4   0   Risk *
56 PHASE_ICON /RPM/TV_PHASE_ICON ICON CHAR 4   0   Phase *
57 PHASE_COLOR RPM_TV_STATUS_COLOR RPM_HTML_COLOR CHAR 7   0   Alert Object Color Status  
58 DERIVED_RISK RPM_TV_RISK_DERIVED NUMC3 NUMC 3   0   Derived Risk  
59 D_PLANSTART DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
60 D_PLANFINISH DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
61 D_ACTUALSTART DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
62 D_ACTUALFINISH DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
63 HEADC_ACTUAL RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
64 BEGDA_DEM DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
65 ENDDA_DEM DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
66 BEGDA_FIN DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
67 ENDDA_FIN DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
68 BUCKET_NAME /RPM/TV_BUCKET_NAME TEXT40 CHAR 40   0   Bucket Name  
69 BUCKET_ID /RPM/TV_BUCKET_ID   CHAR 24   0   Bucket ID  
70 PROPOSAL /RPM/TV_PROPOSAL XFELD CHAR 1   0   Proposal  
71 D_CHANGED_ON /RPM/TV_LAST_CHANGED_ON DATUM DATS 8   0   Changed On Date  
72 MASTER_ITEM_NAME /RPM/TV_MASTER_ITEM_NAME TEXT40 CHAR 40   0   Initiative Name  
73 MASTER_ITEM_ID /RPM/TV_MASTER_ITEM_ID   CHAR 24   0   Initiative ID  
74 HAS_CHILDREN /RPM/TV_ITEM_CHILDREN XFELD CHAR 1   0   Has Children  
75 BUDGET_ICON /RPM/TV_BUDGET_ICON ICON CHAR 4   0   Budget *
76 SCHEDULE_ICON /RPM/TV_SCHEDULE_ICON ICON CHAR 4   0   Schedule *
77 STAFFING_ICON /RPM/TV_STAFFING_ICON ICON CHAR 4   0   Staffing *
78 BUDGET_TOTAL /RPM/TV_BUDGET_TOTAL /RPM/CURR_16_2 CURR 16   2   Total Budget  
79 BUDGET_ANNUAL /RPM/TV_BUDGET_ANNUAL /RPM/CURR_16_2 CURR 16   2   Annual Budget  
80 PLANNED_COST /RPM/TV_PLANNED_COST /RPM/CURR_16_2 CURR 16   2   Planned Costs  
81 PLANNED_COST_YTD /RPM/TV_PLANNED_COST_YTD /RPM/CURR_16_2 CURR 16   2   Planned Costs Year to Date  
82 ACTUAL_COST /RPM/TV_ACTUAL_COST /RPM/CURR_16_2 CURR 16   2   Actual Costs  
83 ACTUAL_COST_YTD /RPM/TV_ACTUAL_COST_YTD /RPM/CURR_16_2 CURR 16   2   Actual Cost Year to Day  
84 ACT_DECPT_NAME /RPM/TV_PHASE_T TEXT80 CHAR 80   0   Decision Point Name  
85 ACT_DECPT_STAT_TEXT /RPM/TV_STATUS_TEXT CHAR40 CHAR 40   0   Active Decision Point Status Text  
86 ACT_DECPT_STAT_ICON /RPM/TV_DECPT_STATUS_ICON ICON CHAR 4   0   Active Decision Point Status *
87 DECPT_INFO /RPM/TV_DECPT_INFO CHAR20 CHAR 20   0   Decision Point Info  
88 STATUS_GROUP /RPM/TV_ITEM_STATUS_GROUP /RPM/ITEM_STATUS_GROUP CHAR 4   0   Status Group  
89 FORECASTED_DURATION /RPM/TV_FORCASTED_DURATION   QUAN 4   0   Forecasted Duration  
90 PLANNED_DURATION /RPM/TV_PLANNED_DURATION   QUAN 4   0   Planned Duration  
91 ACTUAL_DURATION /RPM/TV_ACTUAL_DURATION   QUAN 4   0   Actual Duration  
92 ACT_PHASE_GUID /RPM/TV_GUID_CHAR SYSUUID_C CHAR 32   0   Guid in character type  
93 WORKEFFORT_TOTAL /RPM/TV_WORKEFFORT_TOTAL /RPM/DEC_26_8 DEC 26   8   Actual Effort  
94 WORKEFFORT_YTD /RPM/TV_WORKEFFORT_YTD /RPM/DEC_26_8 DEC 26   8   Work Effort Year-to-Date  
95 PLANNED_EFFORT /RPM/TV_PLANNED_EFFORT /RPM/DEC_26_8 DEC 26   8   Planned Effort  
96 PLANNED_EFFORT_YTD /RPM/TV_PLANNED_EFFORT_YTD /RPM/DEC_26_8 DEC 26   8   Planned Effort Year-to-Date  
97 ROI /RPM/TV_ROI /RPM/CURR_16_2 CURR 16   2   Return on Investment in % (manual)  
98 IRR /RPM/TV_IRR /RPM/CURR_16_2 CURR 16   2   Internal Rate of Return in % (manual)  
99 RISK_GROUP_D /RPM/RISK_GROUP_D RPM_RISK_GROUP NUMC 2   0   Risk Group Derived *
100 RISK_D_ICON /RPM/TV_RISK_ICON_D ICON CHAR 4   0   Derived Risk *
101 PLANNED_DECISION_DATE DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
102 ACTUAL_DECISION_DATE DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
103 FORECAST_DEC_DATE DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
104 D_FORECASTED_START DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
105 D_FORECASTED_FINISH DPR_TV_BAPI_EXT_DATE CHAR10 CHAR 10   0   External Date for BAPI Interface  
106 BUDGET_ICON_TEXT RPM_TV_BUDGET_GROUP_T TEXT30 CHAR 30   0   Project Budget Status Group Text  
107 SCHEDULE_ICON_TEXT RPM_TV_SCHEDULE_GROUP_T TEXT30 CHAR 30   0   Project Schedule Status Text  
108 STAFFING_ICON_TEXT RPM_TV_STAFFING_GROUP_T TEXT30 CHAR 30   0   Project Staffing Status Text  
109 RISK_GROUP_ICON_TEXT RPM_TV_RISK_GROUP_T   CHAR 30   0   Risk Group Assessed Text  
110 RISK_GROUP_D_ICON_TEXT RPM_TV_RISK_GROUP_D_T   CHAR 30   0   Risk Group Derived Text  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /RPM/TS_ITEM_D_API_UI CAP_PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
2 /RPM/TS_ITEM_D_API_UI CATEGORY RPM_PROJ_CAT CATEGORY    
3 /RPM/TS_ITEM_D_API_UI CURRENCY /RPM/CURRENCY CURRENCY REF 1 CN
4 /RPM/TS_ITEM_D_API_UI GEOGRAPHY DPR_AREA AREA REF 1 CN
5 /RPM/TS_ITEM_D_API_UI ITEM_TYPE /RPM/ITEM_TYPE ITEM_TYPE KEY 1 CN
6 /RPM/TS_ITEM_D_API_UI LOCATION DPR_LOCATION LOCATION REF 1 CN
7 /RPM/TS_ITEM_D_API_UI PERIODTYPE /RPM/PERIOD_TYPE PERIODTYPE KEY 1 CN
8 /RPM/TS_ITEM_D_API_UI PHASE RPM_PROJ_PHASE PHASE REF 1 CN
9 /RPM/TS_ITEM_D_API_UI PRIORITY_GROUP RPM_PROJ_PRGRP PRIORITY_GROUP KEY 1 CN
10 /RPM/TS_ITEM_D_API_UI PTYPE RPM_PROJ_TYPE PTYPE KEY 1 CN
11 /RPM/TS_ITEM_D_API_UI STATUS /RPM/STATUS STATUS KEY 1 CN
12 /RPM/TS_ITEM_D_API_UI SUBCATEGORY RPM_PROJ_SUBCAT SUBCATEGORY    
13 /RPM/TS_ITEM_D_API_UI TTYPE RPM_PROJ_TTYPE TTYPE REF 1 CN
14 /RPM/TS_ITEM_D_API_UI UNIT /RPM/CAP_UNITS UNIT REF    
History
Last changed by/on SAP  20141109 
SAP Release Created in 500_702