	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

238 COLUMNS | 9 INDEXES | ERP 6.0 | QALS TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Quality Management :: Quality Inspection
1	ERP EHP7	6.0	QALS	238	9	Inspection lot record	Quality Inspection

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDANT, PRUEFLOS, WERK, ART, HERKUNFT, OBJNR, OBTYP, STSMA, QMATAUTH, STAT11, INSMK, STAT01, STAT02, STAT04, STAT06, STAT07, STAT08, STAT09, STAT10, STAT14, STAT16, STAT18, STAT19, STAT20, STAT21, STAT22, STAT23, STAT24, STAT25, STAT29, STAT26, STAT27, STAT28, STAT31, STAT34, STAT35, STAT45, STAT46, STAT47, STAT48, STAT49, STAT50, KZSKIPLOT, DYN, HPZ, EIN, ANZSN, KZDYNERF, DYNHEAD, STPRVER, EXTNUM, STAFO, STAT30, QINFSTATUS, ENSTEHDAT, ENTSTEZEIT, ERSTELLER, ERSTELDAT, ERSTELZEIT, AENDERER, AENDERDAT, AENDERZEIT, PASTRTERM, PASTRZEIT, PAENDTERM, PAENDZEIT, PLNTY, PLNNR, PPLVERW, PLNAL, ZAEHL, ZKRIZ, STAT15, SLWBEZ, STAT13, PPKZTLZU, ZAEHL1, PRBNAVERF, PRBNAVV, STAT12, SELMATNR, SELREVLV, SELWERK, SELLIFNR, STAT17, SELHERST, SELKUNNR, SELPPLVERW, GUELTIGAB, AUFNR, AUFPL, CUOBJ, CUOBJ_CH, VERID, SA_AUFNR, KUNNR, LIFNR, HERSTELLER, EMATNR, MATNR, REVLV, XCHPF, CHARG, LAGORTCHRG, ZEUGNISBIS, VFDAT, LICHN, SOBKZ, PS_PSP_PNR, KDAUF, KDPOS, EKORG, EBELN, EBELP, ETENR, BLART, MJAHR, MBLNR, ZEILE, BUDAT, BWART, WERKVORG, LAGORTVORG, LGNUM, LGTYP, LGPLA, LS_KDAUF, LS_KDPOS, LS_VBELN, LS_POSNR, LS_ABRVW, LS_ROUTE, LS_LLAND, LS_KUNAG, LS_VKORG, LS_KDMAT, SPRACHE, KTEXTLOS, LTEXTKZ, KTEXTMAT, ZUSMKZAEHL, OFFENNLZMK, OFFEN_LZMK, LOSMENGE, MENGENEINH, ANZGEB, GEBEH, LVS_STIKZ, LVS_STIMG, GESSTICHPR, EINHPROBE, DYNREGEL, STAT44, PRSTUFE, PRSCHAERFE, LMENGE01, LMENGE02, LMENGE03, LMENGE04, LMENGE05, LMENGE06, MATNRNEU, CHARGNEU, LMENGE07, LMENGE08, LMENGE09, LMENGEZUB, LMENGELZ, LMENGEPR, LMENGEZER, LMENGEIST, LMENGESCH, LTEXTKZBB, ANTEIL, QKZVERF, STAT03, QPMATLOS, AUFNR_CO, KZVBR, KNTTP, PSTYP, STAT05, KOSTL, AUFPS, ANLN1, ANLN2, KONT_PSPNR, NPLNR, APLZL, KONT_KDAUF, KONT_KDPOS, IMKEY, DABRZ, KSTRG, PAOBJNR, PRCTR, GSBER, KONTO, KOKRS, BUKRS, SERNP, LOS_REF, BEARBSTATU, STAT32, STAT33, STAT36, STAT37, STAT38, STAT39, STAT40, STAT41, STAT42, STAT43, MENGU, KZPZADR, KZPRADR, ZUSCH, ZUSTD, KZERSTLIEF, KZERSTMUST, ADDON_DUMMY, WARPL, WAPOS, ABNUM, STRAT, TRIALID, RESPONSIBLE, INSP_DOC_NUMBER, LOG_SYSTEM, GESSTICHPR_EXT, EINHPROBE_EXT, PRIO_PUNKTE, SIGN_TYPE_RR, SIGN_TYPE_UD, SIGN_TYPE_SM, SIGNSTRAT_RR, SIGNSTRAT_UD, SIGNSTRAT_SM FROM QALS

TOP ERP 6.0 | QALS COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDANT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	PRUEFLOS	Inspection Lot Number	nvarchar	12	0	NUMC	(N'000000000000')	No		QPLOS	Allow NULL?
3	WERK	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
4	ART	Inspection Type	nvarchar	8	0	CHAR	(N' ')	Yes	TQ30	QPART	Allow NULL?
5	HERKUNFT	Inspection Lot Origin	nvarchar	2	0	CHAR	(N' ')	Yes	TQ31	QHERK	Allow NULL?
6	OBJNR	Object number	nvarchar	22	0	CHAR	(N' ')	Yes	ONR00	J_OBJNR	Allow NULL?
7	OBTYP	Object Category	nvarchar	3	0	CHAR	(N' ')	Yes	TJ03	J_OBTYP	Allow NULL?
8	STSMA	Status Profile	nvarchar	8	0	CHAR	(N' ')	Yes	TJ20	J_STSMA	Allow NULL?
9	QMATAUTH	Material Authorization Group for Activities in QM	nvarchar	6	0	CHAR	(N' ')	Yes	TQ01B	QMATAUTH	Allow NULL?
10	STAT11	GR blocked stock	char	1	0	CHAR	(N' ')	Yes		KZWES	Allow NULL?
11	INSMK	Quantity Is or Was in Inspection Stock	char	1	0	CHAR	(N' ')	Yes		QVINSMK	Allow NULL?
12	STAT01	Inspection Lot is Created Automatically	char	1	0	CHAR	(N' ')	Yes		QSTAT01	Allow NULL?
13	STAT02	Partial Lots Exist	char	1	0	CHAR	(N' ')	Yes		QKZQALT	Allow NULL?
14	STAT04	Data Record Was Changed Using Customer Exit	char	1	0	CHAR	(N' ')	Yes		QUSER_EXIT	Allow NULL?
15	STAT06	Record Appraisal Costs in Individual QM Order	char	1	0	CHAR	(N' ')	Yes		QKZPRFKOST	Allow NULL?
16	STAT07	Inspection with Inspection Points	char	1	0	CHAR	(N' ')	Yes		QKZFERTPRF	Allow NULL?
17	STAT08	Automatic Usage Decision Planned	char	1	0	CHAR	(N' ')	Yes		QAUTO_VE	Allow NULL?
18	STAT09	Source Inspection	char	1	0	CHAR	(N' ')	Yes		QABNAHMPRF	Allow NULL?
19	STAT10	Inspection Specifications from Configuration	char	1	0	CHAR	(N' ')	Yes		QCONF	Allow NULL?
20	STAT14	Completion of Short-Term Inspection	char	1	0	CHAR	(N' ')	Yes		QSTAT14	Allow NULL?
21	STAT16	Inspection Specifications from Batch Determination	char	1	0	CHAR	(N' ')	Yes		QCHARG	Allow NULL?
22	STAT18	Control of Inspection Lot Creation (Lot Summary)	char	1	0	CHAR	(N' ')	Yes		Q1WELOS	Allow NULL?
23	STAT19	Documentation Required for Inspection Lot	char	1	0	CHAR	(N' ')	Yes		QSTAT19	Allow NULL?
24	STAT20	Inspection Plan Required	char	1	0	CHAR	(N' ')	Yes		QSTAT20	Allow NULL?
25	STAT21	Enter Sample Manually	char	1	0	CHAR	(N' ')	Yes		QSTAT21	Allow NULL?
26	STAT22	Inspect with Material Specification	char	1	0	CHAR	(N' ')	Yes		QSPEZUEBER	Allow NULL?
27	STAT23	Inspection Lot Approval	char	1	0	CHAR	(N' ')	Yes		QKZGENLOS	Allow NULL?
28	STAT24	Digital Signature for Insp. Lot in Results Recording	char	1	0	CHAR	(N' ')	Yes		SIG_IL_RES	Allow NULL?
29	STAT25	Digital Signature for Insp. Lot when Usage Decision Made	char	1	0	CHAR	(N' ')	Yes		SIG_IL_USA	Allow NULL?
30	STAT29	Digital Signature for Confirmation of Phys.-Sample Drawing	char	1	0	CHAR	(N' ')	Yes		SIG_IL_SDR	Allow NULL?
31	STAT26	Indicator: Approved batch record required	char	1	0	CHAR	(N' ')	Yes		XGCHP	Allow NULL?
32	STAT27	Inspection Lot is an R/2 Inspection Lot	char	1	0	CHAR	(N' ')	Yes		QSTAT27	Allow NULL?
33	STAT28	Select Characteristics Manually	char	1	0	CHAR	(N' ')	Yes		QSTAT28	Allow NULL?
34	STAT31	Trigger Sample Calculation Manually	char	1	0	CHAR	(N' ')	Yes		QSTAT31	Allow NULL?
35	STAT34	Stock Postings Completed	char	1	0	CHAR	(N' ')	Yes		QSTAT34	Allow NULL?
36	STAT35	Usage Decision Has Been Made	char	1	0	CHAR	(N' ')	Yes		QSTAT35	Allow NULL?
37	STAT45	Material as Dynamic Modification Criterion	char	1	0	CHAR	(N' ')	Yes		QSTAT45	Allow NULL?
38	STAT46	Vendor as Dynamic Modification Criterion	char	1	0	CHAR	(N' ')	Yes		QSTAT46	Allow NULL?
39	STAT47	Manufacturer as Dynamic Modification Criterion	char	1	0	CHAR	(N' ')	Yes		QSTAT47	Allow NULL?
40	STAT48	Customer as Dynamic Modification Criterion	char	1	0	CHAR	(N' ')	Yes		QSTAT48	Allow NULL?
41	STAT49	Machine as Dynamic Modification Criterion	char	1	0	CHAR	(N' ')	Yes		QSTAT49	Allow NULL?
42	STAT50	Project as Dynamic Modification Criterion	char	1	0	CHAR	(N' ')	Yes		QSTAT50	Allow NULL?
43	KZSKIPLOT	Lot Skipped	char	1	0	CHAR	(N' ')	Yes		QKZSKIPLOT	Allow NULL?
44	DYN	Skips Allowed	char	1	0	CHAR	(N' ')	Yes		QDYN	Allow NULL?
45	HPZ	100% Inspection	char	1	0	CHAR	(N' ')	Yes		QHPZ	Allow NULL?
46	EIN	Serial Number Management Possible	char	1	0	CHAR	(N' ')	Yes		QEINZ	Allow NULL?
47	ANZSN	Number of serial numbers	int	10	0	INT4	((0))	Yes		ANZSN	Allow NULL?
48	KZDYNERF	Dynamic Modification Is Carried Out	char	1	0	CHAR	(N' ')	Yes		QKZDYNERF	Allow NULL?
49	DYNHEAD	Level at Which Dynamic Modification Parameters Are Defined	char	1	0	CHAR	(N' ')	Yes	TQ39A	QDYNHEAD	Allow NULL?
50	STPRVER	Sampling Procedure	nvarchar	8	0	CHAR	(N' ')	Yes	QDSV	QSTPRVER	Allow NULL?
51	EXTNUM	External Numbering of Units to be Inspected	char	1	0	CHAR	(N' ')	Yes	TQ12	QEXTNUM	Allow NULL?
52	STAFO	Update group for statistics update	nvarchar	6	0	CHAR	(N' ')	Yes	TMCB	STAFO	Allow NULL?
53	STAT30	Origin of Inspection Lot Unit of Measure for LIS Interface	char	1	0	CHAR	(N' ')	Yes		QUNITORIGIN	Allow NULL?
54	QINFSTATUS	QINF Status	nvarchar	8	0	CHAR	(N' ')	Yes	*	QINFSTATUS	Allow NULL?
55	ENSTEHDAT	Date of Lot Creation	nvarchar	8	0	DATS	(N'00000000')	Yes		QENTST	Allow NULL?
56	ENTSTEZEIT	Time of Lot Creation	nvarchar	6	0	TIMS	(N'000000')	Yes		QENTSTZEIT	Allow NULL?
57	ERSTELLER	Name of User Who Created the Data Record	nvarchar	12	0	CHAR	(N' ')	Yes		QERSTELLER	Allow NULL?
58	ERSTELDAT	Date on Which the Data Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		QDATUMERST	Allow NULL?
59	ERSTELZEIT	Time of Lot Creation	nvarchar	6	0	TIMS	(N'000000')	Yes		QERSTEZEIT	Allow NULL?
60	AENDERER	Name of User who Most Recently Changed the Data Record	nvarchar	12	0	CHAR	(N' ')	Yes		QAENDERER	Allow NULL?
61	AENDERDAT	Date on Which Data Record Was Changed	nvarchar	8	0	DATS	(N'00000000')	Yes		QDATUMAEND	Allow NULL?
62	AENDERZEIT	Time of Lot Change	nvarchar	6	0	TIMS	(N'000000')	Yes		QAENDEZEIT	Allow NULL?
63	PASTRTERM	Inspection Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		QPRSTART	Allow NULL?
64	PASTRZEIT	Inspection Start Time	nvarchar	6	0	TIMS	(N'000000')	Yes		QSTARTZEIT	Allow NULL?
65	PAENDTERM	End Date of the Inspection	nvarchar	8	0	DATS	(N'00000000')	Yes		QPRENDE	Allow NULL?
66	PAENDZEIT	Inspection End Time	nvarchar	6	0	TIMS	(N'000000')	Yes		QENDEZEIT	Allow NULL?
67	PLNTY	Task List Type	char	1	0	CHAR	(N' ')	Yes	TCA01	PLNTY	Allow NULL?
68	PLNNR	Key for Task List Group	nvarchar	8	0	CHAR	(N' ')	Yes		PLNNR	Allow NULL?
69	PPLVERW	Task list usage	nvarchar	3	0	CHAR	(N' ')	Yes	T411	PLN_VERWE	Allow NULL?
70	PLNAL	Group Counter	nvarchar	2	0	CHAR	(N' ')	Yes		PLNAL	Allow NULL?
71	ZAEHL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
72	ZKRIZ	Counter for additional criteria	nvarchar	7	0	NUMC	(N'0000000')	Yes		DZKRIZ	Allow NULL?
73	STAT15	Production Resource/Tool Saved for Insp. Lot	char	1	0	CHAR	(N' ')	Yes		QFHM_MODE	Allow NULL?
74	SLWBEZ	Identification for the Inspection Point Field Combination	nvarchar	3	0	CHAR	(N' ')	Yes	TQ79	QSLWBEZ	Allow NULL?
75	STAT13	Inspection Point Type	char	1	0	CHAR	(N' ')	Yes		QPPKTTYP	Allow NULL?
76	PPKZTLZU	Partial Lot Assignment in an Inspection During Production	char	1	0	CHAR	(N' ')	Yes		QPPKZTLZU	Allow NULL?
77	ZAEHL1	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
78	PRBNAVERF	Sample-Drawing Procedure	nvarchar	8	0	CHAR	(N' ')	Yes	QPRVK	QPRZIEHVER	Allow NULL?
79	PRBNAVV	Version No. of the Sample-Drawing Procedure	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNPRZV	Allow NULL?
80	STAT12	Confirmation Required for Physical-Sample Drawing	char	1	0	CHAR	(N' ')	Yes		QKZQUIT	Allow NULL?
81	SELMATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
82	SELREVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
83	SELWERK	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
84	SELLIFNR	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	ELIFN	Allow NULL?
85	STAT17	Manufacturer Part No. Processing Active	char	1	0	CHAR	(N' ')	Yes		QHERST	Allow NULL?
86	SELHERST	Number of Manufacturer	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	QLIFNR	Allow NULL?
87	SELKUNNR	Account Number of Customer	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	EKUNN	Allow NULL?
88	SELPPLVERW	Task list usage	nvarchar	3	0	CHAR	(N' ')	Yes	T411	PLN_VERWE	Allow NULL?
89	GUELTIGAB	Key Date for Selecting Records or Changing Task Lists	nvarchar	8	0	DATS	(N'00000000')	Yes		QSTICHTAG	Allow NULL?
90	AUFNR	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	AUFNR	Allow NULL?
91	AUFPL	Routing number of operations in the order	nvarchar	10	0	NUMC	(N'0000000000')	Yes		CO_AUFPL	Allow NULL?
92	CUOBJ	Configuration (internal object number)	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ	Allow NULL?
93	CUOBJ_CH	Internal object number of the batch classification	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ_CH	Allow NULL?
94	VERID	Production Version	nvarchar	4	0	CHAR	(N' ')	Yes	MKAL	VERID	Allow NULL?
95	SA_AUFNR	Run schedule header number	nvarchar	12	0	CHAR	(N' ')	Yes	SAFK	SA_AUFNR	Allow NULL?
96	KUNNR	Customer (Ship-To Party)	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	QKUNWE	Allow NULL?
97	LIFNR	Vendor Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	ELIFN	Allow NULL?
98	HERSTELLER	Number of Manufacturer	nvarchar	10	0	CHAR	(N' ')	Yes	LFA1	QLIFNR	Allow NULL?
99	EMATNR	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	EMATN	Allow NULL?
100	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
101	REVLV	Revision Level	nvarchar	2	0	CHAR	(N' ')	Yes		REVLV	Allow NULL?
102	XCHPF	Batch management requirement indicator	char	1	0	CHAR	(N' ')	Yes		XCHPF	Allow NULL?
103	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCH1	CHARG_D	Allow NULL?
104	LAGORTCHRG	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	MCHB	LGORT_D	Allow NULL?
105	ZEUGNISBIS	Valid-To Date for The Batch Certificate	nvarchar	8	0	DATS	(N'00000000')	Yes		QZEUGBIS	Allow NULL?
106	VFDAT	Shelf Life Expiration or Best-Before Date	nvarchar	8	0	DATS	(N'00000000')	Yes		VFDAT	Allow NULL?
107	LICHN	Vendor Batch Number	nvarchar	15	0	CHAR	(N' ')	Yes		LICHN	Allow NULL?
108	SOBKZ	Special Stock Indicator	char	1	0	CHAR	(N' ')	Yes	T148	SOBKZ	Allow NULL?
109	PS_PSP_PNR	Valuated Sales Order Stock WBS Element	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	MAT_PSPNR	Allow NULL?
110	KDAUF	Sales Order Number of Valuated Sales Order Stock	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	MAT_KDAUF	Allow NULL?
111	KDPOS	Sales Order Item of Valuated Sales Order Stock	nvarchar	6	0	NUMC	(N'000000')	Yes		MAT_KDPOS	Allow NULL?
112	EKORG	Purchasing Organization	nvarchar	4	0	CHAR	(N' ')	Yes	T024E	EKORG	Allow NULL?
113	EBELN	Purchasing Document Number	nvarchar	10	0	CHAR	(N' ')	Yes	EKKO	EBELN	Allow NULL?
114	EBELP	Item Number of Purchasing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	EKPO	EBELP	Allow NULL?
115	ETENR	Delivery Schedule Line Counter	nvarchar	4	0	NUMC	(N'0000')	Yes	EKET	EETEN	Allow NULL?
116	BLART	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	T003	BLART	Allow NULL?
117	MJAHR	Material Document Year	nvarchar	4	0	NUMC	(N'0000')	Yes		MJAHR	Allow NULL?
118	MBLNR	Number of Material Document	nvarchar	10	0	CHAR	(N' ')	Yes		MBLNR	Allow NULL?
119	ZEILE	Item in Material Document	nvarchar	4	0	NUMC	(N'0000')	Yes		MBLPO	Allow NULL?
120	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
121	BWART	Movement Type (Inventory Management)	nvarchar	3	0	CHAR	(N' ')	Yes	T156	BWART	Allow NULL?
122	WERKVORG	Plant Where Stock for Inspection Lot Is Held	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKVORG	Allow NULL?
123	LAGORTVORG	Storage Location for Inspection Lot Stock	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	QLGORTVORG	Allow NULL?
124	LGNUM	Warehouse Number / Warehouse Complex	nvarchar	3	0	CHAR	(N' ')	Yes	T300	LGNUM	Allow NULL?
125	LGTYP	Storage Type	nvarchar	3	0	CHAR	(N' ')	Yes	T301	LGTYP	Allow NULL?
126	LGPLA	Storage Bin	nvarchar	10	0	CHAR	(N' ')	Yes	LAGP	LGPLA	Allow NULL?
127	LS_KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	KDAUF	Allow NULL?
128	LS_KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
129	LS_VBELN	Delivery	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	VBELN_VL	Allow NULL?
130	LS_POSNR	Delivery Item	nvarchar	6	0	NUMC	(N'000000')	Yes	VBUP	POSNR_VL	Allow NULL?
131	LS_ABRVW	Delivery Category	nvarchar	3	0	CHAR	(N' ')	Yes	TVLV	QABRVW	Allow NULL?
132	LS_ROUTE	Route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	ROUTE	Allow NULL?
133	LS_LLAND	Country of Destination	nvarchar	3	0	CHAR	(N' ')	Yes	T005	LLAND	Allow NULL?
134	LS_KUNAG	Sold-to party	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	KUNAG	Allow NULL?
135	LS_VKORG	Sales Organization	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	VKORG	Allow NULL?
136	LS_KDMAT	Material belonging to the customer	nvarchar	35	0	CHAR	(N' ')	Yes		KDMAT	Allow NULL?
137	SPRACHE	Language Key	char	1	0	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
138	KTEXTLOS	Short Text	nvarchar	40	0	CHAR	(N' ')	Yes		QKURZTEXT	Allow NULL?
139	LTEXTKZ	Long Text Exists For Inspection Lot	char	1	0	CHAR	(N' ')	Yes		QLTEXTLOS	Allow NULL?
140	KTEXTMAT	Short Text for Inspection Object	nvarchar	40	0	CHAR	(N' ')	Yes		QKTEXTOBJ	Allow NULL?
141	ZUSMKZAEHL	Number of Characteristics Recorded Additionally	smallint	5	0	INT2	((0))	Yes		QZUSMKZHL
142	OFFENNLZMK	Number of Outstanding Short-Term Chars Which Require Conf.	smallint	5	0	INT2	((0))	Yes		QOFFENLZMK
143	OFFEN_LZMK	Number of Outstanding Long-Term Chars Which Require Conf.	smallint	5	0	INT2	((0))	Yes		QOFFELZMK
144	LOSMENGE	Inspection Lot Quantity	decimal	13	3	QUAN	((0))	Yes		QLOSMENGE
145	MENGENEINH	Base Unit of Measure for The Inspection Lot Quantity	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QLOSMENGEH	Allow NULL?
146	ANZGEB	QM - No. of Containers	decimal	6	3	QUAN	((0))	Yes		QANZGEB
147	GEBEH	Lot Container	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QGEBEH	Allow NULL?
148	LVS_STIKZ	Indicator: what has happened to insp.sample (QM) in WM	char	1	0	CHAR	(N' ')	Yes		LVS_STIKZ	Allow NULL?
149	LVS_STIMG	Sample in base unit of measure provided by WM	decimal	13	3	QUAN	((0))	Yes		LVS_STIMG
150	GESSTICHPR	Sample Size	decimal	13	3	QUAN	((0))	Yes		QGESTICH
151	EINHPROBE	Base Unit of Measure for the Sample Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QPROBEMGEH	Allow NULL?
152	DYNREGEL	Dynamic Modification Rule	nvarchar	3	0	CHAR	(N' ')	Yes	QDDR	QDYNREGEL	Allow NULL?
153	STAT44	Time of Dynamic Modification in Inspection Lot	char	1	0	CHAR	(N' ')	Yes		QDYNTIME	Allow NULL?
154	PRSTUFE	Inspection Stage	nvarchar	4	0	NUMC	(N'0000')	Yes	QDPS	QPRSTUFE	Allow NULL?
155	PRSCHAERFE	Inspection Severity	nvarchar	3	0	NUMC	(N'000')	Yes	QDEP	QPRSCHAERF	Allow NULL?
156	LMENGE01	Quantity Posted to Unrestricted-Use Stock	decimal	13	3	QUAN	((0))	Yes		QLMENGE01F
157	LMENGE02	Quantity Posted to Scrap	decimal	13	3	QUAN	((0))	Yes		QLMENGE02F
158	LMENGE03	Quantity Posted to Sample	decimal	13	3	QUAN	((0))	Yes		QLMENGE03F
159	LMENGE04	Quantity Posted to Blocked Stock	decimal	13	3	QUAN	((0))	Yes		QLMENGE04F
160	LMENGE05	Quantity Posted to Reserves	decimal	13	3	QUAN	((0))	Yes		QLMENGE05F
161	LMENGE06	Quantity Posted to Another Material	decimal	13	3	QUAN	((0))	Yes		QLMENGE06F
162	MATNRNEU	Material Number to Which the Quantity is Posted	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	QMATNRNEU	Allow NULL?
163	CHARGNEU	Batch to Which Goods Are Transferred	nvarchar	10	0	CHAR	(N' ')	Yes	MCH1	QCHARGNEU	Allow NULL?
164	LMENGE07	Quantity Returned to Vendor	decimal	13	3	QUAN	((0))	Yes		QLMENGE07F
165	LMENGE08	Other Quantity Posted from Inspection Lot Stock	decimal	13	3	QUAN	((0))	Yes		QLMENGE08F
166	LMENGE09	Other Quantity (2) Posted from Inspection Lot Stock	decimal	13	3	QUAN	((0))	Yes		QLMENGE09F
167	LMENGEZUB	Quantity That Must Be Posted	decimal	13	3	QUAN	((0))	Yes		QLMENGEZUB
168	LMENGELZ	Sample Quantity for Long-Term Characteristics	decimal	13	3	QUAN	((0))	Yes		QLMENGELZ
169	LMENGEPR	Quantity Actually Inspected	decimal	13	3	QUAN	((0))	Yes		QLMENGEPR
170	LMENGEZER	Quantity Destroyed During Inspection	decimal	13	3	QUAN	((0))	Yes		QLMENGEZER
171	LMENGEIST	Actual Lot Quantity	decimal	13	3	QUAN	((0))	Yes		QLMENGEIST
172	LMENGESCH	Defective Quantity in Inspected Quantity	decimal	13	3	QUAN	((0))	Yes		QLMENGESCH
173	LTEXTKZBB	Logs Exist for Usage Decision	char	1	0	CHAR	(N' ')	Yes		QLTEXTKZBB	Allow NULL?
174	ANTEIL	Share of Scrap in Inspection Lot	float	15	16	FLTP	((0))	Yes		QAUSANTEIL
175	QKZVERF	Procedure for Calculating Quality Score	nvarchar	2	0	CHAR	(N' ')	Yes	TQ06	QKZVERF	Allow NULL?
176	STAT03	Usage Decision Mmode (UD Origin)	char	1	0	CHAR	(N' ')	Yes		QMODUS_UD	Allow NULL?
177	QPMATLOS	Allowed Share of Scrap	float	15	16	FLTP	((0))	Yes		QPMATLOS
178	AUFNR_CO	Order Number for Recording Appraisal Costs	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	QAUFNR_CO	Allow NULL?
179	KZVBR	Consumption Posting	char	1	0	CHAR	(N' ')	Yes		KZVBR	Allow NULL?
180	KNTTP	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	T163K	KNTTP	Allow NULL?
181	PSTYP	Item Category in Purchasing Document	char	1	0	CHAR	(N' ')	Yes	T163	PSTYP	Allow NULL?
182	STAT05	Account Assignment Key: Inspection Lot	char	1	0	CHAR	(N' ')	Yes		QKZQALSKNT	Allow NULL?
183	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	KOSTL	Allow NULL?
184	AUFPS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	NUMC	(N'0000')	Yes		RSPOS	Allow NULL?
185	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	Yes	ANLH	ANLN1	Allow NULL?
186	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	ANLA	ANLN2	Allow NULL?
187	KONT_PSPNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_PNR	Allow NULL?
188	NPLNR	Network Number for Account Assignment	nvarchar	12	0	CHAR	(N' ')	Yes	AUFK	NPLNR	Allow NULL?
189	APLZL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
190	KONT_KDAUF	Sales Order Number	nvarchar	10	0	CHAR	(N' ')	Yes	VBUK	KDAUF	Allow NULL?
191	KONT_KDPOS	Item Number in Sales Order	nvarchar	6	0	NUMC	(N'000000')	Yes		KDPOS	Allow NULL?
192	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	CHAR	(N' ')	Yes		IMKEY	Allow NULL?
193	DABRZ	Reference Date for Settlement	nvarchar	8	0	DATS	(N'00000000')	Yes		DABRBEZ	Allow NULL?
194	KSTRG	Cost Object	nvarchar	12	0	CHAR	(N' ')	Yes	CKPH	KSTRG	Allow NULL?
195	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	NUMC	(N'0000000000')	Yes		RKEOBJNR	Allow NULL?
196	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PRCTR	Allow NULL?
197	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
198	KONTO	G/L Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	SKA1	SAKNR	Allow NULL?
199	KOKRS	Controlling Area	nvarchar	4	0	CHAR	(N' ')	Yes	TKA01	KOKRS	Allow NULL?
200	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
201	SERNP	Serial Number Profile	nvarchar	4	0	CHAR	(N' ')	Yes	T377P	SERAIL	Allow NULL?
202	LOS_REF	Inspection Lot Number Which Is Referenced	nvarchar	12	0	NUMC	(N'000000000000')	Yes	QALS	QLOS_REF	Allow NULL?
203	BEARBSTATU	Field Not Used as of 3.0 Field Reserved for SAP	nvarchar	2	0	CHAR	(N' ')	Yes		Q_UNUSED02	Allow NULL?
204	STAT32	Inspection lot for stability study	char	1	0	CHAR	(N' ')	Yes		QSTABI	Allow NULL?
205	STAT33	Indicator: Multiple Specifications	char	1	0	CHAR	(N' ')	Yes		Q_MS_FLG	Allow NULL?
206	STAT36	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
207	STAT37	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
208	STAT38	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
209	STAT39	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
210	STAT40	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
211	STAT41	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
212	STAT42	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
213	STAT43	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
214	MENGU	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
215	KZPZADR	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
216	KZPRADR	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
217	ZUSCH	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
218	ZUSTD	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
219	KZERSTLIEF	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
220	KZERSTMUST	Field Not Used as of 3.0 Field Reserved for SAP	char	1	0	CHAR	(N' ')	Yes		Q_UNUSED01	Allow NULL?
221	ADDON_DUMMY	Dummy Field for ADDON Structures in QM	char	1	0	CHAR	(N' ')	Yes		QDUMMY	Allow NULL?
222	WARPL	Maintenance Plan	nvarchar	12	0	CHAR	(N' ')	Yes	MPLA	WARPL	Allow NULL?
223	WAPOS	Maintenance item	nvarchar	16	0	CHAR	(N' ')	Yes		WAPOS	Allow NULL?
224	ABNUM	Maintenance Plan Call Number	int	10	0	INT4	((0))	Yes		ABNUM	Allow NULL?
225	STRAT	Maintenance strategy	nvarchar	6	0	CHAR	(N' ')	Yes	T351	STRAT	Allow NULL?
226	TRIALID	Trial Number	nvarchar	12	0	CHAR	(N' ')	Yes		RMXTE_TRIALID	Allow NULL?
227	RESPONSIBLE	Responsible	nvarchar	45	0	CHAR	(N' ')	Yes		ESEREALO	Allow NULL?
228	INSP_DOC_NUMBER	Inspection Document Number from External System	nvarchar	30	0	CHAR	(N' ')	Yes		QINSP_DOC_NUMBER	Allow NULL?
229	LOG_SYSTEM	Logical system	nvarchar	10	0	CHAR	(N' ')	Yes	*	LOGSYS	Allow NULL?
230	GESSTICHPR_EXT	Sample Size from External System	decimal	13	3	QUAN	((0))	Yes		QGESTICH_EXT
231	EINHPROBE_EXT	Unit of Measure of External Sample	nvarchar	3	0	UNIT	(N' ')	Yes	*	QPROBEMGEH_EXT	Allow NULL?
232	PRIO_PUNKTE	Priority Points	int	10	0	INT4	((0))	Yes		QPRIO_PUNKTE	Allow NULL?
233	SIGN_TYPE_RR	Signature Type: Inspection Lot Results Recording	char	1	0	CHAR	(N' ')	Yes		SIGN_TYPE_RR	Allow NULL?
234	SIGN_TYPE_UD	Signature Type: Inspection Lot Usage Decision	char	1	0	CHAR	(N' ')	Yes		SIGN_TYPE_UD	Allow NULL?
235	SIGN_TYPE_SM	Signature Type: Physical-Sample Drawing	char	1	0	CHAR	(N' ')	Yes		SIGN_TYPE_SM	Allow NULL?
236	SIGNSTRAT_RR	Signature Strategy: Inspection Lot Results Recording	nvarchar	8	0	CHAR	(N' ')	Yes	*	SIGNSTRAT_RR	Allow NULL?
237	SIGNSTRAT_UD	Signature Strategy with Individual Signature: Usage Decision	nvarchar	8	0	CHAR	(N' ')	Yes	*	SIGNSTRAT_UD	Allow NULL?
238	SIGNSTRAT_SM	Signature Strategy w. Ind.Signature: Physical-Sample Drawing	nvarchar	8	0	CHAR	(N' ')	Yes	*	SIGNSTRAT_SM	Allow NULL?

TOP ERP 6.0 | QALS INDEXES

Name	Primary	Unique	Type	Columns
QALS~0	Yes	Yes	CLUSTERED	PRUEFLOS, MANDANT
QALS~A	No	No	NONCLUSTERED	MATNR, HERKUNFT, ENSTEHDAT, MANDANT
QALS~C	No	No	NONCLUSTERED	KUNNR, LIFNR, MANDANT
QALS~D	No	No	NONCLUSTERED	HERKUNFT, STAT34, WERK, MATNR, MANDANT
QALS~E	No	No	NONCLUSTERED	HERKUNFT, WERK, STAT35, MANDANT
QALS~F	No	No	NONCLUSTERED	MATNR, CHARG, MANDANT
QALS~H	No	No	NONCLUSTERED	MJAHR, ZEILE, MBLNR, MANDANT
QALS~I	No	No	NONCLUSTERED	AUFNR, LS_VBELN, MANDANT
QALS~K	No	No	NONCLUSTERED	EBELN, MANDANT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

238 COLUMNS | 9 INDEXES | ERP 6.0 | QALS TABLE

TOP ERP 6.0 | QALS COLUMNS

TOP ERP 6.0 | QALS INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

238 COLUMNS | 9 INDEXES | ERP 6.0 | QALS TABLE

TOPERP 6.0 | QALS COLUMNS

TOPERP 6.0 | QALS INDEXES

TOP ERP 6.0 | QALS COLUMNS

TOP ERP 6.0 | QALS INDEXES