C_DefectRecordAffectedObject

DDL: C_DEFECTRECORDAFFECTEDOBJECT SQL: CDEFRECAFFCDOBJ Type: view CONSUMPTION Package: ODATA_QM_DEFECT
21 Fields 1 Data Sources 1 Associations 2 OData Services

Object Affected by Defect

C_DefectRecordAffectedObject is a Consumption CDS View that provides data about "Object Affected by Defect" in SAP S/4HANA. It reads from 1 data source (I_DefectAffectedObjectTP) and exposes 21 fields with key fields DefectInternalID, DefectAffectedObject. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F2929, ASQL_F2987). Part of development package ODATA_QM_DEFECT.

Data Sources (1)

SourceAliasJoin Type
I_DefectAffectedObjectTP _DefectAffectedObjectTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_DefectRecord _Defect $projection.DefectInternalID = _Defect.DefectInternalID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CDEFRECAFFCDOBJ view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Object Affected by Defect view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey DefectAffectedObject view
ObjectModel.compositionRoot false view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled EXTERNAL_CALCULATION view
ObjectModel.deleteEnabled false view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F2929 ASQL_F2929 C2 NOT_RELEASED
ASQL_F2987 ASQL_F2987 C2 NOT_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID I_DefectAffectedObjectTP DefectInternalID Internal Defect ID
KEY DefectAffectedObject I_DefectAffectedObjectTP DefectAffectedObject
DefectAffectedObjectType I_DefectAffectedObjectTP DefectAffectedObjectType
Material I_DefectAffectedObjectTP Material Vehicle Model
ProductName
DefectAffectedObjectQuantity I_DefectAffectedObjectTP DefectAffectedObjectQuantity
QltyTaskFollowUpAction I_DefectAffectedObjectTP QltyTaskFollowUpAction
QltyTaskFllwUpActionSts I_DefectAffectedObjectTP QltyTaskFllwUpActionSts
QualityTask I_DefectAffectedObjectTP QualityTask
QualityTaskInternalId I_DefectAffectedObjectTP QualityTaskInternalId
QltyTskFllwUpActnSimlnRslt I_DefectAffectedObjectTP QltyTskFllwUpActnSimlnRslt
DefectAffcdObjQuantityUnit I_DefectAffectedObjectTP DefectAffcdObjQuantityUnit
Batch I_DefectAffectedObjectTP Batch Lot No.
Plant _Defect Plant Valuation Area
DefectAffcdObjIsDefective I_DefectAffectedObjectTP DefectAffcdObjIsDefective
_Defect _Defect
_DefectAffcdObjQuantityUnit I_DefectAffectedObjectTP _DefectAffcdObjQuantityUnit
_Product _Product
_QltyTskFllwUpActnSimlnRslt _QltyTskFllwUpActnSimlnRslt
_QltyTaskFollowUpAction I_DefectAffectedObjectTP _QltyTaskFollowUpAction
_QltyTaskFllwUpActionSts I_DefectAffectedObjectTP _QltyTaskFllwUpActionSts

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_DefectRecordAffectedObject.
-- 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: CDEFRECAFFCDOBJ

CREATE VIEW C_DefectRecordAffectedObject AS
SELECT
  _DefectAffectedObjectTP.DefectInternalID AS DefectInternalID,
  _DefectAffectedObjectTP.DefectAffectedObject AS DefectAffectedObject,
  _DefectAffectedObjectTP.DefectAffectedObjectType AS DefectAffectedObjectType,
  _DefectAffectedObjectTP.Material AS Material,
  _DefectAffectedObjectTP._Product._Text[1: Language = $session.system_language ].ProductName AS ProductName,
  _DefectAffectedObjectTP.DefectAffectedObjectQuantity AS DefectAffectedObjectQuantity,
  _DefectAffectedObjectTP.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  _DefectAffectedObjectTP.QltyTaskFllwUpActionSts AS QltyTaskFllwUpActionSts,
  _DefectAffectedObjectTP.QualityTask AS QualityTask,
  _DefectAffectedObjectTP.QualityTaskInternalId AS QualityTaskInternalId,
  _DefectAffectedObjectTP.QltyTskFllwUpActnSimlnRslt AS QltyTskFllwUpActnSimlnRslt,
  _DefectAffectedObjectTP.DefectAffcdObjQuantityUnit AS DefectAffcdObjQuantityUnit,
  _DefectAffectedObjectTP.Batch AS Batch,
  _Defect.Plant AS Plant,
  _DefectAffectedObjectTP.DefectAffcdObjIsDefective AS DefectAffcdObjIsDefective,
  _DefectAffectedObjectTP._DefectAffcdObjQuantityUnit AS _DefectAffcdObjQuantityUnit,
  _DefectAffectedObjectTP._QltyTaskFollowUpAction AS _QltyTaskFollowUpAction,
  _DefectAffectedObjectTP._QltyTaskFllwUpActionSts AS _QltyTaskFllwUpActionSts
FROM I_DefectAffectedObjectTP AS _DefectAffectedObjectTP
LEFT OUTER JOIN C_DefectRecord AS _Defect ON DefectInternalID = _Defect.DefectInternalID  -- association [1..1]
;

Learn More