ESH_N_VIEWBROWSER

DDL: ESH_N_VIEWBROWSER SQL: ESH_L_VIEWBROWSE Type: view Package: S_ESH_VB
21 Fields 1 Data Sources

Anchor view -VIEWBROWSER

ESH_N_VIEWBROWSER is a CDS View that provides data about "Anchor view -VIEWBROWSER" in SAP S/4HANA. It reads from 1 data source (I_VIEWBROWSER) and exposes 21 fields with key field CDSVIEW. Part of development package S_ESH_VB.

Data Sources (1)

SourceAliasJoin Type
I_VIEWBROWSER I_VIEWBROWSER from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ESH_L_VIEWBROWSE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CDSVIEW CDSVIEW CDS View
APPLICATIONCOMPONENT APPLICATIONCOMPONENT
APPLICATIONCOMPONENTDESC APPLICATIONCOMPONENTDESC
BUSINESSCONTEXT BUSINESSCONTEXT
BUSINESSCONTEXTDESC BUSINESSCONTEXTDESC
CDSDESCRIPTION CDSDESCRIPTION Short text
CDSV1DIRECTBASEOBJECT CDSV1DIRECTBASEOBJECT
CDSV2DIRECTBASEOBJECT CDSV2DIRECTBASEOBJECT
CDSVIEWRAW CDSVIEWRAW DD: Original Name of a Struct. Obj. (e.g. Entity, Context)
EXTENSIONINCLUDEVIEWNAME EXTENSIONINCLUDEVIEWNAME
FEATUREANNOVALUE FEATUREANNOVALUE
FIELDDESCRIPTION FIELDDESCRIPTION
FIELDNAME FIELDNAME UI Group FieldName
MODELINGPATTERNDESC MODELINGPATTERNDESC Well Code Des.
MODELINGPATTERNVALUE MODELINGPATTERNVALUE
RELEASECONTRACT RELEASECONTRACT
RELEASECONTRACTDESC RELEASECONTRACTDESC
RELEASESTATE RELEASESTATE
SAPOBJECTNODETYPE SAPOBJECTNODETYPE SONT Name
SUPPORTEDCAPABILITIESDESC SUPPORTEDCAPABILITIESDESC Well Code Des.
SUPPORTEDCAPABILITIESVALUE SUPPORTEDCAPABILITIESVALUE

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_VIEWBROWSER.
-- 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_VIEWBROWSE

CREATE VIEW ESH_N_VIEWBROWSER AS
SELECT
  CDSVIEW,
  APPLICATIONCOMPONENT,
  APPLICATIONCOMPONENTDESC,
  BUSINESSCONTEXT,
  BUSINESSCONTEXTDESC,
  CDSDESCRIPTION,
  CDSV1DIRECTBASEOBJECT,
  CDSV2DIRECTBASEOBJECT,
  CDSVIEWRAW,
  EXTENSIONINCLUDEVIEWNAME,
  FEATUREANNOVALUE,
  FIELDDESCRIPTION,
  FIELDNAME,
  MODELINGPATTERNDESC,
  MODELINGPATTERNVALUE,
  RELEASECONTRACT,
  RELEASECONTRACTDESC,
  RELEASESTATE,
  SAPOBJECTNODETYPE,
  SUPPORTEDCAPABILITIESDESC,
  SUPPORTEDCAPABILITIESVALUE
FROM I_VIEWBROWSER
;

Learn More