A_InspectionCharacteristic

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 A_InspectionCharacteristic.
-- 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 A_InspectionCharacteristic AS
SELECT
  _InspCharc.InspectionLot AS InspectionLot,
  _InspCharc.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspCharc.InspectionCharacteristic AS InspectionCharacteristic,
  _InspCharc.InspectionSpecificationText AS InspectionSpecificationText,
  _InspCharc.HasInspCharcPrtlSmpl AS HasInspCharcPrtlSmpl,
  _InspCharc.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspCharc.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  _InspCharc.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  _InspCharc.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  _InspCharc.InspSpecRecordingType AS InspSpecRecordingType,
  _InspCharc.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
  _InspCharc.InspSpecCharcCategory AS InspSpecCharcCategory,
  _InspCharc.InspSpecResultCalculation AS InspSpecResultCalculation,
  _InspCharc.InspCharcIsNotPlanned AS InspCharcIsNotPlanned,
  _InspCharc.InspectionMethod AS InspectionMethod,
  _InspCharc.InspectionMethodPlant AS InspectionMethodPlant,
  _InspCharc.InspectionMethodVersion AS InspectionMethodVersion,
  _InspCharc.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _InspCharc.InspectionSpecification AS InspectionSpecification,
  _InspCharc.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _InspCharc.InspectionCharacteristicStatus AS InspectionCharacteristicStatus,
  _InspCharc.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspCharc.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _InspCharc.InspSampleValuationRule AS InspSampleValuationRule,
  _InspCharc.QuantityUnit AS QuantityUnit,
  _InspCharc.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  _InspCharc.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _InspCharc.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
  _InspCharc.InspSpecTargetValue AS InspSpecTargetValue,
  _InspCharc.InspSpecFrmtdTargetValue AS InspSpecFrmtdTargetValue,
  _InspCharc.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  _InspCharc.InspSpecUpperLimit AS InspSpecUpperLimit,
  _InspCharc.InspSpecFrmtdUpperLimit AS InspSpecFrmtdUpperLimit,
  _InspCharc.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  _InspCharc.InspSpecLowerLimit AS InspSpecLowerLimit,
  _InspCharc.InspSpecFrmtdLowerLimit AS InspSpecFrmtdLowerLimit,
  _InspCharc.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  _InspCharc.InspSpecImportanceCode AS InspSpecImportanceCode,
  _InspCharc.InspLotTestEquipInternalID AS InspLotTestEquipInternalID,
  _InspCharc.SelectedCodeSet AS SelectedCodeSet,
  _InspCharc.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  _InspCharc.InspectorQualification AS InspectorQualification,
  _InspCharc.InspSpecInformationField1 AS InspSpecInformationField1,
  _InspCharc.InspSpecInformationField2 AS InspSpecInformationField2,
  _InspCharc.InspSpecInformationField3 AS InspSpecInformationField3,
  _InspCharc.InspectionScope AS InspectionScope,
  _InspCharc.InspCharcQuantity AS InspCharcQuantity,
  _InspCharc.InspSpecControlIndicators AS InspSpecControlIndicators,
  _InspCharc.CharacteristicAttributeCatalog AS CharacteristicAttributeCatalog,
  _InspCharc.UnplndCharcInspSubsetIntID AS UnplndCharcInspSubsetIntID,
  _InspCharc.InspLotDynamicRule AS InspLotDynamicRule,
  _InspCharc.InspCharcConfirmationNumber AS InspCharcConfirmationNumber,
  _InspCharc.ChangedDateTime AS ChangedDateTime,
  _InspCharc.Plant AS Plant,
  _InspCharc.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _InspCharc.WorkCenter AS WorkCenter,
  _InspCharc.InspectionLotType AS InspectionLotType,
  _InspCharc.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
FROM I_InspCharacteristicTP AS _InspCharc
LEFT OUTER JOIN A_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN A_InspectionResult AS _InspResult ON InspectionLot = _InspResult.InspectionLot AND InspPlanOperationInternalID = _InspResult.InspPlanOperationInternalID AND InspectionCharacteristic = _InspResult.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN A_InspectionResultValue AS _InspResultValue ON InspectionLot = _InspResultValue.InspectionLot AND InspPlanOperationInternalID = _InspResultValue.InspPlanOperationInternalID AND InspectionCharacteristic = _InspResultValue.InspectionCharacteristic  -- association [1..*]
LEFT OUTER JOIN A_InspSampleCharacteristic AS _InspSmplCharc ON InspectionLot = _InspSmplCharc.InspectionLot AND InspPlanOperationInternalID = _InspSmplCharc.InspPlanOperationInternalID AND InspectionCharacteristic = _InspSmplCharc.InspectionCharacteristic  -- association [1..*]
LEFT OUTER JOIN A_InspSampleResult AS _InspSmplResult ON InspectionLot = _InspSmplResult.InspectionLot AND InspPlanOperationInternalID = _InspSmplResult.InspPlanOperationInternalID AND InspectionCharacteristic = _InspSmplResult.InspectionCharacteristic  -- association [1..*]
LEFT OUTER JOIN E_InspectionCharacteristic AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionCharacteristic = _Extension.InspectionCharacteristic  -- association [1..1]
;