ESH_S_ICMLEAD

DDL: ESH_S_ICMLEAD SQL: ESH_U_ICMLEAD Type: view
20 Fields 1 Data Sources

ESH_S_ICMLEAD is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_ICMLEAD) and exposes 20 fields with key field INVGCSMCASEID.

Data Sources (1)

SourceAliasJoin Type
ESH_N_ICMLEAD ESH_N_ICMLEAD from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
ObjectModel.supportedCapabilities #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
UI.headerInfo.typeName ICM Lead view
UI.headerInfo.typeNamePlural ICM Leads view
Consumption.semanticObject ICMLead view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value INVGCSMCASEID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_ICMLEAD view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY INVGCSMCASEID INVGCSMCASEID Lead ID
CASETYPENAME CASETYPENAME Lead Type
FILEDESCRIPTION FILEDESCRIPTION Description
FILENAME FILENAME URL or Filenam Path
FIRSTNAME FIRSTNAME First Name
INVGCSMCASEPHASETEXT INVGCSMCASEPHASETEXT Status
INVGCSMCASETITLE INVGCSMCASETITLE Lead Title
INVGCSMCASETYPE INVGCSMCASETYPE
INVGCSMCASEUUID INVGCSMCASEUUID
INVGCSMCATEGORYDESC INVGCSMCATEGORYDESC Category
INVGCSMPARTNERNUMBER INVGCSMPARTNERNUMBER
INVGCSMPROCESSFORCASETYPE INVGCSMPROCESSFORCASETYPE
INVGCSMSECURITYLEVEL INVGCSMSECURITYLEVEL
INVGCSMSECURITYLVLDESC INVGCSMSECURITYLVLDESC Security Level
LASTNAME LASTNAME Last Name
ORGANIZATIONBPNAME1 ORGANIZATIONBPNAME1 Organization Name 1
ORGANIZATIONBPNAME2 ORGANIZATIONBPNAME2 Organization Name 2
DOCUMENTTEXT DOCUMENTTEXT Text ID
RELATIONNOTE RELATIONNOTE Relation Note
PLAINLONGTEXT PLAINLONGTEXT Note

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_ICMLEAD.
-- 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_ICMLEAD
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_ICMLEAD AS
SELECT
  INVGCSMCASEID,
  CASETYPENAME,
  FILEDESCRIPTION,
  FILENAME,
  FIRSTNAME,
  INVGCSMCASEPHASETEXT,
  INVGCSMCASETITLE,
  INVGCSMCASETYPE,
  INVGCSMCASEUUID,
  INVGCSMCATEGORYDESC,
  INVGCSMPARTNERNUMBER,
  INVGCSMPROCESSFORCASETYPE,
  INVGCSMSECURITYLEVEL,
  INVGCSMSECURITYLVLDESC,
  LASTNAME,
  ORGANIZATIONBPNAME1,
  ORGANIZATIONBPNAME2,
  DOCUMENTTEXT,
  RELATIONNOTE,
  PLAINLONGTEXT
FROM ESH_N_ICMLEAD
;

Learn More