C_QltyCtrlChtWthDvtn

DDL: C_QLTYCTRLCHTWTHDVTN SQL: CQLTYCTRLDVTN Type: view CONSUMPTION Package: ODATA_QM_INSPECTION_ANALYTICS
31 Fields 1 Data Sources

Quality Control Chart with deviation

C_QltyCtrlChtWthDvtn is a Consumption CDS View that provides data about "Quality Control Chart with deviation" in SAP S/4HANA. It reads from 1 data source (C_QltyCtrlCalcFld) and exposes 31 fields with key fields QualityControlChart, InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID. Part of development package ODATA_QM_INSPECTION_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
C_QltyCtrlCalcFld C_QltyCtrlCalcFld from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CQLTYCTRLDVTN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Quality Control Chart with deviation view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY QualityControlChart _QualityControlChartDvtn QualityControlChart
KEY InspectionLot _QualityControlChartDvtn InspectionLot Inspection Lot
KEY InspPlanOperationInternalID _QualityControlChartDvtn InspPlanOperationInternalID
KEY InspectionCharacteristic _QualityControlChartDvtn InspectionCharacteristic
KEY InspectionSubsetInternalID _QualityControlChartDvtn InspectionSubsetInternalID
QualityControlChartStatus _QualityControlChartDvtn QualityControlChartStatus
QltyCtrlChtCnt
WorkCenter WorkCenter Work Center
Material Material Vehicle Model
InspectionValuationResult InspectionValuationResult
QltyCtrlChartCreationDate QltyCtrlChartCreationDate
InspectionEndDate InspectionEndDate
QltyCtrlChtDvtnSts QltyCtrlChtDvtnSts
Plant Plant Valuation Area
InspectionLotOrigin InspectionLotOrigin
InspectionLotType InspectionLotType Inspection Type
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup QM Matl Auth.
InspLotSelectionSupplier InspLotSelectionSupplier
Manufacturer Manufacturer Manufacturer
PurchasingOrganization PurchasingOrganization Purchasing Organization
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
Customer Customer Sold-to Party
SoldToParty SoldToParty Sold-to Party
SalesOrganization SalesOrganization Sales Organization
InspectionLotHasQuantity InspectionLotHasQuantity
BatchStorageLocation BatchStorageLocation
InspectionLotStorageLocation InspectionLotStorageLocation
QltyCtrlChartAggrgnCriterion QltyCtrlChartAggrgnCriterion
Supplier Supplier Supplier
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
AuthorizationGroup AuthorizationGroup AuthorizGroup

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_QltyCtrlChtWthDvtn.
-- 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: CQLTYCTRLDVTN

CREATE VIEW C_QltyCtrlChtWthDvtn AS
SELECT
  _QualityControlChartDvtn.QualityControlChart AS QualityControlChart,
  _QualityControlChartDvtn.InspectionLot AS InspectionLot,
  _QualityControlChartDvtn.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _QualityControlChartDvtn.InspectionCharacteristic AS InspectionCharacteristic,
  _QualityControlChartDvtn.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _QualityControlChartDvtn.QualityControlChartStatus AS QualityControlChartStatus,
  cast(1 as vdm_deviations) AS QltyCtrlChtCnt,
  WorkCenter,
  Material,
  InspectionValuationResult,
  QltyCtrlChartCreationDate,
  InspectionEndDate,
  QltyCtrlChtDvtnSts,
  Plant,
  InspectionLotOrigin,
  InspectionLotType,
  MatlQualityAuthorizationGroup,
  InspLotSelectionSupplier,
  Manufacturer,
  PurchasingOrganization,
  ManufacturerPartNmbr,
  Customer,
  SoldToParty,
  SalesOrganization,
  InspectionLotHasQuantity,
  BatchStorageLocation,
  InspectionLotStorageLocation,
  QltyCtrlChartAggrgnCriterion,
  Supplier,
  IsBusinessPurposeCompleted,
  AuthorizationGroup
FROM C_QltyCtrlCalcFld
;

Learn More