I_BudgetEntryDocumentItem

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_BudgetEntryDocumentItem.
-- 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: IFMBUDOCITM

CREATE VIEW I_BudgetEntryDocumentItem AS
SELECT
  FinancialManagementArea,
  BudgetDocumentYear,
  BudgetEntryDocument,
  BudgetEntryDocumentItem,
  BudgetEntryDocItemIsAdditional,
  CommitmentItemCategory,
  FinMgmtAreaFiscalYear,
  BdgtCashEffectivityFiscalYear,
  BudgetedFund,
  BudgetedBudgetPeriod,
  BudgetedFundsCenter,
  BudgetedCommitmentItem,
  BudgetedFunctionalArea,
  BudgetedGrantID,
  BudgetedFundedProgram,
  BudgetedFundsMgmtCustomerField,
  BudgetCategory,
  _BdgtEntrItemSubdivision.FunctionalAreaSubdivisionID AS FunctionalAreaSubdivisionID,
  _BdgtEntrItemSubdivision.FunctionalArea1Subdivision AS FunctionalArea1Subdivision,
  _BdgtEntrItemSubdivision.FunctionalArea2Subdivision AS FunctionalArea2Subdivision,
  _BdgtEntrItemSubdivision.FunctionalArea3Subdivision AS FunctionalArea3Subdivision,
  BudgetValueType,
  InternalBudgetingProcess,
  BudgetType,
  BudgetEntryDocItemDescription,
  BudgetEntryDocDistributionKey,
  TransactionCurrency,
  cast ( BudgetAmountInTransactionCrcy as fmis_budget_amount_trans_curr ) AS BudgetAmountInTransactionCrcy,
  FinancialManagementAreaCrcy,
  cast ( BudgetAmountInFMACrcy as fmis_budget_amount_local_curr ) AS BudgetAmountInFMACrcy,
  _BudgetEntryDocument.BudgetVersion AS BudgetVersion,
  _BudgetEntryDocument.BudgetEntryDocumentType AS BudgetEntryDocumentType,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  _FundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  _FundsCenter.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  _CommitmentItem.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  _FunctionalArea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  CommitmentItemFiscalYear
FROM I_BudgetEntryDocumentItemBasic
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND BudgetedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetedBudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenterByYear AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FundsCenter.FinMgmtAreaFiscalYear AND BudgetedFundsCenter = _FundsCenter.FundsCenter  -- 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_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND BudgetedFundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_ControllingVersion AS _BudgetVersion ON BudgetVersion = _BudgetVersion.ControllingVersion  -- association [1..1]
LEFT OUTER JOIN I_BdgtEntrItemSubdivisionBasic AS _BdgtEntrItemSubdivision ON FinancialManagementArea = _BdgtEntrItemSubdivision.FinancialManagementArea AND BudgetDocumentYear = _BdgtEntrItemSubdivision.BudgetDocumentYear AND BudgetEntryDocument = _BdgtEntrItemSubdivision.BudgetEntryDocument AND BudgetEntryDocumentItem = _BdgtEntrItemSubdivision.BudgetEntryDocumentItem  -- association [0..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_FiscalYearForFinMgmtArea AS _FinMgmtFiscalYear ON FinancialManagementArea = _FinMgmtFiscalYear.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FinMgmtFiscalYear.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND BudgetedCommitmentItem = _CommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear  -- association [0..1]
;