SAP ABAP Table RPM_TS_MASTER_PROJECT_LIST (Master Project List)
Hierarchy
CPRXRPM (Software Component) SAP Portfolio and Project Management 6.0
   PPM-PFM (Application Component) Portfolio Management
     RPM_PROJECT (Package) RPM Application Object Project
Basic Data
Table Category INTTAB    Structure 
Structure RPM_TS_MASTER_PROJECT_LIST   Table Relationship Diagram
Short Description Master Project List    
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 MAIN_PROJECT_ID RPM_TV_EXTID   CHAR 24   0   ID  
2 MAIN_DESCRIPTION CGPL_TEXT1 TEXT40 CHAR 40   0   Language-Dependent Short Text  
3 EXTERNAL_ID RPM_TV_EXTID   CHAR 24   0   ID  
4 PROJ_DESCRIPTION CGPL_TEXT1 TEXT40 CHAR 40   0   Language-Dependent Short Text  
5 CATEGORY RPM_PROJECT_CATEGORY RPM_PROJECT_CATEGORY NUMC 4   0   Category *
6 SUBCATEGORY RPM_PROJ_SUBCATEGORY RPM_SUBCATEGORY NUMC 4   0   Subcategory *
7 .INCLUDE       0   0   Project attributes  
8 PTYPE RPM_PROJECTTYPE RPM_PROJECTTYPE NUMC 4   0   Group *
9 TTYPE RPM_PROJECT_TECHTYPE RPM_PROJECT_TECHTYPE NUMC 4   0   Technology Type *
10 .INCLUDE       0   0   Project attributes  
11 APSTAT RPM_PROJECT_APPST RPM_PROJECT_APPST NUMC 4   0   Project Approval Status RPM_PROJ_APST
12 PPRIO RPM_PROJECT_PRIORITY NUMC4 NUMC 4   0   Project Priority  
13 RISKA RPM_PROJECT_RISK_ASSESED NUMC3 NUMC 3   0   Assessed Project Risk  
14 PROBT RPM_PROJECT_PROB_TECH NUMC3 NUMC 3   0   Probability of Technical Success  
15 PROBC RPM_PROJECT_PROB_COMM NUMC3 NUMC 3   0   Probability of Commercial Success  
16 HEADC RPM_PROJECT_HEADCOUNT_PLAN   DEC 10   2   Project Planned Headcount  
17 BUDGT RPM_PROJECT_BUDGET_PLAN CURR16 CURR 16   2   Budget  
18 COSTD RPM_PROJECT_COST_DEVELOPMENT /RPM/CURR_16_2 CURR 16   2   Development Cost  
19 COSTL RPM_PROJECT_COST_LAUNCH /RPM/CURR_16_2 CURR 16   2   Launch Cost  
20 NPV RPM_PROJECT_NPV /RPM/CURR_16_2 CURR 16   2   Net Present Value (manual)  
21 CURRENCY RPM_TV_CURRENCY WAERS CUKY 5   0   Currency key TCURC
22 LOCATION RPM_TV_PROJECT_LOCATION RPM_PROJECT_LOCATION CHAR 4   0   Project Location RPM_PROJ_LOCAT
23 GEOGRAPHY RPM_TV_PROJECT_GEOGRAPHY RPM_PROJECT_GEOGRAPHY CHAR 4   0   Project Geography RPM_PROJ_GEOGR
24 .INCLUDE       0   0   Project attributes  
25 PHASE RPM_PROJECT_PHASE RPM_PROJECT_PHASE NUMC 4   0   Stage *
26 EXSTAT RPM_PROJECT_EXECSTAT RPM_PROJECT_EXECSTAT NUMC 4   0   Project Execution Status RPM_PROJ_EXST
27 COSTF RPM_PROJECT_COST_FORECAST CURR16 CURR 16   2   Planned Cost  
28 COSTA RPM_PROJECT_COST_ACTUAL CURR16 CURR 16   2   Actual Cost  
29 RPM_CHANGED_ON RPM_TV_TIMESTAMP RPM_BCOS_TSTMP DEC 15   0   Time Stamp  
30 ACTUAL_WORK RPM_TV_ACTUAL_WORK   DEC 10   2   Actual Work  
31 PLANNED_WORK RPM_TV_PLANNED_WORK   DEC 10   2   Planned Work  
32 WORK_UNITS RPM_TV_ALLOCATION_UNIT RPM_ALLOCATION_UNIT CHAR 3   0   Assignment Unit  
33 BASELINE_START RPM_TV_BASELINE_START   DATS 8   0   Baseline Start  
34 BASELINE_FINISH RPM_TV_BASELINE_FINISH   DATS 8   0   Baseline Finish  
35 COSTF_TD RPM_PROJECT_COST_FORECAST CURR16 CURR 16   2   Planned Cost  
36 COSTA_TD RPM_PROJECT_COST_ACTUAL CURR16 CURR 16   2   Actual Cost  
37 ANNUAL_BUDGET RPM_PROJECT_BUDGET_PLAN CURR16 CURR 16   2   Budget  
38 .INCLUDE       0   0    
39 .INCLUDE       0   0   RPM: Proj atts derived from externally modifiable attributes  
40 D_PLANSTART RPM_TV_PLANNED_BEGDA DATUM DATS 8   0   Planned Start Date  
41 D_PLANFINISH RPM_TV_PLANNED_ENDDA DATUM DATS 8   0   Planned Finish Date  
42 D_ACTUALSTART RPM_TV_ACTUAL_BEGDA DATUM DATS 8   0   Actual Start Date  
43 D_ACTUALFINISH RPM_TV_ACTUAL_ENDDA DATUM DATS 8   0   Actual Finish Date  
44 .INCLUDE       0   0   RPM: Proj atts derived from externally modifiable attributes  
45 RISK_PRCNT RPM_RISK_LIMIT_HIGH NUMC3 NUMC 3   0   Risk Group - Upper Limit  
46 RISK_GROUP RPM_RISK_GROUP RPM_RISK_GROUP NUMC 2   0   Risk Group Assessed *
47 RISK_ICON RPM_TV_RISK_ICON ICON CHAR 4   0   Project Risk *
48 ECV RPM_TV_ECV /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value (manual)  
49 DERIVED_RISK RPM_TV_RISK_DERIVED NUMC3 NUMC 3   0   Derived Risk  
50 HEADC_ACTUAL RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
51 LOC_GEOGRAPHY RPM_TV_PROJECT_GEOGRAPHY RPM_PROJECT_GEOGRAPHY CHAR 4   0   Project Geography *
52 DEPENDENCY_COUNT RPM_TV_DEPENDENCY_COUNT NUMC3 NUMC 3   0   Number of Project Dependencies.  
53 DEPENDENCY_GROUP RPM_TV_DEPENDENCY_STATUS RPM_DEPENDENCY_STATUS NUMC 4   0   Dependency Status  
54 DEPENDENCY_ICON ICON_D ICON CHAR 4   0   Icon in text fields (substitute display, alias) *
55 DEPEND_ICONNAME ICONNAME ICONNAME CHAR 30   0   Name of an Icon  
56 DEPENDENCY_TEXT RPM_TV_DP_STATGRP_T TEXT30 CHAR 30   0   Dependency:Status Indicator Text  
57 .INCLUDE       0   0   RPM: Proj atts derived from externally modifiable attributes  
58 PRIORITY_PRCNT RPM_PRIORITY_LIMIT_HIGH NUMC4 NUMC 4   0   Project Priority: Upper Limit  
59 PRIORITY_GROUP RPM_PRIORITY_GROUP RPM_PRIORITY_GROUP NUMC 2   0   Priority Group *
60 PRIORITY_ICON RPM_TV_PRIORITY_ICON ICON CHAR 4   0   Priority *
61 BUDGET_PRCNT RPM_TV_BUDGET_LIMIT_HIGH DECV03 DEC 3   0   Project Budget Status: Upper Limit  
62 BUDGET_GROUP RPM_TV_BUDGET_GROUP RPM_BUDGET_GROUP NUMC 2   0   Budget Status Group *
63 BUDGET_ICON RPM_TV_BUDGET_ICON ICON CHAR 4   0   Project Budget *
64 SCHEDULE_PRCNT RPM_TV_SCHEDULE_LIMIT_HIGH NUMC3 NUMC 3   0   Project Schedule Status: Upper Limit  
65 SCHEDULE_GROUP RPM_TV_SCHEDULE_GROUP RPM_SCHEDULE_GROUP NUMC 2   0   Schedule Status Group *
66 SCHEDULE_ICON RPM_TV_SCHEDULE_ICON ICON CHAR 4   0   Project Schedule *
67 STAFFING_PRCNT RPM_TV_SCHEDULE_LIMIT_HIGH NUMC3 NUMC 3   0   Project Schedule Status: Upper Limit  
68 STAFFING_GROUP RPM_TV_STAFFING_GROUP RPM_STAFFING_GROUP NUMC 2   0   Staffing Status Group *
69 STAFFING_ICON RPM_TV_STAFFING_ICON ICON CHAR 4   0   Project Staffing *
70 PHASE_ICON RPM_TV_PHASE_ICON ICON CHAR 4   0   Stage *
71 PHASE_COLOR RPM_TV_STATUS_COLOR RPM_HTML_COLOR CHAR 7   0   Alert Object Color Status  
72 VAR_COST RPM_PROJ_VARIANCE_COST CURR16 CURR 16   2   Total Variance of Project Planned Cost to Actual Cost  
73 VAR_WORK RPM_TV_ACTUAL_WORK   DEC 10   2   Actual Work  
74 VAR_HEADCOUNT RPM_PROJ_VARIANCE_HEADCOUNT   DEC 10   2   Variance of Project Planned and Actual Headcount  
75 VAR_STARTDATE RPM_PROJ_VAR_DAYS   DEC 8   0   Variance Start Date in Days  
76 VAR_FINISHDATE RPM_PROJ_VAR_DAYS_FINISH   DEC 8   0   Variance Finish Date in Days  
77 VAR_COST_TD RPM_PROJ_VARIANCE_COST_TD CURR16 CURR 16   2   YTD Variance of Project Planned Cost to Actual Cost  
78 MASTER_PROJECT RPM_TV_IS_MASTER_PROJECT CHAR1 CHAR 1   0   Master Project Flag  
79 .INCLUDE       0   0   Node neighbor IDs  
80 PARENT_ID RPM_TV_PARENT_EXTID   CHAR 24   0   Parent ID  
81 LEFT_ID RPM_TV_LEFT_EXTID   CHAR 24   0   Left ID  
82 RIGHT_ID RPM_TV_RIGHT_EXTID   CHAR 24   0   Right ID  
83 .INCLUDE       0   0    
84 .INCLUDE       0   0   Master Project Summary Fields  
85 SUM_HEADC RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
86 SUM_BUDGT RPM_PROJECT_BUDGET_PLAN CURR16 CURR 16   2   Budget  
87 SUM_COSTF RPM_PROJECT_COST_FORECAST CURR16 CURR 16   2   Planned Cost  
88 SUM_COSTA RPM_PROJECT_COST_ACTUAL CURR16 CURR 16   2   Actual Cost  
89 SUM_COSTD RPM_PROJECT_COST_DEVELOPMENT /RPM/CURR_16_2 CURR 16   2   Development Cost  
90 SUM_COSTL RPM_PROJECT_COST_LAUNCH /RPM/CURR_16_2 CURR 16   2   Launch Cost  
91 SUM_NPV RPM_PROJECT_NPV /RPM/CURR_16_2 CURR 16   2   Net Present Value (manual)  
92 SUM_CURRENCY RPM_TV_CURRENCY WAERS CUKY 5   0   Currency key *
93 SUM_A_HEADCOUNT RPM_PROJECT_HEADCOUNT /RPM/DEC_10_2 DEC 10   2   Actual Headcount  
94 SUM_A_WORK RPM_TV_ACTUAL_WORK   DEC 10   2   Actual Work  
95 SUM_P_WORK RPM_TV_PLANNED_WORK   DEC 10   2   Planned Work  
96 SUM_WORK_UNITS RPM_TV_ALLOCATION_UNIT RPM_ALLOCATION_UNIT CHAR 3   0   Assignment Unit  
97 SUM_COSTF_TD RPM_PROJECT_COST_FORECAST CURR16 CURR 16   2   Planned Cost  
98 SUM_COSTA_TD RPM_PROJECT_COST_ACTUAL CURR16 CURR 16   2   Actual Cost  
99 SUM_A_BUDGET RPM_PROJECT_BUDGET_PLAN CURR16 CURR 16   2   Budget  
100 SUM_V_COST RPM_PROJ_VARIANCE_COST CURR16 CURR 16   2   Total Variance of Project Planned Cost to Actual Cost  
101 SUM_V_HEADCOUNT RPM_PROJ_VARIANCE_HEADCOUNT   DEC 10   2   Variance of Project Planned and Actual Headcount  
102 SUM_V_WORK RPM_TV_ACTUAL_WORK   DEC 10   2   Actual Work  
103 SUM_V_COST_TD RPM_PROJ_VARIANCE_COST_TD CURR16 CURR 16   2   YTD Variance of Project Planned Cost to Actual Cost  
104 SUM_ECV RPM_TV_ECV /RPM/CURR_16_2 CURR 16   2   Expected Commercial Value (manual)  
105 AVG_PROBT RPM_PROJECT_PROB_TECH NUMC3 NUMC 3   0   Probability of Technical Success  
106 AVG_PROBC RPM_PROJECT_PROB_COMM NUMC3 NUMC 3   0   Probability of Commercial Success  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RPM_TS_MASTER_PROJECT_LIST APSTAT RPM_PROJ_APST APPST REF 1 CN
2 RPM_TS_MASTER_PROJECT_LIST CURRENCY TCURC WAERS REF 1 CN
3 RPM_TS_MASTER_PROJECT_LIST EXSTAT RPM_PROJ_EXST EXCST REF 1 CN
4 RPM_TS_MASTER_PROJECT_LIST GEOGRAPHY RPM_PROJ_GEOGR GEOGRAPHY REF 1 CN
5 RPM_TS_MASTER_PROJECT_LIST LOCATION RPM_PROJ_LOCAT LOCATION REF 1 CN
History
Last changed by/on SAP  20141109 
SAP Release Created in 100