I_SrvcPartsInboundMntrSts

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_SrvcPartsInboundMntrSts.
-- 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: ISPINBMNTRSTS

CREATE VIEW I_SrvcPartsInboundMntrSts AS
SELECT
  InboundMntrSts.dlv_guid AS SCMAdvncdShipgNotifUUID,
  InboundMntrSts.dlv_item_guid AS SCMAdvncdShipgNotifItemUUID,
  InboundMntrSts.dlv_status AS SCMDeliveryStatus,
  _SrvcPartsInboundMonitor.SCMAdvancedShippingNotif AS SCMAdvancedShippingNotif,
  _SrvcPartsInboundMonitor.SCMAdvancedShippingNotifItem AS SCMAdvancedShippingNotifItem,
  InboundMntrSts.ext_status AS SCMDeliveryStatusExternal,
  cast ( InboundMntrSts.startt as /scmb/dm_ref_datim preserving type ) AS SCMDeliveryStatusStrtDateTime,
  cast ( InboundMntrSts.endt as /scmb/dm_ref_datim preserving type ) AS SCMDeliveryStatusEndDateTime,
  InboundMntrSts.endd AS SCMDeliveryStatusEndDate,
  InboundMntrSts.deltawdays AS SCMDeliveryStatusDurnInDays,
  InboundMntrSts.deltawhours AS SCMDeliveryStatusDurnInHours,
  InboundMntrSts.dlvstatqty AS DeliveryStatusQuantity,
  InboundMntrSts.ref_days AS SCMDeliveryDurationInDays,
  InboundMntrSts.dev_ref_days AS SCMDeliveryDeviationDurnInDays,
  InboundMntrSts.flag_late AS SCMDeliveryStatusIsLate,
  cast ( InboundMntrSts.updatetime as /scmb/dm_ref_datim preserving type ) AS SCMDeliveryStatusLastChgDteTme,
  InboundMntrSts.calculated AS SCMDeliveryStatusIsCalculated
FROM /scmb/inbdlvst AS InboundMntrSts
LEFT OUTER JOIN I_SrvcPartsInboundMonitor AS _SrvcPartsInboundMonitor ON SCMAdvncdShipgNotifUUID = _SrvcPartsInboundMonitor.SCMAdvncdShipgNotifUUID AND SCMAdvncdShipgNotifItemUUID = _SrvcPartsInboundMonitor.SCMAdvncdShipgNotifItemUUID  -- association [0..1]
;