C_ProjectPlanActQ2203

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 C_ProjectPlanActQ2203.
-- 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: CFIPROPLACTQ2203
-- Parameters: P_PlanningCategory : fcom_category, P_BaselinePlanningCategory : fcom_category, P_OngoingPlanningCategory : fcom_category, P_KeyDate : vdm_v_key_date, P_Language : sylangu, P_BusinessUser : syuname, P_ControllingArea : kokrs, P_Ledger : fins_ledger

CREATE VIEW C_ProjectPlanActQ2203 AS
SELECT
  lookupEntity: 'I_CommlProjMgmtPlngCat' AS lookupEntityI_CommlProjMgmtPlngCat,
  resultElement: 'PlanningCategory' AS resultElementPlanningCategory,
  resultElement: 'ControllingArea' AS resultElementControllingArea,
  resultElement: 'Ledger' AS resultElementLedger,
  binding: [ { targetElement : 'IsLeadingLedger' , type : #CONSTANT, value : 'X' AS P_PlanningCategoryasPlanningCategoryName,
  $parameters.P_BaselinePlanningCategory AS BaselinePlanningCategory,
  $parameters.P_OngoingPlanningCategory AS OngoingPlanningCategory,
  WBSElement,
  GLAccount,
  _GLAccountInChartOfAccounts._Text[1:Language = $parameters.P_Language].GLAccountName AS GLAccountName,
  BillableControl,
  ControllingObjectCurrency,
  CompanyCode,
  CompanyCodeCurrency,
  CostSourceUnit,
  ControllingDebitCreditCode,
  FiscalPeriod,
  FiscalYearVariant,
  FunctionalArea,
  GlobalCurrency,
  LedgerFiscalYear,
  OriginProfitCenter,
  PersonnelNumber,
  ProfitCenter,
  CostAnalysisResource,
  _CostAnalysisResource[1:ValidityEndDate >= $parameters.P_KeyDate and ValidityStartDate <= $parameters.P_KeyDate]._Text[1:Language = $parameters.P_Language].CostAnalysisResourceName AS CostAnalysisResourceName,
  Segment,
  WorkItem,
  1 AS EACAmtInCompanyCodeCrcy,
  1 AS BaselineCoCodCrcyDifferencePct,
  1 AS EACCCodeCrcyDifferencePct,
  1 AS OngoingCCodeCrcyDifferencePct,
  1 AS EACAmtInGlobalCrcy,
  1 AS BaselineGlobalCrcyDiffPct,
  1 AS EACGlobalCrcyDifferencePct,
  1 AS OngoingGlobalCrcyDifferencePct,
  1 AS EstAtCompletionAmtInObjectCrcy,
  1 AS ObjectCrcyBaselineDiffPct,
  1 AS ObjCrcyEstAtCompletionDiffPct,
  1 AS ObjectCrcyOngoingDifferencePct
FROM I_ActualPlanJrnlEntryItemCube
;