A_InspectionResult

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_InspectionResult.
-- 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: AINSPRESULT

CREATE VIEW A_InspectionResult AS
SELECT
  _InspResult.InspectionLot AS InspectionLot,
  _InspResult.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspResult.InspectionCharacteristic AS InspectionCharacteristic,
  _InspResult.InspectionResultStatus AS InspectionResultStatus,
  _InspResult.InspectionResultAttribute AS InspectionResultAttribute,
  _InspResult.InspectionResultOrigin AS InspectionResultOrigin,
  _InspResult.Inspector AS Inspector,
  _InspResult.InspectionValuationResult AS InspectionValuationResult,
  _InspResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  _InspResult.InspResultFrmtdMeanValue AS InspResultFrmtdMeanValue,
  _InspResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  _InspResult.InspectionResultMaximumValue AS InspectionResultMaximumValue,
  _InspResult.InspResultFrmtdMaximumValue AS InspResultFrmtdMaximumValue,
  _InspResult.InspResultHasMaximumValue AS InspResultHasMaximumValue,
  _InspResult.InspectionResultMinimumValue AS InspectionResultMinimumValue,
  _InspResult.InspResultFrmtdMinimumValue AS InspResultFrmtdMinimumValue,
  _InspResult.InspResultHasMinimumValue AS InspResultHasMinimumValue,
  _InspResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  _InspResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  _InspResult.InspectionResultText AS InspectionResultText,
  _InspResult.InspectionResultHasLongText AS InspectionResultHasLongText,
  _InspResult.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _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.InspectionNumberOfDefects AS InspectionNumberOfDefects,
  _InspResult.DefectClass AS DefectClass,
  _InspResult.InspRsltAboveToleranceFraction AS InspRsltAboveToleranceFraction,
  _InspResult.InspRsltFrmtdAbvTolFraction AS InspRsltFrmtdAbvTolFraction,
  _InspResult.InspRsltBelowToleranceFraction AS InspRsltBelowToleranceFraction,
  _InspResult.InspRsltFrmtdBelowTolFraction AS InspRsltFrmtdBelowTolFraction,
  _InspResult.InspResultVariance AS InspResultVariance,
  _InspResult.InspResultFrmtdVariance AS InspResultFrmtdVariance,
  _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.Plant AS Plant,
  _InspResult.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspResult.WorkCenter AS WorkCenter,
  _InspResult.InspectionLotType AS InspectionLotType,
  _InspResult.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspectionResultTP AS _InspResult
LEFT OUTER JOIN A_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN A_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN A_InspectionCharacteristic AS _InspCharc ON InspectionLot = _InspCharc.InspectionLot AND InspPlanOperationInternalID = _InspCharc.InspPlanOperationInternalID AND InspectionCharacteristic = _InspCharc.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN E_InspectionResult AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionCharacteristic = _Extension.InspectionCharacteristic  -- association [1..1]
;