I_FundsMgmtCtrlgDocumentItem

DDL: I_FUNDSMGMTCTRLGDOCUMENTITEM Type: view COMPOSITE
65 Fields 1 Data Sources 1 Associations

FM Controlling Document Item

I_FundsMgmtCtrlgDocumentItem is a Composite CDS View that provides data about "FM Controlling Document Item" in SAP S/4HANA. It reads from 1 data source (I_FundsMgmtCtrlgDocItemBasic) and exposes 65 fields with key fields FinancialManagementArea, FundsMgmtCtrlgDocument, FundsMgmtCtrlgDocumentItem, FundsMgmtLongSequenceNumber. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_FundsMgmtCtrlgDocItemBasic I_FundsMgmtCtrlgDocItemBasic from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FundsCenterByYear _FundsCenter $projection.FinancialManagementArea = _FundsCenter.FinancialManagementArea and $projection.FinMgmtAreaFiscalYear = _FundsCenter.FinMgmtAreaFiscalYear and $projection.PostedFundsCenter = _FundsCenter.FundsCenter

Annotations (9)

NameValueLevelField
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName IFMCTRLGDOCITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label FM Controlling Document Item view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea FM Area
KEY FundsMgmtCtrlgDocument FundsMgmtCtrlgDocument Well doc.no.
KEY FundsMgmtCtrlgDocumentItem FundsMgmtCtrlgDocumentItem Matching Document Line Item
KEY FundsMgmtLongSequenceNumber FundsMgmtLongSequenceNumber Record number
FinMgmtAreaFiscalYear FinMgmtAreaFiscalYear Fiscal Year
CashEffectivityFiscalYear CashEffectivityFiscalYear YCE
FundsMgmtCtrlgDocumentItemDate FundsMgmtCtrlgDocumentItemDate Imported On
TransactionCurrency TransactionCurrency Transaction Currency
PostedAmountInTransCrcy PostedAmountInTransCrcy Trans. Currency
FinancialManagementAreaCrcy _FinMgmtArea FinancialManagementAreaCrcy FM Area Currency
PostedAmountInFMACrcy PostedAmountInFMACrcy Local Crcy Amt
PostedFundsCenter PostedFundsCenter
PostedFund PostedFund
PostedCommitmentItem PostedCommitmentItem
PostedFunctionalArea PostedFunctionalArea
PostedFundedProgram PostedFundedProgram
PostedGrantID PostedGrantID
PostedBudgetPeriod PostedBudgetPeriod
PostedFundsMgmtCustomerField PostedFundsMgmtCustomerField
CommitmentItemFiscalYear CommitmentItemFiscalYear Commit. Item FY
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
GLAccount GLAccount General Ledger
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
Segment Segment Segment number
Ledger Ledger Ledger
FinMgmtAreaPeriod FinMgmtAreaPeriod
FundsMgmtValueType FundsMgmtValueType Value Type
FundsMgmtAmountType FundsMgmtAmountType Amount Type
BusinessTransactionType BusinessTransactionType Bus.transaction
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ReferenceDocumentType ReferenceDocumentType Reference Document Type
ReferenceDocumentContext ReferenceDocumentContext Reference Document Context
FundsMgCarryForwardLevel FundsMgCarryForwardLevel C/f Level
IsStatisticalItem IsStatisticalItem Statisticl.Indicator
FundsManagementStatisticalType FundsManagementStatisticalType Statisticl.Indicator
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentFiscalYear ReferenceDocumentFiscalYear Year Cur.Period
ReferenceDocumentItem ReferenceDocumentItem Reference item
FndsCenterFinMgmtAreaForAuthzn _FundsCenter FndsCenterFinMgmtAreaForAuthzn
FundsCenterAuthznGrp _FundsCenter FundsCenterAuthznGrp
FundFinMgmtAreaForAuthzn _Fund FundFinMgmtAreaForAuthzn
FundAuthznGrp _Fund FundAuthznGrp
CmtmtItemFinMgmtAreaForAuthzn _CommitmentItem CmtmtItemFinMgmtAreaForAuthzn
CommitmentItemAuthznGrp _CommitmentItem CommitmentItemAuthznGrp
FunctionalAreaAuthznGrp _FunctionalArea FunctionalAreaAuthznGrp
FundedPgmFinMgmtAreaForAuthzn _FundedProgram FundedPgmFinMgmtAreaForAuthzn
FundedProgramAuthznGrp _FundedProgram FundedProgramAuthznGrp
GrantAuthznGrp _Grant GrantAuthznGrp
GrantLifecycleStatus _Grant GrantLifecycleStatus
BudgetPeriodAuthznGrp _BudgetPeriod BudgetPeriodAuthznGrp
_TransactionCurrency _TransactionCurrency
_FunctionalArea _FunctionalArea
_CommitmentItem _CommitmentItem
_Fund _Fund
_FundsCenter _FundsCenter
_Grant _Grant
_BudgetPeriod _BudgetPeriod
_FundedProgram _FundedProgram
_Ledger _Ledger
_LogicalSystem _LogicalSystem
_ReferenceDocumentType _ReferenceDocumentType
_FiscalYearForFinMgmtArea _FiscalYearForFinMgmtArea
_FinMgmtArea _FinMgmtArea

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_FundsMgmtCtrlgDocumentItem.
-- 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 I_FundsMgmtCtrlgDocumentItem AS
SELECT
  FinancialManagementArea,
  FundsMgmtCtrlgDocument,
  FundsMgmtCtrlgDocumentItem,
  FundsMgmtLongSequenceNumber,
  FinMgmtAreaFiscalYear,
  CashEffectivityFiscalYear,
  FundsMgmtCtrlgDocumentItemDate,
  TransactionCurrency,
  PostedAmountInTransCrcy,
  _FinMgmtArea.FinancialManagementAreaCrcy AS FinancialManagementAreaCrcy,
  PostedAmountInFMACrcy,
  PostedFundsCenter,
  PostedFund,
  PostedCommitmentItem,
  PostedFunctionalArea,
  PostedFundedProgram,
  PostedGrantID,
  PostedBudgetPeriod,
  PostedFundsMgmtCustomerField,
  CommitmentItemFiscalYear,
  CompanyCode,
  BusinessArea,
  GLAccount,
  ProfitCenter,
  ControllingArea,
  Segment,
  Ledger,
  FinMgmtAreaPeriod,
  FundsMgmtValueType,
  FundsMgmtAmountType,
  BusinessTransactionType,
  ReferenceDocumentLogicalSystem,
  ReferenceDocumentType,
  ReferenceDocumentContext,
  FundsMgCarryForwardLevel,
  IsStatisticalItem,
  FundsManagementStatisticalType,
  ReferenceDocument,
  ReferenceDocumentFiscalYear,
  ReferenceDocumentItem,
  _FundsCenter.FndsCenterFinMgmtAreaForAuthzn AS FndsCenterFinMgmtAreaForAuthzn,
  _FundsCenter.FundsCenterAuthznGrp AS FundsCenterAuthznGrp,
  _Fund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  _Fund.FundAuthznGrp AS FundAuthznGrp,
  _CommitmentItem.CmtmtItemFinMgmtAreaForAuthzn AS CmtmtItemFinMgmtAreaForAuthzn,
  _CommitmentItem.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_FundsMgmtCtrlgDocItemBasic
LEFT OUTER JOIN I_FundsCenterByYear AS _FundsCenter ON FinancialManagementArea = _FundsCenter.FinancialManagementArea AND FinMgmtAreaFiscalYear = _FundsCenter.FinMgmtAreaFiscalYear AND PostedFundsCenter = _FundsCenter.FundsCenter  -- association [0..1]
;

Learn More