P_ACTVENTPROJACTCOSTSFORLEDGER

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_ACTVENTPROJACTCOSTSFORLEDGER.
-- 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: PACTENTPROJLED

CREATE VIEW P_ACTVENTPROJACTCOSTSFORLEDGER AS
SELECT
  ProjCstLineItm.FiscalYear AS FiscalYear,
  ProjCstLineItm.LedgerFiscalYear AS LedgerFiscalYear,
  ProjCstLineItm.FiscalPeriod AS FiscalPeriod,
  ProjCstLineItm.FiscalYearPeriod AS FiscalYearPeriod,
  ProjCstLineItm.PostingDate AS PostingDate,
  ProjCstLineItm.AccountingDocument AS AccountingDocument,
  ProjCstLineItm.LedgerGLLineItem AS LedgerGLLineItem,
  ProjCstLineItm.GLAccount AS GLAccount,
  ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  Project.CompanyCode AS CompanyCode,
  Project.ProfitCenter AS ProfitCenter,
  Project.ControllingArea AS ControllingArea,
  Project.ProjectUUID AS ProjectUUID,
  ProjCstLineItm.ProjectInternalID AS ProjectInternalID,
  Project.ProjectType AS ProjectType,
  Project.ProjectExternalID AS Project,
  Project.ProjectCurrency AS ControllingObjectCurrency,
  ProjCstLineItm.GlobalCurrency AS GlobalCurrency,
  Project.ProjectDescription AS ProjectDescription,
  Project.AvailabilityControlProfile AS AvailabilityControlProfile,
  Project.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  Project._AvailabilityCtrlProfile.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  Project._AvailabilityCtrlProfile.BudgetCurrencyRole AS BudgetCurrencyRole,
  cast( cast( 'ACT01' as abap.char( 10 )) as fcom_category) AS PlanningCategory,
  Project.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  ProjCstLineItm.CreationDate AS CreationDate,
  sum(ProjCstLineItm.AmountInObjectCurrency) AS AmountInObjectCurrency,
  sum(ProjCstLineItm.AmountInGlobalCurrency) AS AmountInGlobalCurrency
FROM P_ActvPROJECTSWITHPROJCAT6 AS Project
INNER JOIN I_GLAccountLineItemRawData AS ProjCstLineItm ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerSourceLedger AS SourceLedger ON /* join condition not captured in parsed metadata */
INNER JOIN P_IsLeadingLedger AS Ledger ON /* join condition not captured in parsed metadata */
;