I_DEFECT_TP

CDS View
74 Fields 12 CDS Views

Defect

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

CDS Views using this table (12)

ViewTypeJoinVDMDescription
A_Defect view from CONSUMPTION Defects
C_DefectFDP view from CONSUMPTION FDP view for QM Defect
C_DefectMngDefectsForTransfer view from CONSUMPTION Defects for Transfer
C_DefectOutputParameterFDP view from CONSUMPTION Parameter for Defect (QM) Output
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 (74)

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

-- Defect
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_DEFECT_TP (
    DEFECT,
    DEFECTINTERNALID,
    _PLANT,
    BATCH,
    BILLOFMATERIALCATEGORY,
    BILLOFMATERIALITEMNODENUMBER,
    BILLOFMATERIALVARIANT,
    BOMITEMINSTANCEUUID,
    BOMITEMINTERNALCHANGECOUNT,
    CATALOGPROFILE,
    CHANGEDDATETIME,
    COSTCENTER,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    DEFECTCATEGORY,
    DEFECTCAUSECODE,
    DEFECTCAUSECODECATALOG,
    DEFECTCAUSECODEGROUP,
    DEFECTCAUSECODEVERSION,
    DEFECTCAUSEDBY,
    DEFECTCLASS,
    DEFECTCODE,
    DEFECTCODECATALOG,
    DEFECTCODEGROUP,
    DEFECTCODEVERSION,
    DEFECTCONFIGURATIONVALUE,
    DEFECTISCREATEDAUTOMATICALLY,
    DEFECTIVEQUANTITY,
    DEFECTIVEQUANTITYUNIT,
    DEFECTIVESINGLEUNIT,
    DEFECTLIFECYCLESTATUS,
    DEFECTOBJECTCODE,
    DEFECTOBJECTCODECATALOG,
    DEFECTOBJECTCODEGROUP,
    DEFECTOBJECTCODEVERSION,
    DEFECTORIGIN,
    DEFECTTEXT,
    DEFECTUUID,
    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,
    PRODUCTIONORDERSEQUENCE,
    PRODUCTIONSUPPLYAREA,
    QUALITYISSUEREFERENCE,
    SOURCESTORAGEBIN,
    STORAGELOCATION,
    STORAGETYPE,
    WAREHOUSE,
    WAREHOUSELOGICALSYSTEM,
    WORKCENTERTYPECODE,
    PRIMARY KEY (DEFECT, DEFECTINTERNALID)
);

Learn More