| GUID |
Guid for application objects |
RAW |
16 |
0 |
|
RPM_TV_GUID
|
|
| EXTERNAL_ID |
ID |
CHAR |
24 |
0 |
|
RPM_TV_EXTID
|
|
| CGPL_PROJECT |
|
STRU |
0 |
0 |
|
CGPL_ATTR_INCL
|
|
| PROJECT_GUID |
Project Planning: 16 Character GUID for Projects |
RAW |
16 |
0 |
|
CGPL_PROJECT_GUID
|
|
| OBJECT_TYPE |
Object Type in Project Planning |
CHAR |
3 |
0 |
|
CGPL_OBJECT_TYPE
|
|
| PRIORITY |
Priority |
NUMC |
3 |
0 |
|
CGPL_PRIORITY
|
|
| ACTUALSTART |
Actual Start Date |
DEC |
15 |
0 |
|
CGPL_ACTUALSTART
|
|
| ACTUALFINISH |
Actual Finish Date |
DEC |
15 |
0 |
|
CGPL_ACTUALFINISH
|
|
| PLANSTART |
Planned start date |
DEC |
15 |
0 |
|
CGPL_PLANSTART
|
|
| PLANFINISH |
Planned Finish Date |
DEC |
15 |
0 |
|
CGPL_PLANFINISH
|
|
| COMPLETION |
Percentage of Completion |
NUMC |
3 |
0 |
|
CGPL_COMPLETION
|
|
| MILESTONE |
Milestone indicator |
CHAR |
1 |
0 |
|
CGPL_MILESTONE
|
|
| CONSTRAINT_TYPE |
Type of Scheduling Constraint |
CHAR |
1 |
0 |
|
CGPL_CONSTRAINT
|
| 0 |
Earliest possible |
| 1 |
Latest possible |
| 2 |
Must start on |
| 3 |
Must finish on |
| 4 |
Start no earlier than |
| 5 |
Start no later than |
| 6 |
Finish no earlier than |
| 7 |
Finish no later than |
|
| CONSTRAINT_TIME |
Constraint Date |
DEC |
15 |
0 |
|
CGPL_CONSTRAINT_TIME
|
|
| CREATED_BY |
Name of Person Who Created Object |
CHAR |
12 |
0 |
|
CGPL_CREATED_BY
|
|
| CREATED_ON |
Date When the Object Was Created |
DATS |
8 |
0 |
|
CGPL_CREATED_ON
|
|
| CREATED_IN_BW |
Transfer Object to BW |
CHAR |
1 |
0 |
|
CGPL_CREATED_BW
|
|
| CHANGED_BY |
Name of Person Who Changed Object |
CHAR |
12 |
0 |
|
CGPL_CHANGED_BY
|
|
| CHANGED_ON |
Date on which object was last changed |
DATS |
8 |
0 |
|
CGPL_CHANGED_ON
|
|
| UPDATED_IN_BW |
Current Object in BW |
CHAR |
1 |
0 |
|
CGPL_UPDATED_BW
|
|
| BWIDENTIFIER |
Project Planning - BW Identification |
NUMC |
8 |
0 |
|
CGPL_BWIDENTIFIER
|
|
| PLANGROUP |
Planning Profile Group |
CHAR |
4 |
0 |
|
CGPL_SEM_PLGRP
|
|
| LATEST_START |
Latest start |
DEC |
15 |
0 |
|
CGPL_LATEST_START
|
|
| LATEST_FINISH |
Latest finish date |
DEC |
15 |
0 |
|
CGPL_LATEST_FINISH
|
|
| TOTAL_FLOAT |
Total Float |
DEC |
8 |
2 |
|
CGPL_TOTAL_FLOAT
|
|
| DURATION |
Duration of Execution |
DEC |
8 |
2 |
|
CGPL_DURATION
|
|
| DURATION_UNIT |
Time Unit for Execution Duration |
UNIT |
3 |
0 |
|
CGPL_DURATION_UNIT
|
|
| CALENDAR_ID |
Factory Calendar |
CHAR |
2 |
0 |
|
WFCID
|
|
| CONSTR_TYPE_FIN |
Type of Scheduling Constraint |
CHAR |
1 |
0 |
|
CGPL_CONSTRAINT
|
| 0 |
Earliest possible |
| 1 |
Latest possible |
| 2 |
Must start on |
| 3 |
Must finish on |
| 4 |
Start no earlier than |
| 5 |
Start no later than |
| 6 |
Finish no earlier than |
| 7 |
Finish no later than |
|
| CONSTR_TIME_FIN |
Constraint Date |
DEC |
15 |
0 |
|
CGPL_CONSTRAINT_TIME
|
|
| APPLICATION |
Application in Project Planning |
CHAR |
3 |
0 |
|
CGPL_APPLICATION_TYPE
|
|
| FORECAST_START |
Forecast Start |
DEC |
15 |
0 |
|
CGPL_FORECAST_START
|
|
| FORECAST_FINISH |
Forecast Finish |
DEC |
15 |
0 |
|
CGPL_FORECAST_FINISH
|
|
| RPM_PROJECT |
|
STRU |
0 |
0 |
|
RPM_TS_PROJECT_ATT
|
|
| CATEGORY |
Category |
NUMC |
4 |
0 |
|
RPM_PROJECT_CATEGORY
|
|
| SUBCATEGORY |
Subcategory |
NUMC |
4 |
0 |
|
RPM_PROJ_SUBCATEGORY
|
|
| PHASE |
Stage |
NUMC |
4 |
0 |
|
RPM_PROJECT_PHASE
|
|
| PTYPE |
Group |
NUMC |
4 |
0 |
|
RPM_PROJECTTYPE
|
|
| TTYPE |
Technology Type |
NUMC |
4 |
0 |
|
RPM_PROJECT_TECHTYPE
|
|
| APSTAT |
Project Approval Status |
NUMC |
4 |
0 |
|
RPM_PROJECT_APPST
|
|
| EXSTAT |
Project Execution Status |
NUMC |
4 |
0 |
|
RPM_PROJECT_EXECSTAT
|
|
| PPRIO |
Project Priority |
NUMC |
4 |
0 |
|
RPM_PROJECT_PRIORITY
|
|
| RISKA |
Assessed Project Risk |
NUMC |
3 |
0 |
|
RPM_PROJECT_RISK_ASSESED
|
|
| PROBT |
Probability of Technical Success |
NUMC |
3 |
0 |
|
RPM_PROJECT_PROB_TECH
|
|
| PROBC |
Probability of Commercial Success |
NUMC |
3 |
0 |
|
RPM_PROJECT_PROB_COMM
|
|
| HEADC |
Actual Headcount |
DEC |
10 |
2 |
|
RPM_PROJECT_HEADCOUNT
|
|
| BUDGT |
Budget |
CURR |
16 |
2 |
|
RPM_PROJECT_BUDGET_PLAN
|
|
| COSTF |
Planned Cost |
CURR |
16 |
2 |
|
RPM_PROJECT_COST_FORECAST
|
|
| COSTA |
Actual Cost |
CURR |
16 |
2 |
|
RPM_PROJECT_COST_ACTUAL
|
|
| COSTD |
Development Cost |
CURR |
16 |
2 |
|
RPM_PROJECT_COST_DEVELOPMENT
|
|
| COSTL |
Launch Cost |
CURR |
16 |
2 |
|
RPM_PROJECT_COST_LAUNCH
|
|
| NPV |
Net Present Value (manual) |
CURR |
16 |
2 |
|
RPM_PROJECT_NPV
|
|
| CURRENCY |
Currency key |
CUKY |
5 |
0 |
|
RPM_TV_CURRENCY
|
|
| LOCATION |
Location |
CHAR |
4 |
0 |
|
DPR_TV_LOCATION
|
|
| GEOGRAPHY |
Area |
CHAR |
4 |
0 |
|
DPR_TV_AREA
|
|
| ACTUAL_HEADCOUNT |
Actual Headcount |
DEC |
10 |
2 |
|
RPM_TV_HEADCOUNT
|
|
| RPM_CHANGED_ON |
Time Stamp |
DEC |
15 |
0 |
|
RPM_TV_TIMESTAMP
|
|
| ACTUAL_WORK |
Actual Work |
DEC |
10 |
2 |
|
RPM_TV_ACTUAL_WORK
|
|
| PLANNED_WORK |
Planned Work |
DEC |
10 |
2 |
|
RPM_TV_PLANNED_WORK
|
|
| WORK_UNITS |
Assignment Unit |
CHAR |
3 |
0 |
|
RPM_TV_ALLOCATION_UNIT
|
|
| BASELINE_START |
Baseline Start |
DATS |
8 |
0 |
|
RPM_TV_BASELINE_START
|
|
| BASELINE_FINISH |
Baseline Finish |
DATS |
8 |
0 |
|
RPM_TV_BASELINE_FINISH
|
|
| COSTF_TD |
Planned Cost |
CURR |
16 |
2 |
|
RPM_PROJECT_COST_FORECAST
|
|
| COSTA_TD |
Actual Cost |
CURR |
16 |
2 |
|
RPM_PROJECT_COST_ACTUAL
|
|
| ANNUAL_BUDGET |
Budget |
CURR |
16 |
2 |
|
RPM_PROJECT_BUDGET_PLAN
|
|
| PERIODTYPE |
Period Type (Weekly/Monthly/Generic Interval) |
NUMC |
2 |
0 |
|
RPM_TV_AVLB_PERIOD
|
|
| UNIT |
Project Resource Supply - Unit |
CHAR |
3 |
0 |
|
RPM_TV_RESOURCE_AVAIL_UNIT
|
|
| VERSION |
Project Version Type |
CHAR |
1 |
0 |
|
RPM_TV_VERSION_TYPE
|
|
| ITEM_TYPE |
Type |
CHAR |
15 |
0 |
|
/RPM/TV_ITEM_ID
|
|
| PORTFL_ITEM_GUID |
Guid for application objects |
RAW |
16 |
0 |
|
RPM_TV_GUID
|
|
| ESCALATION |
Escalation Flag |
CHAR |
1 |
0 |
|
RPM_TV_ESCALATION
|
|
| FORECAST_START |
Forecasted Start |
DATS |
8 |
0 |
|
RPM_TV_FORECAST_START
|
|
| PLANNED_START |
Planned Start Date |
DATS |
8 |
0 |
|
RPM_TV_PLAN_START
|
|
| ACTUAL_START |
Actual Start Date |
DATS |
8 |
0 |
|
RPM_TV_ACTUAL_START
|
|
| FORECAST_FINISH |
Forecasted Finish Date |
DATS |
8 |
0 |
|
RPM_TV_FORECAST_FINISH
|
|
| PLANNED_FINISH |
Planned Finish Date |
DATS |
8 |
0 |
|
RPM_TV_PLAN_FINISH
|
|
| ACTUAL_FINISH |
Actual Finish Date |
DATS |
8 |
0 |
|
RPM_TV_ACTUAL_FINISH
|
|
| PORTFOLIO_GUID |
Guid for application objects |
RAW |
16 |
0 |
|
RPM_TV_GUID
|
|
| PARENT_GUID |
Guid for application objects |
RAW |
16 |
0 |
|
RPM_TV_GUID
|
|
| ECV |
Expected Commercial Value (manual) |
CURR |
16 |
2 |
|
RPM_TV_ECV
|
|
| PRIORITY_GROUP |
Priority Group |
NUMC |
2 |
0 |
|
RPM_PRIORITY_GROUP
|
|
| CHANGED_BY |
User Name |
CHAR |
12 |
0 |
|
UNAME
|
|
| VERSION_ITEM |
Single-Character Flag |
CHAR |
1 |
0 |
|
CHAR1
|
|
| ITEM_CLASS |
Item Classification |
CHAR |
1 |
0 |
|
/RPM/TV_ITEM_CLASS
|
|
| MASTER_ITEM_GUID |
Guid for application objects |
RAW |
16 |
0 |
|
RPM_TV_GUID
|
|
| STATUS |
Status |
CHAR |
5 |
0 |
|
/RPM/TV_STATUS_COMMON
|
|
| CAP_PERIODTYPE |
Capacity Period Breakdown |
NUMC |
2 |
0 |
|
/RPM/TV_CAP_PERIOD_TYPE
|
|
| ACT_DPCPT_GUID |
Guid for application objects |
RAW |
16 |
0 |
|
/RPM/TV_GUID
|
|
| DISCOUNT_RATE |
Discount Rate |
DEC |
5 |
2 |
|
/RPM/TV_DISCOUNT_RATE
|
|
| INITIATIVE_GUID |
Guid for application objects |
RAW |
16 |
0 |
|
RPM_TV_GUID
|
|
| FRCST_BGT_TOTAL |
Portfolio Item Forecasted Budget Total |
CURR |
16 |
2 |
|
/RPM/TV_FORECASTED_BUDGT_TOTAL
|
|
| FRCST_BGTANNUAL |
Portfolio Item Forecasted Budget Annual |
CURR |
16 |
2 |
|
/RPM/TV_FORECASTED_BUDGT_ANNL
|
|
| FRCST_COSTTOTAL |
Portfolio Item Forecasted Cost Total |
CURR |
16 |
2 |
|
/RPM/TV_FORECASTED_COST_TOTAL
|
|
| FRCST_COST_YTD |
Portfolio Item Forecasted Cost YTD |
CURR |
16 |
2 |
|
/RPM/TV_FORECASTED_COST_YTD
|
|
| TEMPLATE_GUID |
Guid for application objects |
RAW |
16 |
0 |
|
/RPM/TV_GUID
|
|
| IS_GLOBAL |
Global Template |
CHAR |
1 |
0 |
|
/RPM/TV_GLOBAL
|
|
| EA_DUMMY |
Dummy Data Element for Enhanced xRPM Attributes |
CHAR |
1 |
0 |
|
/RPM/TV_EA_DUMMY
|
|
| RPM_PROJECT_STKHLDR |
|
TTYP |
0 |
0 |
|
RPM_TT_PROJ_STKHLD_WITH_BUPA
|
|
| DEPENDENCIES_INT |
|
TTYP |
0 |
0 |
|
RPM_TT_PROJ_DEPENDENCY_INT
|
|
| RPM_ILINKS |
|
TTYP |
0 |
0 |
|
/RPM/TT_ITEM_ILINKS
|
|
| ITEM_DER |
|
STRU |
0 |
0 |
|
/RPM/TS_ITEM_D_DERIVED_ATT
|
|
| PRIORITY_ICON |
Priority |
CHAR |
4 |
0 |
|
/RPM/TV_PRIORITY_ICON
|
|
| RISK_PRCNT |
Risk Group - Upper Limit |
NUMC |
3 |
0 |
|
RPM_RISK_LIMIT_HIGH
|
|
| RISK_GROUP |
Risk Group Assessed |
NUMC |
2 |
0 |
|
RPM_RISK_GROUP
|
|
| RISK_ICON |
Risk |
CHAR |
4 |
0 |
|
/RPM/TV_RISK_ICON
|
|
| PHASE_ICON |
Phase |
CHAR |
4 |
0 |
|
/RPM/TV_PHASE_ICON
|
|
| PHASE_COLOR |
Alert Object Color Status |
CHAR |
7 |
0 |
|
RPM_TV_STATUS_COLOR
|
|
| DERIVED_RISK |
Derived Risk |
NUMC |
3 |
0 |
|
RPM_TV_RISK_DERIVED
|
|
| D_PLANSTART |
Planned Start |
DATS |
8 |
0 |
|
/RPM/TV_DP_PLAN_START
|
|
| D_PLANFINISH |
Planned Finish |
DATS |
8 |
0 |
|
/RPM/TV_DP_PLAN_FINISH
|
|
| D_ACTUALSTART |
Actual Start |
DATS |
8 |
0 |
|
/RPM/TV_DP_ACTUAL_START
|
|
| D_ACTUALFINISH |
Actual Finish Date |
DATS |
8 |
0 |
|
/RPM/TV_DP_ACTUAL_FINISH
|
|
| HEADC_ACTUAL |
Actual Headcount |
DEC |
10 |
2 |
|
RPM_PROJECT_HEADCOUNT
|
|
| BEGDA_DEM |
Demand Planning Start |
DATS |
8 |
0 |
|
/RPM/TV_PP_START_DEM
|
|
| ENDDA_DEM |
Demand Planning Period Finish Date |
DATS |
8 |
0 |
|
/RPM/TV_PP_END_DEM
|
|
| BEGDA_FIN |
Financial Planning Period Start |
DATS |
8 |
0 |
|
/RPM/TV_PP_START_FIN
|
|
| ENDDA_FIN |
Financial Plan Period Finish Date |
DATS |
8 |
0 |
|
/RPM/TV_PP_END_FIN
|
|
| BUCKET_NAME |
Bucket Name |
CHAR |
40 |
0 |
|
/RPM/TV_BUCKET_NAME
|
|
| BUCKET_ID |
Bucket ID |
CHAR |
24 |
0 |
|
/RPM/TV_BUCKET_ID
|
|
| PROPOSAL |
Proposal |
CHAR |
1 |
0 |
|
/RPM/TV_PROPOSAL
|
|
| D_CHANGED_ON |
Changed On Date |
DATS |
8 |
0 |
|
/RPM/TV_LAST_CHANGED_ON
|
|
| MASTER_ITEM_NAME |
Initiative Name |
CHAR |
40 |
0 |
|
/RPM/TV_MASTER_ITEM_NAME
|
|
| MASTER_ITEM_ID |
Initiative ID |
CHAR |
24 |
0 |
|
/RPM/TV_MASTER_ITEM_ID
|
|
| HAS_CHILDREN |
Has Children |
CHAR |
1 |
0 |
|
/RPM/TV_ITEM_CHILDREN
|
|
| BUDGET_ICON |
Budget |
CHAR |
4 |
0 |
|
/RPM/TV_BUDGET_ICON
|
|
| SCHEDULE_ICON |
Schedule |
CHAR |
4 |
0 |
|
/RPM/TV_SCHEDULE_ICON
|
|
| STAFFING_ICON |
Staffing |
CHAR |
4 |
0 |
|
/RPM/TV_STAFFING_ICON
|
|
| BUDGET_TOTAL |
Total Budget |
CURR |
16 |
2 |
|
/RPM/TV_BUDGET_TOTAL
|
|
| BUDGET_ANNUAL |
Annual Budget |
CURR |
16 |
2 |
|
/RPM/TV_BUDGET_ANNUAL
|
|
| PLANNED_COST |
Planned Costs |
CURR |
16 |
2 |
|
/RPM/TV_PLANNED_COST
|
|
| PLANNED_COST_YTD |
Planned Costs Year to Date |
CURR |
16 |
2 |
|
/RPM/TV_PLANNED_COST_YTD
|
|
| ACTUAL_COST |
Actual Costs |
CURR |
16 |
2 |
|
/RPM/TV_ACTUAL_COST
|
|
| ACTUAL_COST_YTD |
Actual Cost Year to Day |
CURR |
16 |
2 |
|
/RPM/TV_ACTUAL_COST_YTD
|
|
| ACT_DECPT_NAME |
Decision Point Name |
CHAR |
80 |
0 |
|
/RPM/TV_PHASE_T
|
|
| ACT_DECPT_STAT_TEXT |
Active Decision Point Status Text |
CHAR |
40 |
0 |
|
/RPM/TV_STATUS_TEXT
|
|
| ACT_DECPT_STAT_ICON |
Active Decision Point Status |
CHAR |
4 |
0 |
|
/RPM/TV_DECPT_STATUS_ICON
|
|
| DECPT_INFO |
Decision Point Info |
CHAR |
20 |
0 |
|
/RPM/TV_DECPT_INFO
|
|
| STATUS_GROUP |
Status Group |
CHAR |
4 |
0 |
|
/RPM/TV_ITEM_STATUS_GROUP
|
|
| FORECASTED_DURATION |
Forecasted Duration |
QUAN |
4 |
0 |
|
/RPM/TV_FORCASTED_DURATION
|
|
| PLANNED_DURATION |
Planned Duration |
QUAN |
4 |
0 |
|
/RPM/TV_PLANNED_DURATION
|
|
| ACTUAL_DURATION |
Actual Duration |
QUAN |
4 |
0 |
|
/RPM/TV_ACTUAL_DURATION
|
|
| ACT_PHASE_GUID |
Application Object GUID |
RAW |
16 |
0 |
|
DPR_TV_GUID
|
|
| WORKEFFORT_TOTAL |
Actual Effort |
DEC |
26 |
2 |
|
/RPM/TV_WORK_EFFORT_TOTAL
|
|
| WORKEFFORT_YTD |
Actual Work Effort Year-To-Date |
DEC |
26 |
2 |
|
/RPM/TV_WORK_EFFORT_YTD
|
|
| PLANNED_EFFORT |
Planned Effort |
DEC |
26 |
2 |
|
/RPM/TV_PLAN_EFFORT
|
|
| PLANNED_EFFORT_YTD |
Planned Effort Year-To-Date |
DEC |
26 |
2 |
|
/RPM/TV_PLAN_EFFORT_YTD
|
|
| ROI |
Return on Investment in % (manual) |
CURR |
16 |
2 |
|
/RPM/TV_ROI
|
|
| IRR |
Internal Rate of Return in % (manual) |
CURR |
16 |
2 |
|
/RPM/TV_IRR
|
|
| RISK_GROUP_D |
Risk Group Derived |
NUMC |
2 |
0 |
|
/RPM/RISK_GROUP_D
|
|
| RISK_D_ICON |
Derived Risk |
CHAR |
4 |
0 |
|
/RPM/TV_RISK_ICON_D
|
|
| PLANNED_DECISION_DATE |
Planned Decision date |
DATS |
8 |
0 |
|
/RPM/TV_PLAND_DDATE
|
|
| ACTUAL_DECISION_DATE |
Actual Decision Date |
DATS |
8 |
0 |
|
/RPM/TV_ACTUAL_DDATE
|
|
| FORECAST_DEC_DATE |
Forecasted Decision Date |
DATS |
8 |
0 |
|
/RPM/TV_FORECAST_DDATE
|
|
| D_FORECASTED_START |
Forecasted Start |
DATS |
8 |
0 |
|
RPM_TV_DP_FORECAST_START
|
|
| D_FORECASTED_FINISH |
Forecasted Finish Date |
DATS |
8 |
0 |
|
RPM_TV_DP_FORECAST_FINISH
|
|
| BUDGET_GROUP |
Budget Status Group |
NUMC |
2 |
0 |
|
RPM_TV_BUDGET_GROUP
|
|
| SCHEDULE_GROUP |
Schedule Status Group |
NUMC |
2 |
0 |
|
RPM_TV_SCHEDULE_GROUP
|
|
| STAFFING_GROUP |
Staffing Status Group |
NUMC |
2 |
0 |
|
RPM_TV_STAFFING_GROUP
|
|
| PORTFOLIO_NAME |
Portfolio Name |
CHAR |
40 |
0 |
|
/RPM/TV_PORTFOLIO_NAME
|
|
| PORTFOLIO_ID |
Portfolio ID |
CHAR |
24 |
0 |
|
/RPM/TV_PORTFOLIO_ID
|
|
| PLANNED_REVENUE |
Planned Revenues |
CURR |
16 |
2 |
|
/RPM/TV_PLANNED_REVENUE
|
|
| PLANNED_REV_YTD |
Planned Revenues Year to Date |
CURR |
16 |
2 |
|
/RPM/TV_PLANNED_REVENUE_YTD
|
|
| ACTUAL_REVENUE |
Actual Revenues |
CURR |
16 |
2 |
|
/RPM/TV_ACTUAL_REVENUE
|
|
| CALENDAR |
Object Text |
CHAR |
60 |
0 |
|
FKTEXT
|
|
| ACTUAL_REV_YTD |
Actual Revenues Year to Day |
CURR |
16 |
2 |
|
/RPM/TV_ACTUAL_REVENUE_YTD
|
|
| NPV_PLAN |
Net Present Value |
CURR |
16 |
2 |
|
/RPM/TV_NPV_PLAN
|
|
| IRR_PLAN |
Internal Rate of Return in % |
CURR |
16 |
2 |
|
/RPM/TV_IRR_PLAN
|
|
| ROI_PLAN |
Return on Investment in % |
CURR |
16 |
2 |
|
/RPM/TV_ROI_PLAN
|
|
| PAYBACK_PLAN |
Payback Periods in Months |
NUMC |
6 |
0 |
|
/RPM/TV_PAYBACK_PLAN
|
|
| ECV_PLAN |
Expected Commercial Value |
CURR |
16 |
2 |
|
/RPM/TV_ECV_PLAN
|
|
| EA_DUMMY_KPI |
Single-Character Flag |
CHAR |
1 |
0 |
|
CHAR1
|
|