QASPR SAP (Result and specification record for the sample) Structure details
Description: Result and specification record for the sample
Structure field list including key, data, relationships and ABAP select examples
QASPR 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 "Result and specification record for the sample" 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_QASPR TYPE QASPR.
The QASPR table consists of various fields, each holding specific information or linking keys about Result and specification record for the sample data available in SAP. These include MERKNR (Inspection Characteristic Number), PROBENR (Sample Number), UPSLV (Data Base Access), MARK (Selection Field).. 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 QASPR 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 |
VORGLFNR | Current Node Number from Order Counter APLZL | QLFNKN | NUMC | 8 | KNTNR | ||||
MERKNR | Inspection Characteristic Number | QMERKNRP | NUMC | 4 | QMERKNRP | ||||
PROBENR | Sample Number | QPROBENR | NUMC | 6 | Assigned to domain | QPROBENR | QPO | ||
UPSLV | Data Base Access | QUPSL | CHAR | 1 | QUPSL | ||||
MARK | Selection Field | QMARK | CHAR | 1 | QKZ | ||||
STATUSV | Specification Record Status | QSTATUS | CHAR | 1 | TQ76 | QSTATUS | |||
ERSTELLERV | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | QAENDERER | ||||
ERSTELLDAV | Date on Which the Data Record Was Created | QDATUMERST | DATS | 8 | DATUM | ||||
AENDERERV | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
AENDERDATV | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | DATUM | ||||
ANNAHMEZ | Acceptance Number | QANNAHMEZ | INT2 | 5 | QINT2NEG | ||||
RUECKWEZ | Rejection Number | QRUECKWEZ | INT2 | 5 | QANZAHL2 | ||||
KFAKTORNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
KFAKTOR | K-Factor for a Variable Inspection | QKFAKTOR | FLTP | 16(16) | QKFAKTOR | ||||
ANTVERF | Fraction Calculation | QEANTVERF | CHAR | 2 | Assigned to domain | QEANTVERF | |||
BEWREGEL | Valuation Rule | QBEWERT | CHAR | 2 | QDFM | QKEY1 | |||
FBNAME | Name of Function Module | QFBNAME | CHAR | 30 | Assigned to domain | FUNCNAME | |||
KZATTRFE | Attributive Inspection by Nonconforming Units | QKZATTRFE | CHAR | 1 | QKZ | ||||
KZATTRFZ | Attributive Inspection by Number of Defects | QKZATTRFZ | CHAR | 1 | QKZ | ||||
KZVARS | Variable Inspection by S-Method | QKZVARS | CHAR | 1 | QKZ | ||||
KZCOD | Valuation by Code | QKZCOD | CHAR | 1 | QKZ | ||||
KZMAN | Manual Valuation | QKZMAN | CHAR | 1 | QKZ | ||||
KZQRK | Acceptance Using Control Chart | QKZQRK | CHAR | 1 | QKZ | ||||
KZNULL | Inspection Against Specification Limits (k = 0) | QKZKNULL | CHAR | 1 | QKZ | ||||
FAKPLANME | Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure | QUMREN | FLTP | 16(16) | QUMRENFAK | ||||
FAKPROBME | Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure | QUMRENPME | FLTP | 16(16) | QUMRENFAK | ||||
PROBMGFAK | Sample Unit Factor | QPROBMGFAK | DEC | 5(2) | QPROBEFAK | ||||
PROBEMGEH | Sample Unit of Measure | QPROBME | UNIT | 3 | T006 | CUNIT | MEINS | ||
STIPROUMF | Sample Size that Must Be Inspected | QSTIPROUMF | INT4 | 10 | QANZAHL4 | ||||
PRUEFUMF | Quantity to Be Inspected | QPRUEFUMF | QUAN | 13(3) | QMENGEPLOS | ||||
MENGENEINH | Base Unit of Measure for the Sample Unit | QPROBEMGEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
QRKNR | Control Chart Number | QQRKNR | NUMC | 12 | QASH | QQRKNR | |||
PRSTUFE | Inspection Stage | QPRSTUFE | NUMC | 4 | Assigned to domain | QPRSTUFE | |||
PRSCHAERFE | Inspection Severity | QPRSCHAERF | NUMC | 3 | Assigned to domain | QPRSCHAERF | |||
UPSLR | Data Base Access | QUPSL | CHAR | 1 | QUPSL | ||||
STATUSR | Results Record Status | QBEASTATUS | CHAR | 1 | TQ76 | QSTATUS | |||
ATTRIBUT | Attribute of the Results Record (Valid, Invalid,...) | QATTRIBUT | CHAR | 1 | QATTRIBUT | ||||
QERGDATHPL | Planned Results Data Origin | QERGDATHPL | CHAR | 2 | Assigned to domain | QERGDATH | |||
QERGDATH | Origin of Results Data | QERGDATH | CHAR | 2 | TQ73 | QERGDATH | |||
ERSTELLERR | Name of User Who Created the Data Record | QERSTELLER | CHAR | 12 | QAENDERER | ||||
ERSTELLDAR | Date on Which the Data Record Was Created | QDATUMERST | DATS | 8 | DATUM | ||||
AENDERERR | Name of User who Most Recently Changed the Data Record | QAENDERER | CHAR | 12 | QAENDERER | ||||
AENDERDATR | Date on Which Data Record Was Changed | QDATUMAEND | DATS | 8 | DATUM | ||||
MBEWERTG | Inspection Result Valuation | QMBEWERTG | CHAR | 1 | QEEBEWERTG | ||||
DBEWERTG | Valuation of the Characteristic for Dynamic Modification | QDBEWERTG | CHAR | 1 | QEEBEWERTG | ||||
PRUEFER | Name of the Inspector | QPRUEFER | CHAR | 12 | QPRUEFER | QPR | |||
PRUEFDATUV | Inspection Start Date | QPRUEFDATV | DATS | 8 | DATUM | QDV | |||
PRUEFDATUB | End Date of the Inspection | QPRUEFDATB | DATS | 8 | DATUM | ||||
PRUEFZEITV | Starting Time of the Inspection | QPRUEFZTV | TIMS | 6 | QZEIT | QZV | |||
PRUEFZEITB | End Time of the Inspection | QPRUEFZTB | TIMS | 6 | QZEIT | ||||
PRUEFBEMKT | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
PRLTEXTKZ | Inspection Characteristic Long Text Exists | QLTEXTKZ | CHAR | 1 | QKZ | ||||
LTEXTSPR | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
PRFBEMSPRA | Long Text Language for Inspection Description | QPRFBESPRA | LANG | 1 | Assigned to domain | ISOLA | SPRAS | H_T002 | |
ISTSTPUMF | Number of Recorded Sample Units | QISTSTPUMF | INT4 | 10 | QANZAHL4 | ||||
ANZFEHLEH | Number of Nonconforming Sample Units | QANZFEHEH2 | INT2 | 5 | QANZAHL2 | ||||
ANTEILNI | Not Initialized for Fraction | QNIANTEIL | CHAR | 1 | QNOTINI | ||||
ANTEIL | Estimated Fraction of Nonconforming Sample Units | QANTEIL | FLTP | 16(16) | QSTATWERT | ||||
ANZFEHLER | Number of Defects Found | QANZFEHL2 | INT2 | 5 | QANZAHL2 | ||||
ANZWERTO | Number of Measured Values Above the Tolerance Range | QANZWERTO2 | INT2 | 5 | QANZAHL2 | ||||
ANZWERTU | Number of Measured Values Below the Tolerance Range | QANZWERTU2 | INT2 | 5 | QANZAHL2 | ||||
ANZWERTG | Number of Inspected Sample Units | QANZWERTG2 | INT2 | 5 | QANZAHL2 | ||||
MAXWERTNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
MEDIANNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
MINWERTNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
MITTELWNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
VARIANZNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
MOMENT3NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
MOMENT4NI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
ANTEILONI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
ANTEILUNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
MAXWERT | Maximum Value of the Valid Measured Values | QMAXWERT | FLTP | 16(16) | QSTATWERT | ||||
MEDIANWERT | Median of Valid Measured Values | QMEDIANWRT | FLTP | 16(16) | QSTATWERT | ||||
MINWERT | Minimum Value of the Valid Measured Values | QMINWERT | FLTP | 16(16) | QSTATWERT | ||||
MITTELWERT | Arithmetic Mean of Valid Measured Values | QMITTELWRT | FLTP | 16(16) | QSTATWERT | ||||
VARIANZ | Dispersion (Variance) of Valid Measured Values | QVARIANZ | FLTP | 16(16) | QSTATWERT | ||||
MOMENT3 | Third Central Moment of Valid Measured Values | QMOMENT3 | FLTP | 16(16) | QSTATWERT | ||||
MOMENT4 | Fourth Central Moment of Valid Measured Values | QMOMENT4 | FLTP | 16(16) | QSTATWERT | ||||
ANTEILO | Estimated Fraction Above the Tolerance Range | QANTEILO | FLTP | 16(16) | QSTATWERT | ||||
ANTEILU | Estimated Fraction Below the Tolerance Range | QANTEILU | FLTP | 16(16) | QSTATWERT | ||||
KATALGART1 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
GRUPPE1 | Code Group | QCODEGRP | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
CODE1 | Code | QCODE | CHAR | 4 | Assigned to domain | QCODE | QCODE | ||
VERSION1 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
KATALGART2 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
GRUPPE2 | Code Group | QCODEGRP | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
CODE2 | Code | QCODE | CHAR | 4 | Assigned to domain | QCODE | QCODE | ||
VERSION2 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
KATALGART3 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
GRUPPE3 | Code Group | QCODEGRP | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
CODE3 | Code | QCODE | CHAR | 4 | Assigned to domain | QCODE | QCODE | ||
VERSION3 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
KATALGART4 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
GRUPPE4 | Code Group | QCODEGRP | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
CODE4 | Code | QCODE | CHAR | 4 | Assigned to domain | QCODE | QCODE | ||
VERSION4 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
KATALGART5 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | TQ15 | QKATART | QKT | ||
GRUPPE5 | Code Group | QCODEGRP | CHAR | 8 | Assigned to domain | QCODEGRP | CGP | ||
CODE5 | Code | QCODE | CHAR | 4 | Assigned to domain | QCODE | QCODE | ||
VERSION5 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
FEHLKLAS | Defect Class | QFEHLKLAS | CHAR | 2 | TQ17 | QFEHLKLAS | |||
STDABWNI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
STDABW | Standard Deviation of Valid Measured Values | QSTDAW | FLTP | 16(16) | QSTATWERT | ||||
SPANNWEINI | Value Not Initial if Set | QNINITIAL | CHAR | 1 | QKZ | ||||
SPANNWEITE | Range of Valid Measured Values | QSPANNWEI | FLTP | 16(16) | QSTATWERT | ||||
SENDEFLAG | Characteristic Result Confirmation from Control Station | QSENDEFLAG | CHAR | 1 | QSENDEFLAG | ||||
MASCHINE | General Information | QMASCHINE | CHAR | 18 | ALPHA | QEQUNR | |||
POSITION | Test Position | QPRPOS | NUMC | 4 | QPRPOS | ||||
KATERG | Catalog Confirmations Available | QKATERG | CHAR | 1 | QKZ | ||||
AENDBELEG | Create Change Documents During Results Recording | QKZAENBEL | CHAR | 1 | QKZ | ||||
KZBEWERTG | Valuation Copied or Forced | QKZBEWERTG | CHAR | 1 | QKZBEWERTG | ||||
ZEITERSTL | Time at which data record was created | QZEITERSTL | TIMS | 6 | QZEIT | ||||
ZEITAEND | Time at which data record was last changed | QZEITAEND | TIMS | 6 | QZEIT | ||||
PRUEFLOS | Inspection Lot Number | QPLOS | NUMC | 12 | Assigned to domain | QPLOS | QLS | QALS | |
FECODSELE | Selected Defect Code for Autom. Generation of Defect Records | QCODESELE | CHAR | 4 | Assigned to domain | QCODE | |||
FEGRPSELE | Code Group of the Default Record for Automatic Generation | QGRPSELE | CHAR | 8 | Assigned to domain | QCODEGRP | |||
STATUSROLD | Quality Status of Results Record Before Last Change | QBEASTATOD | CHAR | 1 | Assigned to domain | QSTATUS | |||
ORIGINAL_INPUT | Original Value Before Input Processing | QORIGINAL_INPUT | CHAR | 25 | CHAR25 | ||||
DIFF_DEC_PLACES | Different Number of Decimal Places | QDIFF_DEC_PLACES | INT2 | 5 | INT2 | ||||
INPPROC_READY | Input Processing Successfully Completed | QINPPROC_READY | CHAR | 1 | QKZ | ||||
SIGN_ID | Digital Signature: Signature Number as GUID with 22 Chars. | SIGN_GUID_22 | CHAR | 22 | SYSUUID_22 | ||||
SIGN_STATE | Status of Signature Process | SIGN_STATE | CHAR | 1 | SIGN_STATE |
Key field | Non-key field |
How do I retrieve data from SAP structure QASPR using ABAP code?
As QASPR 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 QASPR as there is no data to select.How to access SAP table QASPR
Within an ECC or HANA version of SAP you can also view further information about QASPR 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