I_InspSubsetResult

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_InspSubsetResult.
-- 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: IINSPSUBSETRSLT

CREATE VIEW I_InspSubsetResult AS
SELECT
  qasr.prueflos AS InspectionLot,
  qasr.vorglfnr AS InspPlanOperationInternalID,
  qasr.merknr AS InspectionCharacteristic,
  qasr.probenr AS InspectionSubsetInternalID,
  qasr.pruefer AS Inspector,
  qasr.satzstatus AS InspectionResultStatus,
  qasr.qergdath AS InspectionResultOrigin,
  qasr.pruefdatuv AS InspectionStartDate,
  qasr.pruefzeitv AS InspectionStartTime,
  qasr.pruefdatub AS InspectionEndDate,
  qasr.pruefzeitb AS InspectionEndTime,
  qasr.attribut AS InspectionResultAttribute,
  qasr.mbewertg AS InspectionValuationResult,
  qasr.dbewertg AS InspResultDynModifValuation,
  qasr.mittelwert AS InspectionResultMeanValue,
  cast(case qasr.mittelwni when '*' then 'X' else qasr.mittelwni end as qninitial preserving type ) AS InspectionResultHasMeanValue,
  qasr.maxwert AS InspectionResultMaximumValue,
  cast(case qasr.maxwertni when '*' then 'X' else qasr.maxwertni end as qninitial preserving type ) AS InspResultHasMaximumValue,
  qasr.minwert AS InspectionResultMinimumValue,
  cast(case qasr.minwertni when '*' then 'X' else qasr.minwertni end as qninitial preserving type ) AS InspResultHasMinimumValue,
  qasr.original_input AS InspectionResultOriginalValue,
  qasr.anzwertg AS InspResultValidValuesNumber,
  cast( qasr.pruefbemkt as vdm_qinspectionsamplresultdesc preserving type ) AS InspectionResultText,
  qasr.prltextkz AS InspectionResultHasLongText,
  qasr.ltextspr AS Language,
  qasr.maschine AS InspRsltFreeDefinedTestEquip,
  qasr.anzwertu AS InspRsltBelowToleranceValsNmbr,
  qasr.anzwerto AS InspRsltAboveToleranceValsNmbr,
  qasr.iststpumf AS InspResultNmbrOfRecordedRslts,
  qasr.anzfehleh AS InspRsltNonconformingValsNmbr,
  qasr.anzfehler AS InspectionNumberOfDefects,
  qasr.anteilo AS InspRsltAboveToleranceFraction,
  qasr.anteilu AS InspRsltBelowToleranceFraction,
  qasr.varianz AS InspResultVariance,
  cast(case qasr.varianzni when '*' then 'X' else qasr.varianzni end as vdm_varianzni preserving type ) AS InspResultHasVariance,
  qasr.version1 AS CharcAttributeCodeVers,
  qasr.version2 AS InspectionResultCode2Vers,
  qasr.version3 AS InspectionResultCode3Vers,
  qasr.version4 AS InspectionResultCode4Vers,
  qasr.version5 AS InspectionResultCode5Vers,
  qasr.gruppe1 AS CharacteristicAttributeCodeGrp,
  qasr.gruppe2 AS InspectionResultCodeGroup2,
  qasr.gruppe3 AS InspectionResultCodeGroup3,
  qasr.gruppe4 AS InspectionResultCodeGroup4,
  qasr.gruppe5 AS InspectionResultCodeGroup5,
  qasr.code1 AS CharacteristicAttributeCode,
  qasr.code2 AS InspectionResultCode2,
  qasr.code3 AS InspectionResultCode3,
  qasr.code4 AS InspectionResultCode4,
  qasr.code5 AS InspectionResultCode5,
  qasr.katalgart1 AS CharacteristicAttributeCatalog,
  qasr.katalgart2 AS InspectionResultCatalog2,
  qasr.katalgart3 AS InspectionResultCatalog3,
  qasr.katalgart4 AS InspectionResultCatalog4,
  qasr.katalgart5 AS InspectionResultCatalog5,
  qasr.fehlklas AS DefectClass,
  qasr.ersteller AS CreatedByUser,
  qasr.erstelldat AS CreationDate,
  qasr.aenderer AS LastChangedByUser,
  qasr.aenderdat AS LastChangeDate,
  case qasr.changeddatetime when 0 then cast( '19000101010101' as tzntstmps ) else qasr.changeddatetime end as ChangedDateTime AS changeddatetimeendasChangedDateTime,
  qasr.zeitaend AS ChangedTime,
  qasr.zeiterstl AS CreationTime,
  qasr.diff_dec_places AS InspResultNrOfAddlDcmlsPlaces
FROM qasr
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 _InspectionSubsetInternalID ON InspectionLot = _InspectionSubsetInternalID.InspectionLot AND InspPlanOperationInternalID = _InspectionSubsetInternalID.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspectionSubsetInternalID.InspectionSubsetInternalID AND InspectionCharacteristic = _InspectionSubsetInternalID.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN I_CharcAttributeCode AS _CharcAttributeCode ON CharacteristicAttributeCodeGrp = _CharcAttributeCode.CharacteristicAttributeCodeGrp AND CharacteristicAttributeCode = _CharcAttributeCode.CharacteristicAttributeCode  -- association [0..1]
LEFT OUTER JOIN I_InspectionResultStatus AS _InspectionResultStatus ON InspectionResultStatus = _InspectionResultStatus.InspectionResultStatus  -- association [0..1]
LEFT OUTER JOIN I_InspectionResultAttribute AS _InspectionResultAttribute ON InspectionResultAttribute = _InspectionResultAttribute.InspectionResultAttribute  -- association [0..1]
LEFT OUTER JOIN I_InspectionResultOrigin AS _InspectionResultOrigin ON InspectionResultOrigin = _InspectionResultOrigin.InspectionResultOrigin  -- association [0..1]
LEFT OUTER JOIN I_InspectionValuationResult AS _InspectionValuationResult ON InspectionValuationResult = _InspectionValuationResult.InspectionValuationResult  -- association [0..1]
LEFT OUTER JOIN I_InspectionValuationResult AS _InspResultDynModifValuation ON InspResultDynModifValuation = _InspResultDynModifValuation.InspectionValuationResult  -- association [0..1]
LEFT OUTER JOIN I_InspectionValuationRsltText AS _InspectionValuationRsltTxt ON InspectionValuationResult = _InspectionValuationRsltTxt.InspectionValuationResult  -- association [0..*]
LEFT OUTER JOIN I_InspSubsetResultLongText AS _InspSubsetResultLongText ON InspectionLot = _InspSubsetResultLongText.InspectionLot AND InspPlanOperationInternalID = _InspSubsetResultLongText.InspPlanOperationInternalID AND InspectionCharacteristic = _InspSubsetResultLongText.InspectionCharacteristic AND InspectionSubsetInternalID = _InspSubsetResultLongText.InspectionSubsetInternalID  -- association [0..*]
LEFT OUTER JOIN E_Inspsubsetresult AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionCharacteristic = _Extension.InspectionCharacteristic AND InspectionSubsetInternalID = _Extension.InspectionSubsetInternalID  -- association [1..1]
;