I_DefectAffectedObjectTP

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_DefectAffectedObjectTP.
-- 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: IDEFAFFCDOBJTP

CREATE VIEW I_DefectAffectedObjectTP AS
SELECT
  _DefectAffectedObject.DefectInternalID AS DefectInternalID,
  _DefectAffectedObject.DefectAffectedObject AS DefectAffectedObject,
  Defect,
  _DefectAffectedObject.DefectAffectedObjectType AS DefectAffectedObjectType,
  _DefectAffectedObject.Material AS Material,
  _DefectAffectedObject.DefectAffectedObjectQuantity AS DefectAffectedObjectQuantity,
  _DefectAffectedObject.DefectAffcdObjQuantityUnit AS DefectAffcdObjQuantityUnit,
  _DefectAffectedObject.Batch AS Batch,
  _DefectAffectedObjLastTask.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  _DefectAffectedObjLastTask.QltyTaskFllwUpActionSts AS QltyTaskFllwUpActionSts,
  _DefectAffectedObjLastTask.QualityTaskInternalId AS QualityTaskInternalId,
  _DefectAffectedObjLastTask.QualityTask AS QualityTask,
  cast( ' ' as qtskfoasimres preserving type ) AS QltyTskFllwUpActnSimlnRslt,
  _DefectAffectedObject._DefectAffcdObjQuantityUnit AS _DefectAffcdObjQuantityUnit,
  _DefectAffectedObject._Product AS _Product,
  _DefectAffectedObjLastTask._QltyTaskFllwUpActionSts AS _QltyTaskFllwUpActionSts,
  _DefectAffectedObjLastTask._QltyTaskFollowUpAction AS _QltyTaskFollowUpAction
FROM I_DefectAffectedObject AS _DefectAffectedObject
LEFT OUTER JOIN I_Defect_TP AS _Defect ON DefectInternalID = _Defect.DefectInternalID  -- association [1..1]
LEFT OUTER JOIN I_DefectAffectedObjLastTask AS _DefectAffectedObjLastTask ON DefectInternalID = _DefectAffectedObjLastTask.DefectInternalID AND DefectAffectedObject = _DefectAffectedObjLastTask.DefectAffectedObject  -- association [0..1]
LEFT OUTER JOIN I_QltyTskFllwUpActnSimlnRslt AS _QltyTskFllwUpActnSimlnRslt ON QltyTskFllwUpActnSimlnRslt = _QltyTskFllwUpActnSimlnRslt.QltyTskFllwUpActnSimlnRslt  -- association [0..1]
LEFT OUTER JOIN E_DefectAffectedObject AS _Extension ON DefectInternalID = _Extension.Notification AND _Extension.NotificationItem = '0000' AND DefectAffectedObject = _Extension.DefectAffectedObject  -- association [1..1]
;