P_InspCharcRejection

DDL: P_INSPCHARCREJECTION Type: view_entity COMPOSITE

Rejections for insp. characteristic

P_InspCharcRejection is a Composite CDS View that provides data about "Rejections for insp. characteristic" in SAP S/4HANA. It reads from 1 data source (I_InspectionCharacteristic) and exposes 7 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. It has 3 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionCharacteristic I_InspectionCharacteristic from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_InspectionLot _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[0..1] I_InspectionResult _InspectionResult $projection.InspectionLot = _InspectionResult.InspectionLot and $projection.InspPlanOperationInternalID = _InspectionResult.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _InspectionResult.InspectionCharacteristic
[0..1] P_InspCharcWithRjctdSmpl _InspCharcWithRjctdSmpl $projection.InspectionLot = _InspCharcWithRjctdSmpl.InspectionLot and $projection.InspPlanOperationInternalID = _InspCharcWithRjctdSmpl.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _InspCharcWithRjctdSmpl.InspectionCharacteristic

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Rejections for insp. characteristic view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionCharacteristic InspectionLot
KEY InspPlanOperationInternalID I_InspectionCharacteristic InspPlanOperationInternalID
KEY InspectionCharacteristic I_InspectionCharacteristic InspectionCharacteristic
OrderInternalBillOfOperations inspOp OrderInternalBillOfOperations
OrderOperationInternalID inspOp OrderOperationInternalID
_InspectionLot _InspectionLot
_InspectionResult _InspectionResult 
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #TRANSACTIONAL }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Rejections for insp. characteristic'
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_InspCharcRejection as select from I_InspectionCharacteristic 
left outer to one join I_InspectionOperation as inspOp on I_InspectionCharacteristic.InspectionLot = inspOp.InspectionLot 
                                                        and I_InspectionCharacteristic.InspPlanOperationInternalID = inspOp.InspPlanOperationInternalID
  association [1..1] to I_InspectionLot                as _InspectionLot        
    on $projection.InspectionLot               = _InspectionLot.InspectionLot

  association [0..1] to I_InspectionResult             as _InspectionResult
    on     $projection.InspectionLot               = _InspectionResult.InspectionLot
       and $projection.InspPlanOperationInternalID = _InspectionResult.InspPlanOperationInternalID
       and $projection.InspectionCharacteristic    = _InspectionResult.InspectionCharacteristic

  association [0..1] to P_InspCharcWithRjctdSmpl as _InspCharcWithRjctdSmpl
    on     $projection.InspectionLot               = _InspCharcWithRjctdSmpl.InspectionLot
       and $projection.InspPlanOperationInternalID = _InspCharcWithRjctdSmpl.InspPlanOperationInternalID
       and $projection.InspectionCharacteristic    = _InspCharcWithRjctdSmpl.InspectionCharacteristic
{
  key I_InspectionCharacteristic.InspectionLot,
  key I_InspectionCharacteristic.InspPlanOperationInternalID,
  key I_InspectionCharacteristic.InspectionCharacteristic,
  inspOp.OrderInternalBillOfOperations,
  inspOp.OrderOperationInternalID,
  case 
//     1. Characteristic results which do not have inspection samples

       when     _InspectionLot.InspLotHasSubsets                = ' '
            and I_InspectionCharacteristic.HasInspCharcPrtlSmpl = ' '
            then case 
                      when _InspectionResult.InspectionValuationResult = 'R' 
                      then 'X' 
                      else ' ' 
                 end
//     2. Characteristics with any kind of samples (independent or subsets/ insp. points)

       else 
                 case 
                      when  _InspCharcWithRjctdSmpl.InspectionCharacteristic is not null 
                      then 'X' 
                      else ' ' 
                 end
       end as InspCharcHasRejection,

  _InspectionLot,
  _InspectionResult
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONCHARACTERISTIC",
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_INSPECTIONRESULT",
"P_INSPCHARCWITHRJCTDSMPL"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"I_INSPECTIONRESULT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More