C_DefectDetailsRsltRecg

DDL: C_DEFECTDETAILSRSLTRECG Type: view_entity CONSUMPTION
23 Fields 1 Data Sources 2 Associations

Defect Details for Inspection Lot

C_DefectDetailsRsltRecg is a Consumption CDS View that provides data about "Defect Details for Inspection Lot" in SAP S/4HANA. It reads from 1 data source (I_DefectUnion) and exposes 23 fields with key field DefectInternalID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DefectUnion I_DefectUnion from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_DefectCodeGroupStdVH _DefectCodeGroup $projection.DefectCodeGroup = _DefectCodeGroup.DefectCodeGroup
[0..1] I_DefectCodeStdVH _DefectCode $projection.DefectCodeGroup = _DefectCode.DefectCodeGroup and $projection.DefectCode = _DefectCode.DefectCode association[0..1] to I_DefectCategoryStdVH as _DefectCategory on $projection.DefectCategory = _DefectCategory.DefectCategory

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Defect Details for Inspection Lot view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID DefectInternalID Internal Defect ID
InspectionLot InspectionLot Inspection Lot
InspPlanOperationInternalID InspPlanOperationInternalID
InspectionCharacteristic InspectionCharacteristic
MaterialSample MaterialSample
DefectCode DefectCode Damage Code
DefectCodeGroup DefectCodeGroup Code Group
Notification Notification Notification
DefectText DefectText
DefectCategory DefectCategory
Defect Defect
CreationDate CreationDate Time Stamp
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
Plant Plant Valuation Area
DefectCodeText
DefectCodeGroupText
DefectCategoryText _DefectCategory DefectCategoryText
_Notification _Notification
_InspectionLot _InspectionLot
_DefectCodeGroup _DefectCodeGroup
_DefectCode _DefectCode
_DefectCategory _DefectCategory

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_DefectDetailsRsltRecg.
-- 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_DefectDetailsRsltRecg AS
SELECT
  DefectInternalID,
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  MaterialSample,
  DefectCode,
  DefectCodeGroup,
  Notification,
  DefectText,
  DefectCategory,
  Defect,
  CreationDate,
  MainWorkCenter,
  MainWorkCenterPlant,
  Plant,
  _DefectCode._Text[1:Language=$session.system_language].DefectCodeText AS DefectCodeText,
  _DefectCodeGroup._Text[1:Language=$session.system_language].DefectCodeGroupText AS DefectCodeGroupText,
  _DefectCategory.DefectCategoryText AS DefectCategoryText
FROM I_DefectUnion
LEFT OUTER JOIN I_DefectCodeGroupStdVH AS _DefectCodeGroup ON DefectCodeGroup = _DefectCodeGroup.DefectCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_DefectCodeStdVH AS _DefectCode ON DefectCodeGroup = _DefectCode.DefectCodeGroup AND DefectCode = _DefectCode.DefectCode association[0..1] to I_DefectCategoryStdVH as _DefectCategory on DefectCategory = _DefectCategory.DefectCategory  -- association [0..1]
;

Learn More