P_FundsMgmtCmtmtOpenItem

DDL: P_FUNDSMGMTCMTMTOPENITEM SQL: PFMIOIOPENITEM Type: view COMPOSITE
71 Fields 1 Data Sources 1 Associations

P_FundsMgmtCmtmtOpenItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_FundsMgmtCommitmentEntryItem) and exposes 71 fields with key fields ReferenceDocument, FundsMgmtRefDocumentCategory, ReferenceDocumentContext, ReferenceDocumentItem, RefDocAccountAssignment. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtCommitmentEntryItem I_FundsMgmtCommitmentEntryItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FundsCenter _FundsCenter $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea and $projection.PostedFundsCenter = _FundsCenter.FundsCenter and _FundsCenter.ValidityEndDate >= $projection.FundsMgmtUpdateDate and _FundsCenter.ValidityStartDate <= $projection.FundsMgmtUpdateDate

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PFMIOIOPENITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (71)

KeyFieldSource TableSource FieldDescription
KEY ReferenceDocument ReferenceDocument Reference Document
KEY FundsMgmtRefDocumentCategory FundsMgmtRefDocumentCategory
KEY ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
KEY ReferenceDocumentItem FundsMgmtReferenceDocumentItem
KEY RefDocAccountAssignment RefDocAccountAssignment
KEY ReferenceDocumentScheduleLine FundsMgmtRefDocScheduleLine
KEY RefDocPricingElementContent RefDocPricingElementContent
KEY ReferenceDocumentType ReferenceDocumentType Reference Document Type
KEY ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
KEY FundsMgmtAmountType FundsMgmtAmountType
KEY Ledger Ledger Ledger
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear Fiscal Year
KEY FundsMgmtSequenceNumber FundsMgmtSequenceNumber
CashEffectivityFiscalYear CashEffectivityFiscalYear
FinMgmtAreaPeriod FinMgmtAreaPeriod
FundsMgmtUpdateDate FundsMgmtUpdateDate
FundsMgmtTransactionNumber FundsMgmtTransactionNumber
FundsMgmtCmtmtItemIsCompleted FundsMgmtCmtmtItemIsCompleted Set "Completed"
FundsMgmtCmtmtItemIsDeleted FundsMgmtCmtmtItemIsDeleted
TransactionCurrency TransactionCurrency Transaction Currency
PostedAmountInTransCrcy PostedAmountInTransCrcy
FinancialManagementAreaCrcy FinancialManagementAreaCrcy FM Area Currency
PostedAmountInFMACrcy PostedAmountInFMACrcy
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 _FundsCenter FndsCenterFinMgmtAreaForAuthzn
FundsCenterAuthznGrp _FundsCenter FundsCenterAuthznGrp
FundFinMgmtAreaForAuthzn _Fund FundFinMgmtAreaForAuthzn
FundAuthznGrp _Fund FundAuthznGrp
CmtmtItemFinMgmtAreaForAuthzn _CommitmentItem1 CmtmtItemFinMgmtAreaForAuthzn
CommitmentItemAuthznGrp _CommitmentItem1 CommitmentItemAuthznGrp
FunctionalAreaAuthznGrp _FunctionalArea FunctionalAreaAuthznGrp
FundedPgmFinMgmtAreaForAuthzn _FundedProgram FundedPgmFinMgmtAreaForAuthzn
FundedProgramAuthznGrp _FundedProgram FundedProgramAuthznGrp
GrantAuthznGrp _Grant GrantAuthznGrp
GrantLifecycleStatus _Grant GrantLifecycleStatus
BudgetPeriodAuthznGrp _BudgetPeriod 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 P_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: PFMIOIOPENITEM

CREATE VIEW P_FundsMgmtCmtmtOpenItem AS
SELECT
  ReferenceDocument,
  FundsMgmtRefDocumentCategory,
  ReferenceDocumentContext,
  FundsMgmtReferenceDocumentItem AS ReferenceDocumentItem,
  RefDocAccountAssignment,
  FundsMgmtRefDocScheduleLine AS ReferenceDocumentScheduleLine,
  RefDocPricingElementContent,
  ReferenceDocumentType,
  ReferenceDocumentLogicalSystem,
  FundsMgmtAmountType,
  Ledger,
  FinMgmtAreaFiscalYear,
  FundsMgmtSequenceNumber,
  CashEffectivityFiscalYear,
  FinMgmtAreaPeriod,
  FundsMgmtUpdateDate,
  FundsMgmtTransactionNumber,
  FundsMgmtCmtmtItemIsCompleted,
  FundsMgmtCmtmtItemIsDeleted,
  TransactionCurrency,
  PostedAmountInTransCrcy,
  FinancialManagementAreaCrcy,
  PostedAmountInFMACrcy,
  FinancialManagementArea,
  PostedFundsCenter,
  PostedFund,
  PostedCommitmentItem,
  CommitmentItemFiscalYear,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedGrantID,
  PostedBudgetPeriod,
  PostedFundsMgmtCustomerField,
  EarmarkedFundsDocument,
  EarmarkedFundsDocumentItem,
  AccountAssignmentNumber,
  BusinessArea,
  CompanyCode,
  GLAccount,
  FundsMgmtValueType,
  BusinessTransactionType,
  IsStatisticalItem,
  FundsMgCarryForwardLevel,
  FundsMgmtCmtmtCarryFwdStatus,
  _FundsCenter.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  _FundsCenter.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  _Fund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _CommitmentItem1.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  _CommitmentItem1.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
FROM I_FundsMgmtCommitmentEntryItem
LEFT OUTER JOIN I_FundsCenter AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND PostedFundsCenter = _FundsCenter.FundsCenter AND _FundsCenter.ValidityEndDate >= FundsMgmtUpdateDate AND _FundsCenter.ValidityStartDate <= FundsMgmtUpdateDate  -- association [0..1]
;

Learn More