SAP table QALT (Partial lot)
SAP table QALT has 3 primary key fields being MANDANT,PRUEFLOS,TEILLOS.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDANT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| PRUEFLOS | Inspection Lot Number | NUMC | 12 | 0 | QALS | QPLOS | |
| TEILLOS | Partial Lot Number | NUMC | 6 | 0 | QTLOS | ||
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |
| LS_POSNR | Delivery Item | NUMC | 6 | 0 | POSNR_VL | ||
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| CHARG | Batch Number | CHAR | 10 | 0 | MCH1 | CHARG_D | |
| LAGORTCHRG | Storage location | CHAR | 4 | 0 | T001L | LGORT_D | |
| MENGENEINH | Base Unit of Measure for Inspection Lot Quantity | UNIT | 3 | 0 | T006 | QLOSMENGEH | |
| MENGE | Partial Lot Quantity | QUAN | 13 | 3 | QMENGETLOS | ||
| MENGEIST | Actual Lot Quantity | QUAN | 13 | 3 | QLMENGEIST | ||
| KTEXTTLOS | Short Text for Partial Lot | CHAR | 40 | 0 | QTXTTL | ||
| LTEXTKZ | ID: Long text exists for partial lot | CHAR | 1 | 0 | QLTEXTTLOS | ||
| PRUEFER | Name of Inspector | CHAR | 12 | 0 | QPRUEFER | ||
| ENSTEHDAT | Date in Time Zone Where Lot Created | DATS | 8 | 0 | QENTST | ||
| ENSTEHZEIT | Time in Time Zone Where Partial Lot Was Created | TIMS | 6 | 0 | QZEITENSTE | ||
| ERSTELLER | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| ERSTELDAT | System Date on Which Data Record Was Created | DATS | 8 | 0 | QDATUMERST | ||
| ERSTELZEIT | System Time at Which Data Record Was Created | TIMS | 6 | 0 | QZEITERSTL | ||
| AENDERER | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| AENDERDAT | System Date on Which Data Record Was Changed | DATS | 8 | 0 | QDATUMAEND | ||
| AENDERZEIT | System Time at Which Data Record Was Changed | TIMS | 6 | 0 | QZEITAEND | ||
| NO_INSPPOINT | Flag Partial Lot has no Inspection Point and Specifications | CHAR | 1 | 0 | QTLS_NO_INSPPOINT | ||
| PARTIAL_LOT_GUID | Internal Identification for Partial Lot | RAW | 16 | 0 | QALT_GUID | ||
| VFDAT | Shelf Life Expiration or Best-Before Date | DATS | 8 | 0 | VFDAT | ||
| QALT_ALT_QUANTITY | Partial Lot Alternative Quantity | QUAN | 13 | 3 | QALT_ALT_QUANTITY | ||
| QALT_ALT_UNIT | Partial Lot Alternative Quantity Unit | UNIT | 3 | 0 | QALT_ALT_UNIT | ||
| STOCK_PARENT_GUID | Parent GUID | RAW | 16 | 0 | /LIME/GUID_PARENT | ||
| STOCK_ITEM_GUID | GUID Stock Item | RAW | 16 | 0 | /LIME/GUID_STOCK | ||
| EXCCODE | Exception Code | CHAR | 4 | 0 | * | /SCWM/DE_EXCCODE | |
| HU_DESTINATION | Destination Handling Unit | CHAR | 20 | 0 | /SCWM/DE_DESHU | ||
| CWQUAN | Valuation Quantity | QUAN | 31 | 14 | /SCWM/DE_CWQUAN | ||
| CWUNIT | Unit for Valuation Quantity | UNIT | 3 | 0 | /SCWM/DE_CWUNIT | ||
| CWEXACT | Status of Valuation Quantity | CHAR | 1 | 0 | /SCWM/DE_CWEXACT |
QALT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QALT | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| 1 QALT | LAGORTCHRG | T001L | Storage Locations | MANDT |
| 1 QALT | LAGORTCHRG | T001L | Storage Locations | WERKS |
| 0 QALT | MANDANT | T000 | Clients | MANDT |
| 1 QALT | MATNR | MARA | General Material Data | MATNR |
| 0 QALT | MENGENEINH | T006 | Units of Measurement | MSEHI |
| 1 QALT | OBJNR | ONR00 | General Object Number | MANDT |
| 0 QALT | PRUEFLOS | QALS | Inspection lot record | MANDANT |