C_DefectsByMatl

DDL: C_DEFECTSBYMATL SQL: CDEFECTSBYMATL Type: view CONSUMPTION Package: ODATA_QM_DEFECT_ANALYTICS
26 Fields 1 Data Sources

OVP card Defects by Material

C_DefectsByMatl is a Consumption CDS View that provides data about "OVP card Defects by Material" in SAP S/4HANA. It reads from 1 data source (C_DefectCalcFld) and exposes 26 fields. Part of development package ODATA_QM_DEFECT_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
C_DefectCalcFld C_DefectCalcFld from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CDEFECTSBYMATL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
EndUserText.label OVP card Defects by Material view

Fields (26)

KeyFieldSource TableSource FieldDescription
Material Material Materials
MaterialName MaterialName Material Description
NumberOfDefects Defects
CalculationDate CalculationDate
Plant Plant Valuation Area
InspectionLotOrigin InspectionLotOrigin
InspectionLotType InspectionLotType Inspection Type
InspectionLotHasQuantity
BatchStorageLocation BatchStorageLocation
MatlQualityAuthorizationGroup MatlQualityAuthorizationGroup QM Matl Auth.
Supplier Supplier Supplier
Manufacturer Manufacturer Manufacturer
ManufacturerPartNmbr ManufacturerPartNmbr Mfr Part Number
PurchasingOrganization PurchasingOrganization Purchasing Organization
Customer Customer Sold-to Party
SoldToParty SoldToParty Sold-to Party
SalesOrganization SalesOrganization Sales Organization
DefectCategory DefectCategory
InspectionLot InspectionLot Inspection Lot
WorkCenterTypeCode WorkCenterTypeCode Object Type
MainWorkCenterInternalID MainWorkCenterInternalID Work Center
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
Notification Notification Notification
_InspectionLot _InspectionLot
_Notification _Notification

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_DefectsByMatl.
-- 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: CDEFECTSBYMATL

CREATE VIEW C_DefectsByMatl AS
SELECT
  Material,
  MaterialName,
  sum( NumberOfDefects ) AS NumberOfDefects,
  CalculationDate,
  Plant,
  InspectionLotOrigin,
  InspectionLotType,
  cast ( InspectionLotHasQuantity as xfeld ) AS InspectionLotHasQuantity,
  BatchStorageLocation,
  MatlQualityAuthorizationGroup,
  Supplier,
  Manufacturer,
  ManufacturerPartNmbr,
  PurchasingOrganization,
  Customer,
  SoldToParty,
  SalesOrganization,
  DefectCategory,
  InspectionLot,
  WorkCenterTypeCode,
  MainWorkCenterInternalID,
  MainWorkCenter,
  MainWorkCenterPlant,
  Notification
FROM C_DefectCalcFld
;

Learn More