P_BudgetEntrAndChgDocBasic

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 P_BudgetEntrAndChgDocBasic.
-- 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: PFMBDGECDOCB

CREATE VIEW P_BudgetEntrAndChgDocBasic 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( hdr.docyear as bued_entr_docyear preserving type ) AS BudgetDocumentYear,
  cast( hdr.docnr as bued_entr_docnr preserving type ) AS BudgetEntryDocument,
  cast( itm.docln as bued_entr_docln preserving type ) AS BudgetEntryDocumentItem,
  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.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,
  hdr.doctype AS BudgetEntryDocumentType,
  hdr.docfam AS BudgetEntryDocumentFamily,
  hdr.techorg AS OriginalBudgetingApplication,
  hdr.crtdate AS CreationDate,
  hdr.chgdate AS LastChangeDate,
  hdr.docdate AS BudgetEntryDocumentDate,
  hdr.text50 AS BudgetEntryDocumentDescription,
  hdr.docstate AS BudgetEntryDocumentStatus,
  hdr.revstate AS BdgtEntryDocReversalStatus,
  hdr.reason_rev AS ReversalReason,
  hdr.rev_refnr AS ReversalRefBudgetEntryDocument,
  hdr.logsys AS LogicalSystem,
  hdr.cohort AS FiscalTreasuryLoanCohort,
  hdr.publaw AS PublicLaw,
  hdr.legis AS FiscalTreasuryLegislationType,
  hdr.transfer_agency AS FiscalTreasuryAgency,
  hdr.transfer_account AS FiscalTreasuryBudgetAccount,
  hdr.rcomp AS PartnerCompany,
  itm.distkey AS BudgetEntryDocDistributionKey,
  itm.flg_added AS BudgetEntryDocItemIsAdditional,
  hdr.docnr AS ReferenceDocument,
  cast( hdr.docyear as bued_entr_docyear preserving type ) AS ReferenceDocumentFiscalYear,
  chg.refdocln AS ReferenceDocumentItem,
  chg.awtyp AS ReferenceDocumentType,
  chg.aworg AS ReferenceDocumentContext
FROM fmbdp AS chg
INNER JOIN fmbh AS hdr ON /* join condition not captured in parsed metadata */
INNER JOIN fmbl AS itm ON /* join condition not captured in parsed metadata */
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]
;