I_BdgtEntryChgDocAddressBasic

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_BdgtEntryChgDocAddressBasic.
-- 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: IFMBDGECDOCJ

CREATE VIEW I_BdgtEntryChgDocAddressBasic 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,
  chg.budtype_9 AS BudgetType,
  cast( chg.rvers as buku_version preserving type ) AS BudgetVersion,
  cast( chg.rtcur as fis_rwcur preserving type ) AS TransactionCurrency,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  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,
  cast( chg.cpudt as buku_chg_cpudt preserving type ) AS BudgetChangeDocCreationDate,
  cast( chg.sgtxt as sgtxt preserving type ) AS BudgetEntryDocItemDescription,
  chg.refdocln AS ReferenceDocumentItem,
  chg.awtyp AS ReferenceDocumentType,
  chg.aworg AS ReferenceDocumentContext
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]
;