ESH_N_FUNDED_PRG

DDL: ESH_N_FUNDED_PRG SQL: ESH_L_FUNDED_PRG Type: view
19 Fields 1 Data Sources

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

Data Sources (1)

SourceAliasJoin Type
I_FUNDEDPROGRAM I_FUNDEDPROGRAM from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

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
AbapCatalog.sqlViewName ESH_L_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
FUNDEDPROGRAMAUTHZNGRP FUNDEDPROGRAMAUTHZNGRP
FUNDEDPROGRAMDESCRIPT
FUNDEDPROGRAMEXPIRATIONDATE FUNDEDPROGRAMEXPIRATIONDATE
FUNDEDPROGRAMNAME
FUNDEDPROGRAMTYPE FUNDEDPROGRAMTYPE
FUNDEDPROGRAMTYPENAME
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEDBYUSER LASTCHANGEDBYUSER User Name
LASTCHANGETIME LASTCHANGETIME Time changed
CHANGEDBYUSERNAME _LASTCHANGEDBYUSER USERDESCRIPTION Full Name
CREATEDBYUSERNAME _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_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_L_FUNDED_PRG
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_FUNDED_PRG AS
SELECT
  FINANCIALMANAGEMENTAREA,
  FUNDEDPROGRAM,
  CREATEDBYUSER,
  CREATIONDATE,
  CREATIONTIME,
  _FINMGMTAREA._TEXT[1: LANGUAGE = $parameters. P_Language].FINANCIALMANAGEMENTAREANAME AS FMAREANAME,
  FUNDEDPROGRAMAUTHZNGRP,
  _TEXT[1: LANGUAGE = $parameters. P_Language].FUNDEDPROGRAMDESCRIPTION AS FUNDEDPROGRAMDESCRIPT,
  FUNDEDPROGRAMEXPIRATIONDATE,
  _TEXT[1: LANGUAGE = $parameters. P_Language].FUNDEDPROGRAMNAME AS FUNDEDPROGRAMNAME,
  FUNDEDPROGRAMTYPE,
  _FUNDEDPROGRAMTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].FUNDEDPROGRAMTYPENAME AS FUNDEDPROGRAMTYPENAME,
  LASTCHANGEDATE,
  LASTCHANGEDBYUSER,
  LASTCHANGETIME,
  _LASTCHANGEDBYUSER.USERDESCRIPTION AS CHANGEDBYUSERNAME,
  _CREATEDBYUSER.USERDESCRIPTION AS CREATEDBYUSERNAME,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM I_FUNDEDPROGRAM
;

Learn More