P_ProjPlnBudgetLineItms

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_ProjPlnBudgetLineItms.
-- 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: PPRJBYPLNBGT

CREATE VIEW P_ProjPlnBudgetLineItms AS
SELECT
  cast(cast('' as abap.char (2)) as fins_ledger_pers ) AS SourceLedger,
  _ProjCstLineItm.Ledger AS Ledger,
  case when _ProjCstLineItm.CompanyCode is initial or _ProjCstLineItm.CompanyCode is null then _WBSElementBasicData.CompanyCode else _ProjCstLineItm.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  _ProjCstLineItm.FiscalYear AS FiscalYear,
  cast(cast('' as abap.char (10)) as farp_belnr_d ) AS AccountingDocument,
  _ProjCstLineItm.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  _ProjCstLineItm.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  cast(abs(_ProjCstLineItm.FinancialPlanningEntryItem) as fis_act_pln_docln ) AS ActualPlanJournalEntryItem,
  _ProjCstLineItm.LedgerFiscalYear AS LedgerFiscalYear,
  cast(cast('' as abap.char (6)) as fis_docln ) AS LedgerGLLineItem,
  _ProjCstLineItm.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  _ProjCstLineItm.FinPlngEntryItemCreatedByUser AS AccountingDocCreatedByUser,
  _SemTagGL.GLAccountHierarchy AS GLAccountHierarchy,
  _ProjCstLineItm.BusinessArea AS BusinessArea,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _ProjCstLineItm.BudgetProcess AS BudgetProcess,
  _ProjCstLineItm.PartnerOrder_2 AS PartnerOrder,
  cast(_ProjCstLineItm._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,
  case when _ProjCstLineItm.ProfitCenter is initial or _ProjCstLineItm.ProfitCenter is null then _WBSElementBasicData.ProfitCenter else _ProjCstLineItm.ProfitCenter end as ProfitCenter AS ProfitCenterendasProfitCenter,
  _WBSElementBasicData.ProfitCenter AS WBSElementProfitCenter,
  _WBSElementBasicData.WBSDescription AS WBSDescription,
  _WBSElementBasicData.WBSElementObject AS ProjectObjectNode,
  _WBSElementBasicData.WBSElementExternalID AS WBSElement,
  _WBSElementBasicData.ResponsibleCostCenter AS ResponsibleCostCenter,
  _WBSElementBasicData.ProjectType AS ProjectType,
  _ProjCstLineItm.WBSElementInternalID AS WBSElementInternalID,
  _ProjCstLineItm.ControllingArea AS ControllingArea,
  _ProjCstLineItm._ProjectBasicData.ProjectExternalID AS Project,
  _ProjCstLineItm.ProjectInternalID AS ProjectInternalID,
  _ProjectSummary.Project AS ProjectExternalID,
  _ProjCstLineItm._ProjectBasicData.ProjectDescription AS ProjectDescription,
  _ProjCstLineItm._ProjectBasicData.ProjectProfileCode AS ProjectProfileCode,
  _ProjCstLineItm._ProjectBasicData.ProjectObject AS ProjectObject,
  _ProjCstLineItm._ProjectBasicData.AvailabilityControlProfile AS AvailabilityControlProfile,
  _ProjCstLineItm._ProjectBasicData.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  _ProjCstLineItm._ProjectBasicData._AvailabilityCtrlProfile._SemanticTag.SemanticTag AS ParentSemanticTag,
  _ProjCstLineItm._ProjectBasicData._AvailabilityCtrlProfile.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  _ProjCstLineItm._ProjectBasicData._AvailabilityCtrlProfile.BudgetCurrencyRole AS BudgetCurrencyRole,
  _ProjCstLineItm._ProjectBasicData.ProjectCurrency AS ProjectCurrency,
  _WBSElementBasicData.Plant AS Plant,
  _ProjectSummary.ProjectSummaryTaskUUID AS ProjectSummaryTaskUUID,
  '6' AS ProjectCategory,
  _ProjectSummary.ProjectUUID AS ProjectUUID,
  _ProjectSummary.ProcessingStatus AS ProcessingStatus,
  _ProjectSummary.ProjectSummaryTaskUUID AS TaskUUID,
  cast( cast(substring( cast(_ProjCstLineItm.FinPlngEntryItemCrtnDateTime as abap.char(30)) , 1 , 8) as abap.dats(8)) as fis_cpdat ) 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 AmountInFunctionalCurrency,
  _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,
  'X' AS IsSettled,
  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,
  _ProjCstLineItm.OrderID AS OrderID,
  cast('' as fcom_category ) AS OrderPlanningCategory,
  cast( 'X' as boolean ) AS MaintenanceOrderIsSelected,
  _SemTagGL.SemanticTag AS SemanticTag,
  _AllCost.SemanticTagIsBudgetRelevant AS SemanticTagIsBudgetRelevant,
  _AllCost.SemanticTagIsBudgetRelevant AS ObjectIsBudgeted,
  _AllCost.ProjectIsBudgetRelevant AS ProjectIsBudgetRelevant
FROM I_EnterpriseProject AS _ProjectSummary
INNER JOIN P_PROJECTSEMTAGACC AS _SemTagGL ON /* join condition not captured in parsed metadata */
INNER JOIN P_GetRlvtSemanticTagForProj AS _AllCost ON /* join condition not captured in parsed metadata */
INNER JOIN I_FinancialPlanningEntryItem AS _ProjCstLineItm ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintenanceOrder AS _Orders ON /* join condition not captured in parsed metadata */
INNER JOIN I_OrderPlanningCategoryMap AS _OrderCategoryMap ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriod ON LedgerFiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND FiscalYearVariant = _FiscalPeriod.FiscalYearVariant  -- association [0..1]
-- UNION ALL with additional select branch(es): P_ProjectsWithProjCat6
;