- Home
- Resources
- SAP Tables
- QALTS - Selection table of partial lots in production
SAP Table QALTS
Selection table of partial lots in production
QALTS (Selection table of partial lots in production) 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 QALTS to other SAP tables.
Source: QALTS (Selection table of partial lots in production)
QALTS table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| KZSEL |
X and Blank |
QKZ |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Indicator is not set |
| X |
Indicator is set |
|
| 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 |
Possible values
| 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 |
|
| VETEXT |
Short Text |
QKURZTEXT |
|
CHAR |
|
40 |
0 |
|
QALTS foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| QALTS |
CHARG |
QALTS |
CHARG |
MCH1 |
Batches (if Batch Management Cross-Plant) |
CHARG |
| QALTS |
CHARG |
QALS |
MATNR |
MCH1 |
Batches (if Batch Management Cross-Plant) |
MATNR |
| QALTS |
CHARG |
QALTS |
MANDANT |
MCH1 |
Batches (if Batch Management Cross-Plant) |
MANDT |
| QALTS |
LAGORTCHRG |
QALTS |
MANDANT |
T001L |
Storage Locations |
MANDT |
| QALTS |
LAGORTCHRG |
QALS |
WERK |
T001L |
Storage Locations |
WERKS |
| QALTS |
LAGORTCHRG |
QALTS |
LAGORTCHRG |
T001L |
Storage Locations |
LGORT |
| QALTS |
LS_POSNR |
QALTS |
MANDANT |
VBUP |
Sales Document: Item Status |
MANDT |
| QALTS |
LS_POSNR |
QALS |
LS_VBELN |
VBUP |
Sales Document: Item Status |
VBELN |
| QALTS |
LS_POSNR |
QALTS |
LS_POSNR |
VBUP |
Sales Document: Item Status |
POSNR |
| QALTS |
MANDANT |
QALTS |
MANDANT |
T000 |
Clients |
MANDT |
| QALTS |
MATNR |
QALTS |
MANDANT |
MARA |
General Material Data |
MANDT |
| QALTS |
MATNR |
QALTS |
MATNR |
MARA |
General Material Data |
MATNR |
| QALTS |
MENGENEINH |
QALTS |
MENGENEINH |
T006 |
Units of Measurement |
MSEHI |
| QALTS |
MENGENEINH |
QALTS |
MANDANT |
T006 |
Units of Measurement |
MANDT |
| QALTS |
OBJNR |
QALTS |
OBJNR |
ONR00 |
General Object Number |
OBJNR |
| QALTS |
OBJNR |
QALTS |
MANDANT |
ONR00 |
General Object Number |
MANDT |
| QALTS |
PRUEFLOS |
QALTS |
PRUEFLOS |
QALS |
Inspection lot record |
PRUEFLOS |
| QALTS |
PRUEFLOS |
QALTS |
MANDANT |
QALS |
Inspection lot record |
MANDANT |
