P_ProjectPlanCostLineItem

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_ProjectPlanCostLineItem.
-- 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: PPROJBYPLANCOST
-- Parameters: P_ProjectObjectRootNode : j_objnr

CREATE VIEW P_ProjectPlanCostLineItem 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 AS PartnerOrder,
  case when _hierachyData.ProjectObjectType = 'OR' then _ProjCstLineItm.OrderID else '' end as OrderID AS OrderIDelseendasOrderID,
  _ProjCstLineItm.ControllingObject AS ControllingObject,
  _ProjCstLineItm.OrderOperation AS OrderOperation,
  _ProjCstLineItm.OrderSuboperation AS OrderSuboperation,
  case when _hierachyData.ProjectObjectType = 'IO' then _ProjCstLineItm.OrderID else '' end as InternalOrder AS OrderIDelseendasInternalOrder,
  case when _hierachyData.ProjectObjectType = 'PP' then _ProjCstLineItm.OrderID else '' end as ProductionOrder AS OrderIDelseendasProductionOrder,
  _ProjCstLineItm.Product AS Product,
  case when _hierachyData.ProjectObjectType = 'SV' then _ProjCstLineItm.ServiceDocument else '' end as ServiceOrder AS ServiceDocumentelseendasServiceOrder,
  case when _hierachyData.ProjectObjectType = 'SC' then _ProjCstLineItm.ServiceDocument else '' end as ServiceContract AS ServiceDocumentelseendasServiceContract,
  cast(_PartnerOrder.OrderCategory as fis_par_auftyp preserving type ) AS PartnerOrderCategory,
  _hierachyData.ProjectObjectType AS ProjectObjectType,
  case when _hierachyData.ProjectObjectType = 'PR' or _hierachyData.ProjectObjectType = 'OR' then _ProjCstLineItm.PartnerWBSElement when _hierachyData.ProjectObjectType = 'NV' or _hierachyData.ProjectObjectType = 'EL' or _hierachyData.ProjectObjectType = 'NP' then _ProjCstLineItm.PartnerOrder end as ProjectPartnerObject AS PartnerOrderendasProjectPartnerObject,
  _ProjCstLineItm.PartnerProject AS PartnerProject,
  _ProjCstLineItm.BusinessTransactionType AS BusinessTransactionType,
  _ProjCstLineItm.ControllingDebitCreditCode AS ControllingDebitCreditCode,
  _hierachyData.WBSElement AS WBSElement,
  _ProjCstLineItm.ProjectNetwork AS ProjectNetwork,
  _NetworkActivity.NetworkActivity AS NetworkActivity,
  _NetworkActivity.NetworkActivityElement AS NetworkActivityElement,
  _hierachyData.ProjectObjectExternalID AS ProjectObjectExternalID,
  case when _hierachyData.ProjectObjectType = 'PR' or _hierachyData.ProjectObjectType = 'OR' or _hierachyData.ProjectObjectType = 'NP' then '' when _hierachyData.ProjectObjectType = 'NV' or _hierachyData.ProjectObjectType = 'EL' then _ProjCstLineItm.OrderItem end as ProjectNetworkActivity AS OrderItemendasProjectNetworkActivity,
  _hierachyData.Project AS Project,
  _ProjCstLineItm.ProjectInternalID AS ProjectInternalID,
  case when _hierachyData.ProjectObjectType = 'PR' then _ProjCstLineItm.WBSElementInternalID when _hierachyData.ProjectObjectType = 'OR' or _hierachyData.ProjectObjectType = 'PP' then _ProjCstLineItm.OrderID when _hierachyData.ProjectObjectType = 'NV' or _hierachyData.ProjectObjectType = 'EL' or _hierachyData.ProjectObjectType = 'NP' then _ProjCstLineItm.ProjectNetwork end as ObjectInternalID AS ProjectNetworkendasObjectInternalID,
  _ProjCstLineItm.ControllingArea AS ControllingArea,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _ProjCstLineItm.ProfitCenter AS ProfitCenter,
  _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.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  _ProjCstLineItm.OriginCostCenter AS OriginCostCenter,
  _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,
  _ProjCstLineItm.PostingDate AS PostingDate,
  cast( '00000000' as bldat ) AS DocumentDate,
  _ProjCstLineItm.FiscalPeriod AS FiscalPeriod,
  _ProjCstLineItm.FiscalYearPeriod AS FiscalYearPeriod,
  _ProjCstLineItm.FiscalYearVariant AS FiscalYearVariant,
  _ProjCstLineItm.PartnerProfitCenter AS PartnerProfitCenter,
  _ProjCstLineItm.PartnerCompanyCode AS PartnerCompanyCode,
  cast( 'X' as boolean ) AS MaintenanceOrderIsSelected,
  _hierachyData.ProjectObjectProfitCenter AS ProjectObjectProfitCenter,
  _hierachyData.ProjectObjectDescription AS ProjectObjectDescription,
  _hierachyData.ProjectObjectNode AS ProjectObjectNode,
  _hierachyData.ProjectObjectRootNode AS ProjectObjectRootNode,
  _hierachyData.ResponsibleCostCenter AS ResponsibleCostCenter,
  _hierachyData.ProjectType AS ProjectType,
  _hierachyData.OrderType AS OrderType,
  _ProjCstLineItm.OrderID AS OrderID,
  _ProjCstLineItm.OrderID AS InternalOrder,
  '' AS ProductionOrder,
  '' AS ServiceOrder,
  '' AS ServiceOrderItem,
  '' AS ServiceContract,
  '' AS ServiceContractItem,
  _ProjCstLineItm.PartnerWBSElement AS ProjectPartnerObject,
  '' AS PartnerProjectNetworkActivity,
  '' AS ProjectNetworkActivity,
  _ProjCstLineItm.OrderID AS ObjectInternalID,
  cast( 'IO' as ps_s4_projselobj ) AS ProjectSelectedObject,
  _AppendIndicator.OrderTypeAppendedCode AS OrderTypeAppendedCode
FROM I_FinancialPlanningEntryItem AS _ProjCstLineItm
INNER JOIN P_ProjectObject_2 AS _hierachyData ON /* join condition not captured in parsed metadata */
INNER JOIN I_InternalOrder AS InternalOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VirtualPlanningCategory AS _VirtualPlanningCategory ON PlanningCategory = _VirtualPlanningCategory.SourcePlanningCategory  -- association [0..*]
LEFT OUTER JOIN I_PrjAppendedOrdForCostReport AS _AppendIndicator ON OrderType = _AppendIndicator.OrderType AND ControllingArea = _AppendIndicator.ControllingArea  -- association [0..1]
-- UNION ALL with additional select branch(es): I_FinancialPlanningEntryItem
;