P_PROJACTUALBUDGETLINEITEMS

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_PROJACTUALBUDGETLINEITEMS.
-- 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: PPRJBYACTBGT

CREATE VIEW P_PROJACTUALBUDGETLINEITEMS AS
SELECT
  _ProjCstLineItm.SourceLedger AS SourceLedger,
  _ProjCstLineItm.SourceLedger 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,
  _ProjCstLineItm.AccountingDocument AS AccountingDocument,
  cast( '00000000000000000000000' as fis_fp_request_tsn preserving type ) AS FinancialPlanningReqTransSqnc,
  cast( '000000' as fis_fp_data_packet preserving type ) AS FinancialPlanningDataPacket,
  cast( LedgerGLLineItem as fis_act_pln_docln) AS ActualPlanJournalEntryItem,
  _ProjCstLineItm.LedgerFiscalYear AS LedgerFiscalYear,
  _ProjCstLineItm.LedgerGLLineItem AS LedgerGLLineItem,
  cast( 0 as fis_fp_entry_item ) AS FinancialPlanningEntryItem,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  _ProjCstLineItm.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _SemTagGL.GLAccountHierarchy AS GLAccountHierarchy,
  _ProjCstLineItm.BusinessArea AS BusinessArea,
  _ProjCstLineItm.CostCenter AS CostCenter,
  cast(' ' as budget_process preserving type ) AS BudgetProcess,
  _ProjCstLineItm.PartnerOrder AS PartnerOrder,
  _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,
  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,
  _ProjectSummary.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,
  _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 AmountInFunctionalCurrency,
  _ProjCstLineItm.AmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  _ProjCstLineItm.AmountInObjectCurrency AS ActlCostInProjCrcy,
  _ProjCstLineItm.AmountInFunctionalCurrency AS ActualAmountInFunctionalCrcy,
  _ProjCstLineItm.AmountInCompanyCodeCurrency AS ActualAmountInCompanyCodeCrcy,
  _ProjCstLineItm.AmountInTransactionCurrency AS ActualAmountInTransactionCrcy,
  cast( cast( 'ACT01' 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,
  case when _ProjCstLineItm.PurchasingDocument <> '' then 'PORD ' end AS SourceReferenceDocumentType,
  _ProjCstLineItm.SourceLogicalSystem AS SourceLogicalSystem,
  _ProjCstLineItm.SourceReferenceDocumentCntxt AS SourceReferenceDocumentCntxt,
  _ProjCstLineItm.PurchasingDocument AS SourceReferenceDocument,
  cast(cast(_ProjCstLineItm.PurchasingDocumentItem as abap.char( 6 ) ) as fins_src_awitem ) AS SourceReferenceDocumentItem,
  _ProjCstLineItm.SourceReferenceDocSubitem AS SourceReferenceDocSubitem,
  _ProjCstLineItm.IsCommitment AS IsCommitment,
  _ProjCstLineItm.OrderID AS OrderID,
  _ProjCstLineItm.PartnerAccountAssignmentType AS PartnerAccountAssignmentType,
  cast( 'X' as boolean ) AS MaintenanceOrderIsSelected,
  _SemTagGL.SemanticTag AS SemanticTag,
  _AllCost.SemanticTagIsBudgetRelevant AS SemanticTagIsBudgetRelevant,
  _AllCost.SemanticTagIsBudgetRelevant AS ObjectIsBudgeted,
  _AllCost.ProjectIsBudgetRelevant AS ProjectIsBudgetRelevant,
  case when ( _ProjCstLineItm.ControllingDebitCreditCode <> 'A' and _ProjCstLineItm.ControllingDebitCreditCode <> 'S' ) or ( _ProjCstLineItm.ControllingDebitCreditCode = 'S' and ( _ProjCstLineItm.BusinessTransactionType <> 'KOAO' and _ProjCstLineItm.BusinessTransactionType <> 'KOAE' ) ) or ( _ProjCstLineItm.ControllingDebitCreditCode = 'S' and (_ProjCstLineItm.BusinessTransactionType = 'KOAO' or _ProjCstLineItm.BusinessTransactionType = 'KOAE') and ( _ProjCstLineItm.PartnerProject <> _ProjCstLineItm.Project and ( _ProjCstLineItm.PartnerProject <> ' ' or _ProjCstLineItm.PartnerOrder <> ' ' or _ProjCstLineItm.PartnerSalesDocument <> ' ' or _ProjCstLineItm.PartnerProjectNetwork <> ' ' or _ProjCstLineItm.PartnerProjectNetworkActivity <> ' ' or _ProjCstLineItm.PartnerBusinessProcess <> ' ' or _ProjCstLineItm.PartnerCostObject <> ' ') ) ) then 'X' end as IsSettled AS PartnerCostObjectthenXendasIsSettled,
  _ProjCstLineItm._Ledger.IsLeadingLedger AS IsLeadingLedger
FROM I_EnterpriseProject AS _ProjectSummary
INNER JOIN I_GLAccountLineItemRawData AS _ProjCstLineItm ON /* join condition not captured in parsed metadata */
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 */
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FiscalPeriod ON LedgerFiscalYear = _FiscalPeriod.FiscalYear AND FiscalPeriod = _FiscalPeriod.FiscalPeriod AND FiscalYearVariant = _FiscalPeriod.FiscalYearVariant  -- association [0..1]
-- UNION with additional select branch(es): P_ProjectsWithProjCat6
;