QINSPLOT_D - I_INSPECTIONLOTTP I_INSPECTIONLOTTP

I_INSPECTIONLOTTP I_INSPECTIONLOTTP information is stored in SAP table QINSPLOT_D.
It is part of development package VDM_QM_INSPECTION in software component QM-IM. This development package consists of objects that can be grouped under "Inspection Processing, Virtual data model".

Fields for table QINSPLOT_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
INSPECTIONLOT	Inspection Lot Number		QPLOS	NUMC	24
MATERIAL	Material Number		MATNR	CHAR	80
BATCH	Batch Number		CHARG_D	CHAR	20
PLANT	Plant		WERKS_D	CHAR	8
INSPECTIONLOTORIGIN	Inspection Lot Origin		VDM_QHERK	CHAR	4
ORDERINTERNALBILLOFOPERATIONS	Routing number of operations in the order		CO_AUFPL	NUMC	20
MANUFACTURINGORDER	Order Number (Production Order)		VDM_QM_FERTAUFNR	CHAR	24
INSPECTIONLOTTEXT	Inspection Lot Text		VDM_QPLOS_TEXT	CHAR	80
INSPECTIONLOTTYPE	Inspection Type		QPART	CHAR	16
INSPECTIONLOTQUANTITY	Inspection Lot Quantity		VDM_QLOSMENGE	QUAN	7
INSPECTIONLOTACTUALQUANTITY	Actual Lot Quantity		VDM_QLMENGEIST	QUAN	7
INSPECTIONLOTDEFECTIVEQUANTITY	Defective Quantity		VDM_QLMENGESCH	QUAN	7
INSPECTIONLOTQUANTITYUNIT	Base Unit of Measure for Inspection Lot Quantity		QLOSMENGEH	UNIT	6
INSPLOTCREATEDONLOCALDATE	Date in Time Zone Where Lot Created		QENTST	DATS	16
INSPSUBSETFIELDCOMBINATION	Identifier for Inspection Point Field Combination		QSLWBEZ	CHAR	6
INSPLOTNMBROPENLONGTERMCHARC	Open Long-Term Characteristics		VDM_QOFFELZMK	INT2	2
STATUSOBJECT	Object number		J_OBJNR	CHAR	44
STATUSOBJECTCATEGORY	Object Type		J_OBTYP	CHAR	6
INSPECTIONLOTOBJECTTEXT	Short Text for Inspection Object		QKTEXTOBJ	CHAR	80
STATUSPROFILE	Status Profile		J_STSMA	CHAR	16
MATLQUALITYAUTHORIZATIONGROUP	Material Authorization Group for Activities in QM		VDM_QMATAUTH	CHAR	12
INSPECTIONLOTHASQUANTITY	Posted to Inspection Stock		VDM_QVINSMK	CHAR	2
INSPLOTISCREATEDAUTOMATICALLY	Inspection Lot Is Created Automatically		QSTAT01	CHAR	2
INSPECTIONLOTHASPARTIALLOTS	Partial Lots Exist		QKZQALT	CHAR	2
INSPECTIONLOTHASAPPRAISALCOSTS	Record Appraisal Costs in Individual QM Order		QKZPRFKOST	CHAR	2
INSPLOTHASSUBSETS	Inspection with Inspection Points		QKZFERTPRF	CHAR	2
INSPLOTISAUTOMUSGEDCSNPOSSIBLE	Automatic Usage Decision Planned		VDM_QAUTO_VE	CHAR	2
PURCHASINGDOCUMENTCATEGORY	Source Inspection		QABNAHMPRF	CHAR	2
INSPLOTHASCONFIGNSPECIFICATION	Inspection Specifications from Configuration		QCONF	CHAR	2
GOODSRECEIPTISMOVEDTOBLKDSTOCK	GR Blocked Stock		KZWES	CHAR	2
INSPLOTISDOCUMENTATIONREQUIRED	Documentation Required		VDM_QSTAT19	CHAR	2
INSPLOTISTASKLISTREQUIRED	Inspection Plan Required		VDM_QSTAT20	CHAR	2
INSPLOTHASMANUALSAMPLESIZE	Enter Sample Manually		QSTAT21	CHAR	2
INSPLOTHASMATERIALSPEC	Inspect with Material Specification		VDM_QSPEZUEBER	CHAR	2
INSPECTIONLOTAPPROVAL	Inspection Lot Approval		VDM_QKZGENLOS	CHAR	2
INSPLOTDIGITALSGNTRRESULTSRECG	Digital Signature for Insp. Lot in Results Recording		SIG_IL_RES	CHAR	2
INSPLOTDIGITALSGNTRINUSGEDCSN	Digital Signature Usage Decision		VDM_QDGTLSGNTRUSGEDCSN	CHAR	2
INSPLOTISBATCHREQUIRED	Approved Batch Record Required		XGCHP	CHAR	2
INSPLOTUSAGEINSTABILITYSTUDY	Inspection Lot for Stability Study		QSTABI	CHAR	2
INSPLOTISSTOCKPOSTINGCOMPLETED	Stock Postings Completed		VDM_QSTAT34	CHAR	2
INSPECTIONLOTHASUSAGEDECISION	Usage Decision Made		VDM_QSTAT35	CHAR	2
NUMBEROFSERIALNUMBERS	Number of serial numbers		ANZSN	INT4	4
INSPLOTISSERIALNMBRPOSSIBLE	Serial Numbers Possible		QEINZ	CHAR	2
INSPECTIONLOTISSKIPPED	Skip Lot		VDM_QKZSKIPLOT	CHAR	2
INSPECTIONLOTISFULLINSPECTION	100% Inspection		QHPZ	CHAR	2
INSPECTIONLOTDYNAMICLEVEL	Level at Which Dynamic Modification Parameters Are Defined		VDM_QDYNHEAD	CHAR	2
SAMPLINGPROCEDURE	Sampling Procedure		QSTPRVER	CHAR	16
INSPLOTCREATEDONLOCALTIME	Time in Time Zone Where Lot Created		VDM_QENTSTZEIT	TIMS	12
INSPECTIONLOTCREATEDBY	Name of User Who Created the Data Record		QERSTELLER	CHAR	24
INSPECTIONLOTCREATEDON	System Date on Which Data Record Was Created		QDATUMERST	DATS	16
INSPECTIONLOTCREATEDONTIME	System Time of Creation		VDM_QERSTEZEIT	TIMS	12
INSPECTIONLOTCHANGEDBY	Name of User Who Last Changed Data Record		QAENDERER	CHAR	24
INSPECTIONLOTCHANGEDATE	System Date on Which Data Record Was Changed		QDATUMAEND	DATS	16
INSPECTIONLOTCHANGETIME	System Time of Change		VDM_QAENDEZEIT	TIMS	12
CHANGEDDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
INSPECTIONLOTSTARTDATE	Start Date of Inspection in Local Time Zone		QPRSTART	DATS	16
INSPECTIONLOTSTARTTIME	Inspection Started At		VDM_QSTARTZEIT	TIMS	12
INSPECTIONLOTENDDATE	End Date of Inspection in Local Time Zone		QPRENDE	DATS	16
INSPECTIONLOTENDTIME	Inspection Ended At		VDM_QENDEZEIT	TIMS	12
BILLOFOPERATIONSTYPE	Bill of Operations Type		VDM_PLNTY	CHAR	2
BILLOFOPERATIONSGROUP	Bill of Operations Group		VDM_PLNNR	CHAR	16
BILLOFOPERATIONSUSAGE	Bill of Operations Usage		VDM_PLN_VERWE	CHAR	6
BILLOFOPERATIONSVARIANT	Bill of Operations Group Counter		VDM_PLNAL	CHAR	4
BILLOFOPERATIONSCHANGESTATEID	Internal counter		CIM_COUNT	NUMC	16
INSPECTIONSUBSETTYPE	Inspection Point Type		VDM_QPPKTTYP	CHAR	2
SMPLDRAWINGPROCEDURE	Sample-Drawing Procedure		VDM_QPRZIEHVER	CHAR	16
SMPLDRAWINGPROCEDUREVERSION	Version No. of the Sample-Drawing Procedure		QVERSNPRZV	CHAR	12
SMPLDRWGPROCEDISCONFREQUIRED	Confirmation Required for Sample Drawing		VDM_QKZQUIT	CHAR	2
INSPLOTSELECTIONMATERIAL	Material Number		MATNR	CHAR	80
INSPLOTSELMATLREVISIONLVL	Revision Level		REVLV	CHAR	4
INSPLOTSELECTIONPLANT	Plant		WERKS_D	CHAR	8
INSPLOTSELECTIONSUPPLIER	Vendor's account number		ELIFN	CHAR	20
INSPLOTSELECTIONMANUFACTURER	Number of Manufacturer		QLIFNR	CHAR	20
INSPLOTSELECTIONCUSTOMER	Account number of customer		EKUNN	CHAR	20
INSPLOTSELBILLOFOPERATIONSUSGE	Task List Usage		PLN_VERWE	CHAR	6
INSPLOTSELECTIONVALIDFROMDATE	Key Date for Selecting Records or Changing Task Lists		QSTICHTAG	DATS	16
PRODUCTIONVERSION	Production Version		VERID	CHAR	8
SALESOPERATIONSPLANNINGORDER	Run Schedule Header		VDM_SA_AUFNR	CHAR	24
ISBUSINESSPURPOSECOMPLETED	Business Purpose Completed Flag		CVP_XBLCK	CHAR	2
CUSTOMER	Customer (Ship-To Party)		VDM_QKUNWE	CHAR	20
SUPPLIER	Vendor's account number		ELIFN	CHAR	20
BATCHBYSUPPLIER	Supplier Batch Number		LICHN	CHAR	30
MANUFACTURER	Number of Manufacturer		QLIFNR	CHAR	20
MANUFACTURERPARTNMBR	Manufacturer Material		VDM_EMATN	CHAR	80
MATERIALREVISIONLEVEL	Revision Level		REVLV	CHAR	4
MATERIALISBATCHMANAGED	Batch Required		VDM_XCHPF	CHAR	2
BATCHSTORAGELOCATION	Storage Location for Batch		VDM_QLGORTCHAR	CHAR	8
MATERIALCOMPISSPECIALSTOCK	Special Stock Indicator		SOBKZ	CHAR	2
PURCHASINGORGANIZATION	Purchasing Organization		EKORG_LL	CHAR	8
PURCHASINGDOCUMENT	Purchasing Document		FIS_EBELN	CHAR	20
PURCHASINGDOCUMENTITEM	Purchasing Document Item		VDM_EBELP	NUMC	10
SCHEDULELINE	Delivery Schedule Line Counter		EETEN	NUMC	8
ACCOUNTINGDOCUMENTTYPE	Document Type		VDM_BLART	CHAR	4
MATERIALDOCUMENTYEAR	Material Document Year		VDM_MJAHR	NUMC	8
MATERIALDOCUMENT	Number of Material Document		MBLNR	CHAR	20
MATERIALDOCUMENTITEM	Material Document Item		VDM_MBLPO	NUMC	8
MATLDOCLATESTPOSTGDATE	Posting Date in the Document		BUDAT	DATS	16
GOODSMOVEMENTTYPE	Movement type (inventory management)		BWART	CHAR	6
INSPECTIONLOTPLANT	Plant for Inspection Lot		VDM_QWERKVORG	CHAR	8
INSPECTIONLOTSTORAGELOCATION	Storage Location for Inspection Lot Stock		VDM_QLGORTVORG	CHAR	8
WAREHOUSE	Warehouse Number / Warehouse Complex		LGNUM	CHAR	6
STORAGETYPE	Storage Type		LGTYP	CHAR	6
STORAGEBIN	Storage Bin		LGPLA	CHAR	20
SALESORDER	Sales Order Number		KDAUF	CHAR	20
SALESORDERITEM	Sales Order Item		VDM_KDPOS	NUMC	12
DELIVERYDOCUMENT	Delivery Document		VDM_DELIVERYDOCUMENT	CHAR	20
DELIVERYDOCUMENTITEM	Delivery Document Item		VDM_POSNR_VL	NUMC	12
DELIVERYCATEGORY	Delivery Category		QABRVW	CHAR	6
ROUTE	Route		ROUTE	CHAR	12
BILLTOPARTYCOUNTRY	Destination Country/Region		LLAND	CHAR	6
SOLDTOPARTY	Customer (Sold-To Party)		VDM_KUNAG	CHAR	20
SALESORGANIZATION	Sales Organization		VKORG	CHAR	8
MATERIALBYCUSTOMER	Customer Material		KDMAT	CHAR	70
LANGUAGE	Language Key		SPRAS	LANG	2
INSPLOTNMBRADDLRECORDEDCHARC	Number of Characteristics Recorded Additionally		QZUSMKZHL	INT2	2
INSPLOTNMBROPENSHORTTERMCHARC	Number of Outstanding Short-Term Chars That Require Confirm.		QOFFENLZMK	INT2	2
INSPECTIONLOTCONTAINER	QM - No. of Containers		QANZGEB	QUAN	4
INSPECTIONLOTCONTAINERUNIT	Lot Container		QGEBEH	UNIT	6
INSPECTIONLOTSAMPLEQUANTITY	Inspection Sample Size		QGESTICH	QUAN	7
INSPECTIONLOTSAMPLEUNIT	Sample Unit of Measure		VDM_QPROBEMGEH	UNIT	6
INSPLOTDYNAMICRULE	Dynamic Modification Rule		VDM_QDYNREGEL	CHAR	6
INSPLOTDYNAMICTRGGRPOINT	Time of Dynamic Modification in Inspection Lot		QDYNTIME	CHAR	2
INSPECTIONDYNAMICSTAGE	Inspection Stage		QPRSTUFE	NUMC	8
INSPECTIONSEVERITY	Inspection Severity		QPRSCHAERF	NUMC	6
INSPLOTQTYTOFREE	Unrestricted-Use Stock		VDM_QLMENGE01F	QUAN	7
INSPLOTQTYTOSCRAP	Scrap Quantity		VDM_QLMENGE02F	QUAN	7
INSPLOTQTYTOSAMPLE	Quantity Posted to Sample		QLMENGE03F	QUAN	7
INSPLOTQTYTOBLOCKED	Blocked Stock		VDM_QLMENGE04F	QUAN	7
INSPLOTQTYTORESERVES	Quantity Posted to Reserves		QLMENGE05F	QUAN	7
INSPLOTQTYTOANOTHERMATERIAL	New Material		VDM_QLMENGE06F	QUAN	7
INSPLOTMATERIALPOSTEDTO	Material Posted To		VDM_QMATNRNEU	CHAR	80
INSPLOTBATCHTRANSFERREDTO	Batch Transferred To		VDM_QCHARGNEU	CHAR	20
INSPLOTQTYRETURNEDTOSUPPLIER	Return to Supplier		VDM_QLMENGE07F	QUAN	7
INSPLOTQTYTOSPECIALSTOCK	Other Quantity		VDM_QLMENGE08F	QUAN	7
INSPLOTQTYTOOTHERSTOCK	Other Quantity 2		VDM_QLMENGE09F	QUAN	7
INSPLOTQTYTOBEPOSTED	Quantity to Be Posted		VDM_QLMENGEZUB	QUAN	7
INSPLOTSMPLQTYFORLONGTERMCHAR	Long-Term Sample Quantity		VDM_QLMENGELZ	QUAN	7
INSPLOTQTYINSPECTED	Inspected Quantity		VDM_QLMENGEPR	QUAN	7
INSPLOTQTYDESTROYED	Destroyed Quantity		VDM_QLMENGEZER	QUAN	7
INSPECTIONLOTSCRAPRATIO	Share of Scrap in Inspection Lot		QAUSANTEIL	FLTP	8
INSPLOTUSAGEDECISIONTOOL	Usage Decision Mode (UD Origin)		QMODUS_UD	CHAR	2
INSPECTIONLOTALLOWEDSCRAPRATIO	Allowed Share of Scrap		QPMATLOS	FLTP	8
QUALITYCOSTCOLLECTOR	Order Number for Recording Appraisal Costs		QAUFNR_CO	CHAR	24
CONSUMPTIONPOSTING	Consumption posting		KZVBR	CHAR	2
ACCOUNTASSIGNMENTCATEGORY	Account Assignment Category		KNTTP	CHAR	2
PURCHASINGDOCUMENTITEMCATEGORY	Item category in purchasing document		PSTYP	CHAR	2
INSPLOTACCTASSGMTKEY	Account Assignment Key: Inspection Lot		QKZQALSKNT	CHAR	2
COSTCENTER	Cost Center		KOSTL	CHAR	20
RESERVATIONITEM	Item Number of Reservation / Dependent Requirements		RSPOS	NUMC	8
MASTERFIXEDASSET	Main Asset Number		ANLN1	CHAR	24
FIXEDASSET	Asset Subnumber		ANLN2	CHAR	8
SALESORDSTOCKWBSELEMENT	Valuated Sales Order Stock WBS Element		MAT_PSPNR	NUMC	16
PROJECTNETWORK	Network Number for Account Assignment		NPLNR	CHAR	24
NETWORKACTIVITYINTERNALID	Internal counter		CIM_COUNT	NUMC	16
INVENTORYSPCLSTKSALESDOCUMENT	Inventory Special Stock Sales Document		VDM_MAT_KDAUF	CHAR	20
INVENTORYSPCLSTKSALESDOCITM	Sales Order Item of Valuated Sales Order Stock		MAT_KDPOS	NUMC	12
PROFITABILITYSEGMENT	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
PROFITCENTER	Profit Center		PRCTR	CHAR	20
BUSINESSAREA	Business Area		GSBER	CHAR	8
GLACCOUNT	G/L Account Number		SAKNR	CHAR	20
CONTROLLINGAREA	Controlling Area		KOKRS	CHAR	8
COMPANYCODE	Company Code		BUKRS	CHAR	8
SERIALNUMBERPROFILE	Serial Number Profile		SERAIL	CHAR	8
INSPLOTCOSTCOLLECTORSALESORDER	Sales Order Number		KDAUF	CHAR	20
INSPLOTCOSTCOLLECTORSLSORDITEM	Item number in Sales Order		KDPOS	NUMC	12
INSPLOTCOSTCOLLECTORWBSELEMENT	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16
INSPLOTEXTERNALNUMBER	Inspection Document Number		VDM_QINSP_DOC_NUMBER	CHAR	60
INSPECTIONLOTPRIORITYPOINTS	Priority Points		QPRIO_PUNKTE	INT4	4
MAINTENANCEPLAN	Maintenance Plan		WARPL	CHAR	24
MAINTENANCEPLANITEMINTID	Maintenance item		WAPOS	CHAR	32
MAINTENANCESTRATEGY	Maintenance Strategy		STRAT	CHAR	12
INSPUSGEDCSNDGTLSGNTRTYPE	Signature Type: Inspection Lot Usage Decision		VDM_QSIGN_TYPE_UD	CHAR	2
INSPUSGEDCSNDGTLSGNTRSTRGY	Signature Strategy with Individual Signature: Usage Decision		VDM_QSIGNSTRAT_UD	CHAR	16
APPLICATIONOBJECTSIGNKEY	DS Enhancement: Draft Signature ID		DS_ENH_DRAFT_SIGN_ID	CHAR	120
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				QALS_INCL_EEW_PS	0
DUMMY_QALS_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2