I_MyFMOvrlBdgtDrillPost

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_MyFMOvrlBdgtDrillPost.
-- 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: IMYFMOVLBGTDDPST

CREATE VIEW I_MyFMOvrlBdgtDrillPost AS
SELECT
  rfikrs AS FinancialManagementArea,
  cast(rldnr as buavc_aldnr preserving type) AS AvailabilityControlLedger,
  cast(ryear as fmis_fma_fiscal_year preserving type) AS FinMgmtAreaFiscalYear,
  cast(ceffyear_9 as fm_ceffyear_bcs preserving type) AS BdgtCashEffectivityFiscalYear,
  cast(rcvrgrp_9 as fmis_ctrlobj_cover_group preserving type) AS ControlObjectCoverGroup,
  cast(rgrant_nbr as fmis_ctrlobj_grant_nbr preserving type) AS ControlObjectGrantID,
  cast(rfund as fmis_ctrlobj_fund preserving type) AS ControlObjectFund,
  cast(budget_pd_9 as fmis_ctrlobj_budget_period preserving type) AS ControlObjectBudgetPeriod,
  cast(rfundsctr as fmis_ctrlobj_funds_center preserving type) AS ControlObjectFundsCenter,
  cast(rcmmtitem as fmis_ctrlobj_commitment_item preserving type) AS ControlObjectCommitmentItem,
  cast(rfuncarea as fmis_ctrlobj_functional_area preserving type) AS ControlObjectFunctionalArea,
  cast(rmeasure as fmis_ctrlobj_funded_program preserving type) AS ControlObjectFundedProgram,
  cast(ruserdim as fmis_ctrlobj_userdim preserving type) AS CtrlObjFundsMgmtCustomerField,
  cast(rtcur as fm_waers preserving type) AS FinancialManagementAreaCrcy,
  FundsMgmtJournalEntry,
  FundsMgmtJournalEntryItem,
  Ledger,
  FundsMgmtAmountType,
  FundsMgmtRefDocumentCategory,
  ReferenceDocumentType,
  RefDocAccountAssignment,
  ReferenceDocumentScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentLogicalSystem,
  ReferenceDocumentContext,
  FundsMgmtLongSequenceNumber,
  PostedGrantID,
  PostedFund,
  PostedBudgetPeriod,
  PostedFundsCenter,
  PostedCommitmentItem,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedFundsMgmtCustomerField,
  FinMgmtAreaPeriod,
  CompanyCode,
  FundsMgmtValueType,
  CashEffectivityFiscalYear,
  BusinessTransactionType,
  FundsMgCarryForwardLevel,
  GLAccount,
  BusinessArea,
  ProfitCenter,
  ControllingArea,
  Segment,
  IsStatisticalItem,
  PostedAmountInFMACrcy,
  NumberOfDocumentItems,
  ValidityEndDate,
  FundsCenterKeyDate,
  CommitmentItemFiscalYear
FROM P_MyFMOvrlBdgtDrillPost
LEFT OUTER JOIN I_Grant AS _ControlObjectGrantID ON ControlObjectGrantID = _ControlObjectGrantID.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _ControlObjectFund ON FinancialManagementArea = _ControlObjectFund.FinancialManagementArea AND ControlObjectFund = _ControlObjectFund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _ControlObjectBudgetPeriod ON ControlObjectBudgetPeriod = _ControlObjectBudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _ControlObjectFundsCenter ON FinancialManagementArea = _ControlObjectFundsCenter.FinancialManagementArea AND ControlObjectFundsCenter = _ControlObjectFundsCenter.FundsCenter AND ValidityEndDate = _ControlObjectFundsCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _ControlObjectCommitmentItem ON FinancialManagementArea = _ControlObjectCommitmentItem.FinancialManagementArea AND ControlObjectCommitmentItem = _ControlObjectCommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _ControlObjectCommitmentItem.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _ControlObjectFunctionalArea ON ControlObjectFunctionalArea = _ControlObjectFunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _ControlObjectFundedProgram ON FinancialManagementArea = _ControlObjectFundedProgram.FinancialManagementArea AND ControlObjectFundedProgram = _ControlObjectFundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON PostedGrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND PostedFund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON PostedBudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND PostedFundsCenter = _FundsCenter.FundsCenter AND FundsCenterKeyDate = _FundsCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND PostedCommitmentItem = _CommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON PostedFunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND PostedFundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
;