I_ShopFloorItem

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_ShopFloorItem.
-- 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: IMPESFI

CREATE VIEW I_ShopFloorItem AS
SELECT
  sfi.sfi_id AS ShopFloorItem,
  sfi.sfi_number AS ShopFloorItemExternalID,
  sfi.aufnr AS ManufacturingOrder,
  sfi.posnr AS ManufacturingOrderItem,
  sfi.matnr AS Material,
  sfi.crtn_time AS CreationDateTime,
  sfi.crtn_user AS CreatedByUser,
  sernr AS SerialNumber,
  production_status AS ShopFloorItemProductionStatus,
  replaced_sfi_id AS ReplacedShopFloorItem,
  top_replaced_sfi_id AS OriginalReplacedShopFloorItem,
  order_split_uuid AS MfgOrderSplitUUID,
  reworked_sfi_id AS ReworkedShopFloorItem,
  sfi_is_inactive AS ShopFloorItemIsInactive,
  sfi_deactivation_reason_code AS SFIDeactivationReasonCode,
  sfi_deactivation_tstmp AS SFIDeactivationDateTime
FROM mpe_sfi AS sfi
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _LogisticsOrder ON ManufacturingOrder = _LogisticsOrder.OrderID  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_SFIProductionStatus AS _SFIProductionStatus ON ShopFloorItemProductionStatus = _SFIProductionStatus.ShopFloorItemProductionStatus  -- association [1..1]
LEFT OUTER JOIN I_Equipment AS _Equipment ON Material = _Equipment.Material AND SerialNumber = _Equipment.SerialNumber  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ReplacedShopFloorItem ON ReplacedShopFloorItem = _ReplacedShopFloorItem.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _OriginalReplacedShopFloorItem ON OriginalReplacedShopFloorItem = _OriginalReplacedShopFloorItem.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ReworkedShopFloorItem ON ReworkedShopFloorItem = _ReworkedShopFloorItem.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN I_SFIDeactivationReasonCode AS _SFIDeactivationReasonCode ON SFIDeactivationReasonCode = _SFIDeactivationReasonCode.SFIDeactivationReasonCode  -- association [1..1]
;