C_CommitmentActualsAnalysis

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 C_CommitmentActualsAnalysis.
-- 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: CFMCOMACTANA

CREATE VIEW C_CommitmentActualsAnalysis AS
SELECT
  FM.FinancialManagementArea AS FinancialManagementArea,
  FM.Ledger AS Ledger,
  FM.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  FM.FundsCenter AS FundsCenter,
  _FundsCenter._Text[1:Language = $session.system_language].FundsCenterName AS FundsCenterName,
  FM.Fund AS Fund,
  _Fund._Text[1:Language = $session.system_language].FundName AS FundName,
  FM.CommitmentItem AS CommitmentItem,
  CommitmentItemFiscalYear,
  _CommitmentItem._Text[1:Language = $session.system_language].CommitmentItemName AS CommitmentItemName,
  FM.FunctionalArea AS FunctionalArea,
  _FunctionalArea._Text[1:Language = $session.system_language].FunctionalAreaName AS FunctionalAreaName,
  FM.BudgetPeriod AS BudgetPeriod,
  _BudgetPeriod._Text[1:Language = $session.system_language].BudgetPeriodName AS BudgetPeriodName,
  FM.FundedProgram AS FundedProgram,
  _FundedProgram._Text[1:Language = $session.system_language].FundedProgramName AS FundedProgramName,
  FM.GrantID AS GrantID,
  _Grant._Text[1:Language = $session.system_language].GrantName AS GrantName,
  FM.FundsManagementCustomerField AS FundsManagementCustomerField,
  FM.FundsMgmtValueType AS FundsMgmtValueType,
  FM.FundsMgmtAmountType AS FundsMgmtAmountType,
  FM.BusinessTransactionType AS BusinessTransactionType,
  FM.IsStatisticalItem AS IsStatisticalItem,
  _SalesOrderItem._SalesOrder.SoldToParty AS Customer,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  case FM.ReferenceDocumentType when 'PORD' then _PurchaseOrderItem.Material when 'VBRK' then _SalesOrderItem.Material else ' ' end as Material AS MaterialelseendasMaterial,
  case FM.ReferenceDocumentType when 'PORD' then _PurchaseOrderItem.MaterialGroup when 'VBRK' then _SalesOrderItem.MaterialGroup else ' ' end as MaterialGroup AS MaterialGroupelseendasMaterialGroup,
  FM.FundsMgCarryForwardLevel AS FundsMgCarryForwardLevel,
  FM.BusinessArea AS BusinessArea,
  FM.CompanyCode AS CompanyCode,
  FM.GLAccount AS GLAccount,
  FM.ControllingArea AS ControllingArea,
  FM.ProfitCenter AS ProfitCenter,
  _ProfitCenter._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  FM.Segment AS Segment,
  _Segment._Text[1:Language = $session.system_language].SegmentName AS SegmentName,
  FM.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  FM.TransactionCurrency AS TransactionCurrency,
  FM.AmountInFMACrcy AS AmountInFMACrcy,
  FM.FndsMgmtAmountInTransCrcy AS FndsMgmtAmountInTransCrcy,
  FM.FundsMgmtRefDocumentCategory AS FundsMgmtRefDocumentCategory,
  FM.RefDocAccountAssignment AS RefDocAccountAssignment,
  FM.RefDocPricingElementContent AS RefDocPricingElementContent,
  FM.ReferenceDocument AS ReferenceDocument,
  FM.ReferenceDocumentContext AS ReferenceDocumentContext,
  FM.ReferenceDocumentItem AS ReferenceDocumentItem,
  FM.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  FM.ReferenceDocumentScheduleLine AS ReferenceDocumentScheduleLine,
  FM.ReferenceDocumentType AS ReferenceDocumentType,
  FM.FundsMgmtFinDocFiscalYear AS FundsMgmtFinDocFiscalYear,
  FM.FundsMgmtFinDocItem AS FundsMgmtFinDocItem,
  FM.FundsMgmtFinDocNumber AS FundsMgmtFinDocNumber,
  FM.FundsMgmtPaytDocFiscalYear AS FundsMgmtPaytDocFiscalYear,
  FM.FundsMgmtPaytDocItem AS FundsMgmtPaytDocItem,
  FM.FundsMgmtPaytDocNumber AS FundsMgmtPaytDocNumber,
  FM.FundsMgmtUpdateDate AS FundsMgmtUpdateDate,
  FM.FinMgmtAreaPeriod AS FinMgmtAreaPeriod,
  FM.SalesOrderItem AS SalesOrderItem,
  _FundsCenter.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  _FundsCenter.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  _Fund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _CommitmentItem.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  _CommitmentItem.CommitmentItemAuthznGrp AS CommitmentItemAuthznGrp,
  _FunctionalArea.FunctionalAreaAuthznGrp AS FunctionalAreaAuthznGrp,
  _FundedProgram.FundedPgmFinMgmtAreaForAuthzn AS FundedPgmFinMgmtAreaForAuthzn,
  _FundedProgram.FundedProgramAuthznGrp AS FundedProgramAuthznGrp,
  _Grant.GrantAuthznGrp AS GrantAuthznGrp,
  _Grant.GrantLifecycleStatus AS GrantLifecycleStatus,
  _BudgetPeriod.BudgetPeriodAuthznGrp AS BudgetPeriodAuthznGrp,
  _FundsCenter.ValidityEndDate AS ValidityEndDate,
  _Ledger._Text[1:Language = $session.system_language].LedgerName AS LedgerName,
  _AmountType._Text[1:Language = $session.system_language].FundsMgmtAmountTypeText AS FundsMgmtAmountTypeText,
  _ValueType._Text[1:Language = $session.system_language].FundsMgmtValueTypeText AS FundsMgmtValueTypeText
FROM I_FndsMgmtCmtmtActualCube AS FM
LEFT OUTER JOIN I_FinancialManagementArea AS _FinMgmtArea ON FinancialManagementArea = _FinMgmtArea.FinancialManagementArea  -- association [1..1]
LEFT OUTER JOIN I_FiscalYearForFinMgmtArea AS _FiscalYearForFinMgmtArea ON FinancialManagementArea = _FiscalYearForFinMgmtArea.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FiscalYearForFinMgmtArea.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN I_BudgetPeriod AS _BudgetPeriod ON BudgetPeriod = _BudgetPeriod.BudgetPeriod  -- 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_FundsMgmtLedger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_FndsMgmtPostingLedger AS _PostingLedger ON FinancialManagementArea = _PostingLedger.FinancialManagementArea AND Ledger = _PostingLedger.Ledger  -- association [0..1]
LEFT OUTER JOIN I_Grant AS _Grant ON GrantID = _Grant.GrantID  -- 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_FundsMgmtFunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FundsCenter = _FundsCenter.FundsCenter AND ValidityEndDate = _FundsCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON ReferenceDocument = _PurchaseOrderItem.PurchaseOrder AND ReferenceDocumentItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON ReferenceDocument = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [1]
LEFT OUTER JOIN I_FundsMgmtAmtType AS _AmountType ON FundsMgmtAmountType = _AmountType.FundsMgmtAmountType  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtAmtType AS _AmountTypeVH ON FundsMgmtAmountType = _AmountTypeVH.FundsMgmtAmountType  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtValType AS _ValueType ON FundsMgmtValueType = _ValueType.FundsMgmtValueType  -- association [0..1]
LEFT OUTER JOIN I_FundsMgmtValType AS _ValueTypeVH ON FundsMgmtValueType = _ValueTypeVH.FundsMgmtValueType  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN E_FundsCenter AS _ExtensionFundsCenter ON FinancialManagementArea = _ExtensionFundsCenter.FinancialManagementArea AND FundsCenter = _ExtensionFundsCenter.FundsCenter  -- association [1..1]
LEFT OUTER JOIN E_CommitmentItem AS _ExtensionCommitmentItem ON FinancialManagementArea = _ExtensionCommitmentItem.FinancialManagementArea AND CommitmentItem = _ExtensionCommitmentItem.CommitmentItem AND CommitmentItemFiscalYear = _ExtensionCommitmentItem.FinMgmtAreaFiscalYear  -- association [1..1]
LEFT OUTER JOIN E_Grant AS _ExtensionGrant ON GrantID = _ExtensionGrant.GrantID  -- association [1..1]
LEFT OUTER JOIN E_Fund AS _ExtensionFund ON FinancialManagementArea = _ExtensionFund.FinancialManagementArea AND Fund = _ExtensionFund.Fund  -- association [1..1]
LEFT OUTER JOIN E_FundedProgram AS _ExtensionFundedProgram ON FinancialManagementArea = _ExtensionFundedProgram.FinancialManagementArea AND FundedProgram = _ExtensionFundedProgram.FundedProgram  -- 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_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;