SAP ABAP Table MCPLOS (Communication R/2 - R/3 link for inspection lot)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG02 (Package) QM quality information system

Basic Data

Table Category	INTTAB	Structure
Structure	MCPLOS	Table Relationship Diagram
Short Description	Communication R/2 - R/3 link for inspection lot

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in