P_ProjPMOCostLineItms

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_ProjPMOCostLineItms.
-- 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: PPRJBYPMIOCST

CREATE VIEW P_ProjPMOCostLineItms AS
SELECT
  _ProjCstLineItm.ProjectInternalID AS ProjectInternalID,
  _ProjCstLineItm.OrderID AS OrderID,
  SourceLedger,
  Ledger,
  _ProjCstLineItm.CompanyCode AS CompanyCode,
  FiscalYear,
  AccountingDocument,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  ActualPlanJournalEntryItem,
  _ProjCstLineItm.GLAccountHierarchy AS GLAccountHierarchy,
  _maintorder.MaintenanceOrder AS MaintenanceOrder,
  _ProjCstLineItm.OrderOperation AS OrderOperation,
  _ProjCstLineItm._MaintenanceOrder.MaintenanceOrderDesc AS MaintenanceOrderDesc,
  _ProjCstLineItm._MaintenanceOrderOperation.OperationDescription AS OperationDescription,
  LedgerFiscalYear,
  LedgerGLLineItem,
  FinancialPlanningEntryItem,
  AccountingDocCreatedByUser,
  BusinessArea,
  PartnerOrder,
  PartnerOrderCategory,
  PartnerWBSElement,
  PartnerProject,
  BusinessTransactionType,
  DebitCreditCode,
  ControllingDebitCreditCode,
  _maintorder._WBSElement.WBSElement AS WBSElement,
  _ProjCstLineItm.Project AS Project,
  _maintorder.WBSElementInternalID AS WBSElementInternalID,
  _ProjCstLineItm.ControllingArea AS ControllingArea,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _ProjCstLineItm.ProfitCenter AS ProfitCenter,
  CreationDate,
  _ProjCstLineItm.FunctionalArea AS FunctionalArea,
  CostCtrActivityType,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  AmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  AmountInObjectCurrency AS ActlCostInProjCrcy,
  AmountInFreeDefinedCurrency1 AS ActualAmountInFreeDfndCrcy1,
  AmountInFreeDefinedCurrency2 AS ActualAmountInFreeDfndCrcy2,
  AmountInFreeDefinedCurrency3 AS ActualAmountInFreeDfndCrcy3,
  AmountInFreeDefinedCurrency4 AS ActualAmountInFreeDfndCrcy4,
  AmountInFreeDefinedCurrency5 AS ActualAmountInFreeDfndCrcy5,
  AmountInFreeDefinedCurrency6 AS ActualAmountInFreeDfndCrcy6,
  AmountInFreeDefinedCurrency7 AS ActualAmountInFreeDfndCrcy7,
  AmountInFreeDefinedCurrency8 AS ActualAmountInFreeDfndCrcy8,
  cast(0 as fis_ksl) AS CmtmtCostInGlobalCurrency,
  cast(0 as fins_vco_ocur12) AS CmtmtCostInProjCrcy,
  cast(0 as fis_osl) AS CmtmtCostInFreeDefinedCrcy1,
  cast(0 as fis_vsl) AS CmtmtCostInFreeDefinedCrcy2,
  cast(0 as fis_bsl) AS CmtmtCostInFreeDefinedCrcy3,
  cast(0 as fis_csl) AS CmtmtCostInFreeDefinedCrcy4,
  cast(0 as fis_dsl) AS CmtmtCostInFreeDefinedCrcy5,
  cast(0 as fis_esl) AS CmtmtCostInFreeDefinedCrcy6,
  cast(0 as fis_fsl) AS CmtmtCostInFreeDefinedCrcy7,
  cast(0 as fis_gsl) AS CmtmtCostInFreeDefinedCrcy8,
  cast(0 as fis_ksl) AS PlanAmountInGlobalCurrency,
  cast(0 as fins_vco_ocur12) AS PlndCostAmtInProjCrcy,
  cast(0 as fis_osl) AS PlanAmountInFreeDefinedCrcy1,
  cast(0 as fis_vsl) AS PlanAmountInFreeDefinedCrcy2,
  cast(0 as fis_bsl) AS PlanAmountInFreeDefinedCrcy3,
  cast(0 as fis_csl) AS PlanAmountInFreeDefinedCrcy4,
  cast(0 as fis_dsl) AS PlanAmountInFreeDefinedCrcy5,
  cast(0 as fis_esl) AS PlanAmountInFreeDefinedCrcy6,
  cast(0 as fis_fsl) AS PlanAmountInFreeDefinedCrcy7,
  cast(0 as fis_gsl) AS PlanAmountInFreeDefinedCrcy8,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  '' AS IsCommitment,
  'X' AS IsSettled,
  _ProjCstLineItm.PlanningCategory AS PlanningCategory,
  cast('' as fcom_category ) AS PlanningCategory1,
  cast('' as fcom_category ) AS PlanningCategory2,
  PostingDate,
  DocumentDate,
  FiscalPeriod,
  FiscalYearPeriod,
  _ProjCstLineItm.FiscalYearVariant AS FiscalYearVariant,
  _ProjCstLineItm.IsLeadingLedger AS IsLeadingLedger,
  _ProjCstLineItm.SemanticTag AS SemanticTag
FROM P_ProjCostAcctgLineItms AS _ProjCstLineItm
INNER JOIN P_MAINTORDERBASICDATA AS _maintorder ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderPlanningCategoryMap AS _OrderCategoryMap ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_ProjCostAcctgLineItms
;