OIISOCO1

Transparent Table Application Table
28 Fields 2 CDS Views

SOC: Storage object characteristic segment: bulk

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OIL_StorObjCharcSegmentSilo view_entity from BASIC Storage Obj Characteristic Segment Silo
I_SiloTankMatlAssign view left_outer BASIC CDS for Tank Master Data

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY socnr OII_SOCNR SOCSEG number
lvc_meth OII_LVC_METH LVC method
cali_hist OII_CALI_HIST Cal.history
slvnr OII_SLVNRO LVC set number
slvind OII_SLVIND Recal.index
valfrom OII_FTMSTM From timestamp
maxin OII_MAXIN Max. inflow
maxout OII_MAXOUT Max. outflow
waskz OII_WASKZ Max.contam.qty.
waspc OII_WASPC Max.contam. %
gflag OII_GFLAG Below ground
hflag OII_HFLAG Tank is heated
azeit OII_AZEIT Sp.allow.time
expacorr OII_EXPACORR Tank exp.corr
roofcorr OII_ROOFCORR Fl.roof corr.
watrcorr OII_WATRCORR Water corr.
ul_in_ind OII_UL_IN_IND Innage/ullage
iso_shell OII_ISO_SHELL Insulated shell
mult_tape OII_MULT_TAPE Multiple tapes
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 OIISOCO1 (
    MANDT,      -- Client [MANDT]
    SOCNR,      -- SOCSEG number [OII_SOCNR]
    LVC_METH,   -- LVC method [OII_LVC_METH]
    CALI_HIST,  -- Cal.history [OII_CALI_HIST]
    SLVNR,      -- LVC set number [OII_SLVNRO]
    SLVIND,     -- Recal.index [OII_SLVIND]
    VALFROM,    -- From timestamp [OII_FTMSTM]
    MAXIN,      -- Max. inflow [OII_MAXIN]
    MAXOUT,     -- Max. outflow [OII_MAXOUT]
    WASKZ,      -- Max.contam.qty. [OII_WASKZ]
    WASPC,      -- Max.contam. % [OII_WASPC]
    GFLAG,      -- Below ground [OII_GFLAG]
    HFLAG,      -- Tank is heated [OII_HFLAG]
    AZEIT,      -- Sp.allow.time [OII_AZEIT]
    EXPACORR,   -- Tank exp.corr [OII_EXPACORR]
    ROOFCORR,   -- Fl.roof corr. [OII_ROOFCORR]
    WATRCORR,   -- Water corr. [OII_WATRCORR]
    UL_IN_IND,  -- Innage/ullage [OII_UL_IN_IND]
    ISO_SHELL,  -- Insulated shell [OII_ISO_SHELL]
    MULT_TAPE,  -- Multiple tapes [OII_MULT_TAPE]
    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