QALS SAP (Inspection lot record) Table details
Dictionary Type: Table
Description: Inspection lot record
Description: Inspection lot record
Table field list including key, data, relationships and ABAP select examples
QALS is a standard SAP Table which is used to store Inspection lot record data and is available within R/3 SAP systems depending on the version and release level.
The QALS table consists of various fields, each holding specific information or linking keys about Inspection lot record data available in SAP. These include PRUEFLOS (Inspection Lot Number), WERK (Plant), ART (Inspection Type), HERKUNFT (Inspection Lot Origin).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP QALS table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDANT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QPLOS | QLS | QALS | ||
WERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
ART | Inspection Type | QPART | CHAR | 8 | TQ30 | QPART | QLA | ||
HERKUNFT | Inspection Lot Origin | QHERK | CHAR | 2 | TQ31 | QHERK | QHK | ||
OBJNR | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
OBTYP | Object Category | J_OBTYP | CHAR | 3 | TJ03 | J_OBTYP | |||
STSMA | Status Profile | J_STSMA | CHAR | 8 | TJ20 | J_STSMA | |||
QMATAUTH | Material Authorization Group for Activities in QM | QMATAUTH | CHAR | 6 | TQ01B | QMATAUTH | |||
STAT11 | GR blocked stock | KZWES | CHAR | 1 | KZWES | ||||
INSMK | Quantity Is or Was in Inspection Stock | QVINSMK | CHAR | 1 | QKZ | ||||
STAT01 | Inspection Lot is Created Automatically | QSTAT01 | CHAR | 1 | QKZ | ||||
STAT02 | Partial Lots Exist | QKZQALT | CHAR | 1 | QKZ | ||||
STAT04 | Data Record Was Changed Using Customer Exit | QUSER_EXIT | CHAR | 1 | QKZ | ||||
STAT06 | Record Appraisal Costs in Individual QM Order | QKZPRFKOST | CHAR | 1 | QKZ | ||||
STAT07 | Inspection with Inspection Points | QKZFERTPRF | CHAR | 1 | QKZ | ||||
STAT08 | Automatic Usage Decision Planned | QAUTO_VE | CHAR | 1 | QKZ | ||||
STAT09 | Source Inspection | QABNAHMPRF | CHAR | 1 | BSTYP | ||||
STAT10 | Inspection Specifications from Configuration | QCONF | CHAR | 1 | QKZ | ||||
STAT14 | Completion of Short-Term Inspection | QSTAT14 | CHAR | 1 | QKZ | ||||
STAT16 | Inspection Specifications from Batch Determination | QCHARG | CHAR | 1 | QKZ | ||||
STAT18 | Control of Inspection Lot Creation (Lot Summary) | Q1WELOS | CHAR | 1 | Q1WELOS | ||||
STAT19 | Documentation Required for Inspection Lot | QSTAT19 | CHAR | 1 | QKZ | ||||
STAT20 | Inspection Plan Required | QSTAT20 | CHAR | 1 | QKZ | ||||
STAT21 | Enter Sample Manually | QSTAT21 | CHAR | 1 | QKZ | ||||
STAT22 | Inspect with Material Specification | QSPEZUEBER | CHAR | 1 | QKZ | ||||
STAT23 | Inspection Lot Approval | QKZGENLOS | CHAR | 1 | QKZGENLOS | ||||
STAT24 | Digital Signature for Insp. Lot in Results Recording | SIG_IL_RES | CHAR | 1 | SIG_IL_RES | ||||
STAT25 | Digital Signature for Insp. Lot when Usage Decision Made | SIG_IL_USA | CHAR | 1 | SIG_IL_USA | ||||
STAT29 | Digital Signature for Confirmation of Phys.-Sample Drawing | SIG_IL_SDR | CHAR | 1 | SIG_IL_SDR | ||||
STAT26 | Indicator: Approved batch record required | XGCHP | CHAR | 1 | XFELD | ||||
STAT27 | Inspection Lot is an R/2 Inspection Lot | QSTAT27 | CHAR | 1 | QKZ | ||||
STAT28 | Select Characteristics Manually | QSTAT28 | CHAR | 1 | QKZ | ||||
STAT31 | Trigger Sample Calculation Manually | QSTAT31 | CHAR | 1 | QKZ | ||||
STAT34 | Stock Postings Completed | QSTAT34 | CHAR | 1 | QKZ | ||||
STAT35 | Usage Decision Has Been Made | QSTAT35 | CHAR | 1 | QKZ | ||||
STAT45 | Material as Dynamic Modification Criterion | QSTAT45 | CHAR | 1 | QKZ | ||||
STAT46 | Vendor as Dynamic Modification Criterion | QSTAT46 | CHAR | 1 | QKZ | ||||
STAT47 | Manufacturer as Dynamic Modification Criterion | QSTAT47 | CHAR | 1 | QKZ | ||||
STAT48 | Customer as Dynamic Modification Criterion | QSTAT48 | CHAR | 1 | QKZ | ||||
STAT49 | Machine as Dynamic Modification Criterion | QSTAT49 | CHAR | 1 | QKZ | ||||
STAT50 | Project as Dynamic Modification Criterion | QSTAT50 | CHAR | 1 | QKZ | ||||
KZSKIPLOT | Lot Skipped | QKZSKIPLOT | CHAR | 1 | QKZ | ||||
DYN | Skips Allowed | QDYN | CHAR | 1 | QKZ | ||||
HPZ | 100% Inspection | QHPZ | CHAR | 1 | QKZ | ||||
EIN | Serial Number Management Possible | QEINZ | CHAR | 1 | QKZ | ||||
ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | INT4 | ||||
KZDYNERF | Dynamic Modification Is Carried Out | QKZDYNERF | CHAR | 1 | QKZ | ||||
DYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | QDYNHEAD | CHAR | 1 | TQ39A | QDYNHEAD | |||
STPRVER | Sampling Procedure | QSTPRVER | CHAR | 8 | QDSV | QSTPRVER | QSV | ||
EXTNUM | External Numbering of Units to be Inspected | QEXTNUM | CHAR | 1 | TQ12 | QEXTNUM | |||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
STAT30 | Origin of Inspection Lot Unit of Measure for LIS Interface | QUNITORIGIN | CHAR | 1 | QUNITORIGIN | ||||
QINFSTATUS | QINF Status | QINFSTATUS | CHAR | 8 | Assigned to domain | QINFSTATUS | |||
ENSTEHDAT | Date of Lot Creation | QENTST | DATS | 8 | DATUM | ||||
ENTSTEZEIT | Time of Lot Creation | QENTSTZEIT | TIMS | 6 | QZEIT | ||||
ERSTELLER | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | QAENDERER | ||||
ERSTELDAT | Date on Which the Data Record Was Created | QDATUMERST | DATS | 8 | DATUM | ||||
ERSTELZEIT | Time of Lot Creation | QERSTEZEIT | TIMS | 6 | QZEIT | ||||
AENDERER | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
AENDERDAT | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | DATUM | ||||
AENDERZEIT | Time of Lot Change | QAENDEZEIT | TIMS | 6 | QZEIT | ||||
PASTRTERM | Inspection Start Date | QPRSTART | DATS | 8 | DATUM | ||||
PASTRZEIT | Inspection Start Time | QSTARTZEIT | TIMS | 6 | QZEIT | ||||
PAENDTERM | End Date of the Inspection | QPRENDE | DATS | 8 | DATUM | ||||
PAENDZEIT | Inspection End Time | QENDEZEIT | TIMS | 6 | QZEIT | ||||
PLNTY | Task List Type | PLNTY | CHAR | 1 | TCA01 | PLNTY | PTY | H_TCA01 | |
PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | ALPHA | PLNNR | PLN | PLKS | |
PPLVERW | Task list usage | PLN_VERWE | CHAR | 3 | T411 | PLN_VERWE | H_T411 | ||
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
ZAEHL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
ZKRIZ | Counter for additional criteria | DZKRIZ | NUMC | 7 | ZKRIZ | ||||
STAT15 | Production Resource/Tool Saved for Insp. Lot | QFHM_MODE | CHAR | 1 | QKZ | ||||
SLWBEZ | Identification for the Inspection Point Field Combination | QSLWBEZ | CHAR | 3 | TQ79 | QSLWBEZ | QBK | ||
STAT13 | Inspection Point Type | QPPKTTYP | CHAR | 1 | QPPKTTYP | ||||
PPKZTLZU | Partial Lot Assignment in an Inspection During Production | QPPKZTLZU | CHAR | 1 | QPPKZTLZU | ||||
ZAEHL1 | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
PRBNAVERF | Sample-Drawing Procedure | QPRZIEHVER | CHAR | 8 | QPRVK | QPRZIEHVER | QPV | ||
PRBNAVV | Version No. of the Sample-Drawing Procedure | QVERSNPRZV | CHAR | 6 | ALPHA | QVERSNR | |||
STAT12 | Confirmation Required for Physical-Sample Drawing | QKZQUIT | CHAR | 1 | QKZ | ||||
SELMATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
SELREVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
SELWERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
SELLIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
STAT17 | Manufacturer Part No. Processing Active | QHERST | CHAR | 1 | QKZ | ||||
SELHERST | Number of Manufacturer | QLIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
SELKUNNR | Account Number of Customer | EKUNN | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
SELPPLVERW | Task list usage | PLN_VERWE | CHAR | 3 | T411 | PLN_VERWE | H_T411 | ||
GUELTIGAB | Key Date for Selecting Records or Changing Task Lists | QSTICHTAG | DATS | 8 | DATUM | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | NUMC | 18 | CUOBJ | ||||
VERID | Production Version | VERID | CHAR | 4 | MKAL | VERID | VER | ||
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | SAFK | ALPHA | SA_AUFNR | ||
KUNNR | Customer (Ship-To Party) | QKUNWE | CHAR | 10 | KNA1 | ALPHA | KUNNR | DEBI | |
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
EMATNR | Material Number Corresponding to Manufacturer Part Number | EMATN | CHAR | 18 | MARA | MATN1 | MATNR | HTN | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1 | XFELD | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
LAGORTCHRG | Storage Location | LGORT_D | CHAR | 4 | MCHB | LGORT | LAG | ||
ZEUGNISBIS | Valid-To Date for The Batch Certificate | QZEUGBIS | DATS | 8 | DATUM | ||||
VFDAT | Shelf Life Expiration or Best-Before Date | VFDAT | DATS | 8 | DATUM | ||||
LICHN | Vendor Batch Number | LICHN | CHAR | 15 | LICHN | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
PS_PSP_PNR | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
KDAUF | Sales Order Number of Valuated Sales Order Stock | MAT_KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 6 | NUM06 | KPO | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
ETENR | Delivery Schedule Line Counter | EETEN | NUMC | 4 | EKET | EETEN | |||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
MJAHR | Material Document Year | MJAHR | NUMC | 4 | GJAHR | GJAHR | MJA | ||
MBLNR | Number of Material Document | MBLNR | CHAR | 10 | ALPHA | BELNR | MBN | ||
ZEILE | Item in Material Document | MBLPO | NUMC | 4 | MBLPO | POS | |||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BWART | Movement Type (Inventory Management) | BWART | CHAR | 3 | T156 | BWART | BWA | ||
WERKVORG | Plant Where Stock for Inspection Lot Is Held | QWERKVORG | CHAR | 4 | T001W | WERKS | |||
LAGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4 | T001L | LGORT | |||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | T300 | LGNUM | LGN | ||
LGTYP | Storage Type | LGTYP | CHAR | 3 | T301 | LGTYP | LGT | H_T301 | |
LGPLA | Storage Bin | LGPLA | CHAR | 10 | LAGP | LGPLA | LGP | LAG1 | |
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
LS_KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10 | VBUK | ALPHA | VBELN | VL | |
LS_POSNR | Delivery Item | POSNR_VL | NUMC | 6 | VBUP | POSNR | |||
LS_ABRVW | Delivery Category | QABRVW | CHAR | 3 | TVLV | ABRVW | |||
LS_ROUTE | Route | ROUTE | CHAR | 6 | TVRO | ROUTE | |||
LS_LLAND | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
LS_KUNAG | Sold-to party | KUNAG | CHAR | 10 | KNA1 | ALPHA | KUNNR | VAG | |
LS_VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
LS_KDMAT | Material belonging to the customer | KDMAT | CHAR | 35 | IDNEX | ||||
SPRACHE | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
KTEXTLOS | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
LTEXTKZ | Long Text Exists For Inspection Lot | QLTEXTLOS | CHAR | 1 | QKZ | ||||
KTEXTMAT | Short Text for Inspection Object | QKTEXTOBJ | CHAR | 40 | QKURZTEXT | ||||
ZUSMKZAEHL | Number of Characteristics Recorded Additionally | QZUSMKZHL | INT2 | 5 | INT2 | ||||
OFFENNLZMK | Number of Outstanding Short-Term Chars Which Require Conf. | QOFFENLZMK | INT2 | 5 | INT2 | ||||
OFFEN_LZMK | Number of Outstanding Long-Term Chars Which Require Conf. | QOFFELZMK | INT2 | 5 | INT2 | ||||
LOSMENGE | Inspection Lot Quantity | QLOSMENGE | QUAN | 13(3) | QMENGEPLOS | ||||
MENGENEINH | Base Unit of Measure for The Inspection Lot Quantity | QLOSMENGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
ANZGEB | QM - No. of Containers | QANZGEB | QUAN | 6(3) | QGEBPLOS | ||||
GEBEH | Lot Container | QGEBEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
LVS_STIKZ | Indicator: what has happened to insp.sample (QM) in WM | LVS_STIKZ | CHAR | 1 | LVS_STIKZ | ||||
LVS_STIMG | Sample in base unit of measure provided by WM | LVS_STIMG | QUAN | 13(3) | MENG13 | ||||
GESSTICHPR | Sample Size | QGESTICH | QUAN | 13(3) | QMENGEPLOS | ||||
EINHPROBE | Base Unit of Measure for the Sample Unit | QPROBEMGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
DYNREGEL | Dynamic Modification Rule | QDYNREGEL | CHAR | 3 | QDDR | QDYNREGEL | QDR | ||
STAT44 | Time of Dynamic Modification in Inspection Lot | QDYNTIME | CHAR | 1 | QDYNTIME | ||||
PRSTUFE | Inspection Stage | QPRSTUFE | NUMC | 4 | QDPS | QPRSTUFE | |||
PRSCHAERFE | Inspection Severity | QPRSCHAERF | NUMC | 3 | QDEP | QPRSCHAERF | |||
LMENGE01 | Quantity Posted to Unrestricted-Use Stock | QLMENGE01F | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGE02 | Quantity Posted to Scrap | QLMENGE02F | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGE03 | Quantity Posted to Sample | QLMENGE03F | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGE04 | Quantity Posted to Blocked Stock | QLMENGE04F | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGE05 | Quantity Posted to Reserves | QLMENGE05F | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGE06 | Quantity Posted to Another Material | QLMENGE06F | QUAN | 13(3) | QMENGEPLOS | ||||
MATNRNEU | Material Number to Which the Quantity is Posted | QMATNRNEU | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
CHARGNEU | Batch to Which Goods Are Transferred | QCHARGNEU | CHAR | 10 | MCH1 | CHARG | CHA | ||
LMENGE07 | Quantity Returned to Vendor | QLMENGE07F | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGE08 | Other Quantity Posted from Inspection Lot Stock | QLMENGE08F | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGE09 | Other Quantity (2) Posted from Inspection Lot Stock | QLMENGE09F | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGEZUB | Quantity That Must Be Posted | QLMENGEZUB | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGELZ | Sample Quantity for Long-Term Characteristics | QLMENGELZ | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGEPR | Quantity Actually Inspected | QLMENGEPR | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGEZER | Quantity Destroyed During Inspection | QLMENGEZER | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGEIST | Actual Lot Quantity | QLMENGEIST | QUAN | 13(3) | QMENGEPLOS | ||||
LMENGESCH | Defective Quantity in Inspected Quantity | QLMENGESCH | QUAN | 13(3) | QMENGEPLOS | ||||
LTEXTKZBB | Logs Exist for Usage Decision | QLTEXTKZBB | CHAR | 1 | QKZ | ||||
ANTEIL | Share of Scrap in Inspection Lot | QAUSANTEIL | FLTP | 16(16) | QFLTP16 | ||||
QKZVERF | Procedure for Calculating Quality Score | QKZVERF | CHAR | 2 | TQ06 | QKZVERF | |||
STAT03 | Usage Decision Mmode (UD Origin) | QMODUS_UD | CHAR | 1 | QMODUS_UD | ||||
QPMATLOS | Allowed Share of Scrap | QPMATLOS | FLTP | 16(16) | QPMATLOS | ||||
AUFNR_CO | Order Number for Recording Appraisal Costs | QAUFNR_CO | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
STAT05 | Account Assignment Key: Inspection Lot | QKZQALSKNT | CHAR | 1 | QKZQALSKNT | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
AUFPS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
KONT_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | AUFK | ALPHA | AUFNR | NET | |
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
KONT_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
KONT_KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
DABRZ | Reference Date for Settlement | DABRBEZ | DATS | 8 | DDAT | ||||
KSTRG | Cost Object | KSTRG | CHAR | 12 | CKPH | KSTRG | KTR | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
KONTO | G/L Account Number | SAKNR | CHAR | 10 | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
SERNP | Serial Number Profile | SERAIL | CHAR | 4 | T377P | SERAIL | |||
LOS_REF | Inspection Lot Number Which Is Referenced | QLOS_REF | NUMC | 12 | QALS | QPLOS | |||
BEARBSTATU | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED02 | CHAR | 2 | CHAR2 | ||||
STAT32 | Inspection lot for stability study | QSTABI | CHAR | 1 | QSTABI | ||||
STAT33 | Indicator: Multiple Specifications | Q_MS_FLG | CHAR | 1 | Q_MS_FLG | ||||
STAT36 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
STAT37 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
STAT38 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
STAT39 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
STAT40 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
STAT41 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
STAT42 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
STAT43 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
MENGU | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
KZPZADR | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
KZPRADR | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
ZUSCH | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
ZUSTD | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
KZERSTLIEF | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
KZERSTMUST | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
ADDON_DUMMY | Dummy Field for ADDON Structures in QM | QDUMMY | CHAR | 1 | QDUMMY | ||||
.INCLU--AP | 0 | ||||||||
WARPL | Maintenance Plan | WARPL | CHAR | 12 | MPLA | ALPHA | WARPL | MPL | MPLAL |
WAPOS | Maintenance item | WAPOS | CHAR | 16 | ALPHA | POSNU | MPS | MPOSL | |
ABNUM | Maintenance Plan Call Number | ABNUM | INT4 | 10 | ABNUM | ||||
STRAT | Maintenance strategy | STRAT | CHAR | 6 | T351 | WSTRA | STR | STRAA | |
.INCLU--AP | 0 | ||||||||
TRIALID | Trial Number | RMXTE_TRIALID | CHAR | 12 | ALPHA | RMXTD_TRIALID | RMXTE_TRIALID | ||
RESPONSIBLE | Responsible | ESEREALO | CHAR | 45 | CHAR45 | ||||
INSP_DOC_NUMBER | Inspection Document Number from External System | QINSP_DOC_NUMBER | CHAR | 30 | QPLEXT_INSP_DOC_NUMBER | ||||
LOG_SYSTEM | Logical system | LOGSYS | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
GESSTICHPR_EXT | Sample Size from External System | QGESTICH_EXT | QUAN | 13(3) | QPLEXT_PROBEMNG | ||||
EINHPROBE_EXT | Unit of Measure of External Sample | QPROBEMGEH_EXT | UNIT | 3 | Assigned to domain | CUNIT | QPLEXT_PROBEMGEH | ||
PRIO_PUNKTE | Priority Points | QPRIO_PUNKTE | INT4 | 10 | QPLEXT_PRIOP | ||||
SIGN_TYPE_RR | Signature Type: Inspection Lot Results Recording | SIGN_TYPE_RR | CHAR | 1 | SIGN_TYPE | ||||
SIGN_TYPE_UD | Signature Type: Inspection Lot Usage Decision | SIGN_TYPE_UD | CHAR | 1 | SIGN_TYPE_SINGLE | ||||
SIGN_TYPE_SM | Signature Type: Physical-Sample Drawing | SIGN_TYPE_SM | CHAR | 1 | SIGN_TYPE_SINGLE | ||||
SIGNSTRAT_RR | Signature Strategy: Inspection Lot Results Recording | SIGNSTRAT_RR | CHAR | 8 | Assigned to domain | SIGNSTRAT | |||
SIGNSTRAT_UD | Signature Strategy with Individual Signature: Usage Decision | SIGNSTRAT_UD | CHAR | 8 | Assigned to domain | SIGNSTRAT | |||
SIGNSTRAT_SM | Signature Strategy w. Ind.Signature: Physical-Sample Drawing | SIGNSTRAT_SM | CHAR | 8 | Assigned to domain | SIGNSTRAT |
Key field | Non-key field |
How do I retrieve data from SAP table QALS using ABAP code
The following ABAP code Example will allow you to do a basic selection on QALS to SELECT all data from the tableDATA: WA_QALS TYPE QALS.
SELECT SINGLE *
FROM QALS
INTO CORRESPONDING FIELDS OF WA_QALS
WHERE...
How to access SAP table QALS
Within an ECC or HANA version of SAP you can also view further information about QALS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects