SER09

Transparent Table Application Table
13 Fields 3 CDS Views

Doc. Header for Serial Numbers for Purchase Requisition Item

SER09 is an SAP database table in S/4HANA. Doc. Header for Serial Numbers for Purchase Requisition Item. It contains 13 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_MaintItmObjListPurchaseReqn view from BASIC Maintenance Item Object List Purchase Requisition
I_MaintObjListPurchaseReqn view_entity from BASIC Maint Obj List in Purchase Requisition
I_SerialNmbrPurchaseReqn view from BASIC Serial Number Purchase Requisition

Fields (13)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY obknr OBJKNR Object list
banfn BANFN Purchase Req.
bnfpo BNFPO Requisn. item
etenr EETEN Schedule Line
bstyp BSTYP Doc. Category
bsart ESART Document Type
pstyp PSTYP Item Category
werk EWERK Plant
loekz ELOEK Del. Indicator
anzsn ANZSN No.serial no.
datum DATUM Date
serru SERRU Subcon. type

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.

-- Doc. Header for Serial Numbers for Purchase Requisition Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SER09 (
    MANDT,  -- Client [MANDT]
    OBKNR,  -- Object list [OBJKNR]
    BANFN,  -- Purchase Req. [BANFN]
    BNFPO,  -- Requisn. item [BNFPO]
    ETENR,  -- Schedule Line [EETEN]
    BSTYP,  -- Doc. Category [BSTYP]
    BSART,  -- Document Type [ESART]
    PSTYP,  -- Item Category [PSTYP]
    WERK,   -- Plant [EWERK]
    LOEKZ,  -- Del. Indicator [ELOEK]
    ANZSN,  -- No.serial no. [ANZSN]
    DATUM,  -- Date [DATUM]
    SERRU,  -- Subcon. type [SERRU]
    PRIMARY KEY (MANDT, OBKNR)
);

Learn More