I_FundsMgmtCmtmtOpenItem

DDL: I_FUNDSMGMTCMTMTOPENITEM SQL: IFMIOIOPENITEM Type: view COMPOSITE
66 Fields 1 Data Sources 1 Associations

Funds Management Commitments Open Items

I_FundsMgmtCmtmtOpenItem is a Composite CDS View that provides data about "Funds Management Commitments Open Items" in SAP S/4HANA. It reads from 1 data source (P_FundsMgmtCmtmtOpenItem) and exposes 66 fields with key fields ReferenceDocument, FundsMgmtRefDocumentCategory, ReferenceDocumentContext, ReferenceDocumentItem, RefDocAccountAssignment. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_FundsMgmtCmtmtOpenItem P_FundsMgmtCmtmtOpenItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_FundsCenter _FundsCenter $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea and $projection.PostedFundsCenter = _FundsCenter.FundsCenter

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IFMIOIOPENITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Funds Management Commitments Open Items view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY ReferenceDocument ReferenceDocument Reference Document
KEY FundsMgmtRefDocumentCategory FundsMgmtRefDocumentCategory
KEY ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
KEY ReferenceDocumentItem ReferenceDocumentItem Reference item
KEY RefDocAccountAssignment RefDocAccountAssignment
KEY ReferenceDocumentScheduleLine ReferenceDocumentScheduleLine Schedule Line
KEY RefDocPricingElementContent RefDocPricingElementContent
KEY ReferenceDocumentType ReferenceDocumentType Reference Document Type
KEY ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
KEY Ledger Ledger Ledger
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear Fiscal Year
CashEffectivityFiscalYear CashEffectivityFiscalYear
FundsMgmtCmtmtItemIsCompleted FundsMgmtCmtmtItemIsCompleted Set "Completed"
FundsMgmtCmtmtItemIsDeleted FundsMgmtCmtmtItemIsDeleted
TransactionCurrency TransactionCurrency Transaction Currency
OpenCmtmtAmountInTransCrcy
FinancialManagementAreaCrcy FinancialManagementAreaCrcy FM Area Currency
OpenCmtmtAmountInFMACrcy
FinancialManagementArea FinancialManagementArea FM Area
PostedFundsCenter PostedFundsCenter
PostedFund PostedFund
PostedCommitmentItem PostedCommitmentItem
CommitmentItemFiscalYear CommitmentItemFiscalYear Commit. Item FY
PostedFunctionalArea PostedFunctionalArea
PostedFundedProgram PostedFundedProgram
PostedGrantID PostedGrantID
PostedBudgetPeriod PostedBudgetPeriod
PostedFundsMgmtCustomerField PostedFundsMgmtCustomerField
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
BusinessArea BusinessArea Business Area
CompanyCode CompanyCode Receiver Company Code
GLAccount GLAccount General Ledger
FundsMgmtValueType FundsMgmtValueType
BusinessTransactionType BusinessTransactionType Bus.transaction
IsStatisticalItem IsStatisticalItem Statisticl.Indicator
FundsMgCarryForwardLevel FundsMgCarryForwardLevel
FundsMgmtCmtmtCarryFwdStatus FundsMgmtCmtmtCarryFwdStatus
FndsCenterFinMgmtAreaForAuthzn FndsCenterFinMgmtAreaForAuthzn
FundsCenterAuthznGrp FundsCenterAuthznGrp
FundFinMgmtAreaForAuthzn FundFinMgmtAreaForAuthzn
FundAuthznGrp FundAuthznGrp
CmtmtItemFinMgmtAreaForAuthzn CmtmtItemFinMgmtAreaForAuthzn
CommitmentItemAuthznGrp CommitmentItemAuthznGrp
FunctionalAreaAuthznGrp FunctionalAreaAuthznGrp
FundedPgmFinMgmtAreaForAuthzn FundedPgmFinMgmtAreaForAuthzn
FundedProgramAuthznGrp FundedProgramAuthznGrp
GrantAuthznGrp GrantAuthznGrp
GrantLifecycleStatus GrantLifecycleStatus
BudgetPeriodAuthznGrp BudgetPeriodAuthznGrp
_FunctionalArea _FunctionalArea
_CommitmentItem _CommitmentItem
_CommitmentItem1 _CommitmentItem1
_Fund _Fund
_FundsCenter _FundsCenter
_Grant _Grant
_BudgetPeriod _BudgetPeriod
_FundedProgram _FundedProgram
_Ledger _Ledger
_LogicalSystem _LogicalSystem
_ReferenceDocumentType _ReferenceDocumentType
_FiscalYearForFinMgmtArea _FiscalYearForFinMgmtArea
_FinMgmtArea _FinMgmtArea
_PurchasingDocumentItem _PurchasingDocumentItem
_PurgDocAccountAssignment _PurgDocAccountAssignment

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_FundsMgmtCmtmtOpenItem.
-- 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: IFMIOIOPENITEM

CREATE VIEW I_FundsMgmtCmtmtOpenItem AS
SELECT
  ReferenceDocument,
  FundsMgmtRefDocumentCategory,
  ReferenceDocumentContext,
  ReferenceDocumentItem,
  RefDocAccountAssignment,
  ReferenceDocumentScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  Ledger,
  FinMgmtAreaFiscalYear,
  CashEffectivityFiscalYear,
  FundsMgmtCmtmtItemIsCompleted,
  FundsMgmtCmtmtItemIsDeleted,
  TransactionCurrency,
  sum( PostedAmountInTransCrcy ) AS OpenCmtmtAmountInTransCrcy,
  FinancialManagementAreaCrcy,
  sum( PostedAmountInFMACrcy ) AS OpenCmtmtAmountInFMACrcy,
  FinancialManagementArea,
  PostedFundsCenter,
  PostedFund,
  PostedCommitmentItem,
  CommitmentItemFiscalYear,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedGrantID,
  PostedBudgetPeriod,
  PostedFundsMgmtCustomerField,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  AccountAssignmentNumber,
  BusinessArea,
  CompanyCode,
  GLAccount,
  FundsMgmtValueType,
  BusinessTransactionType,
  IsStatisticalItem,
  FundsMgCarryForwardLevel,
  FundsMgmtCmtmtCarryFwdStatus,
  FndsCenterFinMgmtAreaForAuthzn,
  FundsCenterAuthznGrp,
  FundFinMgmtAreaForAuthzn,
  FundAuthznGrp,
  CmtmtItemFinMgmtAreaForAuthzn,
  CommitmentItemAuthznGrp,
  FunctionalAreaAuthznGrp,
  FundedPgmFinMgmtAreaForAuthzn,
  FundedProgramAuthznGrp,
  GrantAuthznGrp,
  GrantLifecycleStatus,
  BudgetPeriodAuthznGrp
FROM P_FundsMgmtCmtmtOpenItem
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND PostedFundsCenter = _FundsCenter.FundsCenter  -- association [0..*]
;

Learn More