A_FundsMgmtCmtmtActualItem

DDL: A_FUNDSMGMTCMTMTACTUALITEM Type: view COMPOSITE
51 Fields 1 Data Sources 2 Associations

Funds Management Commitment Actual Items

A_FundsMgmtCmtmtActualItem is a Composite CDS View that provides data about "Funds Management Commitment Actual Items" in SAP S/4HANA. It reads from 1 data source (I_FundsMgmtCmtmtActlItemCube) and exposes 51 fields with key fields FinancialManagementArea, FinMgmtAreaFiscalYear, BudgetPeriod, CommitmentItem, FunctionalArea. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtCmtmtActlItemCube I_FundsMgmtCmtmtActlItemCube from

Associations (2)

CardinalityTargetAliasCondition
[0..1] A_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[0..1] A_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName AFMCMTMTACTLITEM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Funds Management Commitment Actual Items view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name FundsManagementCommitmentActualItem_Type view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea FM Area
KEY FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear Fiscal Year
KEY BudgetPeriod BudgetPeriod Budget Period
KEY CommitmentItem CommitmentItem Commitment item
KEY FunctionalArea FunctionalArea Sendr Fctl Area
KEY Fund Fund Sender Fund
KEY FundedProgram FundedProgram Funded Program
KEY FundsCenter FundsCenter Funds Center
KEY GrantID GrantID Sender Grant
KEY FundsManagementCustomerField FundsManagementCustomerField Customer Field
KEY FinancialManagementAreaCrcy FinancialManagementAreaCrcy FM Area Currency
KEY TransactionCurrency TransactionCurrency Transaction Currency
KEY BusinessArea BusinessArea Business Area
KEY CompanyCode CompanyCode Receiver Company Code
KEY GLAccount GLAccount General Ledger
KEY FndsMgmtPaytCmtmtBdgtCat FndsMgmtPaytCmtmtBdgtCat
KEY FundsMgmtValueType FundsMgmtValueType
KEY FundsMgmtAmountType FundsMgmtAmountType
KEY BusinessTransactionType BusinessTransactionType Bus.transaction
KEY FundsManagementStatisticalType FundsManagementStatisticalType
KEY Supplier Supplier Supplier
KEY Customer Customer Sold-to Party
KEY FundsMgCarryForwardLevel FundsMgCarryForwardLevel
KEY ReferenceDocument ReferenceDocument Reference Document
KEY ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Year Cur.Period
KEY ReferenceDocumentItem ReferenceDocumentItem Reference item
KEY ReferenceDocumentType ReferenceDocumentType Reference Document Type
KEY ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
KEY FinMgmtAreaPeriod FinMgmtAreaPeriod
CashEffectivityFiscalYear CashEffectivityFiscalYear
FinMgmtAreaFiscalYearVariant FinMgmtAreaFiscalYearVariant
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
Segment Segment Segment number
CmtmtOpenItemAmountInFMACrcy CmtmtOpenItemAmountInFMACrcy
CmtmtOpenItemAmountInTransCrcy CmtmtOpenItemAmountInTransCrcy
ActualAmountInFMACrcy ActualAmountInFMACrcy
FndsMgmtActlAmountInTransCrcy FndsMgmtActlAmountInTransCrcy
CtrlgItemAmountInFMACrcy CtrlgItemAmountInFMACrcy
CtrlgItemAmountInTransCrcy CtrlgItemAmountInTransCrcy
FundsMgmtUpdateDate FundsMgmtUpdateDate
CommitmentItemFiscalYear CommitmentItemFiscalYear Commit. Item FY
_Supplier _Supplier
_Customer _Customer
_Fund _Fund
_CommitmentItem _CommitmentItem
_BudgetPeriod _BudgetPeriod
_FunctionalArea _FunctionalArea
_FundedProgram _FundedProgram
_FundsCenter _FundsCenter
_Grant _Grant

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 A_FundsMgmtCmtmtActualItem.
-- 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.

CREATE VIEW A_FundsMgmtCmtmtActualItem AS
SELECT
  FinancialManagementArea,
  FinMgmtAreaFiscalYear,
  BudgetPeriod,
  CommitmentItem,
  FunctionalArea,
  Fund,
  FundedProgram,
  FundsCenter,
  GrantID,
  FundsManagementCustomerField,
  FinancialManagementAreaCrcy,
  TransactionCurrency,
  BusinessArea,
  CompanyCode,
  GLAccount,
  FndsMgmtPaytCmtmtBdgtCat,
  FundsMgmtValueType,
  FundsMgmtAmountType,
  BusinessTransactionType,
  FundsManagementStatisticalType,
  Supplier,
  Customer,
  FundsMgCarryForwardLevel,
  ReferenceDocument,
  ReferenceDocumentFiscalYear,
  ReferenceDocumentItem,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  FinMgmtAreaPeriod,
  CashEffectivityFiscalYear,
  FinMgmtAreaFiscalYearVariant,
  ProfitCenter,
  ControllingArea,
  Segment,
  CmtmtOpenItemAmountInFMACrcy,
  CmtmtOpenItemAmountInTransCrcy,
  ActualAmountInFMACrcy,
  FndsMgmtActlAmountInTransCrcy,
  CtrlgItemAmountInFMACrcy,
  CtrlgItemAmountInTransCrcy,
  FundsMgmtUpdateDate,
  CommitmentItemFiscalYear
FROM I_FundsMgmtCmtmtActlItemCube
LEFT OUTER JOIN A_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN A_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
;

Learn More