C_ProjectFinancialSummary
Monitor Projects
C_ProjectFinancialSummary is a Consumption CDS View that provides data about "Monitor Projects" in SAP S/4HANA. It reads from 1 data source (I_ProjectFinancialSummary) and exposes 76 fields with key fields ProjectInternalID, SourceLedger, Ledger, CompanyCode, FiscalYear. It has 5 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ProjectFinancialSummary | I_ProjectFinancialSummary | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_PlanningCategory | fcom_category |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_ProjectProfileCodeText | _ProjectProfileText | $projection.ProjectProfileCode = _ProjectProfileText.ProjectProfileCode |
| [1..1] | I_UserContactCard | _UserContactCard | $projection.BusinessPartner = _UserContactCard.Person |
| [0..*] | C_ProjCostByCostCompChart | _ProjectCostAgg | $projection.Project = _ProjectCostAgg.Project |
| [0..*] | I_ProjBdgtTmeSpanTxt | _BudgetTimeSpanText | $projection.AvailyCtrlTimeRangeType = _BudgetTimeSpanText.AvailyCtrlTimeRangeType |
| [1..1] | E_PPM_Project | _ProjectHeaderExtension | $projection.ProjectUUID = _ProjectHeaderExtension.ProjectUUID |
Annotations (19)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CPROJFINSMMRY | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Monitor Projects | view | |
| AccessControl.personalData.blocking | #REQUIRED | view | |
| UI.presentationVariant.sortOrder.by | Project | view | |
| UI.presentationVariant.sortOrder.direction | #ASC | view | |
| UI.headerInfo.typeName | Project | view | |
| UI.headerInfo.typeNamePlural | Projects | view | |
| UI.headerInfo.title.type | #STANDARD | view | |
| UI.headerInfo.title.value | Project | view | |
| UI.headerInfo.description.type | #STANDARD | view | |
| UI.headerInfo.description.value | ProjectDescription | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XL | view |
Fields (76)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProjectInternalID | ProjectInternalID | Project Def. | |
| KEY | SourceLedger | SourceLedger | Source Ledger | |
| KEY | Ledger | Ledger | Ledger | |
| KEY | CompanyCode | CompanyCode | Receiver Company Code | |
| KEY | FiscalYear | FiscalYear | G/L Fiscal Year | |
| KEY | AccountingDocument | AccountingDocument | Journal Entry | |
| KEY | FinancialPlanningReqTransSqnc | FinancialPlanningReqTransSqnc | Request TSN | |
| KEY | FinancialPlanningDataPacket | FinancialPlanningDataPacket | Data packet number | |
| KEY | ActualPlanJournalEntryItem | ActualPlanJournalEntryItem | ||
| ProjectUUID | ProjectUUID | Project UUID | ||
| Project | Project | Project | ||
| ProjectSummaryTaskUUID | ProjectSummaryTaskUUID | Entity GUID | ||
| ControllingArea | ControllingArea | Controlling Area | ||
| ProfitCenter | ProfitCenter | Profit Center | ||
| ResponsibleCostCenter | ResponsibleCostCenter | Responsible Cost Center | ||
| ProjectType | ProjectType | Project Type | ||
| ProjectDescription | ProjectDescription | Project Name | ||
| PlannedStartDate | PlannedStartDate | Planned Start | ||
| PlannedEndDate | PlannedEndDate | Planned Finish | ||
| PlanningCategory | PlanningCategory | Plan Category | ||
| ProjectCategory | ProjectCategory | Proj. Category | ||
| PostingDate | PostingDate | Posting Date | ||
| CreationDate | CreationDate | Time Stamp | ||
| SemanticTag | SemanticTag | Cost Component | ||
| StatusIsActive | StatusIsActive | Show Planned Projects | ||
| ProjectProfileCode | ProjectProfileCode | Project Profile | ||
| ProjectProfileCodeText | ||||
| BusinessPartner | BusinessPartner | Project Manager | ||
| BusinessPartnerUUID | BusinessPartnerUUID | UUID | ||
| BusinessPartnerFullName | BusinessPartnerFullName | Broker Name | ||
| BudgetCurrencyRole | BudgetCurrencyRole | |||
| AvailabilityControlIsActive | AvailabilityControlIsActive | Budget Availability Control is Active | ||
| AvailabilityControlProfile | AvailabilityControlProfile | Budget Availability Control Profile | ||
| AvailyCtrlTimeRangeType | AvailyCtrlTimeRangeType | |||
| AvailyCtrlTimeRangeTypeDesc | ||||
| GlobalCurrency | GlobalCurrency | GM Billing Element: Global Currency | ||
| ActualAmountInGlobalCurrency | ActualAmountInGlobalCurrency | Actual Costs in Global Currency | ||
| CmtmtCostInGlobalCurrency | CmtmtCostInGlobalCurrency | Commitment in Global Currency | ||
| ActlCmtmtCumltvAmtInGlobCrcy | ActlCmtmtCumltvAmtInGlobCrcy | Actual & Commitment Cost in Global Currency | ||
| PlanAmountInGlobalCurrency | PlanAmountInGlobalCurrency | Planned Costs in Global Currency | ||
| ActlPlnDiffAmtInGlobalCrcy | ||||
| BudgetInGlobalCrcy | BudgetInGlobalCrcy | Budget in Global Currency | ||
| AccmltdAvailBdgtInGlobalCrcy | Available Budget | |||
| BudgetConsumption | Budget Consumption % | |||
| PredictedAmtInGlobalCurrency | PredictedAmtInGlobalCurrency | Predicted Cost in Global Currency | ||
| PredictedCostCreationDate | PredictedCostCreationDate | Predicted Cost Creation Date | ||
| PredictedCostPostingDate | PredictedCostPostingDate | Predicted Cost Posting Date | ||
| UpperPredictionAmtInGlobCrcy | UpperPredictionAmtInGlobCrcy | Upper Prediction in Global Currency | ||
| ControllingObjectCurrency | ControllingObjectCurrency | CO Object Currency | ||
| ActlCostInProjCrcy | ActlCostInProjCrcy | Actual Costs in Project Currency | ||
| CmtmtCostInProjCrcy | CmtmtCostInProjCrcy | Commitment in Project Currency | ||
| PlndCostAmtInProjCrcy | PlndCostAmtInProjCrcy | Planned Costs in Project Currency | ||
| ActlPlnDiffAmtInProjectCrcy | ||||
| BudgetInProjCrcy | BudgetInProjCrcy | Budget | ||
| ActualCostForCostComponent1 | ActualCostForCostComponent1 | |||
| ActualCostForCostComponent2 | ActualCostForCostComponent1 | |||
| ActualCostForCostComponent3 | ActualCostForCostComponent1 | |||
| ActualCostForCostComponent4 | ActualCostForCostComponent1 | |||
| ActualCost | ActualCostForCostComponent1 | |||
| ActualCostComponentName1 | ActualCostComponentName1 | |||
| ActualCostComponentName2 | ActualCostComponentName1 | |||
| ActualCostComponentName3 | ActualCostComponentName1 | |||
| ActualCostComponentName4 | ActualCostComponentName1 | |||
| PlanCostForCostComponent1 | ActualCostForCostComponent1 | |||
| PlanCostForCostComponent2 | ActualCostForCostComponent1 | |||
| PlanCostForCostComponent3 | ActualCostForCostComponent1 | |||
| PlanCostForCostComponent4 | ActualCostForCostComponent1 | |||
| PlannedCost | ActualCostForCostComponent1 | |||
| PlanCostComponentName1 | ActualCostComponentName1 | |||
| PlanCostComponentName2 | ActualCostComponentName1 | |||
| PlanCostComponentName3 | ActualCostComponentName1 | |||
| PlanCostComponentName4 | ActualCostComponentName1 | |||
| CostComponentName | ||||
| ProjectProcessingStatus | ProjectProcessingStatus | |||
| _UserContactCard | _UserContactCard | |||
| _ProjectCostAgg | _ProjectCostAgg |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view C_ProjectFinancialSummary.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPROJFINSMMRY
-- Parameters: P_PlanningCategory : fcom_category
CREATE VIEW C_ProjectFinancialSummary AS
SELECT
ProjectInternalID,
SourceLedger,
Ledger,
CompanyCode,
FiscalYear,
AccountingDocument,
FinancialPlanningReqTransSqnc,
FinancialPlanningDataPacket,
ActualPlanJournalEntryItem,
ProjectUUID,
Project,
ProjectSummaryTaskUUID,
ControllingArea,
ProfitCenter,
ResponsibleCostCenter,
ProjectType,
ProjectDescription,
PlannedStartDate,
PlannedEndDate,
PlanningCategory,
ProjectCategory,
PostingDate,
CreationDate,
SemanticTag,
StatusIsActive,
ProjectProfileCode,
_ProjectProfileText[1:Language = $session.system_language].ProjectProfileCodeText AS ProjectProfileCodeText,
BusinessPartner,
BusinessPartnerUUID,
BusinessPartnerFullName,
BudgetCurrencyRole,
AvailabilityControlIsActive,
AvailabilityControlProfile,
AvailyCtrlTimeRangeType,
_BudgetTimeSpanText[1:Language = $session.system_language].AvailyCtrlTimeRangeTypeDesc AS AvailyCtrlTimeRangeTypeDesc,
GlobalCurrency,
ActualAmountInGlobalCurrency,
CmtmtCostInGlobalCurrency,
ActlCmtmtCumltvAmtInGlobCrcy,
PlanAmountInGlobalCurrency,
PlanAmountInGlobalCurrency - ActualAmountInGlobalCurrency AS ActlPlnDiffAmtInGlobalCrcy,
BudgetInGlobalCrcy,
BudgetInGlobalCrcy - ActlCmtmtCumltvAmtInGlobCrcy AS AccmltdAvailBdgtInGlobalCrcy,
cast(0 as abap.dec( 8, 0 )) AS BudgetConsumption,
PredictedAmtInGlobalCurrency,
PredictedCostCreationDate,
PredictedCostPostingDate,
UpperPredictionAmtInGlobCrcy,
ControllingObjectCurrency,
ActlCostInProjCrcy,
CmtmtCostInProjCrcy,
PlndCostAmtInProjCrcy,
PlndCostAmtInProjCrcy - ActlCostInProjCrcy AS ActlPlnDiffAmtInProjectCrcy,
BudgetInProjCrcy,
ActualCostForCostComponent1,
ActualCostForCostComponent1 AS ActualCostForCostComponent2,
ActualCostForCostComponent1 AS ActualCostForCostComponent3,
ActualCostForCostComponent1 AS ActualCostForCostComponent4,
ActualCostForCostComponent1 AS ActualCost,
ActualCostComponentName1,
ActualCostComponentName1 AS ActualCostComponentName2,
ActualCostComponentName1 AS ActualCostComponentName3,
ActualCostComponentName1 AS ActualCostComponentName4,
ActualCostForCostComponent1 AS PlanCostForCostComponent1,
ActualCostForCostComponent1 AS PlanCostForCostComponent2,
ActualCostForCostComponent1 AS PlanCostForCostComponent3,
ActualCostForCostComponent1 AS PlanCostForCostComponent4,
ActualCostForCostComponent1 AS PlannedCost,
ActualCostComponentName1 AS PlanCostComponentName1,
ActualCostComponentName1 AS PlanCostComponentName2,
ActualCostComponentName1 AS PlanCostComponentName3,
ActualCostComponentName1 AS PlanCostComponentName4,
cast('Others' as fins_sem_tag_name) AS CostComponentName,
ProjectProcessingStatus
FROM I_ProjectFinancialSummary
LEFT OUTER JOIN I_ProjectProfileCodeText AS _ProjectProfileText ON ProjectProfileCode = _ProjectProfileText.ProjectProfileCode -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON BusinessPartner = _UserContactCard.Person -- association [1..1]
LEFT OUTER JOIN C_ProjCostByCostCompChart AS _ProjectCostAgg ON Project = _ProjectCostAgg.Project -- association [0..*]
LEFT OUTER JOIN I_ProjBdgtTmeSpanTxt AS _BudgetTimeSpanText ON AvailyCtrlTimeRangeType = _BudgetTimeSpanText.AvailyCtrlTimeRangeType -- association [0..*]
LEFT OUTER JOIN E_PPM_Project AS _ProjectHeaderExtension ON ProjectUUID = _ProjectHeaderExtension.ProjectUUID -- association [1..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA