C_Qm_Charsresults

DDL: C_QM_CHARSRESULTS SQL: CQMCHARSRESULTS Type: view CONSUMPTION Package: ODATA_QM_RR

Characteristic list of record results

C_Qm_Charsresults is a Consumption CDS View that provides data about "Characteristic list of record results" in SAP S/4HANA. It reads from 5 data sources (I_InspectionLot, I_InspSubsetCharacteristic, I_InspectionCharacteristic, I_InspectionOperation, I_InspectionResult) and exposes 28 fields with key fields InspectionLot, InspectionOperation, InspectionCharacteristic, InspectionSubsetInternalID. Part of development package ODATA_QM_RR.

5 data source(s) 28 fields

Data Sources (5)

SourceAliasJoin Type
I_InspectionLot _insplots inner
I_InspSubsetCharacteristic _inspsmp left_outer
I_InspectionCharacteristic I_InspectionCharacteristic from
I_InspectionOperation I_InspectionOperation inner
I_InspectionResult I_InspectionResult left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CQMCHARSRESULTS view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Characteristic list of record results view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot _inspchs InspectionLot
KEY InspectionOperation _inspops InspectionOperation
KEY InspectionCharacteristic _inspchs InspectionCharacteristic
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID
MaterialSample
Material I_InspectionLot Material
MaterialName
Plant I_InspectionLot Plant
Batch I_InspectionLot Batch
WorkCenterInternalID _inspops WorkCenterInternalID
InspectionLotType I_InspectionLot InspectionLotType
InspectionLotQuantity I_InspectionLot InspectionLotQuantity
OperationText _inspops OperationText
InspectionMethod _inspchs InspectionMethod
InspectionSpecificationText _inspchs InspectionSpecificationText
InspLotTestEquipInternalID _inspchs InspLotTestEquipInternalID
InspCharacteristicSampleSize _inspchs InspCharacteristicSampleSize
InspCharacteristicSampleUnit _inspchs InspCharacteristicSampleUnit
ManufacturingOrder I_InspectionLot ManufacturingOrder
InspSpecTargetValue _inspchs InspSpecTargetValue
InspSpecHasTargetValue _inspchs InspSpecHasTargetValue
InspSpecUpperLimit _inspchs InspSpecUpperLimit
InspSpecHasUpperLimit _inspchs InspSpecHasUpperLimit
InspSpecLowerLimit _inspchs InspSpecLowerLimit
InspSpecHasLowerLimit _inspchs InspSpecHasLowerLimit
InspResultValidValuesNumber _chsResult InspResultValidValuesNumber
InspectionResultMeanValue _chsResult InspectionResultMeanValue
InspectionResultStatus _chsResult InspectionResultStatus 
@AbapCatalog.sqlViewName: 'CQMCHARSRESULTS'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'Characteristic list of record results'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M,
    serviceQuality: #C
}
define view C_Qm_Charsresults
  as select from    I_InspectionCharacteristic _inspchs
    left outer join I_InspectionResult _chsResult          on  _inspchs.InspectionLot               = _chsResult.InspectionLot
                                                           and _inspchs.InspPlanOperationInternalID = _chsResult.InspPlanOperationInternalID
                                                           and _inspchs.InspectionCharacteristic    = _chsResult.InspectionCharacteristic
    inner join      I_InspectionLot            as _insplots           on _insplots.InspectionLot = _inspchs.InspectionLot
    inner join      I_InspectionOperation _inspops         on  _inspchs.InspPlanOperationInternalID   = _inspops.InspPlanOperationInternalID
                                                           and _inspops.OrderInternalBillOfOperations = _insplots.OrderInternalBillOfOperations
                                                           and _inspops.InspectionLot                 = _inspchs.InspectionLot
    left outer join I_InspSubsetCharacteristic as _inspsmp on  _inspsmp.InspPlanOperationInternalID = _inspchs.InspPlanOperationInternalID
                                                           and _inspsmp.InspectionLot               = _inspchs.InspectionLot
                                                           and _inspsmp.InspectionCharacteristic    = _inspchs.InspectionCharacteristic
{
  key _inspchs.InspectionLot,
  key _inspops.InspectionOperation,
  key _inspchs.InspectionCharacteristic,
  key _inspsmp.InspectionSubsetInternalID,
      _inspsmp._InspectionSubset.MaterialSample,
      _insplots.Material,
      _insplots._Material._Text[1:Language=$session.system_language].MaterialName,
      _insplots.Plant,
      _insplots.Batch,
      _inspops.WorkCenterInternalID,
      _insplots.InspectionLotType,
      _insplots.InspectionLotQuantity,
      _inspops.OperationText,
      _inspchs.InspectionMethod,
      _inspchs.InspectionSpecificationText,
      _inspchs.InspLotTestEquipInternalID,
      _inspchs.InspCharacteristicSampleSize,
      _inspchs.InspCharacteristicSampleUnit,
      _insplots.ManufacturingOrder,
      _inspchs.InspSpecTargetValue,    //Target Value for a Quantitative Characteristic

      _inspchs.InspSpecHasTargetValue, //Value Not Initial if Set

      _inspchs.InspSpecUpperLimit,     //Upper Specification Limit

      _inspchs.InspSpecHasUpperLimit,  //Value Not Initial if Set

      _inspchs.InspSpecLowerLimit,     //Lower Tolerance Limit

      _inspchs.InspSpecHasLowerLimit,  //Value Not Initial if Set

      _chsResult.InspResultValidValuesNumber,
      _chsResult.InspectionResultMeanValue,
      _chsResult.InspectionResultStatus
}

Learn More