TSERIAL

Transparent Table Customizing Table
9 Fields 3 CDS Views

Serial Number Profile

TSERIAL is an SAP database table in S/4HANA. Serial Number Profile. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/scmb/v_Tserial_entity view from S4: Serial Number Profile
C_Serialnumtemp view from CONSUMPTION Serial Number Profile View
I_EWM_SerialNumberProfile view from BASIC Serial Number Profile

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY serial cifserial Serial No. Prf.
prefix de_ser_prefix Ser. No. Prefix
nr_object nrobj Object name
nr_interval nrnr No. Range No.
numbering de_ser_numbering Numbering
stock de_ser_stock Ser. No. Reqmt
unit meins Base Unit
iuid_active de_iuid_active IUID Active

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.

-- Serial Number Profile
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TSERIAL (
    MANDT,        -- Client [mandt]
    SERIAL,       -- Serial No. Prf. [cifserial]
    PREFIX,       -- Ser. No. Prefix [de_ser_prefix]
    NR_OBJECT,    -- Object name [nrobj]
    NR_INTERVAL,  -- No. Range No. [nrnr]
    NUMBERING,    -- Numbering [de_ser_numbering]
    STOCK,        -- Ser. No. Reqmt [de_ser_stock]
    UNIT,         -- Base Unit [meins]
    IUID_ACTIVE,  -- IUID Active [de_iuid_active]
    PRIMARY KEY (MANDT, SERIAL)
);

Learn More