I_InspectionIssuesByOperation

DDL: I_INSPECTIONISSUESBYOPERATION SQL: IINSPISSBYOP Type: view COMPOSITE

Inspection Issues By Operation

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

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionOperation I_InspectionOperation from

Associations (3)

CardinalityTargetAliasCondition
[0..1] P_OpCharcWithRjcn _OpCharcWithRjcn $projection.InspectionLot = _OpCharcWithRjcn.InspectionLot and $projection.InspPlanOperationInternalID = _OpCharcWithRjcn.InspPlanOperationInternalID
[0..1] P_OpInspPtWithRjcn _OpInspPtWithRjcn $projection.InspectionLot = _OpInspPtWithRjcn.InspectionLot and $projection.InspPlanOperationInternalID = _OpInspPtWithRjcn.InspPlanOperationInternalID
[0..1] I_InspOperationUsageDecision _InspOperationUsageDecision $projection.InspectionLot = _InspOperationUsageDecision.InspectionLot and $projection.InspPlanOperationInternalID = _InspOperationUsageDecision.InspPlanOperationInternalID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IINSPISSBYOP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Inspection Issues By Operation view
VDM.viewType #COMPOSITE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionOperation InspectionLot
KEY InspPlanOperationInternalID I_InspectionOperation InspPlanOperationInternalID
OrderInternalBillOfOperations I_InspectionOperation OrderInternalBillOfOperations
_InspOperationUsageDecision _InspOperationUsageDecision 
@AbapCatalog.sqlViewName: 'IINSPISSBYOP'
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #TRANSACTIONAL }
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Issues By Operation'
@VDM.viewType: #COMPOSITE
define view I_InspectionIssuesByOperation as select from I_InspectionOperation

  association [0..1] to P_OpCharcWithRjcn       as _OpCharcWithRjcn
   on     $projection.InspectionLot               = _OpCharcWithRjcn.InspectionLot
      and $projection.InspPlanOperationInternalID = _OpCharcWithRjcn.InspPlanOperationInternalID
  
  association [0..1] to P_OpInspPtWithRjcn     as _OpInspPtWithRjcn
    on     $projection.InspectionLot               = _OpInspPtWithRjcn.InspectionLot
       and $projection.InspPlanOperationInternalID = _OpInspPtWithRjcn.InspPlanOperationInternalID 

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

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

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

  
  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

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONOPERATION",
"I_INSPOPERATIONUSAGEDECISION",
"P_OPCHARCWITHRJCN",
"P_OPINSPPTWITHRJCN"
],
"ASSOCIATED":
[
"I_INSPOPERATIONUSAGEDECISION",
"P_OPCHARCWITHRJCN",
"P_OPINSPPTWITHRJCN"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More