P_InspCharcRejection

DDL: P_INSPCHARCREJECTION Type: view_entity COMPOSITE Package: ODATA_MPE_MFGORDER

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 2 data sources (I_InspectionCharacteristic, P_MfgInspOperation) and exposes 7 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. It has 3 associations to related views. Part of development package ODATA_MPE_MFGORDER.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_InspectionCharacteristic I_InspectionCharacteristic from
P_MfgInspOperation inspOp inner

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 P_MfgInspOperation OrderInternalBillOfOperations
Plant P_MfgInspOperation Plant
_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 
    inner join P_MfgInspOperation 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.Plant,
//  inspOp.OrderOperationInternalID,


       case 
            when _InspectionLot.InspLotHasSubsets = ' ' and I_InspectionCharacteristic.HasInspCharcPrtlSmpl = ' ' 
                 and _InspectionResult.InspectionValuationResult = 'R' 
            then 'X'
            when _InspectionLot.InspLotHasSubsets = ' ' and I_InspectionCharacteristic.HasInspCharcPrtlSmpl = ' ' 
            then ''
            when _InspCharcWithRjctdSmpl.InspectionCharacteristic is not null 
            then 'X'
            else ''
        end as InspCharcHasRejection,

  _InspectionLot,
  _InspectionResult
  
}
//where 

// (_InspectionLot.InspLotHasSubsets                = ' '

//  and I_InspectionCharacteristic.HasInspCharcPrtlSmpl = ' '

//  and _InspectionResult.InspectionValuationResult     = 'R' ) or ((    _InspectionLot.InspLotHasSubsets                = 'X'

//        or I_InspectionCharacteristic.HasInspCharcPrtlSmpl = 'X' )

//  and _InspCharcWithRjctdSmpl.InspectionCharacteristic is not null) and

//  _List.OrderInternalID is not null

Learn More