C_Inspectionoperation

@AbapCatalog.sqlViewName: 'CMPEINSPOPR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK 
@EndUserText.label: 'Inspection Lot for Operations'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@UI.headerInfo: {
    title : { type: #STANDARD, value: 'InspectionLot' },
    description : { type: #STANDARD, value: 'InspectionOperation' },
    typeName: 'Operation Inspection Lot',
    typeNamePlural: 'Operation Inspection Lots'   
}

define view C_Inspectionoperation
  as select from I_InspectionOperation
  association [1..1] to P_InspectionOperationHeader as _InspOpHeader on $projection.InspectionLot = _InspOpHeader.InspectionLot
                                                                and $projection.InspPlanOperationInternalID = _InspOpHeader.InspPlanOperationInternalID
  association [1..1] to P_MPEOrdILOperOpenCharcCount as _InspOpenCharCount on $projection.InspectionLot = _InspOpenCharCount.InspectionLot
                                                                and $projection.InspPlanOperationInternalID = _InspOpenCharCount.InspPlanOperationInternalID                                                                                                                             
{
      @UI.hidden : true
      @Consumption.valueHelpDefinition: [{entity:{name:'I_InspectionLotStdVH' , element: 'InspectionLot'}}]
  key InspectionLot,
      @UI.hidden : true
  key InspPlanOperationInternalID,
      @UI.hidden : true
      @ObjectModel.text.element: 'OperationText'
      InspectionOperation,
      @UI.hidden : true
      OperationText,
      @UI.hidden : true
      _InspectionLot.InspectionLotText,
      @UI.hidden : true
      _InspectionLot.ManufacturingOrder,
      @UI.hidden : true
      _InspectionLot.InspectionLotQuantity,
      @UI.hidden : true
      _InspectionLot.InspectionLotActualQuantity,
      @UI.hidden : true
      _InspectionLot.InspectionLotQuantityUnit,
      @UI.hidden : true
      _InspectionLot.InspectionLotType,
      @UI.hidden : true
      _InspectionLot._InspectionLotType._Text[1: Language=$session.system_language].InspectionLotTypeText,
      @UI.hidden : true
      //Visible controler of characteristics bar: when 0 no characteristic

      _InspOpHeader.InspOpHasCharc,
      @UI.hidden : true
      //Characteristic counts for no sample

      _InspOpenCharCount.InspCharOpenCount,
      @UI.hidden : true
      _InspOpHeader.InspCharAcceptedCount,
      @UI.hidden : true
      _InspOpHeader.InspCharRejectedCount,
      @UI.hidden : true
      _InspOpHeader.InspCharCount as InspCharacteristicCount,
//      _InspOpAgg.InspCharacteristicCount,

      @UI.hidden: true
      case when _InspOpHeader.InspCharCount = 0 or _InspOpenCharCount.InspCharOpenCount is null
            then 100
            else division(division((_InspOpHeader.InspCharCount - _InspOpenCharCount.InspCharOpenCount),
                         (_InspOpHeader.InspCharCount),2)*100,1,0)
       end  as InspCharcsCompletedInPercent,
      // Total completed inspection Characteristics

      @UI.hidden: true
      case when _InspOpenCharCount.InspCharOpenCount is null
            then _InspOpHeader.InspCharCount
            else (_InspOpHeader.InspCharCount - _InspOpenCharCount.InspCharOpenCount) 
      end as InspCharCount,
//      @UI.hidden : true

//      _InspOpAgg.InspOperationCount,

      @UI.hidden : true    
      //Visible controler of sample bar: when 0 no sample bar

      _InspOpHeader.InspLotHasSubsets,
      @UI.hidden : true    
      //Characteristic counts for sample

      _InspOpHeader.InspSubsetCharcOpenCount,
      @UI.hidden : true
      _InspOpHeader.InspSubsetCharcAcceptedCount,
      @UI.hidden : true
      _InspOpHeader.InspSubsetCharcRejectedCount,
      @UI.hidden : true
      InspectionOperationPlant,
      
//      _InspOpHeader,

      _InspectionLot

}
where
     _InspectionLot.InspectionLotType = '03'
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONLOT",
"I_INSPECTIONLOTTYPE",
"I_INSPECTIONLOTTYPETEXT",
"I_INSPECTIONOPERATION",
"P_INSPECTIONOPERATIONHEADER",
"P_MPEORDILOPEROPENCHARCCOUNT"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"P_INSPECTIONOPERATIONHEADER",
"P_MPEORDILOPEROPENCHARCCOUNT"
],
"BASE":
[
"I_INSPECTIONOPERATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/