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