I_DEFECT_TP

CDS View
67 Fields 10 CDS Views

Defect

I_DEFECT_TP is a CDS View in S/4HANA. Defect. It contains 67 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
A_Defect view_entity from CONSUMPTION Defects
C_DefectMngDefectsForTransfer view from CONSUMPTION Defects for Transfer
C_DefectRecord view from CONSUMPTION Record Defect
C_MfgExecDefectRecord view from CONSUMPTION View with UI attributes for defect
C_MfgOrderDefectRecord view from CONSUMPTION Consumption view for defect
C_QltyTaskProcessDefectInfo view from CONSUMPTION Defect Information for Quality Task
C_QltyTskDefectMng view inner CONSUMPTION Quality Task Defect Fields View
C_SFIMfgDefectDcsnScrap view inner CONSUMPTION View for SFI with decision Scrap
I_DefectUnion view from COMPOSITE Defects and Quality Notification Items
I_DefectUnion view union COMPOSITE Defects and Quality Notification Items

Fields (67)

KeyField CDS FieldsUsed in Views
KEY DefectInternalID DefectInternalID 4
_Plant _Plant 1
Batch Batch 3
BOMItemInstanceUUID BOMItemInstanceUUID 2
CatalogProfile CatalogProfile 1
ChangedDateTime ChangedDateTime 1
CostCenter CostCenter 1
CreatedByUser CreatedByUser 2
CreationDate CreationDate 2
CreationTime CreationTime 2
Defect Defect 1
DefectCategory DefectCategory 3
DefectCauseCode DefectCauseCode 1
DefectCauseCodeCatalog DefectCauseCodeCatalog 1
DefectCauseCodeGroup DefectCauseCodeGroup 1
DefectCauseCodeVersion DefectCauseCodeVersion 1
DefectCausedBy DefectCausedBy 1
DefectClass DefectClass 2
DefectCode DefectCode 2
DefectCodeCatalog DefectCodeCatalog 2
DefectCodeGroup DefectCodeGroup 2
DefectCodeVersion DefectCodeVersion 1
DefectConfigurationValue DefectConfigurationValue 1
DefectIsCreatedAutomatically DefectIsCreatedAutomatically 1
DefectiveQuantity DefectiveQuantity 2
DefectiveQuantityUnit DefectiveQuantityUnit 2
DefectiveSingleUnit DefectiveSingleUnit,SerialNumber 2
DefectLifecycleStatus DefectLifecycleStatus 2
DefectObjectCode DefectLocationCode 1
DefectObjectCodeCatalog DefectLocationCatalog 1
DefectObjectCodeGroup DefectLocationCodeGroup 1
DefectOrigin DefectOrigin 1
DefectText DefectText 1
Equipment Equipment 1
FunctionalLocation FunctionalLocation 1
InspectionCharacteristic InspectionCharacteristic 2
InspectionLot InspectionLot 2
InspectionSubsetInternalID InspectionSubsetInternalID 2
InspPlanOperationInternalID InspPlanOperationInternalID 2
IsDeleted IsDeleted 2
LastChangeDate LastChangeDate 2
LastChangedByUser LastChangedByUser 2
LastChangeTime LastChangeTime 2
MainWorkCenter MainWorkCenter 3
MainWorkCenterInternalID MainWorkCenterInternalID 3
MainWorkCenterPlant MainWorkCenterPlant 3
MasterLanguage MasterLanguage 2
Material Material 3
MaterialSample MaterialSample 2
NumberOfDefects NumberOfDefects 2
OrderInternalID OrderInternalID 1
Plant Plant 4
ProblemAnalysisStatus ProblemAnalysisStatus 2
ProducedMaterial ProducedMaterial 2
ProducedSerialNumber ProducedSerialNumber 2
ProductionOrder ProductionOrder 1
ProductionOrderOpActyVers ProductionOrderOpActyVers 1
ProductionOrderOperation ProductionOrderOperation 1
ProductionOrderOperationActy ProductionOrderOperationActy 1
ProductionSupplyArea ProductionSupplyArea 1
QualityIssueReference QualityIssueReference 2
SourceStorageBin SourceStorageBin 1
StorageLocation StorageLocation 1
StorageType StorageType 1
Warehouse Warehouse 1
WarehouseLogicalSystem WarehouseLogicalSystem 1
WorkCenterTypeCode WorkCenterTypeCode 3

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_TP (
    DEFECTINTERNALID,
    _PLANT,
    BATCH,
    BOMITEMINSTANCEUUID,
    CATALOGPROFILE,
    CHANGEDDATETIME,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECT,
    DEFECTCATEGORY,
    DEFECTCAUSECODE,
    DEFECTCAUSECODECATALOG,
    DEFECTCAUSECODEGROUP,
    DEFECTCAUSECODEVERSION,
    DEFECTCAUSEDBY,
    DEFECTCLASS,
    DEFECTCODE,
    DEFECTCODECATALOG,
    DEFECTCODEGROUP,
    DEFECTCODEVERSION,
    DEFECTCONFIGURATIONVALUE,
    DEFECTISCREATEDAUTOMATICALLY,
    DEFECTIVEQUANTITY,
    DEFECTIVEQUANTITYUNIT,
    DEFECTIVESINGLEUNIT,
    DEFECTLIFECYCLESTATUS,
    DEFECTOBJECTCODE,
    DEFECTOBJECTCODECATALOG,
    DEFECTOBJECTCODEGROUP,
    DEFECTORIGIN,
    DEFECTTEXT,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    INSPECTIONCHARACTERISTIC,
    INSPECTIONLOT,
    INSPECTIONSUBSETINTERNALID,
    INSPPLANOPERATIONINTERNALID,
    ISDELETED,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    MAINWORKCENTER,
    MAINWORKCENTERINTERNALID,
    MAINWORKCENTERPLANT,
    MASTERLANGUAGE,
    MATERIAL,
    MATERIALSAMPLE,
    NUMBEROFDEFECTS,
    ORDERINTERNALID,
    PLANT,
    PROBLEMANALYSISSTATUS,
    PRODUCEDMATERIAL,
    PRODUCEDSERIALNUMBER,
    PRODUCTIONORDER,
    PRODUCTIONORDEROPACTYVERS,
    PRODUCTIONORDEROPERATION,
    PRODUCTIONORDEROPERATIONACTY,
    PRODUCTIONSUPPLYAREA,
    QUALITYISSUEREFERENCE,
    SOURCESTORAGEBIN,
    STORAGELOCATION,
    STORAGETYPE,
    WAREHOUSE,
    WAREHOUSELOGICALSYSTEM,
    WORKCENTERTYPECODE,
    PRIMARY KEY (DEFECTINTERNALID)
);

Learn More