C_DefectsByDefectCode

DDL: C_DEFECTSBYDEFECTCODE SQL: CDEFSBYDEFCODE Type: view CONSUMPTION Package: ODATA_QM_DEFECT_ANALYTICS
29 Fields 1 Data Sources

Defects By Defect Code View

C_DefectsByDefectCode is a Consumption CDS View that provides data about "Defects By Defect Code View" in SAP S/4HANA. It reads from 1 data source (C_DefectCalcFld) and exposes 29 fields with key field Defect. Part of development package ODATA_QM_DEFECT_ANALYTICS.

Data Sources (1)

SourceAliasJoin Type
C_DefectCalcFld C_DefectCalcFld from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CDEFSBYDEFCODE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Defects By Defect Code View view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY Defect Defect
DefectCode DefectCode Defect Codes
DefectCodeGroup DefectCodeGroup Code Group
DefectCodeText DefectCodeText
NumberOfDefects NumberOfDefects Defects
CalculationDate CalculationDate
Plant Plant Valuation Area
InspectionLotOrigin InspectionLotOrigin
InspectionLotType InspectionLotType Inspection Type
InspectionLotHasQuantity
Material Material Vehicle Model
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_DefectsByDefectCode.
-- 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: CDEFSBYDEFCODE

CREATE VIEW C_DefectsByDefectCode AS
SELECT
  Defect,
  DefectCode,
  DefectCodeGroup,
  DefectCodeText,
  NumberOfDefects,
  CalculationDate,
  Plant,
  InspectionLotOrigin,
  InspectionLotType,
  cast ( InspectionLotHasQuantity as xfeld preserving type ) AS InspectionLotHasQuantity,
  Material,
  BatchStorageLocation,
  MatlQualityAuthorizationGroup,
  Supplier,
  Manufacturer,
  ManufacturerPartNmbr,
  PurchasingOrganization,
  Customer,
  SoldToParty,
  SalesOrganization,
  DefectCategory,
  InspectionLot,
  WorkCenterTypeCode,
  MainWorkCenterInternalID,
  MainWorkCenter,
  MainWorkCenterPlant,
  Notification
FROM C_DefectCalcFld
;

Learn More