SAP Table QALT

Partial lot

QALT (Partial lot) 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 QALT to other SAP tables.

QALT 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
TEILLOS Partial lot number QTLOS NUMC 6 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
LS_POSNR Delivery Item POSNR_VL VBUP NUMC 6 0
MATNR Material Number MATNR MARA CHAR 18 0
CHARG Batch Number CHARG_D MCH1 CHAR 10 0
LAGORTCHRG Storage Location LGORT_D T001L CHAR 4 0
MENGENEINH Base Unit of Measure for The Inspection Lot Quantity QLOSMENGEH T006 UNIT 3 0
MENGE Partial lot quantity QMENGETLOS QUAN 13 3
MENGEIST Actual Lot Quantity QLMENGEIST QUAN 13 3
KTEXTTLOS Short Text for Partial Lot QTXTTL CHAR 40 0
LTEXTKZ ID: Long text exists for partial lot QLTEXTTLOS CHAR 1 0
NULL Indicator is not set
X Indicator is set
PRUEFER Name of the Inspector QPRUEFER CHAR 12 0
ENSTEHDAT Date of Lot Creation QENTST DATS 8 0
ENSTEHZEIT Time at which partial lot was created QZEITENSTE TIMS 6 0
ERSTELLER Name of Person who Created the Object ERNAM CHAR 12 0
ERSTELDAT Date on Which Record Was Created ERDAT DATS 8 0
ERSTELZEIT Time at which data record was created QZEITERSTL TIMS 6 0
AENDERER Name of Person Who Changed Object AENAM CHAR 12 0
AENDERDAT Changed On AEDAT DATS 8 0
AENDERZEIT Time at which data record was last changed QZEITAEND TIMS 6 0

QALT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QALT CHARG QALT MANDANT MCH1 Batches (if Batch Management Cross-Plant) MANDT
QALT CHARG QALS MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
QALT CHARG QALT CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
QALT LAGORTCHRG QALS WERK T001L Storage Locations WERKS
QALT LAGORTCHRG QALT LAGORTCHRG T001L Storage Locations LGORT
QALT LAGORTCHRG QALT MANDANT T001L Storage Locations MANDT
QALT LS_POSNR QALS LS_VBELN VBUP Sales Document: Item Status VBELN
QALT LS_POSNR QALT LS_POSNR VBUP Sales Document: Item Status POSNR
QALT LS_POSNR QALT MANDANT VBUP Sales Document: Item Status MANDT
QALT MANDANT QALT MANDANT T000 Clients MANDT
QALT MATNR QALT MANDANT MARA General Material Data MANDT
QALT MATNR QALT MATNR MARA General Material Data MATNR
QALT MENGENEINH QALT MANDANT T006 Units of Measurement MANDT
QALT MENGENEINH QALT MENGENEINH T006 Units of Measurement MSEHI
QALT OBJNR QALT OBJNR ONR00 General Object Number OBJNR
QALT OBJNR QALT MANDANT ONR00 General Object Number MANDT
QALT PRUEFLOS QALT MANDANT QALS Inspection lot record MANDANT
QALT PRUEFLOS QALT PRUEFLOS QALS Inspection lot record PRUEFLOS