OIGSE

Transparent Table Application Table

TD Events

OIGSE is an SAP database table in S/4HANA. TD Events. It contains 34 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BulkShipmentEvent view from BASIC Bulk Shipment Event

Fields (34)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY shnumber OIG_SHNUM Bulk shipment
KEY event_nr OIG_EVNR Event number
type OIG_EVTYPE Event type
doc_type OIG_EVDCTY Document type
ev_seq OIG_EVSEQ Seq. number
doc_number OIG_ASGDOC Document no.
shitem OIG_SHITM Shipment item
status OIG_EVSTAT Event status
pstdtf OIG_PSTDTF PlndStartDateFr
psttmf OIG_PSTTMF PlndStTimeFrom
pstdtt OIG_PSTDTT PlndStartDateTo
psttmt OIG_PSTTMT PlndStTime-To
peddtf OIG_PEDDTF PlEndDateFr
pedtmf OIG_PEDTMF PlEndTimeFr
peddtt OIG_PEDDTT PlEndDateTo
pedtmt OIG_PEDTMT PlEndTimeTo
cre_name ERNAM Created By
cre_date ERDAT Created On
cre_time ERZET Time
cha_name AENAM Changed By
cha_date AEDAT Changed On
cha_time AEZET Time of change
astdtf OIG_ASTDTF Strt Date-From
asttmf OIG_ASTTMF Strt Time-From
astdtt OIG_ASTDTT Start Date-To
asttmt OIG_ASTTMT Start Time - To
aeddtf OIG_AEDDTF ActEndDateFr
aedtmf OIG_AEDTMF ActEndTimeFr
aeddtt OIG_AEDDTT ActEndDateTo
aedtmt OIG_AEDTMT ActEndTimeTo
defaulted OIG_FIELDS Field selection
veh_nr OIG_VEHNR Vehicle Seq. No
tsrfo TSRFO Seq.stage

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.

-- TD Events
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIGSE (
    CLIENT,      -- Client [MANDT]
    SHNUMBER,    -- Bulk shipment [OIG_SHNUM]
    EVENT_NR,    -- Event number [OIG_EVNR]
    TYPE,        -- Event type [OIG_EVTYPE]
    DOC_TYPE,    -- Document type [OIG_EVDCTY]
    EV_SEQ,      -- Seq. number [OIG_EVSEQ]
    DOC_NUMBER,  -- Document no. [OIG_ASGDOC]
    SHITEM,      -- Shipment item [OIG_SHITM]
    STATUS,      -- Event status [OIG_EVSTAT]
    PSTDTF,      -- PlndStartDateFr [OIG_PSTDTF]
    PSTTMF,      -- PlndStTimeFrom [OIG_PSTTMF]
    PSTDTT,      -- PlndStartDateTo [OIG_PSTDTT]
    PSTTMT,      -- PlndStTime-To [OIG_PSTTMT]
    PEDDTF,      -- PlEndDateFr [OIG_PEDDTF]
    PEDTMF,      -- PlEndTimeFr [OIG_PEDTMF]
    PEDDTT,      -- PlEndDateTo [OIG_PEDDTT]
    PEDTMT,      -- PlEndTimeTo [OIG_PEDTMT]
    CRE_NAME,    -- Created By [ERNAM]
    CRE_DATE,    -- Created On [ERDAT]
    CRE_TIME,    -- Time [ERZET]
    CHA_NAME,    -- Changed By [AENAM]
    CHA_DATE,    -- Changed On [AEDAT]
    CHA_TIME,    -- Time of change [AEZET]
    ASTDTF,      -- Strt Date-From [OIG_ASTDTF]
    ASTTMF,      -- Strt Time-From [OIG_ASTTMF]
    ASTDTT,      -- Start Date-To [OIG_ASTDTT]
    ASTTMT,      -- Start Time - To [OIG_ASTTMT]
    AEDDTF,      -- ActEndDateFr [OIG_AEDDTF]
    AEDTMF,      -- ActEndTimeFr [OIG_AEDTMF]
    AEDDTT,      -- ActEndDateTo [OIG_AEDDTT]
    AEDTMT,      -- ActEndTimeTo [OIG_AEDTMT]
    DEFAULTED,   -- Field selection [OIG_FIELDS]
    VEH_NR,      -- Vehicle Seq. No [OIG_VEHNR]
    TSRFO,       -- Seq.stage [TSRFO]
    PRIMARY KEY (CLIENT, SHNUMBER, EVENT_NR)
);