OIISOCTSM

Transparent Table Application Table
28 Fields 3 CDS Views

SOC: time dependent assignment SO <-> material (IS-Oil BDR

OIISOCTSM is an SAP database table in S/4HANA. SOC: time dependent assignment SO <-> material (IS-Oil BDR. It contains 28 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_OIL_StorObjectCharcMatlBasic view_entity from BASIC SOC Material
I_TicketTankSqncNoVH view inner BASIC Tank Sequence Number Value Help
I_TimeDepdntMatlAssign view from BASIC Time Dependent Material assignment to SOC

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY socnr OII_SOCNR SOCSEG number
KEY ftmstm OII_FTMSTM From timestamp
KEY asscnt OII_ASSCNT Mat.assn.cntr.
ttmstm OII_TTMSTM To timestamp
matnr MATNR Material
matkl MATKL Material Group
charg CHARG_D Batch
bwtar BWTAR_D Valuation Type
bstar BSTAR Stock type
ns_stock OII_NS_STOCK Non-special stk
so_stock OII_SO_STOCK Sales ord.stock
vc_stock OII_VC_STOCK Vdr.consg.stock
pr_stock OII_PR_STOCK Project stock
meins MEINS Base Unit
uomgr OIB_UOMGR UoM Group
umrsl OIB_UMRSL Conv. Group
kapaz_ind OII_KAPAZ_IND PldCapacity
volun OII_VOLUN Volume UoM
pld_ttmstm OII_PLD_TTMSTM To timestamp
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: time dependent assignment SO <-> material (IS-Oil BDR
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIISOCTSM (
    MANDT,       -- Client [MANDT]
    SOCNR,       -- SOCSEG number [OII_SOCNR]
    FTMSTM,      -- From timestamp [OII_FTMSTM]
    ASSCNT,      -- Mat.assn.cntr. [OII_ASSCNT]
    TTMSTM,      -- To timestamp [OII_TTMSTM]
    MATNR,       -- Material [MATNR]
    MATKL,       -- Material Group [MATKL]
    CHARG,       -- Batch [CHARG_D]
    BWTAR,       -- Valuation Type [BWTAR_D]
    BSTAR,       -- Stock type [BSTAR]
    NS_STOCK,    -- Non-special stk [OII_NS_STOCK]
    SO_STOCK,    -- Sales ord.stock [OII_SO_STOCK]
    VC_STOCK,    -- Vdr.consg.stock [OII_VC_STOCK]
    PR_STOCK,    -- Project stock [OII_PR_STOCK]
    MEINS,       -- Base Unit [MEINS]
    UOMGR,       -- UoM Group [OIB_UOMGR]
    UMRSL,       -- Conv. Group [OIB_UMRSL]
    KAPAZ_IND,   -- PldCapacity [OII_KAPAZ_IND]
    VOLUN,       -- Volume UoM [OII_VOLUN]
    PLD_TTMSTM,  -- To timestamp [OII_PLD_TTMSTM]
    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, FTMSTM, ASSCNT)
);

Learn More