R_DefectAffectedObjectTP

DDL: R_DEFECTAFFECTEDOBJECTTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 3 Associations

Object Affected by Defect

R_DefectAffectedObjectTP is a Transactional CDS View that provides data about "Object Affected by Defect" in SAP S/4HANA. It reads from 1 data source (I_DefectAffectedObject) and exposes 16 fields with key fields DefectInternalID, DefectAffectedObject. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DefectAffectedObject _DefectAffectedObject from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_DefectAffectedObjLastTask _DefectAffectedObjLastTask $projection.DefectInternalID = _DefectAffectedObjLastTask.DefectInternalID and $projection.DefectAffectedObject = _DefectAffectedObjLastTask.DefectAffectedObject
[0..1] I_QltyTskFllwUpActnSimlnRslt _QltyTskFllwUpActnSimlnRslt $projection.QltyTskFllwUpActnSimlnRslt = _QltyTskFllwUpActnSimlnRslt.QltyTskFllwUpActnSimlnRslt
[1..1] E_DefectAffectedObject _Extension $projection.DefectInternalID = _Extension.Notification and _Extension.NotificationItem = '0000' and $projection.DefectAffectedObject = _Extension.DefectAffectedObject

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Object Affected by Defect view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey DefectAffectedObject view
Metadata.ignorePropagatedAnnotations true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID I_DefectAffectedObject DefectInternalID Internal Defect ID
KEY DefectAffectedObject I_DefectAffectedObject DefectAffectedObject Affected Object Counter (#)
Defect I_DefectAffectedObject Defect
DefectAffectedObjectType I_DefectAffectedObject DefectAffectedObjectType Translation OType
Material I_DefectAffectedObject Material Vehicle Model
DefectAffectedObjectQuantity I_DefectAffectedObject DefectAffectedObjectQuantity Value
DefectAffcdObjQuantityUnit I_DefectAffectedObject DefectAffcdObjQuantityUnit Unit of measure
Batch I_DefectAffectedObject Batch Lot No.
QltyTaskFollowUpAction _DefectAffectedObjLastTask QltyTaskFollowUpAction
QltyTaskFllwUpActionSts _DefectAffectedObjLastTask QltyTaskFllwUpActionSts
QualityTaskInternalId _DefectAffectedObjLastTask QualityTaskInternalId
QualityTask _DefectAffectedObjLastTask QualityTask
QltyTskFllwUpActnSimlnRslt
_Defect _Defect
_DefectAffectedObjLastTask _DefectAffectedObjLastTask
_QltyTskFllwUpActnSimlnRslt _QltyTskFllwUpActnSimlnRslt

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 R_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.

CREATE VIEW R_DefectAffectedObjectTP AS
SELECT
  _DefectAffectedObject.DefectInternalID AS DefectInternalID,
  _DefectAffectedObject.DefectAffectedObject AS DefectAffectedObject,
  _DefectAffectedObject.Defect AS 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( abap.char' ' as qtskfoasimres preserving type ) AS QltyTskFllwUpActnSimlnRslt
FROM I_DefectAffectedObject AS _DefectAffectedObject
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]
;

Learn More