C_FundsMgmtCmtmtDocQry1

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_FundsMgmtCmtmtDocQry1.
-- 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: CFMCMOIANQ1
-- Parameters: P_FinancialManagementArea : fikrs

CREATE VIEW C_FundsMgmtCmtmtDocQry1 AS
SELECT
  lookupEntity: 'I_FndsMgmtFinMgmtAreaDefault' AS lookupEntityI_FndsMgmtFinMgmtAreaDefault,
  resultElement: 'FinancialManagementArea' AS resultElementFinancialManagementArea,
  binding: [ { targetElement : 'CreatedByUser' , type : #SYSTEM_FIELD, value : '#USER' AS ReferenceDocument,
  FM.FundsMgmtRefDocumentCategory AS FundsMgmtRefDocumentCategory,
  FM.ReferenceDocumentContext AS ReferenceDocumentContext,
  FM.ReferenceDocumentItem AS ReferenceDocumentItem,
  FM.RefDocAccountAssignment AS RefDocAccountAssignment,
  FM.ReferenceDocumentScheduleLine AS ReferenceDocumentScheduleLine,
  FM.RefDocPricingElementContent AS RefDocPricingElementContent,
  FM.ReferenceDocumentType AS ReferenceDocumentType,
  FM.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  FM.FundsMgmtAmountType AS FundsMgmtAmountType,
  FM.Ledger AS Ledger,
  FM.FinMgmtAreaFiscalYear AS FinMgmtAreaFiscalYear,
  FM.FundsMgmtSequenceNumber AS FundsMgmtSequenceNumber,
  FM.FinancialManagementArea AS FinancialManagementArea,
  FM.FundsCenter AS FundsCenter,
  FM.FndsMgmtRptgFndsCtrForHier AS FndsMgmtRptgFndsCtrForHier,
  FM.CommitmentItem AS CommitmentItem,
  FM.FndsMgmtRptgCmtmtItemForHier AS FndsMgmtRptgCmtmtItemForHier,
  FM.Fund AS Fund,
  FM.FndsMgmtRptgFundForHierarchy AS FndsMgmtRptgFundForHierarchy,
  FM.BudgetPeriod AS BudgetPeriod,
  FM.FndsMgmtRptgBdgtPerdForHier AS FndsMgmtRptgBdgtPerdForHier,
  FM.FunctionalArea AS FunctionalArea,
  FM.FndsMgmtRptgFctArForHierarchy AS FndsMgmtRptgFctArForHierarchy,
  FM.FundedProgram AS FundedProgram,
  FM.FndsMgmtRptgFnddPgmForHier AS FndsMgmtRptgFnddPgmForHier,
  FM.GrantID AS GrantID,
  FM.FndsMgmtRptgGrantIDForHier AS FndsMgmtRptgGrantIDForHier,
  FM.FundsManagementCustomerField AS FundsManagementCustomerField,
  FM.CompanyCode AS CompanyCode,
  FM.BusinessArea AS BusinessArea,
  FM.GLAccount AS GLAccount,
  FM.ProfitCenter AS ProfitCenter,
  FM.FndsMgmtRptgPrftCtrForHier AS FndsMgmtRptgPrftCtrForHier,
  FM.ControllingArea AS ControllingArea,
  FM.Segment AS Segment,
  FM.FndsMgmtRptgSegmentForHier AS FndsMgmtRptgSegmentForHier,
  FM.FinMgmtAreaPeriod AS FinMgmtAreaPeriod,
  FM.FinMgmtAreaFiscalYearVariant AS FinMgmtAreaFiscalYearVariant,
  FM.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  FM.OpenCmtmtAmountInFMACrcy AS OpenCmtmtAmountInFMACrcy,
  FM.FndsMgmtPaytCmtmtBdgtCat AS FndsMgmtPaytCmtmtBdgtCat,
  FM.BusinessTransactionType AS BusinessTransactionType,
  FM.CashEffectivityFiscalYear AS CashEffectivityFiscalYear,
  FM.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  FM.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  FM.FundsMgCarryForwardLevel AS FundsMgCarryForwardLevel,
  FM.FundsMgmtCmtmtCarryFwdStatus AS FundsMgmtCmtmtCarryFwdStatus,
  FM.FundsMgmtCmtmtItemIsCompleted AS FundsMgmtCmtmtItemIsCompleted,
  FM.FundsMgmtCmtmtItemIsDeleted AS FundsMgmtCmtmtItemIsDeleted,
  FM.FundsMgmtValueType AS FundsMgmtValueType,
  FM.IsStatisticalItem AS IsStatisticalItem,
  FM.FundsManagementStatisticalType AS FundsManagementStatisticalType,
  FM.CommitmentItemFiscalYear AS CommitmentItemFiscalYear,
  FM.PurchaseOrder AS PurchaseOrder,
  FM.PurchaseRequisition AS PurchaseRequisition,
  FM.EmployeeExpenseReport AS EmployeeExpenseReport,
  FM.SalesOrder AS SalesOrder,
  FM.ConcurTravelRequest AS ConcurTravelRequest,
  FM.CTEExpenseReportObligation AS CTEExpenseReportObligation
FROM I_FundsMgmtCmtmtOpnItmCube AS FM
;