C_QualityControlDeviations

DDL: C_QUALITYCONTROLDEVIATIONS SQL: CQLTYCTRLDVTNS Type: view CONSUMPTION Package: ODATA_QM_INSPECTION_ANALYTICS
30 Fields 1 Data Sources 3 Associations

Quality Control Deviations for SPC

C_QualityControlDeviations is a Consumption CDS View that provides data about "Quality Control Deviations for SPC" in SAP S/4HANA. It reads from 1 data source (I_QualityControlChart) and exposes 30 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID. It has 3 associations to related views. Part of development package ODATA_QM_INSPECTION_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
I_QualityControlChart _QualityControlChart from

Associations (3)

CardinalityTargetAliasCondition
[0..*] P_QualityControlChartResults _QualityControlChartResults $projection.QualityControlChart = _QualityControlChartResults.QualityControlChart
[1..1] P_InspCharcSmplSizeAggrgn _InspCharcSmplSizeAggrgn $projection.QualityControlChart = _InspCharcSmplSizeAggrgn.QualityControlChart
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYCTRLDVTNS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Quality Control Deviations for SPC view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot _QualityControlChartResults InspectionLot Inspection Lot
KEY InspPlanOperationInternalID _QualityControlChartResults InspPlanOperationInternalID
KEY InspectionCharacteristic _QualityControlChartResults InspectionCharacteristic Characteristic
KEY InspectionSubsetInternalID _QualityControlChartResults InspectionSubsetInternalID
QualityControlChart I_QualityControlChart QualityControlChart Control Chart
QltyCtrlChartAggrgnCriterion I_QualityControlChart QltyCtrlChartAggrgnCriterion SPC Criterion
InspectionSpecification I_QualityControlChart InspectionSpecification Master IC
QualityControlChartStatus I_QualityControlChart QualityControlChartStatus Workflow Status
QualityControlChartType I_QualityControlChart QualityControlChartType Ctrl Chart Type
Supplier I_QualityControlChart Supplier Supplier
QltyCtrlChartCreationDate I_QualityControlChart QltyCtrlChartCreationDate
Plant _QualityControlChartResults Plant Valuation Area
Material _QualityControlChartResults Material Vehicle Model
InspectionLotOrigin _QualityControlChartResults InspectionLotOrigin
InspectionLotType _QualityControlChartResults InspectionLotType Inspection Type
BillOfOperationsType _QualityControlChartResults BillOfOperationsType Task List Type
BillOfOperationsGroup _QualityControlChartResults BillOfOperationsGroup Group
BillOfOperationsVariant _QualityControlChartResults BillOfOperationsVariant Group Counter
InspLotSelectionSupplier _QualityControlChartResults Supplier Supplier
Customer _QualityControlChartResults Customer Sold-to Party
Manufacturer _QualityControlChartResults Manufacturer Manufacturer
WorkCenter _QualityControlChartResults WorkCenter Work Center
WorkCenterText _QualityControlChartResults WorkCenterText Work Center Text
InspectionSpecificationText _QualityControlChartResults InspectionSpecificationText
InspectionValuationResult _QualityControlChartResults InspectionValuationResult
InspectionEndDate _QualityControlChartResults InspectionEndDate
InspSubsetResultValuation _QualityControlChartResults InspSubsetResultValuation
IsBusinessPurposeCompleted _Supplier IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup _Supplier AuthorizationGroup AuthorizGroup
_InspectionLot _QualityControlChartResults _InspectionLot

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_QualityControlDeviations.
-- 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: CQLTYCTRLDVTNS

CREATE VIEW C_QualityControlDeviations AS
SELECT
  _QualityControlChartResults.InspectionLot AS InspectionLot,
  _QualityControlChartResults.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _QualityControlChartResults.InspectionCharacteristic AS InspectionCharacteristic,
  _QualityControlChartResults.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _QualityControlChart.QualityControlChart AS QualityControlChart,
  _QualityControlChart.QltyCtrlChartAggrgnCriterion AS QltyCtrlChartAggrgnCriterion,
  _QualityControlChart.InspectionSpecification AS InspectionSpecification,
  _QualityControlChart.QualityControlChartStatus AS QualityControlChartStatus,
  _QualityControlChart.QualityControlChartType AS QualityControlChartType,
  _QualityControlChart.Supplier AS Supplier,
  _QualityControlChart.QltyCtrlChartCreationDate AS QltyCtrlChartCreationDate,
  _QualityControlChartResults.Plant AS Plant,
  _QualityControlChartResults.Material AS Material,
  _QualityControlChartResults.InspectionLotOrigin AS InspectionLotOrigin,
  _QualityControlChartResults.InspectionLotType AS InspectionLotType,
  _QualityControlChartResults.BillOfOperationsType AS BillOfOperationsType,
  _QualityControlChartResults.BillOfOperationsGroup AS BillOfOperationsGroup,
  _QualityControlChartResults.BillOfOperationsVariant AS BillOfOperationsVariant,
  _QualityControlChartResults.Supplier AS InspLotSelectionSupplier,
  _QualityControlChartResults.Customer AS Customer,
  _QualityControlChartResults.Manufacturer AS Manufacturer,
  _QualityControlChartResults.WorkCenter AS WorkCenter,
  _QualityControlChartResults.WorkCenterText AS WorkCenterText,
  _QualityControlChartResults.InspectionSpecificationText AS InspectionSpecificationText,
  _QualityControlChartResults.InspectionValuationResult AS InspectionValuationResult,
  _QualityControlChartResults.InspectionEndDate AS InspectionEndDate,
  _QualityControlChartResults.InspSubsetResultValuation AS InspSubsetResultValuation,
  _Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Supplier.AuthorizationGroup AS AuthorizationGroup,
  _QualityControlChartResults._InspectionLot AS _InspectionLot
FROM I_QualityControlChart AS _QualityControlChart
LEFT OUTER JOIN P_QualityControlChartResults AS _QualityControlChartResults ON QualityControlChart = _QualityControlChartResults.QualityControlChart  -- association [0..*]
LEFT OUTER JOIN P_InspCharcSmplSizeAggrgn AS _InspCharcSmplSizeAggrgn ON QualityControlChart = _InspCharcSmplSizeAggrgn.QualityControlChart  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;

Learn More