P_MfgOrderDefectAll

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 P_MfgOrderDefectAll.
-- 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 P_MfgOrderDefectAll AS
SELECT
  NotificationItem.Notification AS Notification,
  NotificationItem.NotificationItem AS NotificationItem,
  cast( substring(NotificationItem.Notification,2,11) as qdefectid preserving type ) AS Defect,
  cast(NotificationItem.NotificationItemText as vdm_qfetxt preserving type ) AS DefectText,
  NotificationItem.DefectCategory AS DefectCategory,
  NotificationItem.DefectiveQuantity AS DefectiveQuantity,
  NotificationItem.DefectiveQuantityUnit AS DefectiveQuantityUnit,
  NotificationItem.ProductionOrder AS ProductionOrder,
  NotificationItem.ProducedMaterial AS ProducedMaterial,
  NotificationItem.ProducedSerialNumber AS ProducedSerialNumber,
  NotificationItem.Material AS Material,
  NotificationItem.DefectiveSingleUnit AS DefectiveSingleUnit,
  NotificationItemRef.Notification AS QualityNotification,
  NotificationItemRef.NotificationItem AS QualityNotificationItem,
  NotificationItem.OrderInternalID AS OrderInternalID,
  NotificationItem.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  NotificationItem.ProductionOrderOperationActy AS ProductionOrderOperationActy,
  NotificationItem.ProductionOrderOpActyVers AS ProductionOrderOpActyVers
FROM I_NotificationItem AS NotificationItem
INNER JOIN I_NotificationItem AS NotificationItemRef ON /* join condition not captured in parsed metadata */
INNER JOIN I_Notification AS Notification ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_NotificationItem
;