OIISOCB1

Transparent Table Application Table
23 Fields 1 CDS Views

SOC: Storage object characteristic segment: bulk

OIISOCB1 is an SAP database table in S/4HANA. SOC: Storage object characteristic segment: bulk. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_StorObjCharcSegmentBulk view_entity from BASIC Storage Obj Characteristic Segment Bulk

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY socnr OII_SOCNR SOCSEG number
slvnr OII_SLVNR LVC set number
maxdp OII_MAXDP Maximum dip
mindp OII_MINDP Minimum dip
maxin OII_MAXIN Max. inflow
maxout OII_MAXOUT Max. outflow
unpkz OII_UNPKZ Unp.qty.
unppc OII_UNPPC Unp.qty. %
waskz OII_WASKZ Max.contam.qty.
waspc OII_WASPC Max.contam. %
flmas OII_FLMAS Foat. roof w.
gflag OII_GFLAG Below ground
hflag OII_HFLAG Tank is heated
azeit OII_AZEIT Sp.allow.time
erdat OII_ERDAT Date created
erzeit OII_ERZEIT Time created
ernam OII_ERNAM Created by
aedat OII_AEDAT Date changed
aezeit OII_AEZEIT Time changed
aenam OII_AENAM Changed by
bloind OII_BLOIND Blocking ind.
delind OII_DELIND Deletion ind.

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.

-- SOC: Storage object characteristic segment: bulk
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIISOCB1 (
    MANDT,   -- Client [MANDT]
    SOCNR,   -- SOCSEG number [OII_SOCNR]
    SLVNR,   -- LVC set number [OII_SLVNR]
    MAXDP,   -- Maximum dip [OII_MAXDP]
    MINDP,   -- Minimum dip [OII_MINDP]
    MAXIN,   -- Max. inflow [OII_MAXIN]
    MAXOUT,  -- Max. outflow [OII_MAXOUT]
    UNPKZ,   -- Unp.qty. [OII_UNPKZ]
    UNPPC,   -- Unp.qty. % [OII_UNPPC]
    WASKZ,   -- Max.contam.qty. [OII_WASKZ]
    WASPC,   -- Max.contam. % [OII_WASPC]
    FLMAS,   -- Foat. roof w. [OII_FLMAS]
    GFLAG,   -- Below ground [OII_GFLAG]
    HFLAG,   -- Tank is heated [OII_HFLAG]
    AZEIT,   -- Sp.allow.time [OII_AZEIT]
    ERDAT,   -- Date created [OII_ERDAT]
    ERZEIT,  -- Time created [OII_ERZEIT]
    ERNAM,   -- Created by [OII_ERNAM]
    AEDAT,   -- Date changed [OII_AEDAT]
    AEZEIT,  -- Time changed [OII_AEZEIT]
    AENAM,   -- Changed by [OII_AENAM]
    BLOIND,  -- Blocking ind. [OII_BLOIND]
    DELIND,  -- Deletion ind. [OII_DELIND]
    PRIMARY KEY (MANDT, SOCNR)
);

Learn More