1. Home
  2. Resources
  3. SAP Tables
  4. RPM_TS_PROJECT_INT - Project attributes

SAP Table RPM_TS_PROJECT_INT

Project attributes

RPM_TS_PROJECT_INT (Project attributes) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RPM_TS_PROJECT_INT to other SAP tables.

Source: RPM_TS_PROJECT_INT (Project attributes)

RPM_TS_PROJECT_INT table fields

Field Data element Checktable Datatype Length Decimals
GUID Guid for application objects RPM_TV_GUID RAW 16 0
EXTERNAL_ID ID RPM_TV_EXTID CHAR 24 0
CGPL_PROJECT CGPL_ATTR_INCL STRU 0 0
PROJECT_GUID Project Planning: 16 Character GUID for Projects CGPL_PROJECT_GUID RAW 16 0
OBJECT_TYPE Object Type in Project Planning CGPL_OBJECT_TYPE CHAR 3 0
PRIORITY Priority CGPL_PRIORITY NUMC 3 0
ACTUALSTART Actual Start Date CGPL_ACTUALSTART DEC 15 0
ACTUALFINISH Actual Finish Date CGPL_ACTUALFINISH DEC 15 0
PLANSTART Planned start date CGPL_PLANSTART DEC 15 0
PLANFINISH Planned Finish Date CGPL_PLANFINISH DEC 15 0
COMPLETION Percentage of Completion CGPL_COMPLETION NUMC 3 0
000 0 - 100
MILESTONE Milestone indicator CGPL_MILESTONE CHAR 1 0
CONSTRAINT_TYPE Type of Scheduling Constraint CGPL_CONSTRAINT CHAR 1 0
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 CGPL_CONSTRAINT_TIME DEC 15 0
CREATED_BY Name of Person Who Created Object CGPL_CREATED_BY CHAR 12 0
CREATED_ON Date When the Object Was Created CGPL_CREATED_ON DATS 8 0
CREATED_IN_BW Transfer Object to BW CGPL_CREATED_BW CHAR 1 0
CHANGED_BY Name of Person Who Changed Object CGPL_CHANGED_BY CHAR 12 0
CHANGED_ON Date on which object was last changed CGPL_CHANGED_ON DATS 8 0
UPDATED_IN_BW Current Object in BW CGPL_UPDATED_BW CHAR 1 0
BWIDENTIFIER Project Planning - BW Identification CGPL_BWIDENTIFIER NUMC 8 0
PLANGROUP Planning Profile Group CGPL_SEM_PLGRP CHAR 4 0
LATEST_START Latest start CGPL_LATEST_START DEC 15 0
LATEST_FINISH Latest finish date CGPL_LATEST_FINISH DEC 15 0
TOTAL_FLOAT Total Float CGPL_TOTAL_FLOAT DEC 8 2
DURATION Duration of Execution CGPL_DURATION DEC 8 2
DURATION_UNIT Time Unit for Execution Duration CGPL_DURATION_UNIT UNIT 3 0
CALENDAR_ID Factory Calendar WFCID CHAR 2 0
CONSTR_TYPE_FIN Type of Scheduling Constraint CGPL_CONSTRAINT CHAR 1 0
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 CGPL_CONSTRAINT_TIME DEC 15 0
APPLICATION Application in Project Planning CGPL_APPLICATION_TYPE CHAR 3 0
FORECAST_START Forecast Start CGPL_FORECAST_START DEC 15 0
FORECAST_FINISH Forecast Finish CGPL_FORECAST_FINISH DEC 15 0
RPM_PROJECT RPM_TS_PROJECT_ATT STRU 0 0
CATEGORY Category RPM_PROJECT_CATEGORY NUMC 4 0
SUBCATEGORY Subcategory RPM_PROJ_SUBCATEGORY NUMC 4 0
PHASE Stage RPM_PROJECT_PHASE NUMC 4 0
PTYPE Group RPM_PROJECTTYPE NUMC 4 0
TTYPE Technology Type RPM_PROJECT_TECHTYPE NUMC 4 0
APSTAT Project Approval Status RPM_PROJECT_APPST NUMC 4 0
EXSTAT Project Execution Status RPM_PROJECT_EXECSTAT NUMC 4 0
PPRIO Project Priority RPM_PROJECT_PRIORITY NUMC 4 0
RISKA Assessed Project Risk RPM_PROJECT_RISK_ASSESED NUMC 3 0
PROBT Probability of Technical Success RPM_PROJECT_PROB_TECH NUMC 3 0
PROBC Probability of Commercial Success RPM_PROJECT_PROB_COMM NUMC 3 0
HEADC Actual Headcount RPM_PROJECT_HEADCOUNT DEC 10 2
BUDGT Budget RPM_PROJECT_BUDGET_PLAN CURR 16 2
COSTF Planned Cost RPM_PROJECT_COST_FORECAST CURR 16 2
COSTA Actual Cost RPM_PROJECT_COST_ACTUAL CURR 16 2
COSTD Development Cost RPM_PROJECT_COST_DEVELOPMENT CURR 16 2
COSTL Launch Cost RPM_PROJECT_COST_LAUNCH CURR 16 2
NPV Net Present Value (manual) RPM_PROJECT_NPV CURR 16 2
CURRENCY Currency key RPM_TV_CURRENCY CUKY 5 0
LOCATION Location DPR_TV_LOCATION CHAR 4 0
GEOGRAPHY Area DPR_TV_AREA CHAR 4 0
ACTUAL_HEADCOUNT Actual Headcount RPM_TV_HEADCOUNT DEC 10 2
RPM_CHANGED_ON Time Stamp RPM_TV_TIMESTAMP DEC 15 0
ACTUAL_WORK Actual Work RPM_TV_ACTUAL_WORK DEC 10 2
PLANNED_WORK Planned Work RPM_TV_PLANNED_WORK DEC 10 2
WORK_UNITS Assignment Unit RPM_TV_ALLOCATION_UNIT CHAR 3 0
FTE Full Time Equivalents
DAY Person Days
HRS Hours Worked
BASELINE_START Baseline Start RPM_TV_BASELINE_START DATS 8 0
BASELINE_FINISH Baseline Finish RPM_TV_BASELINE_FINISH DATS 8 0
COSTF_TD Planned Cost RPM_PROJECT_COST_FORECAST CURR 16 2
COSTA_TD Actual Cost RPM_PROJECT_COST_ACTUAL CURR 16 2
ANNUAL_BUDGET Budget RPM_PROJECT_BUDGET_PLAN CURR 16 2
PERIODTYPE Period Type (Weekly/Monthly/Generic Interval) RPM_TV_AVLB_PERIOD NUMC 2 0
01 Month
02 Week
04 Generic Interval
UNIT Project Resource Supply - Unit RPM_TV_RESOURCE_AVAIL_UNIT CHAR 3 0
FTE Full Time Equivalents
DAY Person Days
HRS Hours Worked
VERSION Project Version Type RPM_TV_VERSION_TYPE CHAR 1 0
NULL Not a version - original Project
1 What-If Scenario Version
2 What-if Scenario version with Cap. Mgmt
ITEM_TYPE Type /RPM/TV_ITEM_ID CHAR 15 0
PORTFL_ITEM_GUID Guid for application objects RPM_TV_GUID RAW 16 0
ESCALATION Escalation Flag RPM_TV_ESCALATION CHAR 1 0
X Yes
NULL No
FORECAST_START Forecasted Start RPM_TV_FORECAST_START DATS 8 0
PLANNED_START Planned Start Date RPM_TV_PLAN_START DATS 8 0
ACTUAL_START Actual Start Date RPM_TV_ACTUAL_START DATS 8 0
FORECAST_FINISH Forecasted Finish Date RPM_TV_FORECAST_FINISH DATS 8 0
PLANNED_FINISH Planned Finish Date RPM_TV_PLAN_FINISH DATS 8 0
ACTUAL_FINISH Actual Finish Date RPM_TV_ACTUAL_FINISH DATS 8 0
PORTFOLIO_GUID Guid for application objects RPM_TV_GUID RAW 16 0
PARENT_GUID Guid for application objects RPM_TV_GUID RAW 16 0
ECV Expected Commercial Value (manual) RPM_TV_ECV CURR 16 2
PRIORITY_GROUP Priority Group RPM_PRIORITY_GROUP NUMC 2 0
CHANGED_BY User Name UNAME CHAR 12 0
VERSION_ITEM Single-Character Indicator CHAR1 CHAR 1 0
ITEM_CLASS Item Classification /RPM/TV_ITEM_CLASS CHAR 1 0
NULL Item
1 Item of an Initiative
2 Sub Item
4 Item Template
MASTER_ITEM_GUID Guid for application objects RPM_TV_GUID RAW 16 0
STATUS Status /RPM/TV_STATUS_COMMON CHAR 5 0
CAP_PERIODTYPE Capacity Period Breakdown /RPM/TV_CAP_PERIOD_TYPE NUMC 2 0
ACT_DPCPT_GUID Guid for application objects /RPM/TV_GUID RAW 16 0
DISCOUNT_RATE Discount Rate /RPM/TV_DISCOUNT_RATE DEC 5 2
INITIATIVE_GUID Guid for application objects RPM_TV_GUID RAW 16 0
FRCST_BGT_TOTAL Portfolio Item Forecasted Budget Total /RPM/TV_FORECASTED_BUDGT_TOTAL CURR 16 2
FRCST_BGTANNUAL Portfolio Item Forecasted Budget Annual /RPM/TV_FORECASTED_BUDGT_ANNL CURR 16 2
FRCST_COSTTOTAL Portfolio Item Forecasted Cost Total /RPM/TV_FORECASTED_COST_TOTAL CURR 16 2
FRCST_COST_YTD Portfolio Item Forecasted Cost YTD /RPM/TV_FORECASTED_COST_YTD CURR 16 2
TEMPLATE_GUID Guid for application objects /RPM/TV_GUID RAW 16 0
IS_GLOBAL Global Template /RPM/TV_GLOBAL CHAR 1 0
X Yes
NULL No
EA_DUMMY Dummy Data Element for Enhanced xRPM Attributes /RPM/TV_EA_DUMMY CHAR 1 0
ZRDS_BUDGET Custom Field Budget Status (RDS) ZRDS_BUDGETSTATUS CHAR 2 0
01 Budget Proposal
02 Budget Approved
03 Budget Replanned
04 Budget Reapproved
05 Budget Declined
ZRDS_STRATFIT KPI Strategic Fit Questionnaire (RDS) ZRDS_STRATFIT INT1 3 0
ZRDS_TECHRISK KPI Technological Risk Questionnaire (RDS) ZRDS_TECHRISK INT1 3 0
ZRDS_SOCRISK KPI Social Risk Questionnaire (RDS) ZRDS_SOCRISK INT1 3 0
ZRDS_OVSCORE KPI Overall Score (RDS) ZRDS_OVSCORE INT1 3 0
ZRDS_BUDGET_S Custom Field Budget Status (RDS PPM) ZRDS_BUDGET_STATUS CHAR 2 0
01 Budget Proposed
02 Budget Approved
03 Budget Replanned
04 Budget Reapproved
05 Budget Declined
ZRDS_OVASCORE KPI Overall Score Scoring Model (RDS PPM) ZRDS_OVALLSCORE INT1 3 0
ZANUAL_ES Estimated Energy Savings/year(GJ) ZANUAL_ES NUMC 5 0
ZANUAL_CS Estimated Savings $ ZANUAL_CS CURR 16 2
ZIMP_COST Estimated Costs $ ZIMP_COST CURR 16 2
ZANNUAL_COST Annual Costs $ ZANNUAL_COST CURR 16 2
ZSPEND_CAT Spend Category ZPEND_CAT CHAR 60 0
01 Capital
02 Operating
ZROI 3-Year ROI % ZROI INT4 10 0
ZPAYBK Estimated Payback Period (months) ZPAYBK NUMC 5 0
ZAPPROVER APPROVER ZAPPROVER CHAR 60 0
01 01
02 02
ZTEST Approver ZTEST CHAR 60 0
ZACTROI 3-Year Actual ROI % ZACTROI INT4 10 0
ZANUAL_ACTES Actual Energy Savings/Year (GJ) ZANUAL_ACTES NUMC 5 0
ZIMP_ACOST Actual Costs $ ZIMP_ACTCOST CURR 16 2
ZACRPAYBK Actual Payback Period (months) ZACRPAYBK NUMC 5 0
ZANUAL_ACTCS Actual Savings $ ZANUAL_ACTCS CURR 16 2
ZITSPONSOR IT Sponsor ZITSPONSOR CHAR 40 0
ZBS Business Sponsor ZBS CHAR 40 0
RPM_PROJECT_STKHLDR RPM_TT_PROJ_STKHLD_WITH_BUPA TTYP 0 0
DEPENDENCIES_INT RPM_TT_PROJ_DEPENDENCY_INT TTYP 0 0
RPM_ILINKS /RPM/TT_ITEM_ILINKS TTYP 0 0
ITEM_DER /RPM/TS_ITEM_D_DERIVED_ATT STRU 0 0
PRIORITY_ICON Priority /RPM/TV_PRIORITY_ICON CHAR 4 0
RISK_PRCNT Risk Group - Upper Limit RPM_RISK_LIMIT_HIGH NUMC 3 0
RISK_GROUP Risk Group Assessed RPM_RISK_GROUP NUMC 2 0
RISK_ICON Risk /RPM/TV_RISK_ICON CHAR 4 0
PHASE_ICON Phase /RPM/TV_PHASE_ICON CHAR 4 0
PHASE_COLOR Alert Object Color Status RPM_TV_STATUS_COLOR CHAR 7 0
#FFFF00 Yellow default
#FFFFCC Yellow 1
#FFFF77 Yellow 2
#FFED00 Yellow 4
#FFDC11 Yellow 5
#00CF00 Green default
#CCFF77 Green 2
#CCFF00 Green 3
#CCED00 Green 4
#CCDC11 Green 5
#AADDFF Blue 1
#88CCFF Blue 2
#44BBFF Blue 3
#2288FF Blue 4
#0055FF Blue 5
#FF0000 Red default
#FF9999 Red 1
#FF6666 Red 2
#FF3333 Red 3
#FF1100 Red 4
#EE1100 Red 5
#FFCC99 Brown 1
#DD9966 Brown 2
#CC6622 Brown 3
#996600 Brown 4
#663300 Brown 5
#CC99FF Purple 1
#CC66FF Purple 2
#9933FF Purple 3
#6633CC Purple 4
#660099 Purple 5
#FF9900 Orange default
#FFCC77 Orange 1
#FFCC33 Orange 2
#FFBB00 Orange 3
#FF7700 Orange 5
#FFFFFF White
#000000 Black
#FF00FF Pink
#E8E8D3 Beige
#000080 Dark Blue
#00FFFF Turquoise
DERIVED_RISK Derived Risk RPM_TV_RISK_DERIVED NUMC 3 0
D_PLANSTART Planned Start /RPM/TV_DP_PLAN_START DATS 8 0
D_PLANFINISH Planned Finish /RPM/TV_DP_PLAN_FINISH DATS 8 0
D_ACTUALSTART Actual Start /RPM/TV_DP_ACTUAL_START DATS 8 0
D_ACTUALFINISH Actual Finish Date /RPM/TV_DP_ACTUAL_FINISH DATS 8 0
HEADC_ACTUAL Actual Headcount RPM_PROJECT_HEADCOUNT DEC 10 2
BEGDA_DEM Demand Planning Start /RPM/TV_PP_START_DEM DATS 8 0
ENDDA_DEM Demand Planning Period Finish Date /RPM/TV_PP_END_DEM DATS 8 0
BEGDA_FIN Financial Planning Period Start /RPM/TV_PP_START_FIN DATS 8 0
ENDDA_FIN Financial Plan Period Finish Date /RPM/TV_PP_END_FIN DATS 8 0
BUCKET_NAME Bucket Name /RPM/TV_BUCKET_NAME CHAR 40 0
BUCKET_ID Bucket ID /RPM/TV_BUCKET_ID CHAR 24 0
PROPOSAL Proposal /RPM/TV_PROPOSAL CHAR 1 0
X Yes
NULL No
D_CHANGED_ON Changed On Date /RPM/TV_LAST_CHANGED_ON DATS 8 0
MASTER_ITEM_NAME Initiative Name /RPM/TV_MASTER_ITEM_NAME CHAR 40 0
MASTER_ITEM_ID Initiative ID /RPM/TV_MASTER_ITEM_ID CHAR 24 0
HAS_CHILDREN Has Children /RPM/TV_ITEM_CHILDREN CHAR 1 0
X Yes
NULL No
BUDGET_ICON Budget /RPM/TV_BUDGET_ICON CHAR 4 0
SCHEDULE_ICON Schedule /RPM/TV_SCHEDULE_ICON CHAR 4 0
STAFFING_ICON Staffing /RPM/TV_STAFFING_ICON CHAR 4 0
BUDGET_TOTAL Total Budget /RPM/TV_BUDGET_TOTAL CURR 16 2
BUDGET_ANNUAL Annual Budget /RPM/TV_BUDGET_ANNUAL CURR 16 2
PLANNED_COST Planned Costs /RPM/TV_PLANNED_COST CURR 16 2
PLANNED_COST_YTD Planned Costs Year to Date /RPM/TV_PLANNED_COST_YTD CURR 16 2
ACTUAL_COST Actual Costs /RPM/TV_ACTUAL_COST CURR 16 2
ACTUAL_COST_YTD Actual Cost Year to Day /RPM/TV_ACTUAL_COST_YTD CURR 16 2
ACT_DECPT_NAME Decision Point Name /RPM/TV_PHASE_T CHAR 80 0
ACT_DECPT_STAT_TEXT Active Decision Point Status Text /RPM/TV_STATUS_TEXT CHAR 40 0
ACT_DECPT_STAT_ICON Active Decision Point Status /RPM/TV_DECPT_STATUS_ICON CHAR 4 0
DECPT_INFO Decision Point Info /RPM/TV_DECPT_INFO CHAR 20 0
STATUS_GROUP Status Group /RPM/TV_ITEM_STATUS_GROUP CHAR 4 0
NULL Not specified
0100 Created/Not Started
0200 Proposed
0300 To be approved
0400 Active
0500 Canceled
0600 Delayed
0700 Closed
0800 Rejected
0900 Ready For Review
1000 To be Archived
1100 Archived
FORECASTED_DURATION Forecasted Duration /RPM/TV_FORCASTED_DURATION QUAN 4 0
PLANNED_DURATION Planned Duration /RPM/TV_PLANNED_DURATION QUAN 4 0
ACTUAL_DURATION Actual Duration /RPM/TV_ACTUAL_DURATION QUAN 4 0
ACT_PHASE_GUID Application Object GUID DPR_TV_GUID RAW 16 0
WORKEFFORT_TOTAL Actual Effort /RPM/TV_WORK_EFFORT_TOTAL DEC 26 2
WORKEFFORT_YTD Actual Work Effort Year-To-Date /RPM/TV_WORK_EFFORT_YTD DEC 26 2
PLANNED_EFFORT Planned Effort /RPM/TV_PLAN_EFFORT DEC 26 2
PLANNED_EFFORT_YTD Planned Effort Year-To-Date /RPM/TV_PLAN_EFFORT_YTD DEC 26 2
ROI Return on Investment in % (manual) /RPM/TV_ROI CURR 16 2
IRR Internal Rate of Return in % (manual) /RPM/TV_IRR CURR 16 2
RISK_GROUP_D Risk Group Derived /RPM/RISK_GROUP_D NUMC 2 0
RISK_D_ICON Derived Risk /RPM/TV_RISK_ICON_D CHAR 4 0
PLANNED_DECISION_DATE Planned Decision date /RPM/TV_PLAND_DDATE DATS 8 0
ACTUAL_DECISION_DATE Actual Decision Date /RPM/TV_ACTUAL_DDATE DATS 8 0
FORECAST_DEC_DATE Forecasted Decision Date /RPM/TV_FORECAST_DDATE DATS 8 0
D_FORECASTED_START Forecasted Start RPM_TV_DP_FORECAST_START DATS 8 0
D_FORECASTED_FINISH Forecasted Finish Date RPM_TV_DP_FORECAST_FINISH DATS 8 0
BUDGET_GROUP Budget Status Group RPM_TV_BUDGET_GROUP NUMC 2 0
SCHEDULE_GROUP Schedule Status Group RPM_TV_SCHEDULE_GROUP NUMC 2 0
STAFFING_GROUP Staffing Status Group RPM_TV_STAFFING_GROUP NUMC 2 0
PORTFOLIO_NAME Portfolio Name /RPM/TV_PORTFOLIO_NAME CHAR 40 0
PORTFOLIO_ID Portfolio ID /RPM/TV_PORTFOLIO_ID CHAR 24 0
PLANNED_REVENUE Planned Revenues /RPM/TV_PLANNED_REVENUE CURR 16 2
PLANNED_REV_YTD Planned Revenues Year to Date /RPM/TV_PLANNED_REVENUE_YTD CURR 16 2
ACTUAL_REVENUE Actual Revenues /RPM/TV_ACTUAL_REVENUE CURR 16 2
ACTUAL_REV_YTD Actual Revenues Year to Day /RPM/TV_ACTUAL_REVENUE_YTD CURR 16 2
NPV_PLAN Net Present Value /RPM/TV_NPV_PLAN CURR 16 2
IRR_PLAN Internal Rate of Return in % /RPM/TV_IRR_PLAN CURR 16 2
ROI_PLAN Return on Investment in % /RPM/TV_ROI_PLAN CURR 16 2
PAYBACK_PLAN Payback Periods in Months /RPM/TV_PAYBACK_PLAN NUMC 6 0
ECV_PLAN Expected Commercial Value /RPM/TV_ECV_PLAN CURR 16 2
EA_DUMMY_KPI Single-Character Indicator CHAR1 CHAR 1 0