I_BudgetChangeDocumentBasic

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_BudgetChangeDocumentBasic.
-- 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: IFMBDGDOCQ

CREATE VIEW I_BudgetChangeDocumentBasic AS
SELECT
  cast( chg.docnr as buku_chg_docnr preserving type ) AS BudgetChangeDocument,
  chg.ryear AS FinMgmtAreaFiscalYear,
  chg.rfikrs AS FinancialManagementArea,
  cast( chg.rldnr as buku_budcat preserving type ) AS BudgetCategory,
  cast( chg.docln as buku_chg_docln preserving type ) AS BudgetChangeDocumentItem,
  cast( chg.rfund as fmis_budgeted_fund preserving type ) AS BudgetedFund,
  cast( chg.rfundsctr as fmis_budgeted_funds_center preserving type ) AS BudgetedFundsCenter,
  cast( chg.rcmmtitem as fmis_budgeted_cmtmt_item preserving type ) AS BudgetedCommitmentItem,
  cast( chg.rfuncarea as fmis_budgeted_functional_area preserving type ) AS BudgetedFunctionalArea,
  cast( chg.rgrant_nbr as fmis_budgeted_grant_nbr preserving type ) AS BudgetedGrantID,
  cast( chg.rmeasure as fmis_budgeted_funded_program preserving type ) AS BudgetedFundedProgram,
  cast( chg.budget_pd_9 as fmis_budgeted_budget_period preserving type ) AS BudgetedBudgetPeriod,
  cast( chg.ruserdim as fmis_budgeted_userdim preserving type ) AS BudgetedFundsMgmtCustomerField,
  cast( chg.rtcur as fis_rwcur preserving type ) AS TransactionCurrency,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  (chg.tslvt + chg.tsl01 + chg.tsl02 + chg.tsl03 + chg.tsl04 + chg.tsl05 + chg.tsl06 + chg.tsl07 + chg.tsl08 + chg.tsl09 + chg.tsl10 + chg.tsl11 + chg.tsl12 + chg.tsl13 + chg.tsl14 + chg.tsl15 + chg.tsl16) as BudgetAmountInTransactionCrcy AS tsl16asBudgetAmountInTransactionCrcy,
  (chg.hslvt + chg.hsl01 + chg.hsl02 + chg.hsl03 + chg.hsl04 + chg.hsl05 + chg.hsl06 + chg.hsl07 + chg.hsl08 + chg.hsl09 + chg.hsl10 + chg.hsl11 + chg.hsl12 + chg.hsl13 + chg.hsl14 + chg.hsl15 + chg.hsl16) as BudgetAmountInFMACrcy AS hsl16asBudgetAmountInFMACrcy,
  chg.hsl01 AS Period01BudgetAmountInFMACrcy,
  chg.hsl02 AS Period02BudgetAmountInFMACrcy,
  chg.hsl03 AS Period03BudgetAmountInFMACrcy,
  chg.hsl04 AS Period04BudgetAmountInFMACrcy,
  chg.hsl05 AS Period05BudgetAmountInFMACrcy,
  chg.hsl06 AS Period06BudgetAmountInFMACrcy,
  chg.hsl07 AS Period07BudgetAmountInFMACrcy,
  chg.hsl08 AS Period08BudgetAmountInFMACrcy,
  chg.hsl09 AS Period09BudgetAmountInFMACrcy,
  chg.hsl10 AS Period10BudgetAmountInFMACrcy,
  chg.hsl11 AS Period11BudgetAmountInFMACrcy,
  chg.hsl12 AS Period12BudgetAmountInFMACrcy,
  chg.hsl13 AS Period13BudgetAmountInFMACrcy,
  chg.hsl14 AS Period14BudgetAmountInFMACrcy,
  chg.hsl15 AS Period15BudgetAmountInFMACrcy,
  chg.hsl16 AS Period16BudgetAmountInFMACrcy,
  chg.tsl01 AS Perd01BdgtAmtInTransacCrcy,
  chg.tsl02 AS Perd02BdgtAmtInTransacCrcy,
  chg.tsl03 AS Perd03BdgtAmtInTransacCrcy,
  chg.tsl04 AS Perd04BdgtAmtInTransacCrcy,
  chg.tsl05 AS Perd05BdgtAmtInTransacCrcy,
  chg.tsl06 AS Perd06BdgtAmtInTransacCrcy,
  chg.tsl07 AS Perd07BdgtAmtInTransacCrcy,
  chg.tsl08 AS Perd08BdgtAmtInTransacCrcy,
  chg.tsl09 AS Perd09BdgtAmtInTransacCrcy,
  chg.tsl10 AS Perd10BdgtAmtInTransacCrcy,
  chg.tsl11 AS Perd11BdgtAmtInTransacCrcy,
  chg.tsl12 AS Perd12BdgtAmtInTransacCrcy,
  chg.tsl13 AS Perd13BdgtAmtInTransacCrcy,
  chg.tsl14 AS Perd14BdgtAmtInTransacCrcy,
  chg.tsl15 AS Perd15BdgtAmtInTransacCrcy,
  chg.tsl16 AS Perd16BdgtAmtInTransacCrcy,
  chg.ctem_category_9 AS CommitmentItemCategory,
  cast( chg.ceffyear_9 as fm_ceffyear_bcs preserving type ) AS BdgtCashEffectivityFiscalYear,
  chg.valtype_9 AS BudgetValueType,
  chg.wfstate_9 AS BudgetWorkFlowStatus,
  chg.process_9 AS InternalBudgetingProcess,
  chg.budtype_9 AS BudgetType,
  cast( chg.rvers as buku_version preserving type ) AS BudgetVersion,
  cast( chg.cpudt as buku_chg_cpudt preserving type ) AS BudgetChangeDocCreationDate,
  chg.refdocnr AS ReferenceDocument,
  cast( chg.refryear as lfbja preserving type ) AS ReferenceDocumentFiscalYear,
  chg.refdocln AS ReferenceDocumentItem,
  chg.awtyp AS ReferenceDocumentType,
  chg.aworg AS ReferenceDocumentContext,
  chg.logsys AS ReferenceDocumentLogicalSystem,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear
FROM fmbdp 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_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON FinancialManagementAreaCrcy = _Currency.Currency  -- association [0..1]
;