I_FundsMgmtCommitmentEntryItem

DDL: I_FUNDSMGMTCOMMITMENTENTRYITEM SQL: IFMIOI Type: view COMPOSITE
66 Fields 1 Data Sources

Funds Management Commitments Entry Items

I_FundsMgmtCommitmentEntryItem is a Composite CDS View that provides data about "Funds Management Commitments Entry Items" in SAP S/4HANA. It reads from 1 data source (I_FundsMgmtCmtmtEntryItemBasic) and exposes 66 fields with key fields ReferenceDocument, FundsMgmtRefDocumentCategory, ReferenceDocumentContext, FundsMgmtReferenceDocumentItem, RefDocAccountAssignment.

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtCmtmtEntryItemBasic I_FundsMgmtCmtmtEntryItemBasic from

Annotations (10)

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

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY ReferenceDocument ReferenceDocument Reference Document
KEY FundsMgmtRefDocumentCategory FundsMgmtRefDocumentCategory Reference Doc. Cat.
KEY ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
KEY FundsMgmtReferenceDocumentItem FundsMgmtReferenceDocumentItem Reference item
KEY RefDocAccountAssignment RefDocAccountAssignment Acct Assnmt No.
KEY FundsMgmtRefDocScheduleLine FundsMgmtRefDocScheduleLine Schedule Line
KEY RefDocPricingElementContent RefDocPricingElementContent Counter
KEY ReferenceDocumentType ReferenceDocumentType Reference Document Type
KEY ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
KEY FundsMgmtAmountType FundsMgmtAmountType Amount Type
KEY Ledger Ledger Ledger
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear Fiscal Year
KEY FundsMgmtSequenceNumber FundsMgmtSequenceNumber Step Number
CashEffectivityFiscalYear CashEffectivityFiscalYear YCE
FinMgmtAreaPeriod FinMgmtAreaPeriod Time unit
FundsMgmtTransactionNumber FundsMgmtTransactionNumber Transaction No.
FundsMgmtCmtmtItemIsCompleted FundsMgmtCmtmtItemIsCompleted Set "Completed"
FundsMgmtCmtmtItemIsDeleted FundsMgmtCmtmtItemIsDeleted Status
TransactionCurrency TransactionCurrency Transaction Currency
PostedAmountInTransCrcy PostedAmountInTransCrcy TC amount
FinancialManagementAreaCrcy FinancialManagementAreaCrcy FM Area Currency
PostedAmountInFMACrcy PostedAmountInFMACrcy FMAC amount
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
AccountAssignmentNumber AccountAssignmentNumber Account Assgmt No.
EarmarkedFundsDocument EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem Document Item
BusinessArea BusinessArea Business Area
CompanyCode CompanyCode Receiver Company Code
GLAccount GLAccount General Ledger
FundsMgmtValueType FundsMgmtValueType Value Type
BusinessTransactionType BusinessTransactionType Bus.transaction
IsStatisticalItem IsStatisticalItem Statisticl.Indicator
FundsManagementStatisticalType FundsManagementStatisticalType Vehcle Status
FundsMgCarryForwardLevel FundsMgCarryForwardLevel C/f Level
FundsMgmtCmtmtCarryFwdStatus FundsMgmtCmtmtCarryFwdStatus FYC Status
FundsMgmtUpdateDate FundsMgmtUpdateDate FM Posting Date
FundsMgmtObjectNumber FundsMgmtObjectNumber Object number
ProfitCenter ProfitCenter Profit Center
Supplier Supplier Supplier
ControllingArea ControllingArea Controlling Area
Segment Segment Segment number
BudgetaryLedgerDocumentType BudgetaryLedgerDocumentType BL document type
_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_FundsMgmtCommitmentEntryItem.
-- 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: IFMIOI

CREATE VIEW I_FundsMgmtCommitmentEntryItem AS
SELECT
  ReferenceDocument,
  FundsMgmtRefDocumentCategory,
  ReferenceDocumentContext,
  FundsMgmtReferenceDocumentItem,
  RefDocAccountAssignment,
  FundsMgmtRefDocScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  FundsMgmtAmountType,
  Ledger,
  FinMgmtAreaFiscalYear,
  FundsMgmtSequenceNumber,
  CashEffectivityFiscalYear,
  FinMgmtAreaPeriod,
  FundsMgmtTransactionNumber,
  FundsMgmtCmtmtItemIsCompleted,
  FundsMgmtCmtmtItemIsDeleted,
  TransactionCurrency,
  PostedAmountInTransCrcy,
  FinancialManagementAreaCrcy,
  PostedAmountInFMACrcy,
  FinancialManagementArea,
  PostedFundsCenter,
  PostedFund,
  PostedCommitmentItem,
  CommitmentItemFiscalYear,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedGrantID,
  PostedBudgetPeriod,
  PostedFundsMgmtCustomerField,
  AccountAssignmentNumber,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  BusinessArea,
  CompanyCode,
  GLAccount,
  FundsMgmtValueType,
  BusinessTransactionType,
  IsStatisticalItem,
  FundsManagementStatisticalType,
  FundsMgCarryForwardLevel,
  FundsMgmtCmtmtCarryFwdStatus,
  FundsMgmtUpdateDate,
  FundsMgmtObjectNumber,
  ProfitCenter,
  Supplier,
  ControllingArea,
  Segment,
  BudgetaryLedgerDocumentType
FROM I_FundsMgmtCmtmtEntryItemBasic
;

Learn More