I_FundsMgmtCtrlgDocItmCube

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_FundsMgmtCtrlgDocItmCube.
-- 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: IFMCODOCIANC

CREATE VIEW I_FundsMgmtCtrlgDocItmCube AS
SELECT
  co.FinancialManagementArea AS FinancialManagementArea,
  FundsMgmtCtrlgDocument,
  co.FundsMgmtCtrlgDocumentItem AS FundsMgmtCtrlgDocumentItem,
  co.FundsMgmtLongSequenceNumber AS FundsMgmtLongSequenceNumber,
  cast( co.PostedBudgetPeriod as fm_budget_period preserving type ) AS BudgetPeriod,
  cast( co.PostedCommitmentItem as fm_fipex preserving type ) AS CommitmentItem,
  cast( co.PostedFunctionalArea as fm_farea preserving type ) AS FunctionalArea,
  cast( co.PostedFund as fm_fund preserving type ) AS Fund,
  cast( co.PostedFundedProgram as fm_measure preserving type ) AS FundedProgram,
  cast( co.PostedFundsCenter as fistl preserving type ) AS FundsCenter,
  cast( co.PostedGrantID as gm_grant_nbr preserving type ) AS GrantID,
  cast( co.PostedFundsMgmtCustomerField as fm_userdim preserving type ) AS FundsManagementCustomerField,
  co.CompanyCode AS CompanyCode,
  co.BusinessArea AS BusinessArea,
  co.GLAccount AS GLAccount,
  co.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  co.FinMgmtAreaPeriod AS FinMgmtAreaPeriod,
  co._FinMgmtArea.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  co.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  cast( 0 - co.PostedAmountInFMACrcy as fm_amount_co_fma_curr ) AS PostedAmountInFMACrcy,
  co.TransactionCurrency AS TransactionCurrency,
  cast( 0 - co.PostedAmountInTransCrcy as fm_amount_oi_trans_curr ) AS PostedAmountInTransCrcy,
  co.BusinessTransactionType AS BusinessTransactionType,
  cast( co.CashEffectivityFiscalYear as fmis_gnjhr ) AS CashEffectivityFiscalYear,
  co.FundsMgCarryForwardLevel AS FundsMgCarryForwardLevel,
  co.FundsMgmtAmountType AS FundsMgmtAmountType,
  co.FundsMgmtValueType AS FundsMgmtValueType,
  co.IsStatisticalItem AS IsStatisticalItem,
  co.FundsManagementStatisticalType AS FundsManagementStatisticalType,
  co.Ledger AS Ledger,
  _CommitmentItem.CommitmentItemCategory AS CommitmentItemCategory,
  cast( co.CommitmentItemFiscalYear as abap.numc( 4 ) ) AS CommitmentItemFiscalYear,
  co.ReferenceDocumentContext AS ReferenceDocumentContext,
  co.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  co.ReferenceDocumentType AS ReferenceDocumentType,
  cast( co.ReferenceDocument as awref preserving type ) AS ReferenceDocument,
  cast( co.ReferenceDocumentFiscalYear as refgjahr preserving type ) AS ReferenceDocumentFiscalYear,
  cast( concat( '000', co.ReferenceDocumentItem ) as fins_awitem ) AS ReferenceDocumentItem,
  _fmpaycom.FndsMgmtPaytCmtmtBdgtCat AS FndsMgmtPaytCmtmtBdgtCat,
  co.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  co.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  co.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  co.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  co.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  co.FundAuthznGrp AS FundAuthznGrp,
  co.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  co.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  co.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  co.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  co.GrantAuthznGrp AS GrantAuthznGrp,
  co.GrantLifecycleStatus AS GrantLifecycleStatus,
  co.ReferenceDocument AS ControllingDocument,
  co.ProfitCenter AS ProfitCenter,
  co.ControllingArea AS ControllingArea,
  co.Segment AS Segment,
  co.PostedFundsCenter AS FndsMgmtRptgFndsCtrForHier,
  co.PostedFund AS FndsMgmtRptgFundForHierarchy,
  co.PostedBudgetPeriod AS FndsMgmtRptgBdgtPerdForHier,
  co.PostedCommitmentItem AS FndsMgmtRptgCmtmtItemForHier,
  co.PostedFundedProgram AS FndsMgmtRptgFnddPgmForHier,
  co.PostedFunctionalArea AS FndsMgmtRptgFctArForHierarchy,
  co.PostedGrantID AS FndsMgmtRptgGrantIDForHier,
  co.Segment AS FndsMgmtRptgSegmentForHier,
  co.ProfitCenter AS FndsMgmtRptgPrftCtrForHier,
  _FundsMgmtCtrlgDocument.AccountingDocument AS AccountingDocument,
  _FundsMgmtCtrlgDocument.FiscalYear AS FiscalYear,
  co._LogicalSystem AS _LogicalSystem,
  co._ReferenceDocumentType AS _ReferenceDocumentType,
  co._TransactionCurrency AS _TransactionCurrency,
  co._FinMgmtArea AS _FinMgmtArea
FROM I_FundsMgmtCtrlgDocumentItem AS co
INNER JOIN I_FundsMgmtPaytCmtmtBdgtCat AS _fmpaycom ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Fund AS _Fund ON FinancialManagementArea = _Fund.FinancialManagementArea AND Fund = _Fund.Fund  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem ON FinancialManagementArea = _CommitmentItem.FinancialManagementArea AND CommitmentItem = _CommitmentItem.CommitmentItem AND ( FinMgmtAreaFiscalYear = _CommitmentItem.FinMgmtAreaFiscalYear OR _CommitmentItem.FinMgmtAreaFiscalYear = '0000' )  -- association [0..*]
LEFT OUTER JOIN I_CommitmentItem AS _CommitmentItem_2 ON FinancialManagementArea = _CommitmentItem_2.FinancialManagementArea AND CommitmentItem = _CommitmentItem_2.CommitmentItem AND CommitmentItemFiscalYear = _CommitmentItem_2.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FundedProgram ON FinancialManagementArea = _FundedProgram.FinancialManagementArea AND FundedProgram = _FundedProgram.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- association [0..1]
LEFT OUTER JOIN I_SystemStatus AS _GrantLifecycleStatus ON GrantLifecycleStatus = _GrantLifecycleStatus.SystemStatus  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtLedger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FinMgmtFiscalYear ON FinancialManagementArea = _FinMgmtFiscalYear.FinancialManagementArea AND CommitmentItemFiscalYear = _FinMgmtFiscalYear.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FndsMgmtRptgFndsCtrForHier ON FinancialManagementArea = _FndsMgmtRptgFndsCtrForHier.FinancialManagementArea AND FndsMgmtRptgFndsCtrForHier = _FndsMgmtRptgFndsCtrForHier.FundsCenter  -- association [0..*]
LEFT OUTER JOIN I_Fund AS _FndsMgmtRptgFundForHierarchy ON FinancialManagementArea = _FndsMgmtRptgFundForHierarchy.FinancialManagementArea AND FndsMgmtRptgFundForHierarchy = _FndsMgmtRptgFundForHierarchy.Fund  -- association [0..1]
LEFT OUTER JOIN I_CommitmentItem AS _FndsMgmtRptgCmtmtItemForHier ON FinancialManagementArea = _FndsMgmtRptgCmtmtItemForHier.FinancialManagementArea AND FndsMgmtRptgCmtmtItemForHier = _FndsMgmtRptgCmtmtItemForHier.CommitmentItem AND CommitmentItemFiscalYear = _FndsMgmtRptgCmtmtItemForHier.FinMgmtAreaFiscalYear  -- association [0..1]
LEFT OUTER JOIN I_BudgetPeriod AS _FndsMgmtRptgBdgtPerdForHier ON FndsMgmtRptgBdgtPerdForHier = _FndsMgmtRptgBdgtPerdForHier.BudgetPeriod  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtFunctionalArea AS _FndsMgmtRptgFctArForHierarchy ON FndsMgmtRptgFctArForHierarchy = _FndsMgmtRptgFctArForHierarchy.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FundedProgram AS _FndsMgmtRptgFnddPgmForHier ON FinancialManagementArea = _FndsMgmtRptgFnddPgmForHier.FinancialManagementArea AND FndsMgmtRptgFnddPgmForHier = _FndsMgmtRptgFnddPgmForHier.FundedProgram  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _FndsMgmtRptgGrantIDForHier ON FndsMgmtRptgGrantIDForHier = _FndsMgmtRptgGrantIDForHier.GrantID  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _FndsMgmtRptgSegmentForHier ON FndsMgmtRptgSegmentForHier = _FndsMgmtRptgSegmentForHier.Segment  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _FndsMgmtRptgPrftCtrForHier ON ControllingArea = _FndsMgmtRptgPrftCtrForHier.ControllingArea AND FndsMgmtRptgPrftCtrForHier = _FndsMgmtRptgPrftCtrForHier.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_FundsMgmtCtrlgDocument AS _FundsMgmtCtrlgDocument ON CompanyCode = _FundsMgmtCtrlgDocument.CompanyCode AND FundsMgmtCtrlgDocument = _FundsMgmtCtrlgDocument.FundsMgmtCtrlgDocument AND FinMgmtAreaFiscalYear = _FundsMgmtCtrlgDocument.FiscalYear AND FinancialManagementArea = _FundsMgmtCtrlgDocument.FinancialManagementArea  -- association [1..1]
;