I_BudgetEntryItemSearch

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 I_BudgetEntryItemSearch.
-- 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: IFMBDGECDOCS

CREATE VIEW I_BudgetEntryItemSearch AS
SELECT
  BudgetChangeDocument,
  FinMgmtAreaFiscalYear,
  FinancialManagementArea,
  BudgetCategory,
  BudgetChangeDocumentItem,
  BudgetDocumentYear,
  BudgetEntryDocument,
  BudgetEntryDocumentItem,
  BudgetedFund,
  BudgetedFundsCenter,
  BudgetedCommitmentItem,
  BudgetedFunctionalArea,
  BudgetedGrantID,
  BudgetedFundedProgram,
  BudgetedBudgetPeriod,
  BudgetedFundsMgmtCustomerField,
  TransactionCurrency,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  BudgetAmountInTransactionCrcy,
  BudgetAmountInFMACrcy,
  CommitmentItemCategory,
  BdgtCashEffectivityFiscalYear,
  BudgetValueType,
  BudgetWorkFlowStatus,
  InternalBudgetingProcess,
  BudgetType,
  BudgetVersion,
  BudgetChangeDocCreationDate,
  BudgetEntryDocumentType,
  BudgetEntryDocumentFamily,
  OriginalBudgetingApplication,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  LastChangeDate,
  BudgetEntryDocumentDate,
  BudgetEntryDocumentDescription,
  BudgetEntryDocumentStatus,
  BdgtEntryDocReversalStatus,
  ReversalReason,
  ReversalRefBudgetEntryDocument,
  LogicalSystem,
  FiscalTreasuryLoanCohort,
  PublicLaw,
  FiscalTreasuryLegislationType,
  FiscalTreasuryAgency,
  FiscalTreasuryBudgetAccount,
  PartnerCompany,
  BudgetEntryDocDistributionKey,
  BudgetEntryDocItemIsAdditional,
  BudgetEntryDocItemDescription,
  ReferenceDocument,
  ReferenceDocumentFiscalYear,
  ReferenceDocumentItem,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearEndDate AS FinMgmtAreaFiscalYearEndDate,
  _CommitmentItem.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _FunctionalArea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  _FundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  _BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  BudgetCategoryName,
  _DocumentStatus._Text[1:Language=$session.system_language].BudgetEntryDocumentStatusName AS BudgetEntryDocumentStatusName,
  _BudgetingProcessLine._Text[1:Language=$session.system_language].InternalBudgetingProcessName AS InternalBudgetingProcessName,
  _BudgetType._Text[1:Language=$session.system_language].BudgetTypeName1 AS BudgetTypeName1,
  _BudgetValueType._Text[1:Language=$session.system_language].BudgetValueTypeName AS BudgetValueTypeName,
  FunctionalAreaSubdivisionID,
  FunctionalArea1Subdivision,
  FunctionalArea2Subdivision,
  FunctionalArea3Subdivision
FROM I_BudgetEntryItemSearchBasic AS chg
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND BudgetedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND BudgetedFundsCenter = _FundsCenter.FundsCenter AND FinMgmtAreaFiscalYearEndDate = _FundsCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND BudgetedFundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND BudgetedCommitmentItem = _CommitmentItem.CommitmentItem AND ( FinMgmtAreaFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear OR _CommitmentItem.FinMgmtAreaFiscalYear = '0000' )  -- association [0..1]
LEFT OUTER JOIN I_FundToBudgetPeriod AS _BudgetPeriod ON FinancialManagementArea = _BudgetPeriod.FinancialManagementArea AND BudgetedFund = _BudgetPeriod.Fund AND BudgetedBudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON BudgetedFunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON BudgetedGrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_BudgetingProcessItem AS _BudgetingProcessLine ON InternalBudgetingProcess = _BudgetingProcessLine.BudgetingProcessAtLineLevel  -- association [1..1]
LEFT OUTER JOIN I_BudgetType AS _BudgetType ON FinancialManagementArea = _BudgetType.FinancialManagementArea AND BudgetValueType = _BudgetType.BudgetValueType AND BudgetType = _BudgetType.BudgetType  -- association [0..1]
LEFT OUTER JOIN I_BudgetValueType AS _BudgetValueType ON BudgetValueType = _BudgetValueType.BudgetValueType  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_FuncAreaSubdivisionBasic AS _FuncAreaSubdivisionBasic ON FunctionalAreaSubdivisionID = _FuncAreaSubdivisionBasic.FunctionalAreaSubdivisionID  -- association [0..1]
LEFT OUTER JOIN I_FuncArea1Subdivision AS _FuncArea1Subdivision ON FunctionalAreaSubdivisionID = _FuncArea1Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea1Subdivision = _FuncArea1Subdivision.FunctionalArea1Subdivision  -- association [0..1]
LEFT OUTER JOIN I_FuncArea2Subdivision AS _FuncArea2Subdivision ON FunctionalAreaSubdivisionID = _FuncArea2Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea2Subdivision = _FuncArea2Subdivision.FunctionalArea2Subdivision  -- association [0..1]
LEFT OUTER JOIN I_FuncArea3Subdivision AS _FuncArea3Subdivision ON FunctionalAreaSubdivisionID = _FuncArea3Subdivision.FunctionalAreaSubdivisionID AND FunctionalArea3Subdivision = _FuncArea3Subdivision.FunctionalArea3Subdivision  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItemCategory AS _CommitmentItemCategory ON CommitmentItemCategory = _CommitmentItemCategory.CommitmentItemCategory  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_BudgetEntryDocumentStatus AS _DocumentStatus ON BudgetEntryDocumentStatus = _DocumentStatus.BudgetEntryDocumentStatus  -- association [0..1]
;