C_InspCharcSubsetResults

DDL: C_INSPCHARCSUBSETRESULTS SQL: CINSPCHSUBRSLTS Type: view CONSUMPTION

RRIP: Characteristics Subset Results

C_InspCharcSubsetResults is a Consumption CDS View that provides data about "RRIP: Characteristics Subset Results" in SAP S/4HANA. It reads from 2 data sources (I_InspectionSubset, I_InspSubsetCharacteristic) and exposes 33 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID.

2 data source(s) 33 fields

Data Sources (2)

SourceAliasJoin Type
I_InspectionSubset InspectionSubset inner
I_InspSubsetCharacteristic InspSubsetCharacteristic from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName CINSPCHSUBRSLTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label RRIP: Characteristics Subset Results view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspSubsetCharacteristic InspectionLot
KEY InspPlanOperationInternalID I_InspSubsetCharacteristic InspPlanOperationInternalID
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID
InspSpecIsQuantitative
InspectionCharacteristicStatus InspectionCharacteristicStatus
InspectionResultMeanValue InspectionResultMeanValue
CharacteristicAttributeCode CharacteristicAttributeCode
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp
InspectionValuationResult InspectionValuationResult
InspectionValuationResultText
InspSubsetUsageDcsnValuation InspSubsetUsageDcsnValuation
InspectionSubsetDate InspectionSubsetDate
InspectionSubsetTime InspectionSubsetTime
InspRsltAboveToleranceValsNmbr InspSubsetResult InspRsltAboveToleranceValsNmbr
InspRsltBelowToleranceValsNmbr InspSubsetResult InspRsltBelowToleranceValsNmbr
InspectionResultText InspSubsetResult InspectionResultText
Plant
WorkCenter
WorkCenterInternalID
InspectionLotType
InspectionSubsetType
MatlQualityAuthorizationGroup
IsBusinessPurposeCompleted
_InspectionLot I_InspSubsetCharacteristic _InspectionLot
_InspectionOperation I_InspSubsetCharacteristic _InspectionOperation
_InspectionCharacteristic _InspectionCharacteristic
_Plant
_WorkCenter
_InspectionLotType
_InspectionSubsetType
_InspectionValuationResult InspSubsetResult _InspectionValuationResult
_InspSubsetUsageDcsnValn I_InspectionSubset _InspSubsetUsageDcsnValn 
@AbapCatalog.sqlViewName: 'CINSPCHSUBRSLTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
}
@EndUserText.label: 'RRIP: Characteristics Subset Results'

define view C_InspCharcSubsetResults
  as select from           I_InspSubsetCharacteristic as InspSubsetCharacteristic
    inner join             I_InspectionSubset         as InspectionSubset on  InspSubsetCharacteristic.InspectionLot               = InspectionSubset.InspectionLot
                                                                          and InspSubsetCharacteristic.InspectionSubsetInternalID  = InspectionSubset.InspectionSubsetInternalID
                                                                          and InspSubsetCharacteristic.InspPlanOperationInternalID = InspectionSubset.InspPlanOperationInternalID
    left outer to one join I_InspSubsetResult         as InspSubsetResult on  InspSubsetCharacteristic.InspectionLot               = InspSubsetResult.InspectionLot
                                                                          and InspSubsetCharacteristic.InspPlanOperationInternalID = InspSubsetResult.InspPlanOperationInternalID
                                                                          and InspSubsetCharacteristic.InspectionCharacteristic    = InspSubsetResult.InspectionCharacteristic
                                                                          and InspSubsetCharacteristic.InspectionSubsetInternalID  = InspSubsetResult.InspectionSubsetInternalID
  {
  key InspSubsetCharacteristic.InspectionLot as InspectionLot,
  key InspSubsetCharacteristic.InspPlanOperationInternalID as InspPlanOperationInternalID,
  key InspSubsetCharacteristic.InspectionCharacteristic as InspectionCharacteristic,
  key InspSubsetCharacteristic.InspectionSubsetInternalID as InspectionSubsetInternalID ,
      InspSubsetCharacteristic._InspectionCharacteristic.InspSpecIsQuantitative,
      InspectionCharacteristicStatus,
      InspectionResultMeanValue,
      CharacteristicAttributeCode,
      CharacteristicAttributeCodeGrp,
      InspectionValuationResult,
      _InspectionValuationResult._Text[1:Language=$session.system_language].InspectionValuationResultText,
//      InspectionResultStatus,

//      _InspectionResultStatus._Text[1:Language=$session.system_language].InspectionResultStatusText,

      InspSubsetUsageDcsnValuation,
      InspectionSubsetDate,
      InspectionSubsetTime,
      InspSubsetResult.InspRsltAboveToleranceValsNmbr,
      InspSubsetResult.InspRsltBelowToleranceValsNmbr,
      InspSubsetResult.InspectionResultText,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot.Plant,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionOperation._WorkCenter.WorkCenter,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionOperation.WorkCenterInternalID,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot.InspectionLotType,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot.InspectionSubsetType,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot.MatlQualityAuthorizationGroup,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot.IsBusinessPurposeCompleted,

      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionOperation,    
      @Consumption.hidden: true
      _InspectionCharacteristic,
//      @Consumption.hidden: true

//      _InspSubsetResult,

//      @Consumption.hidden: true

//      _InspectionResultValue,

//      @Consumption.hidden: true

//      _InspCharacteristicStatus,

      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot._Plant,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionOperation._WorkCenter,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot._InspectionLotType,
      @Consumption.hidden: true
      InspSubsetCharacteristic._InspectionLot._InspectionSubsetType,
      @Consumption.hidden: true
      InspSubsetResult._InspectionValuationResult,
      @Consumption.hidden: true
      InspectionSubset._InspSubsetUsageDcsnValn
      
}
where
  (
       InspectionSubset.InspSubsetUsageDcsnValuation = 'A'
    or InspectionSubset.InspSubsetUsageDcsnValuation = 'R'
  )
  and(
       InspSubsetResult.InspectionValuationResult    = 'A'
    or InspSubsetResult.InspectionValuationResult    = 'R'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONCHARACTERISTIC",
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_INSPECTIONSUBSET",
"I_INSPECTIONVALUATIONRESULT",
"I_INSPECTIONVALUATIONRSLTTEXT",
"I_INSPSUBSETCHARACTERISTIC",
"I_INSPSUBSETRESULT",
"I_WORKCENTER"
],
"ASSOCIATED":
[
"I_INSPECTIONCHARACTERISTIC",
"I_INSPECTIONLOT",
"I_INSPECTIONLOTTYPE",
"I_INSPECTIONOPERATION",
"I_INSPECTIONSUBSETTYPE",
"I_INSPECTIONVALUATIONRESULT",
"I_INSPLOTUSGEDCSNVALN",
"I_PLANT",
"I_WORKCENTER"
],
"BASE":
[
"I_INSPECTIONLOT",
"I_INSPECTIONOPERATION",
"I_INSPECTIONSUBSET",
"I_INSPSUBSETCHARACTERISTIC",
"I_INSPSUBSETRESULT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More