- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
- Cross-Application Components (CA)
- Asset Retirement Obligation Management for Oil & Gas (CA-ARO)
- Available to Promise (ATP) (CA-ATP)
- Bank (CA-BK)
- CA-VCM: Value Chain Management (CA-VCM)
- Classification (CA-CL)
- Commercial Project Management (CA-CPD)
- Cross functional developments in Asset Intell. N/W (CA-AIN)
- Cross-Application Objects in HR (CA-HR)
- Data Transformation (CA-DT)
- Document Management System (CA-DMS)
- Field Logistics (CA-FL)
- General Application Functions (CA-GTF)
- Integration from S/4HC to Master Data for Worker (CA-WFD)
- Issue & Activity Management (CA-IAM)
- Joint Venture und Production Sharing Accounting (CA-JVA)
- Landscape Transformation (CA-LT)
- Machine Learning (CA-ML)
- Master Data Governance. (CA-MDG)
- Master Data Integration Services (CA-MDI)
- PLM Audit Management (CA-AUD)
- Prepayment agreements (CA-PPA)
- Processes and Tools for Enterprise Applications (CA-EPT)
- Production Volume Capture (CA-PVL)
- Resource Scheduling (CA-RSH)
- SAP UI development toolkit for HTML5 - Rendering library (CA-UI5)
- Situation handling across applications, generic (CA-SIT)
- Time Sheet (CA-TS)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_EngmtProjWrkPckgRevQuery
Engagement Project Work Package Plan Review Query
| view: CEPWRKPCKGRQ
| Extraction:
Not supported
| Component: S/4HANA Professional Services Cloud - CPM
Tables used:
/CPD/D_MP_HDR, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_ST_HRA, /CPD/D_PFP_PH, /CPD/D_MP_STATUS, VBAP, /CPD/D_PFP_PS, /CPD/D_PFP_PS, ACDOCA, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, /CPD/D_PFP_PS, /CPD/D_WORK_ITEM, MARA, ADCP, ADRC, BUT0ID, CSLA, CSLA, CSLT, KNA1, /CPD/FC_RES, /CPD/PWSC_ORGID, /CPD/PWSC_ORGIDT, /CPD/PLANDATA, /CPD/PLANDATA, /CPD/PLANDATA, /CPD/PWSC_ORGPID, /CPD/FC_RES_T, /CPD/PWSC_MPTYP, /CPD/PWSC_TLA_AR, /S4PPM/ROLE, /S4PPM/TEAMMBR, /S4PPM/ENTITLMNT, FINSC_LEDGER, MARA, TVAP, TVAPT, PRPS, /CPD/FC_WORKITEM, PROJ, /CPD/PWSC_ORG_AT, /CPD/FC_RES_CEGT, /CPD/C_MAP_RESID, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 💲 Plan Currency (Currency): | ||
| NetAmount | Net Value of the Order Item in Document Currency | |
| PlndCostAmt | Planned Cost | |
| PlannedEffortCostAmt | null | |
| AddlResourcePlannedCostAmount | null | |
| PlndRevnAmt | Planned Revenue | |
| BaselinePlndCostAmt | null | |
| BaselinePlndRevnAmt | null | |
| ActualPlanDeviationCost | Cost Deviation | |
| ActualCostUpToFsclYrPerd | null | |
| PlannedExpenseCost | null | |
| ActlExpenseCostUpToFsclYrPerd | null | |
| ActualPlanDeviationExpnCost | null | |
| AdjustedRemainingExpnCost | null | |
| AdjustedRemainingEffortCost | Actual Cost | |
| AddlRsceEstToCmpltCostAmount | Actual Cost | |
| AdjustedRemainingCostPlnAmt | Actual Cost | |
| EstimateAtCompletionCost | Actual Cost | |
| DerivedEstAtCompltnCost | Actual Cost | |
| Column Name | Description | |
|---|---|---|
| 📏 Cost Source Unit (UnitOfMeasure): | ||
| PlndEffortQty | Planned Effort | |
| AddlResourcePlannedQuantity | null | |
| SupplyEffortQty | null | |
| BaselinePlndEffortQty | null | |
| ActualPlanDeviationEffort | Effort Deviation | |
| AddlRsceActlPlanDeviationQty | null | |
| ActualEffortUpToFsclYrPerd | null | |
| AddlResourceActualQuantity | null | |
| AdjustedRemainingEffort | null | |
| AddlRsceEstToCmpltQty | null | |
| EstimateAtCompletionEffort | null | |
| 📏 Unit of Measure (WorkPackageUnitUoM): | ||
| PlanUnitQuantity | null | |
| BaselinePlannedQuantity | null | |
| ActualUnitQty | null | |
| Column Name | Description | |
|---|---|---|
| WorkPackageStartDate | Start Date | |
| WorkPackageEndDate | End Date |
| Column Name | Description | |
|---|---|---|
| WorkPackageType | Work Package Type | Show values |
| IsDeleted | Boolean Variable (X = True, - = False, Space = Unknown) | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| EngagementProject | Project | /CPD/MP_ID | |
| EngagementProjectName | Customer Project Name | /CPD/SHORT_TEXT | |
| Ledger | Ledger | FINS_LEDGER | |
| WorkPackage | Work Package | /CPD/PLAN_ITEM_ID | |
| WorkPackageName | Plan Item Description | /CPD/PLAN_ITEM_NAME | |
| IsUnitBased | null | ||
| WBSElementIsBillingElement | null | ||
| ProjectLastChangedDateTime | Changed On | /CPD/SC_CHANGEDON | |
| EngmtProjFinPlanVersion | null | ||
| EngagementProjectResourceType | Resource Type ID | /CPD/PFP_RES_TYPE_ID | |
| EngagementProjectResource | Role / Expense | /CPD/PFP_RESOURCE_ID | |
| EngagementProjResourceText | Resource Description | /CPD/PFP_DESCRIPTION | |
| WorkPackageUnit | Resource ID | ||
| WorkPackageUnitText | Resource Description | ||
| WorkItem | Work Item | /CPD/PFP_WORKITEM_ID | |
| WorkItemName | Work Item Name | /CPD/PFP_WORKITEM_NAME | |
| EngagementProjectServiceOrg | null | ||
| EngmtProjectServiceOrgName | Description of Organization Unit ID | /CPD/PWS_WS_ORG_UNIT_ID_DESC | |
| SalesOrder | Sales Document | VBELN | |
| SalesOrderItem | Sales Document Item | POSNR | |
| SalesOrderItemText | Short text for sales order item | TEXT40 | |
| SalesDocumentItemCategoryName | Description | TEXT20 | |
| PlannedCostRate | null | ||
| AddlResourcePlannedCostRate | null | ||
| CostVariance | null | ||
| EffortVariance | null | ||
| AddlRsceVarcOfQty | null | ||
| CalculatedAdjustedRmngCost | null | ||
| CalculatedAdjustedRmngEffort | null | ||
| AddlRsceCalcdEstToCmpltQty | null | ||
| CalcdAdjustedRmngExpnCost | null | ||
| AddlRsceEstAtCompltnQty | null | ||
| EffortCompletionRateInPercent | null | ||
| UnitCompltnRateInPercent | null | ||
| CostCompletionRateInPercent | null | ||
| BaselinePlndMarginPct | null | ||
| PlndMarginPct | null | ||
| AdjustedPlndMarginPct | null |