C_ShopFloorItemHold

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 C_ShopFloorItemHold.
-- 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: CMPESFIHOLD

CREATE VIEW C_ShopFloorItemHold AS
SELECT
  ProdnHoldAffcdSFIAtOpActy.ShopFloorItem AS ShopFloorItem,
  ProdnHoldAffcdSFIAtOpActy.ProductionHold AS ProductionHold,
  ProdnHoldAffcdSFIAtOpActy.OpActyNtwkInstance AS OpActyNtwkInstance,
  ProdnHoldAffcdSFIAtOpActy.OpActyNtwkElement AS OpActyNtwkElement,
  SFIOfOriginalReplacedSFI.OriginalReplacedShopFloorItem AS OriginalReplacedShopFloorItem,
  ProdnHoldAffcdSFIAtOpActy.SerialNumber AS SerialNumber,
  ProdnHoldAffcdSFIAtOpActy.Material AS Material,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ProdnHoldAffcdSFIAtOpActy.ProductionPlant AS ProductionPlant,
  cast(ProdnHoldAffcdSFIAtOpActy.ProductionHoldObjectType as mpe_manage_hold_object_type preserving type ) AS ProductionHoldObjectType,
  _ProductionHoldObjectType._Text[1: Language=$session.system_language].ProductionHoldObjectTypeName AS ProductionHoldObjectTypeName,
  cast(_ProductionHoldActionApply.MfgActionReasonCodeGroup as mpe_hold_apply_codegrp preserving type ) AS ProdnHoldApplyRsnCodeGroup,
  ProdnHoldAffcdSFIAtOpActy.ProductionHoldStatus AS ProductionHoldStatus,
  ProdnHoldAffcdSFIAtOpActy.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  ProdnHoldAffcdSFIAtOpActy.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  cast(_ProductionHoldActionApply.ManufacturingActionReasonCode as mpe_hold_apply_code preserving type ) AS ProductionHoldApplyReasonCode,
  ProdnHoldAffcdSFIAtOpActy.ProductionHoldStartDateTime AS ProductionHoldStartDateTime,
  _ProductionHoldActionApply._MfgActionReasonCode._Text[1: Language=$session.system_language].MfgActionReasonCodeName AS ProdnHoldApplyReasonCodeName,
  cast(_ProductionHoldActionApply.CreatedByUser as mpe_hold_applied_by preserving type) AS ProductionHoldAppliedByUser,
  ProdnHoldAffcdSFIAtOpActy.ProductionHoldEndDateTime AS ProductionHoldEndDateTime,
  _ProductionHoldStatus._Text[1: Language=$session.system_language].ProductionHoldStatusName AS ProductionHoldStatusName,
  ProdnHoldAffcdSFIAtOpActy.Notification AS Notification,
  ProdnHoldAffcdSFIAtOpActy.NotificationItem AS NotificationItem,
  ProdnHoldAffcdSFIAtOpActy._Defect.DefectLifecycleStatus AS DefectLifecycleStatus,
  ProdnHoldAffcdSFIAtOpActy._Defect.DefectCode AS DefectCode,
  ProdnHoldAffcdSFIAtOpActy._Defect.DefectCodeGroup AS DefectCodeGroup,
  ProdnHoldAffcdSFIAtOpActy._Defect._DefectCode._Text[1: Language=$session.system_language].DefectCodeText AS DefectCodeText,
  ProdnHoldAffcdSFIAtOpActy._Defect._DefectStatus._DefectStatusText[1: Language=$session.system_language].DefectLifecycleStatusText AS DefectLifecycleStatusText,
  ProdnHoldAffcdSFIAtOpActy.OrderInternalID AS OrderInternalID,
  ProdnHoldAffcdSFIAtOpActy.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  ProdnHoldAffcdSFIAtOpActy.MfgOrderOperationText AS MfgOrderOperationText,
  _ProductionHoldActionApply._MfgActionReasonCode AS _MfgActionReasonCode,
  ProdnHoldAffcdSFIAtOpActy._MfgOrder AS _MfgOrder,
  ProdnHoldAffcdSFIAtOpActy._MfgOrderOperation AS _MfgOrderOperation,
  ProdnHoldAffcdSFIAtOpActy._OperationActivityInstance AS _OperationActivityInstance,
  ProdnHoldAffcdSFIAtOpActy._OpActyInstceOpActyNtwkElmnt AS _OpActyInstceOpActyNtwkElmnt,
  ProdnHoldAffcdSFIAtOpActy._Notification AS _Notification,
  ProdnHoldAffcdSFIAtOpActy._NotificationItem AS _NotificationItem,
  ProdnHoldAffcdSFIAtOpActy._Defect._DefectCode AS _DefectCode,
  ProdnHoldAffcdSFIAtOpActy._Defect._DefectCodeGroup AS _DefectCodeGroup,
  ProdnHoldAffcdSFIAtOpActy._Defect._DefectStatus AS _DefectStatus
FROM I_SFIOfOriginalReplacedSFI AS SFIOfOriginalReplacedSFI
INNER JOIN P_ProdnHoldAffcdSFIAtOpActy AS ProdnHoldAffcdSFIAtOpActy ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionHoldBasic AS _ProductionHold ON ProductionHold = _ProductionHold.ProductionHold  -- association [1..1]
LEFT OUTER JOIN I_ProductionHoldStatus AS _ProductionHoldStatus ON ProductionHoldStatus = _ProductionHoldStatus.ProductionHoldStatus  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_ProductionHoldObjectType AS _ProductionHoldObjectType ON ProductionHoldObjectType = _ProductionHoldObjectType.ProductionHoldObjectType  -- association [1..1]
LEFT OUTER JOIN I_ProductionHoldAction AS _ProductionHoldActionApply ON ProductionHold = _ProductionHoldActionApply.ProductionHold AND _ProductionHoldActionApply.ProductionHoldItem = 1  -- association [1..1]
LEFT OUTER JOIN I_ProductionHoldAction AS _ProductionHoldActionRelease ON ProductionHold = _ProductionHoldActionRelease.ProductionHold AND _ProductionHoldActionRelease.ProductionHoldItem = 2  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _AppliedByUserContactCard ON ProductionHoldAppliedByUser = _AppliedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ReleasedByUserContactCard ON ProductionHoldReleasedByUser = _ReleasedByUserContactCard.ContactCardID  -- association [0..1]
;