SAP table QALTS (Selection table of partial lots in production)

Field Description Data Type Length Decimals Checktable Data Element
KZSEL X and Blank CHAR 1 0 QKZ
Indicator is not set
X Indicator is set
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 VBUP 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
VETEXT Short Text CHAR 40 0 QKURZTEXT

QALTS foreign key relationships

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