A_QltyNotification

DDL: A_QLTYNOTIFICATION Type: view_entity CONSUMPTION Package: ODATA_QM_NOTIFICATION_API
47 Fields 1 Data Sources 1 OData Services

Quality Notification

A_QltyNotification is a Consumption CDS View that provides data about "Quality Notification" in SAP S/4HANA. It reads from 1 data source (R_QltyNotificationTP) and exposes 47 fields with key field QualityNotification. It is exposed through 1 OData service (API_QUALITYNOTIFICATION). Part of development package ODATA_QM_NOTIFICATION_API.

Data Sources (1)

SourceAliasJoin Type
R_QltyNotificationTP R_QltyNotificationTP projection

Annotations (13)

NameValueLevelField
EndUserText.label Quality Notification view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey QualityNotification view
OData.entitySet.name QualityNotification view
OData.entityType.name QualityNotification_Type view
ObjectModel.sapObjectNodeType.name QualityNotification view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_QUALITYNOTIFICATION API_QUALITYNOTIFICATION V4 C2 C1

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY QualityNotification _QltyNotification QualityNotification
NotificationOrigin _QltyNotification NotificationOrigin
NotificationType _QltyNotification NotificationType Notifictn Type
MasterLanguage _QltyNotification MasterLanguage Primary lang.
NotificationText _QltyNotification NotificationText Description
NotificationPriorityType _QltyNotification NotificationPriorityType
NotificationPriority _QltyNotification NotificationPriority
NotificationStatusObject _QltyNotification NotificationStatusObject
NotifProcessingPhase _QltyNotification NotifProcessingPhase Notif. Phase
NotificationCatalog _QltyNotification NotificationCatalog
NotificationCodeGroup _QltyNotification NotificationCodeGroup
NotificationCodeID _QltyNotification NotificationCodeID
NotificationReportingDate _QltyNotification NotificationReportingDate
NotificationCompletionDate _QltyNotification NotificationCompletionDate Completion Date
NotificationRequiredStartDate _QltyNotification NotificationRequiredStartDate
NotificationRequiredStartTime _QltyNotification NotificationRequiredStartTime
NotificationRequiredEndDate _QltyNotification NotificationRequiredEndDate
NotificationRequiredEndTime _QltyNotification NotificationRequiredEndTime
NotificationTimeZone _QltyNotification NotificationTimeZone Notif.Time.Zone
Supplier _QltyNotification Supplier Supplier
Customer _QltyNotification Customer Sold-to Party
Material _QltyNotification Material Vehicle Model
MaterialGroup _QltyNotification MaterialGroup Product Group
Plant _QltyNotification Plant Valuation Area
PurchasingDocument _QltyNotification PurchasingDocument Purchasing Document
PurchasingDocumentItem _QltyNotification PurchasingDocumentItem Purchasing Doc. Item
PurchasingOrganization _QltyNotification PurchasingOrganization Purchasing Organization
PurchasingGroup _QltyNotification PurchasingGroup Purchasing Group
ActiveDivision _QltyNotification ActiveDivision
SalesOrganization _QltyNotification SalesOrganization Sales Organization
DistributionChannel _QltyNotification DistributionChannel RefDistCh-Cust/Mat.
WBSElementInternalID _QltyNotification WBSElementInternalID WBS Internal ID
WorkCenterTypeCode _QltyNotification WorkCenterTypeCode Object Type
MainWorkCenterInternalID _QltyNotification MainWorkCenterInternalID Work Center
MainWorkCenterPlant _QltyNotification MainWorkCenterPlant Plnt WorkCenter
InspectionLot _QltyNotification InspectionLot Inspection Lot
Batch _QltyNotification Batch Lot No.
MaterialDocumentYear _QltyNotification MaterialDocumentYear Material Document Year
MaterialDocument _QltyNotification MaterialDocument Material Doc.
MaterialDocumentItem _QltyNotification MaterialDocumentItem Material Document Item
IsBusinessPurposeCompleted _QltyNotification IsBusinessPurposeCompleted Purpose Completed
IsDeleted _QltyNotification IsDeleted TRUE
CreatedByUser _QltyNotification CreatedByUser User Name
CreationDate _QltyNotification CreationDate Time Stamp
LastChangedByUser _QltyNotification LastChangedByUser User Name
LastChangedDate _QltyNotification LastChangedDate Created On
ChangedDateTime _QltyNotification ChangedDateTime Time Stamp

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 A_QltyNotification.
-- 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.

CREATE VIEW A_QltyNotification AS
SELECT
  _QltyNotification.QualityNotification AS QualityNotification,
  _QltyNotification.NotificationOrigin AS NotificationOrigin,
  _QltyNotification.NotificationType AS NotificationType,
  _QltyNotification.MasterLanguage AS MasterLanguage,
  _QltyNotification.NotificationText AS NotificationText,
  _QltyNotification.NotificationPriorityType AS NotificationPriorityType,
  _QltyNotification.NotificationPriority AS NotificationPriority,
  _QltyNotification.NotificationStatusObject AS NotificationStatusObject,
  _QltyNotification.NotifProcessingPhase AS NotifProcessingPhase,
  _QltyNotification.NotificationCatalog AS NotificationCatalog,
  _QltyNotification.NotificationCodeGroup AS NotificationCodeGroup,
  _QltyNotification.NotificationCodeID AS NotificationCodeID,
  _QltyNotification.NotificationReportingDate AS NotificationReportingDate,
  _QltyNotification.NotificationCompletionDate AS NotificationCompletionDate,
  _QltyNotification.NotificationRequiredStartDate AS NotificationRequiredStartDate,
  _QltyNotification.NotificationRequiredStartTime AS NotificationRequiredStartTime,
  _QltyNotification.NotificationRequiredEndDate AS NotificationRequiredEndDate,
  _QltyNotification.NotificationRequiredEndTime AS NotificationRequiredEndTime,
  _QltyNotification.NotificationTimeZone AS NotificationTimeZone,
  _QltyNotification.Supplier AS Supplier,
  _QltyNotification.Customer AS Customer,
  _QltyNotification.Material AS Material,
  _QltyNotification.MaterialGroup AS MaterialGroup,
  _QltyNotification.Plant AS Plant,
  _QltyNotification.PurchasingDocument AS PurchasingDocument,
  _QltyNotification.PurchasingDocumentItem AS PurchasingDocumentItem,
  _QltyNotification.PurchasingOrganization AS PurchasingOrganization,
  _QltyNotification.PurchasingGroup AS PurchasingGroup,
  _QltyNotification.ActiveDivision AS ActiveDivision,
  _QltyNotification.SalesOrganization AS SalesOrganization,
  _QltyNotification.DistributionChannel AS DistributionChannel,
  _QltyNotification.WBSElementInternalID AS WBSElementInternalID,
  _QltyNotification.WorkCenterTypeCode AS WorkCenterTypeCode,
  _QltyNotification.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  _QltyNotification.MainWorkCenterPlant AS MainWorkCenterPlant,
  _QltyNotification.InspectionLot AS InspectionLot,
  _QltyNotification.Batch AS Batch,
  _QltyNotification.MaterialDocumentYear AS MaterialDocumentYear,
  _QltyNotification.MaterialDocument AS MaterialDocument,
  _QltyNotification.MaterialDocumentItem AS MaterialDocumentItem,
  _QltyNotification.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _QltyNotification.IsDeleted AS IsDeleted,
  _QltyNotification.CreatedByUser AS CreatedByUser,
  _QltyNotification.CreationDate AS CreationDate,
  _QltyNotification.LastChangedByUser AS LastChangedByUser,
  _QltyNotification.LastChangedDate AS LastChangedDate,
  _QltyNotification.ChangedDateTime AS ChangedDateTime
FROM R_QltyNotificationTP
;

Learn More