CPD_WS_KPI - Master Project KPI
Master Project KPI information is stored in SAP table CPD_WS_KPI.
It is part of development package ODATA_PWS in software component CA-CPD-WS. This development package consists of objects that can be grouped under "OData Package for Project Workspace".
It is part of development package ODATA_PWS in software component CA-CPD-WS. This development package consists of objects that can be grouped under "OData Package for Project Workspace".
Fields for table CPD_WS_KPI
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| MASTERPROJECTUUID | NodeID | /BOBF/CONF_KEY | RAW | 16 | ||
| MASTERPROJECT | Commercial Project ID | /CPD/CPM_COMLPROJID | CHAR | 80 | ||
| MASTERPROJECTTYPE | Commercial Project Type | /CPD/CPM_MP_TYPE | CHAR | 8 | ||
| MASTERPROJECTSTAGE | Commercial Project Stage | /CPD/CPM_MP_STAGE | CHAR | 8 | ||
| CUSTOMER | Customer ID | /CPD/CPM_CUSTID | CHAR | 20 | ||
| MASTERPROJECTORGANIZATION | Project Organization | /CPD/CPM_COMLPROJORG | CHAR | 10 | ||
| MASTERPROJECTORGANIZATIONNAME | Commercial Project Organization Name | /CPD/CPM_COMLPROJORGNAME | CHAR | 80 | ||
| STARTDATE | Commercial Project: Start Date | /CPD/MP_START_DATE | DATS | 16 | ||
| ENDDATE | Commercial Project: End Date | /CPD/MP_END_DATE | DATS | 16 | ||
| MASTERPROJECTISCONFIDENTIAL | Commercial Project Is Confidential | /CPD/CPM_COMLPROJCOFL | CHAR | 2 | ||
| COUNTRY | Country/Region | /CPD/CPM_COUNTRY | CHAR | 6 | ||
| REGION | Region (State, Province, County) | REGIO | CHAR | 6 | ||
| FINANCIALRISK | Financial Risk | /CPD/PWS_WS_FIN_RISK | CHAR | 4 | ||
| INDUSTRY | Industry | /CPD/PWS_WS_INDUSTRY | CHAR | 10 | ||
| INTERNALINSPECTIONDATE | Int. Inspection Date | /CPD/CPM_INTINSDATE | DATS | 16 | ||
| EXTERNALINSPECTIONDATE | External Inspection Date | /CPD/CPM_EXTINSDATE | DATS | 16 | ||
| OVERALLRISK | Commercial Project Overall Risk | /CPD/CPM_OVERALL_RISK | CHAR | 2 | ||
| TECHNICALRISK | Technical Risk | /CPD/PWS_WS_TECH_RISK | CHAR | 4 | ||
| WORKTYPE | Type of Work | /CPD/PWS_WS_WORK_TYPE | CHAR | 10 | ||
| CREATEDBYUSER | Created By | /BOFU/USER_ID_CREATED_BY | CHAR | 24 | ||
| CREATEDBY | Created By | /BOFU/USER_ID_CREATED_BY | CHAR | 24 | ||
| ROLE_ID | Role ID | /CPD/PWS_WS_ROLE_ID | CHAR | 8 | ||
| ROLE_DESC | Role Description: Text Table of the Role Master | /CPD/PWS_WS_ROLE_DESC | CHAR | 80 | ||
| PROJECTMANAGERNAME | Commercial Project Manager Name | /CPD/CPM_PROJMNGRNAME | CHAR | 80 | ||
| OVERALL_STATUS_ID | Overall Status ID | /CPD/CPM_OVERALL_STSID | CHAR | 8 | ||
| OVERALL_STATUS_DESCRIPTION | Description of Status | /CPD/PWS_WS_STATUS_KEY_FIG_DES | CHAR | 48 | ||
| OVERALL_STATUS_COLOR | Overall Status Color | /CPD/CPM_OVERALLSTSCOL | CHAR | 40 | ||
| ISSUE | Issues | /CPD/CPM_ISSUES | INT4 | 4 | ||
| CHANGEREQUEST | Change Request | /CPD/CPM_CHANGEREQUEST | INT4 | 4 | ||
| WORKINPROGRESS | Work In Progress | /CPD/CPM_WIP | CURR | 8 | ||
| WIPUOM | WIP Unit Of Measure | /CPD/CPM_WIPUOM | CUKY | 10 | ||
| DEBT | Debt | /CPD/CPM_DEBT | CURR | 8 | ||
| DEBTUOM | Debt Unit Of Measure | /CPD/CPM_DEBTUOM | CUKY | 10 | ||
| PLANNEDCOST | Plan Cost (Up to Current Month) | /CPD/CPM_PLNCOST | CURR | 8 | ||
| ACTUALCOST | Actual Cost (Up to Current Month) | /CPD/CPM_ACTLCOST | CURR | 8 | ||
| COSTVARIANCE | Commercial Project Cost Variance | /CPD/CPM_COSTVAR | CURR | 8 | ||
| COSTCURRENCY | Cost Currency | /CPD/CPM_COSTCRCY | CUKY | 10 | ||
| COSTCOLOR | Cost Color | /CPD/CPM_COSTCOLOR | CHAR | 40 | ||
| PLANREVENUE | Plan Revenue (Up to Current Month) | /CPD/CPM_PLNREV | CURR | 8 | ||
| ACTUALREVENUE | Actual Revenue (Up to Current Month) | /CPD/CPM_ACTLREV | CURR | 8 | ||
| REVENUEVARIANCE | Commercial Project Revenue Variance | /CPD/CPM_REVVARIANCE | CURR | 8 | ||
| REVENUECURRENCY | Commercial Project Revenue Currency | /CPD/CPM_REVCRCY | CUKY | 10 | ||
| REVENUECOLOR | Revenue Color | /CPD/CPM_REVCOLOR | CHAR | 40 | ||
| TOTALPLANNEDCOST | Commercial Project Total Plan Cost | /CPD/CPM_TOTPLNCOST | CURR | 8 | ||
| EACCOST | Estimate at Completion (Cost) | /CPD/CPM_EACCOST | CURR | 8 | ||
| EACVARIANCE | EAC Variance | /CPD/CPM_EACVAR | DEC | 9 | ||
| EACCURRENCY | EAC Currency | /CPD/CPM_EACCRCY | CUKY | 10 | ||
| EACPERIOD | Forecast Period | /CPD/PFP_FORECAST_PERIOD | CHAR | 16 | ||
| EACCOLOR | EAC Color | /CPD/CPM_EACCOLOR | CHAR | 40 | ||
| PLANNEDPROGRESS | Commercial Project Plan Progress | /CPD/CPM_PLNPROG | DEC | 3 | ||
| ACTUALPROGRESS | Commercial Project Actual Progress | /CPD/CPM_ACTLPROG | DEC | 3 | ||
| PROGRESSVARIANCE | Progress Variance | /CPD/CPM_PROGVAR | DEC | 3 | ||
| PROGRESSUOM | Progress Unit of Measure | /CPD/CPM_PROGUOM | UNIT | 6 | ||
| PROGRESSCOLOR | Progress Color | /CPD/CPM_PROGRESSCLR | CHAR | 40 | ||
| PLANNEDEARNEDVALUE | Plan Earned Value | /CPD/CPM_PLNEV | DEC | 9 | ||
| ACTUALEARNEDVALUE | Actual Earned Value | /CPD/CPM_ACTLEV | DEC | 9 | ||
| EARNEDVALUEVARIANCE | Earned Value Variance | /CPD/CPM_EVVAR | DEC | 9 | ||
| EARNEDVALUECURRENCY | Earned Value Currency | /CPD/CPM_EVCRCY | CUKY | 10 | ||
| EARNEDVALUECOLOR | Earned Value Color | /CPD/CPM_EVCOLOR | CHAR | 40 | ||
| CPI | Cost Performance Index | /CPD/CPM_CPI | DEC | 3 | ||
| SPI | Schedule Performance Index | /CPD/CPM_SPI | DEC | 3 | ||
| PLANNEDMARGIN | Planned Margin | /CPD/CPM_PLANMGN | DEC | 9 | ||
| ACTUALMARGIN | Actual Margin | /CPD/CPM_ACTLMRGN | DEC | 9 | ||
| MARGINVARIANCE | Commercial Project Margin Variance | /CPD/CPM_MRGNVAR | DEC | 9 | ||
| MARGINUOM | Margin Unit Of measure | /CPD/CPM_MRGNUOM | UNIT | 6 | ||
| MARGINCOLOR | Margin Color | /CPD/CPM_MARGINCOLOR | CHAR | 40 | ||
| TOTALACTUALCOST | Actual Cost | /CPD/CPM_TOTACTLCOST | CURR | 8 | ||
| TOTALCOSTVARIANCE | Total Cost Variance | /CPD/TOTLCOSTVARIANCE | CURR | 8 | ||
| TOTALPLANREVENUE | Total Plan revenue | /CPD/TOTLPLANREV | CURR | 8 | ||
| TOTALACTUALREVENUE | Total Actual Revenue | /CPD/TOTLACTLREV | CURR | 8 | ||
| TOTALREVENUEVARIANCE | Total Revenue Variance | /CPD/TOTLREVVARIANCE | CURR | 8 | ||
| PLAN_REV_PLN_VS_EAC | Total Plan revenue | /CPD/TOTLPLANREV | CURR | 8 | ||
| EAC_REV_PLN_VS_EAC | Forecast Revenue | /CPD/EACREVENUE | CURR | 8 | ||
| VARIANCE_REV_PLN_VS_EAC | Total Revenue Variance | /CPD/TOTLREVVARIANCE | CURR | 8 | ||
| COLOR_REV_PLN_VS_EAC | Revenue Color | /CPD/CPM_REVCOLOR | CHAR | 40 | ||
| PLAN_MARGIN_PLN_VS_EAC | Planned Margin | /CPD/CPM_PLANMGN | DEC | 9 | ||
| EAC_MARGIN_PLN_VS_EAC | Forecast Margin | /CPD/EACMARGIN | DEC | 9 | ||
| VARIANCE_MARGIN_PLN_VS_EAC | Commercial Project Margin Variance | /CPD/CPM_MRGNVAR | DEC | 9 | ||
| COLOR_MARGIN_PLN_VS_EAC | Margin Color | /CPD/CPM_MARGINCOLOR | CHAR | 40 | ||
| MASTERPROJECTNAME | Project Name | /CPD/CPM_COMLPROJNAME | CHAR | 80 | ||
| ISUSERSTATUS | User Status | /CPD/CPM_ISUSER_SATATUS | CHAR | 2 | ||
| CUSTOMERNAME | Customer | /CPD/CPM_CUSTOMER | CHAR | 160 | ||
| MASTERPROJECTUUID_E | Commercial Project UUID | /CPD/CPM_COMLPROJUUID | CHAR | 64 | ||
| EMAILADDRESS | E-Mail Address | AD_SMTPADR | CHAR | 482 | ||
| MOBILEPHONENUMBER | Cell (Customer) | /CPD/CPM_CUSTMOBNO | CHAR | 60 | ||
| PHONENUMBER | Landline (Customer) | /CPD/CPM_CUSTCONTACTNO | CHAR | 80 | ||
| MASTERPROJECTTYPENAME | Description of Commercial Project Type | /CPD/CPM_MP_TYPE_DESC | CHAR | 80 | ||
| MASTERPROJECTSTAGENAME | Master Project: Stage Description | /CPD/PWS_WS_MP_STG_DESC | CHAR | 80 | ||
| PMEMAILADDRESS | E-Mail Address | AD_SMTPADR | CHAR | 482 | ||
| PMMOBILENUMBER | Cell (Customer) | /CPD/CPM_CUSTMOBNO | CHAR | 60 | ||
| PMPHONENUMBER | Landline (Customer) | /CPD/CPM_CUSTCONTACTNO | CHAR | 80 | ||
| CURRENCY | Currency Key | WAERS | CUKY | 10 | ||
| ALERTCOUNT | 1 Byte Unsigned Integer | INT1 | INT1 | 1 | ||
| PROJECTRISK | Commercial Project Risk | /CPD/CPM_PROJRISK | CHAR | 2 | ||
| /CPD/KPI_INCL_EEW_DUMMY | KPI Extensibility Persistent Include Dummy Data Element | /CPD/KPI_INCL_EEW_DUMMY | CHAR | 2 | ||
| /CPD/KPI_INCL_EEW_PS_COMP | KPI Extensibility Persistent Include Dummy Data Element | /CPD/KPI_INCL_EEW_DUMMY | CHAR | 2 | ||
| /CPD/KPI_INCL_TRF_DUMMY | KPI Text Transient Include for extensibility | /CPD/KPI_INCL_TRF_DUMMY | CHAR | 2 | ||
| /CPD/MP_DUMMY_INCL_EEW_PS | Dummy data element for extensibility | /CPD/DUMMY_INCL_EEW | CHAR | 2 | ||
| /CPD/MP_DUMMY_INCL_EEW_TR | Dummy data element for extensibility | /CPD/DUMMY_INCL_EEW | CHAR | 2 |