I_InspSubsetCharcResultTP

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_InspSubsetCharcResultTP.
-- 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: IINSPSSCHARTP

CREATE VIEW I_InspSubsetCharcResultTP AS
SELECT
  InspSubsetChar.InspectionLot AS InspectionLot,
  InspSubsetChar.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspSubsetChar.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspSubsetChar.InspectionCharacteristic AS InspectionCharacteristic,
  InspSubsetChar.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  InspSubsetChar.QualityControlChart AS QualityControlChart,
  InspSubsetChar.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
  InspSubsetChar.InspSampleRejectionNumber AS InspSampleRejectionNumber,
  InspSubsetChar.InspSampleValuationRule AS InspSampleValuationRule,
  InspSubsetChar.InspectionSampleSize AS InspectionSampleSize,
  InspSubsetChar.InspLotDynRuleStage AS InspLotDynRuleStage,
  InspSubsetChar.InspectionSeverity AS InspectionSeverity,
  InspSubsetResult.ChangedDateTime AS ChangedDateTime,
  InspSubsetResult.LastChangedByUser AS LastChangedByUser,
  InspSubsetResult.CreatedByUser AS CreatedByUser,
  InspSubsetResult.Inspector AS Inspector,
  InspSubsetResult.InspectionResultStatus AS InspectionResultStatus,
  InspSubsetResult.InspectionResultOrigin AS InspectionResultOrigin,
  InspSubsetResult.InspectionResultAttribute AS InspectionResultAttribute,
  InspSubsetResult.InspectionValuationResult AS InspectionValuationResult,
  InspSubsetResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  InspSubsetResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  InspSubsetResult.InspectionResultMaximumValue AS InspectionResultMaximumValue,
  InspSubsetResult.InspResultHasMaximumValue AS InspResultHasMaximumValue,
  InspSubsetResult.InspectionResultMinimumValue AS InspectionResultMinimumValue,
  InspSubsetResult.InspResultHasMinimumValue AS InspResultHasMinimumValue,
  InspSubsetResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  InspSubsetResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  cast(InspSubsetResult.InspectionResultText as abap.sstring( 1024 )) AS InspectionResultText,
  InspSubsetResult.InspectionResultHasLongText AS InspectionResultHasLongText,
  InspSubsetResult.Language AS Language,
  InspSubsetResult.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  InspSubsetResult.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  InspSubsetResult.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  InspSubsetResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  InspSubsetResult.InspRsltAboveToleranceFraction AS InspRsltAboveToleranceFraction,
  InspSubsetResult.InspRsltBelowToleranceFraction AS InspRsltBelowToleranceFraction,
  InspSubsetResult.InspResultVariance AS InspResultVariance,
  InspSubsetResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  InspSubsetResult.InspectionResultCodeGroup2 AS InspectionResultCodeGroup2,
  InspSubsetResult.InspectionResultCodeGroup3 AS InspectionResultCodeGroup3,
  InspSubsetResult.InspectionResultCodeGroup4 AS InspectionResultCodeGroup4,
  InspSubsetResult.InspectionResultCodeGroup5 AS InspectionResultCodeGroup5,
  InspSubsetResult.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  InspSubsetResult.InspectionResultCode2 AS InspectionResultCode2,
  InspSubsetResult.InspectionResultCode3 AS InspectionResultCode3,
  InspSubsetResult.InspectionResultCode4 AS InspectionResultCode4,
  InspSubsetResult.InspectionResultCode5 AS InspectionResultCode5,
  InspSubsetResult.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  InspSubsetResult.InspectionResultCatalog2 AS InspectionResultCatalog2,
  InspSubsetResult.InspectionResultCatalog3 AS InspectionResultCatalog3,
  InspSubsetResult.InspectionResultCatalog4 AS InspectionResultCatalog4,
  InspSubsetResult.InspectionResultCatalog5 AS InspectionResultCatalog5,
  Configuration.InspSpecAddlDecimalPlaces AS InspSpecAddlDecimalPlaces,
  Configuration.InspSpecAddlDecimalPlaces + InspSubsetChar._InspectionCharacteristic.InspSpecDecimalPlaces AS InspSpecSummarizedDcmlPlaces,
  _InspectionOperation.InspectionOperation AS InspectionOperation,
  _InspectionCharacteristic.InspSpecRecordingType AS InspSpecRecordingType,
  _InspectionCharacteristic.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspectionCharacteristic.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  _InspectionCharacteristic.InspSpecCharcCategory AS InspSpecCharcCategory,
  _InspectionCharacteristic.InspSpecResultCalculation AS InspSpecResultCalculation,
  InspSubsetCharcAggregate.InspCharAcceptedCount AS InspCharAcceptedCount,
  InspSubsetCharcAggregate.InspCharRejectedCount AS InspCharRejectedCount,
  _InspectionResultStatus._Text[1:Language=$session.system_language].InspectionResultStatusText AS InspectionResultStatusText,
  _InspCharacteristicStatus._Text[1:Language=$session.system_language].InspectionResultStatusText AS CharcStatusName,
  _InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  _InspectionCharacteristic.HasInspCharcPrtlSmpl AS HasInspCharcPrtlSmpl,
  _InspectionCharacteristic.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _InspectionCharacteristic.QuantityUnit AS QuantityUnit,
  _InspectionCharacteristic.InspLotTestEquipInternalID AS InspLotTestEquipInternalID,
  _InspectionCharacteristic.InspCharcQuantity AS InspectionScope,
  _InspectionCharacteristic._InspectionMethodVersion.InspectionMethod AS InspectionMethod,
  _InspectionCharacteristic._InspectionMethodVersion._InspectionMethodText[1:Language = $session.system_language].InspectionMethodText AS InspectionMethodText,
  _InspectionCharacteristic.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspectionCharacteristic.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  _InspectionCharacteristic.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  _InspectionCharacteristic.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  _InspectionCharacteristic.InspectionMethodPlant AS InspectionMethodPlant,
  _InspectionCharacteristic.InspectionSpecification AS InspectionSpecification,
  _InspectionCharacteristic.InspectionMethodVersion AS InspectionMethodVersion,
  _InspectionCharacteristic.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  _InspectionCharacteristic.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
  _InspectionCharacteristic.InspSpecControlIndicators AS InspSpecControlIndicators,
  _InspectionCharacteristic.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  _InspectionCharacteristic.InspSpecTargetValue AS InspSpecTargetValue,
  _InspectionCharacteristic.InspSpecUpperLimit AS InspSpecUpperLimit,
  _InspectionCharacteristic.InspSpecLowerLimit AS InspSpecLowerLimit,
  _InspectionCharacteristic.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _InspectionCharacteristic._InspectionSpecificationUnit._Text[1:Language=$session.system_language].UnitOfMeasureTechnicalName AS UnitOfMeasureTechnicalName,
  _InspectionCharacteristic.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _InspectionCharacteristic.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _InspectionCharacteristic.SelectedCodeSet AS SelectedCodeSet,
  _InspectionCharacteristic.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  _InspectionCharacteristic._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  _InspectionResultAttribute._Text[1:Language=$session.system_language].InspectionResultAttributeText AS InspectionResultAttributeText,
  _InspectionCharcAttriCodeText.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  _InspCharcValueAggregate.InspResultValueCount AS InspResultValueCount,
  _InspectionCharacteristic.InspSpecImportanceCode AS InspSpecImportanceCode,
  _InspectionCharacteristic._InspSpecImportanceCode.InspSpecImportanceCodeText AS InspSpecImportanceCodeText,
  _InspectionCharacteristic.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd
FROM I_InspSubsetCharacteristic AS InspSubsetChar
LEFT OUTER JOIN I_InspectionSubsetTP AS _InspectionSubset ON InspectionLot = _InspectionSubset.InspectionLot AND InspPlanOperationInternalID = _InspectionSubset.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspectionSubset.InspectionSubsetInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspSubsetResultValueTP AS _InspectionResultValue ON InspectionLot = _InspectionResultValue.InspectionLot AND InspPlanOperationInternalID = _InspectionResultValue.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspectionResultValue.InspectionSubsetInternalID AND InspectionCharacteristic = _InspectionResultValue.InspectionCharacteristic  -- association [0..*]
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_CharcAttributeCodeText AS _InspectionCharcAttriCodeText ON CharacteristicAttributeCode = _InspectionCharcAttriCodeText.CharacteristicAttributeCode AND CharacteristicAttributeCodeGrp = _InspectionCharcAttriCodeText.CharacteristicAttributeCodeGrp AND _InspectionCharcAttriCodeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_InspCharcValueAggregate AS _InspCharcValueAggregate ON InspectionLot = _InspCharcValueAggregate.InspectionLot AND InspPlanOperationInternalID = _InspCharcValueAggregate.InspPlanOperationInternalID AND InspectionCharacteristic = _InspCharcValueAggregate.InspectionCharacteristic AND InspectionSubsetInternalID = _InspCharcValueAggregate.InspectionSubsetInternalID  -- association [1..1]
;