A_ProjectActualCost

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 A_ProjectActualCost.
-- 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.
-- Parameters: P_ProjectObjectNode : j_objnr, P_ProjectObjectRootNode : j_objnr, P_Ledger : fins_ledger

CREATE VIEW A_ProjectActualCost AS
SELECT
  lookupEntity: 'I_PROJECTOBJECTUNION' AS lookupEntityI_PROJECTOBJECTUNION,
  resultElement: 'ProjectObjectRootNode' AS resultElementProjectObjectRootNode,
  resultElement: 'Ledger' AS P_ProjectObjectNode,
  _ProjCostLineItems.FiscalYear AS FiscalYear,
  _ProjCostLineItems.AccountingDocument AS AccountingDocument,
  _ProjCostLineItems.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  _ProjectHierarchy.ProjectObjectParentNode AS ProjectObjectParentNode,
  cast( _ProjGLAccountHierarchy.ProjectCostComponent as ps_s4_projcostcomp preserving type ) AS ProjectCostComponent,
  _ProjGLAccountHierarchy.GLAccountHierarchy AS GLAccountHierarchy,
  _ProjCostLineItems.CreatedByUser AS CreatedByUser,
  _ProjCostLineItems.BusinessArea AS BusinessArea,
  _ProjCostLineItems.ProjectObjectType AS ProjectObjectType,
  _ProjCostLineItems.MaintenanceOrder AS MaintenanceOrder,
  _ProjCostLineItems.InternalOrder AS InternalOrder,
  _ProjCostLineItems.ProductionOrder AS ProductionOrder,
  _ProjCostLineItems.Product AS Product,
  _ProjCostLineItems.ServiceOrder AS ServiceOrder,
  _ProjCostLineItems.ServiceOrderItem AS ServiceOrderItem,
  _ProjCostLineItems.ServiceContract AS ServiceContract,
  _ProjCostLineItems.ServiceContractItem AS ServiceContractItem,
  _ProjCostLineItems.BusinessTransactionType AS BusinessTransactionType,
  _ProjCostLineItems.ControllingBusTransacType AS ControllingBusTransacType,
  _ProjCostLineItems.ControllingCostRevenueCode AS ControllingCostRevenueCode,
  _ProjCostLineItems.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _ProjCostLineItems.WBSElement AS WBSElement,
  _ProjCostLineItems.ProjectNetwork AS ProjectNetwork,
  _ProjCostLineItems.NetworkActivity AS NetworkActivity,
  _ProjCostLineItems.NetworkActivityElement AS NetworkActivityElement,
  _ProjCostLineItems.ProjectObjectExternalID AS ProjectObjectExternalID,
  _ProjCostLineItems.Project AS Project,
  _ProjCostLineItems.ControllingArea AS ControllingArea,
  _ProjCostLineItems.GLAccount AS GLAccount,
  _ProjCostLineItems.ChartOfAccounts AS ChartOfAccounts,
  _ProjCostLineItems.CostCenter AS CostCenter,
  _ProjCostLineItems.CreationDate AS CreationDate,
  _ProjCostLineItems.FunctionalArea AS FunctionalArea,
  _ProjCostLineItems.CostCtrActivityType AS CostCtrActivityType,
  _ProjCostLineItems.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  _ProjCostLineItems.OriginCostCenter AS OriginCostCenter,
  _ProjCostLineItems.ControllingObjectCurrency AS ControllingObjectCurrency,
  _ProjCostLineItems.TransactionCurrency AS TransactionCurrency,
  _ProjCostLineItems.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ProjCostLineItems.GlobalCurrency AS GlobalCurrency,
  _ProjCostLineItems.FunctionalCurrency AS FunctionalCurrency,
  _ProjCostLineItems.AmountInObjectCurrency AS AmountInObjectCurrency,
  _ProjCostLineItems.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _ProjCostLineItems.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _ProjCostLineItems.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ProjCostLineItems.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _ProjCostLineItems.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _ProjCostLineItems.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _ProjCostLineItems.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _ProjCostLineItems.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _ProjCostLineItems.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _ProjCostLineItems.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _ProjCostLineItems.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _ProjCostLineItems.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _ProjCostLineItems.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _ProjCostLineItems.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _ProjCostLineItems.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _ProjCostLineItems.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _ProjCostLineItems.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _ProjCostLineItems.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _ProjCostLineItems.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _ProjCostLineItems.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _ProjCostLineItems.ProjectCostIsNotSettled AS ProjectCostIsNotSettled,
  _ProjCostLineItems.PostingDate AS PostingDate,
  _ProjCostLineItems.DocumentDate AS DocumentDate,
  _ProjCostLineItems.FiscalPeriod AS FiscalPeriod,
  _ProjCostLineItems.FiscalYearVariant AS FiscalYearVariant,
  _ProjCostLineItems.ProjectObjectProfitCenter AS ProjectObjectProfitCenter,
  _ProjCostLineItems.ProjectObjectDescription AS ProjectObjectDescription,
  _ProjCostLineItems.ProjectObjectNode AS ControllingObject,
  _ProjCostLineItems.ProjectObjectRootNode AS ProjectObjectRootNode,
  _ProjCostLineItems.OrderType AS OrderType,
  _ProjCostLineItems._NetworkActivity AS _NetworkActivity,
  _ProjCostLineItems._ProjectNetwork AS _ProjectNetwork,
  _ProjCostLineItems._WBSElement AS _WBSElement
FROM I_ProjectActualCostLineItem AS _ProjCostLineItems
INNER JOIN I_ProjFinancialHierarchyNode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProjectGLAccountHierarchy_2 AS _ProjGLAccountHierarchy ON GLAccount = _ProjGLAccountHierarchy.GLAccount  -- association [0..*]
;