TE271

Transparent Table Application Table
46 Fields 1 CDS Views

Sample Lot

TE271 is an SAP database table in S/4HANA. Sample Lot. It contains 46 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_UtilsDeviceSampleLot view from BASIC Device Sample Lot

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY los LOS Lot
losext LOSEXT Off. lot number
loserst LOSERST 1st samp. insp.
losok LOSOK Lot status
losfaell LOSFAELL Next due year
sparte SPARTE Division
bglkz BGLKZ Certific. req.
startz1 STARTZ1 1st st. access
loslag LOSLAG Dev. in wareh.
losanzg LOSANZG Lot size
losdat LOSDAT Determin. date
startd1 STARTD1 1st drawing on
losamt LOSAMT Lot category
startz2 STARTZ2 2nd start acc.
startd2 STARTD2 2nd drawing on
lagerinc1 LAGERINC Devs n. instld
lagerinc2 LAGERINC Devs n. instld
loszumd LOSZUMD Compiled on
losaufd LOSAUFD Termin. date
losaufj LOSAUFJ Per. repl. year
verfahren VERFAHREN Single drawing
emesswerk EMESSWERK Elect. register
losaufn AENDNAM Changed by
erdat ERDAT Created On
ernam ERNAM Created By
aedat AEDAT Changed On
aenam AENAM Changed By
begru BEGRU AuthorizGroup
loevm LOEVM Delete
kz_lot_cnt_proz KZ_LOT_CNT_PROZ SD percentage
pruefanz_perc_p1 PRUEFANZ_PERC_P1 SDs in percent
pruefanz_perc_r1 PRUEFANZ_PERC_R1 Spare devs in %
pruefanz_perc_p2 PRUEFANZ_PERC_P2 Samp. devs in %
pruefanz_perc_r2 PRUEFANZ_PERC_R2 Spare devs in %
dest_lot DEST_LOT Target Lot
lot_merge_compl LOT_MERGE_COMPLETE Merge Complete
sample_type SAMPLE_TYPE Procedure Type
startd3 STARTD3 3rd Drawing
startd4 STARTD4 4th Drawing
startd5 STARTD5 5th Drawing
seed1 SEED1 StartVal. 1
seed2 SEED2 StartVal. 2
seed3 SEED3 StartVal. 3
seed4 SEED4 StartVal. 4
seed5 SEED5 StartVal. 5

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.

-- Sample Lot
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TE271 (
    MANDT,             -- Client [MANDT]
    LOS,               -- Lot [LOS]
    LOSEXT,            -- Off. lot number [LOSEXT]
    LOSERST,           -- 1st samp. insp. [LOSERST]
    LOSOK,             -- Lot status [LOSOK]
    LOSFAELL,          -- Next due year [LOSFAELL]
    SPARTE,            -- Division [SPARTE]
    BGLKZ,             -- Certific. req. [BGLKZ]
    STARTZ1,           -- 1st st. access [STARTZ1]
    LOSLAG,            -- Dev. in wareh. [LOSLAG]
    LOSANZG,           -- Lot size [LOSANZG]
    LOSDAT,            -- Determin. date [LOSDAT]
    STARTD1,           -- 1st drawing on [STARTD1]
    LOSAMT,            -- Lot category [LOSAMT]
    STARTZ2,           -- 2nd start acc. [STARTZ2]
    STARTD2,           -- 2nd drawing on [STARTD2]
    LAGERINC1,         -- Devs n. instld [LAGERINC]
    LAGERINC2,         -- Devs n. instld [LAGERINC]
    LOSZUMD,           -- Compiled on [LOSZUMD]
    LOSAUFD,           -- Termin. date [LOSAUFD]
    LOSAUFJ,           -- Per. repl. year [LOSAUFJ]
    VERFAHREN,         -- Single drawing [VERFAHREN]
    EMESSWERK,         -- Elect. register [EMESSWERK]
    LOSAUFN,           -- Changed by [AENDNAM]
    ERDAT,             -- Created On [ERDAT]
    ERNAM,             -- Created By [ERNAM]
    AEDAT,             -- Changed On [AEDAT]
    AENAM,             -- Changed By [AENAM]
    BEGRU,             -- AuthorizGroup [BEGRU]
    LOEVM,             -- Delete [LOEVM]
    KZ_LOT_CNT_PROZ,   -- SD percentage [KZ_LOT_CNT_PROZ]
    PRUEFANZ_PERC_P1,  -- SDs in percent [PRUEFANZ_PERC_P1]
    PRUEFANZ_PERC_R1,  -- Spare devs in % [PRUEFANZ_PERC_R1]
    PRUEFANZ_PERC_P2,  -- Samp. devs in % [PRUEFANZ_PERC_P2]
    PRUEFANZ_PERC_R2,  -- Spare devs in % [PRUEFANZ_PERC_R2]
    DEST_LOT,          -- Target Lot [DEST_LOT]
    LOT_MERGE_COMPL,   -- Merge Complete [LOT_MERGE_COMPLETE]
    SAMPLE_TYPE,       -- Procedure Type [SAMPLE_TYPE]
    STARTD3,           -- 3rd Drawing [STARTD3]
    STARTD4,           -- 4th Drawing [STARTD4]
    STARTD5,           -- 5th Drawing [STARTD5]
    SEED1,             -- StartVal. 1 [SEED1]
    SEED2,             -- StartVal. 2 [SEED2]
    SEED3,             -- StartVal. 3 [SEED3]
    SEED4,             -- StartVal. 4 [SEED4]
    SEED5,             -- StartVal. 5 [SEED5]
    PRIMARY KEY (MANDT, LOS)
);

Learn More