I_FndsMgmtCmtmtActualCube

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_FndsMgmtCmtmtActualCube.
-- 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: IFMCOMACTANC

CREATE VIEW I_FndsMgmtCmtmtActualCube AS
SELECT
  cast( oi.FinancialManagementArea as fikrs preserving type ) AS FinancialManagementArea,
  cast( oi.FinMgmtAreaFiscalYear as gjahr preserving type ) AS FinMgmtAreaFiscalYear,
  cast( oi.PostedBudgetPeriod as fm_budget_period preserving type ) AS BudgetPeriod,
  cast( oi.PostedCommitmentItem as fm_fipex preserving type ) AS CommitmentItem,
  cast( oi.PostedFunctionalArea as fm_farea preserving type) AS FunctionalArea,
  cast( oi.PostedFund as fm_fund preserving type ) AS Fund,
  cast( oi.PostedFundedProgram as fm_measure preserving type ) AS FundedProgram,
  cast( oi.PostedFundsCenter as fistl preserving type ) AS FundsCenter,
  cast( oi.PostedGrantID as gm_grant_nbr preserving type ) AS GrantID,
  cast( oi.FinancialManagementAreaCrcy as fm_waers preserving type ) AS FinancialManagementAreaCrcy,
  cast( oi.TransactionCurrency as twaer preserving type ) AS TransactionCurrency,
  cast( oi.PostedFundsMgmtCustomerField as fm_userdim preserving type ) AS FundsManagementCustomerField,
  cast( oi.BusinessArea as gsber preserving type) AS BusinessArea,
  cast( oi.CompanyCode as bukrs preserving type ) AS CompanyCode,
  cast( oi.GLAccount as hkont preserving type ) AS GLAccount,
  oi.Ledger AS Ledger,
  oi.FundsMgmtValueType AS FundsMgmtValueType,
  oi.FundsMgmtAmountType AS FundsMgmtAmountType,
  oi.BusinessTransactionType AS BusinessTransactionType,
  oi.IsStatisticalItem AS IsStatisticalItem,
  cast( ' ' as lifnr ) AS Supplier,
  cast( ' ' as kunnr ) AS Customer,
  oi.FundsMgCarryForwardLevel AS FundsMgCarryForwardLevel,
  cast( ' ' as fmce_cvrgrp ) AS ControlObjectCoverGroup,
  oi.ReferenceDocument AS ReferenceDocument,
  oi.FundsMgmtRefDocumentCategory AS FundsMgmtRefDocumentCategory,
  oi.ReferenceDocumentContext AS ReferenceDocumentContext,
  cast( oi.FundsMgmtReferenceDocumentItem as cc_rfpos ) AS ReferenceDocumentItem,
  oi.RefDocAccountAssignment AS RefDocAccountAssignment,
  oi.FundsMgmtRefDocScheduleLine AS ReferenceDocumentScheduleLine,
  oi.RefDocPricingElementContent AS RefDocPricingElementContent,
  oi.ReferenceDocumentType AS ReferenceDocumentType,
  oi.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  oi.FundsMgmtSequenceNumber AS FundsMgmtSequenceNumber,
  oi.ProfitCenter AS ProfitCenter,
  cast( 0 - oi.PostedAmountInFMACrcy as fm_amount_fma_curr ) AS AmountInFMACrcy,
  cast( 0 - oi.PostedAmountInTransCrcy as fm_amount_trans_curr ) AS FndsMgmtAmountInTransCrcy,
  oi._FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  cast(' ' as fm_vogjahr ) AS FundsMgmtPaytDocFiscalYear,
  cast(' ' as fm_vobelnr) AS FundsMgmtPaytDocNumber,
  cast(' ' as fm_vobuzei) AS FundsMgmtPaytDocItem,
  cast(' ' as fm_kngjahr) AS FundsMgmtFinDocFiscalYear,
  cast(' ' as fm_knbelnr) AS FundsMgmtFinDocNumber,
  cast(' ' as fm_knbuzei) AS FundsMgmtFinDocItem,
  oi.FundsMgmtUpdateDate AS FundsMgmtUpdateDate,
  oi.FinMgmtAreaPeriod AS FinMgmtAreaPeriod,
  _FiscalYearForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  oi.ControllingArea AS ControllingArea,
  cast( '000000' as sales_order_item ) AS SalesOrderItem,
  co.Segment AS Segment
FROM I_FundsMgmtCommitmentEntryItem AS oi
-- UNION ALL with additional select branch(es): I_FundsManagementDocumentItem, I_FundsMgmtCtrlgDocumentItem
;