P_ProjCmtmtCostLineItms

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_ProjCmtmtCostLineItms.
-- 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: PPRJBYCMTMTCST

CREATE VIEW P_ProjCmtmtCostLineItms AS
SELECT
  _ProjCstLineItm.SourceLedger AS SourceLedger,
  _SourceLedger.Ledger AS Ledger,
  _ProjCstLineItm.CompanyCode AS CompanyCode,
  _ProjCstLineItm.FiscalYear AS FiscalYear,
  _ProjCstLineItm.AccountingDocument AS AccountingDocument,
  cast(cast( '00000000000000000000000' as abap.numc (23)) as fis_fp_request_tsn ) AS FinancialPlanningReqTransSqnc,
  cast(cast( '000000' as abap.numc (6)) as fis_fp_data_packet ) AS FinancialPlanningDataPacket,
  cast( _ProjCstLineItm.LedgerGLLineItem as fis_act_pln_docln) AS ActualPlanJournalEntryItem,
  _ProjCstLineItm.LedgerFiscalYear AS LedgerFiscalYear,
  cast(cast( 'A' as abap.char (1)) as fis_actual_plan_code) AS ActualPlanCode,
  _ProjCstLineItm.LedgerGLLineItem AS LedgerGLLineItem,
  cast(cast( 0 as abap.int4 ) as fis_fp_entry_item ) AS FinancialPlanningEntryItem,
  _ProjCstLineItm.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _ProjCstLineItm.BusinessArea AS BusinessArea,
  _ProjCstLineItm.PartnerOrder AS PartnerOrder,
  _ProjCstLineItm.OrderID AS OrderID,
  _ProjCstLineItm.PartnerOrderCategory AS PartnerOrderCategory,
  _ProjCstLineItm._PartnerWBSElementBasicData.WBSElementExternalID AS PartnerWBSElement,
  _ProjCstLineItm._PartnerProjectBasicData.ProjectExternalID AS PartnerProject,
  _ProjCstLineItm.BusinessTransactionType AS BusinessTransactionType,
  _ProjCstLineItm.DebitCreditCode AS DebitCreditCode,
  _ProjCstLineItm.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _WBS.WBSElementExternalID AS WBSElement,
  _Project.ProjectExternalID AS Project,
  _Project.ProjectInternalID AS ProjectInternalID,
  _ProjCstLineItm.WBSElementInternalID AS WBSElementInternalID,
  _ProjCstLineItm.ControllingArea AS ControllingArea,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _SemanticTag.GLAccountHierarchy AS GLAccountHierarchy,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _ProjCstLineItm.ProfitCenter AS ProfitCenter,
  _ProjCstLineItm.CreationDate AS CreationDate,
  _ProjCstLineItm.FunctionalArea AS FunctionalArea,
  _ProjCstLineItm.CostCtrActivityType AS CostCtrActivityType,
  _ProjCstLineItm.ControllingObjectCurrency AS ControllingObjectCurrency,
  _ProjCstLineItm.AmountInObjectCurrency AS AmountInObjectCurrency,
  _ProjCstLineItm.TransactionCurrency AS TransactionCurrency,
  _ProjCstLineItm.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _ProjCstLineItm.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ProjCstLineItm.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _ProjCstLineItm.GlobalCurrency AS GlobalCurrency,
  _ProjCstLineItm.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ProjCstLineItm.FunctionalCurrency AS FunctionalCurrency,
  _ProjCstLineItm.AmountInFunctionalCurrency AS CmtmtAmountInFunctionalCrcy,
  _ProjCstLineItm.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _ProjCstLineItm.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
  _ProjCstLineItm.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _ProjCstLineItm.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
  _ProjCstLineItm.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _ProjCstLineItm.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
  _ProjCstLineItm.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _ProjCstLineItm.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
  _ProjCstLineItm.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _ProjCstLineItm.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
  _ProjCstLineItm.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _ProjCstLineItm.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
  _ProjCstLineItm.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _ProjCstLineItm.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
  _ProjCstLineItm.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _ProjCstLineItm.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
  _ProjCstLineItm.AmountInGlobalCurrency AS CmtmtCostInGlobalCurrency,
  _ProjCstLineItm.AmountInObjectCurrency AS CmtmtCostInProjCrcy,
  _ProjCstLineItm.AmountInFreeDefinedCurrency1 AS CmtmtCostInFreeDefinedCrcy1,
  _ProjCstLineItm.AmountInFreeDefinedCurrency2 AS CmtmtCostInFreeDefinedCrcy2,
  _ProjCstLineItm.AmountInFreeDefinedCurrency3 AS CmtmtCostInFreeDefinedCrcy3,
  _ProjCstLineItm.AmountInFreeDefinedCurrency4 AS CmtmtCostInFreeDefinedCrcy4,
  _ProjCstLineItm.AmountInFreeDefinedCurrency5 AS CmtmtCostInFreeDefinedCrcy5,
  _ProjCstLineItm.AmountInFreeDefinedCurrency6 AS CmtmtCostInFreeDefinedCrcy6,
  _ProjCstLineItm.AmountInFreeDefinedCurrency7 AS CmtmtCostInFreeDefinedCrcy7,
  _ProjCstLineItm.AmountInFreeDefinedCurrency8 AS CmtmtCostInFreeDefinedCrcy8,
  _ProjCstLineItm.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  _ProjCstLineItm.SourceLogicalSystem AS SourceLogicalSystem,
  _ProjCstLineItm.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  _ProjCstLineItm.SourceReferenceDocument AS SourceReferenceDocument,
  _ProjCstLineItm.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  _ProjCstLineItm.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  _ProjCstLineItm.IsCommitment AS IsCommitment,
  'X' AS IsSettled,
  cast( cast( 'CMTMT' as abap.char( 10 )) as fcom_category) AS PlanningCategory,
  _ProjCstLineItm.PostingDate AS PostingDate,
  _ProjCstLineItm.DocumentDate AS DocumentDate,
  _ProjCstLineItm.FiscalPeriod AS FiscalPeriod,
  _ProjCstLineItm.FiscalYearPeriod AS FiscalYearPeriod,
  _ProjCstLineItm.FiscalYearVariant AS FiscalYearVariant,
  cast( 'X' as boolean ) AS MaintenanceOrderIsSelected,
  _SemanticTag.SemanticTag AS SemanticTag,
  _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
FROM I_ProjectBasicData AS _Project
INNER JOIN I_LedgerSourceLedger AS _SourceLedger ON /* join condition not captured in parsed metadata */
INNER JOIN P_PROJECTSEMTAGACC AS _SemanticTag ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_ProjectBasicData
;