I_FundTP

DDL: I_FUNDTP SQL: IFUNDTP Type: view TRANSACTIONAL
24 Fields 1 Data Sources 4 Associations

Manage Fund

I_FundTP is a Transactional CDS View that provides data about "Manage Fund" in SAP S/4HANA. It reads from 1 data source (I_Fund) and exposes 24 fields with key fields FinancialManagementArea, Fund. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Fund iFund from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_FundToBudgetPeriodTP _FundToBP $projection.FinancialManagementArea = _FundToBP.FinancialManagementArea and $projection.Fund = _FundToBP.Fund
[0..1] I_ApplicationOfFund _ApplOfFund $projection.FinancialManagementArea = _ApplOfFund.FinancialManagementArea and $projection.ApplicationOfFunds = _ApplOfFund.ApplicationOfFunds
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[1..1] E_Fund _Extension $projection.FinancialManagementArea = _Extension.FinancialManagementArea and $projection.Fund = _Extension.Fund

Annotations (23)

NameValueLevelField
AbapCatalog.sqlViewName IFUNDTP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Fund view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.modelCategory #BUSINESS_OBJECT view
ObjectModel.createEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.representativeKey Fund view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence FMFUND_DRAFT view
ObjectModel.entityChangeStateId EXTERNAL_CALCULATION view
ObjectModel.lifecycle.draft.expiryBehavior #RELATIVE_TO_PROCESSING_START view
ObjectModel.lifecycle.draft.expiryInterval P5D view
ObjectModel.sapObjectNodeType.name Fund view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_Fund FinancialManagementArea FM Area
KEY Fund I_Fund Fund Sender Fund
FinancialManagementAreaForEdit I_Fund FinancialManagementArea FM Area
FundForEdit I_Fund Fund Sender Fund
FundType I_Fund FundType Fund Type
Customer I_Fund Customer Sold-to Party
ApplicationOfFunds I_Fund ApplicationOfFunds
FundAuthznGrp I_Fund FundAuthznGrp
FundCreatedBy I_Fund FundCreatedBy
FundCreatedAt I_Fund FundCreatedAt
LastChangedByUser I_Fund LastChangeUser User Name
LastChangeDate I_Fund LastChangeDate Time Stamp
ValidityStartDate I_Fund ValidityStartDate Validity Start Date
ValidityEndDate I_Fund ValidityEndDate ValidTo
FundReversalDate I_Fund FundReversalDate
FundExpirationDate I_Fund FundExpirationDate
FundName
FundDescription
FundFinMgmtAreaForAuthzn I_Fund FundFinMgmtAreaForAuthzn
_FundToBP _FundToBP
_FundType I_Fund _FundType
_FinMgmtArea I_Fund _FinMgmtArea
_ApplOfFund _ApplOfFund
_Customer _Customer

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_FundTP.
-- 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: IFUNDTP

CREATE VIEW I_FundTP AS
SELECT
  iFund.FinancialManagementArea AS FinancialManagementArea,
  iFund.Fund AS Fund,
  iFund.FinancialManagementArea AS FinancialManagementAreaForEdit,
  iFund.Fund AS FundForEdit,
  iFund.FundType AS FundType,
  iFund.Customer AS Customer,
  iFund.ApplicationOfFunds AS ApplicationOfFunds,
  iFund.FundAuthznGrp AS FundAuthznGrp,
  iFund.FundCreatedBy AS FundCreatedBy,
  iFund.FundCreatedAt AS FundCreatedAt,
  iFund.LastChangeUser AS LastChangedByUser,
  iFund.LastChangeDate AS LastChangeDate,
  iFund.ValidityStartDate AS ValidityStartDate,
  iFund.ValidityEndDate AS ValidityEndDate,
  iFund.FundReversalDate AS FundReversalDate,
  iFund.FundExpirationDate AS FundExpirationDate,
  iFund._Text[1:Language = $session.system_language].FundName AS FundName,
  iFund._Text[1:Language = $session.system_language].FundDescription AS FundDescription,
  iFund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  iFund._FundType AS _FundType,
  iFund._FinMgmtArea AS _FinMgmtArea
FROM I_Fund AS iFund
LEFT OUTER JOIN I_FundToBudgetPeriodTP AS _FundToBP ON FinancialManagementArea = _FundToBP.FinancialManagementArea AND Fund = _FundToBP.Fund  -- association [0..*]
LEFT OUTER JOIN I_ApplicationOfFund AS _ApplOfFund ON FinancialManagementArea = _ApplOfFund.FinancialManagementArea AND ApplicationOfFunds = _ApplOfFund.ApplicationOfFunds  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN E_Fund AS _Extension ON FinancialManagementArea = _Extension.FinancialManagementArea AND Fund = _Extension.Fund  -- association [1..1]
;

Learn More