I_Fund

DDL: I_FUND SQL: IFUND Type: view COMPOSITE

Fund

I_Fund (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Fund · Cross Applications

I_Fund is a Composite CDS View (Dimension) that provides data about "Fund" in SAP S/4HANA. It reads from 1 data source (I_FundBasic) and exposes 28 fields with key fields FinancialManagementArea, Fund. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Master Data
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the master data for a fund, which can be used to answer the following business questions: What is the fund type? What is the frequency of fund?

Prerequisites
You have authorization to access specific FM areas based on the authorization object F_FICB_FKR. You have authorization to access a specific group of funds based on the authorization object F_FICA_FOG.

Structure
Object types This view is built on the following business object: Fund

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentPSM-FM-MD
CapabilitiesAnalytical Dimension, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction
PackageCross Applications for SAP S/4HANA Cloud Private Edition
Description

Documentation

Data Sources (1)

SourceAliasJoin Type
I_FundBasic I_FundBasic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_Fund _Extension $projection.Fund = _Extension.Fund and $projection.FinancialManagementArea = _Extension.FinancialManagementArea

Annotations (18)

NameValueLevelField
EndUserText.label Fund view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey Fund view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name Fund view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IFUND view
AbapCatalog.preserveKey true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea Financial Management Area
KEY Fund Fund Sender Fund
Customer Customer Customer Account Number for Fund
ApplicationOfFunds ApplicationOfFunds Application of Funds
FundCreatedBy FundCreatedBy Fund Created by User
FundCreatedAt FundCreatedAt Fund Created on Date
LastChangeUser LastChangeUser Fund Last Changed by User
LastChangeDate LastChangeDate Fund Last Changed on Date
FundAuthznGrp FundAuthznGrp Component of the Version Number
FundFinMgmtAreaForAuthzn FundFinMgmtAreaForAuthzn FM Area for Auth Grp for Fund
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Fund Valid To
FundReversalDate FundReversalDate Fund Reversal Date
FundExpirationDate FundExpirationDate Fund Expiration Date
FundType FundType FM Fund Type
FundPeriodicity FundPeriodicity Fund Frequency
FundResponsibleUser FundResponsibleUser Responsible User for Fund
_FundAuthznGrp _FundAuthznGrp
_FundType _FundType
_FinMgmtArea _FinMgmtArea
_Text _Text
_ApplicationOfFund _ApplicationOfFund
_Customer _Customer
_FundPeriodicity _FundPeriodicity
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_FundHierarchyNode _FundHierarchyNode
_FundToBudgetPeriod _FundToBudgetPeriod

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_Fund.
-- 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: IFUND

CREATE VIEW I_Fund AS
SELECT
  FinancialManagementArea,
  Fund,
  Customer,
  ApplicationOfFunds,
  FundCreatedBy,
  FundCreatedAt,
  LastChangeUser,
  LastChangeDate,
  FundAuthznGrp,
  FundFinMgmtAreaForAuthzn,
  ValidityStartDate,
  ValidityEndDate,
  FundReversalDate,
  FundExpirationDate,
  FundType,
  FundPeriodicity,
  FundResponsibleUser
FROM I_FundBasic
LEFT OUTER JOIN E_Fund AS _Extension ON Fund = _Extension.Fund AND FinancialManagementArea = _Extension.FinancialManagementArea  -- association [1..1]
;