I_InspectionResultValidValue

DDL: I_INSPECTIONRESULTVALIDVALUE SQL: IINSPRSLTVALDVAL Type: view COMPOSITE
43 Fields 1 Data Sources

Valid Single Value of an Insp Charc Rslt

I_InspectionResultValidValue is a Composite CDS View that provides data about "Valid Single Value of an Insp Charc Rslt" in SAP S/4HANA. It reads from 1 data source (I_InspectionResultValue) and exposes 43 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspResultValueInternalID.

Data Sources (1)

SourceAliasJoin Type
I_InspectionResultValue I_InspectionResultValue from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IINSPRSLTVALDVAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Valid Single Value of an Insp Charc Rslt view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey InspResultValueInternalID view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic InspectionCharacteristic Characteristic
KEY InspResultValueInternalID InspResultValueInternalID Indiv. result
InspectionResultAttribute InspectionResultAttribute Name of attribute
CreationDate CreationDate Time Stamp
InspResultItemInternalID InspResultItemInternalID Insp. Unit No.
InspectionSubsetInternalID InspectionSubsetInternalID Sample Number
InspectionResultMeasuredValue InspectionResultMeasuredValue Measured Value
InspResultHasMeasuredValue InspResultHasMeasuredValue
InspectionResultOriginalValue InspectionResultOriginalValue Original Value
InspectionResultText InspectionResultText
InspLotSingleUnitNumber InspLotSingleUnitNumber Single Unit
InspectionResultItem InspectionResultItem Serial Number
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip Information
InspectionValuationResult InspectionValuationResult Valuation
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp Code Group
InspectionResultCodeGroup2 InspectionResultCodeGroup2 Code Group
InspectionResultCodeGroup3 InspectionResultCodeGroup3 Code Group
InspectionResultCodeGroup4 InspectionResultCodeGroup4 Code Group
InspectionResultCodeGroup5 InspectionResultCodeGroup5 Code Group
CharacteristicAttributeCode CharacteristicAttributeCode Code
InspectionResultCode2 InspectionResultCode2 Code
InspectionResultCode3 InspectionResultCode3 Code
InspectionResultCode4 InspectionResultCode4 Code
InspectionResultCode5 InspectionResultCode5 Code
CharacteristicAttributeCatalog CharacteristicAttributeCatalog Catalog Type
InspectionResultCatalog2 InspectionResultCatalog2 Catalog Type
InspectionResultCatalog3 InspectionResultCatalog3 Catalog Type
InspectionResultCatalog4 InspectionResultCatalog4 Catalog Type
InspectionResultCatalog5 InspectionResultCatalog5 Catalog Type
InspectionStartDate InspectionStartDate Insp.Start Date
InspectionStartTime InspectionStartTime Insp.Start Time
InspectionEndDate InspectionEndDate Insp. End Date
InspectionEndTime InspectionEndTime Insp. End Time
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation
_InspectionCharacteristic _InspectionCharacteristic
_InspSubsetCharacteristic _InspSubsetCharacteristic
_CharcAttributeCodeGrp _CharcAttributeCodeGrp
_CharcAttributeCode _CharcAttributeCode
_InspectionResultAttribute _InspectionResultAttribute
_InspectionValuationResult _InspectionValuationResult

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 I_InspectionResultValidValue.
-- 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: IINSPRSLTVALDVAL

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

Learn More