I_DEFECT

CDS View
79 Fields 8 CDS Views

Defect

I_DEFECT is a CDS View in S/4HANA. Defect. It contains 79 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
ESH_N_DEFECT view from
I_Defect_TP view from TRANSACTIONAL Defect
I_DefectVH view from COMPOSITE Defect
I_InspLotCharcNumberOfDefects view_entity union COMPOSITE Number of Defects for Inspection Charc
I_MfgOrderDefectForSituations view from COMPOSITE Defect list to trigger situation
P_EWM_QltyInspectionEmbedded view_entity from COMPOSITE
P_MfgOrdNrOfDefectSitns view from COMPOSITE
R_DefectTP view_entity from TRANSACTIONAL Defect

Fields (79)

KeyField CDS FieldsUsed in Views
KEY DefectInternalID DefectInternalID 2
KEY ProductionOrder ProductionOrder 3
_CatalogProfile _CatalogProfile 2
_DefectArchivingStatus _DefectArchivingStatus 1
_DefectCategory _DefectCategory 2
_DefectCodeCatalog _DefectCodeCatalog 2
_DefectiveQuantityUnit _DefectiveQuantityUnit 2
_InspectionLot _InspectionLot 2
Batch Batch 2
BillOfMaterial BillOfMaterial 2
BillOfMaterialCategory BillOfMaterialCategory 2
BillOfMaterialItemNodeNumber BillOfMaterialItemNodeNumber 2
BillOfMaterialVariant BillOfMaterialVariant 2
BOMItemInstanceUUID BOMItemInstanceUUID 2
BOMItemInternalChangeCount BOMItemInternalChangeCount 2
CatalogProfile CatalogProfile 2
ChangedDateTime ChangedDateTime 2
CostCenter CostCenter 2
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationTime CreationTime 2
Defect Defect 3
DefectArchivingStatus DefectArchivingStatus 1
DefectCategory DefectCategory 2
DefectCauseCode DefectCauseCode 2
DefectCauseCodeCatalog DefectCauseCodeCatalog 2
DefectCauseCodeGroup DefectCauseCodeGroup 2
DefectCauseCodeVersion DefectCauseCodeVersion 2
DefectCausedBy DefectCausedBy 2
DefectClass DefectClass 2
DefectCode DefectCode 2
DefectCodeCatalog DefectCodeCatalog 2
DefectCodeGroup DefectCodeGroup 2
DefectCodeVersion DefectCodeVersion 2
DefectIsCreatedAutomatically DefectIsCreatedAutomatically 2
DefectiveQuantity DefectiveQuantity 2
DefectiveQuantityUnit DefectiveQuantityUnit 2
DefectiveSingleUnit DefectiveSingleUnit 2
DefectLifecycleStatus DefectLifecycleStatus 1
DefectObjectCode DefectLocationCode,DefectObjectCode 2
DefectObjectCodeCatalog DefectLocationCatalog,DefectObjectCodeCatalog 2
DefectObjectCodeGroup DefectLocationCodeGroup,DefectObjectCodeGroup 2
DefectObjectCodeVersion DefectLocationCodeVersion,DefectObjectCodeVersion 2
DefectOrigin DefectOrigin 2
DefectText DefectText 2
DefectUUID DefectUUID 1
Equipment Equipment 2
EWMWarehouse EWMWarehouse,Warehouse 2
FunctionalLocation FunctionalLocation 2
InspectionCharacteristic InspectionCharacteristic 2
InspectionLot InspectionLot 2
InspectionSubsetInternalID InspectionSubsetInternalID 3
InspPlanOperationInternalID InspPlanOperationInternalID 2
IsDeleted IsDeleted 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
LastChangeTime LastChangeTime 2
MainWorkCenter MainWorkCenter 2
MainWorkCenterInternalID MainWorkCenterInternalID 2
MainWorkCenterPlant MainWorkCenterPlant 2
Material Material 2
MaterialSample MaterialSample 2
NumberOfDefects NumberOfDefects 2
OpActyNtwkElement OpActyNtwkElement 2
OpActyNtwkInstance OpActyNtwkInstance 2
OrderInternalID OrderInternalID 2
Plant Plant 2
ProblemAnalysisStatus ProblemAnalysisStatus 1
ProducedMaterial ProducedMaterial 2
ProducedSerialNumber ProducedSerialNumber 2
ProductionOrderOpActyVers ProductionOrderOpActyVers 2
ProductionOrderOperationActy ProductionOrderOperationActy 2
ProductionSupplyArea ProductionSupplyArea 2
QualityIssueReference QualityIssueReference 1
SourceStorageBin SourceStorageBin 2
SourceStorageType SourceStorageType,StorageType 2
StorageLocation StorageLocation 2
WarehouseLogicalSystem WarehouseLogicalSystem 2
WorkCenterTypeCode WorkCenterTypeCode 2

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.

-- Defect
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEFECT (
    DEFECTINTERNALID,
    PRODUCTIONORDER,
    _CATALOGPROFILE,
    _DEFECTARCHIVINGSTATUS,
    _DEFECTCATEGORY,
    _DEFECTCODECATALOG,
    _DEFECTIVEQUANTITYUNIT,
    _INSPECTIONLOT,
    BATCH,
    BILLOFMATERIAL,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALVARIANT,
    BOMITEMINSTANCEUUID,
    BOMITEMINTERNALCHANGECOUNT,
    CATALOGPROFILE,
    CHANGEDDATETIME,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECT,
    DEFECTARCHIVINGSTATUS,
    DEFECTCATEGORY,
    DEFECTCAUSECODE,
    DEFECTCAUSECODECATALOG,
    DEFECTCAUSECODEGROUP,
    DEFECTCAUSECODEVERSION,
    DEFECTCAUSEDBY,
    DEFECTCLASS,
    DEFECTCODE,
    DEFECTCODECATALOG,
    DEFECTCODEGROUP,
    DEFECTCODEVERSION,
    DEFECTISCREATEDAUTOMATICALLY,
    DEFECTIVEQUANTITY,
    DEFECTIVEQUANTITYUNIT,
    DEFECTIVESINGLEUNIT,
    DEFECTLIFECYCLESTATUS,
    DEFECTOBJECTCODE,
    DEFECTOBJECTCODECATALOG,
    DEFECTOBJECTCODEGROUP,
    DEFECTOBJECTCODEVERSION,
    DEFECTORIGIN,
    DEFECTTEXT,
    DEFECTUUID,
    EQUIPMENT,
    EWMWAREHOUSE,
    FUNCTIONALLOCATION,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINWORKCENTER,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MATERIAL,
    MATERIALSAMPLE,
    NUMBEROFDEFECTS,
    OPACTYNTWKELEMENT,
    OPACTYNTWKINSTANCE,
    ORDERINTERNALID,
    PLANT,
    PROBLEMANALYSISSTATUS,
    PRODUCEDMATERIAL,
    PRODUCEDSERIALNUMBER,
    PRODUCTIONORDEROPACTYVERS,
    PRODUCTIONORDEROPERATIONACTY,
    PRODUCTIONSUPPLYAREA,
    QUALITYISSUEREFERENCE,
    SOURCESTORAGEBIN,
    SOURCESTORAGETYPE,
    STORAGELOCATION,
    WAREHOUSELOGICALSYSTEM,
    WORKCENTERTYPECODE,
    PRIMARY KEY (DEFECTINTERNALID, PRODUCTIONORDER)
);

Learn More