C_InspCharcSubsetResults

DDL: C_INSPCHARCSUBSETRESULTS SQL: CINSPCHSUBRSLTS Type: view CONSUMPTION Package: ODATA_QM_INSPSUBSET_RR
33 Fields 2 Data Sources

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. Part of development package ODATA_QM_INSPSUBSET_RR.

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 Inspection Lot
KEY InspPlanOperationInternalID I_InspSubsetCharacteristic InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic Characteristic
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID Sample Number
InspSpecIsQuantitative
InspectionCharacteristicStatus InspectionCharacteristicStatus Status
InspectionResultMeanValue InspectionResultMeanValue
CharacteristicAttributeCode CharacteristicAttributeCode
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp
InspectionValuationResult InspectionValuationResult
InspectionValuationResultText
InspSubsetUsageDcsnValuation InspSubsetUsageDcsnValuation Code Valuation
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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_InspCharcSubsetResults.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CINSPCHSUBRSLTS

CREATE VIEW C_InspCharcSubsetResults AS
SELECT
  InspSubsetCharacteristic.InspectionLot AS InspectionLot,
  InspSubsetCharacteristic.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspSubsetCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  InspSubsetCharacteristic.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspSubsetCharacteristic._InspectionCharacteristic.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  InspectionCharacteristicStatus,
  InspectionResultMeanValue,
  CharacteristicAttributeCode,
  CharacteristicAttributeCodeGrp,
  InspectionValuationResult,
  _InspectionValuationResult._Text[1:Language=$session.system_language].InspectionValuationResultText AS InspectionValuationResultText,
  InspSubsetUsageDcsnValuation,
  InspectionSubsetDate,
  InspectionSubsetTime,
  InspSubsetResult.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  InspSubsetResult.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  InspSubsetResult.InspectionResultText AS InspectionResultText,
  InspSubsetCharacteristic._InspectionLot.Plant AS Plant,
  InspSubsetCharacteristic._InspectionOperation._WorkCenter.WorkCenter AS WorkCenter,
  InspSubsetCharacteristic._InspectionOperation.WorkCenterInternalID AS WorkCenterInternalID,
  InspSubsetCharacteristic._InspectionLot.InspectionLotType AS InspectionLotType,
  InspSubsetCharacteristic._InspectionLot.InspectionSubsetType AS InspectionSubsetType,
  InspSubsetCharacteristic._InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  InspSubsetCharacteristic._InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  InspSubsetCharacteristic._InspectionLot AS _InspectionLot,
  InspSubsetCharacteristic._InspectionOperation AS _InspectionOperation,
  InspSubsetCharacteristic._InspectionLot._Plant AS _Plant,
  InspSubsetCharacteristic._InspectionOperation._WorkCenter AS _WorkCenter,
  InspSubsetCharacteristic._InspectionLot._InspectionLotType AS _InspectionLotType,
  InspSubsetCharacteristic._InspectionLot._InspectionSubsetType AS _InspectionSubsetType,
  InspSubsetResult._InspectionValuationResult AS _InspectionValuationResult,
  InspectionSubset._InspSubsetUsageDcsnValn AS _InspSubsetUsageDcsnValn
FROM I_InspSubsetCharacteristic AS InspSubsetCharacteristic
INNER JOIN I_InspectionSubset AS InspectionSubset ON /* join condition not captured in parsed metadata */
;

Learn More