P_QualityControlChartResults

DDL: P_QUALITYCONTROLCHARTRESULTS SQL: PQLTYCTRLRESULTS Type: view CONSUMPTION
25 Fields 1 Data Sources 3 Associations

Inspection Results

P_QualityControlChartResults is a Consumption CDS View that provides data about "Inspection Results" in SAP S/4HANA. It reads from 1 data source (I_InspSubsetCharacteristic) and exposes 25 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspSubsetCharacteristic I_InspSubsetCharacteristic from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_InspSubsetResult _SubsetResult $projection.InspectionLot = _SubsetResult.InspectionLot and $projection.InspPlanOperationInternalID = _SubsetResult.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _SubsetResult.InspectionCharacteristic and $projection.InspectionSubsetInternalID = _SubsetResult.InspectionSubsetInternalID
[0..1] I_InspectionResult _InspectionResult $projection.InspectionLot = _InspectionResult.InspectionLot and $projection.InspPlanOperationInternalID = _InspectionResult.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _InspectionResult.InspectionCharacteristic
[1..1] I_Supplier _Supplier $projection.supplier = _Supplier.Supplier

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PQLTYCTRLRESULTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Inspection Results view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspSubsetCharacteristic InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspSubsetCharacteristic InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic Characteristic
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID Sample Number
QualityControlChart QualityControlChart Control Chart
InspectionValuationResult _InspectionResult InspectionValuationResult
InspSubsetResultValuation _SubsetResult InspectionValuationResult
InspectionEndDate _InspectionResult InspectionEndDate
InspectionEndTime _InspectionResult InspectionEndTime
Plant
Material
InspectionLotOrigin
InspectionLotType
BillOfOperationsType
BillOfOperationsGroup
BillOfOperationsVariant
Supplier
Customer
Manufacturer
InspLotHasSubsets
InspectionSpecificationText
WorkCenter
WorkCenterText
_InspectionLot I_InspSubsetCharacteristic _InspectionLot
_Supplier _Supplier

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 P_QualityControlChartResults.
-- 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: PQLTYCTRLRESULTS

CREATE VIEW P_QualityControlChartResults AS
SELECT
  I_InspSubsetCharacteristic.InspectionLot AS InspectionLot,
  I_InspSubsetCharacteristic.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  I_InspSubsetCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  I_InspSubsetCharacteristic.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  QualityControlChart,
  _InspectionResult.InspectionValuationResult AS InspectionValuationResult,
  _SubsetResult.InspectionValuationResult AS InspSubsetResultValuation,
  _InspectionResult.InspectionEndDate AS InspectionEndDate,
  _InspectionResult.InspectionEndTime AS InspectionEndTime,
  I_InspSubsetCharacteristic._InspectionLot.Plant AS Plant,
  I_InspSubsetCharacteristic._InspectionLot.Material AS Material,
  I_InspSubsetCharacteristic._InspectionLot.InspectionLotOrigin AS InspectionLotOrigin,
  I_InspSubsetCharacteristic._InspectionLot.InspectionLotType AS InspectionLotType,
  I_InspSubsetCharacteristic._InspectionLot.BillOfOperationsType AS BillOfOperationsType,
  I_InspSubsetCharacteristic._InspectionLot.BillOfOperationsGroup AS BillOfOperationsGroup,
  I_InspSubsetCharacteristic._InspectionLot.BillOfOperationsVariant AS BillOfOperationsVariant,
  I_InspSubsetCharacteristic._InspectionLot.Supplier AS Supplier,
  I_InspSubsetCharacteristic._InspectionLot.Customer AS Customer,
  I_InspSubsetCharacteristic._InspectionLot.Manufacturer AS Manufacturer,
  I_InspSubsetCharacteristic._InspectionLot.InspLotHasSubsets AS InspLotHasSubsets,
  I_InspSubsetCharacteristic._InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  I_InspSubsetCharacteristic._InspectionOperation._WorkCenter.WorkCenter AS WorkCenter,
  I_InspSubsetCharacteristic._InspectionOperation._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  I_InspSubsetCharacteristic._InspectionLot AS _InspectionLot
FROM I_InspSubsetCharacteristic
LEFT OUTER JOIN I_InspSubsetResult AS _SubsetResult ON InspectionLot = _SubsetResult.InspectionLot AND InspPlanOperationInternalID = _SubsetResult.InspPlanOperationInternalID AND InspectionCharacteristic = _SubsetResult.InspectionCharacteristic AND InspectionSubsetInternalID = _SubsetResult.InspectionSubsetInternalID  -- association [0..1]
LEFT OUTER JOIN I_InspectionResult AS _InspectionResult ON InspectionLot = _InspectionResult.InspectionLot AND InspPlanOperationInternalID = _InspectionResult.InspPlanOperationInternalID AND InspectionCharacteristic = _InspectionResult.InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON supplier = _Supplier.Supplier  -- association [1..1]
;

Learn More