C_InspSubsetCharSingleRslt

DDL: C_INSPSUBSETCHARSINGLERSLT SQL: CINSSBSTSNGLRSLT Type: view CONSUMPTION

Inspection Characteristic Single Result for Insp. Points

C_InspSubsetCharSingleRslt is a Consumption CDS View that provides data about "Inspection Characteristic Single Result for Insp. Points" in SAP S/4HANA. It reads from 2 data sources (I_InspectionResultValue, I_InspSubsetCharacteristic) and exposes 18 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID, InspectionOperation.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_InspectionResultValue _InspectionResultValue left_outer
I_InspSubsetCharacteristic _InspSubsetChar from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CINSSBSTSNGLRSLT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
EndUserText.label Inspection Characteristic Single Result for Insp. Points view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspSubsetCharacteristic InspectionLot
KEY InspPlanOperationInternalID I_InspSubsetCharacteristic InspPlanOperationInternalID
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID
KEY InspectionOperation
InspSpecIsQuantitative
InspSpecRecordingType
InspSpecDecimalPlaces
InspSpecIsMeasuredValueRqd
InspectionSpecificationUnit
CharacteristicAttributeCodeGrp I_InspectionResultValue CharacteristicAttributeCodeGrp
InspResultHasMeasuredValue I_InspectionResultValue InspResultHasMeasuredValue
fltpendasInspectionResultMeasuredValue
InspectionLotPlant
InspectionLotType
InspectionSubsetType
MatlQualityAuthorizationGroup
WorkCenter 
@AbapCatalog.sqlViewName: 'CINSSBSTSNGLRSLT'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Inspection Characteristic Single Result for Insp. Points'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L, //expected number of rows < 10.000.000

    serviceQuality: #D 
}
define view C_InspSubsetCharSingleRslt 
as select from I_InspSubsetCharacteristic as _InspSubsetChar
    left outer join I_InspectionResultValue as _InspectionResultValue
        on _InspSubsetChar.InspectionLot                = _InspectionResultValue.InspectionLot
        and _InspSubsetChar.InspPlanOperationInternalID = _InspectionResultValue.InspPlanOperationInternalID
        and _InspSubsetChar.InspectionSubsetInternalID  = _InspectionResultValue.InspectionSubsetInternalID
        and _InspSubsetChar.InspectionCharacteristic    = _InspectionResultValue.InspectionCharacteristic
{
  key _InspSubsetChar.InspectionLot,
  key _InspSubsetChar.InspPlanOperationInternalID,
  key _InspSubsetChar.InspectionCharacteristic,
  key _InspSubsetChar.InspectionSubsetInternalID,
  key _InspSubsetChar._InspectionCharacteristic._InspectionOperation.InspectionOperation,  
  _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative,
  _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType,
  _InspSubsetChar._InspectionCharacteristic.InspSpecDecimalPlaces,
  _InspSubsetChar._InspectionCharacteristic.InspSpecIsMeasuredValueRqd,
  _InspSubsetChar._InspectionCharacteristic._InspectionSpecificationUnit._Text[1:Language=$session.system_language].UnitOfMeasureTechnicalName as InspectionSpecificationUnit,   
  _InspectionResultValue.CharacteristicAttributeCodeGrp,
  _InspectionResultValue.InspResultHasMeasuredValue,
  
  case _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative
       when 'X' then case _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType //Quantitative

                     when '+' then _InspectionResultValue.InspectionValuationResult //'+' is Single

                     else ''
                     end
       else case _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType           
            when '+' then _InspectionResultValue.InspectionValuationResult //'+' is Single

            else ''
            end
  end as InspectionValuationResult,
  
  case _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative
  when 'X' then case _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType //Quantitative

                when '+' then _InspectionResultValue.InspectionResultMeasuredValue //'+' is Single

                else cast(0 as abap.fltp)
                end
  else cast(0 as abap.fltp)
  end as InspectionResultMeasuredValue,
              
  case _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative 
  when 'X' then '' //Quantitative

  else case _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType //Qualitive

       when '+' then _InspectionResultValue._CharcAttributeCode.CharacteristicAttributeCodeTxt //Single      

       else '' //Summary

       end
  end as CharacteristicAttributeCodeTxt,
  
  case _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative 
  when 'X' then '' //Quantitative

  else case _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType //Qualitive

       when '+' then _InspectionResultValue._CharcAttributeCode.CharacteristicAttributeCode //Single      

       else '' //Summary

       end
  end as CharacteristicAttributeCode,
  
  // only for auth check

  @Consumption.hidden: true
  _InspSubsetChar._InspectionLot.Plant as InspectionLotPlant,
  @Consumption.hidden: true
  _InspSubsetChar._InspectionLot.InspectionLotType,
  @Consumption.hidden: true
  _InspSubsetChar._InspectionLot.InspectionSubsetType,
  @Consumption.hidden: true
  _InspSubsetChar._InspectionLot.MatlQualityAuthorizationGroup,
  @Consumption.hidden: true
  _InspSubsetChar._InspectionOperation._WorkCenter.WorkCenter
  
}
where _InspSubsetChar.InspectionSubsetInternalID <> '000000'                    
  and _InspectionResultValue.InspectionResultAttribute <> '/'
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHARCATTRIBUTECODE",
"I_INSPECTIONCHARACTERISTIC",
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_INSPECTIONRESULTVALUE",
"I_INSPSUBSETCHARACTERISTIC",
"I_UNITOFMEASURE",
"I_UNITOFMEASURETEXT",
"I_WORKCENTER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More