C_InspResultMltplRsltRec

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_InspResultMltplRsltRec.
-- 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: CINSPRSLTMLTPL

CREATE VIEW C_InspResultMltplRsltRec AS
SELECT
  _InspCharac.InspectionLot AS InspectionLot,
  _InspCharac.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspCharac.InspectionCharacteristic AS InspectionCharacteristic,
  _InspCharac._InspectionOperation.InspectionOperation AS InspectionOperation,
  _InspCharac.InspectionSpecificationText AS InspectionCharacteristicText,
  _InspSpecificationText.InspectionSpecificationText AS InspectionSpecificationText,
  cast ('' as abap.char(2) ) AS InspResultValueCount,
  _InspCharac.HasInspCharcPrtlSmpl AS HasInspCharcPrtlSmpl,
  _InspCharac.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspCharac.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  _InspCharac.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  _InspCharac.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  _InspCharac.InspSpecRecordingType AS InspSpecRecordingType,
  _InspCharac.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
  _InspCharac.InspSpecCharcCategory AS InspSpecCharcCategory,
  _InspCharac.InspSpecResultCalculation AS InspSpecResultCalculation,
  _InspCharac.InspCharcIsNotPlanned AS InspCharcIsNotPlanned,
  _InspCharac.InspectionMethod AS InspectionMethod,
  _InspCharac.InspectionMethodPlant AS InspectionMethodPlant,
  _InspCharac.InspectionMethodVersion AS InspectionMethodVersion,
  _InspMethodText.InspectionMethodText AS InspectionMethodText,
  _InspCharac.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _InspCharac.InspectionSpecification AS InspectionSpecification,
  _InspCharac.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _InspCharac.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  _InspCharac.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspCharac.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _InspCharac.InspSampleValuationRule AS InspSampleValuationRule,
  _InspCharac.QuantityUnit AS QuantityUnit,
  _InspCharac.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  _InspCharac.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _InspCharac.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
  _InspCharac.InspSpecTargetValue AS InspSpecTargetValue,
  _InspCharac._InspectionSpecificationUnit._Text[1:Language=$session.system_language].UnitOfMeasureTechnicalName AS UnitOfMeasureTechnicalName,
  _InspCharac._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  _InspCharac.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  _InspCharac.InspSpecUpperLimit AS InspSpecUpperLimit,
  _InspCharac.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  _InspCharac.InspSpecLowerLimit AS InspSpecLowerLimit,
  _InspCharac.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  _InspCharac.InspSpecImportanceCode AS InspSpecImportanceCode,
  _InspCharac.InspLotTestEquipInternalID AS InspLotTestEquipInternalID,
  _InspCharac.SelectedCodeSet AS SelectedCodeSet,
  _InspCharac.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  _InspCharac.InspectorQualification AS InspectorQualification,
  _InspCharac.InspSpecInformationField1 AS InspSpecInformationField1,
  _InspCharac.InspSpecInformationField2 AS InspSpecInformationField2,
  _InspCharac.InspSpecInformationField3 AS InspSpecInformationField3,
  _InspCharac.InspCharcQuantity AS InspectionScope,
  _InspCharac.InspSpecControlIndicators AS InspSpecControlIndicators,
  _InspCharac.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _InspCharac.UnplndCharcInspSubsetIntID AS UnplndCharcInspSubsetIntID,
  _InspCharac.InspLotDynamicRule AS InspLotDynamicRule,
  _InspCharac.QualityLevelInternalID AS QualityLevelInternalID,
  _InspCharac.BOOCharcGroup AS BOOCharcGroup,
  _InspCharac.BOOCharcSourceCharc AS BOOCharcSourceCharc,
  _InspCharac.BOOCharcGroupDivision AS BOOCharcGroupDivision,
  _InspCharac.ProductionOrderOperationActy AS ProductionOrderOperationActy,
  _InspCharac.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  _InspCharac._CharcAttribSelectedCodeSet AS _CharcAttribSelectedCodeSet,
  _InspCharac._InspCharacteristic AS _InspCharacteristic,
  _InspCharac._InspCharacteristicSampleUnit AS _InspCharacteristicSampleUnit,
  _InspCharac._InspCharacteristicStatus AS _InspCharacteristicStatus,
  _InspCharac._InspectionLot AS _InspectionLot,
  _InspCharac._InspectionMethodPlant AS _InspectionMethodPlant,
  _InspCharac._InspectionMethodVersion AS _InspectionMethodVersion,
  _InspCharac._InspectionOperation AS _InspectionOperation,
  _InspCharac._InspectionResult AS _InspectionResult,
  _InspCharac._InspectionResultValue AS _InspectionResultValue,
  _InspCharac._InspectionSpecification AS _InspectionSpecification,
  _InspCharac._InspectionSpecificationPlant AS _InspectionSpecificationPlant,
  _InspCharac._InspectionSpecificationUnit AS _InspectionSpecificationUnit,
  _InspCharac._InspLotDynamicRule AS _InspLotDynamicRule,
  _InspCharac._InspSampleResult AS _InspSampleResult,
  _InspCharac._InspSpecificationVersion AS _InspSpecificationVersion,
  _InspCharac._InspSpecImportanceCode AS _InspSpecImportanceCode,
  _InspCharac._InspSubsetCharacteristic AS _InspSubsetCharacteristic,
  _InspCharac._QuantityUnit AS _QuantityUnit,
  _InspCharac1.ProductionResourceTool AS ProductionResourceTool,
  _InspCharac1.ProductionResourceToolDesc AS ProductionResourceToolDesc,
  _InspSubsetCharacteristic.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
  _InspSubsetCharacteristic.InspSampleRejectionNumber AS InspSampleRejectionNumber,
  _InspSubsetCharacteristic.InspectionSampleSize AS InspectionSampleSize,
  InspResult.Inspector AS Inspector,
  InspResult._InspectionResultAttribute.InspResultAttributeIsValid AS InspResultAttributeIsValid,
  InspResult.InspectionResultAttribute AS InspectionResultAttribute,
  InspResult.InspectionResultOrigin AS InspectionResultOrigin,
  InspResult.InspectionValuationResult AS InspectionValuationResult,
  InspResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  InspResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  InspResult.InspectionResultMaximumValue AS InspectionResultMaximumValue,
  InspResult.InspResultHasMaximumValue AS InspResultHasMaximumValue,
  InspResult.InspectionResultMinimumValue AS InspectionResultMinimumValue,
  InspResult.InspResultHasMinimumValue AS InspResultHasMinimumValue,
  InspResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  InspResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  cast(InspResult.InspectionResultText as abap.sstring(1024) ) AS InspectionResultText,
  InspResult.InspectionResultHasLongText AS InspectionResultHasLongText,
  InspResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  InspResult.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  InspResult.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  InspResult.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  InspResult.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  InspResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  InspResult.InspRsltAboveToleranceFraction AS InspRsltAboveToleranceFraction,
  InspResult.InspRsltBelowToleranceFraction AS InspRsltBelowToleranceFraction,
  InspResult.InspResultVariance AS InspResultVariance,
  InspResult.InspectionResultCatalog2 AS InspectionResultCatalog2,
  InspResult.InspectionResultCatalog3 AS InspectionResultCatalog3,
  InspResult.InspectionResultCatalog4 AS InspectionResultCatalog4,
  InspResult.InspectionResultCatalog5 AS InspectionResultCatalog5,
  InspResult.InspectionResultCode2 AS InspectionResultCode2,
  InspResult.InspectionResultCode3 AS InspectionResultCode3,
  InspResult.InspectionResultCode4 AS InspectionResultCode4,
  InspResult.InspectionResultCode5 AS InspectionResultCode5,
  InspResult.InspectionResultCodeGroup2 AS InspectionResultCodeGroup2,
  InspResult.InspectionResultCodeGroup3 AS InspectionResultCodeGroup3,
  InspResult.InspectionResultCodeGroup4 AS InspectionResultCodeGroup4,
  InspResult.InspectionResultCodeGroup5 AS InspectionResultCodeGroup5,
  InspResult.InspectionPartialSampleSize AS InspectionPartialSampleSize,
  InspResult.InspectionStartDate AS InspectionStartDate,
  InspResult.InspectionStartTime AS InspectionStartTime,
  InspResult.InspectionEndDate AS InspectionEndDate,
  InspResult.InspectionEndTime AS InspectionEndTime,
  InspResult.CreatedByUser AS CreatedByUser,
  InspResult.CreationDate AS CreationDate,
  InspResult.LastChangedByUser AS LastChangedByUser,
  InspResult.LastChangeDate AS LastChangeDate,
  InspResult.ChangedDateTime AS ChangedDateTime,
  InspResult.ChangedTime AS ChangedTime,
  InspResult.CreationTime AS CreationTime,
  InspResult._InspectionOperation._WorkCenter.WorkCenter AS WorkCenter,
  _InspLots.Material AS Material,
  _InspLots.InspLotIsSerialNmbrPossible AS InspLotIsSerialNmbrPossible,
  _InspLots.SerialNumberProfile AS SerialNumberProfile
FROM I_InspectionCharacteristic AS _InspCharac
LEFT OUTER JOIN I_InspectionResult AS InspResult ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspSubsetCharacteristic AS _InspSubsetCharacteristic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_InspRsltValueMltplRsltRec AS _InspResultValue ON _InspCharac.InspectionLot = _InspResultValue.InspectionLot AND _InspCharac.InspPlanOperationInternalID = _InspResultValue.InspPlanOperationInternalID AND _InspCharac.InspectionCharacteristic = _InspResultValue.InspectionCharacteristic  -- association [0..*]
LEFT OUTER JOIN I_InspectionLot AS _InspLots ON _InspCharac.InspectionLot = _InspLots.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspSpecificationVersionText AS _InspSpecificationText ON _InspCharac.InspectionSpecification = _InspSpecificationText.InspectionSpecification AND _InspCharac.InspectionSpecificationPlant = _InspSpecificationText.InspectionSpecificationPlant AND _InspCharac.InspectionSpecificationVersion = _InspSpecificationText.InspectionSpecificationVersion AND _InspSpecificationText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_InspectionMethodVersionText AS _InspMethodText ON _InspCharac.InspectionMethod = _InspMethodText.InspectionMethod AND _InspCharac.InspectionMethodPlant = _InspMethodText.InspectionMethodPlant AND _InspCharac.InspectionMethodVersion = _InspMethodText.InspectionMethodVersion AND _InspMethodText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN C_Chargroupcode_Valuehelp AS _CodeVH ON _InspCharac.InspectionLot = _CodeVH.InspectionLot AND _InspCharac.InspPlanOperationInternalID = _CodeVH.InspPlanOperationInternalID AND _InspCharac.InspectionCharacteristic = _CodeVH.InspectionCharacteristic  -- association [0..*]
LEFT OUTER JOIN C_InspCharcMltplRsltRec AS _InspCharac1 ON _InspCharac.InspectionLot = _InspCharac1.InspectionLot AND _InspCharac.InspectionCharacteristic = _InspCharac1.InspectionCharacteristic AND _InspCharac.InspPlanOperationInternalID = _InspCharac1.InspPlanOperationInternalID  -- association [1..1]
;