I_FundsMgmtCtrlgDocumentBasic

DDL: I_FUNDSMGMTCTRLGDOCUMENTBASIC Type: view_entity BASIC
13 Fields 3 Data Sources

Funds Management Controlling Document

I_FundsMgmtCtrlgDocumentBasic is a Basic CDS View that provides data about "Funds Management Controlling Document" in SAP S/4HANA. It reads from 3 data sources (P_ACDOCA, I_FundsMgmtCtrlgDocItemBasic, I_Ledger) and exposes 13 fields with key fields FinancialManagementArea, CompanyCode, FundsMgmtCtrlgDocument, FiscalYear.

Data Sources (3)

SourceAliasJoin Type
P_ACDOCA _acdoca inner
I_FundsMgmtCtrlgDocItemBasic _co from
I_Ledger _Ledger inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Funds Management Controlling Document view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_FundsMgmtCtrlgDocItemBasic FinancialManagementArea FM Area
KEY CompanyCode P_ACDOCA rbukrs Company Code
KEY FundsMgmtCtrlgDocument I_FundsMgmtCtrlgDocItemBasic FundsMgmtCtrlgDocument Well doc.no.
KEY FiscalYear P_ACDOCA gjahr Settlement Year
AccountingDocument P_ACDOCA belnr SD Document
LedgerGLLineItem P_ACDOCA docln Matching Document Line Item
ReferenceDocument P_ACDOCA awref Reference Doc.
ReferenceDocumentType P_ACDOCA awtyp Reference Document Type
ReferenceDocumentContext P_ACDOCA aworg Refer. Org.Unit
ReversalReferenceDocumentType P_ACDOCA awtyp_rev ReversalRefTran
ReversalReferenceDocumentCntxt P_ACDOCA aworg_rev Reversal Org.
ReversalReferenceDocument P_ACDOCA awref_rev Reversal Ref.
ControllingDocument P_ACDOCA co_belnr Document Number

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_FundsMgmtCtrlgDocumentBasic.
-- 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_FundsMgmtCtrlgDocumentBasic AS
SELECT
  _co.FinancialManagementArea AS FinancialManagementArea,
  _acdoca.rbukrs AS CompanyCode,
  _co.FundsMgmtCtrlgDocument AS FundsMgmtCtrlgDocument,
  _acdoca.gjahr AS FiscalYear,
  _acdoca.belnr AS AccountingDocument,
  _acdoca.docln AS LedgerGLLineItem,
  _acdoca.awref AS ReferenceDocument,
  _acdoca.awtyp AS ReferenceDocumentType,
  _acdoca.aworg AS ReferenceDocumentContext,
  _acdoca.awtyp_rev AS ReversalReferenceDocumentType,
  _acdoca.aworg_rev AS ReversalReferenceDocumentCntxt,
  _acdoca.awref_rev AS ReversalReferenceDocument,
  _acdoca.co_belnr AS ControllingDocument
FROM I_FundsMgmtCtrlgDocItemBasic AS _co
INNER JOIN I_Ledger AS _Ledger ON /* join condition not captured in parsed metadata */
INNER JOIN P_ACDOCA AS _acdoca ON /* join condition not captured in parsed metadata */
;

Learn More