OIISOCTSS

Transparent Table Application Table
14 Fields 1 CDS Views

SOC: time dependent assignment SO <-> SO (IS-Oil BDRP)

OIISOCTSS is an SAP database table in S/4HANA. SOC: time dependent assignment SO <-> SO (IS-Oil BDRP). It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_OIL_StorageObjCharcAssgmtBsc view_entity from BASIC SOC Assignment

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY socnr OII_SOCNR SOCSEG number
KEY ftmstm OII_FTMSTM From timestamp
ttmstm OII_TTMSTM To timestamp
socnrx OII_SOCNR SOCSEG number
socgrp OII_SOCGRP SO Group ID
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 <-> SO (IS-Oil BDRP)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIISOCTSS (
    MANDT,   -- Client [MANDT]
    SOCNR,   -- SOCSEG number [OII_SOCNR]
    FTMSTM,  -- From timestamp [OII_FTMSTM]
    TTMSTM,  -- To timestamp [OII_TTMSTM]
    SOCNRX,  -- SOCSEG number [OII_SOCNR]
    SOCGRP,  -- SO Group ID [OII_SOCGRP]
    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)
);

Learn More