P_ProjPlnCostLineItms

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_ProjPlnCostLineItms.
-- 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: PPRJBYPLNCST

CREATE VIEW P_ProjPlnCostLineItms AS
SELECT
  _ProjCstLineItm.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _ProjCstLineItm.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  cast(abs(_ProjCstLineItm.FinancialPlanningEntryItem) as fis_act_pln_docln ) AS ActualPlanJournalEntryItem,
  cast(cast('' as abap.char (2)) as fins_ledger_pers ) AS SourceLedger,
  _ProjCstLineItm.Ledger AS Ledger,
  _ProjCstLineItm.CompanyCode AS CompanyCode,
  _ProjCstLineItm.FiscalYear AS FiscalYear,
  cast(cast('' as abap.char (10)) as farp_belnr_d ) AS AccountingDocument,
  _ProjCstLineItm.LedgerFiscalYear AS LedgerFiscalYear,
  cast(cast('' as abap.char (6)) as fis_docln ) AS LedgerGLLineItem,
  _ProjCstLineItm.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  cast(cast( 'P' as abap.char (1)) as fis_actual_plan_code) AS ActualPlanCode,
  _ProjCstLineItm.FinPlngEntryItemCreatedByUser AS AccountingDocCreatedByUser,
  _ProjCstLineItm.BusinessArea AS BusinessArea,
  _ProjCstLineItm.PartnerOrder_2 AS PartnerOrder,
  _ProjCstLineItm.OrderID AS OrderID,
  '' AS ProjectObjectType,
  ' ' AS OrderOperation,
  ' ' AS OperationDescription,
  cast(_PartnerOrder.OrderCategory as fis_par_auftyp preserving type ) AS PartnerOrderCategory,
  _ProjCstLineItm._PartnerWBSElementBasicData.WBSElementExternalID AS PartnerWBSElement,
  _ProjCstLineItm._PartnerProjectBasicData.ProjectExternalID AS PartnerProject,
  _ProjCstLineItm.BusinessTransactionType AS BusinessTransactionType,
  _ProjCstLineItm.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _WBS.Plant AS Plant,
  _WBS.WBSElementExternalID AS WBSElement,
  _Project.ProjectExternalID AS Project,
  _Project.ProjectInternalID AS ProjectInternalID,
  _ProjCstLineItm.WBSElementInternalID AS WBSElementInternalID,
  _ProjCstLineItm.ControllingArea AS ControllingArea,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _ProjCstLineItm.ProfitCenter AS ProfitCenter,
  _SemanticTag.GLAccountHierarchy AS GLAccountHierarchy,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  cast(cast(substring(FinancialPlanningReqTransSqnc,1,8)as abap.dats) as fis_budat ) 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 PlanAmountInFunctionalCurrency,
  _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.AmountInObjectCurrency AS PlndCostAmtInProjCrcy,
  _ProjCstLineItm.AmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  _ProjCstLineItm.AmountInFreeDefinedCurrency1 AS PlanAmountInFreeDefinedCrcy1,
  _ProjCstLineItm.AmountInFreeDefinedCurrency2 AS PlanAmountInFreeDefinedCrcy2,
  _ProjCstLineItm.AmountInFreeDefinedCurrency3 AS PlanAmountInFreeDefinedCrcy3,
  _ProjCstLineItm.AmountInFreeDefinedCurrency4 AS PlanAmountInFreeDefinedCrcy4,
  _ProjCstLineItm.AmountInFreeDefinedCurrency5 AS PlanAmountInFreeDefinedCrcy5,
  _ProjCstLineItm.AmountInFreeDefinedCurrency6 AS PlanAmountInFreeDefinedCrcy6,
  _ProjCstLineItm.AmountInFreeDefinedCurrency7 AS PlanAmountInFreeDefinedCrcy7,
  _ProjCstLineItm.AmountInFreeDefinedCurrency8 AS PlanAmountInFreeDefinedCrcy8,
  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 preserving type ) AS SourceReferenceDocumentItem,
  cast('000000' as fins_src_awsubit preserving type ) AS SourceReferenceDocSubitem,
  cast(' ' as fins_xcommitment preserving type ) AS IsCommitment,
  'X' AS IsSettled,
  _ProjCstLineItm.PlanningCategory AS PlanningCategory,
  cast( '' as fcom_category ) AS PlanningCategory1,
  cast( '' as fcom_category ) AS PlanningCategory2,
  _ProjCstLineItm.PostingDate AS PostingDate,
  cast( '00000000' as bldat ) 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,
  _ProjCstLineItm._FiscalCalendarDate.FiscalYear AS OriginalFiscalYear,
  _ProjCstLineItm._FiscalCalendarDate.FiscalPeriod AS OriginalFiscalPeriod,
  _ProjCstLineItm._FiscalCalendarDate.FiscalYearPeriod AS NextFiscalYearPeriod
FROM I_ProjectBasicData AS _Project
INNER JOIN P_PROJECTSEMTAGACC AS _SemanticTag ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderPlanningCategoryMap AS _OrderCategoryMap ON /* join condition not captured in parsed metadata */
INNER JOIN I_ManufacturingOrder AS _Orders ON /* join condition not captured in parsed metadata */
INNER JOIN I_FinancialPlanningEntryItem AS _ProjCstLineItm ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_ProjectBasicData, I_WBSElementBasicData
;