I_QualityControlChart

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_QualityControlChart.
-- 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: IQLTYCNTRLCHART

CREATE VIEW I_QualityControlChart AS
SELECT
  qrknr AS QualityControlChart,
  qrkart AS QualityControlChartType,
  spckrit AS QltyCtrlChartAggrgnCriterion,
  werk AS Plant,
  cast( plnty as vdm_plnty preserving type ) AS BillOfOperationsType,
  cast( plnnr as vdm_plnnr preserving type ) AS BillOfOperationsGroup,
  cast( plnal as vdm_plnal preserving type ) AS BillOfOperationsVariant,
  plnfl AS BillOfOperationsRefSequence,
  plnkn AS BOOOperationInternalID,
  plmknr AS InspectionCharacteristic,
  cast( qpmk_werks as vdm_qpmk_werks preserving type ) AS InspectionSpecificationPlant,
  verwmerkm AS InspectionSpecification,
  lsprueflos AS InspectionLot,
  poplatz AS WorkCenter,
  cast( poplatzwrk as vdm_poplatzwrk preserving type ) AS MainWorkCenterPlant,
  ppequnr AS Equipment,
  pptplnr AS FunctionalLocation,
  lsmatnr AS Material,
  lslifnr AS Supplier,
  cast( kurztext as vdm_qrknr_text preserving type ) AS QualityControlChartText,
  status AS QualityControlChartStatus,
  ename AS QltyCtrlChartCreatedByUser,
  cast( edatum as vdm_erdat preserving type ) AS QltyCtrlChartCreationDate,
  ezeit AS QltyCtrlChartCreationTime,
  aname AS QltyCtrlChartLastChangedByUser,
  adatum AS QltyCtrlChartLastChangedDate,
  azeit AS QltyCtrlChartLastChangedTime,
  toleranzob AS InspSpecUpperLimit,
  cast( tolobni as vdm_qninitial preserving type ) AS InspSpecHasUpperLimit,
  toleranzun AS InspSpecLowerLimit,
  cast( tolunni as vdm_qninitial preserving type ) AS InspSpecHasLowerLimit
FROM qash
LEFT OUTER JOIN I_QltyCtrlChartAggrgnCriterion AS _QltyCtrlChartAggrgnCriterion ON QltyCtrlChartAggrgnCriterion = _QltyCtrlChartAggrgnCriterion.QltyCtrlChartAggrgnCriterion  -- association [1..1]
LEFT OUTER JOIN I_QualityControlChartTrack AS _QualityControlChartTrack ON QualityControlChart = _QualityControlChartTrack.QualityControlChart  -- association [0..*]
LEFT OUTER JOIN I_QualityControlChartType AS _QualityControlChartType ON QualityControlChartType = _QualityControlChartType.QualityControlChartType  -- association [1..1]
LEFT OUTER JOIN I_QltyControlChartTypeTrack AS _QltyControlChartTypeTrack ON QualityControlChartType = _QltyControlChartTypeTrack.QualityControlChartType  -- association [0..*]
LEFT OUTER JOIN I_QualityControlChartStatus AS _QualityControlChartStatus ON QualityControlChartStatus = _QualityControlChartStatus.QualityControlChartStatus  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenter ON WorkCenter = _WorkCenter.WorkCenter AND MainWorkCenterPlant = _WorkCenter.Plant  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MainWorkCenterPlant ON MainWorkCenterPlant = _MainWorkCenterPlant.Plant  -- association [0..1]
;