I_MfgOrderItemSerialNumber

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_MfgOrderItemSerialNumber.
-- 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: IPPMFGORDITMSERN

CREATE VIEW I_MfgOrderItemSerialNumber AS
SELECT
  item.ManufacturingOrder AS ManufacturingOrder,
  item.ManufacturingOrderItem AS ManufacturingOrderItem,
  objk.MaintenanceItemObjectList AS MaintenanceItemObjectList,
  objk.MaintenanceItemObject AS MaintenanceItemObject,
  objk.Equipment AS Equipment,
  cast(objk.Equipment as equnr preserving type) AS Equipment_2,
  item.Product AS Product,
  item.ProductionPlant AS ProductionPlant,
  item.PlanningPlant AS PlanningPlant,
  item.MRPController AS MRPController,
  item.ProductionSupervisor AS ProductionSupervisor,
  item.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  item.ManufacturingOrderType AS ManufacturingOrderType,
  sern.SerialNumberAssignmentDate AS DocumentDate,
  item._MfgOrder AS _MfgOrder,
  item._MfgOrderCategory AS _MfgOrderCategory,
  item._MfgOrderType AS _MfgOrderType,
  item._Product AS _Product,
  item._ProductionPlant AS _ProductionPlant,
  item._ProductionSupervisor AS _ProductionSupervisor,
  item._MRPController AS _MRPController,
  item._MRPPlant AS _MRPPlant,
  item._SerialNumberProfile AS _SerialNumberProfile
FROM I_ManufacturingOrderItem AS item
INNER JOIN I_MaintenanceItemObject AS objk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ManufacturingOrderItem AS _MfgOrderItem ON ManufacturingOrder = _MfgOrderItem.ManufacturingOrder AND ManufacturingOrderItem = _MfgOrderItem.ManufacturingOrderItem  -- association [1..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [1..1]
LEFT OUTER JOIN I_Equipment AS _Equipment_2 ON Equipment_2 = _Equipment_2.Equipment  -- association [1..1]
;