C_InspCharcMltplRsltRec

@AbapCatalog.sqlViewName: 'CINSPCHARMLTPL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Insp Charac for Mltpl Rslt Recording'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M, //expected number of rows is < 100.000

    serviceQuality: #C
}
//@Search.searchable: true

define view C_InspCharcMltplRsltRec
  as select  from  I_InspectionCharacteristic as _InspectionCharacteristic
    left outer to one join I_InspectionLot            as _InspLot   on _InspectionCharacteristic.InspectionLot = _InspLot.InspectionLot   //

    left outer join        I_InspectionResult         as InspResult on _InspectionCharacteristic.InspectionLot               =  InspResult.InspectionLot
                                                                  and _InspectionCharacteristic.InspPlanOperationInternalID =  InspResult.InspPlanOperationInternalID
                                                                    and _InspectionCharacteristic.InspectionCharacteristic    =  InspResult.InspectionCharacteristic
  association [1..1] to C_InspResultMltplRsltRec       as _InspectionResult       on  _InspectionCharacteristic.InspectionLot               = _InspectionResult.InspectionLot
                                                                                  and _InspectionCharacteristic.InspectionCharacteristic    = _InspectionResult.InspectionCharacteristic
                                                                                  and _InspectionCharacteristic.InspPlanOperationInternalID = _InspectionResult.InspPlanOperationInternalID
  association [1..1] to I_InspSpecificationVersionText as _InspSpecificationText  on  _InspectionCharacteristic.InspectionSpecification        = _InspSpecificationText.InspectionSpecification
                                                                                  and _InspectionCharacteristic.InspectionSpecificationPlant   = _InspSpecificationText.InspectionSpecificationPlant
                                                                                  and _InspectionCharacteristic.InspectionSpecificationVersion = _InspSpecificationText.InspectionSpecificationVersion
                                                                                  and _InspSpecificationText.Language                          = $session.system_language
   association [1..1] to C_InspLotMltplRsltRec          as _InspLot1                on  _InspectionCharacteristic.InspectionLot = _InspLot1.InspectionLot
  association [1..1] to I_OrderProdnResourceTool       as _OrderProdnResourceTool on  _InspLot.OrderInternalBillOfOperations               = _OrderProdnResourceTool.OrderInternalBillOfOperations
                                                                                  and _InspectionCharacteristic.InspLotTestEquipInternalID = _OrderProdnResourceTool.OrderProdnRsceToolInternalID

  association [1..1] to I_InspectionMethodVersionText  as _InspMethodText         on  _InspectionCharacteristic.InspectionMethod        = _InspMethodText.InspectionMethod
                                                                                  and _InspectionCharacteristic.InspectionMethodPlant   = _InspMethodText.InspectionMethodPlant
                                                                                  and _InspectionCharacteristic.InspectionMethodVersion = _InspMethodText.InspectionMethodVersion
                                                                                  and _InspMethodText.Language                          = $session.system_language


{
  key              _InspectionCharacteristic.InspectionLot,
  key              _InspectionCharacteristic.InspectionCharacteristic,
                   //                   @Consumption.hidden: true

  key              _InspectionCharacteristic.InspPlanOperationInternalID,
  //                 _InspLot.OrderInternalBillOfOperations,

                  _InspectionCharacteristic.InspectionCharacteristicStatus,
                   @EndUserText.label: 'Master Inspection Characteristics'
                   //       @ObjectModel.foreignKey.association: '_InspectionSpecification'

                   //                   @Search.defaultSearchElement: true

                   //                   @UI.selectionField: {position: 10}

                   //                   @Consumption.valueHelpDefinition: [ { entity: { name: 'I_InspSpecVersStdVH', element: 'InspectionSpecification' } } ]

                   cast(_InspectionCharacteristic.InspectionSpecification as abap.char(8)) as InspectionSpecification,
                   _OrderProdnResourceTool._ProdnRsceToolByInternalKey.ProductionResourceTool,
                   _OrderProdnResourceTool._ProdnRsceToolByInternalKey._ProdnRsceToolText[1:Language = $session.system_language].ProductionResourceToolDesc,
                   _InspectionCharacteristic.InspectionSpecificationPlant,
                   _InspSpecificationText.InspectionSpecificationText,
                   cast( _InspectionCharacteristic.InspectionMethod as abap.char(8))       as InspectionMethod,
                   _InspectionCharacteristic.InspectionSpecificationVersion,
                   //                   COALESCE(_InspectionCharacteristic.InspectionMethodPlant, '' )                                                                                                   as  InspectionMethodPlant,

                   _InspectionCharacteristic.InspectionMethodPlant,
                   _InspMethodText.InspectionMethodText,
                   _InspectionCharacteristic.InspectionMethodVersion,
                   //                   COALESCE(_InspectionCharacteristic.InspectionMethodVersion, '' )                                                                                                 as  InspectionMethodVersion,

                   //                   _InspLot1.OrderInternalBillOfOperations,

                   _InspectionCharacteristic.InspLotTestEquipInternalID,
                   _InspectionCharacteristic._InspectionLot,
                   _InspectionResult
              
}
where
      _InspectionCharacteristic.InspectionSpecification        <> ''  //Inspection Characteristic should refer to an MIC

  and _InspectionCharacteristic.InspectionCharacteristicStatus <> '5' // Characteristic status should not be 'Processed completely

  
 // and _InspectionCharacteristic.InspectionCharacteristicStatus <> '4'                                               BY i344811

//  and   ( InspResult.InspectionResultStatus <> '6' or InspResult.InspectionResultStatus is null  )   //             BY i344811

 
//and InspResult.InspectionResultStatus                        <> '6'

// and InspResult.InspectionResultStatus <> '4' and InspResult.InspectionResultStatus <> '6'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONCHARACTERISTIC",
"I_INSPECTIONLOT",
"I_INSPECTIONMETHODVERSIONTEXT",
"I_INSPECTIONRESULT",
"I_INSPSPECIFICATIONVERSIONTEXT",
"I_ORDERPRODNRESOURCETOOL",
"I_PRODNRSCETOOLBYINTERNALKEY",
"I_PRODNRSCETOOLTEXT"
],
"ASSOCIATED":
[
"C_INSPLOTMLTPLRSLTREC",
"C_INSPRESULTMLTPLRSLTREC",
"I_INSPECTIONLOT",
"I_INSPECTIONMETHODVERSIONTEXT",
"I_INSPSPECIFICATIONVERSIONTEXT",
"I_ORDERPRODNRESOURCETOOL"
],
"BASE":
[
"I_INSPECTIONCHARACTERISTIC"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/