ESH_S_QUALITYNOTIFICATION

DDL: ESH_S_QUALITYNOTIFICATION SQL: ESH_U_QLTYNOTIF Type: view
31 Fields 1 Data Sources

ESH_S_QUALITYNOTIFICATION is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_QUALITYNOTIFICATION) and exposes 31 fields with key field QUALITYNOTIFICATION.

Data Sources (1)

SourceAliasJoin Type
ESH_N_QUALITYNOTIFICATION ESH_N_QUALITYNOTIFICATION from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name QualityNotification view
UI.headerInfo.typeName Quality Notification view
UI.headerInfo.typeNamePlural Quality Notifications view
Consumption.semanticObject QualityNotification view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value QUALITYNOTIFICATION view
UI.headerInfo.description.value NOTIFICATIONTYPENAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_QLTYNOTIF view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY QUALITYNOTIFICATION QUALITYNOTIFICATION
CREATIONDATE CREATIONDATE Time Stamp
ISBUSINESSPURPOSECOMPLETED ISBUSINESSPURPOSECOMPLETED Purpose Completed
ISDELETED ISDELETED TRUE
LASTCHANGEDDATE LASTCHANGEDDATE Created On
MATERIAL MATERIAL Vehicle Model
MATERIALGROUP MATERIALGROUP Material Group
MATERIALGROUPNAME MATERIALGROUPNAME Material Group Text
NOTIFICATIONCODEGROUP NOTIFICATIONCODEGROUP
NOTIFICATIONCODEGROUPTEXT NOTIFICATIONCODEGROUPTEXT
NOTIFICATIONCODEID NOTIFICATIONCODEID
NOTIFICATIONCODETEXT NOTIFICATIONCODETEXT
NOTIFICATIONCOMPLETIONDATE NOTIFICATIONCOMPLETIONDATE Completion Date
NOTIFICATIONORIGIN NOTIFICATIONORIGIN
NOTIFICATIONPRIORITY NOTIFICATIONPRIORITY
NOTIFICATIONPRIORITYTEXT NOTIFICATIONPRIORITYTEXT
NOTIFICATIONREPORTINGDATE NOTIFICATIONREPORTINGDATE
NOTIFICATIONTEXT NOTIFICATIONTEXT Description
NOTIFICATIONTYPE NOTIFICATIONTYPE Notifictn Type
NOTIFICATIONTYPENAME NOTIFICATIONTYPENAME
NOTIFPROCESSINGPHASE NOTIFPROCESSINGPHASE Main Status
NOTIFPROCESSINGPHASEDESC NOTIFPROCESSINGPHASEDESC Main Status Text
PLANT PLANT Valuation Area
PLANTNAME PLANTNAME Plant Name
PRODUCTHIERARCHY PRODUCTHIERARCHY Prod.hierarchy
PRODUCTHIERARCHYTEXT PRODUCTHIERARCHYTEXT
PRODUCTNAME PRODUCTNAME Material Description
QLTYNOTIFICATIONLONGTEXT QLTYNOTIFICATIONLONGTEXT
SUPPLIER SUPPLIER Supplier
USERCHANGED USERCHANGED Changed By
USERCREATED USERCREATED Created By

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

CREATE VIEW ESH_S_QUALITYNOTIFICATION AS
SELECT
  QUALITYNOTIFICATION,
  CREATIONDATE,
  ISBUSINESSPURPOSECOMPLETED,
  ISDELETED,
  LASTCHANGEDDATE,
  MATERIAL,
  MATERIALGROUP,
  MATERIALGROUPNAME,
  NOTIFICATIONCODEGROUP,
  NOTIFICATIONCODEGROUPTEXT,
  NOTIFICATIONCODEID,
  NOTIFICATIONCODETEXT,
  NOTIFICATIONCOMPLETIONDATE,
  NOTIFICATIONORIGIN,
  NOTIFICATIONPRIORITY,
  NOTIFICATIONPRIORITYTEXT,
  NOTIFICATIONREPORTINGDATE,
  NOTIFICATIONTEXT,
  NOTIFICATIONTYPE,
  NOTIFICATIONTYPENAME,
  NOTIFPROCESSINGPHASE,
  NOTIFPROCESSINGPHASEDESC,
  PLANT,
  PLANTNAME,
  PRODUCTHIERARCHY,
  PRODUCTHIERARCHYTEXT,
  PRODUCTNAME,
  QLTYNOTIFICATIONLONGTEXT,
  SUPPLIER,
  USERCHANGED,
  USERCREATED
FROM ESH_N_QUALITYNOTIFICATION
;

Learn More