QDEFECT_D - I_DEFECT_TP I_DEFECT_TP

I_DEFECT_TP I_DEFECT_TP information is stored in SAP table QDEFECT_D.
It is part of development package VDM_QM_NOTIFICATION in software component QM-QN. This development package consists of objects that can be grouped under "Notification and defect processing, Virtual data model".

Fields for table QDEFECT_D

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
DRAFTUUID	UUID serving as key (parent key, root key)	X	/BOBF/UUID	RAW	16
DEFECTINTERNALID	Internal Defect ID		QDEFECTINTERNALID	CHAR	24
DEFECT	Defect Number		QDEFECTID	CHAR	22
DEFECTCATEGORY	Defect Category		QDEFCATEGORY	CHAR	4
CREATEDBYUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
CREATIONDATE	Date on which the record was created		ERDAT	DATS	16
LASTCHANGEDBYUSER	Name of Person Who Changed Object		AENAM	CHAR	24
LASTCHANGEDATE	Last Changed On		AEDAT	DATS	16
DEFECTTEXT	Defect Text		VDM_QFETXT	CHAR	80
DEFECTCODECATALOG	Catalog Type - Problems/Defects		FEKAT	CHAR	2
DEFECTCODEGROUP	Defect Code Group		VDM_QFEGRP	CHAR	16
DEFECTCODE	Defect Code		VDM_QFECOD	CHAR	8
DEFECTCODEVERSION	Version Number		QVERSNR	CHAR	12
DEFECTOBJECTCODECATALOG	Defect Location Catalog		VDM_QFEOCAT	CHAR	2
DEFECTOBJECTCODEGROUP	Defect Location Code Group		VDM_QFEOGRP	CHAR	16
DEFECTOBJECTCODE	Defect Location Code		VDM_QFEOCOD	CHAR	8
DEFECTOBJECTCODEVERSION	Version Number		QVERSNR	CHAR	12
DEFECTCAUSECODECATALOG	Initial Defect Cause Code Catalog		VDM_QINITDEFCAUSECODECAT	CHAR	2
DEFECTCAUSECODEGROUP	Initial Defect Cause Code Group		VDM_QINITDEFCAUSECODEGROUP	CHAR	16
DEFECTCAUSECODE	Initial Defect Cause Code		VDM_QINITDEFCAUSECODE	CHAR	8
DEFECTCAUSECODEVERSION	Version Number		QVERSNR	CHAR	12
DEFECTIVEQUANTITY	Defective Quantity for Item (Internal)		QMGPOS	QUAN	7
DEFECTIVEQUANTITYUNIT	Unit of Measure for Item		QMGEIN	UNIT	6
DEFECTISCREATEDAUTOMATICALLY	Defect Created Automatically		QISDEFECTCREATEDAUTOMATICALLY	CHAR	2
PRODUCTIONORDEROPERATIONACTY	Identifies an Operation Activity		MPE_OA_ID	INT8	8
PRODUCTIONORDEROPACTYVERS	Number of an Operation Actiivity Version		MPE_OA_VERSION_NO	INT4	4
BATCH	Batch Number		CHARG_D	CHAR	20
DEFECTIVESINGLEUNIT	Single-Unit Number for Unit to Be Inspected		QPRUEFLINR	CHAR	36
PRODUCTIONORDER	Order Number (Production Order)		VDM_QM_FERTAUFNR	CHAR	24
ORDERINTERNALID	Plan Number for Operations in Order (Production Order)		FERTAUFPL	NUMC	20
PRODUCTIONORDEROPERATION	Operation/Activity Number		VORNR	CHAR	8
PRODUCTIONORDERSEQUENCE	Sequence		PLNFOLGE	CHAR	12
CREATIONTIME	System Time of Creation		VDM_QERSTEZEIT	TIMS	12
LASTCHANGETIME	System Time of Change		VDM_QAENDEZEIT	TIMS	12
DEFECTCLASS	Defect Class		QFEHLKLAS	CHAR	4
NUMBEROFDEFECTS	Number of Defect Occurrences		VDM_DEF_NUMBEROFOCC	INT4	4
INSPPLANOPERATIONINTERNALID	Current Node Number from Order Counter		QLFNKN	NUMC	16
INSPECTIONCHARACTERISTIC	Inspection Characteristic Number		QMERKNRP	NUMC	8
INSPECTIONSUBSETINTERNALID	Inspection Sample Number		QPROBENR	NUMC	12
MATERIALSAMPLE	Material Sample Number		QPHYSPRNR	CHAR	24
WORKCENTERTYPECODE	Object types of the CIM resource		CR_OBJTY	CHAR	4
MAINWORKCENTERINTERNALID	Object ID of the Work Center		LGWID	NUMC	16
MAINWORKCENTERPLANT	Plant for Work Center		QARBPWERKS	CHAR	8
MAINWORKCENTER	Work Center		PPH_ARBPL	CHAR	16
EQUIPMENT	Equipment Number		EQUNR	CHAR	36
FUNCTIONALLOCATION	Functional Location		TPLNR	CHAR	60
ISDELETED	Is Deleted		VDM_QDEFISDELETED	CHAR	2
DEFECTORIGIN	Origin of Item Record		QMFEHERK	CHAR	2
MATERIAL	Defective Material		VDM_DEFECTIVE_MATERIAL	CHAR	80
PLANT	Plant		WERKS_D	CHAR	8
STORAGELOCATION	Storage location		LGORT_D	CHAR	8
INSPECTIONLOT	Inspection Lot Number		QPLOS	NUMC	24
CATALOGPROFILE	Catalog Profile		RBNR	CHAR	18
CHANGEDDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
DEFECTLIFECYCLESTATUS	Defect Status		QDEFLCYCLESTAT	CHAR	4
PROBLEMANALYSISSTATUS	Problem Analysis		QDEFPANASTAT	CHAR	4
QUALITYISSUEREFERENCE	External Reference Number		QEXTREFNUM	CHAR	80
MASTERLANGUAGE	Primary language indicator for text segment		KZMLA	CHAR	2
DEFECTUUID	Defect UUID		QDEFECTUUID	RAW	16
PRODUCTIONSUPPLYAREA	Production Supply Area		VDM_PRVBE	CHAR	20
WAREHOUSE	Warehouse Number/Warehouse Complex		/SCWM/LGNUM	CHAR	8
STORAGETYPE	Source Storage Type		/SCWM/LTAP_VLTYP	CHAR	8
SOURCESTORAGEBIN	Source Storage Bin		/SCWM/LTAP_VLPLA	CHAR	36
DEFECTCONFIGURATIONVALUE	Defect Configuration		QDEFECTCONFIGURATION	STRG	8
DEFECTCAUSEDBY	Defect Caused By		QDEFECTCAUSEDBY	CHAR	4
COSTCENTER	Cost Center		KOSTL	CHAR	20
BOMITEMINSTANCEUUID	Internal Identification for DMU Objects of Type RAW 16		DMU_GUID16	RAW	16
PRODUCEDMATERIAL	Material Number		MATNR	CHAR	80
PRODUCEDSERIALNUMBER	Serial Number		GERNR	CHAR	36
HASACTIVEENTITY	Draft - Indicator - Has active document		SDRAFT_HAS_ACTIVE	CHAR	2
.INCLUDE				SDRAFT_WRITE_DRAFT_ADMIN	0
DRAFTENTITYCREATIONDATETIME	Draft Created On		SDRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed On		SDRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Technical ID for the Administrative Data of a Draft Document		SDRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYCONSISTENCYSTATUS	Draft - Consistency Status		SDRAFT_CONSISTENCY_STATUS	CHAR	2
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SDRAFT_OPERATION_CODE	CHAR	2
.INCLUDE				QMFE_INCL_EEW_PS	0
DUMMY_QMFE_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2