P_ProjectBudgetItems

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_ProjectBudgetItems.
-- 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: PPROJBDGTITM

CREATE VIEW P_ProjectBudgetItems AS
SELECT
  SourceLedger,
  Ledger,
  case when _ProjCstLineItm.CompanyCode is initial or _ProjCstLineItm.CompanyCode is null then _WBSElementBasicData.CompanyCode else _ProjCstLineItm.CompanyCode end as CompanyCode AS CompanyCodeendasCompanyCode,
  FiscalYear,
  AccountingDocument,
  FinancialPlanningReqTransSqnc,
  FinancialPlanningDataPacket,
  ActualPlanJournalEntryItem,
  LedgerFiscalYear,
  LedgerGLLineItem,
  FinancialPlanningEntryItem,
  _ProjCstLineItm.GLAccount AS GLAccount,
  _ProjCstLineItm.ChartOfAccounts AS ChartOfAccounts,
  AccountingDocCreatedByUser,
  _SemTagGL.GLAccountHierarchy AS GLAccountHierarchy,
  BusinessArea,
  _ProjCstLineItm.CostCenter AS CostCenter,
  _ProjCstLineItm.BudgetProcess AS BudgetProcess,
  _ProjCstLineItm.PartnerOrder_2 AS PartnerOrder,
  PartnerOrderCategory,
  _ProjCstLineItm.PartnerWBSElementExternalID AS PartnerWBSElement,
  _ProjCstLineItm.PartnerProjectExternalID AS PartnerProject,
  BusinessTransactionType,
  DebitCreditCode,
  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,
  _ProjCstLineItm.WBSElementExternalID AS WBSElement,
  _WBSElementBasicData.ResponsibleCostCenter AS ResponsibleCostCenter,
  _ProjectSummary.EnterpriseProjectType AS ProjectType,
  _ProjCstLineItm.WBSElementInternalID AS WBSElementInternalID,
  Project.ControllingArea AS ControllingArea,
  _ProjCstLineItm.ProjectExternalID AS Project,
  _ProjCstLineItm.ProjectInternalID AS ProjectInternalID,
  _ProjCstLineItm.ProjectExternalID AS ProjectExternalID,
  Project.ProjectDescription AS ProjectDescription,
  Project.ProjectProfileCode AS ProjectProfileCode,
  Project.ProjectObject AS ProjectObject,
  Project.AvailabilityControlProfile AS AvailabilityControlProfile,
  Project.AvailabilityControlIsActive AS AvailabilityControlIsActive,
  Project._AvailabilityCtrlProfile._SemanticTag.SemanticTag AS ParentSemanticTag,
  Project._AvailabilityCtrlProfile.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  Project._AvailabilityCtrlProfile.BudgetCurrencyRole AS BudgetCurrencyRole,
  Project.ProjectCurrency AS ProjectCurrency,
  _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,
  CostCtrActivityType,
  ControllingObjectCurrency,
  AmountInObjectCurrency,
  TransactionCurrency,
  AmountInTransactionCurrency,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  GlobalCurrency,
  AmountInGlobalCurrency,
  _ProjCstLineItm.FunctionalCurrency AS FunctionalCurrency,
  _ProjCstLineItm.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  PostingDate,
  DocumentDate,
  FiscalPeriod,
  FiscalYearPeriod,
  _ProjCstLineItm.FiscalYearVariant AS FiscalYearVariant,
  case when ControllingDebitCreditCode = 'A' then '' when ControllingDebitCreditCode = 'S' and (BusinessTransactionType = 'KOAO' or BusinessTransactionType = 'KOAE') and ( PartnerProject = ' ' and PartnerOrder = ' ' and PartnerSalesDocument = ' ' and PartnerProjectNetwork = ' ' and PartnerProjectNetworkActivity = ' ' and PartnerBusinessProcess = ' ' and PartnerCostObject = ' ') then '' when ControllingDebitCreditCode = 'S' and (BusinessTransactionType = 'KOAO' or BusinessTransactionType = 'KOAE') and (PartnerProject = _ProjCstLineItm.Project) then '' else 'X' end as IsSettled AS ProjectthenelseXendasIsSettled,
  SourceReferenceDocumentType,
  SourceLogicalSystem,
  SourceReferenceDocumentCntxt,
  SourceReferenceDocument,
  SourceReferenceDocumentItem,
  SourceReferenceDocSubitem,
  IsCommitment,
  _SemTagGL.SemanticTag AS SemanticTag,
  _AllCost.SemanticTagIsBudgetRelevant AS SemanticTagIsBudgetRelevant,
  _AllCost.SemanticTagIsBudgetRelevant AS ObjectIsBudgeted,
  _AllCost.ProjectIsBudgetRelevant AS ProjectIsBudgetRelevant
FROM P_ProjectsWithProjCat6 AS Project
INNER JOIN I_ActualPlanJournalEntryItem AS _ProjCstLineItm ON /* join condition not captured in parsed metadata */
INNER JOIN I_ControllingArea AS _ContArea 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_WBSElementBasicData AS _WBSElementBasicData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EnterpriseProject AS _ProjectSummary 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]
;