SAP ABAP Table QALS (Inspection lot record)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QL (Package) QM inspection lots

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QALS	Table Relationship Diagram
Short Description	Inspection lot record

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QALS	ANLN1	ANLH	ANLN1	REF	C	CN
2	QALS	ANLN2	ANLA	ANLN2	REF	C	CN
3	QALS	ART	TQ30	ART	KEY	1	CN
4	QALS	AUFNR	AUFK	AUFNR	REF	C	CN
5	QALS	AUFNR_CO	AUFK	AUFNR	REF	C	CN
6	QALS	BLART	T003	BLART	REF	C	CN
7	QALS	BUKRS	T001	BUKRS	REF	C	CN
8	QALS	BWART	T156	BWART	REF	C	CN
9	QALS	CHARG	MCH1	CHARG	REF	C	CN
10	QALS	CHARGNEU	MCH1	CHARG	REF	C	CN
11	QALS	DYNHEAD	TQ39A	DYNLEVEL	REF	C	CN
12	QALS	DYNREGEL	QDDR	DYNREGEL	REF	C	CN
13	QALS	EBELN	EKKO	EBELN	REF	C	CN
14	QALS	EBELP	EKPO	EBELP	REF	C	CN
15	QALS	EINHPROBE	T006	MSEHI	REF	C	CN
16	QALS	EKORG	T024E	EKORG	REF	C	CN
17	QALS	EMATNR	MARA	MATNR
18	QALS	ETENR	EKET	ETENR	REF
19	QALS	EXTNUM	TQ12	EXTNUM	REF	C	CN
20	QALS	GEBEH	T006	MSEHI	REF	C	CN
21	QALS	GSBER	TGSB	GSBER	REF	C	CN
22	QALS	HERKUNFT	TQ31	HERKUNFT	KEY	1	CN
23	QALS	HERSTELLER	LFA1	LIFNR	REF	C	CN
24	QALS	KDAUF	VBUK	VBELN	REF	C	CN
25	QALS	KNTTP	T163K	KNTTP	REF	C	CN
26	QALS	KOKRS	TKA01	KOKRS	REF	C	CN
27	QALS	KONTO	SKA1	SAKNR	REF	C	CN
28	QALS	KONT_KDAUF	VBUK	VBELN	REF	C	CN
29	QALS	KONT_PSPNR	PRPS	PSPNR	REF	C	CN
30	QALS	KOSTL	CSKS	KOSTL	REF	C	CN
31	QALS	KSTRG	CKPH	KSTRG	REF	C	CN
32	QALS	KUNNR	KNA1	KUNNR	REF	C	CN
33	QALS	LAGORTCHRG	MCHB	LGORT	REF	C	CN
34	QALS	LAGORTVORG	T001L	LGORT	REF	C	CN
35	QALS	LGNUM	T300	LGNUM	REF	C	CN
36	QALS	LGPLA	LAGP	LGPLA	REF	C	CN
37	QALS	LGTYP	T301	LGTYP	REF	C	CN
38	QALS	LIFNR	LFA1	LIFNR	REF	C	CN
39	QALS	LOS_REF	QALS	PRUEFLOS	REF	C	CN
40	QALS	LS_ABRVW	TVLV	ABRVW	REF	C	CN
41	QALS	LS_KDAUF	VBUK	VBELN	REF	C	CN
42	QALS	LS_KUNAG	KNA1	KUNNR	REF	C	CN
43	QALS	LS_LLAND	T005	LAND1	REF	C	CN
44	QALS	LS_POSNR	VBUP	POSNR	REF	C	CN
45	QALS	LS_ROUTE	TVRO	ROUTE	REF	C	CN
46	QALS	LS_VBELN	VBUK	VBELN	REF	C	CN
47	QALS	LS_VKORG	TVKO	VKORG	REF	C	CN
48	QALS	MANDANT	T000	MANDT	KEY	1	CN
49	QALS	MATNR	MARA	MATNR	REF	C	CN
50	QALS	MATNRNEU	MARA	MATNR	REF	C	CN
51	QALS	MENGENEINH	T006	MSEHI	REF	C	CN
52	QALS	NPLNR	AUFK	AUFNR	REF	C	CN
53	QALS	OBJNR	ONR00	OBJNR	KEY	1	C
54	QALS	OBTYP	TJ03	OBTYP	KEY	1	CN
55	QALS	PLNTY	TCA01	PLNTY	REF	C	CN
56	QALS	PPLVERW	T411	VERWE	REF	C	CN
57	QALS	PRBNAVERF	QPRVK	PRZIEHVERF	KEY	C	CN
58	QALS	PRCTR	CEPC	PRCTR	REF	C	CN
59	QALS	PRSCHAERFE	QDEP	PRSCHAERFE	REF	C	CN
60	QALS	PRSTUFE	QDPS	PRSTUFE	REF	C	CN
61	QALS	PSTYP	T163	PSTYP	REF	C	CN
62	QALS	PS_PSP_PNR	PRPS	PSPNR	REF	C	CN
63	QALS	QKZVERF	TQ06	QKZVERF	REF	C	CN
64	QALS	QMATAUTH	TQ01B	QMATAUTH	REF	C	CN
65	QALS	SA_AUFNR	SAFK	AUFNR
66	QALS	SELHERST	LFA1	LIFNR	REF	C	CN
67	QALS	SELKUNNR	KNA1	KUNNR	REF	C	CN
68	QALS	SELLIFNR	LFA1	LIFNR	REF	C	CN
69	QALS	SELMATNR	MARA	MATNR	REF	C	CN
70	QALS	SELPPLVERW	T411	VERWE	REF	C	CN
71	QALS	SELWERK	T001W	WERKS	REF	C	CN
72	QALS	SERNP	T377P	SERAIL	REF	C	CN
73	QALS	SLWBEZ	TQ79	SLWBEZ		C	CN
74	QALS	SOBKZ	T148	SOBKZ	REF	C	CN
75	QALS	SPRACHE	T002	SPRAS	REF	C	CN
76	QALS	STAFO	TMCB	STAFO	REF	C	CN
77	QALS	STPRVER	QDSV	STICHPRVER	REF	C	CN
78	QALS	STRAT	T351	STRAT	REF	C	CN
79	QALS	STSMA	TJ20	STSMA	REF	C	CN
80	QALS	VERID	MKAL	VERID
81	QALS	WARPL	MPLA	WARPL	REF	C	CN
82	QALS	WERK	T001W	WERKS	KEY	1	CN
83	QALS	WERKVORG	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in