QALS - Inspection lot record

Inspection lot record information is stored in SAP table QALS.
It is part of development package QL in software component QM-IM. This development package consists of objects that can be grouped under "QM inspection lots".

Fields for table QALS

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDANT	Client	X	MANDT	CLNT	6	T000
PRUEFLOS	Inspection Lot Number	X	QPLOS	NUMC	24
WERK	Plant		WERKS_D	CHAR	8	T001W
ART	Inspection Type		QPART	CHAR	16	TQ30
HERKUNFT	Inspection Lot Origin		QHERK	CHAR	4	TQ31
OBJNR	Object number		J_OBJNR	CHAR	44	ONR00
OBTYP	Object Type		J_OBTYP	CHAR	6	TJ03
STSMA	Status Profile		J_STSMA	CHAR	16	TJ20
QMATAUTH	Material Authorization Group for Activities in QM		QMATAUTH	CHAR	12	TQ01B
STAT11	GR Blocked Stock		KZWES	CHAR	2
INSMK	Quantity Is or Was in Inspection Stock		QVINSMK	CHAR	2
STAT01	Inspection Lot Is Created Automatically		QSTAT01	CHAR	2
STAT02	Partial Lots Exist		QKZQALT	CHAR	2
STAT04	Data Record Was Changed Using Customer Exit		QUSER_EXIT	CHAR	2
STAT06	Record Appraisal Costs in Individual QM Order		QKZPRFKOST	CHAR	2
STAT07	Inspection with Inspection Points		QKZFERTPRF	CHAR	2
STAT08	Automatic Usage Decision Planned		QAUTO_VE	CHAR	2
STAT09	Source Inspection		QABNAHMPRF	CHAR	2
STAT10	Inspection Specifications from Configuration		QCONF	CHAR	2
STAT14	Completion of Short-Term Inspection		QSTAT14	CHAR	2
STAT16	Inspection Specifications from Batch Determination		QCHARG	CHAR	2
STAT18	Control of Inspection Lot Creation (Lot Summary)		Q1WELOS	CHAR	2
STAT19	Documentation Required for Inspection Lot		QSTAT19	CHAR	2
STAT20	Inspection Plan Required		QSTAT20	CHAR	2
STAT21	Enter Sample Manually		QSTAT21	CHAR	2
STAT22	Inspect with Material Specification		QSPEZUEBER	CHAR	2
STAT23	Inspection Lot Approval		QKZGENLOS	CHAR	2
STAT24	Digital Signature for Insp. Lot in Results Recording		SIG_IL_RES	CHAR	2
STAT25	Digital Signature for Insp. Lot When Usage Decision Made		SIG_IL_USA	CHAR	2
STAT29	Digital Signature for Confirmation of Sample Drawing		SIG_IL_SDR	CHAR	2
STAT26	Approved Batch Record Required		XGCHP	CHAR	2
STAT27	Inspection Lot is an R/2 Inspection Lot		QSTAT27	CHAR	2
STAT28	Select Characteristics Manually		QSTAT28	CHAR	2
STAT31	Trigger Sample Calculation Manually		QSTAT31	CHAR	2
STAT34	Stock Postings Completed		QSTAT34	CHAR	2
STAT35	Usage Decision Has Been Made		QSTAT35	CHAR	2
STAT45	Material as Dynamic Modification Criterion		QSTAT45	CHAR	2
STAT46	Supplier as Dynamic Modification Criterion		QSTAT46	CHAR	2
STAT47	Manufacturer as Dynamic Modification Criterion		QSTAT47	CHAR	2
STAT48	Customer as Dynamic Modification Criterion		QSTAT48	CHAR	2
STAT49	Machine as Dynamic Modification Criterion		QSTAT49	CHAR	2
STAT50	Project as Dynamic Modification Criterion		QSTAT50	CHAR	2
KZSKIPLOT	Lot Skipped		QKZSKIPLOT	CHAR	2
DYN	Skips Allowed		QDYN	CHAR	2
HPZ	100% Inspection		QHPZ	CHAR	2
EIN	Serial Numbers Possible		QEINZ	CHAR	2
ANZSN	Number of serial numbers		ANZSN	INT4	4
KZDYNERF	Dynamic Modification Is Carried Out		QKZDYNERF	CHAR	2
DYNHEAD	Level at Which Dynamic Modification Parameters Are Defined		QDYNHEAD	CHAR	2	TQ39A
STPRVER	Sampling Procedure		QSTPRVER	CHAR	16	QDSV
EXTNUM	External Numbering of Units to Be Inspected		QEXTNUM	CHAR	2	TQ12
STAFO	Update Group for statistics update		STAFO	CHAR	12	TMCB
STAT30	Origin of Inspection Lot Unit of Measure for LIS Interface		QUNITORIGIN	CHAR	2
QINFSTATUS	QINF Status		QINFSTATUS	CHAR	16
ENSTEHDAT	Date in Time Zone Where Lot Created		QENTST	DATS	16
ENTSTEZEIT	Time in Time Zone Where Lot Created		QENTSTZEIT	TIMS	12
ERSTELLER	Name of User Who Created the Data Record		QERSTELLER	CHAR	24
ERSTELDAT	System Date on Which Data Record Was Created		QDATUMERST	DATS	16
ERSTELZEIT	System Time of Lot Creation		QERSTEZEIT	TIMS	12
AENDERER	Name of User Who Last Changed Data Record		QAENDERER	CHAR	24
AENDERDAT	System Date on Which Data Record Was Changed		QDATUMAEND	DATS	16
AENDERZEIT	System Time of Lot Change		QAENDEZEIT	TIMS	12
CHANGEDDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
PASTRTERM	Start Date of Inspection in Local Time Zone		QPRSTART	DATS	16
PASTRZEIT	Inspection Start Time in Local Time Zone		QSTARTZEIT	TIMS	12
PAENDTERM	End Date of Inspection in Local Time Zone		QPRENDE	DATS	16
PAENDZEIT	Inspection End Time in Local Time Zone		QENDEZEIT	TIMS	12
PLNTY	Task List Type		PLNTY	CHAR	2	TCA01
PLNNR	Key for Task List Group		PLNNR	CHAR	16
PPLVERW	Task List Usage		PLN_VERWE	CHAR	6	T411
PLNAL	Group Counter		PLNAL	CHAR	4
STAT15	Production Resource/Tool Saved for Insp. Lot		QFHM_MODE	CHAR	2
SLWBEZ	Identifier for Inspection Point Field Combination		QSLWBEZ	CHAR	6	TQ79
STAT13	Inspection Point Type		QPPKTTYP	CHAR	2
PPKZTLZU	Partial Lot Assignment in an Inspection During Production		QPPKZTLZU	CHAR	2
PRBNAVERF	Sample-Drawing Procedure		QPRZIEHVER	CHAR	16	QPRVK
PRBNAVV	Version No. of the Sample-Drawing Procedure		QVERSNPRZV	CHAR	12
STAT12	Confirmation Required for Sample Drawing		QKZQUIT	CHAR	2
SELMATNR	Material Number		MATNR	CHAR	80	MARA
SELREVLV	Revision Level		REVLV	CHAR	4
SELWERK	Plant		WERKS_D	CHAR	8	T001W
SELLIFNR	Vendor's account number		ELIFN	CHAR	20	LFA1
STAT17	Manufacturer Part No. Processing Active		QHERST	CHAR	2
SELHERST	Number of Manufacturer		QLIFNR	CHAR	20	LFA1
SELKUNNR	Account number of customer		EKUNN	CHAR	20	KNA1
SELPPLVERW	Task List Usage		PLN_VERWE	CHAR	6	T411
GUELTIGAB	Key Date for Selecting Records or Changing Task Lists		QSTICHTAG	DATS	16
AUFNR	Order Number		AUFNR	CHAR	24	AUFK
AUFPL	Routing number of operations in the order		CO_AUFPL	NUMC	20
CUOBJ	Configuration (internal object number)		CUOBJ	NUMC	36
CUOBJ_CH	Internal object number of the batch classification		CUOBJ_CH	NUMC	36
VERID	Production Version		VERID	CHAR	8	MKAL
SA_AUFNR	Run schedule header number		SA_AUFNR	CHAR	24	SAFK
CVP_XBLCK	Business Purpose Completed Flag		CVP_XBLCK	CHAR	2
KUNNR	Customer (Ship-To Party)		QKUNWE	CHAR	20	KNA1
LIFNR	Vendor's account number		ELIFN	CHAR	20	LFA1
HERSTELLER	Number of Manufacturer		QLIFNR	CHAR	20	LFA1
EMATNR	Material number corresponding to manufacturer part number		EMATN	CHAR	80	MARA
MATNR	Material Number		MATNR	CHAR	80	MARA
REVLV	Revision Level		REVLV	CHAR	4
XCHPF	Batch Management Requirement Indicator		XCHPF	CHAR	2
CHARG	Batch Number		CHARG_D	CHAR	20	MCH1
LAGORTCHRG	Storage location		LGORT_D	CHAR	8	MCHB
VFDAT	Shelf Life Expiration or Best-Before Date		VFDAT	DATS	16
LICHN	Supplier Batch Number		LICHN	CHAR	30
SOBKZ	Special Stock Indicator		SOBKZ	CHAR	2	T148
PS_PSP_PNR	Valuated Sales Order Stock WBS Element		MAT_PSPNR	NUMC	16	PRPS
KDAUF	Sales order number of valuated sales order stock		MAT_KDAUF	CHAR	20
KDPOS	Sales Order Item of Valuated Sales Order Stock		MAT_KDPOS	NUMC	12
EKORG	Purchasing organization		EKORG	CHAR	8	T024E
EBELN	Purchasing Document Number		EBELN	CHAR	20	EKKO
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10	EKPO
ETENR	Delivery Schedule Line Counter		EETEN	NUMC	8	EKET
BLART	Document Type		BLART	CHAR	4	T003
MJAHR	Material Document Year		MJAHR	NUMC	8
MBLNR	Number of Material Document		MBLNR	CHAR	20
BUDAT	Posting Date in the Document		BUDAT	DATS	16
BWART	Movement type (inventory management)		BWART	CHAR	6	T156
WERKVORG	Plant Where Stock for Inspection Lot Is Held		QWERKVORG	CHAR	8	T001W
LAGORTVORG	Storage Location for Inspection Lot Stock		QLGORTVORG	CHAR	8	T001L
LGNUM	Warehouse Number / Warehouse Complex		LGNUM	CHAR	6	T300
LGTYP	Storage Type		LGTYP	CHAR	6	T301
LGPLA	Storage Bin		LGPLA	CHAR	20	LAGP
LS_KDAUF	Sales Order Number		KDAUF	CHAR	20
LS_KDPOS	Item number in Sales Order		KDPOS	NUMC	12
LS_VBELN	Delivery		VBELN_VL	CHAR	20
LS_POSNR	Delivery Item		POSNR_VL	NUMC	12
LS_ABRVW	Delivery Category		QABRVW	CHAR	6	TVLV
LS_ROUTE	Route		ROUTE	CHAR	12	TVRO
LS_LLAND	Destination Country/Region		LLAND	CHAR	6	T005
LS_KUNAG	Sold-to Party		KUNAG	CHAR	20	KNA1
LS_VKORG	Sales Organization		VKORG	CHAR	8	TVKO
LS_KDMAT	Customer Material		KDMAT	CHAR	70
SPRACHE	Language Key		SPRAS	LANG	2	T002
KTEXTLOS	Short Text		QKURZTEXT	CHAR	80
LTEXTKZ	Long Text Exists For Inspection Lot		QLTEXTLOS	CHAR	2
KTEXTMAT	Short Text for Inspection Object		QKTEXTOBJ	CHAR	80
LS_EQUNR	Equipment Number		EQUNR	CHAR	36
LS_TPLNR	Functional Location		TPLNR	CHAR	60
OFFENNLZMK	Number of Outstanding Short-Term Chars That Require Confirm.		QOFFENLZMK	INT2	2
OFFEN_LZMK	Number of Outstanding Long-Term Chars That Require Confirm.		QOFFELZMK	INT2	2
LOSMENGE	Inspection Lot Quantity		QLOSMENGE	QUAN	7
MENGENEINH	Base Unit of Measure for Inspection Lot Quantity		QLOSMENGEH	UNIT	6	T006
ANZGEB	QM - No. of Containers		QANZGEB	QUAN	4
GEBEH	Lot Container		QGEBEH	UNIT	6	T006
LVS_STIKZ	Indicator: what has happened to insp.sample (QM) in WM		LVS_STIKZ	CHAR	2
LVS_STIMG	Sample in base unit of measure provided by WM		LVS_STIMG	QUAN	7
GESSTICHPR	Inspection Sample Size		QGESTICH	QUAN	7
EINHPROBE	Base Unit of Measure for Sample Unit		QPROBEMGEH	UNIT	6	T006
DYNREGEL	Dynamic Modification Rule		QDYNREGEL	CHAR	6	QDDR
STAT44	Time of Dynamic Modification in Inspection Lot		QDYNTIME	CHAR	2
PRSTUFE	Inspection Stage		QPRSTUFE	NUMC	8	QDPS
PRSCHAERFE	Inspection Severity		QPRSCHAERF	NUMC	6	QDEP
LMENGE01	Quantity Posted to Unrestricted-Use Stock		QLMENGE01F	QUAN	7
LMENGE02	Quantity Posted to Scrap		QLMENGE02F	QUAN	7
LMENGE03	Quantity Posted to Sample		QLMENGE03F	QUAN	7
LMENGE04	Quantity Posted to Blocked Stock		QLMENGE04F	QUAN	7
LMENGE05	Quantity Posted to Reserves		QLMENGE05F	QUAN	7
LMENGE06	Quantity Posted to Another Material		QLMENGE06F	QUAN	7
MATNRNEU	Material Number to Which the Quantity is Posted		QMATNRNEU	CHAR	80	MARA
CHARGNEU	Batch to Which Goods Are Transferred		QCHARGNEU	CHAR	20	MCH1
LMENGE07	Quantity Returned to Vendor		QLMENGE07F	QUAN	7
LMENGE08	Other Quantity Posted from Inspection Lot Stock		QLMENGE08F	QUAN	7
LMENGE09	Other Quantity (2) Posted from Inspection Lot Stock		QLMENGE09F	QUAN	7
LMENGEZUB	Quantity That Must Be Posted		QLMENGEZUB	QUAN	7
LMENGELZ	Sample Quantity for Long-Term Characteristics		QLMENGELZ	QUAN	7
LMENGEPR	Quantity Actually Inspected		QLMENGEPR	QUAN	7
LMENGEZER	Quantity Destroyed During Inspection		QLMENGEZER	QUAN	7
LMENGEIST	Actual Lot Quantity		QLMENGEIST	QUAN	7
LMENGESCH	Defective Quantity in Inspected Quantity		QLMENGESCH	QUAN	7
LTEXTKZBB	Logs Exist for Usage Decision		QLTEXTKZBB	CHAR	2
ANTEIL	Share of Scrap in Inspection Lot		QAUSANTEIL	FLTP	8
QKZVERF	Procedure for Calculating Quality Score		QKZVERF	CHAR	4	TQ06
STAT03	Usage Decision Mode (UD Origin)		QMODUS_UD	CHAR	2
QPMATLOS	Allowed Share of Scrap		QPMATLOS	FLTP	8
AUFNR_CO	Order Number for Recording Appraisal Costs		QAUFNR_CO	CHAR	24	AUFK
KZVBR	Consumption posting		KZVBR	CHAR	2
KNTTP	Account Assignment Category		KNTTP	CHAR	2	T163K
PSTYP	Item category in purchasing document		PSTYP	CHAR	2	T163
STAT05	Account Assignment Key: Inspection Lot		QKZQALSKNT	CHAR	2
KOSTL	Cost Center		KOSTL	CHAR	20	CSKS
AUFPS	Item Number of Reservation / Dependent Requirements		RSPOS	NUMC	8
ANLN1	Main Asset Number		ANLN1	CHAR	24	ANLH
ANLN2	Asset Subnumber		ANLN2	CHAR	8	ANLA
KONT_PSPNR	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
NPLNR	Network Number for Account Assignment		NPLNR	CHAR	24	AUFK
APLZL	Internal counter		CIM_COUNT	NUMC	16
KONT_KDAUF	Sales Order Number		KDAUF	CHAR	20
KONT_KDPOS	Item number in Sales Order		KDPOS	NUMC	12
IMKEY	Internal Key for Real Estate Object		IMKEY	CHAR	16
DABRZ	Reference date for settlement		DABRBEZ	DATS	16
KSTRG	Cost Object		KSTRG	CHAR	24	CKPH
PAOBJNR	Profitability Segment Number (CO-PA)		RKEOBJNR	NUMC	20
PRCTR	Profit Center		PRCTR	CHAR	20	CEPC
GSBER	Business Area		GSBER	CHAR	8	TGSB
KONTO	G/L Account Number		SAKNR	CHAR	20	SKA1
KOKRS	Controlling Area		KOKRS	CHAR	8	TKA01
BUKRS	Company Code		BUKRS	CHAR	8	T001
SERNP	Serial Number Profile		SERAIL	CHAR	8	T377P
LOS_REF	Inspection Lot Number Which Is Referenced		QLOS_REF	NUMC	24	QALS
.INCLUDE				CI_QALS	0
BEARBSTATU	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED02	CHAR	4
STAT32	Inspection Lot for Stability Study		QSTABI	CHAR	2
STAT33	Indicator: Multiple Specifications		Q_MS_FLG	CHAR	2
STAT36	Lot Has Partial Lots Without Insp. Point and Insp. Specs		QTLS_WO_INSPPOINT	CHAR	2
STAT37	Inspection Lot Is Blocked for Archiving		QL_BLOCKED4ARCHIVING	CHAR	2
STAT38	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
STAT39	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
STAT40	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
STAT41	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
STAT42	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
STAT43	Inspection Lot Created for First Article Inspection		QINSP_FAI	CHAR	2
MENGU	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
KZPZADR	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
KZPRADR	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
KZERSTLIEF	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
KZERSTMUST	Field Not Used as of 3.0 Field Reserved for SAP		Q_UNUSED01	CHAR	2
.INCLUDE				QALS_ADDON	0
ADDON_DUMMY	Dummy Field for ADDON Structures in QM		QDUMMY	CHAR	2
.INCLU--AP				QSTQALS0001	0
WARPL	Maintenance Plan		WARPL	CHAR	24	MPLA
WAPOS	Maintenance item		WAPOS	CHAR	32
ABNUM	Maintenance Plan Call Number		ABNUM	INT4	4
STRAT	Maintenance Strategy		STRAT	CHAR	12	T351
.INCLU--AP				RMXTQALS0001	0
TRIALID	Trial Number		RMXTE_TRIALID	CHAR	24
RESPONSIBLE	Responsible		ESEREALO	CHAR	90
INSP_DOC_NUMBER	Inspection Document Number from External System		QINSP_DOC_NUMBER	CHAR	60
LOG_SYSTEM	Logical system		LOGSYS	CHAR	20
GESSTICHPR_EXT	Sample Size from External System		QGESTICH_EXT	QUAN	7
EINHPROBE_EXT	Unit of Measure of External Sample		QPROBEMGEH_EXT	UNIT	6
PRIO_PUNKTE	Priority Points		QPRIO_PUNKTE	INT4	4
SIGN_TYPE_RR	Signature Type: Inspection Lot Results Recording		SIGN_TYPE_RR	CHAR	2
SIGN_TYPE_UD	Signature Type: Inspection Lot Usage Decision		SIGN_TYPE_UD	CHAR	2
SIGN_TYPE_SM	Signature Type: Sample Drawing		SIGN_TYPE_SM	CHAR	2
SIGNSTRAT_RR	Signature Strategy: Inspection Lot Results Recording		SIGNSTRAT_RR	CHAR	16
SIGNSTRAT_UD	Signature Strategy with Individual Signature: Usage Decision		SIGNSTRAT_UD	CHAR	16
SIGNSTRAT_SM	Signature Strategy w. Ind.Signature: Sample Drawing		SIGNSTRAT_SM	CHAR	16
.INCLUDE	EXT			QALS_INCL_EEW_PS	0
DUMMY_QALS_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2
LOT_GUID	Internal Identification for Inspection Lot		QALS_GUID	RAW	16
SETUP_ORIG	Origin of Inspection Lot Setup		QL_SETUP_ORIG	CHAR	2
.INCLUDE	EWM_ARGS			QALS_EWM_ARGS	0
EWM_IS_LOCAL	X and Blank		QKZ	CHAR	2
CAT_FROM	Stock Type		/LIME/STOCK_CATEGORY	CHAR	4
CATLOCN_TO	Inspection Rule Argument: Location-Independent Stock Type		/SCWM/DE_QCATLOCN	CHAR	4	*
PROCESS_STEP	External Storage Process Step		/SCWM/DE_PROCS	CHAR	8	*
COO	Country/Region of Origin		/SCWM/DE_COO	CHAR	6
INSP_GROUP	Quality Inspection Group		/SCWM/DE_QGRP	CHAR	8	*
INBOUND_PROC	Inbound Inspection Process		/SCWM/DE_QINB_PROC	CHAR	2
IOT_GUID	GUID of Inspection Object Type		QIE_TV_IOBTYP_GUID	RAW	16
RLGRP	Inspection Rule Group		/SCWM/DE_QRGRP	CHAR	8	*
EXCCODE	Exception Code		/SCWM/DE_EXCCODE	CHAR	8	*
WITHDRAWN_SAMPLE_QTY	Withdrawn Quantity for External Sample Size		/SCWM/DE_QDOC_WITHDRAWN_SAMPLE	QUAN	16
.INCLUDE				/CWM/QALS_I	0
/CWM/LOSMENGE	Inspection Lot Quantity in Parallel Unit of Measure		/CWM/QLOSMENGE	QUAN	7
/CWM/MENGENEINH	Parallel Unit of Measure of Inspection Lot Quantity		/CWM/QLOSMENGEH	UNIT	6	*
/CWM/LMENGE01	Quantity in PUoM Posted to Unrestricted Stock		/CWM/QLMENGE01F	QUAN	7
/CWM/LMENGE02	Quantity in PUoM Posted to Scrap		/CWM/QLMENGE02F	QUAN	7
/CWM/LMENGE03	Quantity Posted to Sample		/CWM/QLMENGE03F	QUAN	7
/CWM/LMENGE04	Quantity in PUoM Posted to Blocked Stock		/CWM/QLMENGE04F	QUAN	7
/CWM/LMENGE05	Quantity in PUoM Posted to Reserves		/CWM/QLMENGE05F	QUAN	7
/CWM/LMENGE06	Quantity in PUoM Posted to a Different Material		/CWM/QLMENGE06F	QUAN	7
/CWM/LMENGE07	Quantity in PUoM Posted Back to Vendor		/CWM/QLMENGE07F	QUAN	7
/CWM/LMENGE08	Other Posted Quantity in PUoM from Inspection Lot Stock		/CWM/QLMENGE08F	QUAN	7
/CWM/LMENGE09	Second Other Posted Quant. from Inspection Lot Stock in PUoM		/CWM/QLMENGE09F	QUAN	7
/CWM/LMENGEZUB	Quantity to be Posted in PUoM		/CWM/QLMENGEZUB	QUAN	7
/CWM/LMENGEIST	Actual Lot Quantity in PUoM		/CWM/QLMENGEIST	QUAN	7