R_FundCoreTP

DDL: R_FUNDCORETP Type: view_entity TRANSACTIONAL Package: PSM_S4C_API
20 Fields 1 Data Sources 4 Associations

Manage Funds in Core using RAP

R_FundCoreTP is a Transactional CDS View that provides data about "Manage Funds in Core using RAP" in SAP S/4HANA. It reads from 1 data source (I_Fund) and exposes 20 fields with key fields FinancialManagementArea, Fund. It has 4 associations to related views. Part of development package PSM_S4C_API.

Data Sources (1)

SourceAliasJoin Type
I_Fund iFund from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_User _user_created $projection.FundCreatedBy = _user_created.UserID
[0..1] I_User _user_changed $projection.LastChangedByUser = _user_changed.UserID
[0..1] E_Fund _Extension $projection.Fund = _Extension.Fund and $projection.FinancialManagementArea = _Extension.FinancialManagementArea
[0..*] R_FundCoreTextTP _Text

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.sapObjectNodeType.name Fund view
EndUserText.label Manage Funds in Core using RAP view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea I_Fund FinancialManagementArea FM Area
KEY Fund I_Fund Fund Sender Fund
FundType I_Fund FundType Fund Type
FundPeriodicity I_Fund FundPeriodicity
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
FundName
FundDescription
FundFinMgmtAreaForAuthzn
FundResponsibleUser I_Fund FundResponsibleUser
_FundAuthznGrp I_Fund _FundAuthznGrp
_FundType I_Fund _FundType
_FinMgmtArea I_Fund _FinMgmtArea
_Text _Text
_FundPeriodicity I_Fund _FundPeriodicity

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_FundCoreTP.
-- 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_FundCoreTP AS
SELECT
  iFund.FinancialManagementArea AS FinancialManagementArea,
  iFund.Fund AS Fund,
  iFund.FundType AS FundType,
  iFund.FundPeriodicity AS FundPeriodicity,
  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._Text[1:Language = $session.system_language].FundName AS FundName,
  iFund._Text[1:Language = $session.system_language].FundDescription AS FundDescription,
  cast ( iFund.FundFinMgmtAreaForAuthzn as fikrs preserving type ) AS FundFinMgmtAreaForAuthzn,
  iFund.FundResponsibleUser AS FundResponsibleUser,
  iFund._FundAuthznGrp AS _FundAuthznGrp,
  iFund._FundType AS _FundType,
  iFund._FinMgmtArea AS _FinMgmtArea,
  iFund._FundPeriodicity AS _FundPeriodicity
FROM I_Fund AS iFund
LEFT OUTER JOIN I_User AS _user_created ON FundCreatedBy = _user_created.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _user_changed ON LastChangedByUser = _user_changed.UserID  -- association [0..1]
LEFT OUTER JOIN E_Fund AS _Extension ON Fund = _Extension.Fund AND FinancialManagementArea = _Extension.FinancialManagementArea  -- association [0..1]
LEFT OUTER JOIN R_FundCoreTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More