QALS_D01 SAP (Display fields for QM reporting) Structure details
Description: Display fields for QM reporting
Structure field list including key, data, relationships and ABAP select examples
QALS_D01 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Display fields for QM reporting" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_QALS_D01 TYPE QALS_D01.
The QALS_D01 table consists of various fields, each holding specific information or linking keys about Display fields for QM reporting data available in SAP. These include STTXT (System Status), USTXT (Field displaying user status), WERK (Plant), ART (Inspection Type).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP QALS_D01 structure 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 |
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | QALS | QPLOS | QLS | QALS | |
STTXT | System Status | CO_STTXT | CHAR | 40 | CHAR40 | ||||
USTXT | Field displaying user status | CO_ASTTX | CHAR | 40 | CHAR40 | ||||
WERK | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
ART | Inspection Type | QPART | CHAR | 8 | Assigned to domain | QPART | QLA | ||
HERKUNFT | Inspection Lot Origin | QHERK | CHAR | 2 | Assigned to domain | QHERK | QHK | ||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
OBTYP | Object Category | J_OBTYP | CHAR | 3 | Assigned to domain | J_OBTYP | |||
AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | AUFPL | ||||
KTEXTMAT | Short Text for Inspection Object | QKTEXTOBJ | CHAR | 40 | QKURZTEXT | ||||
STSMA | Status Profile | J_STSMA | CHAR | 8 | Assigned to domain | J_STSMA | |||
QMATAUTH | Material Authorization Group for Activities in QM | QMATAUTH | CHAR | 6 | Assigned to domain | QMATAUTH | |||
STAT11 | GR blocked stock | KZWES | CHAR | 1 | KZWES | ||||
INSMK | Quantity Is or Was in Inspection Stock | QVINSMK | CHAR | 1 | QKZ | ||||
STAT02 | Partial Lots Exist | QKZQALT | CHAR | 1 | QKZ | ||||
STAT07 | Inspection with Inspection Points | QKZFERTPRF | CHAR | 1 | QKZ | ||||
STAT06 | Record Appraisal Costs in Individual QM Order | QKZPRFKOST | CHAR | 1 | QKZ | ||||
STAT09 | Source Inspection | QABNAHMPRF | CHAR | 1 | BSTYP | ||||
STAT19 | Documentation Required for Inspection Lot | QSTAT19 | 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 | ||||
KZSKIPLOT | Lot Skipped | QKZSKIPLOT | CHAR | 1 | QKZ | ||||
HPZ | 100% Inspection | QHPZ | CHAR | 1 | QKZ | ||||
DYNHEAD | Level at Which Dynamic Modification Parameters Are Defined | QDYNHEAD | CHAR | 1 | Assigned to domain | QDYNHEAD | |||
STPRVER | Sampling Procedure | QSTPRVER | CHAR | 8 | Assigned to domain | QSTPRVER | QSV | ||
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 | Assigned to domain | 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 | Assigned to domain | PLN_VERWE | H_T411 | ||
PLNAL | Group Counter | PLNAL | CHAR | 2 | ALPHA | ALTNR | PAL | ||
SLWBEZ | Identification for the Inspection Point Field Combination | QSLWBEZ | CHAR | 3 | Assigned to domain | QSLWBEZ | QBK | ||
STAT13 | Inspection Point Type | QPPKTTYP | CHAR | 1 | QPPKTTYP | ||||
PRBNAVERF | Sample-Drawing Procedure | QPRZIEHVER | CHAR | 8 | Assigned to domain | 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 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
SELREVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
SELWERK | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
SELLIFNR | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
SELHERST | Number of Manufacturer | QLIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | |
SELKUNNR | Account Number of Customer | EKUNN | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | |
SELPPLVERW | Task list usage | PLN_VERWE | CHAR | 3 | Assigned to domain | PLN_VERWE | H_T411 | ||
GUELTIGAB | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
VERID | Production Version | VERID | CHAR | 4 | Assigned to domain | VERID | VER | ||
SA_AUFNR | Run schedule header number | SA_AUFNR | CHAR | 12 | Assigned to domain | ALPHA | SA_AUFNR | ||
KUNNR | Customer (Ship-To Party) | QKUNWE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | DEBI | |
LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
HERSTELLER | Number of Manufacturer | QLIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | |
EMATNR | Material Number | EMATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | |
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | 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 | Assigned to domain | CHARG | CHA | ||
LAGORTCHRG | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
ETENR | Delivery Schedule Line Counter | EETEN | NUMC | 4 | Assigned to domain | EETEN | |||
BLART | Document Type | BLART | CHAR | 2 | Assigned to domain | 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 | Assigned to domain | BWART | BWA | ||
WERKVORG | Plant Where Stock for Inspection Lot Is Held | QWERKVORG | CHAR | 4 | Assigned to domain | WERKS | |||
LAGORTVORG | Storage Location for Inspection Lot Stock | QLGORTVORG | CHAR | 4 | Assigned to domain | LGORT | |||
LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | Assigned to domain | LGNUM | LGN | ||
LGTYP | Storage Type | LGTYP | CHAR | 3 | Assigned to domain | LGTYP | LGT | H_T301 | |
LGPLA | Storage Bin | LGPLA | CHAR | 10 | Assigned to domain | LGPLA | LGP | LAG1 | |
LS_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
LS_KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
LS_VBELN | Delivery | VBELN_VL | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VL | |
LS_POSNR | Delivery Item | POSNR_VL | NUMC | 6 | Assigned to domain | POSNR | |||
LS_ABRVW | Delivery Category | QABRVW | CHAR | 3 | Assigned to domain | ABRVW | |||
LS_ROUTE | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
LS_LLAND | Country of Destination | LLAND | CHAR | 3 | Assigned to domain | LAND1 | VLL | ||
LS_KUNAG | Sold-to party | KUNAG | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | VAG | |
LS_VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
LS_KDMAT | Material belonging to the customer | KDMAT | CHAR | 35 | IDNEX | ||||
SPRACHE | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
KTEXTLOS | Short Text | QKURZTEXT | 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 | Assigned to domain | CUNIT | MEINS | ||
ANZGEB | QM - No. of Containers | QANZGEB | QUAN | 6(3) | QGEBPLOS | ||||
GEBEH | Lot Container | QGEBEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GESSTICHPR | Sample Size | QGESTICH | QUAN | 13(3) | QMENGEPLOS | ||||
EINHPROBE | Base Unit of Measure for the Sample Unit | QPROBEMGEH | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DYNREGEL | Dynamic Modification Rule | QDYNREGEL | CHAR | 3 | Assigned to domain | QDYNREGEL | QDR | ||
STAT44 | Immediate Dynamic Modification at Inspection Lot Creation | QKZDYNAUT | CHAR | 1 | QKZ | ||||
PRSTUFE | Inspection Stage | QPRSTUFE | NUMC | 4 | Assigned to domain | QPRSTUFE | |||
PRSCHAERFE | Inspection Severity | QPRSCHAERF | NUMC | 3 | Assigned to domain | 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 | Assigned to domain | MATN1 | MATNR | MAT | |
CHARGNEU | Batch to Which Goods Are Transferred | QCHARGNEU | CHAR | 10 | Assigned to domain | 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 | ||||
ANTEIL | Share of Scrap in Inspection Lot | QAUSANTEIL | FLTP | 16(16) | QFLTP16 | ||||
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 | Assigned to domain | ALPHA | AUFNR | ANR | |
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | Assigned to domain | KNTTP | KNT | ||
STAT05 | Account Assignment Key: Inspection Lot | QKZQALSKNT | CHAR | 1 | QKZQALSKNT | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
AUFPS | Item Number of Reservation/Dependent Requirement | RSPOS | NUMC | 4 | RSPOS | RPO | |||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | Assigned to domain | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | Assigned to domain | ALPHA | ANLN2 | AN2 | |
PS_PSP_PNR | Valuated Sales Order Stock WBS Element | MAT_PSPNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
APLZL | Internal counter | CIM_COUNT | NUMC | 8 | CIM_COUNT | ||||
KDAUF | Sales Order Number of Valuated Sales Order Stock | MAT_KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KDPOS | Sales Order Item of Valuated Sales Order Stock | MAT_KDPOS | NUMC | 6 | NUM06 | KPO | |||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
KONTO | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
SERNP | Serial Number Profile | SERAIL | CHAR | 4 | Assigned to domain | SERAIL | |||
KONT_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
KONT_KDAUF | Sales Order Number | KDAUF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
KONT_KDPOS | Item Number in Sales Order | KDPOS | NUMC | 6 | NUM06 | KPO | |||
STAT16 | Field Not Used as of 3.0 Field Reserved for SAP | Q_UNUSED01 | CHAR | 1 | CHAR1 | ||||
INSP_DOC_NUMBER | Inspection Document Number from External System | QINSP_DOC_NUMBER | CHAR | 30 | QPLEXT_INSP_DOC_NUMBER | ||||
PRIO_PUNKTE | Priority Points | QPRIO_PUNKTE | INT4 | 10 | QPLEXT_PRIOP |
Key field | Non-key field |
How do I retrieve data from SAP structure QALS_D01 using ABAP code?
As QALS_D01 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on QALS_D01 as there is no data to select.How to access SAP table QALS_D01
Within an ECC or HANA version of SAP you can also view further information about QALS_D01 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