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