C_DefectMngCharcs

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_DefectMngCharcs.
-- 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.

CREATE VIEW C_DefectMngCharcs AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  cast( I_InspectionCharacteristic._InspectionOperation.InspectionOperation as vdm_vornr preserving type ) AS InspectionOperation,
  I_InspectionCharacteristic._InspectionOperation.OperationText AS OperationText,
  InspectionSpecificationText,
  InspSpecIsQuantitative,
  InspectionSpecificationUnit,
  InspSpecRecordingType,
  InspSpecUpperLimit,
  InspSpecHasUpperLimit,
  InspSpecLowerLimit,
  InspSpecHasLowerLimit,
  InspSpecDecimalPlaces,
  InspCharacteristicSampleSize,
  InspSpecSampleQuantityFactor,
  InspCharacteristicSampleUnit,
  I_InspectionCharacteristic._InspectionResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  I_InspectionCharacteristic._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  I_InspectionCharacteristic._InspectionResult.InspectionValuationResult AS InspectionValuationResult,
  _InspectionResult._InspectionValuationResult._Text[1:Language=$session.system_language].InspectionValuationResultText AS InspectionValuationResultText,
  I_InspectionCharacteristic._InspectionResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  I_InspectionCharacteristic._InspectionResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  cast( ' ' as vdm_qinspsummerizedresults preserving type ) AS InspectionResultMeanValueText,
  cast( ' ' as vdm_qinspspecification preserving type ) AS InspSpecToleranceLimitsText,
  I_InspectionCharacteristic._InspectionResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  cast( I_InspectionCharacteristic._InspectionResult.CharacteristicAttributeCode as vdm_qinspsummerizedresults) AS CharacteristicAttributeCode,
  I_InspectionCharacteristic._InspectionResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  I_InspectionCharacteristic._InspectionResult._CharcAttributeCode.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  InspectionMethodPlant,
  InspectionMethodVersion,
  InspectionCharacteristicStatus,
  _InspectionResult._InspectionValuationResult AS _InspectionValuationResult
FROM I_InspectionCharacteristic
LEFT OUTER JOIN I_InspectionResultStatus AS _InspectionResultStatus ON InspectionCharacteristicStatus = _InspectionResultStatus.InspectionResultStatus  -- association [0..1]
;