I_InspSampleResultTP

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_InspSampleResultTP.
-- 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: IINSPSAMPLERESTP

CREATE VIEW I_InspSampleResultTP AS
SELECT
  _InspSampleResult.InspectionLot AS InspectionLot,
  _InspSampleResult.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspSampleResult.InspectionCharacteristic AS InspectionCharacteristic,
  _InspSampleResult.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _InspSampleResult.Inspector AS Inspector,
  _InspSampleResult.InspectionResultStatus AS InspectionResultStatus,
  _InspSampleResult.InspectionResultOrigin AS InspectionResultOrigin,
  _InspSampleResult.InspectionStartDate AS InspectionStartDate,
  _InspSampleResult.InspectionStartTime AS InspectionStartTime,
  _InspSampleResult.InspectionEndDate AS InspectionEndDate,
  _InspSampleResult.InspectionEndTime AS InspectionEndTime,
  _InspSampleResult.InspectionResultAttribute AS InspectionResultAttribute,
  _InspSampleResult.InspectionValuationResult AS InspectionValuationResult,
  _InspSampleResult.InspResultDynModifValuation AS InspResultDynModifValuation,
  _InspSampleResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  _FrmtdVal.InspResultFrmtdMeanValue AS InspResultFrmtdMeanValue,
  _InspSampleResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  _InspSampleResult.InspectionResultMaximumValue AS InspectionResultMaximumValue,
  _FrmtdVal.InspResultFrmtdMaximumValue AS InspResultFrmtdMaximumValue,
  _InspSampleResult.InspResultHasMaximumValue AS InspResultHasMaximumValue,
  _InspSampleResult.InspectionResultMinimumValue AS InspectionResultMinimumValue,
  _FrmtdVal.InspResultFrmtdMinimumValue AS InspResultFrmtdMinimumValue,
  _InspSampleResult.InspResultHasMinimumValue AS InspResultHasMinimumValue,
  _InspSampleResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  _InspSampleResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  _InspSampleResult.InspectionResultText AS InspectionResultText,
  _InspSampleResult.InspectionResultHasLongText AS InspectionResultHasLongText,
  _InspSampleResult.Language AS Language,
  _InspSampleResult.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  _InspSampleResult.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  _InspSampleResult.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  _InspSampleResult.InspRsltAboveToleranceFraction AS InspRsltAboveToleranceFraction,
  _FrmtdVal.InspRsltFrmtdAbvTolFraction AS InspRsltFrmtdAbvTolFraction,
  _InspSampleResult.InspRsltBelowToleranceFraction AS InspRsltBelowToleranceFraction,
  _FrmtdVal.InspRsltFrmtdBelowTolFraction AS InspRsltFrmtdBelowTolFraction,
  _InspSampleResult.InspResultVariance AS InspResultVariance,
  _FrmtdVal.InspResultFrmtdVariance AS InspResultFrmtdVariance,
  _InspSampleResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  _InspSampleResult.InspResultNmbrOfRecordedRslts AS InspResultNmbrOfRecordedRslts,
  _InspSampleResult.InspectionNumberOfDefects AS InspectionNumberOfDefects,
  _InspSampleResult.CharcAttributeCodeVers AS CharcAttributeCodeVers,
  _InspSampleResult.InspectionResultCode2Vers AS InspectionResultCode2Vers,
  _InspSampleResult.InspectionResultCode3Vers AS InspectionResultCode3Vers,
  _InspSampleResult.InspectionResultCode4Vers AS InspectionResultCode4Vers,
  _InspSampleResult.InspectionResultCode5Vers AS InspectionResultCode5Vers,
  _InspSampleResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _InspSampleResult.InspectionResultCodeGroup2 AS InspectionResultCodeGroup2,
  _InspSampleResult.InspectionResultCodeGroup3 AS InspectionResultCodeGroup3,
  _InspSampleResult.InspectionResultCodeGroup4 AS InspectionResultCodeGroup4,
  _InspSampleResult.InspectionResultCodeGroup5 AS InspectionResultCodeGroup5,
  _InspSampleResult.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  _InspSampleResult.InspectionResultCode2 AS InspectionResultCode2,
  _InspSampleResult.InspectionResultCode3 AS InspectionResultCode3,
  _InspSampleResult.InspectionResultCode4 AS InspectionResultCode4,
  _InspSampleResult.InspectionResultCode5 AS InspectionResultCode5,
  _InspSampleResult.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _InspSampleResult.InspectionResultCatalog2 AS InspectionResultCatalog2,
  _InspSampleResult.InspectionResultCatalog3 AS InspectionResultCatalog3,
  _InspSampleResult.InspectionResultCatalog4 AS InspectionResultCatalog4,
  _InspSampleResult.InspectionResultCatalog5 AS InspectionResultCatalog5,
  _InspSampleResult.DefectClass AS DefectClass,
  _InspSampleResult.CreatedByUser AS CreatedByUser,
  _InspSampleResult.CreationDate AS CreationDate,
  _InspSampleResult.CreationTime AS CreationTime,
  _InspSampleResult.LastChangedByUser AS LastChangedByUser,
  _InspSampleResult.LastChangeDate AS LastChangeDate,
  _InspSampleResult.ChangedTime AS ChangedTime,
  _InspectionResult.ChangedDateTime AS ChangedDateTime,
  _InspLot.Plant AS Plant,
  _InspLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspOper._WorkCenter.WorkCenter AS WorkCenter,
  _InspLot.InspectionLotType AS InspectionLotType,
  _InspLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspSubsetResult AS _InspSampleResult
INNER JOIN I_InspectionLot AS _InspLot ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionOperation AS _InspOper ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspectionResultTP AS _InspectionResult ON /* join condition not captured in parsed metadata */
INNER JOIN I_InspSampleResultFrmtdValues AS _FrmtdVal ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspCharacteristicTP AS _InspCharc ON InspectionLot = _InspCharc.InspectionLot AND InspPlanOperationInternalID = _InspCharc.InspPlanOperationInternalID AND InspectionCharacteristic = _InspCharc.InspectionCharacteristic  -- association [1..1]
;