| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | Guid for application objects | varbinary | 16 | 0 | RAW | | No | | /RPM/TV_GUID | |
| 3 | EXTERNAL_ID | Business Object ID | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | /RPM/TV_EXTID | Allow NULL? |
| 4 | PORTFOLIO_GUID | Guid for application objects | varbinary | 16 | 0 | RAW | | Yes | | /RPM/TV_GUID | |
| 5 | PARENT_GUID | Guid for application objects | varbinary | 16 | 0 | RAW | | Yes | | /RPM/TV_GUID | |
| 6 | CATEGORY | Category | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | RPM_PROJECT_CATEGORY | Allow NULL? |
| 7 | SUBCATEGORY | Subcategory | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | RPM_PROJ_SUBCATEGORY | Allow NULL? |
| 8 | PHASE | Stage | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | RPM_PROJECT_PHASE | Allow NULL? |
| 9 | PTYPE | Group | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | RPM_PROJECTTYPE | Allow NULL? |
| 10 | TTYPE | Technology Type | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | RPM_PROJECT_TECHTYPE | Allow NULL? |
| 11 | RISKA | Assessed Project Risk | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RPM_PROJECT_RISK_ASSESED | Allow NULL? |
| 12 | PROBT | Probability of Technical Success | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RPM_PROJECT_PROB_TECH | Allow NULL? |
| 13 | PROBC | Probability of Commercial Success | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RPM_PROJECT_PROB_COMM | Allow NULL? |
| 14 | HEADC | Actual Headcount | decimal | 10 | 2 | DEC | ((0)) | Yes | | RPM_PROJECT_HEADCOUNT | |
| 15 | COSTD | Development Cost | decimal | 16 | 2 | CURR | ((0)) | Yes | | RPM_PROJECT_COST_DEVELOPMENT | |
| 16 | COSTL | Launch Cost | decimal | 16 | 2 | CURR | ((0)) | Yes | | RPM_PROJECT_COST_LAUNCH | |
| 17 | NPV | Net Present Value (manual) | decimal | 16 | 2 | CURR | ((0)) | Yes | | RPM_PROJECT_NPV | |
| 18 | CURRENCY | Currency key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | RPM_TV_CURRENCY | Allow NULL? |
| 19 | LOCATION | Project Location | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RPM_TV_PROJECT_LOCATION | Allow NULL? |
| 20 | GEOGRAPHY | Project Geography | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RPM_TV_PROJECT_GEOGRAPHY | Allow NULL? |
| 21 | RPM_CHANGED_ON | Time Stamp | decimal | 15 | 0 | DEC | ((0)) | Yes | | RPM_TV_TIMESTAMP | |
| 22 | PERIODTYPE | Financial Period Breakdown | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | /RPM/TV_PERIOD_TYPE | Allow NULL? |
| 23 | UNIT | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | RPM_TV_UNIT | Allow NULL? |
| 24 | FORECAST_START | Forecasted Start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RPM_TV_FORECAST_START | Allow NULL? |
| 25 | PLANNED_START | Planned Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RPM_TV_PLAN_START | Allow NULL? |
| 26 | ACTUAL_START | Actual Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RPM_TV_ACTUAL_START | Allow NULL? |
| 27 | FORECAST_FINISH | Forecasted Finish Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RPM_TV_FORECAST_FINISH | Allow NULL? |
| 28 | PLANNED_FINISH | Planned Finish Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RPM_TV_PLAN_FINISH | Allow NULL? |
| 29 | ACTUAL_FINISH | Actual Finish Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RPM_TV_ACTUAL_FINISH | Allow NULL? |
| 30 | ESCALATION | Escalation Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | RPM_TV_ESCALATION | Allow NULL? |
| 31 | ITEM_TYPE | Type | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | /RPM/TV_ITEM_ID | Allow NULL? |
| 32 | PORTFL_ITEM_GUID | Guid for application objects | varbinary | 16 | 0 | RAW | | Yes | | RPM_TV_GUID | |
| 33 | ECV | Expected Commercial Value (manual) | decimal | 16 | 2 | CURR | ((0)) | Yes | | RPM_TV_ECV | |
| 34 | PRIORITY_GROUP | Priority Group | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | RPM_PRIORITY_GROUP | Allow NULL? |
| 35 | CHANGED_BY | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | RPM_TV_CHANGED_BY | Allow NULL? |
| 36 | VERSION_ITEM | Project Version Flag | char | 1 | 0 | CHAR | (N' ') | Yes | | RPM_TV_VERSION_FLAG | Allow NULL? |
| 37 | ITEM_CLASS | Item Classification | char | 1 | 0 | CHAR | (N' ') | Yes | | /RPM/TV_ITEM_CLASS | Allow NULL? |
| 38 | MASTER_ITEM_GUID | Guid for application objects | varbinary | 16 | 0 | RAW | | Yes | | RPM_TV_GUID | |
| 39 | STATUS | Status | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | /RPM/TV_STATUS_COMMON | Allow NULL? |
| 40 | CAP_PERIODTYPE | Capacity Period Breakdown | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | * | /RPM/TV_CAP_PERIOD_TYPE | Allow NULL? |
| 41 | INITIATIVE_GUID | Guid for application objects | varbinary | 16 | 0 | RAW | | Yes | | RPM_TV_GUID | |
| 42 | DISCOUNT_RATE | Discount Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | /RPM/TV_DISCOUNT_RATE | |
| 43 | ACT_DPCPT_GUID | Guid for application objects | varbinary | 16 | 0 | RAW | | Yes | | /RPM/TV_GUID | |
| 44 | FRCST_BGT_TOTAL | Portfolio Item Forecasted Budget Total | decimal | 16 | 2 | CURR | ((0)) | Yes | | /RPM/TV_FORECASTED_BUDGT_TOTAL | |
| 45 | FRCST_BGTANNUAL | Portfolio Item Forecasted Budget Annual | decimal | 16 | 2 | CURR | ((0)) | Yes | | /RPM/TV_FORECASTED_BUDGT_ANNL | |
| 46 | FRCST_COSTTOTAL | Portfolio Item Forecasted Cost Total | decimal | 16 | 2 | CURR | ((0)) | Yes | | /RPM/TV_FORECASTED_COST_TOTAL | |
| 47 | FRCST_COST_YTD | Portfolio Item Forecasted Cost YTD | decimal | 16 | 2 | CURR | ((0)) | Yes | | /RPM/TV_FORECASTED_COST_YTD | |
| 48 | TEMPLATE_GUID | Guid for application objects | varbinary | 16 | 0 | RAW | | Yes | | /RPM/TV_GUID | |
| 49 | IS_GLOBAL | Global Template | char | 1 | 0 | CHAR | (N' ') | Yes | | /RPM/TV_GLOBAL | Allow NULL? |
| 50 | EA_DUMMY | Dummy Data Element for Enhanced xRPM Attributes | char | 1 | 0 | CHAR | (N' ') | Yes | | /RPM/TV_EA_DUMMY | Allow NULL? |
| 51 | ZZNPDI_SCORE | Score | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | Z_TV_SCORE | Allow NULL? |
| 52 | ZZNPDI_DP | Current DecPoint | nvarchar | 80 | 0 | CHAR | (N' ') | Yes | | Z_TV_DECPOINT | Allow NULL? |
| 53 | ZZNPDI_DP_STATUS | Decision Status | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | Z_TV_DECPOINT_STATUS | Allow NULL? |
| 54 | ZZ_NPDI_NEXTRVW | | nvarchar | 8 | 0 | | (N'00000000') | Yes | | | Allow NULL? |
| 55 | ZZ_NPDI_REVGRWTH | | nvarchar | 3 | 0 | | (N'000') | Yes | | | Allow NULL? |
| 56 | ZZ_NPDI_SCHEDVAR | | nvarchar | 5 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 57 | ZZ_NPDI_PROFIMP | | nvarchar | 3 | 0 | | (N'000') | Yes | | | Allow NULL? |
| 58 | ZZ_NPDI_BDGTSTRT | Budget Data Element | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ZZBUDGET_DE | Allow NULL? |
| 59 | ZZ_HER_PA | | nvarchar | 5 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 60 | ZZ_HER_IC | | nvarchar | 5 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 61 | ZZ_HER_SAG | | nvarchar | 5 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 62 | ZZ_PS_AC | | nvarchar | 5 | 0 | | (N' ') | Yes | | | Allow NULL? |
| 63 | ZZ_HER_IR | | nvarchar | 3 | 0 | | (N'000') | Yes | | | Allow NULL? |
| 64 | ZZ_HER_CSR | | nvarchar | 3 | 0 | | (N'000') | Yes | | | Allow NULL? |
| 65 | ZRDS_BUDGET | Custom Field Budget Status (RDS) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ZRDS_BUDGETSTATUS | Allow NULL? |
| 66 | ZRDS_STRATFIT | KPI Strategic Fit Questionnaire (RDS) | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | ZRDS_STRATFIT | |
| 67 | ZRDS_TECHRISK | KPI Technological Risk Questionnaire (RDS) | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | ZRDS_TECHRISK | |
| 68 | ZRDS_SOCRISK | KPI Social Risk Questionnaire (RDS) | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | ZRDS_SOCRISK | |
| 69 | ZRDS_OVSCORE | KPI Overall Score (RDS) | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | ZRDS_OVSCORE | |
| 70 | ZRDS_BUDGET_S | Custom Field Budget Status (RDS PPM) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ZRDS_BUDGET_STATUS | Allow NULL? |
| 71 | ZRDS_OVASCORE | KPI Overall Score Scoring Model (RDS PPM) | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | ZRDS_OVALLSCORE | |
| 72 | ZANUAL_ES | Estimated Energy Savings/year(GJ) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ZANUAL_ES | Allow NULL? |
| 73 | ZANUAL_CS | Estimated Savings $ | decimal | 16 | 2 | CURR | ((0)) | Yes | | ZANUAL_CS | |
| 74 | ZIMP_COST | Estimated Costs $ | decimal | 16 | 2 | CURR | ((0)) | Yes | | ZIMP_COST | |
| 75 | ZANNUAL_COST | Annual Costs $ | decimal | 16 | 2 | CURR | ((0)) | Yes | | ZANNUAL_COST | |
| 76 | ZSPEND_CAT | Spend Category | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ZPEND_CAT | Allow NULL? |
| 77 | ZROI | 3-Year ROI % | int | 10 | 0 | INT4 | ((0)) | Yes | | ZROI | Allow NULL? |
| 78 | ZPAYBK | Estimated Payback Period (months) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ZPAYBK | Allow NULL? |
| 79 | ZAPPROVER | APPROVER | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ZAPPROVER | Allow NULL? |
| 80 | ZTEST | Approver | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | ZTEST | Allow NULL? |
| 81 | ZACTROI | 3-Year Actual ROI % | int | 10 | 0 | INT4 | ((0)) | Yes | | ZACTROI | Allow NULL? |
| 82 | ZANUAL_ACTES | Actual Energy Savings/Year (GJ) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ZANUAL_ACTES | Allow NULL? |
| 83 | ZIMP_ACOST | Actual Costs $ | decimal | 16 | 2 | CURR | ((0)) | Yes | | ZIMP_ACTCOST | |
| 84 | ZACRPAYBK | Actual Payback Period (months) | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ZACRPAYBK | Allow NULL? |
| 85 | ZANUAL_ACTCS | Actual Savings $ | decimal | 16 | 2 | CURR | ((0)) | Yes | | ZANUAL_ACTCS | |
| 86 | ZITSPONSOR | IT Sponsor | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ZITSPONSOR | Allow NULL? |
| 87 | ZBS | Business Sponsor | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ZBS | Allow NULL? |
| 88 | ZERMOVRSCORE | Overall Score (EERM) | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | ZERMOVRSCORE | Allow NULL? |
| 89 | ZNUM | Number of Changes | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ZNUM | Allow NULL? |
| 90 | ZOEM | OEM Project | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ZOEM | Allow NULL? |
