I_Notification

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_Notification.
-- 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: INOTIFICATION

CREATE VIEW I_Notification AS
SELECT
  qmel.qmnum AS Notification,
  qmel.qmart AS NotificationType,
  qmel.qmtxt AS NotificationText,
  qmel.artpr AS NotificationPriorityType,
  qmel.priok AS NotificationPriority,
  qmel.ernam AS CreatedByUser,
  qmel.erdat AS CreationDate,
  qmel.aenam AS LastChangedByUser,
  qmel.aedat AS LastChangedDate,
  qmel.mzeit AS NotificationCreationTime,
  qmel.qmdat AS NotificationReportingDate,
  qmel.qmnam AS ReportedByUser,
  qmel.strmn AS NotificationRequiredStartDate,
  qmel.strur AS NotificationRequiredStartTime,
  qmel.ltrmn AS NotificationRequiredEndDate,
  qmel.ltrur AS NotificationRequiredEndTime,
  qmel.tzonso AS NotificationTimeZone,
  qmel.aufnr AS OrderID,
  qmel.verid AS ProductionVersion,
  qmel.matnr AS Material,
  qmel.matkl AS MaterialGroup,
  qmel.kunum AS Customer,
  qmel.objnr AS NotificationStatusObject,
  qmel.qmdab AS NotificationCompletionDate,
  cast( qmel.kzmla as vdm_j_masterlanguage ) AS MasterLanguage,
  qmel.herkz AS NotificationOrigin,
  qmel.lifnum AS Supplier,
  qmel.bstnk AS PurchaseOrderByCustomer,
  qmel.bstdk AS CustomerPurchaseOrderDate,
  qmel.spart AS ActiveDivision,
  qmel.vkorg AS SalesOrganization,
  qmel.vtweg AS DistributionChannel,
  qmel.mawerk AS Plant,
  qmel.qmkat AS NotificationCatalog,
  qmel.qmgrp AS NotificationCodeGroup,
  qmel.qmcod AS NotificationCodeID,
  qmel.prueflos AS InspectionLot,
  qmel.charg AS Batch,
  qmel.hersteller AS Manufacturer,
  qmel.ekorg AS PurchasingOrganization,
  qmel.bkgrp AS PurchasingGroup,
  qmel.fertaufnr AS ProductionOrder,
  qmel.fertaufpl AS MfgOrderInternalID,
  qmel.ebeln AS PurchasingDocument,
  qmel.ebelp AS PurchasingDocumentItem,
  qmel.mjahr AS MaterialDocumentYear,
  qmel.mblnr AS MaterialDocument,
  qmel.mblpo AS MaterialDocumentItem,
  qmel.ls_kdauf AS OrderDocument,
  qmel.ls_vbeln AS DeliveryDocument,
  qmel.ls_posnr AS DeliveryDocumentItem,
  qmel.crobjty AS WorkCenterTypeCode,
  qmel.arbpl AS MainWorkCenterInternalID,
  qmel.arbplwerk AS MainWorkCenterPlant,
  qmel.pnlkn AS OrderOperationInternalID,
  qmel.mgeig AS NotificationInternalQuantity,
  qmel.mgfrd AS NotificationExternalQty,
  qmel.mgein AS NotificationQuantityUnit,
  qmel.bzmng AS NotificationReferenceQuantity,
  qmel.rkmng AS NotificationComplaintQuantity,
  qmel.rgmng AS NotifReturnDeliveryQuantity,
  qmel.rkdat AS NotificationReturnDeliveryDate,
  qmel.qwrnum AS NotificationLinkedNotification,
  qmel.refnum AS NotificationExtReferenceNumber,
  qmel.kzloesch AS IsDeleted,
  qmel.cvp_xblck AS IsBusinessPurposeCompleted,
  qmel.deviceid AS AdditionalDeviceData,
  cast ( qmel.psp_nr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  qmel.phase AS NotifProcessingPhase,
  qmel.changeddatetime AS ChangedDateTime,
  qmel.shn_objty AS ShiftNoteWorkCenterType,
  qmel.shn_objid AS ShiftNoteWorkCenterInternalID,
  qmel.shn_funct_loc AS FunctionalLocation,
  qmel.shn_equipment AS Equipment,
  qmel.shn_origin AS ShiftNoteOrigin
FROM qmel
LEFT OUTER JOIN I_NotificationPartner AS _NotificationPartner ON NotificationStatusObject = _NotificationPartner.NotificationPartnerObject  -- association [0..*]
LEFT OUTER JOIN I_NotificationItem AS _NotificationItem ON Notification = _NotificationItem.Notification  -- association [0..*]
LEFT OUTER JOIN I_NotificationTask AS _NotificationTask ON Notification = _NotificationTask.Notification  -- association [0..*]
LEFT OUTER JOIN I_NotificationActivity AS _NotificationActivity ON Notification = _NotificationActivity.Notification  -- association [0..*]
LEFT OUTER JOIN I_LogisticsOrder AS _LogisticsOrder ON OrderID = _LogisticsOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON MaterialGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup_2 ON MaterialGroup = _ProductGroup_2.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_PMNotifMaintenanceData AS _PMNotifMaintenanceData ON Notification = _PMNotifMaintenanceData.MaintenanceNotification  -- association [0..1]
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedByUserContactCard ON LastChangedByUser = _LastChangedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND OrderOperationInternalID = _InspectionOperation.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _OrderOperationBasic ON MfgOrderInternalID = _OrderOperationBasic.OrderInternalID AND OrderOperationInternalID = _OrderOperationBasic.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_NotificationType AS _NotificationType ON NotificationType = _NotificationType.NotificationType  -- association [1..1]
LEFT OUTER JOIN I_NotificationPriority AS _NotificationPriority ON NotificationPriorityType = _NotificationPriority.NotificationPriorityType AND NotificationPriority = _NotificationPriority.NotificationPriority  -- association [0..1]
LEFT OUTER JOIN I_NotificationCatalog AS _NotificationCatalog ON NotificationCatalog = _NotificationCatalog.NotificationCatalog  -- association [0..1]
LEFT OUTER JOIN I_NotificationCodeGroup AS _NotificationCodeGroup ON NotificationCatalog = _NotificationCodeGroup.NotificationCatalog AND NotificationCodeGroup = _NotificationCodeGroup.NotificationCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_NotificationCode AS _NotificationCode ON NotificationCatalog = _NotificationCode.NotificationCatalog AND NotificationCodeGroup = _NotificationCode.NotificationCodeGroup AND NotificationCodeID = _NotificationCode.NotificationCodeID  -- association [0..1]
LEFT OUTER JOIN I_NotifProcessingPhase AS _NotifProcessingPhase ON NotifProcessingPhase = _NotifProcessingPhase.NotifProcessingPhase  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _NotificationQuantityUnit ON NotificationQuantityUnit = _NotificationQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_StsObjConcatActiveStsILL AS _StsObjConcatActiveStsILL ON NotificationStatusObject = _StsObjConcatActiveStsILL.StatusObject  -- association [0..1]
;