ESH_S_VIEWBROWSER

DDL: ESH_S_VIEWBROWSER SQL: ESH_U_VIEWBROWSE Type: view Package: S_ESH_VB
21 Fields 1 Data Sources

Search view -VIEWBROWSER

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

Data Sources (1)

SourceAliasJoin Type
ESH_N_VIEWBROWSER ESH_N_VIEWBROWSER from

Annotations (17)

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
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
UI.headerInfo.typeName CDS View view
UI.headerInfo.typeNamePlural CDS Views view
Consumption.semanticObject CDSView view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value CDSVIEWRAW view
UI.headerInfo.description.value CDSDESCRIPTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_VIEWBROWSE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CDSVIEW CDSVIEW CDS View Name
APPLICATIONCOMPONENT APPLICATIONCOMPONENT Application Component
APPLICATIONCOMPONENTDESC APPLICATIONCOMPONENTDESC Application Component Description
BUSINESSCONTEXT BUSINESSCONTEXT Business Context
BUSINESSCONTEXTDESC BUSINESSCONTEXTDESC Business Context Description
CDSDESCRIPTION CDSDESCRIPTION CDS View Description
CDSV1DIRECTBASEOBJECT CDSV1DIRECTBASEOBJECT Data Source/Database Table
CDSV2DIRECTBASEOBJECT CDSV2DIRECTBASEOBJECT Data Source/Database Table
CDSVIEWRAW CDSVIEWRAW CDS View
EXTENSIONINCLUDEVIEWNAME EXTENSIONINCLUDEVIEWNAME Extension Include View
FEATUREANNOVALUE FEATUREANNOVALUE Business Feature/Switch/Feature Toggle
FIELDDESCRIPTION FIELDDESCRIPTION Field Description
FIELDNAME FIELDNAME Field Name
MODELINGPATTERNDESC MODELINGPATTERNDESC Modeling Pattern Description
MODELINGPATTERNVALUE MODELINGPATTERNVALUE Modeling Pattern
RELEASECONTRACT RELEASECONTRACT Release Contract
RELEASECONTRACTDESC RELEASECONTRACTDESC Release Contract Description
RELEASESTATE RELEASESTATE
SAPOBJECTNODETYPE SAPOBJECTNODETYPE SAP Object Node Type
SUPPORTEDCAPABILITIESDESC SUPPORTEDCAPABILITIESDESC Supported Capabilities Description
SUPPORTEDCAPABILITIESVALUE SUPPORTEDCAPABILITIESVALUE Supported Capabilities

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_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_U_VIEWBROWSE

CREATE VIEW ESH_S_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 ESH_N_VIEWBROWSER
;

Learn More