SAP Table QAREL

Assignment table for dependent characteristics

QAREL (Assignment table for dependent characteristics) 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 QAREL to other SAP tables.

QAREL table fields

Field Data element Checktable Datatype Length Decimals
VORGLFNR Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
LEITMERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
ABHMERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
MARK Selection Field QMARK CHAR 1 0
NULL Indicator is not set
X Indicator is set
ABHSTATUS Results Record Status QBEASTATUS TQ76 CHAR 1 0
ABHKURZTXT Short Text for Inspection Characteristic QTXT_CHA CHAR 40 0
LEITSTATUS Results Record Status QBEASTATUS TQ76 CHAR 1 0
LEITBEWETG Inspection Result Valuation QMBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
LZEITKZ Long-Term Inspection QLZEITKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MERKMALKZ X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
PROBENKZ X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
URWERTEKZ X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FORMELKZ X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
BEDMERKKZ X and Blank QKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set

QAREL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAREL ABHSTATUS QAREL ABHSTATUS TQ76 Processing status of inspection characteristics STATUS
QAREL LEITSTATUS QAREL LEITSTATUS TQ76 Processing status of inspection characteristics STATUS