ESH_S_FUNDED_PRG

DDL: ESH_S_FUNDED_PRG SQL: ESH_U_FUNDED_PRG Type: view
19 Fields 1 Data Sources 1 Associations

ESH_S_FUNDED_PRG is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_FUNDED_PRG) and exposes 19 fields with key fields FINANCIALMANAGEMENTAREA, FUNDEDPROGRAM. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ESH_N_FUNDED_PRG ESH_N_FUNDED_PRG from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_FUNDEDPROGRAM _EXTENSION $projection.FINANCIALMANAGEMENTAREA = _EXTENSION.FINANCIALMANAGEMENTAREA AND $projection.FUNDEDPROGRAM = _EXTENSION.FUNDEDPROGRAM

Annotations (20)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
ObjectModel.supportedCapabilities #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
UI.headerInfo.typeName Funded Program view
UI.headerInfo.typeNamePlural Funded Programs view
Consumption.semanticObject FundedProgram view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value FUNDEDPROGRAM view
UI.headerInfo.description.type #AS_CONNECTED_FIELDS view
UI.headerInfo.description.valueQualifier Group2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_FUNDED_PRG view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY FINANCIALMANAGEMENTAREA FINANCIALMANAGEMENTAREA FM Area
KEY FUNDEDPROGRAM FUNDEDPROGRAM Funded Program
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
CREATIONTIME CREATIONTIME Time of Change
FMAREANAME FMAREANAME FM Area Name
FUNDEDPROGRAMAUTHZNGRP FUNDEDPROGRAMAUTHZNGRP
FUNDEDPROGRAMDESCRIPT FUNDEDPROGRAMDESCRIPT
FUNDEDPROGRAMEXPIRATIONDATE FUNDEDPROGRAMEXPIRATIONDATE
FUNDEDPROGRAMNAME FUNDEDPROGRAMNAME
FUNDEDPROGRAMTYPE FUNDEDPROGRAMTYPE
FUNDEDPROGRAMTYPENAME FUNDEDPROGRAMTYPENAME Funded Program Type Description
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEDBYUSER LASTCHANGEDBYUSER User Name
LASTCHANGETIME LASTCHANGETIME Time changed
CHANGEDBYUSERNAME CHANGEDBYUSERNAME Changed by User Name
CREATEDBYUSERNAME CREATEDBYUSERNAME 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_FUNDED_PRG.
-- 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_FUNDED_PRG
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_FUNDED_PRG AS
SELECT
  FINANCIALMANAGEMENTAREA,
  FUNDEDPROGRAM,
  CREATEDBYUSER,
  CREATIONDATE,
  CREATIONTIME,
  FMAREANAME,
  FUNDEDPROGRAMAUTHZNGRP,
  FUNDEDPROGRAMDESCRIPT,
  FUNDEDPROGRAMEXPIRATIONDATE,
  FUNDEDPROGRAMNAME,
  FUNDEDPROGRAMTYPE,
  FUNDEDPROGRAMTYPENAME,
  LASTCHANGEDATE,
  LASTCHANGEDBYUSER,
  LASTCHANGETIME,
  CHANGEDBYUSERNAME,
  CREATEDBYUSERNAME,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM ESH_N_FUNDED_PRG
LEFT OUTER JOIN E_FUNDEDPROGRAM AS _EXTENSION ON FINANCIALMANAGEMENTAREA = _EXTENSION.FINANCIALMANAGEMENTAREA AND FUNDEDPROGRAM = _EXTENSION.FUNDEDPROGRAM  -- association [0..1]
;

Learn More