C_DefectDetailsRsltRecg

DDL: C_DEFECTDETAILSRSLTRECG Type: view_entity CONSUMPTION

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.

1 data source(s) 23 fields

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
InspectionLot InspectionLot
InspPlanOperationInternalID InspPlanOperationInternalID
InspectionCharacteristic InspectionCharacteristic
MaterialSample MaterialSample
DefectCode DefectCode
DefectCodeGroup DefectCodeGroup
Notification Notification
DefectText DefectText
DefectCategory DefectCategory
Defect Defect
CreationDate CreationDate
MainWorkCenter MainWorkCenter
MainWorkCenterPlant MainWorkCenterPlant
Plant Plant
DefectCodeText
DefectCodeGroupText
DefectCategoryText _DefectCategory DefectCategoryText
_Notification _Notification
_InspectionLot _InspectionLot
_DefectCodeGroup _DefectCodeGroup
_DefectCode _DefectCode
_DefectCategory _DefectCategory 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Defect Details for Inspection Lot'
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity C_DefectDetailsRsltRecg
  as select from I_DefectUnion 
  association [0..1] to I_DefectCodeGroupStdVH    as _DefectCodeGroup             on  $projection.DefectCodeGroup   = _DefectCodeGroup.DefectCodeGroup
  association [0..1] to I_DefectCodeStdVH          as _DefectCode                  on  $projection.DefectCodeGroup   = _DefectCode.DefectCodeGroup
                                                                               and $projection.DefectCode        = _DefectCode.DefectCode 
  association[0..1] to I_DefectCategoryStdVH as _DefectCategory on  $projection.DefectCategory   = _DefectCategory.DefectCategory
{
  key DefectInternalID,
      InspectionLot,
      InspPlanOperationInternalID,
      InspectionCharacteristic,
      MaterialSample,
      @ObjectModel.text.element: ['DefectCodeText']
      DefectCode,
      @ObjectModel.text.element: ['DefectCodeGroupText']
      DefectCodeGroup,
      Notification,
      DefectText,
      @ObjectModel.text.element: ['DefectCategoryText']
      DefectCategory,
      Defect,
      CreationDate,
      MainWorkCenter,
      MainWorkCenterPlant,
      Plant,
      _DefectCode._Text[1:Language=$session.system_language].DefectCodeText,
      _DefectCodeGroup._Text[1:Language=$session.system_language].DefectCodeGroupText,  
      _DefectCategory.DefectCategoryText,   
      _Notification,
      _InspectionLot,
      _DefectCodeGroup,
      _DefectCode,
      _DefectCategory
      
      
      
      
      

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DEFECTCATEGORYSTDVH",
"I_DEFECTCODEGROUPSTDVH",
"I_DEFECTCODEGROUPTEXT",
"I_DEFECTCODESTDVH",
"I_DEFECTCODETEXT",
"I_DEFECTUNION"
],
"ASSOCIATED":
[
"I_DEFECTCATEGORYSTDVH",
"I_DEFECTCODEGROUPSTDVH",
"I_DEFECTCODESTDVH",
"I_INSPECTIONLOT",
"I_NOTIFICATION"
],
"BASE":
[
"I_DEFECTUNION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More