I_InspectionResultValue

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_InspectionResultValue.
-- 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 I_InspectionResultValue AS
SELECT
  qase.prueflos AS InspectionLot,
  qase.vorglfnr AS InspPlanOperationInternalID,
  qase.merknr AS InspectionCharacteristic,
  qase.detailerg AS InspResultValueInternalID,
  qase.attribut AS InspectionResultAttribute,
  qase.stuecknr AS InspResultItemInternalID,
  qase.probenr AS InspectionSubsetInternalID,
  qase.messwert AS InspectionResultMeasuredValue,
  cast(case qase.messwertni when '*' then 'X' else qase.messwertni end as qmesswrtni preserving type ) AS InspResultHasMeasuredValue,
  qase.original_input AS InspectionResultOriginalValue,
  cast( qase.pruefbemkt as vdm_qinspectionvalueresultdesc preserving type ) AS InspectionResultText,
  qase.prltextkz AS InspectionResultHasLongText,
  qase.ltextspr AS Language,
  qase.estuecknr AS InspLotSingleUnitNumber,
  qase.serialnr AS InspectionResultItem,
  qase.maschine AS InspRsltFreeDefinedTestEquip,
  qase.mbewertg AS InspectionValuationResult,
  qase.gruppe1 AS CharacteristicAttributeCodeGrp,
  qase.gruppe2 AS InspectionResultCodeGroup2,
  qase.gruppe3 AS InspectionResultCodeGroup3,
  qase.gruppe4 AS InspectionResultCodeGroup4,
  qase.gruppe5 AS InspectionResultCodeGroup5,
  qase.code1 AS CharacteristicAttributeCode,
  qase.code2 AS InspectionResultCode2,
  qase.code3 AS InspectionResultCode3,
  qase.code4 AS InspectionResultCode4,
  qase.code5 AS InspectionResultCode5,
  qase.version1 AS CharcAttributeCodeVers,
  qase.version2 AS InspectionResultCode2Vers,
  qase.version3 AS InspectionResultCode3Vers,
  qase.version4 AS InspectionResultCode4Vers,
  qase.version5 AS InspectionResultCode5Vers,
  qase.katalgart1 AS CharacteristicAttributeCatalog,
  qase.katalgart2 AS InspectionResultCatalog2,
  qase.katalgart3 AS InspectionResultCatalog3,
  qase.katalgart4 AS InspectionResultCatalog4,
  qase.katalgart5 AS InspectionResultCatalog5,
  qase.pruefer AS Inspector,
  qase.pruefdatuv AS InspectionStartDate,
  qase.pruefzeitv AS InspectionStartTime,
  qase.pruefdatub AS InspectionEndDate,
  qase.pruefzeitb AS InspectionEndTime,
  qase.anzfehler AS InspectionNumberOfDefects,
  qase.fehlklas AS DefectClass,
  qase.diff_dec_places AS InspResultNrOfAddlDcmlsPlaces,
  qase.ersteller AS CreatedByUser,
  qase.erstelldat AS CreationDate,
  qase.aenderer AS LastChangedByUser,
  qase.aenderdat AS LastChangeDate,
  qase.zeitaend AS ChangedTime,
  qase.zeiterstl AS CreationTime
FROM qase
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspectionCharacteristic AS _InspectionCharacteristic ON InspectionLot = _InspectionCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspectionCharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _InspectionCharacteristic.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN I_InspSubsetCharacteristic AS _InspSubsetCharacteristic ON InspectionLot = _InspSubsetCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspSubsetCharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _InspSubsetCharacteristic.InspectionCharacteristic AND InspectionSubsetInternalID = _InspSubsetCharacteristic.InspectionSubsetInternalID  -- association [0..1]
LEFT OUTER JOIN I_InspResultValueLongText AS _InspResultValueLongText ON InspectionLot = _InspResultValueLongText.InspectionLot AND InspPlanOperationInternalID = _InspResultValueLongText.InspPlanOperationInternalID AND InspectionCharacteristic = _InspResultValueLongText.InspectionCharacteristic AND InspResultValueInternalID = _InspResultValueLongText.InspResultValueInternalID AND Language = _InspResultValueLongText.Language  -- association [0..*]
LEFT OUTER JOIN I_CharcAttributeCodeGrp AS _CharcAttributeCodeGrp ON CharacteristicAttributeCodeGrp = _CharcAttributeCodeGrp.CharacteristicAttributeCodeGrp  -- association [0..1]
LEFT OUTER JOIN I_CharcAttributeCode AS _CharcAttributeCode ON CharacteristicAttributeCodeGrp = _CharcAttributeCode.CharacteristicAttributeCodeGrp AND CharacteristicAttributeCode = _CharcAttributeCode.CharacteristicAttributeCode  -- association [0..1]
LEFT OUTER JOIN I_InspectionResultAttribute AS _InspectionResultAttribute ON InspectionResultAttribute = _InspectionResultAttribute.InspectionResultAttribute  -- association [0..1]
LEFT OUTER JOIN I_InspectionValuationResult AS _InspectionValuationResult ON InspectionValuationResult = _InspectionValuationResult.InspectionValuationResult  -- association [0..1]
LEFT OUTER JOIN E_InspectionResultValue AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionCharacteristic = _Extension.InspectionCharacteristic AND InspResultValueInternalID = _Extension.InspResultValueInternalID  -- association [1..1]
;