I_InspectionResultValidValue

DDL: I_INSPECTIONRESULTVALIDVALUE SQL: IINSPRSLTVALDVAL Type: view COMPOSITE Package: VDM_QM_INSPECTION

Valid Single Value of an Insp Charc Rslt

I_InspectionResultValidValue is a Composite CDS View that provides data about "Valid Single Value of an Insp Charc Rslt" in SAP S/4HANA. It reads from 1 data source (I_InspectionResultValue) and exposes 43 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspResultValueInternalID. Part of development package VDM_QM_INSPECTION.

1 data source(s) 43 fields

Data Sources (1)

SourceAliasJoin Type
I_InspectionResultValue I_InspectionResultValue from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IINSPRSLTVALDVAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Valid Single Value of an Insp Charc Rslt view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey InspResultValueInternalID view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
KEY InspResultValueInternalID InspResultValueInternalID
InspectionResultAttribute InspectionResultAttribute
CreationDate CreationDate
InspResultItemInternalID InspResultItemInternalID
InspectionSubsetInternalID InspectionSubsetInternalID
InspectionResultMeasuredValue InspectionResultMeasuredValue
InspResultHasMeasuredValue InspResultHasMeasuredValue
InspectionResultOriginalValue InspectionResultOriginalValue
InspectionResultText InspectionResultText
InspLotSingleUnitNumber InspLotSingleUnitNumber
InspectionResultItem InspectionResultItem
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip
InspectionValuationResult InspectionValuationResult
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp
InspectionResultCodeGroup2 InspectionResultCodeGroup2
InspectionResultCodeGroup3 InspectionResultCodeGroup3
InspectionResultCodeGroup4 InspectionResultCodeGroup4
InspectionResultCodeGroup5 InspectionResultCodeGroup5
CharacteristicAttributeCode CharacteristicAttributeCode
InspectionResultCode2 InspectionResultCode2
InspectionResultCode3 InspectionResultCode3
InspectionResultCode4 InspectionResultCode4
InspectionResultCode5 InspectionResultCode5
CharacteristicAttributeCatalog CharacteristicAttributeCatalog
InspectionResultCatalog2 InspectionResultCatalog2
InspectionResultCatalog3 InspectionResultCatalog3
InspectionResultCatalog4 InspectionResultCatalog4
InspectionResultCatalog5 InspectionResultCatalog5
InspectionStartDate InspectionStartDate
InspectionStartTime InspectionStartTime
InspectionEndDate InspectionEndDate
InspectionEndTime InspectionEndTime
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation
_InspectionCharacteristic _InspectionCharacteristic
_InspSubsetCharacteristic _InspSubsetCharacteristic
_CharcAttributeCodeGrp _CharcAttributeCodeGrp
_CharcAttributeCode _CharcAttributeCode
_InspectionResultAttribute _InspectionResultAttribute
_InspectionValuationResult _InspectionValuationResult 
@AbapCatalog.sqlViewName: 'IINSPRSLTVALDVAL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Valid Single Value of an Insp Charc Rslt'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #B
}
@ObjectModel.representativeKey: 'InspResultValueInternalID'
define view I_InspectionResultValidValue 
  as select from I_InspectionResultValue 

{
   key InspectionLot,
   key InspPlanOperationInternalID,
   key InspectionCharacteristic,
   key InspResultValueInternalID,
    
       InspectionResultAttribute,
       CreationDate,
       InspResultItemInternalID,
       InspectionSubsetInternalID,
       InspectionResultMeasuredValue,
       InspResultHasMeasuredValue,
       InspectionResultOriginalValue,
       InspectionResultText,
       InspLotSingleUnitNumber,
       InspectionResultItem,
       InspRsltFreeDefinedTestEquip,
       InspectionValuationResult,
       CharacteristicAttributeCodeGrp,
       InspectionResultCodeGroup2,
       InspectionResultCodeGroup3,
       InspectionResultCodeGroup4,
       InspectionResultCodeGroup5,
       CharacteristicAttributeCode,
       InspectionResultCode2,
       InspectionResultCode3,
       InspectionResultCode4,
       InspectionResultCode5,
       CharacteristicAttributeCatalog,
       InspectionResultCatalog2,
       InspectionResultCatalog3,
       InspectionResultCatalog4,
       InspectionResultCatalog5,
       InspectionStartDate,
       InspectionStartTime,
       InspectionEndDate,
       InspectionEndTime,
        
       // Association

       _InspectionLot,
       _InspectionOperation,
       _InspectionCharacteristic,
       _InspSubsetCharacteristic,
       _CharcAttributeCodeGrp,
       _CharcAttributeCode,
       _InspectionResultAttribute,
       _InspectionValuationResult
  
} where
  // Select only attributes which indicates the inspection result is a valid result (refer to I_InspectionResultAttribute)

     I_InspectionResultValue.InspectionResultAttribute = ''
  or I_InspectionResultValue.InspectionResultAttribute = '<'
  or I_InspectionResultValue.InspectionResultAttribute = '>'
  or I_InspectionResultValue.InspectionResultAttribute = '?'
  or I_InspectionResultValue.InspectionResultAttribute = '*'
  or I_InspectionResultValue.InspectionResultAttribute = '('
  or I_InspectionResultValue.InspectionResultAttribute = '['
  or I_InspectionResultValue.InspectionResultAttribute = '{'
  or I_InspectionResultValue.InspectionResultAttribute = '~'
  or I_InspectionResultValue.InspectionResultAttribute = '#'
  or I_InspectionResultValue.InspectionResultAttribute = 'U'
  or I_InspectionResultValue.InspectionResultAttribute = 'V'
  or I_InspectionResultValue.InspectionResultAttribute = 'W'

Learn More