P_ESHSEARCHVIEWCE

DDL: P_ESHSEARCHVIEWCE SQL: PESHVIEWCE Type: view BASIC
15 Fields 2 Data Sources

P_ESHSEARCHVIEWCE is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (P_ESHSEARCHVIEW, P_ESHSEARCHVIEWSCOPE) and exposes 15 fields with key field DDLName.

Data Sources (2)

SourceAliasJoin Type
P_ESHSEARCHVIEW _cdsview left_outer
P_ESHSEARCHVIEWSCOPE _eshscopeview from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PESHVIEWCE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY DDLName P_ESHSEARCHVIEWSCOPE DDLName DDL Source Name
ApplicationComponentName P_ESHSEARCHVIEW ApplicationComponentName
ApplicationComponentText P_ESHSEARCHVIEW ApplicationComponentText
CDSPackage P_ESHSEARCHVIEW CDSPackage
CDSViewName P_ESHSEARCHVIEW CDSViewName CDS View Name
LastChangeDate P_ESHSEARCHVIEW LastChangeDate Time Stamp
LastChangeTime P_ESHSEARCHVIEW LastChangeTime Time changed
LastChangeUser P_ESHSEARCHVIEW LastChangeUser User Name
SemanticObject P_ESHSEARCHVIEW SemanticObject Semantic Object
ModelName P_ESHSEARCHVIEW ModelName Provider
Origin P_ESHSEARCHVIEW Origin Task Origin
SQLViewName P_ESHSEARCHVIEW SQLViewName View Name
CONNECTORNAME P_ESHSEARCHVIEW CONNECTORNAME Search Connector ID
STATUS P_ESHSEARCHVIEW STATUS Workflow Status
InScope P_ESHSEARCHVIEWSCOPE InScope

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 P_ESHSEARCHVIEWCE.
-- 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: PESHVIEWCE

CREATE VIEW P_ESHSEARCHVIEWCE AS
SELECT
  _eshscopeview.DDLName AS DDLName,
  _cdsview.ApplicationComponentName AS ApplicationComponentName,
  _cdsview.ApplicationComponentText AS ApplicationComponentText,
  _cdsview.CDSPackage AS CDSPackage,
  _cdsview.CDSViewName AS CDSViewName,
  _cdsview.LastChangeDate AS LastChangeDate,
  _cdsview.LastChangeTime AS LastChangeTime,
  _cdsview.LastChangeUser AS LastChangeUser,
  _cdsview.SemanticObject AS SemanticObject,
  _cdsview.ModelName AS ModelName,
  _cdsview.Origin AS Origin,
  _cdsview.SQLViewName AS SQLViewName,
  _cdsview.CONNECTORNAME AS CONNECTORNAME,
  _cdsview.STATUS AS STATUS,
  _eshscopeview.InScope AS InScope
FROM P_ESHSEARCHVIEWSCOPE AS _eshscopeview
LEFT OUTER JOIN P_ESHSEARCHVIEW AS _cdsview ON /* join condition not captured in parsed metadata */
;

Learn More