I_DEFECTUNION

CDS View
42 Fields 10 CDS Views

Defects and Quality Notification Items

I_DEFECTUNION is a CDS View in S/4HANA. Defects and Quality Notification Items. It contains 42 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
C_DefectCalc view from CONSUMPTION Manage Defects Calculation Fields
C_DefectCalcFld view from CONSUMPTION Defects Calculation Fields View
C_DefectDetailsRsltRecg view_entity from CONSUMPTION Defect Details for Inspection Lot
C_DefectMng view from CONSUMPTION Manage Defects
C_DefectsByCode view from CONSUMPTION Defects by Defect Code
C_InspCharcDefectCntRsltRecg view from CONSUMPTION Inspection Characteristic Defect Count
C_InspOriginDefects view from CONSUMPTION Defects by Insp Origin
C_MatlDefect view from CONSUMPTION Defects by Material
I_DefectCube view from COMPOSITE Defect Analytics Cube View
I_DefectKeyFigCube view from COMPOSITE Key Figure view for Defect Analytics

Fields (42)

KeyField CDS FieldsUsed in Views
KEY DefectInternalID DefectInternalID 4
_InspectionLot _InspectionLot 2
Batch Batch 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 4
CreationTime CreationTime 1
Defect Defect 4
DefectCategory DefectCategory 4
DefectCausedBy DefectCausedBy 1
DefectClass DefectClass 4
DefectCode DefectCode 4
DefectCodeGroup DefectCodeGroup 4
DefectLifecycleStatus DefectLifecycleStatus 3
DefectLocationCatalog DefectLocationCatalog 1
DefectLocationCode DefectLocationCode 1
DefectLocationCodeGroup DefectLocationCodeGroup 1
DefectText DefectText 1
InspectionCharacteristic InspectionCharacteristic 1
InspectionLot InspectionLot 3
InspectionSubsetInternalID InspectionSubsetInternalID 1
InspPlanOperationInternalID InspPlanOperationInternalID 3
IsDeleted IsDeleted 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LastChangeTime LastChangeTime 1
MainWorkCenter MainWorkCenter 4
MainWorkCenterInternalID MainWorkCenterInternalID 4
MainWorkCenterPlant MainWorkCenterPlant 4
Material Material 6
MaterialSample MaterialSample 1
Notification Notification 4
NotificationItem NotificationItem 4
NotificationItemExternalID NotificationItemExternalID 1
NotificationType NotificationType 1
NumberOfDefects NumberOfDefects 4
Plant Plant 6
ProductionSupplyArea ProductionSupplyArea 1
SourceStorageBin SourceStorageBin 1
StorageLocation StorageLocation 1
StorageType StorageType 1
Warehouse Warehouse 1
WorkCenterTypeCode WorkCenterTypeCode 4

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Defects and Quality Notification Items
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEFECTUNION (
    DEFECTINTERNALID,
    _INSPECTIONLOT,
    BATCH,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECT,
    DEFECTCATEGORY,
    DEFECTCAUSEDBY,
    DEFECTCLASS,
    DEFECTCODE,
    DEFECTCODEGROUP,
    DEFECTLIFECYCLESTATUS,
    DEFECTLOCATIONCATALOG,
    DEFECTLOCATIONCODE,
    DEFECTLOCATIONCODEGROUP,
    DEFECTTEXT,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINWORKCENTER,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MATERIAL,
    MATERIALSAMPLE,
    NOTIFICATION,
    NOTIFICATIONITEM,
    NOTIFICATIONITEMEXTERNALID,
    NOTIFICATIONTYPE,
    NUMBEROFDEFECTS,
    PLANT,
    PRODUCTIONSUPPLYAREA,
    SOURCESTORAGEBIN,
    STORAGELOCATION,
    STORAGETYPE,
    WAREHOUSE,
    WORKCENTERTYPECODE,
    PRIMARY KEY (DEFECTINTERNALID)
);

Learn More