R_FundTP

DDL: R_FUNDTP Type: view_entity TRANSACTIONAL
29 Fields 1 Data Sources 1 Associations

Manage Fund - TP

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

Data Sources (1)

SourceAliasJoin Type
I_Fund iFund from

Associations (1)

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

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Manage Fund - TP view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_Fund FinancialManagementArea FM Area
KEY Fund I_Fund Fund Sender Fund
Customer I_Fund Customer Sold-to Party
ApplicationOfFunds I_Fund ApplicationOfFunds
FundCreatedBy I_Fund FundCreatedBy
FundCreatedAt I_Fund FundCreatedAt
LastChangedByUser I_Fund LastChangeUser User Name
LastChangeDate I_Fund LastChangeDate Time Stamp
FundAuthznGrp I_Fund FundAuthznGrp
FundFinMgmtAreaForAuthzn I_Fund FundFinMgmtAreaForAuthzn
ValidityStartDate I_Fund ValidityStartDate Validity Start Date
ValidityEndDate I_Fund ValidityEndDate ValidTo
FundReversalDate I_Fund FundReversalDate
FundExpirationDate I_Fund FundExpirationDate
FundType I_Fund FundType Fund Type
FundPeriodicity I_Fund FundPeriodicity
FundName
FundDescription
_FinMgmtArea I_Fund _FinMgmtArea
_Customer I_Fund _Customer
_ApplicationOfFund I_Fund _ApplicationOfFund
_CreatedByUser I_Fund _CreatedByUser
_LastChangedByUser I_Fund _LastChangedByUser
_FundAuthznGrp I_Fund _FundAuthznGrp
_FundType I_Fund _FundType
_FundPeriodicity I_Fund _FundPeriodicity
_FundHierarchyNode I_Fund _FundHierarchyNode
_FundToBudgetPeriod I_Fund _FundToBudgetPeriod
_Text I_Fund _Text

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

CREATE VIEW R_FundTP AS
SELECT
  iFund.FinancialManagementArea AS FinancialManagementArea,
  iFund.Fund AS Fund,
  iFund.Customer AS Customer,
  iFund.ApplicationOfFunds AS ApplicationOfFunds,
  iFund.FundCreatedBy AS FundCreatedBy,
  iFund.FundCreatedAt AS FundCreatedAt,
  iFund.LastChangeUser AS LastChangedByUser,
  iFund.LastChangeDate AS LastChangeDate,
  iFund.FundAuthznGrp AS FundAuthznGrp,
  iFund.FundFinMgmtAreaForAuthzn AS FundFinMgmtAreaForAuthzn,
  iFund.ValidityStartDate AS ValidityStartDate,
  iFund.ValidityEndDate AS ValidityEndDate,
  iFund.FundReversalDate AS FundReversalDate,
  iFund.FundExpirationDate AS FundExpirationDate,
  iFund.FundType AS FundType,
  iFund.FundPeriodicity AS FundPeriodicity,
  iFund._Text[1:Language = $session.system_language].FundName AS FundName,
  iFund._Text[1:Language = $session.system_language].FundDescription AS FundDescription,
  iFund._FinMgmtArea AS _FinMgmtArea,
  iFund._Customer AS _Customer,
  iFund._ApplicationOfFund AS _ApplicationOfFund,
  iFund._CreatedByUser AS _CreatedByUser,
  iFund._LastChangedByUser AS _LastChangedByUser,
  iFund._FundAuthznGrp AS _FundAuthznGrp,
  iFund._FundType AS _FundType,
  iFund._FundPeriodicity AS _FundPeriodicity,
  iFund._FundHierarchyNode AS _FundHierarchyNode,
  iFund._FundToBudgetPeriod AS _FundToBudgetPeriod,
  iFund._Text AS _Text
FROM I_Fund AS iFund
LEFT OUTER JOIN E_Fund AS _Extension ON FinancialManagementArea = _Extension.FinancialManagementArea AND Fund = _Extension.Fund  -- association [1..1]
;

Learn More