A_DefectAffectedObject

DDL: A_DEFECTAFFECTEDOBJECT Type: view_entity CONSUMPTION Package: ODATA_QM_DEFECT_API
15 Fields 1 Data Sources 1 OData Services

Object Affected by Defect

A_DefectAffectedObject is a Consumption CDS View that provides data about "Object Affected by Defect" in SAP S/4HANA. It reads from 1 data source (R_DefectAffectedObjectTP) and exposes 15 fields with key fields DefectInternalID, DefectAffectedObject. It is exposed through 1 OData service (API_DEFECT). Part of development package ODATA_QM_DEFECT_API.

Data Sources (1)

SourceAliasJoin Type
R_DefectAffectedObjectTP R_DefectAffectedObjectTP projection

Annotations (12)

NameValueLevelField
EndUserText.label Object Affected by Defect view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey DefectAffectedObject view
OData.entitySet.name DefectAffectedObject view
OData.entityType.name DefectAffectedObject_Type view
Metadata.ignorePropagatedAnnotations true view
Feature QM_CE_DEFECT_WAREHOUSE_DEF view

OData Services (1)

ServiceBindingVersionContractRelease
API_DEFECT API_DEFECT V4 C2 C1

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID _DefectAffectedObject DefectInternalID Internal Defect ID
KEY DefectAffectedObject _DefectAffectedObject DefectAffectedObject
Defect _DefectAffectedObject Defect
DefectAffectedObjectType _DefectAffectedObject DefectAffectedObjectType
Material _DefectAffectedObject Material Vehicle Model
DefectAffectedObjectQuantity _DefectAffectedObject DefectAffectedObjectQuantity
DefectAffcdObjQuantityUnit _DefectAffectedObject DefectAffcdObjQuantityUnit
Batch _DefectAffectedObject Batch Lot No.
QltyTaskFollowUpAction _DefectAffectedObject QltyTaskFollowUpAction
QltyTaskFllwUpActionSts _DefectAffectedObject QltyTaskFllwUpActionSts
QualityTaskInternalId _DefectAffectedObject QualityTaskInternalId
QualityTask _DefectAffectedObject QualityTask
QltyTskFllwUpActnSimlnRslt _DefectAffectedObject QltyTskFllwUpActnSimlnRslt
DefectAffcdObjIsDefective _DefectAffectedObject DefectAffcdObjIsDefective
_DefectredirectedtoparentA_Defect2

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 A_DefectAffectedObject.
-- 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 A_DefectAffectedObject 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,
  _DefectAffectedObject.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  _DefectAffectedObject.QltyTaskFllwUpActionSts AS QltyTaskFllwUpActionSts,
  _DefectAffectedObject.QualityTaskInternalId AS QualityTaskInternalId,
  _DefectAffectedObject.QualityTask AS QualityTask,
  _DefectAffectedObject.QltyTskFllwUpActnSimlnRslt AS QltyTskFllwUpActnSimlnRslt,
  _DefectAffectedObject.DefectAffcdObjIsDefective AS DefectAffcdObjIsDefective
FROM R_DefectAffectedObjectTP
;

Learn More