ESH_S_FUNDS_CTR

DDL: ESH_S_FUNDS_CTR SQL: ESH_U_FUNDS_CTR Type: view
17 Fields 1 Data Sources 1 Associations

ESH_S_FUNDS_CTR is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_FUNDS_CTR) and exposes 17 fields with key fields FINANCIALMANAGEMENTAREA, FUNDSCENTER, VALIDITYENDDATE. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ESH_N_FUNDS_CTR ESH_N_FUNDS_CTR from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_FUNDSCENTER _EXTENSION ( $projection.FINANCIALMANAGEMENTAREA = _EXTENSION.FINANCIALMANAGEMENTAREA AND $projection.FUNDSCENTER = _EXTENSION.FUNDSCENTER AND $projection.VALIDITYENDDATE = _EXTENSION.VALIDITYENDDATE )

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name FundsCenter view
UI.headerInfo.typeName Funds Center view
UI.headerInfo.typeNamePlural Funds Centers view
Consumption.semanticObject FundsCenter view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value FUNDSCENTER view
UI.headerInfo.description.value FINANCIALMANAGEMENTAREA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_FUNDS_CTR view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY FINANCIALMANAGEMENTAREA FINANCIALMANAGEMENTAREA FM Area
KEY FUNDSCENTER FUNDSCENTER Funds Center
KEY VALIDITYENDDATE VALIDITYENDDATE ValidTo
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
FUNDSCENTERAUTHZNGRP FUNDSCENTERAUTHZNGRP Authorization Group
FUNDSCENTERDEFAULTFUND FUNDSCENTERDEFAULTFUND Default Fund
FUNDSCENTERDESCRIPTION FUNDSCENTERDESCRIPTION
FUNDSCENTEREXPIRATIONDATE FUNDSCENTEREXPIRATIONDATE
FUNDSCENTERNAME FUNDSCENTERNAME
FUNDSCENTERRESPONSIBLE FUNDSCENTERRESPONSIBLE User Name
FUNDSCENTERRESPONSIBLENAME FUNDSCENTERRESPONSIBLENAME Person Responsible
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEUSER LASTCHANGEUSER User Name
CHANGEDBY CHANGEDBY Changed by User Name
CREATEDBY CREATEDBY Created by User Name
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_FUNDS_CTR.
-- 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_FUNDS_CTR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_FUNDS_CTR AS
SELECT
  FINANCIALMANAGEMENTAREA,
  FUNDSCENTER,
  VALIDITYENDDATE,
  CREATEDBYUSER,
  CREATIONDATE,
  FUNDSCENTERAUTHZNGRP,
  FUNDSCENTERDEFAULTFUND,
  FUNDSCENTERDESCRIPTION,
  FUNDSCENTEREXPIRATIONDATE,
  FUNDSCENTERNAME,
  FUNDSCENTERRESPONSIBLE,
  FUNDSCENTERRESPONSIBLENAME,
  LASTCHANGEDATE,
  LASTCHANGEUSER,
  CHANGEDBY,
  CREATEDBY,
  VALIDITYSTARTDATE
FROM ESH_N_FUNDS_CTR
LEFT OUTER JOIN E_FUNDSCENTER AS _EXTENSION ON ( FINANCIALMANAGEMENTAREA = _EXTENSION.FINANCIALMANAGEMENTAREA AND FUNDSCENTER = _EXTENSION.FUNDSCENTER AND VALIDITYENDDATE = _EXTENSION.VALIDITYENDDATE )  -- association [0..1]
;

Learn More