C_InspSubsetCharcResult

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 C_InspSubsetCharcResult.
-- 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: CINSPSUBCHARCRES

CREATE VIEW C_InspSubsetCharcResult AS
SELECT
  InspSubsetCharcResult.InspectionLot AS InspectionLot,
  InspSubsetCharcResult.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  InspSubsetCharcResult.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  InspSubsetCharcResult.InspectionCharacteristic AS InspectionCharacteristic,
  InspSubsetCharcResult.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  InspSubsetCharcResult.QualityControlChart AS QualityControlChart,
  InspSubsetCharcResult.InspSampleAcceptanceNumber AS InspSampleAcceptanceNumber,
  InspSubsetCharcResult.InspSampleRejectionNumber AS InspSampleRejectionNumber,
  InspSubsetCharcResult.InspSampleValuationRule AS InspSampleValuationRule,
  InspSubsetCharcResult.InspectionSampleSize AS InspectionSampleSize,
  InspSubsetCharcResult.InspLotDynRuleStage AS InspLotDynRuleStage,
  InspSubsetCharcResult.ChangedDateTime AS ChangedDateTime,
  InspSubsetCharcResult.LastChangedByUser AS LastChangedByUser,
  InspSubsetCharcResult.CreatedByUser AS CreatedByUser,
  InspSubsetCharcResult.InspectionSeverity AS InspectionSeverity,
  InspSubsetCharcResult.Inspector AS Inspector,
  InspSubsetCharcResult.InspectionResultStatus AS InspectionResultStatus,
  InspSubsetCharcResult.InspectionResultOrigin AS InspectionResultOrigin,
  InspSubsetCharcResult.InspectionResultAttribute AS InspectionResultAttribute,
  InspSubsetCharcResult.InspectionValuationResult AS InspectionValuationResult,
  InspSubsetCharcResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  InspSubsetCharcResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  InspSubsetCharcResult.InspectionResultMaximumValue AS InspectionResultMaximumValue,
  InspSubsetCharcResult.InspResultHasMaximumValue AS InspResultHasMaximumValue,
  InspSubsetCharcResult.InspectionResultMinimumValue AS InspectionResultMinimumValue,
  InspSubsetCharcResult.InspResultHasMinimumValue AS InspResultHasMinimumValue,
  InspSubsetCharcResult.InspectionResultOriginalValue AS InspectionResultOriginalValue,
  InspSubsetCharcResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  InspSubsetCharcResult.InspectionResultText AS InspectionResultText,
  InspSubsetCharcResult.InspectionResultHasLongText AS InspectionResultHasLongText,
  InspSubsetCharcResult.Language AS Language,
  InspSubsetCharcResult.InspRsltFreeDefinedTestEquip AS InspRsltFreeDefinedTestEquip,
  InspSubsetCharcResult.InspRsltBelowToleranceValsNmbr AS InspRsltBelowToleranceValsNmbr,
  InspSubsetCharcResult.InspRsltAboveToleranceValsNmbr AS InspRsltAboveToleranceValsNmbr,
  InspSubsetCharcResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  InspSubsetCharcResult.InspRsltAboveToleranceFraction AS InspRsltAboveToleranceFraction,
  InspSubsetCharcResult.InspRsltBelowToleranceFraction AS InspRsltBelowToleranceFraction,
  InspSubsetCharcResult.InspResultVariance AS InspResultVariance,
  InspSubsetCharcResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  InspSubsetCharcResult.InspectionResultCodeGroup2 AS InspectionResultCodeGroup2,
  InspSubsetCharcResult.InspectionResultCodeGroup3 AS InspectionResultCodeGroup3,
  InspSubsetCharcResult.InspectionResultCodeGroup4 AS InspectionResultCodeGroup4,
  InspSubsetCharcResult.InspectionResultCodeGroup5 AS InspectionResultCodeGroup5,
  InspSubsetCharcResult.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  InspSubsetCharcResult.InspectionResultCode2 AS InspectionResultCode2,
  InspSubsetCharcResult.InspectionResultCode3 AS InspectionResultCode3,
  InspSubsetCharcResult.InspectionResultCode4 AS InspectionResultCode4,
  InspSubsetCharcResult.InspectionResultCode5 AS InspectionResultCode5,
  InspSubsetCharcResult.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  InspSubsetCharcResult.InspectionResultCatalog2 AS InspectionResultCatalog2,
  InspSubsetCharcResult.InspectionResultCatalog3 AS InspectionResultCatalog3,
  InspSubsetCharcResult.InspectionResultCatalog4 AS InspectionResultCatalog4,
  InspSubsetCharcResult.InspectionResultCatalog5 AS InspectionResultCatalog5,
  InspSubsetCharcResult.InspSpecAddlDecimalPlaces AS InspSpecAddlDecimalPlaces,
  InspSubsetCharcResult.InspSpecSummarizedDcmlPlaces AS InspSpecSummarizedDcmlPlaces,
  InspSubsetCharcResult.InspectionOperation AS InspectionOperation,
  InspCharAcceptedCount,
  InspCharRejectedCount,
  CharcStatusName,
  InspectionSpecificationText,
  HasInspCharcPrtlSmpl,
  InspCharacteristicSampleUnit,
  QuantityUnit,
  InspLotTestEquipInternalID,
  InspectionScope,
  InspectionMethod,
  InspectionMethodText,
  InspSpecDecimalPlaces,
  InspSpecHasTargetValue,
  InspSpecHasUpperLimit,
  InspSpecHasLowerLimit,
  InspectionMethodPlant,
  InspectionSpecification,
  InspectionMethodVersion,
  InspCharacteristicSampleSize,
  InspSpecSampleQuantityFactor,
  InspSpecControlIndicators,
  InspSpecIsMeasuredValueRqd,
  InspSpecTargetValue,
  InspSpecUpperLimit,
  InspSpecLowerLimit,
  InspectionSpecificationUnit,
  UnitOfMeasureTechnicalName,
  InspectionSpecificationPlant,
  InspectionSpecificationVersion,
  SelectedCodeSet,
  SelectedCodeSetPlant,
  SelectedCodeSetText,
  InspectionResultAttributeText,
  CharacteristicAttributeCodeTxt,
  cast( InspRsltNonconformingValsNmbr as abap.fltp) AS InspectionNonconformingRatio,
  InspSpecIsQuantitative,
  InspSpecIsLongTermInspection,
  InspSpecRecordingType,
  InspSpecCharcCategory,
  InspSpecResultCalculation,
  InspResultValueCount,
  InspSpecImportanceCode,
  InspSpecImportanceCodeText,
  InspResultIsDocumentationRqd,
  InspSpecHasFormula
FROM I_InspSubsetCharcResultTP AS InspSubsetCharcResult
LEFT OUTER JOIN C_InspCharcSubsetResults AS _InspCharcSubsetResults ON InspectionLot = _InspCharcSubsetResults.InspectionLot AND InspPlanOperationInternalID = _InspCharcSubsetResults.InspPlanOperationInternalID AND InspectionCharacteristic = _InspCharcSubsetResults.InspectionCharacteristic  -- association [0..*]
LEFT OUTER JOIN C_Chargroupcode_Valuehelp AS _Chargroupcode_Valuehelp ON SelectedCodeSetPlant = _Chargroupcode_Valuehelp.SelectedCodeSetPlant AND SelectedCodeSet = _Chargroupcode_Valuehelp.SelectedCodeSet AND InspectionLot = _Chargroupcode_Valuehelp.InspectionLot AND InspPlanOperationInternalID = _Chargroupcode_Valuehelp.InspPlanOperationInternalID AND InspectionCharacteristic = _Chargroupcode_Valuehelp.InspectionCharacteristic  -- association [0..*]
LEFT OUTER JOIN I_Inspectionresultstatustext AS _InspectionResultStatusText ON InspectionResultStatus = _InspectionResultStatusText.InspectionResultStatus  -- association [0..*]
LEFT OUTER JOIN I_Inspectionresultstatustext AS _InspCharacteristicStatusText ON InspectionCharacteristicStatus = _InspCharacteristicStatusText.InspectionResultStatus  -- association [0..*]
;