P_EnterpriseProjectPlnCosts

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_EnterpriseProjectPlnCosts.
-- 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: PENTPRJPLN

CREATE VIEW P_EnterpriseProjectPlnCosts AS
SELECT
  cast(cast('' as abap.char (2)) as fins_ledger_pers ) AS SourceLedger,
  _Ledger.Ledger AS Ledger,
  _ProjCstLineItm.CompanyCode AS CompanyCode,
  _ProjCstLineItm.FiscalYear AS FiscalYear,
  cast(cast('' as abap.char (10)) as farp_belnr_d ) AS AccountingDocument,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  cast(abs(FinancialPlanningEntryItem) as fis_act_pln_docln ) AS ActualPlanJournalEntryItem,
  cast(cast('' as abap.char (6)) as fis_docln ) AS LedgerGLLineItem,
  FinancialPlanningEntryItem,
  _ProjCstLineItm.ControllingArea AS ControllingArea,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  LedgerFiscalYear,
  cast(cast( 'P' as abap.char (1)) as fis_actual_plan_code) AS ActualPlanCode,
  _ProjCstLineItm.BusinessArea AS BusinessArea,
  _ProjCstLineItm.ProfitCenter AS ProfitCenter,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _Project.ProjectExternalID AS Project,
  _ProjCstLineItm.ProjectInternalID AS ProjectInternalID,
  _ProjCstLineItm._WBSElementBasicData.WBSElementExternalID AS WBSElement,
  _ProjCstLineItm.WBSElementInternalID AS WBSElementInternalID,
  _ProjCstLineItm.FunctionalArea AS FunctionalArea,
  _ProjCstLineItm._PartnerWBSElementBasicData.WBSElementExternalID AS PartnerWBSElement,
  _ProjCstLineItm._PartnerProjectBasicData.ProjectExternalID AS PartnerProject,
  PartnerProjectInternalID,
  PartnerWBSElementInternalID,
  PartnerFunctionalArea,
  PartnerCostCtrActivityType,
  OrderID,
  OrderOperation,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  cast( 0 as fis_act_wsl) AS ActualAmountInTransactionCrcy,
  cast( 0 as fis_act_hsl) AS ActualAmountInCompanyCodeCrcy,
  cast( 0 as fis_act_ksl) AS ActualAmountInGlobalCurrency,
  cast(AmountInObjectCurrency as fis_act_co_osl) AS ActualAmountInObjectCurrency,
  cast(AmountInTransactionCurrency as fis_plan_wsl) AS PlanAmountInTransactionCrcy,
  cast(AmountInCompanyCodeCurrency as fis_plan_hsl) AS PlanAmountInCompanyCodeCrcy,
  cast(AmountInGlobalCurrency as fis_plan_ksl) AS PlanAmountInGlobalCurrency,
  cast(AmountInObjectCurrency as fis_plan_co_osl) AS PlndCostAmtInProjCrcy,
  _ProjCstLineItm.PostingDate AS PostingDate,
  FiscalPeriod,
  FiscalYearPeriod,
  _ProjCstLineItm.FiscalYearVariant AS FiscalYearVariant,
  FinPlngEntryItemCreatedByUser AS AccountingDocCreatedByUser,
  cast( cast(substring( cast(FinPlngEntryItemCrtnDateTime as abap.char(30)) , 1 , 8) as abap.dats(8)) as fis_cpdat ) AS CreationDate,
  PlanningCategory,
  cast(' ' as fins_xcommitment) AS IsCommitment,
  _ProjCstLineItm.PartnerOrder_2 AS PartnerOrder,
  BusinessTransactionType,
  ControllingDebitCreditCode,
  CostCtrActivityType,
  'X' AS IsSettled,
  _SemanticTag.SemanticTag AS SemanticTag,
  cast(_PartnerOrder.OrderCategory as fis_par_auftyp preserving type ) AS PartnerOrderCategory,
  cast('' as fins_src_awtyp) AS SourceReferenceDocumentType,
  cast('' as fins_src_awsys) AS SourceLogicalSystem,
  cast('' as fins_src_aworg) AS SourceReferenceDocumentCntxt,
  cast('' as fins_src_awref) AS SourceReferenceDocument,
  cast('000000' as fins_src_awitem) AS SourceReferenceDocumentItem,
  cast('000000' as fins_src_awsubit) AS SourceReferenceDocSubitem,
  _WBS.ProfitCenter AS WBSElementProfitCenter,
  _WBS.WBSDescription AS WBSDescription,
  _WBS.WBSElementObject AS ProjectObjectNode,
  _WBS.ResponsibleCostCenter AS ResponsibleCostCenter,
  _WBS.ProjectType AS ProjectType,
  _Project.ProjectDescription AS ProjectDescription,
  _Project.ProjectProfileCode AS ProjectProfileCode,
  _Project.ProjectObject AS ProjectObject,
  _Project.AvailabilityControlProfile AS AvailabilityControlProfile,
  _Project.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  _Project._AvailabilityCtrlProfile.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  _Project._AvailabilityCtrlProfile.BudgetCurrencyRole AS BudgetCurrencyRole,
  _Project.ProjectUUID AS ProjectUUID,
  _Project.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  _Project.ProcessingStatus AS ProcessingStatus,
  _Project.ProjectCategory AS ProjectCategory,
  PlannedStartDate,
  PlannedEndDate
FROM I_FinancialPlanningEntryItem AS _ProjCstLineItm
INNER JOIN P_IsLeadingLedger AS _Ledger ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElementBasicData AS _WBS ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProjectsWithProjCat6 AS _Project ON /* join condition not captured in parsed metadata */
INNER JOIN P_PROJECTSEMTAGACC AS _SemanticTag ON /* join condition not captured in parsed metadata */
;