I_SrvcPartsDeliveryBasic

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_SrvcPartsDeliveryBasic.
-- 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 I_SrvcPartsDeliveryBasic AS
SELECT
  InboundMonitor.dlv_guid AS SCMAdvncdShipgNotifUUID,
  InboundMonitor.dlv_item_guid AS SCMAdvncdShipgNotifItemUUID,
  InboundMonitor.dlv_hdr AS SCMAdvancedShippingNotif,
  InboundMonitor.dlv_item AS SCMAdvancedShippingNotifItem,
  InboundMonitor.ext_status AS SCMDeliveryStatusExternal,
  InboundMonitor.pu_ref_hdr AS SCMPurchaseOrder,
  InboundMonitor.pu_ref_itm AS SCMPurchaseOrderItem,
  InboundMonitor.pu_ref_sch AS SCMPurchaseOrderScheduleLine,
  InboundMonitor.ref_dlv_hdr_guid AS SCMDeliveryDocumentUUID,
  InboundMonitor.ref_dlv_itm_guid AS SCMDeliveryDocumentItemUUID,
  InboundMonitor.ref_dlv_hdr AS SCMDeliveryDocument,
  InboundMonitor.ref_dlv_itm AS SCMDeliveryDocumentItem,
  InboundMonitor.lifex AS SCMDeliveryNote,
  InboundMonitor.traid AS SCMShipment,
  InboundMonitor.tramode AS MeansOfTransportExternal,
  InboundMonitor.suppl_loc AS SCMSupplier,
  InboundMonitor.lifnr AS Supplier,
  InboundMonitor.shpfr_timezone AS ShippingLocationTimeZone,
  InboundMonitor.shpfr_locid AS StartLocationUUID,
  InboundMonitor.shpfr_loctype AS ShippingLocationType,
  InboundMonitor.shpto_loc_grp AS SCMHierarchyParentNode,
  InboundMonitor.shpto_timezone AS ReceivingLocationTimeZone,
  InboundMonitor.shpto_locid AS DestinationLocationUUID,
  InboundMonitor.shpto_loctype AS ReceivingLocationType,
  InboundMonitor.plant AS SCMPlant,
  InboundMonitor.prodgroup AS ProductGroupValue,
  InboundMonitor.prod_guid AS SCMProductUUID,
  InboundMonitor.prod_nr AS Product,
  InboundMonitor.dlvquan AS TotDeliveryQuantityInBaseUnit,
  InboundMonitor.dlvstatqty AS DeliveryStatusQuantity,
  InboundMonitor.dlvrecqty AS CumulativeGoodsReceiptQuantity,
  InboundMonitor.altquan AS TotalAlertQuantity,
  InboundMonitor.tgrmng_bme AS TotReceiptQuantityInBaseUnit,
  InboundMonitor.agrmng_bme AS LastGoodsReceiptQuantity,
  InboundMonitor.base_uom AS ProductBaseUnit,
  cast ( InboundMonitor.shp_date as vdm_inbnd_tstmp_pro_ship ) AS SCMDeliveryStartDateTime,
  cast ( InboundMonitor.avail_date as vdm_inbnd_tstmp_avail ) AS SCMDeliveryAvailyDateTime,
  cast ( InboundMonitor.next_chg_date as vdm_inbnd_tstmp_nchg ) AS SCMDeliveryStatusChgDateTime,
  InboundMonitor.tzone AS WarehouseTimeZone,
  InboundMonitor.flag_open AS SCMDeliveryIsOpen,
  InboundMonitor.flag_late AS SCMDeliveryIsLate,
  InboundMonitor.ext_system AS WarehouseLogicalSystem,
  InboundMonitor.flag_del_rec AS DeliveryIsMarkedForDeletion,
  InboundMonitor.updtmode AS DeliveryUpdateCode,
  InboundMonitor.priop_last AS DeliveryPriorityPointsValue,
  cast ( InboundMonitor.priop_last_tstmp as vdm_inbnd_priop_tstmp ) AS DelivPriorityPointsLastDteTime,
  InboundMonitor.priop_req AS DelivIsPlndForPriorityPoints,
  cast ( InboundMonitor.priop_req_tstmp as vdm_inbnd_priop_req_tstmp ) AS DelivPriorityPointsReqdDteTime,
  InboundMonitor.cr_alert_req AS DelivIsMarkedForCriticalAlert,
  InboundMonitor.shpto_master_fc AS ContractPackagerLocation,
  InboundMonitor.shpto_master_lt AS ContractPackagerLocationType,
  InboundMonitor.process_type AS SCMProcessCategory,
  InboundMonitor.putawayqty AS SCMPutawayQuantity,
  InboundMonitor.first_status AS SCMFirstDeliveryStatus,
  InboundMonitor.push_scenario AS DeliveryIsPushScenario,
  InboundMonitor.shpfr_loc AS StartLocation,
  InboundMonitor.shpto_loc AS DestinationLocation,
  _MTrMapping.MeansOfTransportVehicle AS MeansOfTransportVehicle,
  _Status.SCMDeliveryStatus AS SCMDeliveryStatus,
  _Status.SCMDeliveryStatusStrtDate AS SCMDeliveryStatusStrtDate,
  _Status.SCMDeliveryStatusDurnInHours AS SCMDeliveryStatusDurnInHours,
  'SPP' AS SrvcPartsApplication,
  cast ('000' as /sapapo/c_modelid ) AS PlanningModel,
  _Status._CalendarDate.CalendarDate AS CalendarDate,
  _Status._CalendarDate.CalendarYear AS CalendarYear,
  _Status._CalendarDate.CalendarQuarter AS CalendarQuarter,
  _Status._CalendarDate.CalendarMonth AS CalendarMonth,
  _Status._CalendarDate.CalendarWeek AS CalendarWeek,
  _Status._CalendarDate.CalendarDay AS CalendarDay,
  _Status._CalendarDate.YearMonth AS YearMonth,
  _Status._CalendarDate.YearQuarter AS YearQuarter,
  _Status._CalendarDate.YearWeek AS YearWeek,
  _Status._CalendarDate.WeekDay AS WeekDay,
  _Status._CalendarDate.FirstDayOfWeekDate AS FirstDayOfWeekDate,
  _Status._CalendarDate.FirstDayOfMonthDate AS FirstDayOfMonthDate,
  _Status._CalendarDate.CalendarDayOfYear AS CalendarDayOfYear,
  _Status._CalendarDate.YearDay AS YearDay,
  _Status._CalendarDate._CalendarMonth AS _CalendarMonth,
  _Status._CalendarDate._CalendarQuarter AS _CalendarQuarter,
  _Status._CalendarDate._CalendarYear AS _CalendarYear,
  _Status._CalendarDate._WeekDay AS _WeekDay,
  _Status._CalendarDate._YearMonth AS _YearMonth,
  _Status._CalendarDate AS _CalendarDate
FROM /scmb/inbdlvdat AS InboundMonitor
LEFT OUTER JOIN I_SrvcPartsDeliveryStatusBasic AS _Status ON SCMAdvncdShipgNotifUUID = _Status.SCMAdvncdShipgNotifUUID AND SCMAdvncdShipgNotifItemUUID = _Status.SCMAdvncdShipgNotifItemUUID  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_LocationAnalytics AS _StartLocationAnalytics ON StartLocation = _StartLocationAnalytics.Location  -- association [0..1]
LEFT OUTER JOIN I_LocationAnalytics AS _DestinationLocationAnalytics ON DestinationLocation = _DestinationLocationAnalytics.Location  -- association [0..1]
LEFT OUTER JOIN I_LocationText AS _StartLocationText ON StartLocationUUID = _StartLocationText.LocationUUID  -- association [0..*]
LEFT OUTER JOIN I_LocationText AS _DestinationLocationText ON DestinationLocationUUID = _DestinationLocationText.LocationUUID  -- association [0..*]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CalendarMonthText AS _CalendarMonthText ON CalendarMonth = _CalendarMonthText.CalendarMonth  -- association [0..*]
LEFT OUTER JOIN I_CalendarQuarterText AS _CalendarQuarterText ON CalendarQuarter = _CalendarQuarterText.CalendarQuarter  -- association [0..*]
LEFT OUTER JOIN I_WeekDayText AS _WeekDayText ON WeekDay = _WeekDayText.WeekDay  -- association [0..*]
LEFT OUTER JOIN I_SrvcPartsForecastPeriodicity AS _Periodicity ON SrvcPartsApplication = _Periodicity.SrvcPartsApplication  -- association [1..1]
LEFT OUTER JOIN I_SrvcPartsMTrMapping AS _MTrMapping ON MeansOfTransportExternal = _MTrMapping.MeansOfTransportExternal  -- association [0..*]
;