C_CmplAgainstSuplrDefectRef

DDL: C_CMPLAGAINSTSUPLRDEFECTREF Type: view_entity CONSUMPTION Package: ODATA_QM_CMPLAGSUPLR
35 Fields 1 Data Sources 2 OData Services

Defect in Complaint Against Supplier

C_CmplAgainstSuplrDefectRef is a Consumption CDS View that provides data about "Defect in Complaint Against Supplier" in SAP S/4HANA. It reads from 1 data source (R_CmplAgainstSuplrDefectRefTP) and exposes 35 fields with key fields ComplaintAgainstSupplier, DefectInternalID. It is exposed through 2 OData services (ASQL_F8685, UI_QLTYCMPLAGNSTSUPLRMNG). Part of development package ODATA_QM_CMPLAGSUPLR.

Data Sources (1)

SourceAliasJoin Type
R_CmplAgainstSuplrDefectRefTP R_CmplAgainstSuplrDefectRefTP projection

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Defect in Complaint Against Supplier view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey DefectInternalID view
ObjectModel.sapObjectNodeType.name CmplAgainstSuplrDefectRef view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F8685 ASQL_F8685 C2 NOT_RELEASED
UI_QLTYCMPLAGNSTSUPLRMNG UI_QLTYCMPLAGNSTSUPLRMNG V4 C1 NOT_RELEASED

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY ComplaintAgainstSupplier defref ComplaintAgainstSupplier
KEY DefectInternalID defref DefectInternalID Internal Defect ID
QualityComplaintItem QualityComplaintItem
Defect _Defect Defect
DefectText _Defect DefectText
DefectCategory _Defect DefectCategory
DefectCategoryTextlocalized
DefectLifecycleStatus _Defect DefectLifecycleStatus
DefectLifecycleStatusTextlocalized
DefectCode _Defect DefectCode Damage Code
DefectCodeTextlocalized
DefectCodeGroup _Defect DefectCodeGroup Code Group
DefectCodeGroupTextlocalized
Material _Defect Material Vehicle Model
ProductNamelocalized
DefectiveQuantity _Defect DefectiveQuantity
DefectiveQuantityUnit _Defect DefectiveQuantityUnit
Batch _Defect Batch Lot No.
Plant _Defect Plant Valuation Area
PlantName
InspectionLot _Defect InspectionLot Inspection Lot
InspectionLotQuantity
InspectionLotQuantityUnit
InspectionLotActualQuantity
InspectionLotSampleQuantity
InspectionLotSampleUnit
PurchasingDocument
PurchasingDocumentItem
InspPlanOperationInternalID _Defect InspPlanOperationInternalID
virtualInspectionOperationpph_vornr
virtualOperationTextltxa1
InspectionCharacteristic _Defect InspectionCharacteristic
virtualProductionOrdervdm_qm_fertaufnr
virtualProcessOrdervdm_qm_fertaufnr
ManufacturingOrder

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_CmplAgainstSuplrDefectRef.
-- 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.

CREATE VIEW C_CmplAgainstSuplrDefectRef AS
SELECT
  defref.ComplaintAgainstSupplier AS ComplaintAgainstSupplier,
  defref.DefectInternalID AS DefectInternalID,
  QualityComplaintItem,
  _Defect.Defect AS Defect,
  _Defect.DefectText AS DefectText,
  _Defect.DefectCategory AS DefectCategory,
  _Defect._DefectCategory._Text.DefectCategoryText : localized AS DefectCategoryTextlocalized,
  _Defect.DefectLifecycleStatus AS DefectLifecycleStatus,
  _Defect._DefectStatus._DefectStatusText.DefectLifecycleStatusText : localized AS DefectLifecycleStatusTextlocalized,
  _Defect.DefectCode AS DefectCode,
  _Defect._DefectCode._Text.DefectCodeText : localized AS DefectCodeTextlocalized,
  _Defect.DefectCodeGroup AS DefectCodeGroup,
  _Defect._DefectCodeGroup._Text.DefectCodeGroupText : localized AS DefectCodeGroupTextlocalized,
  _Defect.Material AS Material,
  _Defect._Product._Text.ProductName : localized AS ProductNamelocalized,
  _Defect.DefectiveQuantity AS DefectiveQuantity,
  _Defect.DefectiveQuantityUnit AS DefectiveQuantityUnit,
  _Defect.Batch AS Batch,
  _Defect.Plant AS Plant,
  _Defect._Plant.PlantName AS PlantName,
  _Defect.InspectionLot AS InspectionLot,
  _Defect._InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
  _Defect._InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _Defect._InspectionLot.InspectionLotActualQuantity AS InspectionLotActualQuantity,
  _Defect._InspectionLot.InspectionLotSampleQuantity AS InspectionLotSampleQuantity,
  _Defect._InspectionLot.InspectionLotSampleUnit AS InspectionLotSampleUnit,
  _Defect._InspectionLot.PurchasingDocument AS PurchasingDocument,
  _Defect._InspectionLot.PurchasingDocumentItem AS PurchasingDocumentItem,
  _Defect.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  virtual InspectionOperation : pph_vornr AS virtualInspectionOperationpph_vornr,
  virtual OperationText : ltxa1 AS virtualOperationTextltxa1,
  _Defect.InspectionCharacteristic AS InspectionCharacteristic,
  virtual ProductionOrder : vdm_qm_fertaufnr AS virtualProductionOrdervdm_qm_fertaufnr,
  virtual ProcessOrder : vdm_qm_fertaufnr AS virtualProcessOrdervdm_qm_fertaufnr,
  cast ( _Defect.ProductionOrder as manufacturingorder preserving type ) AS ManufacturingOrder
FROM R_CmplAgainstSuplrDefectRefTP
;

Learn More