I_BudgetEntryDocumentItemBasic

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_BudgetEntryDocumentItemBasic.
-- 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: IFMBUDOCITMBASIC

CREATE VIEW I_BudgetEntryDocumentItemBasic AS
SELECT
  fm_area AS FinancialManagementArea,
  docyear AS BudgetDocumentYear,
  docnr AS BudgetEntryDocument,
  docln AS BudgetEntryDocumentItem,
  flg_added AS BudgetEntryDocItemIsAdditional,
  ctem_category AS CommitmentItemCategory,
  fiscyear AS FinMgmtAreaFiscalYear,
  ceffyear AS BdgtCashEffectivityFiscalYear,
  fund AS BudgetedFund,
  budget_pd AS BudgetedBudgetPeriod,
  fundsctr AS BudgetedFundsCenter,
  cmmtitem AS BudgetedCommitmentItem,
  funcarea AS BudgetedFunctionalArea,
  grant_nbr AS BudgetedGrantID,
  measure AS BudgetedFundedProgram,
  userdim AS BudgetedFundsMgmtCustomerField,
  budcat AS BudgetCategory,
  valtype AS BudgetValueType,
  process AS InternalBudgetingProcess,
  budtype AS BudgetType,
  text50 AS BudgetEntryDocItemDescription,
  distkey AS BudgetEntryDocDistributionKey,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  tcurr AS TransactionCurrency,
  sum(BudgetAmountInTransactionCrcy) AS BudgetAmountInTransactionCrcy,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  sum(BudgetAmountInFMACrcy) AS BudgetAmountInFMACrcy
FROM P_FmblNoPeriod
LEFT OUTER JOIN I_BudgetEntryDocument AS _BudgetEntryDocument ON FinancialManagementArea = _BudgetEntryDocument.FinancialManagementArea AND BudgetDocumentYear = _BudgetEntryDocument.BudgetDocumentYear AND BudgetEntryDocument = _BudgetEntryDocument.BudgetEntryDocument  -- association [1..1]
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_BudgetCategory AS _BudgetCategory ON FinancialManagementArea = _BudgetCategory.FinancialManagementArea AND BudgetCategory = _BudgetCategory.BudgetCategory  -- association [1..1]
LEFT OUTER JOIN I_BudgetValueType AS _BudgetValueType ON BudgetValueType = _BudgetValueType.BudgetValueType  -- association [1..1]
LEFT OUTER JOIN I_InternalBudgetingProcess AS _BudgetingProcess ON InternalBudgetingProcess = _BudgetingProcess.InternalBudgetingProcess  -- 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_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN E_BudgetEntryItem AS _ExtensionItem ON BudgetEntryDocument = _ExtensionItem.BudgetEntryDocument AND FinancialManagementArea = _ExtensionItem.FinancialManagementArea AND BudgetDocumentYear = _ExtensionItem.BudgetDocumentYear AND BudgetEntryDocumentItem = _ExtensionItem.BudgetEntryDocumentItem  -- association [1..1]
;