What is C_InspSubsetResultValue in SAP S/4HANA?

C_InspSubsetResultValue is a consumption CDS view in SAP S/4HANA. IPRR: Inspection Point Single Results It contains 44 fields.

Which tables does C_InspSubsetResultValue read from?

C_InspSubsetResultValue reads data from: I_InspSubsetResultValueTP.

What VDM layer is C_InspSubsetResultValue?

C_InspSubsetResultValue is classified as a Consumption view optimized for specific business scenarios and reporting.

C_InspSubsetResultValue

DDL: C_INSPSUBSETRESULTVALUE SQL: CINSPSUBRESVAL Type: view CONSUMPTION

44 Fields 1 Data Sources

IPRR: Inspection Point Single Results

C_InspSubsetResultValue is a Consumption CDS View that provides data about "IPRR: Inspection Point Single Results" in SAP S/4HANA. It reads from 1 data source (I_InspSubsetResultValueTP) and exposes 44 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID, InspectionCharacteristic, InspResultValueInternalID.

Data Sources (1)

Source	Alias	Join Type
I_InspSubsetResultValueTP	I_InspSubsetResultValueTP	from

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CINSPSUBRESVAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#CONSUMPTION	view
EndUserText.label	IPRR: Inspection Point Single Results	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	true	view
ObjectModel.transactionalProcessingDelegated	true	view

Fields (44)

Key	Field	Source Field	Description
KEY	InspectionLot	InspectionLot	Inspection Lot
KEY	InspPlanOperationInternalID	InspPlanOperationInternalID
KEY	InspectionSubsetInternalID	InspectionSubsetInternalID
KEY	InspectionCharacteristic	InspectionCharacteristic
KEY	InspResultValueInternalID	InspResultValueInternalID
	InspectionResultAttribute	InspectionResultAttribute
	CreationDate	CreationDate	Time Stamp
	InspResultItemInternalID	InspResultItemInternalID
	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
	_CharcAttributeCode	_CharcAttributeCode
	_CharcAttributeCodeGrp	_CharcAttributeCodeGrp
	_InspectionCharacteristic	_InspectionCharacteristic
	_InspectionLot	_InspectionLot
	_InspectionOperation	_InspectionOperation
	_InspectionResultAttribute	_InspectionResultAttribute
	_InspectionValuationResult	_InspectionValuationResult
	_InspectionSubset	_InspectionSubset
	_InspSubsetCharcResult	_InspSubsetCharcResult

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_InspSubsetResultValue.
-- 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: CINSPSUBRESVAL

CREATE VIEW C_InspSubsetResultValue AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionSubsetInternalID,
  InspectionCharacteristic,
  InspResultValueInternalID,
  InspectionResultAttribute,
  CreationDate,
  InspResultItemInternalID,
  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
FROM I_InspSubsetResultValueTP
;

Depth:

C_InspSubsetResultValue view

I_InspSubsetResultValueTP view