I_QltyNotificationVH

DDL: I_QLTYNOTIFICATIONVH SQL: IQLTYNOTIFVH Type: view COMPOSITE
33 Fields 1 Data Sources

Search help for Quality Notification

I_QltyNotificationVH is a Composite CDS View that provides data about "Search help for Quality Notification" in SAP S/4HANA. It reads from 1 data source (I_QltyNotification) and exposes 33 fields with key field QualityNotification.

Data Sources (1)

SourceAliasJoin Type
I_QltyNotification I_QltyNotification from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IQLTYNOTIFVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Search help for Quality Notification view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey QualityNotification view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
Consumption.ranked true view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification QualityNotification Notification
NotificationOrigin NotificationOrigin
NotificationType NotificationType Notifictn Type
NotificationTypeName
NotifProcessingPhase NotifProcessingPhase Notif. Phase
NotifProcessingPhaseDesc
NotificationText NotificationText Description
NotificationPriorityType NotificationPriorityType
NotificationPriority NotificationPriority
NotificationPriorityText
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedDate LastChangedDate Created On
NotificationReportingDate NotificationReportingDate
NotificationCompletionDate NotificationCompletionDate Completion Date
Supplier Supplier Supplier
Customer Customer Sold-to Party
Material Material Vehicle Model
ProductName
Plant Plant Valuation Area
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
ActiveDivision ActiveDivision
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
WBSElement _WBSElement WBSElement WBS Internal ID
_Supplier _Supplier
_Product _Product
_Plant _Plant
_PurchasingDocument _PurchasingDocument

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 I_QltyNotificationVH.
-- 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: IQLTYNOTIFVH

CREATE VIEW I_QltyNotificationVH AS
SELECT
  QualityNotification,
  NotificationOrigin,
  NotificationType,
  _NotificationType._NotificationTypeName[1:Language = $session.system_language].NotificationTypeName AS NotificationTypeName,
  NotifProcessingPhase,
  _NotifProcessingPhase._Text[1:Language = $session.system_language].NotifProcessingPhaseDesc AS NotifProcessingPhaseDesc,
  NotificationText,
  NotificationPriorityType,
  NotificationPriority,
  _NotificationPriority._NotificationPriorityText[1:Language = $session.system_language].NotificationPriorityText AS NotificationPriorityText,
  IsBusinessPurposeCompleted,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  LastChangedDate,
  NotificationReportingDate,
  NotificationCompletionDate,
  Supplier,
  Customer,
  Material,
  _Product._Text[1:Language = $session.system_language].ProductName AS ProductName,
  Plant,
  PurchasingDocument,
  PurchasingOrganization,
  PurchasingGroup,
  ActiveDivision,
  SalesOrganization,
  DistributionChannel,
  _WBSElement.WBSElement AS WBSElement
FROM I_QltyNotification
;

Learn More