A_FundCore

DDL: A_FUNDCORE Type: view_entity COMPOSITE
11 Fields 1 Data Sources 1 Associations 1 OData Services

Fund

A_FundCore is a Composite CDS View that provides data about "Fund" in SAP S/4HANA. It reads from 1 data source (R_FundCoreTP) and exposes 11 fields with key fields FinancialManagementArea, Fund. It has 1 association to related views. It is exposed through 1 OData service (API_FUNDCORE).

Data Sources (1)

SourceAliasJoin Type
R_FundCoreTP R_FundCoreTP projection

Associations (1)

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

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Fund view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
OData.entityType.name FundCore_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view

OData Services (1)

ServiceBindingVersionContractRelease
API_FUNDCORE API_FUNDCORE V2 C2 C1

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY FinancialManagementArea FinancialManagementArea FM Area
KEY Fund Fund Sender Fund
FundType FundType Fund Type
FundPeriodicity FundPeriodicity
FundAuthznGrp FundAuthznGrp
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
FundName FundName Long Text
FundDescription FundDescription
FundFinMgmtAreaForAuthzn FundFinMgmtAreaForAuthzn
FundResponsibleUser FundResponsibleUser

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 A_FundCore.
-- 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 A_FundCore AS
SELECT
  FinancialManagementArea,
  Fund,
  FundType,
  FundPeriodicity,
  FundAuthznGrp,
  ValidityStartDate,
  ValidityEndDate,
  FundName,
  FundDescription,
  FundFinMgmtAreaForAuthzn,
  FundResponsibleUser
FROM R_FundCoreTP
LEFT OUTER JOIN E_Fund AS _Extension ON Fund = _Extension.Fund AND FinancialManagementArea = _Extension.FinancialManagementArea  -- association [0..1]
;

Learn More