What is A_InspSampleResult in SAP S/4HANA?

A_InspSampleResult is a composite CDS view in SAP S/4HANA. Summarized Inspection Results for Inspection Point It contains 61 fields.

Which tables does A_InspSampleResult read from?

A_InspSampleResult reads data from: I_InspSampleResultTP.

What VDM layer is A_InspSampleResult?

A_InspSampleResult is classified as a Composite view that combines data from multiple basic views.

A_InspSampleResult

DDL: A_INSPSAMPLERESULT Type: view_entity COMPOSITE Package: ODATA_QM_INSPECTION_API

61 Fields 1 Data Sources 1 Associations

Summarized Inspection Results for Inspection Point

A_InspSampleResult is a Composite CDS View that provides data about "Summarized Inspection Results for Inspection Point" in SAP S/4HANA. It reads from 1 data source (I_InspSampleResultTP) and exposes 61 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID. It has 1 association to related views. Part of development package ODATA_QM_INSPECTION_API.

Data Sources (1)

Source	Alias	Join Type
I_InspSampleResultTP	_InspSampleResult	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	A_InspectionCharacteristic	_InspCharc	`$projection.InspectionLot = _InspCharc.InspectionLot and $projection.InspPlanOperationInternalID = _InspCharc.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _InspCharc.InspectionCharacteristic`

Annotations (13)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
EndUserText.label	Summarized Inspection Results for Inspection Point	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.createEnabled	true	view
ObjectModel.updateEnabled	true	view
ObjectModel.deleteEnabled	false	view
ObjectModel.entityChangeStateId	ChangedDateTime	view

Fields (61)

Key	Field	Source Table	Source Field	Description
KEY	InspectionLot	I_InspSampleResultTP	InspectionLot	Inspection Lot
KEY	InspPlanOperationInternalID	I_InspSampleResultTP	InspPlanOperationInternalID
KEY	InspectionCharacteristic	I_InspSampleResultTP	InspectionCharacteristic
KEY	InspectionSubsetInternalID	I_InspSampleResultTP	InspectionSubsetInternalID
	Inspector	I_InspSampleResultTP	Inspector	Inspector
	InspectionResultStatus	I_InspSampleResultTP	InspectionResultStatus
	InspectionResultOrigin	I_InspSampleResultTP	InspectionResultOrigin
	InspectionStartDate	I_InspSampleResultTP	InspectionStartDate
	InspectionStartTime	I_InspSampleResultTP	InspectionStartTime
	InspectionEndDate	I_InspSampleResultTP	InspectionEndDate
	InspectionEndTime	I_InspSampleResultTP	InspectionEndTime
	InspectionResultAttribute	I_InspSampleResultTP	InspectionResultAttribute
	InspectionValuationResult	I_InspSampleResultTP	InspectionValuationResult
	InspResultFrmtdMeanValue	I_InspSampleResultTP	InspResultFrmtdMeanValue
	InspectionResultHasMeanValue	I_InspSampleResultTP	InspectionResultHasMeanValue
	InspResultFrmtdMaximumValue	I_InspSampleResultTP	InspResultFrmtdMaximumValue
	InspResultHasMaximumValue	I_InspSampleResultTP	InspResultHasMaximumValue
	InspResultFrmtdMinimumValue	I_InspSampleResultTP	InspResultFrmtdMinimumValue
	InspResultHasMinimumValue	I_InspSampleResultTP	InspResultHasMinimumValue
	InspectionResultOriginalValue	I_InspSampleResultTP	InspectionResultOriginalValue
	InspResultValidValuesNumber	I_InspSampleResultTP	InspResultValidValuesNumber
	InspResultNmbrOfRecordedRslts	I_InspSampleResultTP	InspResultNmbrOfRecordedRslts
	InspectionResultText	I_InspSampleResultTP	InspectionResultText
	InspectionResultHasLongText	I_InspSampleResultTP	InspectionResultHasLongText
	Language	I_InspSampleResultTP	Language	Report Text Language
	InspRsltFreeDefinedTestEquip	I_InspSampleResultTP	InspRsltFreeDefinedTestEquip
	InspRsltBelowToleranceValsNmbr	I_InspSampleResultTP	InspRsltBelowToleranceValsNmbr
	InspRsltAboveToleranceValsNmbr	I_InspSampleResultTP	InspRsltAboveToleranceValsNmbr
	InspRsltFrmtdAbvTolFraction	I_InspSampleResultTP	InspRsltFrmtdAbvTolFraction
	InspRsltFrmtdBelowTolFraction	I_InspSampleResultTP	InspRsltFrmtdBelowTolFraction
	InspResultFrmtdVariance	I_InspSampleResultTP	InspResultFrmtdVariance
	InspRsltNonconformingValsNmbr	I_InspSampleResultTP	InspRsltNonconformingValsNmbr
	InspectionNumberOfDefects	I_InspSampleResultTP	InspectionNumberOfDefects
	CharacteristicAttributeCodeGrp	I_InspSampleResultTP	CharacteristicAttributeCodeGrp
	InspectionResultCodeGroup2	I_InspSampleResultTP	InspectionResultCodeGroup2
	InspectionResultCodeGroup3	I_InspSampleResultTP	InspectionResultCodeGroup3
	InspectionResultCodeGroup4	I_InspSampleResultTP	InspectionResultCodeGroup4
	InspectionResultCodeGroup5	I_InspSampleResultTP	InspectionResultCodeGroup5
	CharacteristicAttributeCode	I_InspSampleResultTP	CharacteristicAttributeCode
	InspectionResultCode2	I_InspSampleResultTP	InspectionResultCode2
	InspectionResultCode3	I_InspSampleResultTP	InspectionResultCode3
	InspectionResultCode4	I_InspSampleResultTP	InspectionResultCode4
	InspectionResultCode5	I_InspSampleResultTP	InspectionResultCode5
	CharacteristicAttributeCatalog	I_InspSampleResultTP	CharacteristicAttributeCatalog
	InspectionResultCatalog2	I_InspSampleResultTP	InspectionResultCatalog2
	InspectionResultCatalog3	I_InspSampleResultTP	InspectionResultCatalog3
	InspectionResultCatalog4	I_InspSampleResultTP	InspectionResultCatalog4
	InspectionResultCatalog5	I_InspSampleResultTP	InspectionResultCatalog5
	CreatedByUser	I_InspSampleResultTP	CreatedByUser	User Name
	CreationDate	I_InspSampleResultTP	CreationDate	Time Stamp
	CreationTime	I_InspSampleResultTP	CreationTime	Time of Change
	LastChangedByUser	I_InspSampleResultTP	LastChangedByUser	User Name
	LastChangeDate	I_InspSampleResultTP	LastChangeDate	Time Stamp
	ChangedDateTime	I_InspSampleResultTP	ChangedDateTime	Time Stamp
	ChangedTime	I_InspSampleResultTP	ChangedTime	Changed at
	Plant	I_InspSampleResultTP	Plant	Valuation Area
	InspectionLotType	I_InspSampleResultTP	InspectionLotType	Inspection Type
	MatlQualityAuthorizationGroup	I_InspSampleResultTP	MatlQualityAuthorizationGroup	QM Matl Auth.
	IsBusinessPurposeCompleted	I_InspSampleResultTP	IsBusinessPurposeCompleted	Purpose Completed
	WorkCenter	I_InspSampleResultTP	WorkCenter	Work Center
	_InspCharc		_InspCharc

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 A_InspSampleResult.
-- 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.

CREATE VIEW A_InspSampleResult AS
SELECT
  _InspSampleResult.InspectionLot AS InspectionLot,
  _InspSampleResult.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspSampleResult.InspectionCharacteristic AS InspectionCharacteristic,
  _InspSampleResult.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _InspSampleResult.Inspector AS Inspector,
  _InspSampleResult.InspectionResultStatus AS InspectionResultStatus,
  _InspSampleResult.InspectionResultOrigin AS InspectionResultOrigin,
  _InspSampleResult.InspectionStartDate AS InspectionStartDate,
  _InspSampleResult.InspectionStartTime AS InspectionStartTime,
  _InspSampleResult.InspectionEndDate AS InspectionEndDate,
  _InspSampleResult.InspectionEndTime AS InspectionEndTime,
  _InspSampleResult.InspectionResultAttribute AS InspectionResultAttribute,
  _InspSampleResult.InspectionValuationResult AS InspectionValuationResult,
  _InspSampleResult.InspResultFrmtdMeanValue AS InspResultFrmtdMeanValue,
  _InspSampleResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  _InspSampleResult.InspResultFrmtdMaximumValue AS InspResultFrmtdMaximumValue,
  _InspSampleResult.InspResultHasMaximumValue AS InspResultHasMaximumValue,
  _InspSampleResult.InspResultFrmtdMinimumValue AS InspResultFrmtdMinimumValue,
  _InspSampleResult.InspResultHasMinimumValue AS InspResultHasMinimumValue,
  _InspSampleResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  _InspSampleResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  _InspSampleResult.InspResultNmbrOfRecordedRslts AS InspResultNmbrOfRecordedRslts,
  _InspSampleResult.InspectionResultText AS InspectionResultText,
  _InspSampleResult.InspectionResultHasLongText AS InspectionResultHasLongText,
  _InspSampleResult.Language AS Language,
  _InspSampleResult.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  _InspSampleResult.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  _InspSampleResult.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  _InspSampleResult.InspRsltFrmtdAbvTolFraction AS InspRsltFrmtdAbvTolFraction,
  _InspSampleResult.InspRsltFrmtdBelowTolFraction AS InspRsltFrmtdBelowTolFraction,
  _InspSampleResult.InspResultFrmtdVariance AS InspResultFrmtdVariance,
  _InspSampleResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  _InspSampleResult.InspectionNumberOfDefects AS InspectionNumberOfDefects,
  _InspSampleResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _InspSampleResult.InspectionResultCodeGroup2 AS InspectionResultCodeGroup2,
  _InspSampleResult.InspectionResultCodeGroup3 AS InspectionResultCodeGroup3,
  _InspSampleResult.InspectionResultCodeGroup4 AS InspectionResultCodeGroup4,
  _InspSampleResult.InspectionResultCodeGroup5 AS InspectionResultCodeGroup5,
  _InspSampleResult.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  _InspSampleResult.InspectionResultCode2 AS InspectionResultCode2,
  _InspSampleResult.InspectionResultCode3 AS InspectionResultCode3,
  _InspSampleResult.InspectionResultCode4 AS InspectionResultCode4,
  _InspSampleResult.InspectionResultCode5 AS InspectionResultCode5,
  _InspSampleResult.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _InspSampleResult.InspectionResultCatalog2 AS InspectionResultCatalog2,
  _InspSampleResult.InspectionResultCatalog3 AS InspectionResultCatalog3,
  _InspSampleResult.InspectionResultCatalog4 AS InspectionResultCatalog4,
  _InspSampleResult.InspectionResultCatalog5 AS InspectionResultCatalog5,
  _InspSampleResult.CreatedByUser AS CreatedByUser,
  _InspSampleResult.CreationDate AS CreationDate,
  _InspSampleResult.CreationTime AS CreationTime,
  _InspSampleResult.LastChangedByUser AS LastChangedByUser,
  _InspSampleResult.LastChangeDate AS LastChangeDate,
  _InspSampleResult.ChangedDateTime AS ChangedDateTime,
  _InspSampleResult.ChangedTime AS ChangedTime,
  _InspSampleResult.Plant AS Plant,
  _InspSampleResult.InspectionLotType AS InspectionLotType,
  _InspSampleResult.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspSampleResult.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspSampleResult.WorkCenter AS WorkCenter
FROM I_InspSampleResultTP AS _InspSampleResult
LEFT OUTER JOIN A_InspectionCharacteristic AS _InspCharc ON InspectionLot = _InspCharc.InspectionLot AND InspPlanOperationInternalID = _InspCharc.InspPlanOperationInternalID AND InspectionCharacteristic = _InspCharc.InspectionCharacteristic  -- association [1..1]
;

Depth:

A_InspSampleResult view_entity

I_InspSampleResultTP view