OIGS

Transparent Table Application Table
42 Fields 6 CDS Views

TD Shipment Header

OIGS is an SAP database table in S/4HANA. TD Shipment Header. It contains 42 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_BulkShipmentHeader view from BASIC Bulk Shipment Header
I_TripAllocationItemsTP view left_outer TRANSACTIONAL Allocated charges to scheduled items
I_TripShipmentItemVH view inner BASIC Shipment Item value help
I_TripShipmentKeyVH view inner BASIC Shipment Key value help
I_TripShipmentTypeVH view from BASIC Shipment Type value help
I_TripShptItmTP view left_outer TRANSACTIONAL Shipment Items

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY shnumber oig_shnum Bulk shipment
shtype oig_tdstyp Bulk shipm.type
xblnr xblnr1 Reference
tplst tplst TransportPlanPt
route route Route
carrier tdlnr Service Agent
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_sstsf oig_sstsf Shipment Status
sched_stdt oig_shstdt Plan shpm.start
sched_sttm oig_shsttm Sched. start
load_stdt oig_ldstdt Plan.load start
load_sttm oig_ldsttm Loading start
load_eddt oig_ldeddt Plan.load end
load_edtm oig_ldedtm Loading end
del_stdt oig_destdt Del.start.date
del_sttm oig_desttm Delivery start
del_eddt oig_deeddt Del.end date
del_edtm oig_deedtm Delivery end
load_stdta oig_ldstda Load start
load_sttma oig_ldstta Loading start
load_eddta oig_ldedda ActLoadEnd
load_edtma oig_ldedta Loading end
del_stdta oig_destda Del.start.date
del_sttma oig_destta Delivery start
del_eddta oig_deedda Del.end.date
del_edtma oig_deedta Delivery end
fbsta fbsta Shipm.Csts Cal
fbgst fbgst OvSts.ShCostCal
arsta arsta Shpmt Costs Set
argst argst Tot.Shp.Cst Stm
frkrl_shp frkrl ShpmntCostsRel.
skalsm kalsm_kopf Procedure
tswuseind oij_tswuseind TSW useage
chg_reason oig_chreas Change reason
shsta_scd oig_sstsf Shipment Status
shselect oig_shpselect Flag to Sel Shipment

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 Shipment Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIGS (
    CLIENT,      -- Client [mandt]
    SHNUMBER,    -- Bulk shipment [oig_shnum]
    SHTYPE,      -- Bulk shipm.type [oig_tdstyp]
    XBLNR,       -- Reference [xblnr1]
    TPLST,       -- TransportPlanPt [tplst]
    ROUTE,       -- Route [route]
    CARRIER,     -- Service Agent [tdlnr]
    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_SSTSF,   -- Shipment Status [oig_sstsf]
    SCHED_STDT,  -- Plan shpm.start [oig_shstdt]
    SCHED_STTM,  -- Sched. start [oig_shsttm]
    LOAD_STDT,   -- Plan.load start [oig_ldstdt]
    LOAD_STTM,   -- Loading start [oig_ldsttm]
    LOAD_EDDT,   -- Plan.load end [oig_ldeddt]
    LOAD_EDTM,   -- Loading end [oig_ldedtm]
    DEL_STDT,    -- Del.start.date [oig_destdt]
    DEL_STTM,    -- Delivery start [oig_desttm]
    DEL_EDDT,    -- Del.end date [oig_deeddt]
    DEL_EDTM,    -- Delivery end [oig_deedtm]
    LOAD_STDTA,  -- Load start [oig_ldstda]
    LOAD_STTMA,  -- Loading start [oig_ldstta]
    LOAD_EDDTA,  -- ActLoadEnd [oig_ldedda]
    LOAD_EDTMA,  -- Loading end [oig_ldedta]
    DEL_STDTA,   -- Del.start.date [oig_destda]
    DEL_STTMA,   -- Delivery start [oig_destta]
    DEL_EDDTA,   -- Del.end.date [oig_deedda]
    DEL_EDTMA,   -- Delivery end [oig_deedta]
    FBSTA,       -- Shipm.Csts Cal [fbsta]
    FBGST,       -- OvSts.ShCostCal [fbgst]
    ARSTA,       -- Shpmt Costs Set [arsta]
    ARGST,       -- Tot.Shp.Cst Stm [argst]
    FRKRL_SHP,   -- ShpmntCostsRel. [frkrl]
    SKALSM,      -- Procedure [kalsm_kopf]
    TSWUSEIND,   -- TSW useage [oij_tswuseind]
    CHG_REASON,  -- Change reason [oig_chreas]
    SHSTA_SCD,   -- Shipment Status [oig_sstsf]
    SHSELECT,    -- Flag to Sel Shipment [oig_shpselect]
    PRIMARY KEY (CLIENT, SHNUMBER)
);

Learn More