QALT

Transparent Table Application Table
27 Fields 2 CDS Views

Partial lot

QALT is an SAP database table in S/4HANA. Partial lot. It contains 27 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InspectionPartialLot view from EXTENSION Inspection Partial Lot Extension
I_InspectionPartialLot view_entity from BASIC Partial Inspection Lot

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandant mandt Client
KEY prueflos qplos Inspection Lot
KEY teillos qtlos Partial Lot
objnr j_objnr Object number
ls_posnr posnr_vl Item
matnr matnr Material
charg charg_d Batch
lagortchrg lgort_d Location
mengeneinh qlosmengeh Base Unit
menge qmengetlos Partial Lot Qty
mengeist qlmengeist Actual Lot Qty
ktexttlos qtxttl Short Text
ltextkz qltexttlos Long text
pruefer qpruefer Inspector
enstehdat qentst Lot Created
enstehzeit qzeitenste Time
ersteller ernam Created By
ersteldat qdatumerst Created On
erstelzeit qzeiterstl Time
aenderer aenam Changed By
aenderdat qdatumaend Changed On
aenderzeit qzeitaend Time
no_insppoint qtls_no_insppoint no Insp.Point
partial_lot_guid qalt_guid Partial Lot ID
vfdat vfdat SLED/BBD
qalt_alt_quantity qalt_alt_quantity Part. Lot Altern. Qu
qalt_alt_unit qalt_alt_unit Parti. Lot Alt. Unit

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Partial lot
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE QALT (
    MANDANT,            -- Client [mandt]
    PRUEFLOS,           -- Inspection Lot [qplos]
    TEILLOS,            -- Partial Lot [qtlos]
    OBJNR,              -- Object number [j_objnr]
    LS_POSNR,           -- Item [posnr_vl]
    MATNR,              -- Material [matnr]
    CHARG,              -- Batch [charg_d]
    LAGORTCHRG,         -- Location [lgort_d]
    MENGENEINH,         -- Base Unit [qlosmengeh]
    MENGE,              -- Partial Lot Qty [qmengetlos]
    MENGEIST,           -- Actual Lot Qty [qlmengeist]
    KTEXTTLOS,          -- Short Text [qtxttl]
    LTEXTKZ,            -- Long text [qltexttlos]
    PRUEFER,            -- Inspector [qpruefer]
    ENSTEHDAT,          -- Lot Created [qentst]
    ENSTEHZEIT,         -- Time [qzeitenste]
    ERSTELLER,          -- Created By [ernam]
    ERSTELDAT,          -- Created On [qdatumerst]
    ERSTELZEIT,         -- Time [qzeiterstl]
    AENDERER,           -- Changed By [aenam]
    AENDERDAT,          -- Changed On [qdatumaend]
    AENDERZEIT,         -- Time [qzeitaend]
    NO_INSPPOINT,       -- no Insp.Point [qtls_no_insppoint]
    PARTIAL_LOT_GUID,   -- Partial Lot ID [qalt_guid]
    VFDAT,              -- SLED/BBD [vfdat]
    QALT_ALT_QUANTITY,  -- Part. Lot Altern. Qu [qalt_alt_quantity]
    QALT_ALT_UNIT,      -- Parti. Lot Alt. Unit [qalt_alt_unit]
    PRIMARY KEY (MANDANT, PRUEFLOS, TEILLOS)
);

Learn More