P_EngmntProjActlByPeriod

DDL: P_ENGMNTPROJACTLBYPERIOD Type: view COMPOSITE Package: CPD_CDS
59 Fields 1 Data Sources

Engagement Project Actuals aggregated by Fiscal Year Period

P_EngmntProjActlByPeriod is a Composite CDS View that provides data about "Engagement Project Actuals aggregated by Fiscal Year Period" in SAP S/4HANA. It reads from 1 data source (P_EngmntProjActlInProjCrcy) and exposes 59 fields. Part of development package CPD_CDS.

Data Sources (1)

SourceAliasJoin Type
P_EngmntProjActlInProjCrcy P_EngmntProjActlInProjCrcy from

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PEPACTLBYPERIOD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #NONE view
Metadata.ignorePropagatedAnnotations true view

Fields (59)

KeyFieldSource TableSource FieldDescription
EngagementProject EngagementProject Engmnt Project ID
EngagementProjectServiceOrg EngagementProjectServiceOrg Service Org.
Customer Customer Sold-to Party
EngagementProjectType EngagementProjectType
EngagementProjectCategory EngagementProjectCategory
EngmntProjReviewYearPeriod EngmntProjReviewYearPeriod
EngagementProjectReviewStatus EngagementProjectReviewStatus
EngagementProjectStage EngagementProjectStage
CurrentYearPeriod CurrentYearPeriod
EngagementProjFinPlanUUID EngagementProjFinPlanUUID Engagement Project
PlanVersion PlanVersion
CompanyCodeCurrency CompanyCodeCurrency Local Currency
ControllingObjectCurrency ControllingObjectCurrency CO Object Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
TransactionCurrency TransactionCurrency Transaction Currency
Currency Currency Valuation Crcy
BaseUnit BaseUnit Unit of Measure
FiscalYear G/L Fiscal Year
FiscalPeriod
FiscalYearPeriod FiscalYearPeriod Period/Year
WorkPackage WorkPackage Plan Item
WorkItem WorkItem Work Item ID
SalesOrder SalesOrder SD Document
SalesOrderItem SalesOrderItem Sales Order Item
BusinessTransactionType BusinessTransactionType Bus.transaction
GLAccount GLAccount General Ledger
ControllingArea ControllingArea Controlling Area
CompanyCode CompanyCode Receiver Company Code
CostCenter CostCenter Cost Center
PartnerCostCtrActivityType PartnerCostCtrActivityType Partner Cost Center Activity Type
ChartOfAccounts ChartOfAccounts Node Class
Material Material Vehicle Model
ControllingObjectDebitType ControllingObjectDebitType
ActlEffortQty
ActlCostAmtInCoCodeCrcy
ActlCostAmt
AmountInObjectCurrency
AmountInGlobalCurrency
AmountInTransactionCurrency
AmountInCompanyCodeCurrency
IsMyProject IsMyProject
ProjectManagerExternalID ProjectManagerExternalID
ProjectAccountantExternalID ProjectAccountantExternalID
ProjectControllerExternalID ProjectControllerExternalID
ProjectPartnerExternalID ProjectPartnerExternalID
ProjectManager ProjectManager Busn. Partner
ProjectAccountant ProjectAccountant
ProjectController ProjectController
Projectpartner Projectpartner
ProjectManagerName ProjectManagerName
ProjectAccountantName ProjectAccountantName
ProjectControllerName ProjectControllerName
ProjectPartnerName ProjectPartnerName
Ledger Ledger Ledger
ProjectVisibility ProjectVisibility
ProjectProfileCode ProjectProfileCode Project Profile
EngmntProjectHeaderCompanyCode EngmntProjectHeaderCompanyCode
EngagementProjectCostCenter EngagementProjectCostCenter
ProfitCenter ProfitCenter Profit Center

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 P_EngmntProjActlByPeriod.
-- 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.

CREATE VIEW P_EngmntProjActlByPeriod AS
SELECT
  EngagementProject,
  EngagementProjectServiceOrg,
  Customer,
  EngagementProjectType,
  EngagementProjectCategory,
  EngmntProjReviewYearPeriod,
  EngagementProjectReviewStatus,
  EngagementProjectStage,
  CurrentYearPeriod,
  EngagementProjFinPlanUUID,
  PlanVersion,
  CompanyCodeCurrency,
  ControllingObjectCurrency,
  GlobalCurrency,
  TransactionCurrency,
  Currency,
  BaseUnit,
  cast(FiscalYear as gjahr ) AS FiscalYear,
  cast (concat('0', FiscalPeriod) as co_perio ) AS FiscalPeriod,
  FiscalYearPeriod,
  WorkPackage,
  WorkItem,
  SalesOrder,
  SalesOrderItem,
  BusinessTransactionType,
  GLAccount,
  ControllingArea,
  CompanyCode,
  CostCenter,
  PartnerCostCtrActivityType,
  ChartOfAccounts,
  Material,
  ControllingObjectDebitType,
  sum(ValuationQuantity) AS ActlEffortQty,
  sum(ActlCostAmtInCoCodeCrcy) AS ActlCostAmtInCoCodeCrcy,
  sum(ActlCostAmt) AS ActlCostAmt,
  sum(AmountInObjectCurrency) AS AmountInObjectCurrency,
  sum(AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  sum(AmountInTransactionCurrency) AS AmountInTransactionCurrency,
  sum(AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  IsMyProject,
  ProjectManagerExternalID,
  ProjectAccountantExternalID,
  ProjectControllerExternalID,
  ProjectPartnerExternalID,
  ProjectManager,
  ProjectAccountant,
  ProjectController,
  Projectpartner,
  ProjectManagerName,
  ProjectAccountantName,
  ProjectControllerName,
  ProjectPartnerName,
  Ledger,
  ProjectVisibility,
  ProjectProfileCode,
  EngmntProjectHeaderCompanyCode,
  EngagementProjectCostCenter,
  ProfitCenter
FROM P_EngmntProjActlInProjCrcy
;

Learn More