C_InspSubsetValuation

@AbapCatalog.sqlViewName: 'CINSPSUBSETVALN'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
}
@EndUserText.label: 'IPRR: Inspection Point Valuation'
define view C_InspSubsetValuation
  as select from
  //I_InspectionOperation as InspOp inner join

                           I_InspectionSubset         as InspSubset //on  InspOp.InspectionLot               = InspSubset.InspectionLot

  //and InspOp.InspPlanOperationInternalID = InspSubset.InspPlanOperationInternalID

    left outer to one join P_InspSubsetCharcAggregate as InspSubsetCharcAggregate on  InspSubset.InspectionLot               = InspSubsetCharcAggregate.InspectionLot
                                                                                  and InspSubset.InspectionSubsetInternalID  = InspSubsetCharcAggregate.InspectionSubsetInternalID
                                                                                  and InspSubset.InspPlanOperationInternalID = InspSubsetCharcAggregate.InspPlanOperationInternalID
  association [0..1] to I_InspLotUsgeDcsnValn as _InspSubsetUsageDcsnValn on $projection.InspSubsetUsageDcsnValuation = _InspSubsetUsageDcsnValn.InspLotUsageDecisionValuation


{
      //--[ GENERATED:012:GlBfhyFV7kY4h7jYW0xcqG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_InspectionLotStdVH',
                     element: 'InspectionLot' }
        }]
      // ]--GENERATED

  key InspSubset.InspectionLot,
  key InspSubset.InspectionSubsetInternalID,
      //--[ GENERATED:012:GlBfhyFV7kY4h7jYW0xcqG

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_InspectionOperationStdVH',
                     element: 'InspPlanOperationInternalID' },
          additionalBinding: [{ localElement: 'InspectionLot',
                                element: 'InspectionLot' }]
        }]
      // ]--GENERATED

  key InspSubset.InspPlanOperationInternalID,
      InspSubset.InspSubsetUsageDcsnValuation,
      InspSubsetCharcAggregate.InspSubsetCharcOpenCount,
      InspSubsetCharcAggregate.InspSubsetCharcAcceptedCount,
      InspSubsetCharcAggregate.InspSubsetCharcRejectedCount,
      InspSubset.InspectionSubsetTime,
      InspSubset.InspectionSubsetDate,
      @ObjectModel.readOnly: true
      cast ('' as abap.char(50)) as InspSubsetDateTime,

      @Consumption.hidden: true
      InspSubset._InspectionLot.Plant,
      @Consumption.hidden: true
      InspSubset._InspectionLot.InspectionLotType,
      @Consumption.hidden: true
      InspSubset._InspectionLot.InspectionSubsetType,
      @Consumption.hidden: true
      InspSubset._InspectionLot.MatlQualityAuthorizationGroup,
      @Consumption.hidden: true
      InspSubset._InspectionLot.IsBusinessPurposeCompleted,
      @Consumption.hidden: true
      InspSubset._InspectionOperation._WorkCenter.WorkCenter,

      // Associations

      InspSubset._InspectionLot,
      InspSubset._InspectionOperation,
      _InspSubsetUsageDcsnValn
}
where
  (
       InspSubset.InspSubsetUsageDcsnValuation = 'A'
    or InspSubset.InspSubsetUsageDcsnValuation = 'R'
  )
  and(
       InspSubset.InspectionSubsetInternalID   is not null
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_INSPECTIONSUBSET",
"I_WORKCENTER",
"P_INSPSUBSETCHARCAGGREGATE"
],
"ASSOCIATED":
[
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_INSPLOTUSGEDCSNVALN"
],
"BASE":
[
"I_INSPECTIONSUBSET"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/