I_QualityComplaintDefectVH

DDL: I_QUALITYCOMPLAINTDEFECTVH Type: view_entity COMPOSITE Package: VDM_QM_NOTIFICATION
13 Fields 1 Data Sources 1 Associations 2 OData Services

Defect for Quality Complaint

I_QualityComplaintDefectVH is a Composite CDS View that provides data about "Defect for Quality Complaint" in SAP S/4HANA. It reads from 1 data source (I_Defect) and exposes 13 fields with key field DefectInternalID. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F8685, UI_QLTYCMPLAGNSTSUPLRMNG). Part of development package VDM_QM_NOTIFICATION.

Data Sources (1)

SourceAliasJoin Type
I_Defect I_Defect from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_NotificationItem _Extension $projection.DefectInternalID = _Extension.Notification and _Extension.NotificationItem = '0000'

Annotations (13)

NameValueLevelField
EndUserText.label Defect for Quality Complaint view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.representativeKey DefectInternalID view
Search.searchable true view
Consumption.ranked true view
Metadata.ignorePropagatedAnnotations true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F8685 ASQL_F8685 C2 NOT_RELEASED
UI_QLTYCMPLAGNSTSUPLRMNG UI_QLTYCMPLAGNSTSUPLRMNG V4 C1 NOT_RELEASED

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID DefectInternalID Internal Defect ID
Defect Defect
DefectText DefectText
DefectCode DefectCode Damage Code
DefectCodeGroup DefectCodeGroup Code Group
Material Material Vehicle Model
Plant Plant Valuation Area
InspectionLot InspectionLot Inspection Lot
ManufacturingOrder Order
_InspectionLot _InspectionLot
DefectCategory DefectCategory
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter

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 I_QualityComplaintDefectVH.
-- 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 I_QualityComplaintDefectVH AS
SELECT
  DefectInternalID,
  Defect,
  DefectText,
  DefectCode,
  DefectCodeGroup,
  Material,
  Plant,
  InspectionLot,
  cast(ProductionOrder as manufacturingorder preserving type ) AS ManufacturingOrder,
  DefectCategory,
  MainWorkCenter,
  MainWorkCenterPlant
FROM I_Defect
LEFT OUTER JOIN E_NotificationItem AS _Extension ON DefectInternalID = _Extension.Notification AND _Extension.NotificationItem = '0000'  -- association [1..1]
;

Learn More