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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 |