C_UnplndInspCharcRsltRecg

@AbapCatalog.sqlViewName: 'CUNPLNDINSPCHAR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Unplanned Characteristics in Rslt Recg'

@Search.searchable: true
@ObjectModel: {
    usageType: {
        dataClass: #MASTER,
        sizeCategory: #M, //expected number of rows < 100.000

        serviceQuality: #C // includes A,B as well

    },
    createEnabled: true,
    updateEnabled: true
}

@Metadata.ignorePropagatedAnnotations: true
define view C_UnplndInspCharcRsltRecg
  as select from           I_InspSpecificationVersion
    left outer to one join I_AssgmtInspMethInspSpec as InspectionMethod on  I_InspSpecificationVersion.InspectionSpecificationPlant   = InspectionMethod.InspectionSpecificationPlant
                                                                        and I_InspSpecificationVersion.InspectionSpecification        = InspectionMethod.InspectionSpecification
                                                                        and I_InspSpecificationVersion.InspectionSpecificationVersion = InspectionMethod.InspectionSpecificationVersion
                                                                        and InspectionMethod.InspectionMethod                         = ''
                                                                        and InspectionMethod.InspectionMethodVersion                  = ''
                                                                        and InspectionMethod.InspectionMethodPlant                    = ''

  association [1..1] to C_UnplndInspSpecVH as _InspSpecVersReldVH on  $projection.InspectionSpecification        = _InspSpecVersReldVH.InspectionSpecification
                                                                  and $projection.InspectionSpecificationVersion = _InspSpecVersReldVH.InspectionSpecificationVersion
                                                                  and $projection.InspectionSpecificationPlant   = _InspSpecVersReldVH.InspectionSpecificationPlant

{
      @Consumption.valueHelpDefinition: [ { entity: { name: 'C_UnplndInspSpecVH', element: 'InspectionSpecification'},
      additionalBinding: [{ localElement: 'InspectionSpecificationPlant', element: 'InspectionSpecificationPlant'},
                           { localElement: 'InspectionSpecificationVersion', element: 'InspectionSpecificationVersion' }]}]
      @Search.defaultSearchElement: true
  key I_InspSpecificationVersion.InspectionSpecification,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_PlantStdVH', element: 'Plant'}}]
  key I_InspSpecificationVersion.InspectionSpecificationPlant,
  key I_InspSpecificationVersion.InspectionSpecificationVersion,
      InspSpecTransferType,
      InspSpecControlIndicators,
      InspSpecIsQuantitative,
      InspSpecCharacteristicType,
      InspSpecIsMeasuredValueRqd,
      InspSpecIsSelectedSetRequired,
      InspSpecIsUpperLimitRequired,
      InspSpecIsLowerLimitRequired,
      InspSpecIsTargetValueInLimit,
      InspSpecRecordingType,
      InspSpecCharcCategory,
      InspSpecIsSampleQtyAdditive,
      InspSpecIsSamplingProcedRqd,
      InspSpecHasFixedCtrlIndicators,
      InspSpecIsDefectsRecgAutomatic,
      InspSpecIsControlChartUsed,
      InspSpecInformationField1,
      InspSpecInformationField2,
      InspSpecInformationField3,
      InspToleranceSpecification,
      QltyMstrDataAuthorizationGroup,
      InspSpecDecimalPlaces,
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_UnitOfMeasure',
                   element: 'UnitOfMeasure' }
      }]
      //      @UI.hidden: true

      //      @Consumption.hidden: true

      InspectionSpecificationUnit,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      InspSpecTargetValue,
      InspSpecHasTargetValue,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      InspSpecUpperLimit,
      InspSpecHasUpperLimit,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      InspSpecLowerLimit,
      InspSpecHasLowerLimit,
      @EndUserText.label: 'Defect Code Group at Lower Tolerance '
      InspSpecDefectCodeGrpRjcnLower,
      @EndUserText.label: 'Defect Code Type at Lower Tolerance '
      InspSpecDefectCodeRjcnLower,
      @EndUserText.label: 'Defect Code Group at Upper Tolerance '
      InspSpecDefectCodeGrpRjcnUpper,
      @EndUserText.label:   'Defect Code Type at Upper Tolerance '
      InspSpecDefectCodeRjcnUpper,
      CharcInternalID,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_DefectCodeGroupStdVH',
                     element: 'DefectCodeGroup' }
        }]
      @EndUserText.label: 'Defect Code Group for Rejection'
      InspSpecDefectCodeGrpRejection,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_DefectCodeStdVH',
                     element: 'DefectCode' },
          additionalBinding: [{ localElement: 'InspSpecDefectCodeGrpRejection',
                                element: 'DefectCodeGroup' }]
        }]
      @EndUserText.label: 'Defect Code for Rejection'
      InspSpecDefectCodeRejection,
      _Text[1:Language = $session.system_language].InspectionSpecificationText,
      InspectionSpecificationStatus,
      @Consumption.valueHelpDefinition: [
      { entity:  { name:    'I_SamplingProcedureStdVH',
                   element: 'SamplingProcedure' }
      }]
      cast('' as qstichverf )   as SamplingProcedure,
      @Semantics.quantity.unitOfMeasure: 'InspCharacteristicSampleUnit'
      cast(0 as qprobefak)      as BOOCharcSampleQuantity,
      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_UnitOfMeasure',
                    element: 'UnitOfMeasure' }
       }]
      @EndUserText.label: 'Sample Unit of Measure'
      cast('' as qprobme )      as InspCharacteristicSampleUnit,
      //SPC Criterion

      @Consumption.valueHelpDefinition: [
       { entity:  { name:    'I_QltyCtrlChartAggrgnCriterion',
                    element: 'QltyCtrlChartAggrgnCriterion' }
       }]
      cast ('' as qspckrit)     as QltyCtrlChartAggrgnCriterion,

      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_InspMethForInspSpecVH', element: 'InspectionMethod'},
      additionalBinding: [{ localElement: 'InspectionMethodPlant', element: 'InspectionMethodPlant'},
                           { localElement: 'InspectionMethodVersion', element: 'InspectionMethodVersion' }]}]
      cast('' as qpmethode )    as InspectionMethod,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_InspMethForInspSpecVH', element: 'InspectionMethodPlant'},
      additionalBinding: [{ localElement: 'InspectionMethod', element: 'InspectionMethod'},
                           { localElement: 'InspectionMethodVersion', element: 'InspectionMethodVersion' }]}]
      cast('' as q_meth_plant ) as InspectionMethodPlant,
      @Consumption.valueHelpDefinition: [ { entity: { name: 'I_InspMethForInspSpecVH', element: 'InspectionMethodVersion'},
      additionalBinding: [{ localElement: 'InspectionMethod', element: 'InspectionMethod'},
                           { localElement: 'InspectionMethodPlant', element: 'InspectionMethodPlant' }]}]
      cast('' as qversnrpm )    as InspectionMethodVersion,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CharcAttribSeldCodeSetStdVH',
                     element: 'SelectedCodeSet' },
          additionalBinding: [{ localElement: 'SelectedCodeSetPlant',
                                element: 'SelectedCodeSetPlant' }]
        }]
      @EndUserText.label: 'Selected Set'
      InspectionMethod.SelectedCodeSet,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_CharcAttribSeldCodeSetStdVH',
                     element: 'SelectedCodeSetPlant' }
        }]
      InspectionMethod.SelectedCodeSetPlant,

      /* Associations */
      _InspSpecVersReldVH,
      _InspDefectCodeGrpRejection,
      _InspDefectCodeGrpRjcnLower,
      _InspDefectCodeGrpRjcnUpper,
      _InspDefectCodeRejection,
      _InspDefectCodeRjcnLower,
      _InspDefectCodeRjcnUpper,
      _InspectionMethod,
      _InspectionSpecification,
      //      _InspResultDocuRequired,

      _InspSpecCharcCategory,
      _InspSpecCharcCategoryText,
      _InspSpecCharcType,
      _InspSpecCharcTypeText,
      _InspSpecificationPlant,
      _InspSpecRecordingType,
      _InspSpecRecordingTypeText,
      _InspSpecTransferType,
      _InspSpecTransferTypeText,
      _Text,
      _UnitOfMeasure
}
where
  I_InspSpecificationVersion.InspectionSpecificationStatus = '2'