C_QltyControlChartTrackValue

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_QltyControlChartTrackValue.
-- 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: CQLTYCNTRLCHTRKV

CREATE VIEW C_QltyControlChartTrackValue AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSubsetInternalID,
  QualityControlChart,
  '1' AS QualityControlChartTrack,
  cast(' ' as qqrkobject preserving type ) AS ControlChartValueObject,
  cast('0' as abap.dec(16,2)) AS ControlChartValue,
  '' AS ControlChartValueHasValue,
  cast(' ' as qkurztext preserving type) AS ControlChartValueText,
  _InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  _InspectionLot.Plant AS Plant,
  _InspectionOperation._WorkCenter.WorkCenter AS WorkCenter,
  _InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionLot.InspectionSubsetType AS InspectionSubsetType,
  _InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspectionLot._InspectionSubsetType AS _InspectionSubsetType
FROM I_InspSubsetCharacteristic
LEFT OUTER JOIN C_QualityControlChartTrack AS _ControlChartTrack ON QualityControlChart = _ControlChartTrack.QualityControlChart AND QualityControlChartTrack = _ControlChartTrack.QualityControlChartTrack  -- association [1..1]
;