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