1. Home
  2. Resources
  3. SAP Tables
  4. QALS - Inspection lot record

SAP Table QALS

Inspection lot record

QALS (Inspection lot record) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link QALS to other SAP tables.

Source: QALS (Inspection lot record)

QALS table fields

Field Data element Checktable Datatype Length Decimals
MANDANT Client MANDT T000 CLNT 3 0
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
WERK Plant WERKS_D T001W CHAR 4 0
ART Inspection Type QPART TQ30 CHAR 8 0
HERKUNFT Inspection Lot Origin QHERK TQ31 CHAR 2 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
OBTYP Object Category J_OBTYP TJ03 CHAR 3 0
STSMA Status Profile J_STSMA TJ20 CHAR 8 0
QMATAUTH Material Authorization Group for Activities in QM QMATAUTH TQ01B CHAR 6 0
STAT11 GR blocked stock KZWES CHAR 1 0
INSMK Quantity Is or Was in Inspection Stock QVINSMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT01 Inspection Lot is Created Automatically QSTAT01 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT02 Partial Lots Exist QKZQALT CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT04 Data Record Was Changed Using Customer Exit QUSER_EXIT CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT06 Record Appraisal Costs in Individual QM Order QKZPRFKOST CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT07 Inspection with Inspection Points QKZFERTPRF CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT08 Automatic Usage Decision Planned QAUTO_VE CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT09 Source Inspection QABNAHMPRF CHAR 1 0
A Request for quotation
B Purchase requisition
F Purchase order
I Info record
K Contract
L Scheduling agreement
Q Service entry sheet
W Source list
STAT10 Inspection Specifications from Configuration QCONF CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT14 Completion of Short-Term Inspection QSTAT14 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT16 Inspection Specifications from Batch Determination QCHARG CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT18 Control of Inspection Lot Creation (Lot Summary) Q1WELOS CHAR 1 0
NULL An inspection lot for each document item
X An insp. lot per purch. order item, or order item and batch
Y Early lot creation for the order item
1 An insp. lot per material document, material and batch
2 An inspection lot for each material and batch
3 One Inspection Lot for Each Batch Split Item
STAT19 Documentation Required for Inspection Lot QSTAT19 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT20 Inspection Plan Required QSTAT20 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT21 Enter Sample Manually QSTAT21 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT22 Inspect with Material Specification QSPEZUEBER CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT23 Inspection Lot Approval QKZGENLOS CHAR 1 0
NULL Approval not required
1 automatic approval despite mat. specification
2 no automatic approval for insp. with mat. specification
STAT24 Digital Signature for Insp. Lot in Results Recording SIG_IL_RES CHAR 1 0
NULL not required
1 Required for Results Recording
2 Required for Results Recording 'New' Digital Signature
STAT25 Digital Signature for Insp. Lot when Usage Decision Made SIG_IL_USA CHAR 1 0
NULL not required
1 required for making the usage decision
2 Required for Making the Usage Decision New Digital Signature
STAT29 Digital Signature for Confirmation of Phys.-Sample Drawing SIG_IL_SDR CHAR 1 0
NULL not required
1 required for confirmation of physical-sample drawing
2 Req. for Conf. of Physical-Sample Drawing 'New' Digital Sig.
STAT26 Indicator: Approved batch record required XGCHP CHAR 1 0
X Yes
NULL No
STAT27 Inspection Lot is an R/2 Inspection Lot QSTAT27 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT28 Select Characteristics Manually QSTAT28 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT31 Trigger Sample Calculation Manually QSTAT31 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT34 Stock Postings Completed QSTAT34 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT35 Usage Decision Has Been Made QSTAT35 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT45 Material as Dynamic Modification Criterion QSTAT45 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT46 Vendor as Dynamic Modification Criterion QSTAT46 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT47 Manufacturer as Dynamic Modification Criterion QSTAT47 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT48 Customer as Dynamic Modification Criterion QSTAT48 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT49 Machine as Dynamic Modification Criterion QSTAT49 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT50 Project as Dynamic Modification Criterion QSTAT50 CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZSKIPLOT Lot Skipped QKZSKIPLOT CHAR 1 0
NULL Indicator is not set
X Indicator is set
DYN Skips Allowed QDYN CHAR 1 0
NULL Indicator is not set
X Indicator is set
HPZ 100% Inspection QHPZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
EIN Serial Number Management Possible QEINZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANZSN Number of serial numbers ANZSN INT4 10 0
KZDYNERF Dynamic Modification Is Carried Out QKZDYNERF CHAR 1 0
NULL Indicator is not set
X Indicator is set
DYNHEAD Level at Which Dynamic Modification Parameters Are Defined QDYNHEAD TQ39A CHAR 1 0
STPRVER Sampling Procedure QSTPRVER QDSV CHAR 8 0
EXTNUM External Numbering of Units to be Inspected QEXTNUM TQ12 CHAR 1 0
STAFO Update group for statistics update STAFO TMCB CHAR 6 0
STAT30 Origin of Inspection Lot Unit of Measure for LIS Interface QUNITORIGIN CHAR 1 0
1 Base unit of measure for the material
9 Deviating base unit of measure
NULL Not defined
2 Equipment/functional location
QINFSTATUS QINF Status QINFSTATUS CHAR 8 0
ENSTEHDAT Date of Lot Creation QENTST DATS 8 0
ENTSTEZEIT Time of Lot Creation QENTSTZEIT TIMS 6 0
ERSTELLER Name of User Who Created the Data Record QERSTELLER CHAR 12 0
ERSTELDAT Date on Which the Data Record Was Created QDATUMERST DATS 8 0
ERSTELZEIT Time of Lot Creation QERSTEZEIT TIMS 6 0
AENDERER Name of User who Most Recently Changed the Data Record QAENDERER CHAR 12 0
AENDERDAT Date on Which Data Record Was Changed QDATUMAEND DATS 8 0
AENDERZEIT Time of Lot Change QAENDEZEIT TIMS 6 0
PASTRTERM Inspection Start Date QPRSTART DATS 8 0
PASTRZEIT Inspection Start Time QSTARTZEIT TIMS 6 0
PAENDTERM End Date of the Inspection QPRENDE DATS 8 0
PAENDZEIT Inspection End Time QENDEZEIT TIMS 6 0
PLNTY Task List Type PLNTY TCA01 CHAR 1 0
PLNNR Key for Task List Group PLNNR CHAR 8 0
PPLVERW Task list usage PLN_VERWE T411 CHAR 3 0
PLNAL Group Counter PLNAL CHAR 2 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
ZKRIZ Counter for additional criteria DZKRIZ NUMC 7 0
STAT15 Production Resource/Tool Saved for Insp. Lot QFHM_MODE CHAR 1 0
NULL Indicator is not set
X Indicator is set
SLWBEZ Identification for the Inspection Point Field Combination QSLWBEZ TQ79 CHAR 3 0
STAT13 Inspection Point Type QPPKTTYP CHAR 1 0
NULL Freely-defined inspection point
1 Inspection point for equipment
2 Inspection point for funct. location
3 Inspection point for phys. sample
PPKZTLZU Partial Lot Assignment in an Inspection During Production QPPKZTLZU CHAR 1 0
NULL Partial lot assignment according to plant default values
0 Partial lots not supported
1 Partial lot for each inspection point
2 Partial lot and batch for each insp. point
3 Partial lot for inspection points of 'last' inspection oper.
4 Partial lot and batch for insp. points of 'last' operation
ZAEHL1 Internal counter CIM_COUNT NUMC 8 0
PRBNAVERF Sample-Drawing Procedure QPRZIEHVER QPRVK CHAR 8 0
PRBNAVV Version No. of the Sample-Drawing Procedure QVERSNPRZV CHAR 6 0
STAT12 Confirmation Required for Physical-Sample Drawing QKZQUIT CHAR 1 0
NULL Indicator is not set
X Indicator is set
SELMATNR Material Number MATNR MARA CHAR 18 0
SELREVLV Revision Level REVLV CHAR 2 0
SELWERK Plant WERKS_D T001W CHAR 4 0
SELLIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
STAT17 Manufacturer Part No. Processing Active QHERST CHAR 1 0
NULL Indicator is not set
X Indicator is set
SELHERST Number of Manufacturer QLIFNR LFA1 CHAR 10 0
SELKUNNR Account Number of Customer EKUNN KNA1 CHAR 10 0
SELPPLVERW Task list usage PLN_VERWE T411 CHAR 3 0
GUELTIGAB Key Date for Selecting Records or Changing Task Lists QSTICHTAG DATS 8 0
AUFNR Order Number AUFNR AUFK CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
CUOBJ_CH Internal object number of the batch classification CUOBJ_CH NUMC 18 0
VERID Production Version VERID MKAL CHAR 4 0
SA_AUFNR Run schedule header number SA_AUFNR SAFK CHAR 12 0
KUNNR Customer (Ship-To Party) QKUNWE KNA1 CHAR 10 0
LIFNR Vendor Account Number ELIFN LFA1 CHAR 10 0
HERSTELLER Number of Manufacturer QLIFNR LFA1 CHAR 10 0
EMATNR Material Number Corresponding to Manufacturer Part Number EMATN MARA CHAR 18 0
MATNR Material Number MATNR MARA CHAR 18 0
REVLV Revision Level REVLV CHAR 2 0
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
CHARG Batch Number CHARG_D MCH1 CHAR 10 0
LAGORTCHRG Storage Location LGORT_D MCHB CHAR 4 0
ZEUGNISBIS Valid-To Date for The Batch Certificate QZEUGBIS DATS 8 0
VFDAT Shelf Life Expiration or Best-Before Date VFDAT DATS 8 0
LICHN Vendor Batch Number LICHN CHAR 15 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
PS_PSP_PNR Valuated Sales Order Stock WBS Element MAT_PSPNR PRPS NUMC 8 0
KDAUF Sales Order Number of Valuated Sales Order Stock MAT_KDAUF VBUK CHAR 10 0
KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP Item Number of Purchasing Document EBELP EKPO NUMC 5 0
ETENR Delivery Schedule Line Counter EETEN EKET NUMC 4 0
BLART Document Type BLART T003 CHAR 2 0
MJAHR Material Document Year MJAHR NUMC 4 0
MBLNR Number of Material Document MBLNR CHAR 10 0
ZEILE Item in Material Document MBLPO NUMC 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
WERKVORG Plant Where Stock for Inspection Lot Is Held QWERKVORG T001W CHAR 4 0
LAGORTVORG Storage Location for Inspection Lot Stock QLGORTVORG T001L CHAR 4 0
LGNUM Warehouse Number / Warehouse Complex LGNUM T300 CHAR 3 0
LGTYP Storage Type LGTYP T301 CHAR 3 0
LGPLA Storage Bin LGPLA LAGP CHAR 10 0
LS_KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
LS_KDPOS Item Number in Sales Order KDPOS NUMC 6 0
LS_VBELN Delivery VBELN_VL VBUK CHAR 10 0
LS_POSNR Delivery Item POSNR_VL VBUP NUMC 6 0
LS_ABRVW Delivery Category QABRVW TVLV CHAR 3 0
LS_ROUTE Route ROUTE TVRO CHAR 6 0
LS_LLAND Country of Destination LLAND T005 CHAR 3 0
LS_KUNAG Sold-to party KUNAG KNA1 CHAR 10 0
LS_VKORG Sales Organization VKORG TVKO CHAR 4 0
LS_KDMAT Material belonging to the customer KDMAT CHAR 35 0
SPRACHE Language Key SPRAS T002 LANG 1 0
KTEXTLOS Short Text QKURZTEXT CHAR 40 0
LTEXTKZ Long Text Exists For Inspection Lot QLTEXTLOS CHAR 1 0
NULL Indicator is not set
X Indicator is set
KTEXTMAT Short Text for Inspection Object QKTEXTOBJ CHAR 40 0
ZUSMKZAEHL Number of Characteristics Recorded Additionally QZUSMKZHL INT2 5 0
OFFENNLZMK Number of Outstanding Short-Term Chars Which Require Conf. QOFFENLZMK INT2 5 0
OFFEN_LZMK Number of Outstanding Long-Term Chars Which Require Conf. QOFFELZMK INT2 5 0
LOSMENGE Inspection Lot Quantity QLOSMENGE QUAN 13 3
MENGENEINH Base Unit of Measure for The Inspection Lot Quantity QLOSMENGEH T006 UNIT 3 0
ANZGEB QM - No. of Containers QANZGEB QUAN 6 3
GEBEH Lot Container QGEBEH T006 UNIT 3 0
LVS_STIKZ Indicator: what has happened to insp.sample (QM) in WM LVS_STIKZ CHAR 1 0
NULL Still no activity in WM for inspection sample
1 Inspection sample in WM transferred to sample storage bin
2 Inspection sample in WM left in GR area
3 Insp.sample in WM ignored; quantity in unknown storage bin
LVS_STIMG Sample in base unit of measure provided by WM LVS_STIMG QUAN 13 3
GESSTICHPR Sample Size QGESTICH QUAN 13 3
EINHPROBE Base Unit of Measure for the Sample Unit QPROBEMGEH T006 UNIT 3 0
DYNREGEL Dynamic Modification Rule QDYNREGEL QDDR CHAR 3 0
STAT44 Time of Dynamic Modification in Inspection Lot QDYNTIME CHAR 1 0
NULL 3.0 lot -> Determine time of dyn. modif. from dyn. mod. rule
1 Dynamic modification at the usage decision
X Dynamic modification at lot creation
PRSTUFE Inspection Stage QPRSTUFE QDPS NUMC 4 0
PRSCHAERFE Inspection Severity QPRSCHAERF QDEP NUMC 3 0
LMENGE01 Quantity Posted to Unrestricted-Use Stock QLMENGE01F QUAN 13 3
LMENGE02 Quantity Posted to Scrap QLMENGE02F QUAN 13 3
LMENGE03 Quantity Posted to Sample QLMENGE03F QUAN 13 3
LMENGE04 Quantity Posted to Blocked Stock QLMENGE04F QUAN 13 3
LMENGE05 Quantity Posted to Reserves QLMENGE05F QUAN 13 3
LMENGE06 Quantity Posted to Another Material QLMENGE06F QUAN 13 3
MATNRNEU Material Number to Which the Quantity is Posted QMATNRNEU MARA CHAR 18 0
CHARGNEU Batch to Which Goods Are Transferred QCHARGNEU MCH1 CHAR 10 0
LMENGE07 Quantity Returned to Vendor QLMENGE07F QUAN 13 3
LMENGE08 Other Quantity Posted from Inspection Lot Stock QLMENGE08F QUAN 13 3
LMENGE09 Other Quantity (2) Posted from Inspection Lot Stock QLMENGE09F QUAN 13 3
LMENGEZUB Quantity That Must Be Posted QLMENGEZUB QUAN 13 3
LMENGELZ Sample Quantity for Long-Term Characteristics QLMENGELZ QUAN 13 3
LMENGEPR Quantity Actually Inspected QLMENGEPR QUAN 13 3
LMENGEZER Quantity Destroyed During Inspection QLMENGEZER QUAN 13 3
LMENGEIST Actual Lot Quantity QLMENGEIST QUAN 13 3
LMENGESCH Defective Quantity in Inspected Quantity QLMENGESCH QUAN 13 3
LTEXTKZBB Logs Exist for Usage Decision QLTEXTKZBB CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANTEIL Share of Scrap in Inspection Lot QAUSANTEIL FLTP 16 16
QKZVERF Procedure for Calculating Quality Score QKZVERF TQ06 CHAR 2 0
STAT03 Usage Decision Mmode (UD Origin) QMODUS_UD CHAR 1 0
A UD using QM-IDI (interface)
B Automatic UD (job planning)
C Worklist (lists)
D UD using BAPI
E Other UD mode
QPMATLOS Allowed Share of Scrap QPMATLOS FLTP 16 16
AUFNR_CO Order Number for Recording Appraisal Costs QAUFNR_CO AUFK CHAR 12 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
PSTYP Item Category in Purchasing Document PSTYP T163 CHAR 1 0
STAT05 Account Assignment Key: Inspection Lot QKZQALSKNT CHAR 1 0
A Cost center
B Order
C Project
D Cost object
E Network
F Real est.
G Sales order
H Profitability segment
I Fixed asset
J Reconciliation object
K Repetitive manufacturing
KOSTL Cost Center KOSTL CSKS CHAR 10 0
AUFPS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
ANLN1 Main Asset Number ANLN1 ANLH CHAR 12 0
ANLN2 Asset Subnumber ANLN2 ANLA CHAR 4 0
KONT_PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR AUFK CHAR 12 0
APLZL Internal counter CIM_COUNT NUMC 8 0
KONT_KDAUF Sales Order Number KDAUF VBUK CHAR 10 0
KONT_KDPOS Item Number in Sales Order KDPOS NUMC 6 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
KSTRG Cost Object KSTRG CKPH CHAR 12 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PRCTR Profit Center PRCTR CEPC CHAR 10 0
GSBER Business Area GSBER TGSB CHAR 4 0
KONTO G/L Account Number SAKNR SKA1 CHAR 10 0
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
BUKRS Company Code BUKRS T001 CHAR 4 0
SERNP Serial Number Profile SERAIL T377P CHAR 4 0
LOS_REF Inspection Lot Number Which Is Referenced QLOS_REF QALS NUMC 12 0
BEARBSTATU Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED02 CHAR 2 0
STAT32 Inspection lot for stability study QSTABI CHAR 1 0
NULL No inspection lot for stability study
1 Initial inspection
2 Inspection lot for storage condition (created automatically)
3 Inspection lot for storage condition (created manually)
STAT33 Indicator: Multiple Specifications Q_MS_FLG CHAR 1 0
NULL Insp. Plan/Assignment for Dependent Char. Specifications
X Inspection Plan/Assignment for Multiple Specifications
STAT36 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
STAT37 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
STAT38 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
STAT39 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
STAT40 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
STAT41 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
STAT42 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
STAT43 Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
MENGU Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
KZPZADR Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
KZPRADR Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
ZUSCH Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
ZUSTD Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
KZERSTLIEF Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
KZERSTMUST Field Not Used as of 3.0 Field Reserved for SAP Q_UNUSED01 CHAR 1 0
ADDON_DUMMY Dummy Field for ADDON Structures in QM QDUMMY CHAR 1 0
WARPL Maintenance Plan WARPL MPLA CHAR 12 0
WAPOS Maintenance item WAPOS CHAR 16 0
ABNUM Maintenance Plan Call Number ABNUM INT4 10 0
STRAT Maintenance strategy STRAT T351 CHAR 6 0
TRIALID Trial Number RMXTE_TRIALID CHAR 12 0
RESPONSIBLE Responsible ESEREALO CHAR 45 0
INSP_DOC_NUMBER Inspection Document Number from External System QINSP_DOC_NUMBER CHAR 30 0
LOG_SYSTEM Logical system LOGSYS CHAR 10 0
GESSTICHPR_EXT Sample Size from External System QGESTICH_EXT QUAN 13 3
EINHPROBE_EXT Unit of Measure of External Sample QPROBEMGEH_EXT UNIT 3 0
PRIO_PUNKTE Priority Points QPRIO_PUNKTE INT4 10 0
SIGN_TYPE_RR Signature Type: Inspection Lot Results Recording SIGN_TYPE_RR CHAR 1 0
A Asynchronous Signature Process
B Asynchronous Signature Process with Changeable Signatory
C Synchronous Signature Process
SIGN_TYPE_UD Signature Type: Inspection Lot Usage Decision SIGN_TYPE_UD CHAR 1 0
A Signature Strategy - Signatory Cannot Be Changed
B Signature Strategy - Signatory Can Be Changed
SIGN_TYPE_SM Signature Type: Physical-Sample Drawing SIGN_TYPE_SM CHAR 1 0
A Signature Strategy - Signatory Cannot Be Changed
B Signature Strategy - Signatory Can Be Changed
SIGNSTRAT_RR Signature Strategy: Inspection Lot Results Recording SIGNSTRAT_RR CHAR 8 0
SIGNSTRAT_UD Signature Strategy with Individual Signature: Usage Decision SIGNSTRAT_UD CHAR 8 0
SIGNSTRAT_SM Signature Strategy w. Ind.Signature: Physical-Sample Drawing SIGNSTRAT_SM CHAR 8 0

QALS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QALS ANLN1 QALS MANDANT ANLH Main asset number MANDT
QALS ANLN1 QALS BUKRS ANLH Main asset number BUKRS
QALS ANLN1 QALS ANLN1 ANLH Main asset number ANLN1
QALS ANLN2 QALS MANDANT ANLA Asset Master Record Segment MANDT
QALS ANLN2 QALS BUKRS ANLA Asset Master Record Segment BUKRS
QALS ANLN2 QALS ANLN1 ANLA Asset Master Record Segment ANLN1
QALS ANLN2 QALS ANLN2 ANLA Asset Master Record Segment ANLN2
QALS ART QALS MANDANT TQ30 Inspection types MANDT
QALS ART QALS ART TQ30 Inspection types ART
QALS AUFNR QALS MANDANT AUFK Order master data MANDT
QALS AUFNR QALS AUFNR AUFK Order master data AUFNR
QALS AUFNR_CO QALS MANDANT AUFK Order master data MANDT
QALS AUFNR_CO QALS AUFNR_CO AUFK Order master data AUFNR
QALS BLART QALS MANDANT T003 Document Types MANDT
QALS BLART QALS BLART T003 Document Types BLART
QALS BUKRS QALS MANDANT T001 Company Codes MANDT
QALS BUKRS QALS BUKRS T001 Company Codes BUKRS
QALS BWART QALS MANDANT T156 Movement Type MANDT
QALS BWART QALS BWART T156 Movement Type BWART
QALS CHARG QALS MANDANT MCH1 Batches (if Batch Management Cross-Plant) MANDT
QALS CHARG QALS MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
QALS CHARG QALS CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
QALS CHARGNEU QALS MANDANT MCH1 Batches (if Batch Management Cross-Plant) MANDT
QALS CHARGNEU QALS MATNRNEU MCH1 Batches (if Batch Management Cross-Plant) MATNR
QALS CHARGNEU QALS CHARGNEU MCH1 Batches (if Batch Management Cross-Plant) CHARG
QALS DYNHEAD QALS DYNHEAD TQ39A Definition of dynamic modification level DYNLEVEL
QALS DYNREGEL QALS MANDANT QDDR Dynamic modification rule (header) MANDT
QALS DYNREGEL QALS DYNREGEL QDDR Dynamic modification rule (header) DYNREGEL
QALS EBELN QALS MANDANT EKKO Purchasing Document Header MANDT
QALS EBELN QALS EBELN EKKO Purchasing Document Header EBELN
QALS EBELP QALS MANDANT EKPO Purchasing Document Item MANDT
QALS EBELP QALS EBELN EKPO Purchasing Document Item EBELN
QALS EBELP QALS EBELP EKPO Purchasing Document Item EBELP
QALS EINHPROBE QALS MANDANT T006 Units of Measurement MANDT
QALS EINHPROBE QALS EINHPROBE T006 Units of Measurement MSEHI
QALS EKORG QALS MANDANT T024E Purchasing Organizations MANDT
QALS EKORG QALS EKORG T024E Purchasing Organizations EKORG
QALS EMATNR QALS MANDANT MARA General Material Data MANDT
QALS EMATNR QALS EMATNR MARA General Material Data MATNR
QALS ETENR QALS MANDANT EKET Scheduling Agreement Schedule Lines MANDT
QALS ETENR QALS EBELN EKET Scheduling Agreement Schedule Lines EBELN
QALS ETENR QALS EBELP EKET Scheduling Agreement Schedule Lines EBELP
QALS ETENR QALS ETENR EKET Scheduling Agreement Schedule Lines ETENR
QALS EXTNUM QALS MANDANT TQ12 Ind. external numbering for test units in results recording MANDT
QALS EXTNUM QALS EXTNUM TQ12 Ind. external numbering for test units in results recording EXTNUM
QALS GEBEH QALS MANDANT T006 Units of Measurement MANDT
QALS GEBEH QALS GEBEH T006 Units of Measurement MSEHI
QALS GSBER QALS MANDANT TGSB Business Areas MANDT
QALS GSBER QALS GSBER TGSB Business Areas GSBER
QALS HERKUNFT QALS HERKUNFT TQ31 Inspection Lot Origins HERKUNFT
QALS HERSTELLER QALS MANDANT LFA1 Vendor Master (General Section) MANDT
QALS HERSTELLER QALS HERSTELLER LFA1 Vendor Master (General Section) LIFNR
QALS KDAUF QALS MANDANT VBUK Sales Document: Header Status and Administrative Data MANDT
QALS KDAUF QALS KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
QALS KNTTP QALS MANDANT T163K Account Assignment Categories in Purchasing Document MANDT
QALS KNTTP QALS KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
QALS KOKRS QALS MANDANT TKA01 Controlling Areas MANDT
QALS KOKRS QALS KOKRS TKA01 Controlling Areas KOKRS
QALS KONTO QALS MANDANT SKA1 G/L Account Master (Chart of Accounts) MANDT
QALS KONTO * SKA1 G/L Account Master (Chart of Accounts) KTOPL
QALS KONTO QALS KONTO SKA1 G/L Account Master (Chart of Accounts) SAKNR
QALS KONT_KDAUF QALS MANDANT VBUK Sales Document: Header Status and Administrative Data MANDT
QALS KONT_KDAUF QALS KONT_KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
QALS KONT_PSPNR QALS MANDANT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
QALS KONT_PSPNR QALS KONT_PSPNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
QALS KOSTL QALS MANDANT CSKS Cost Center Master Data MANDT
QALS KOSTL QALS KOKRS CSKS Cost Center Master Data KOKRS
QALS KOSTL QALS KOSTL CSKS Cost Center Master Data KOSTL
QALS KOSTL * CSKS Cost Center Master Data DATBI
QALS KSTRG QALS MANDANT CKPH Master Record: Cost Object ID Number MANDT
QALS KSTRG QALS KSTRG CKPH Master Record: Cost Object ID Number KSTRG
QALS KSTRG * CKPH Master Record: Cost Object ID Number DATBI
QALS KUNNR QALS MANDANT KNA1 General Data in Customer Master MANDT
QALS KUNNR QALS KUNNR KNA1 General Data in Customer Master KUNNR
QALS LAGORTCHRG QALS MANDANT MCHB Batch Stocks MANDT
QALS LAGORTCHRG QALS MATNR MCHB Batch Stocks MATNR
QALS LAGORTCHRG QALS WERK MCHB Batch Stocks WERKS
QALS LAGORTCHRG QALS LAGORTCHRG MCHB Batch Stocks LGORT
QALS LAGORTCHRG QALS CHARG MCHB Batch Stocks CHARG
QALS LAGORTVORG QALS MANDANT T001L Storage Locations MANDT
QALS LAGORTVORG QALS WERKVORG T001L Storage Locations WERKS
QALS LAGORTVORG QALS LAGORTVORG T001L Storage Locations LGORT
QALS LGNUM QALS MANDANT T300 WM Warehouse Numbers MANDT
QALS LGNUM QALS LGNUM T300 WM Warehouse Numbers LGNUM
QALS LGPLA QALS MANDANT LAGP Storage bins MANDT
QALS LGPLA QALS LGNUM LAGP Storage bins LGNUM
QALS LGPLA QALS LGTYP LAGP Storage bins LGTYP
QALS LGPLA QALS LGPLA LAGP Storage bins LGPLA
QALS LGTYP QALS MANDANT T301 WM Storage Types MANDT
QALS LGTYP QALS LGNUM T301 WM Storage Types LGNUM
QALS LGTYP QALS LGTYP T301 WM Storage Types LGTYP
QALS LIFNR QALS MANDANT LFA1 Vendor Master (General Section) MANDT
QALS LIFNR QALS LIFNR LFA1 Vendor Master (General Section) LIFNR
QALS LOS_REF QALS MANDANT QALS Inspection lot record MANDANT
QALS LOS_REF QALS LOS_REF QALS Inspection lot record PRUEFLOS
QALS LS_ABRVW QALS MANDANT TVLV Check table for release orders: Usage ID MANDT
QALS LS_ABRVW QALS LS_ABRVW TVLV Check table for release orders: Usage ID ABRVW
QALS LS_KDAUF QALS MANDANT VBUK Sales Document: Header Status and Administrative Data MANDT
QALS LS_KDAUF QALS LS_KDAUF VBUK Sales Document: Header Status and Administrative Data VBELN
QALS LS_KUNAG QALS MANDANT KNA1 General Data in Customer Master MANDT
QALS LS_KUNAG QALS LS_KUNAG KNA1 General Data in Customer Master KUNNR
QALS LS_LLAND QALS MANDANT T005 Countries MANDT
QALS LS_LLAND QALS LS_LLAND T005 Countries LAND1
QALS LS_POSNR QALS MANDANT VBUP Sales Document: Item Status MANDT
QALS LS_POSNR QALS LS_VBELN VBUP Sales Document: Item Status VBELN
QALS LS_POSNR QALS LS_POSNR VBUP Sales Document: Item Status POSNR
QALS LS_ROUTE QALS MANDANT TVRO Routes MANDT
QALS LS_ROUTE QALS LS_ROUTE TVRO Routes ROUTE
QALS LS_VBELN QALS MANDANT VBUK Sales Document: Header Status and Administrative Data MANDT
QALS LS_VBELN QALS LS_VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
QALS LS_VKORG QALS MANDANT TVKO Organizational Unit: Sales Organizations MANDT
QALS LS_VKORG QALS LS_VKORG TVKO Organizational Unit: Sales Organizations VKORG
QALS MANDANT QALS MANDANT T000 Clients MANDT
QALS MATNR QALS MANDANT MARA General Material Data MANDT
QALS MATNR QALS MATNR MARA General Material Data MATNR
QALS MATNRNEU QALS MANDANT MARA General Material Data MANDT
QALS MATNRNEU QALS MATNRNEU MARA General Material Data MATNR
QALS MENGENEINH QALS MANDANT T006 Units of Measurement MANDT
QALS MENGENEINH QALS MENGENEINH T006 Units of Measurement MSEHI
QALS NPLNR QALS MANDANT AUFK Order master data MANDT
QALS NPLNR QALS NPLNR AUFK Order master data AUFNR
QALS OBJNR QALS MANDANT ONR00 General Object Number MANDT
QALS OBJNR QALS OBJNR ONR00 General Object Number OBJNR
QALS OBTYP QALS OBTYP TJ03 Object types OBTYP
QALS PLNTY QALS MANDANT TCA01 Task list types MANDT
QALS PLNTY QALS PLNTY TCA01 Task list types PLNTY
QALS PPLVERW QALS MANDANT T411 Task list usage MANDT
QALS PPLVERW QALS PPLVERW T411 Task list usage VERWE
QALS PRBNAVERF QALS MANDANT QPRVK Sample-drawing procedure MANDT
QALS PRBNAVERF QALS PRBNAVERF QPRVK Sample-drawing procedure PRZIEHVERF
QALS PRBNAVERF QALS PRBNAVV QPRVK Sample-drawing procedure VERSION
QALS PRCTR QALS MANDANT CEPC Profit Center Master Data Table MANDT
QALS PRCTR QALS PRCTR CEPC Profit Center Master Data Table PRCTR
QALS PRCTR * CEPC Profit Center Master Data Table DATBI
QALS PRCTR * CEPC Profit Center Master Data Table KOKRS
QALS PRSCHAERFE QALS MANDANT QDEP Allowed inspection severities MANDT
QALS PRSCHAERFE QALS PRSCHAERFE QDEP Allowed inspection severities PRSCHAERFE
QALS PRSTUFE QALS MANDANT QDPS Inspection stages for a dynamic modification rule MANDT
QALS PRSTUFE QALS DYNREGEL QDPS Inspection stages for a dynamic modification rule DYNREGEL
QALS PRSTUFE QALS PRSTUFE QDPS Inspection stages for a dynamic modification rule PRSTUFE
QALS PSTYP QALS MANDANT T163 Item Categories in Purchasing Document MANDT
QALS PSTYP QALS PSTYP T163 Item Categories in Purchasing Document PSTYP
QALS PS_PSP_PNR QALS MANDANT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
QALS PS_PSP_PNR QALS PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
QALS QKZVERF QALS MANDANT TQ06 Procedure for Calculating the Quality Score MANDT
QALS QKZVERF QALS QKZVERF TQ06 Procedure for Calculating the Quality Score QKZVERF
QALS QMATAUTH QALS MANDANT TQ01B Material authorization groups in quality management MANDT
QALS QMATAUTH QALS QMATAUTH TQ01B Material authorization groups in quality management QMATAUTH
QALS SA_AUFNR QALS MANDANT SAFK Run Schedule Master Data MANDT
QALS SA_AUFNR QALS SA_AUFNR SAFK Run Schedule Master Data AUFNR
QALS SELHERST QALS MANDANT LFA1 Vendor Master (General Section) MANDT
QALS SELHERST QALS SELHERST LFA1 Vendor Master (General Section) LIFNR
QALS SELKUNNR QALS MANDANT KNA1 General Data in Customer Master MANDT
QALS SELKUNNR QALS SELKUNNR KNA1 General Data in Customer Master KUNNR
QALS SELLIFNR QALS MANDANT LFA1 Vendor Master (General Section) MANDT
QALS SELLIFNR QALS SELLIFNR LFA1 Vendor Master (General Section) LIFNR
QALS SELMATNR QALS MANDANT MARA General Material Data MANDT
QALS SELMATNR QALS SELMATNR MARA General Material Data MATNR
QALS SELPPLVERW QALS MANDANT T411 Task list usage MANDT
QALS SELPPLVERW QALS SELPPLVERW T411 Task list usage VERWE
QALS SELWERK QALS MANDANT T001W Plants/Branches MANDT
QALS SELWERK QALS SELWERK T001W Plants/Branches WERKS
QALS SERNP QALS MANDANT T377P Serial Number Management Profiles MANDT
QALS SERNP QALS SERNP T377P Serial Number Management Profiles SERAIL
QALS SLWBEZ QALS MANDANT TQ79 Table with inspection point/user field combinations MANDT
QALS SLWBEZ QALS SLWBEZ TQ79 Table with inspection point/user field combinations SLWBEZ
QALS SOBKZ QALS MANDANT T148 Special Stock Indicator MANDT
QALS SOBKZ QALS SOBKZ T148 Special Stock Indicator SOBKZ
QALS SPRACHE QALS SPRACHE T002 Language Keys (Component BC-I18) SPRAS
QALS STAFO QALS MANDANT TMCB Update groups MANDT
QALS STAFO QALS STAFO TMCB Update groups STAFO
QALS STPRVER QALS MANDANT QDSV Sampling procedure MANDT
QALS STPRVER QALS STPRVER QDSV Sampling procedure STICHPRVER
QALS STRAT * T351 Maintenance strategy MANDT
QALS STRAT QALS STRAT T351 Maintenance strategy STRAT
QALS STSMA QALS MANDANT TJ20 Status profiles MANDT
QALS STSMA QALS STSMA TJ20 Status profiles STSMA
QALS VERID QALS MANDANT MKAL Production Versions of Material MANDT
QALS VERID QALS MATNR MKAL Production Versions of Material MATNR
QALS VERID QALS WERK MKAL Production Versions of Material WERKS
QALS VERID QALS VERID MKAL Production Versions of Material VERID
QALS WARPL * MPLA Maintenance plan MANDT
QALS WARPL QALS WARPL MPLA Maintenance plan WARPL
QALS WERK QALS MANDANT T001W Plants/Branches MANDT
QALS WERK QALS WERK T001W Plants/Branches WERKS
QALS WERKVORG QALS MANDANT T001W Plants/Branches MANDT
QALS WERKVORG QALS WERKVORG T001W Plants/Branches WERKS