I_FundsMgmtDocItmCube

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_FundsMgmtDocItmCube.
-- 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: IFMACTDOCIANC

CREATE VIEW I_FundsMgmtDocItmCube AS
SELECT
  Act.FinancialManagementArea AS FinancialManagementArea,
  Act.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  Act.FundsManagementDocument AS FundsManagementDocument,
  Act.FundsManagementDocumentItem AS FundsManagementDocumentItem,
  Act.FundsMgmtAmountType AS FundsMgmtAmountType,
  Act.Ledger AS Ledger,
  Act.FundsMgmtSequenceNumber AS FundsMgmtSequenceNumber,
  cast( Act.PostedBudgetPeriod as fm_budget_period preserving type ) AS BudgetPeriod,
  cast( Act.PostedCommitmentItem as fm_fipex preserving type ) AS CommitmentItem,
  cast( Act.PostedFunctionalArea as fm_farea preserving type ) AS FunctionalArea,
  cast( Act.PostedFund as fm_fund preserving type ) AS Fund,
  cast( Act.PostedFundedProgram as fm_measure preserving type ) AS FundedProgram,
  cast( Act.PostedFundsCenter as fistl preserving type ) AS FundsCenter,
  cast( Act.PostedGrantID as gm_grant_nbr preserving type ) AS GrantID,
  cast( Act.PostedFundsMgmtCustomerField as fm_userdim preserving type ) AS FundsManagementCustomerField,
  Act.BusinessArea AS BusinessArea,
  Act.CompanyCode AS CompanyCode,
  Act.GLAccount AS GLAccount,
  Act.FinMgmtAreaPeriod AS FinMgmtAreaPeriod,
  Act._FinMgmtArea.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  Act.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  cast( 0 - Act.PostedAmountInFMACrcy as fm_amount_act_fma_curr ) AS PostedAmountInFMACrcy,
  Act.TransactionCurrency AS TransactionCurrency,
  cast( 0 - Act.PostedAmountInTransCrcy as fm_amount_act_trans_curr ) AS PostedAmountInTransCrcy,
  Act.BusinessTransactionType AS BusinessTransactionType,
  cast( Act.CashEffectivityFiscalYear as fmis_gnjhr ) AS CashEffectivityFiscalYear,
  Act.FundsMgCarryForwardLevel AS FundsMgCarryForwardLevel,
  Act.FundsMgmtTransactionNumber AS FundsMgmtTransactionNumber,
  Act.FundsMgmtValueType AS FundsMgmtValueType,
  Act.IsStatisticalItem AS IsStatisticalItem,
  Act.FundsManagementStatisticalType AS FundsManagementStatisticalType,
  Act._Header.Supplier AS Supplier,
  Act._Header.Customer AS Customer,
  Act._Header.AccountingDocumentType AS AccountingDocumentType,
  Act._Header.PostingDate AS PostingDate,
  Act.FundsMgmtUpdateDate AS FundsMgmtUpdateDate,
  Act.FundsMgmtObjectNumber AS FundsMgmtObjectNumber,
  Act.FundsMgmtTradingPartnerCoId AS FundsMgmtTradingPartnerCoId,
  Act.ProfitCenter AS ProfitCenter,
  Act.ControllingArea AS ControllingArea,
  Act.Segment AS Segment,
  Act.FundsMgmtFinDocFiscalYear AS FundsMgmtFinDocFiscalYear,
  Act.FundsMgmtFinDocNumber AS FundsMgmtFinDocNumber,
  Act.FundsMgmtFinDocFiscalYear AS FiscalYear,
  Act.FundsMgmtFinDocNumber AS AccountingDocument,
  cast( Act.FundsMgmtFinDocItem as fm_fin_doc_item preserving type) AS FundsMgmtFinDocItem,
  cast( Act.FundsMgmtPaytDocFiscalYear as fm_payt_doc_fiscyear preserving type ) AS FundsMgmtPaytDocFiscalYear,
  Act.FundsMgmtPaytDocNumber AS FundsMgmtPaytDocNumber,
  Act.FundsMgmtPaytDocItem AS FundsMgmtPaytDocItem,
  Act.FundsMgmtPredecessorDocCat AS FundsMgmtPredecessorDocCat,
  Act.FundsMgmtPredecessorDocNumber AS FundsMgmtPredecessorDocNumber,
  Act.FundsMgmtPredecessorDocOrg AS FundsMgmtPredecessorDocOrg,
  Act.FundsMgmtPredecessorDocItem AS FundsMgmtPredecessorDocItem,
  Act.FundsMgmtPredecessorAcctAssgmt AS FundsMgmtPredecessorAcctAssgmt,
  cast( Act.FundsMgmtPredecessorRefTrans as fm_predecessor_reftrans preserving type ) AS FundsMgmtPredecessorRefTrans,
  cast( Act.FundsMgmtPredecessorLgclSyst as fm_predecessor_lgclsyst preserving type ) AS FundsMgmtPredecessorLgclSyst,
  cast( Act.FundsMgmtFinDocNumber as awref preserving type ) AS ReferenceDocument,
  cast( Act.FundsMgmtFinDocFiscalYear as refgjahr preserving type ) AS ReferenceDocumentFiscalYear,
  cast( 'BKPF ' as awtyp preserving type ) AS ReferenceDocumentType,
  cast( concat( Act._Header.ReferenceDocumentCompanyCode, Act._Header.ReferenceDocumentFiscalYear ) as aworg ) AS ReferenceDocumentContext,
  Act._Header.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  _FiscalCalDateForFinMgmtArea.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  Act.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  Act.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  Act.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  Act.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  Act.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  Act.FundAuthznGrp AS FundAuthznGrp,
  Act.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  Act.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  Act.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  Act.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  Act.GrantAuthznGrp AS GrantAuthznGrp,
  Act.GrantLifecycleStatus AS GrantLifecycleStatus,
  Act.PostedFundsCenter AS FndsMgmtRptgFndsCtrForHier,
  Act.PostedFund AS FndsMgmtRptgFundForHierarchy,
  Act.PostedBudgetPeriod AS FndsMgmtRptgBdgtPerdForHier,
  Act.PostedCommitmentItem AS FndsMgmtRptgCmtmtItemForHier,
  Act.PostedFundedProgram AS FndsMgmtRptgFnddPgmForHier,
  Act.PostedFunctionalArea AS FndsMgmtRptgFctArForHierarchy,
  Act.PostedGrantID AS FndsMgmtRptgGrantIDForHier,
  Act.Segment AS FndsMgmtRptgSegmentForHier,
  Act.ProfitCenter AS FndsMgmtRptgPrftCtrForHier,
  Act._FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea,
  Act._Header AS _Header,
  Act._FinMgmtArea AS _FinMgmtArea
FROM I_FundsManagementDocumentItem AS Act
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FinMgmtFiscalYear ON FinancialManagementArea = _FinMgmtFiscalYear.FinancialManagementArea AND CommitmentItemFiscalYear = _FinMgmtFiscalYear.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_FiscalCalDateForFinMgmtArea AS _FiscalCalDateForFinMgmtArea ON FinancialManagementArea = _FiscalCalDateForFinMgmtArea.FinancialManagementArea AND FundsMgmtUpdateDate = _FiscalCalDateForFinMgmtArea.CalendarDate  -- association [0..1]
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 CommitmentItemFiscalYear = _CommitmentItem.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_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON BusinessTransactionType = _BusinessTransactionType.BusinessTransactionType  -- association [1..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _ReferenceDocumentType ON ReferenceDocumentType = _ReferenceDocumentType.ReferenceDocumentType  -- association [1..1]
LEFT OUTER JOIN I_ReferenceDocumentType AS _PredecessorRefTrans ON FundsMgmtPredecessorRefTrans = _PredecessorRefTrans.ReferenceDocumentType  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocumentType AS _AccountingDocumentType ON accountingdocumenttype = _AccountingDocumentType.AccountingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FinMgmtAreaFiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_JournalEntry AS _JournalEntry ON CompanyCode = _JournalEntry.CompanyCode AND FundsMgmtPaytDocFiscalYear = _JournalEntry.FiscalYear AND FundsMgmtPaytDocNumber = _JournalEntry.AccountingDocument  -- 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_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..*]
;