C_DefectAffectedObjectFDP

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_DefectAffectedObjectFDP.
-- 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: CDEFECTAOFDP

CREATE VIEW C_DefectAffectedObjectFDP AS
SELECT
  _DefectAffectedObjectTP.DefectInternalID AS DefectInternalID,
  _DefectAffectedObjectTP.DefectAffectedObject AS DefectAffectedObject,
  _DefectAffectedObjectTP.Defect AS Defect,
  _DefectAffectedObjectTP.DefectAffectedObjectType AS DefectAffectedObjectType,
  _DefectAffectedObjectTP.Material AS Material,
  _DefectAffectedObjectTP.DefectAffectedObjectQuantity AS DefectAffectedObjectQuantity,
  _DefectAffectedObjectTP.DefectAffcdObjQuantityUnit AS DefectAffcdObjQuantityUnit,
  _DefectAffectedObjectTP.Batch AS Batch,
  _DefectAffectedObjectTP.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  _DefectAffectedObjectTP.QltyTaskFllwUpActionSts AS QltyTaskFllwUpActionSts,
  _DefectAffectedObjectTP.QualityTask AS QualityTask,
  _DefectAffectedObjectTP.DefectAffcdObjIsDefective AS DefectAffcdObjIsDefective
FROM I_DefectAffectedObjectTP AS _DefectAffectedObjectTP
LEFT OUTER JOIN C_DefectFDP AS _Defect ON DefectInternalID = _Defect.DefectInternalID  -- association [1..1]
LEFT OUTER JOIN E_DefectAffectedObject AS _Extension ON DefectInternalID = _Extension.Notification AND _Extension.NotificationItem = '0000' AND DefectAffectedObject = _Extension.DefectAffectedObject  -- association [1..1]
;