ESH_N_FUND

DDL: ESH_N_FUND SQL: ESH_L_FUND Type: view Package: ODATA_PSM_S4C_FM_MD
23 Fields 1 Data Sources 1 Associations

Anchor view -FUND

ESH_N_FUND is a CDS View that provides data about "Anchor view -FUND" in SAP S/4HANA. It reads from 1 data source (I_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
I_FUND I_FUND from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _GRANTEEMGMTFUNDTYPE $projection.GMFUNDTYPE=_GRANTEEMGMTFUNDTYPE.domvalue_l and _GRANTEEMGMTFUNDTYPE.domname='GM_FUNDTYPE' and _GRANTEEMGMTFUNDTYPE.as4local='A'

Annotations (7)

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
AbapCatalog.sqlViewName ESH_L_FUND view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY FINANCIALMANAGEMENTAREA FINANCIALMANAGEMENTAREA FM Area
KEY FUND FUND Sender Fund
BUDGETPERIOD _FUNDTOBUDGETPERIOD BUDGETPERIOD Budget Period
CUSTOMER CUSTOMER Sold-to Party
FINANCIALMANAGEMENTAREANAME
FUNDAUTHZNGRP FUNDAUTHZNGRP
FUNDCREATEDAT FUNDCREATEDAT
FUNDCREATEDBY FUNDCREATEDBY
FUNDDESCRIPTION
FUNDEXPIRATIONDATE FUNDEXPIRATIONDATE
FUNDNAME
FUNDTYPE FUNDTYPE Fund Type
FUNDTYPEDESCRIPTION
GRANTEEMGMTFUNDTYPE _FUNDTYPE GRANTEEMGMTFUNDTYPE
GMFUNDTYPE _FUNDTYPE GRANTEEMGMTFUNDTYPE
_GRANTEEMGMTFUNDTYPE _GRANTEEMGMTFUNDTYPE
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEUSER LASTCHANGEUSER User Name
PERSONFULLNAME
CHANGEDBYNAME _LASTCHANGEDBYUSER USERDESCRIPTION Full Name
CREATEBYNAME _CREATEDBYUSER USERDESCRIPTION Full 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_N_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_L_FUND
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_FUND AS
SELECT
  FINANCIALMANAGEMENTAREA,
  FUND,
  _FUNDTOBUDGETPERIOD.BUDGETPERIOD AS BUDGETPERIOD,
  CUSTOMER,
  _FINMGMTAREA._TEXT[1: LANGUAGE = $parameters. P_Language].FINANCIALMANAGEMENTAREANAME AS FINANCIALMANAGEMENTAREANAME,
  FUNDAUTHZNGRP,
  FUNDCREATEDAT,
  FUNDCREATEDBY,
  _TEXT[1: LANGUAGE = $parameters. P_Language].FUNDDESCRIPTION AS FUNDDESCRIPTION,
  FUNDEXPIRATIONDATE,
  _TEXT[1: LANGUAGE = $parameters. P_Language].FUNDNAME AS FUNDNAME,
  FUNDTYPE,
  _FUNDTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].FUNDTYPEDESCRIPTION AS FUNDTYPEDESCRIPTION,
  _FUNDTYPE.GRANTEEMGMTFUNDTYPE AS GRANTEEMGMTFUNDTYPE,
  _FUNDTYPE.GRANTEEMGMTFUNDTYPE AS GMFUNDTYPE,
  LASTCHANGEDATE,
  LASTCHANGEUSER,
  _CUSTOMER._CUSTOMERTOBUSINESSPARTNER._BUSINESSPARTNER.PERSONFULLNAME AS PERSONFULLNAME,
  _LASTCHANGEDBYUSER.USERDESCRIPTION AS CHANGEDBYNAME,
  _CREATEDBYUSER.USERDESCRIPTION AS CREATEBYNAME,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM I_FUND
LEFT OUTER JOIN dd07t AS _GRANTEEMGMTFUNDTYPE ON GMFUNDTYPE=_GRANTEEMGMTFUNDTYPE.domvalue_l AND _GRANTEEMGMTFUNDTYPE.domname='GM_FUNDTYPE' AND _GRANTEEMGMTFUNDTYPE.as4local='A'  -- association [0..*]
;

Learn More