P_MPEInspIssuesByOperation

DDL: P_MPEINSPISSUESBYOPERATION Type: view_entity COMPOSITE Package: ODATA_MPE_MFGORDER

Inspection Issues By Operation

P_MPEInspIssuesByOperation is a Composite CDS View that provides data about "Inspection Issues By Operation" in SAP S/4HANA. It reads from 1 data source (P_MfgInspOperation) and exposes 5 fields with key fields InspectionLot, InspPlanOperationInternalID. It has 3 associations to related views. Part of development package ODATA_MPE_MFGORDER.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_MfgInspOperation inspo from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_MPEOpCharcWithRjcn _OpCharcWithRjcn $projection.InspectionLot = _OpCharcWithRjcn.InspectionLot and $projection.InspPlanOperationInternalID = _OpCharcWithRjcn.InspPlanOperationInternalID and $projection.OrderInternalBillOfOperations = _OpCharcWithRjcn.OrderInternalBillOfOperations and $projection.Plant = _OpCharcWithRjcn.Plant
[0..1] P_MPEOpInspPtWithRjcn _OpInspPtWithRjcn $projection.InspectionLot = _OpInspPtWithRjcn.InspectionLot and $projection.InspPlanOperationInternalID = _OpInspPtWithRjcn.InspPlanOperationInternalID and $projection.OrderInternalBillOfOperations = _OpInspPtWithRjcn.OrderInternalBillOfOperations and $projection.Plant = _OpInspPtWithRjcn.Plant
[0..1] P_MPEInspOpUsageDecision _InspOperationUsageDecision $projection.InspectionLot = _InspOperationUsageDecision.InspectionLot and $projection.InspPlanOperationInternalID = _InspOperationUsageDecision.InspPlanOperationInternalID and $projection.OrderInternalBillOfOperations = _InspOperationUsageDecision.OrderInternalBillOfOperations and $projection.Plant = _InspOperationUsageDecision.Plant

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Inspection Issues By Operation view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot P_MfgInspOperation InspectionLot
KEY InspPlanOperationInternalID P_MfgInspOperation InspPlanOperationInternalID
OrderInternalBillOfOperations P_MfgInspOperation OrderInternalBillOfOperations
Plant P_MfgInspOperation Plant
_InspOperationUsageDecision _InspOperationUsageDecision 
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Issues By Operation'
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_MPEInspIssuesByOperation as select from P_MfgInspOperation as inspo
//  left outer to one join    I_MfgOrderBasic              as aufv on  aufv.OrderInternalID = I_InspectionOperation.OrderInternalBillOfOperations

//  left outer to one join P_MfgOperAORList as _List         on  _List.OrderInternalID = I_InspectionOperation.OrderInternalBillOfOperations

//                                                            and _List.OrderOperationInternalID  = I_InspectionOperation.InspPlanOperationInternalID

  association [0..1] to P_MPEOpCharcWithRjcn       as _OpCharcWithRjcn
   on     $projection.InspectionLot                 = _OpCharcWithRjcn.InspectionLot
      and $projection.InspPlanOperationInternalID   = _OpCharcWithRjcn.InspPlanOperationInternalID
      and $projection.OrderInternalBillOfOperations = _OpCharcWithRjcn.OrderInternalBillOfOperations
      and $projection.Plant                         = _OpCharcWithRjcn.Plant
  
  association [0..1] to P_MPEOpInspPtWithRjcn     as _OpInspPtWithRjcn
    on     $projection.InspectionLot                  = _OpInspPtWithRjcn.InspectionLot
       and $projection.InspPlanOperationInternalID    = _OpInspPtWithRjcn.InspPlanOperationInternalID
       and $projection.OrderInternalBillOfOperations  = _OpInspPtWithRjcn.OrderInternalBillOfOperations
       and $projection.Plant                          = _OpInspPtWithRjcn.Plant

  association [0..1] to P_MPEInspOpUsageDecision as _InspOperationUsageDecision
    on     $projection.InspectionLot                  = _InspOperationUsageDecision.InspectionLot
       and $projection.InspPlanOperationInternalID    = _InspOperationUsageDecision.InspPlanOperationInternalID
       and $projection.OrderInternalBillOfOperations  = _InspOperationUsageDecision.OrderInternalBillOfOperations
       and $projection.Plant                          = _InspOperationUsageDecision.Plant 

{
  key inspo.InspectionLot                 as InspectionLot,
  key inspo.InspPlanOperationInternalID   as InspPlanOperationInternalID,   // = afvc.aplzl = qaop.vorglfnr !

  
      inspo.OrderInternalBillOfOperations as OrderInternalBillOfOperations, // = afvc.aufpl

      inspo.Plant,
  case
    when _OpCharcWithRjcn.InspPlanOperationInternalID is not null
    then 'X' 
//    else ' ' 

  end as InspHasRejectedCharc,
  
  case
    when _OpInspPtWithRjcn.InspPlanOperationInternalID is not null
    then 'X' 
//    else ' ' 

  end as InspHasRejectedInspSubset,
  
  case
    when _InspOperationUsageDecision.InspOpUsageDecisionValuation = 'R'
    then 'X' 
//    else ' ' 

  end as InspHasRejectedInspLot,
    
  _InspOperationUsageDecision

}
//where _List.OrderInternalID is not null

Learn More