ESH_S_FUND

DDL: ESH_S_FUND SQL: ESH_U_FUND Type: view Package: ODATA_PSM_S4C_FM_MD
23 Fields 1 Data Sources 1 Associations

Search view -FUND

ESH_S_FUND is a CDS View that provides data about "Search view -FUND" in SAP S/4HANA. It reads from 1 data source (ESH_N_FUND) and exposes 23 fields with key fields FINANCIALMANAGEMENTAREA, FUND. It has 1 association to related views. Part of development package ODATA_PSM_S4C_FM_MD.

Data Sources (1)

SourceAliasJoin Type
ESH_N_FUND ESH_N_FUND from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_FUND _EXTENSION ( $projection.FINANCIALMANAGEMENTAREA = _EXTENSION.FINANCIALMANAGEMENTAREA AND $projection.FUND = _EXTENSION.FUND )

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name Fund view
UI.headerInfo.typeName Fund view
UI.headerInfo.typeNamePlural Funds view
Consumption.semanticObject Fund view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value FUND view
UI.headerInfo.description.value FINANCIALMANAGEMENTAREA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_FUND view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY FINANCIALMANAGEMENTAREA FINANCIALMANAGEMENTAREA FM Area
KEY FUND FUND Sender Fund
BUDGETPERIOD BUDGETPERIOD Budget Period
CUSTOMER CUSTOMER Sold-to Party
FINANCIALMANAGEMENTAREANAME FINANCIALMANAGEMENTAREANAME
FUNDAUTHZNGRP FUNDAUTHZNGRP
FUNDCREATEDAT FUNDCREATEDAT
FUNDCREATEDBY FUNDCREATEDBY
FUNDDESCRIPTION FUNDDESCRIPTION
FUNDEXPIRATIONDATE FUNDEXPIRATIONDATE
FUNDNAME FUNDNAME Long Text
FUNDTYPE FUNDTYPE Fund Type
FUNDTYPEDESCRIPTION FUNDTYPEDESCRIPTION
GRANTEEMGMTFUNDTYPE GRANTEEMGMTFUNDTYPE
GMFUNDTYPE GMFUNDTYPE
GRANTEEMGMTFUNDTYPENAME
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEUSER LASTCHANGEUSER User Name
PERSONFULLNAME PERSONFULLNAME Full Name
CHANGEDBYNAME CHANGEDBYNAME Changed by User Name
CREATEBYNAME CREATEBYNAME Created by User Name
VALIDITYENDDATE VALIDITYENDDATE ValidTo
VALIDITYSTARTDATE VALIDITYSTARTDATE Validity Start Date

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 ESH_S_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: ESH_U_FUND
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_FUND AS
SELECT
  FINANCIALMANAGEMENTAREA,
  FUND,
  BUDGETPERIOD,
  CUSTOMER,
  FINANCIALMANAGEMENTAREANAME,
  FUNDAUTHZNGRP,
  FUNDCREATEDAT,
  FUNDCREATEDBY,
  FUNDDESCRIPTION,
  FUNDEXPIRATIONDATE,
  FUNDNAME,
  FUNDTYPE,
  FUNDTYPEDESCRIPTION,
  GRANTEEMGMTFUNDTYPE,
  GMFUNDTYPE,
  _GRANTEEMGMTFUNDTYPE[1: ddlanguage = $parameters.P_Language ].ddtext AS GRANTEEMGMTFUNDTYPENAME,
  LASTCHANGEDATE,
  LASTCHANGEUSER,
  PERSONFULLNAME,
  CHANGEDBYNAME,
  CREATEBYNAME,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM ESH_N_FUND
LEFT OUTER JOIN E_FUND AS _EXTENSION ON ( FINANCIALMANAGEMENTAREA = _EXTENSION.FINANCIALMANAGEMENTAREA AND FUND = _EXTENSION.FUND )  -- association [0..1]
;

Learn More