C_DefectAffectedObjectFDP

DDL: C_DEFECTAFFECTEDOBJECTFDP Type: view_entity CONSUMPTION Package: ODATA_QM_DEFECT
16 Fields 1 Data Sources 4 Associations

FDP view for QM Defect Affected Object

C_DefectAffectedObjectFDP is a Consumption CDS View that provides data about "FDP view for QM Defect Affected Object" in SAP S/4HANA. It reads from 1 data source (I_DefectAffectedObject) and exposes 16 fields with key fields DefectInternalID, DefectAffectedObject. It has 4 associations to related views. Part of development package ODATA_QM_DEFECT.

Data Sources (1)

SourceAliasJoin Type
I_DefectAffectedObject _DefectAffectedObject from

Associations (4)

CardinalityTargetAliasCondition
[1..1] C_DefectFDP _Defect $projection.DefectInternalID = _Defect.DefectInternalID
[0..1] I_DefectAffectedObjLastTask _DefectAffectedObjLastTask $projection.DefectInternalID = _DefectAffectedObjLastTask.DefectInternalID and $projection.DefectAffectedObject = _DefectAffectedObjLastTask.DefectAffectedObject
[0..*] I_UnitOfMeasureText _DefectAffcdObjQuantityUnitT $projection.DefectAffcdObjQuantityUnit = _DefectAffcdObjQuantityUnitT.UnitOfMeasure
[1..1] E_DefectAffectedObject _Extension $projection.DefectInternalID = _Extension.Notification and _Extension.NotificationItem = '0000' and $projection.DefectAffectedObject = _Extension.DefectAffectedObject

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label FDP view for QM Defect Affected Object view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #OUTPUT_FORM_DATA_PROVIDER view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.representativeKey DefectAffectedObject view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Consumption.semanticObject Defect 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
Product I_DefectAffectedObject Material Vehicle Model
ProductName
DefectAffectedObjectQuantity I_DefectAffectedObject DefectAffectedObjectQuantity Value
DefectAffcdObjQuantityUnit I_DefectAffectedObject DefectAffcdObjQuantityUnit Unit of measure
Batch I_DefectAffectedObject Batch Lot No.
QltyTaskFollowUpAction _DefectAffectedObjLastTask QltyTaskFollowUpAction
QltyTaskFollowUpActionText
QltyTaskFllwUpActionSts _DefectAffectedObjLastTask QltyTaskFllwUpActionSts
QltyTaskFllwUpActionStsTxt
QualityTask _DefectAffectedObjLastTask QualityTask
_DefectAffcdObjQuantityUnitT _DefectAffcdObjQuantityUnitT
_Defect _Defect

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.

CREATE VIEW C_DefectAffectedObjectFDP AS
SELECT
  _DefectAffectedObject.DefectInternalID AS DefectInternalID,
  _DefectAffectedObject.DefectAffectedObject AS DefectAffectedObject,
  _DefectAffectedObject.Defect AS Defect,
  _DefectAffectedObject.DefectAffectedObjectType AS DefectAffectedObjectType,
  _DefectAffectedObject.Material AS Product,
  _DefectAffectedObject._Product._Text[ 1: Language = $session.system_language ].ProductName AS ProductName,
  _DefectAffectedObject.DefectAffectedObjectQuantity AS DefectAffectedObjectQuantity,
  _DefectAffectedObject.DefectAffcdObjQuantityUnit AS DefectAffcdObjQuantityUnit,
  _DefectAffectedObject.Batch AS Batch,
  _DefectAffectedObjLastTask.QltyTaskFollowUpAction AS QltyTaskFollowUpAction,
  _DefectAffectedObjLastTask._QltyTaskFollowUpAction._QltyTaskFollowUpActionText[ 1: Language = $session.system_language ].QltyTaskFollowUpActionText AS QltyTaskFollowUpActionText,
  _DefectAffectedObjLastTask.QltyTaskFllwUpActionSts AS QltyTaskFllwUpActionSts,
  _DefectAffectedObjLastTask._QltyTaskFllwUpActionSts._QltyTaskFllwUpActionStsTxt[ 1: Language = $session.system_language ].QltyTaskFllwUpActionStsTxt AS QltyTaskFllwUpActionStsTxt,
  _DefectAffectedObjLastTask.QualityTask AS QualityTask
FROM I_DefectAffectedObject AS _DefectAffectedObject
LEFT OUTER JOIN C_DefectFDP 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_UnitOfMeasureText AS _DefectAffcdObjQuantityUnitT ON DefectAffcdObjQuantityUnit = _DefectAffcdObjQuantityUnitT.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN E_DefectAffectedObject AS _Extension ON DefectInternalID = _Extension.Notification AND _Extension.NotificationItem = '0000' AND DefectAffectedObject = _Extension.DefectAffectedObject  -- association [1..1]
;

Learn More