SER03

Transparent Table Application Table
18 Fields 3 CDS Views

Document Header for Serial Numbers for Goods Movements

SER03 is an SAP database table in S/4HANA. Document Header for Serial Numbers for Goods Movements. It contains 18 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaintItmObjListMaterialDoc view from BASIC Maintenance Item Object List Material Document
I_MaintObjListMaterialDocument view_entity from BASIC Maint Object List in Material Document
I_SerialNmbrMaterialDoc view from BASIC Serial Number Material Document

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY obknr OBJKNR Object list
mblnr MBLNR Material Doc.
mjahr MJAHR Mat. Doc. Year
zeile MBLPO Mat. Doc.Item
blart BLART Document Type
bwart BWART Movement Type
shkzg SHKZG Debit/Credit
datum DATUM Date
uzeit UZEIT Time
letznr OBZAE Obj.Ctr
anzsn ANZSN No.serial no.
vorgang BELEG SerialProcedure
lieferant ELIEF Vendor
kunde KUNNR Customer
werk WERKS_D Plant
lagerort LGORT_D Location
charge CHARG_D Batch

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 Numbers for Goods Movements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SER03 (
    MANDT,      -- Client [MANDT]
    OBKNR,      -- Object list [OBJKNR]
    MBLNR,      -- Material Doc. [MBLNR]
    MJAHR,      -- Mat. Doc. Year [MJAHR]
    ZEILE,      -- Mat. Doc.Item [MBLPO]
    BLART,      -- Document Type [BLART]
    BWART,      -- Movement Type [BWART]
    SHKZG,      -- Debit/Credit [SHKZG]
    DATUM,      -- Date [DATUM]
    UZEIT,      -- Time [UZEIT]
    LETZNR,     -- Obj.Ctr [OBZAE]
    ANZSN,      -- No.serial no. [ANZSN]
    VORGANG,    -- SerialProcedure [BELEG]
    LIEFERANT,  -- Vendor [ELIEF]
    KUNDE,      -- Customer [KUNNR]
    WERK,       -- Plant [WERKS_D]
    LAGERORT,   -- Location [LGORT_D]
    CHARGE,     -- Batch [CHARG_D]
    PRIMARY KEY (MANDT, OBKNR)
);

Learn More