1. Home
  2. Resources
  3. SAP Tables
  4. QAMB - QM: Link Between Inspection Lot and Material Document

SAP Table QAMB

QM: Link Between Inspection Lot and Material Document

QAMB (QM: Link Between Inspection Lot and Material Document) 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 QAMB to other SAP tables.

QAMB table fields

Field Data element Checktable Datatype Length Decimals
MANDANT Client MANDT T000 CLNT 3 0
PRUEFLOS Inspection Lot Number QPLOS QALS NUMC 12 0
ZAEHLER Internal Counter for DB Objects Q_COUNT NUMC 6 0
TYP Type of Reference Between Inspection Lot and Material Doc. QAMBTYPE CHAR 1 0
NULL Material documents from UD posting or qty correction
1 Material documents for lot creation
2 Material documents for correcting an actual qty
3 Material documents for a usage decision transfer posting
4 Material docs. for stock transfer of the insp. lot Q stock
5 Material doc. for follow-up delivs. after stock credit entry
6 Canceled material docs for lot creation/follow-up delivery
7 Canceled material docs for usage decision transfer posting
X Material Documents for QM Inventory
MBLNR Number of Material Document MBLNR MKPF CHAR 10 0
MJAHR Material Document Year MJAHR MKPF NUMC 4 0
ZEILE Item in Material Document MBLPO MSEG NUMC 4 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0

QAMB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QAMB MANDANT QAMB MANDANT T000 Clients MANDT
QAMB MBLNR QAMB MANDANT MKPF Header: Material Document MANDT
QAMB MBLNR QAMB MBLNR MKPF Header: Material Document MBLNR
QAMB MBLNR QAMB MJAHR MKPF Header: Material Document MJAHR
QAMB MJAHR QAMB MANDANT MKPF Header: Material Document MANDT
QAMB MJAHR QAMB MBLNR MKPF Header: Material Document MBLNR
QAMB MJAHR QAMB MJAHR MKPF Header: Material Document MJAHR
QAMB PRUEFLOS QAMB PRUEFLOS QALS Inspection lot record PRUEFLOS
QAMB PRUEFLOS QAMB MANDANT QALS Inspection lot record MANDANT
QAMB ZEILE QAMB MANDANT MSEG Document Segment: Material MANDT
QAMB ZEILE QAMB MBLNR MSEG Document Segment: Material MBLNR
QAMB ZEILE QAMB MJAHR MSEG Document Segment: Material MJAHR
QAMB ZEILE QAMB ZEILE MSEG Document Segment: Material ZEILE