SER07

Transparent Table Application Table
12 Fields 3 CDS Views

Document Header for Serial Numbers in Physical Inventory

SER07 is an SAP database table in S/4HANA. Document Header for Serial Numbers in Physical Inventory. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaintItmObjListPhysInventory view from BASIC Maintenance Item Object List Physical Inventory
I_MaintObjListPhysInventoryDoc view_entity from BASIC Maint Object List in Phys Inventory Doc
I_SerialNmbrPhysicalInvtry view from BASIC Serial Number Phys Invtry doc

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY obknr objknr Object list
iblnr iblnr Phys. Inv. Doc.
zeili dzeile Item
mjahr gjahr Fiscal Year
oltpi oltpi OL feat. inventory
werk werks_d Plant
lagerort lgort_d Location
charge charg_d Batch
bstar i_bstar Stock Type
anzsn anzsn No.serial no.
datum datum Date

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 in Physical Inventory
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SER07 (
    MANDT,     -- Client [mandt]
    OBKNR,     -- Object list [objknr]
    IBLNR,     -- Phys. Inv. Doc. [iblnr]
    ZEILI,     -- Item [dzeile]
    MJAHR,     -- Fiscal Year [gjahr]
    OLTPI,     -- OL feat. inventory [oltpi]
    WERK,      -- Plant [werks_d]
    LAGERORT,  -- Location [lgort_d]
    CHARGE,    -- Batch [charg_d]
    BSTAR,     -- Stock Type [i_bstar]
    ANZSN,     -- No.serial no. [anzsn]
    DATUM,     -- Date [datum]
    PRIMARY KEY (MANDT, OBKNR)
);

Learn More