OIGSI

Transparent Table Application Table
20 Fields 3 CDS Views

Shipment Item

OIGSI is an SAP database table in S/4HANA. Shipment Item. It contains 20 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_BulkShipmentItem view from BASIC Bulk Shipment Item
I_TripShipmentItemVH view inner BASIC Shipment Item value help
I_TripShptItmTP view left_outer TRANSACTIONAL Shipment Items

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY shnumber OIG_SHNUM Bulk shipment
KEY shitem OIG_SHITM Shipment item
doc_typ VBTYPL Document Cat.
doc_number OIG_DOCNR Document number
vgtyp VBTYPL Document Cat.
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
oig_sstsfp OIG_SSTSF Shipment Status
doc_seq OIG_DELSEQ Document seq.
load_indi OIG_LDIND Load indicator
disch_indi OIG_DCIND Discharge ind.
longtext OIG_LTXT Longtext
tcode TCODE Transaction Code
oig_glpod OIG_GLPOD GI loading/POD
cont_dg ADGE_SCDG Contains DG

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.

-- Shipment Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIGSI (
    CLIENT,      -- Client [MANDT]
    SHNUMBER,    -- Bulk shipment [OIG_SHNUM]
    SHITEM,      -- Shipment item [OIG_SHITM]
    DOC_TYP,     -- Document Cat. [VBTYPL]
    DOC_NUMBER,  -- Document number [OIG_DOCNR]
    VGTYP,       -- Document Cat. [VBTYPL]
    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]
    OIG_SSTSFP,  -- Shipment Status [OIG_SSTSF]
    DOC_SEQ,     -- Document seq. [OIG_DELSEQ]
    LOAD_INDI,   -- Load indicator [OIG_LDIND]
    DISCH_INDI,  -- Discharge ind. [OIG_DCIND]
    LONGTEXT,    -- Longtext [OIG_LTXT]
    TCODE,       -- Transaction Code [TCODE]
    OIG_GLPOD,   -- GI loading/POD [OIG_GLPOD]
    CONT_DG,     -- Contains DG [ADGE_SCDG]
    PRIMARY KEY (CLIENT, SHNUMBER, SHITEM)
);

Learn More