C_QltyCtrlCalcFld

DDL: C_QLTYCTRLCALCFLD Type: view CONSUMPTION Package: ODATA_QM_INSPECTION_ANALYTICS
39 Fields 1 Data Sources 1 Associations

Quality Control Calculated Fields

C_QltyCtrlCalcFld is a Consumption CDS View that provides data about "Quality Control Calculated Fields" in SAP S/4HANA. It reads from 1 data source (C_QualityControlDeviations) and exposes 39 fields with key fields QualityControlChart, InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID. It has 1 association to related views. Part of development package ODATA_QM_INSPECTION_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
C_QualityControlDeviations _QualityControlDeviations from

Parameters (1)

NameTypeDefault
P_CurrentDate dats

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_QltyCtrlChtDvtnStsTxt _QltyCtrlChtDvtnStsTxt $projection.QltyCtrlChtDvtnSts = _QltyCtrlChtDvtnStsTxt.QltyCtrlChtDvtnSts and _QltyCtrlChtDvtnStsTxt.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CQLTYCTRLCALCFLD view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Quality Control Calculated Fields view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY QualityControlChart QualityControlChart
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
KEY InspectionSubsetInternalID InspectionSubsetInternalID
InspectionValuationResult InspectionValuationResult
InspSubsetResultValuation InspSubsetResultValuation
CalculationDate
MatlQualityAuthorizationGroup _InspectionLot MatlQualityAuthorizationGroup QM Matl Auth.
PurchasingOrganization _InspectionLot PurchasingOrganization Purchasing Organization
ManufacturerPartNmbr _InspectionLot ManufacturerPartNmbr Mfr Part Number
SoldToParty _InspectionLot SoldToParty Sold-to Party
SalesOrganization _InspectionLot SalesOrganization Sales Organization
InspectionLotHasQuantity _InspectionLot InspectionLotHasQuantity
BatchStorageLocation _InspectionLot BatchStorageLocation
InspectionLotStorageLocation _InspectionLot InspectionLotStorageLocation
_QltyCtrlChtDvtnStsTxt _QltyCtrlChtDvtnStsTxt
Material Material Vehicle Model
Plant Plant Valuation Area
WorkCenter WorkCenter Work Center
QltyCtrlChartAggrgnCriterion QltyCtrlChartAggrgnCriterion
QualityControlChartStatus QualityControlChartStatus
QualityControlChartType QualityControlChartType
QltyCtrlChtDvtnSts QltyCtrlChtDvtnSts
InspectionSpecification InspectionSpecification Master IC
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVariant BillOfOperationsVariant Group Counter
NmbrOfRsltsRecordedCat NmbrOfRsltsRecordedCat
InspectionEndDate InspectionEndDate
InspectionLotOrigin InspectionLotOrigin
InspectionLotType InspectionLotType Inspection Type
InspLotSelectionSupplier InspLotSelectionSupplier Supplier
Manufacturer Manufacturer Manufacturer
QltyCtrlChartCreationDate QltyCtrlChartCreationDate
Customer Customer Sold-to Party
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_QltyCtrlCalcFld.
-- 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.
-- Parameters: P_CurrentDate : dats

CREATE VIEW C_QltyCtrlCalcFld AS
SELECT
  QualityControlChart,
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSubsetInternalID,
  InspectionValuationResult,
  InspSubsetResultValuation,
  dats_add_days($parameters.P_CurrentDate , -7, 'UNCHANGED') AS CalculationDate,
  _InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspectionLot.PurchasingOrganization AS PurchasingOrganization,
  _InspectionLot.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _InspectionLot.SoldToParty AS SoldToParty,
  _InspectionLot.SalesOrganization AS SalesOrganization,
  _InspectionLot.InspectionLotHasQuantity AS InspectionLotHasQuantity,
  _InspectionLot.BatchStorageLocation AS BatchStorageLocation,
  _InspectionLot.InspectionLotStorageLocation AS InspectionLotStorageLocation,
  Material,
  Plant,
  WorkCenter,
  QltyCtrlChartAggrgnCriterion,
  QualityControlChartStatus,
  QualityControlChartType,
  QltyCtrlChtDvtnSts,
  InspectionSpecification,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  NmbrOfRsltsRecordedCat,
  InspectionEndDate,
  InspectionLotOrigin,
  InspectionLotType,
  InspLotSelectionSupplier,
  Manufacturer,
  QltyCtrlChartCreationDate,
  Customer,
  Supplier,
  IsBusinessPurposeCompleted,
  AuthorizationGroup
FROM C_QualityControlDeviations AS _QualityControlDeviations
LEFT OUTER JOIN I_QltyCtrlChtDvtnStsTxt AS _QltyCtrlChtDvtnStsTxt ON QltyCtrlChtDvtnSts = _QltyCtrlChtDvtnStsTxt.QltyCtrlChtDvtnSts AND _QltyCtrlChtDvtnStsTxt.Language = $session.system_language  -- association [0..1]
;

Learn More