SER02

Transparent Table Application Table
12 Fields 3 CDS Views

Document Header for Serial Nos for Maint.Contract (SD Order)

SER02 is an SAP database table in S/4HANA. Document Header for Serial Nos for Maint.Contract (SD Order). It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaintItmObjListSalesOrder view from BASIC Maintenance Item Object List Sales Order
I_MaintObjListSalesOrder view_entity from BASIC Maintenance Object List in Sales Order
I_SerialNmbrSalesOrder view from BASIC Serial Number Sales Order

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY obknr objknr Object list
sdaufnr vbeln_va Sales Document
posnr posnr_va Item
datum datum Date
letznr obzae Obj.Ctr
kunde kunde_d Partner
anzsn anzsn No.serial no.
vorgang beleg SerialProcedure
vbtyp vbtypl Document Cat.
sd_auart auart Sales Doc. Type
sd_postyp pstyv Item Category

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.

-- Document Header for Serial Nos for Maint.Contract (SD Order)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SER02 (
    MANDT,      -- Client [mandt]
    OBKNR,      -- Object list [objknr]
    SDAUFNR,    -- Sales Document [vbeln_va]
    POSNR,      -- Item [posnr_va]
    DATUM,      -- Date [datum]
    LETZNR,     -- Obj.Ctr [obzae]
    KUNDE,      -- Partner [kunde_d]
    ANZSN,      -- No.serial no. [anzsn]
    VORGANG,    -- SerialProcedure [beleg]
    VBTYP,      -- Document Cat. [vbtypl]
    SD_AUART,   -- Sales Doc. Type [auart]
    SD_POSTYP,  -- Item Category [pstyv]
    PRIMARY KEY (MANDT, OBKNR)
);

Learn More