OIISOCK

Transparent Table Application Table
39 Fields 2 CDS Views

SOC: Storage object characteristic segment header

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_OIL_StorageObjCharcSegment view_entity from BASIC Storage Object Characteristic Segment
I_SiloTankMatlAssign view left_outer BASIC CDS for Tank Master Data

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY socnr OII_SOCNR SOCSEG number
objnr J_OBJNR Object number
socam OII_SOCAM Access mode
sockl OII_SOCKL SOC class
soctyp OII_SOCTYP Stor.obj.type
equnr OII_EQUNR Equipment
tplnr OII_TPLNR Funct.location
herst OII_HERST Manufacturer
herld OII_HERLD Mnf. Cntry/Regn
hzein OII_SHZEIN Drawing no.
serge OII_SSERGE Mnf.serial no.
typbz OII_STYPBZ Model number
baujj OII_SBAUJJ ConstructYear
baumm OII_SBAUMM ConstructMth
volun OII_VOLUN Volume UoM
masun OII_MASUN UoM mass
lenun OII_LENUN Length UoM
frtun OII_FRTUN UoM flow rate
timun OII_TIMUN UoM time
tmpun OII_TMPUN UoM Temp
dnsun OII_DNSUN Density UoM
spvun OII_SPVUN Vol/height UoM
dntyp OIB_DNTYP Dens. Type
kapaz OII_KAPAZ Max. capacity
mxmas OII_MXMAS Max.safety wgt.
gxdat OII_GXDAT Expiry date
gxtim OII_GXTIM Expiry time
gxrea OII_GXREA Expiry reason
sogrp OII_SOGRP SO is group
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.
st_gauge_rt OIJ_STOP_GAUGE_RT Stp Gauge Routine

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 header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIISOCK (
    MANDT,        -- Client [MANDT]
    SOCNR,        -- SOCSEG number [OII_SOCNR]
    OBJNR,        -- Object number [J_OBJNR]
    SOCAM,        -- Access mode [OII_SOCAM]
    SOCKL,        -- SOC class [OII_SOCKL]
    SOCTYP,       -- Stor.obj.type [OII_SOCTYP]
    EQUNR,        -- Equipment [OII_EQUNR]
    TPLNR,        -- Funct.location [OII_TPLNR]
    HERST,        -- Manufacturer [OII_HERST]
    HERLD,        -- Mnf. Cntry/Regn [OII_HERLD]
    HZEIN,        -- Drawing no. [OII_SHZEIN]
    SERGE,        -- Mnf.serial no. [OII_SSERGE]
    TYPBZ,        -- Model number [OII_STYPBZ]
    BAUJJ,        -- ConstructYear [OII_SBAUJJ]
    BAUMM,        -- ConstructMth [OII_SBAUMM]
    VOLUN,        -- Volume UoM [OII_VOLUN]
    MASUN,        -- UoM mass [OII_MASUN]
    LENUN,        -- Length UoM [OII_LENUN]
    FRTUN,        -- UoM flow rate [OII_FRTUN]
    TIMUN,        -- UoM time [OII_TIMUN]
    TMPUN,        -- UoM Temp [OII_TMPUN]
    DNSUN,        -- Density UoM [OII_DNSUN]
    SPVUN,        -- Vol/height UoM [OII_SPVUN]
    DNTYP,        -- Dens. Type [OIB_DNTYP]
    KAPAZ,        -- Max. capacity [OII_KAPAZ]
    MXMAS,        -- Max.safety wgt. [OII_MXMAS]
    GXDAT,        -- Expiry date [OII_GXDAT]
    GXTIM,        -- Expiry time [OII_GXTIM]
    GXREA,        -- Expiry reason [OII_GXREA]
    SOGRP,        -- SO is group [OII_SOGRP]
    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]
    ST_GAUGE_RT,  -- Stp Gauge Routine [OIJ_STOP_GAUGE_RT]
    PRIMARY KEY (MANDT, SOCNR)
);

Learn More