P_EngmtProjSalesActualByPerd

DDL: P_ENGMTPROJSALESACTUALBYPERD SQL: PEPSLSACTBYPRD Type: view COMPOSITE Package: CPD_CDS_MONITOR
25 Fields 1 Data Sources

Engagement Project Actual Sales By Period

P_EngmtProjSalesActualByPerd is a Composite CDS View that provides data about "Engagement Project Actual Sales By Period" in SAP S/4HANA. It reads from 1 data source (P_EngmntProjActCostAndRevn) and exposes 25 fields. Part of development package CPD_CDS_MONITOR.

Data Sources (1)

SourceAliasJoin Type
P_EngmntProjActCostAndRevn P_EngmntProjActCostAndRevn from

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PEPSLSACTBYPRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (25)

KeyFieldSource TableSource FieldDescription
EngagementProject P_EngmntProjActCostAndRevn EngagementProject Engmnt Project ID
EngagementProjFinPlanUUID P_EngmntProjActCostAndRevn EngagementProjFinPlanUUID Engagement Project
WorkPackage P_EngmntProjActCostAndRevn WorkPackage Plan Item
WorkItem P_EngmntProjActCostAndRevn WorkItem Work Item ID
Currency P_EngmntProjActCostAndRevn Currency Valuation Crcy
SalesOrder P_EngmntProjActCostAndRevn SalesOrder SD Document
SalesOrderItem P_EngmntProjActCostAndRevn SalesOrderItem Sales Order Item
Confirmed P_EngmntProjActCostAndRevn Confirmed Confirmed
AccountingDocumentStatus P_EngmntProjActCostAndRevn AccountingDocumentStatus
EngagementProjectResourceType P_EngmntProjActCostAndRevn EngagementProjectResourceType ResourceTypeID
CompanyCodeCurrency P_EngmntProjActCostAndRevn CompanyCodeCurrency Local Currency
PlanVersion
ActlCostAmtInCoCodeCrcy
ActlCostAmtInPlanCrcy
ActlRevnAmtInCoCodeCrcy
ActlRevnAmtInPlanCrcy
PersonnelNumber P_EngmntProjActCostAndRevn PersonnelNumber Personnel No.
FiscalYear P_EngmntProjActCostAndRevn FiscalYear G/L Fiscal Year
FiscalPeriod P_EngmntProjActCostAndRevn FiscalPeriod Tax period
FiscalYearPeriod
BaseUnit P_EngmntProjActCostAndRevn Unit UoM
BilledEffort
ActlEffortQty
IsMyProject P_EngmntProjActCostAndRevn IsMyProject
EngagementProjectCategory P_EngmntProjActCostAndRevn EngagementProjectCategory

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_EngmtProjSalesActualByPerd.
-- 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: PEPSLSACTBYPRD

CREATE VIEW P_EngmtProjSalesActualByPerd AS
SELECT
  P_EngmntProjActCostAndRevn.EngagementProject AS EngagementProject,
  P_EngmntProjActCostAndRevn.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  P_EngmntProjActCostAndRevn.WorkPackage AS WorkPackage,
  P_EngmntProjActCostAndRevn.WorkItem AS WorkItem,
  P_EngmntProjActCostAndRevn.Currency AS Currency,
  P_EngmntProjActCostAndRevn.SalesOrder AS SalesOrder,
  P_EngmntProjActCostAndRevn.SalesOrderItem AS SalesOrderItem,
  P_EngmntProjActCostAndRevn.Confirmed AS Confirmed,
  P_EngmntProjActCostAndRevn.AccountingDocumentStatus AS AccountingDocumentStatus,
  P_EngmntProjActCostAndRevn.EngagementProjectResourceType AS EngagementProjectResourceType,
  P_EngmntProjActCostAndRevn.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast('1' as /cpd/pfp_version_id ) AS PlanVersion,
  sum(P_EngmntProjActCostAndRevn.ActlCostAmtInCoCodeCrcy) AS ActlCostAmtInCoCodeCrcy,
  sum(P_EngmntProjActCostAndRevn.ActlCostAmtInPlanCrcy) AS ActlCostAmtInPlanCrcy,
  sum(P_EngmntProjActCostAndRevn.ActlRevnAmtInCoCodeCrcy) AS ActlRevnAmtInCoCodeCrcy,
  sum(P_EngmntProjActCostAndRevn.ActlRevnAmtInPlanCrcy) AS ActlRevnAmtInPlanCrcy,
  P_EngmntProjActCostAndRevn.PersonnelNumber AS PersonnelNumber,
  P_EngmntProjActCostAndRevn.FiscalYear AS FiscalYear,
  P_EngmntProjActCostAndRevn.FiscalPeriod AS FiscalPeriod,
  cast(concat(P_EngmntProjActCostAndRevn.FiscalYear,P_EngmntProjActCostAndRevn.FiscalPeriod) as /cpd/pfp_review_year_period) AS FiscalYearPeriod,
  P_EngmntProjActCostAndRevn.Unit AS BaseUnit,
  sum(P_EngmntProjActCostAndRevn.BilledEffort) AS BilledEffort,
  sum(P_EngmntProjActCostAndRevn.ActlEffortQty) AS ActlEffortQty,
  P_EngmntProjActCostAndRevn.IsMyProject AS IsMyProject,
  P_EngmntProjActCostAndRevn.EngagementProjectCategory AS EngagementProjectCategory
FROM P_EngmntProjActCostAndRevn
;

Learn More