SAP table QAES (Sample unit table)

SAP table QAES has 3 primary key fields being MANDANT,PRUEFLOS,ESTUECKNR.

Field Description Data Type Length Decimals Checktable Data Element
MANDANT Client CLNT 3 0 T000 MANDT
PRUEFLOS Inspection Lot Number NUMC 12 0 QALS QPLOS
ESTUECKNR Number of Single Unit in Inspection Lot NUMC 4 0 QESTUECKNR
EQUNR Equipment Number CHAR 18 0 EQUI EQUNR
SERIALNR Single-Unit Number for the Unit to Be Inspected CHAR 18 0 QSERIALNR

QAES foreign key relationships

Table Field Check Table Check Field
0 QAES EQUNR EQUI Equipment master data MANDT
1 QAES MANDANT T000 Clients MANDT
0 QAES PRUEFLOS QALS Inspection lot record MANDANT