I_QltyNotificationCube

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_QltyNotificationCube.
-- 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: IQLTYNOTIFC

CREATE VIEW I_QltyNotificationCube AS
SELECT
  I_QltyNotification.QualityNotification AS QualityNotification,
  I_QltyNotification.NotificationOrigin AS NotificationOrigin,
  I_QltyNotification.NotificationType AS NotificationType,
  I_QltyNotification.NotificationPriority AS NotificationPriority,
  I_QltyNotification.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_QltyNotification.CreationDate AS CreationDate,
  I_QltyNotification.NotificationReportingDate AS NotificationReportingDate,
  I_QltyNotification.NotificationCompletionDate AS NotificationCompletionDate,
  _QltyNotificationWithStatus.NotificationIsCompleted AS NotificationIsCompleted,
  _QltyNotificationWithStatus.NotificationIsDeleted AS NotificationIsDeleted,
  _QltyNotificationWithStatus.NotificationIsExtCaused AS NotificationIsExtCaused,
  I_QltyNotification.Supplier AS Supplier,
  I_QltyNotification.Material AS Material,
  I_QltyNotification.Plant AS Plant,
  I_QltyNotification.PurchasingDocument AS PurchasingDocument,
  I_QltyNotification.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_QltyNotification.PurchasingOrganization AS PurchasingOrganization,
  cast ('1' as vdm_qltynotificationcount) AS QualityNotificationCount,
  I_QltyNotification.NotificationExternalQty AS NotificationExternalQty,
  I_QltyNotification.NotificationQuantityUnit AS NotificationQuantityUnit,
  I_QltyNotification._Product AS _Product,
  I_QltyNotification._Plant AS _Plant,
  I_QltyNotification._Supplier AS _Supplier,
  I_QltyNotification._PurchasingDocument AS _PurchasingDocument,
  I_QltyNotification._NotificationQuantityUnit AS _NotificationQuantityUnit
FROM I_QltyNotification
LEFT OUTER JOIN I_QltyNotificationWithStatus AS _QltyNotificationWithStatus ON QualityNotification = _QltyNotificationWithStatus.QualityNotification  -- association [1..1]
;