P_ENGMTPROJACTUAL

DDL: P_ENGMTPROJACTUAL Type: view COMPOSITE
40 Fields 1 Data Sources

P_ENGMTPROJACTUAL is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ActualsForEngmntProject) and exposes 40 fields with key fields Project, WorkPackage, Ledger, FiscalYearPeriod, PostingDate.

Data Sources (1)

SourceAliasJoin Type
P_ActualsForEngmntProject A from

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PENGPROJACTL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view
VDM.lifecycle.contract.type #NONE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY Project P_ActualsForEngmntProject Project WBS Element
KEY WorkPackage P_ActualsForEngmntProject WorkPackage Plan Item
KEY Ledger P_ActualsForEngmntProject SourceLedger Source Ledger
KEY FiscalYearPeriod P_ActualsForEngmntProject FiscalYearPeriod Period/Year
KEY PostingDate P_ActualsForEngmntProject PostingDate Posting Date for GR
KEY FiscalYear P_ActualsForEngmntProject FiscalYear G/L Fiscal Year
KEY FiscalPeriod P_ActualsForEngmntProject FiscalPeriod Tax period
WBSElement P_ActualsForEngmntProject WBSElement WBS Internal ID
ControllingObject P_ActualsForEngmntProject ControllingObject Object number
WorkItem P_ActualsForEngmntProject WorkItem Work Item ID
PartnerCompanyCode P_ActualsForEngmntProject PartnerCompanyCode Partner Company Code
PartnerCostCenter P_ActualsForEngmntProject PartnerCostCenter Sender Cost Ctr
Currency P_ActualsForEngmntProject TransactionCurrency Transaction Currency
SalesOrder P_ActualsForEngmntProject SalesDocument SD Document
SalesOrderItem P_ActualsForEngmntProject SalesDocumentItem Sales Document Item
Material P_ActualsForEngmntProject Product Product Sold
GLAccount P_ActualsForEngmntProject GLAccount General Ledger
ChartOfAccounts P_ActualsForEngmntProject ChartOfAccounts Node Class
ControllingObjectDebitType P_ActualsForEngmntProject ControllingObjectDebitType
BusinessTransactionType P_ActualsForEngmntProject BusinessTransactionType Bus.transaction
PersonnelNumber P_ActualsForEngmntProject PersonnelNumber Personnel No.
CurrentDate
AccountAssignmentType P_ActualsForEngmntProject AccountAssignmentType Sndr AcctAssgmt Type
CompanyCodeCurrency P_ActualsForEngmntProject CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_ActualsForEngmntProject AmountInCompanyCodeCurrency Local Crcy Amt
AmountInPlanCurrency P_ActualsForEngmntProject AmountInCompanyCodeCurrency Local Crcy Amt
ControllingObjectCurrency P_ActualsForEngmntProject ControllingObjectCurrency CO Object Currency
AmountInObjectCurrency P_ActualsForEngmntProject AmountInObjectCurrency Amount in Obj Crcy
GlobalCurrency P_ActualsForEngmntProject GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency P_ActualsForEngmntProject AmountInGlobalCurrency Amount in Global Currency
BaseUnit P_ActualsForEngmntProject BaseUnit Unit of Measure
Quantity P_ActualsForEngmntProject Quantity Value
CompanyCode P_ActualsForEngmntProject PartnerCompanyCode Partner Company Code
CostCenter P_ActualsForEngmntProject PartnerCostCenter Sender Cost Ctr
ControllingArea P_ActualsForEngmntProject ControllingArea Controlling Area
SourceLedger P_ActualsForEngmntProject SourceLedger Source Ledger
IsCommitment P_ActualsForEngmntProject IsCommitment
BillableControl P_ActualsForEngmntProject BillableControl Billable Control
IsMyProject P_ActualsForEngmntProject IsMyProject
ProjectManagerName P_ActualsForEngmntProject ProjectManagerName

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_ENGMTPROJACTUAL.
-- 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_ENGMTPROJACTUAL AS
SELECT
  A.Project AS Project,
  A.WorkPackage AS WorkPackage,
  A.SourceLedger AS Ledger,
  A.FiscalYearPeriod AS FiscalYearPeriod,
  A.PostingDate AS PostingDate,
  A.FiscalYear AS FiscalYear,
  A.FiscalPeriod AS FiscalPeriod,
  A.WBSElement AS WBSElement,
  A.ControllingObject AS ControllingObject,
  A.WorkItem AS WorkItem,
  A.PartnerCompanyCode AS PartnerCompanyCode,
  A.PartnerCostCenter AS PartnerCostCenter,
  A.TransactionCurrency AS Currency,
  A.SalesDocument AS SalesOrder,
  A.SalesDocumentItem AS SalesOrderItem,
  A.Product AS Material,
  A.GLAccount AS GLAccount,
  A.ChartOfAccounts AS ChartOfAccounts,
  A.ControllingObjectDebitType AS ControllingObjectDebitType,
  A.BusinessTransactionType AS BusinessTransactionType,
  A.PersonnelNumber AS PersonnelNumber,
  $session.system_date AS CurrentDate,
  A.AccountAssignmentType AS AccountAssignmentType,
  A.CompanyCodeCurrency AS CompanyCodeCurrency,
  A.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  A.AmountInCompanyCodeCurrency AS AmountInPlanCurrency,
  A.ControllingObjectCurrency AS ControllingObjectCurrency,
  A.AmountInObjectCurrency AS AmountInObjectCurrency,
  A.GlobalCurrency AS GlobalCurrency,
  A.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  A.BaseUnit AS BaseUnit,
  A.Quantity AS Quantity,
  A.PartnerCompanyCode AS CompanyCode,
  A.PartnerCostCenter AS CostCenter,
  A.ControllingArea AS ControllingArea,
  A.SourceLedger AS SourceLedger,
  A.IsCommitment AS IsCommitment,
  A.BillableControl AS BillableControl,
  A.IsMyProject AS IsMyProject,
  A.ProjectManagerName AS ProjectManagerName
FROM P_ActualsForEngmntProject AS A
;

Learn More