OIISOCKL

Transparent Table Customizing Table
22 Fields 1 CDS Views

SOC: Storage object characteristic class

OIISOCKL is an SAP database table in S/4HANA. SOC: Storage object characteristic class. It contains 22 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_StorObjectCharcClassVH view_entity from BASIC Storage Object Characteristic Class

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY sockl OII_SOCKL SOC class
socusg OII_SOCUSG Usg.indicator
socapp1 OII_SOCAP1 Appl.flag: O&G
socapp2 OII_SOCAP2 ApplFl:Retail
socapp3 OII_SOCAP3 ApplFl SP.1
socapp4 OII_SOCAP4 ApplFl SP.2
soclvconv OII_SOCLV L/V Conversion
soclvmasterfill OII_SOCLVMASTERFILL V/SpV fill
soclvmastercalc OII_SOCLVMASTERCALC V/SpV calc
soc_unp_quan OII_SOC_UNPQUAN UnpQuLnk
soc_kapaz OII_SOC_KAPAZ Capactiy link
soc_rdggrp OII_SOC_RDGRP Tank rd.grp
soc_ft_msehi OII_SOC_FT_MSEHI FtDisUoM
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 class
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIISOCKL (
    MANDT,            -- Client [MANDT]
    SOCKL,            -- SOC class [OII_SOCKL]
    SOCUSG,           -- Usg.indicator [OII_SOCUSG]
    SOCAPP1,          -- Appl.flag: O&G [OII_SOCAP1]
    SOCAPP2,          -- ApplFl:Retail [OII_SOCAP2]
    SOCAPP3,          -- ApplFl SP.1 [OII_SOCAP3]
    SOCAPP4,          -- ApplFl SP.2 [OII_SOCAP4]
    SOCLVCONV,        -- L/V Conversion [OII_SOCLV]
    SOCLVMASTERFILL,  -- V/SpV fill [OII_SOCLVMASTERFILL]
    SOCLVMASTERCALC,  -- V/SpV calc [OII_SOCLVMASTERCALC]
    SOC_UNP_QUAN,     -- UnpQuLnk [OII_SOC_UNPQUAN]
    SOC_KAPAZ,        -- Capactiy link [OII_SOC_KAPAZ]
    SOC_RDGGRP,       -- Tank rd.grp [OII_SOC_RDGRP]
    SOC_FT_MSEHI,     -- FtDisUoM [OII_SOC_FT_MSEHI]
    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, SOCKL)
);

Learn More