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