C_DefectMngCharacteristicsSbst

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_DefectMngCharacteristicsSbst.
-- 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: CDEFECTMNGSBST

CREATE VIEW C_DefectMngCharacteristicsSbst AS
SELECT
  _InspSubset.InspectionLot AS InspectionLot,
  _InspSubset.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspSubset.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _InspSubset.MaterialSample AS MaterialSample,
  _InspSubsetChar.InspectionCharacteristic AS InspectionCharacteristic,
  cast('' as qpruefpkt) AS InspectionSubset,
  cast( _InspSubset._InspectionOperation.InspectionOperation as vdm_vornr preserving type ) AS InspectionOperation,
  _InspSubset._InspectionOperation.OperationText AS OperationText,
  _InspSubsetChar._InspectionLot.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  _InspectionSubset.InspectionSubsetDate AS InspectionSubsetDate,
  _InspectionSubset.InspectionSubsetLongCharKey AS InspectionSubsetLongCharKey,
  _InspectionSubset.InspectionSubsetShortCharKey AS InspectionSubsetShortCharKey,
  _InspectionSubset.InspSubsetLongNumericKey AS InspSubsetLongNumericKey,
  _InspectionSubset.InspSubsetShortNumericKey AS InspSubsetShortNumericKey,
  _InspectionSubset.Equipment AS Equipment,
  _InspectionSubset.FunctionalLocation AS FunctionalLocation,
  _InspSubsetChar._InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspSubsetChar._InspectionCharacteristic.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType AS InspSpecRecordingType,
  _InspSubsetChar._InspectionCharacteristic.InspSpecUpperLimit AS InspSpecUpperLimit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecLowerLimit AS InspSpecLowerLimit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspSubsetChar._InspectionCharacteristic.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  _InspSubsetChar._InspectionCharacteristic.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
  _InspSubsetChar._InspectionCharacteristic._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  _InspSubsetChar._InspSubsetResult.InspectionValuationResult AS InspectionValuationResult,
  _InspSubsetChar._InspSubsetResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  cast( '' as vdm_qinspsummerizedresults ) AS InspectionResultMeanValueText,
  cast( '' as vdm_qinspspecification ) AS InspSpecToleranceLimitsText,
  _InspSubsetChar._InspSubsetResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  cast(_InspSubsetChar._InspSubsetResult.CharacteristicAttributeCode as vdm_qinspsummerizedresults ) AS CharacteristicAttributeCode,
  _InspSubsetChar._InspSubsetResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _InspSubsetChar._InspSubsetResult._CharcAttributeCode.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  _InspSubsetChar._InspSubsetResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  _InspSubsetChar._InspSubsetResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  _InspSubset._InspectionLot AS _InspectionLot,
  _InspSubset._InspectionOperation AS _InspectionOperation
FROM I_InspSubsetCharacteristic AS _InspSubsetChar
INNER JOIN I_InspectionSubset AS _InspSubset ON /* join condition not captured in parsed metadata */
;