I_InspSubsetCharacteristic

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_InspSubsetCharacteristic.
-- 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: IINSPSUBSETCHAR

CREATE VIEW I_InspSubsetCharacteristic AS
SELECT
  prueflos AS InspectionLot,
  vorglfnr AS InspPlanOperationInternalID,
  merknr AS InspectionCharacteristic,
  probenr AS InspectionSubsetInternalID,
  qasv.satzstatus AS InspectionCharacteristicStatus,
  qasv.qrknr AS QualityControlChart,
  qasv.annahmez AS InspSampleAcceptanceNumber,
  qasv.rueckwez AS InspSampleRejectionNumber,
  qasv.kfaktorni AS InspSampleHasAcceptanceFactor,
  qasv.kfaktor AS InspSampleAcceptanceFactor,
  qasv.antverf AS DefectFractionEstimationProced,
  qasv.bewregel AS InspSampleValuationRule,
  qasv.fakplanme AS BOOCharcMatlToSampleUnitRate,
  qasv.fakprobme AS BOOCharcSampleToMatlUnitRate,
  qasv.stiproumf AS InspectionSampleSize,
  qasv.probemgeh AS InspCharacteristicSampleUnit,
  qasv.probmgfak AS InspSpecSampleQuantityFactor,
  qasv.pruefumf AS InspectionSampleQuantity,
  qasv.mengeneinh AS InspectionLotSampleUnit,
  qasv.prstufe AS InspLotDynRuleStage,
  qasv.prschaerfe AS InspectionSeverity,
  qasv.erstelldat AS InspSubsetCharcCreationDate
FROM qasv
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_InspectionSubset AS _InspectionSubset ON InspectionLot = _InspectionSubset.InspectionLot AND InspPlanOperationInternalID = _InspectionSubset.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspectionSubset.InspectionSubsetInternalID  -- 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_InspSubsetResult AS _InspSubsetResult ON InspectionLot = _InspSubsetResult.InspectionLot AND InspPlanOperationInternalID = _InspSubsetResult.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspSubsetResult.InspectionSubsetInternalID AND InspectionCharacteristic = _InspSubsetResult.InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_InspectionResultValue AS _InspectionResultValue ON InspectionLot = _InspectionResultValue.InspectionLot AND InspPlanOperationInternalID = _InspectionResultValue.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspectionResultValue.InspectionSubsetInternalID AND InspectionCharacteristic = _InspectionResultValue.InspectionCharacteristic  -- association [0..*]
LEFT OUTER JOIN I_InspectionResultStatus AS _InspCharacteristicStatus ON InspectionCharacteristicStatus = _InspCharacteristicStatus.InspectionResultStatus  -- association [0..1]
LEFT OUTER JOIN I_InspectionSeverity AS _InspectionSeverity ON InspectionSeverity = _InspectionSeverity.InspectionSeverity  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _InspCharcSampleUnit ON InspCharacteristicSampleUnit = _InspCharcSampleUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN E_InspSubsetCharacteristic AS _Extension ON InspectionLot = _Extension.InspectionLot AND InspPlanOperationInternalID = _Extension.InspPlanOperationInternalID AND InspectionCharacteristic = _Extension.InspectionCharacteristic AND InspectionSubsetInternalID = _Extension.InspectionSubsetInternalID  -- association [1..1]
;