ESH_S_FAREA

DDL: ESH_S_FAREA SQL: ESH_U_FAREA Type: view
14 Fields 1 Data Sources 1 Associations

ESH_S_FAREA is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_FAREA) and exposes 14 fields with key field FUNCTIONALAREA. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ESH_N_FAREA ESH_N_FAREA from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_FNDSMGMTFUNCTIONALAREA _EXTENSION ( $projection.FUNCTIONALAREA = _EXTENSION.FUNCTIONALAREA )

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L 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 FunctionalArea view
UI.headerInfo.typeName Functional Area view
UI.headerInfo.typeNamePlural Functional Areas view
Consumption.semanticObject FunctionalArea view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value FUNCTIONALAREA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_FAREA view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY FUNCTIONALAREA FUNCTIONALAREA Sendr Fctl Area
CREATEDBYUSER CREATEDBYUSER User Name
CREATIONDATE CREATIONDATE Time Stamp
CREATIONTIME CREATIONTIME Time of Change
EXPIRATIONDATE EXPIRATIONDATE Expiratn Date
FUNCTIONALAREAAUTHZNGRP FUNCTIONALAREAAUTHZNGRP
FUNCTIONALAREANAME FUNCTIONALAREANAME Long Text
LASTCHANGEDATE LASTCHANGEDATE Time Stamp
LASTCHANGEDBYUSER LASTCHANGEDBYUSER User Name
LASTCHANGETIME LASTCHANGETIME Time changed
CREATEDBYUSERNAME CREATEDBYUSERNAME Created by User Name
LASTCHANGEDBYUSERNAME LASTCHANGEDBYUSERNAME Changed 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_FAREA.
-- 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_FAREA
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_FAREA AS
SELECT
  FUNCTIONALAREA,
  CREATEDBYUSER,
  CREATIONDATE,
  CREATIONTIME,
  EXPIRATIONDATE,
  FUNCTIONALAREAAUTHZNGRP,
  FUNCTIONALAREANAME,
  LASTCHANGEDATE,
  LASTCHANGEDBYUSER,
  LASTCHANGETIME,
  CREATEDBYUSERNAME,
  LASTCHANGEDBYUSERNAME,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM ESH_N_FAREA
LEFT OUTER JOIN E_FNDSMGMTFUNCTIONALAREA AS _EXTENSION ON ( FUNCTIONALAREA = _EXTENSION.FUNCTIONALAREA )  -- association [0..1]
;

Learn More