OIGS

Transparent Table Application Table
97 Fields 6 CDS Views

TD Shipment Header

OIGS is an SAP database table in S/4HANA. TD Shipment Header. It contains 97 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 (97)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY shnumber OIG_SHNUM Bulk shipment
shtype OIG_TDSTYP Bulk shipm.type
xblnr XBLNR1 Reference
veh_mode OIG_VMOT Mode/transp.
vmrqt OIG_VMRQT Veh.meter req.
cplid OIG_CPLID Compart.loadID
chkcmp_p_c OIG_CMP_PC Check compat.
chkcmp_v_c OIG_CMP_VC Check compat.
part_dc OIG_PRTDC Part del.conf.
uomid OIG_UOMID UoM ID
cfbll OIG_CFBLL Confirm bl.load
inpgp OIG_INPGP Intr.post.grp.
wgt_uom OIG_WGTUOM Weight UoM
vol_uom OIG_VOLUOM Vol.UoM
nr_decv OIG_NRDEC Nr.decimals
nr_decw OIG_NRDEC Nr.decimals
vola_uom OIG_VOLA Vol.UoM (amb.)
volc_uom OIG_VOLC Vol.UoM (corr.)
ovld_wrng OIG_CHKOWE Overld.warng.
oig_dlnmck OIG_DLNMCK Doc.seq.check
schund OIG_SCHUND Check underdel.
schovr OIG_SCHOVR Overdelivery
loaund OIG_LOAUND Check underdel.
loaovr OIG_LOAOVR Check overdel.
delund OIG_DELUND Check underdel.
delovr OIG_DELOVR Check overdel.
ev_seq_uni OIG_EVSEQU SeqNr (unique)
ev_group OIG_EVGRP Event def.group
shft_mnt OIG_SHFTMT Shift mand.
chk_ovl OIG_CHKOVL Chk.overload
vclose OIG_VCLOSE Vehicle close
vbalnc OIG_VBALNC Vehicle balance
glpst OIG_GLPST Post gain/loss
exch_sch OIG_EXCH Exchange assign
fftyp OIA_FFTYP Del.fulfillment
exgass OIA_EXGASS Purch.assg.exit
bwart BWARTWE Movement Type
vsart VSARTTR Shipping Type
exch_load OIG_EXCH Exchange assign
exch_check OIG_EXCHCH Check exchange
austgasgn OIG_ASTGAS AutoStgAssign
fkart FKART_T Ship. cost type
frkrl FRKRL_KOP Header
frkrl_str FRKRL_STR Leg
frkrl_ump FRKRL_UMP Load trnsf.pnt
frkrl_grp FRKRL_GRP Border cross.pt
frkrl_veh OIG_FRKRLV Vehicle
scldtype OIG_STYPE Costing base
cpl_cusfnt OIG_CPCUSF CompPl.cus.fnt.
new_comp OIG_NCOMP A comp. alloc.
chgdocs OIG_CHGDOCS Change documents
proli ADGE_PROLI DG Mgmt Profile
dgtlock ADGE_TLOCK Block Ind. DG
dgmddat ADGE_MDDAT Selection Date
cont_dg ADGE_NCDG Contains DG
c_shtyp SHTYP Shipment Type
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
tm_ttrq_handle_h OINSC_TM_TTRQ_HANDLE UUID
tm_shipment_cost_rel OINSC_TM_SHIPMENT_COST_REL TM Shp. Cost. Rel.

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]
    VEH_MODE,              -- Mode/transp. [OIG_VMOT]
    VMRQT,                 -- Veh.meter req. [OIG_VMRQT]
    CPLID,                 -- Compart.loadID [OIG_CPLID]
    CHKCMP_P_C,            -- Check compat. [OIG_CMP_PC]
    CHKCMP_V_C,            -- Check compat. [OIG_CMP_VC]
    PART_DC,               -- Part del.conf. [OIG_PRTDC]
    UOMID,                 -- UoM ID [OIG_UOMID]
    CFBLL,                 -- Confirm bl.load [OIG_CFBLL]
    INPGP,                 -- Intr.post.grp. [OIG_INPGP]
    WGT_UOM,               -- Weight UoM [OIG_WGTUOM]
    VOL_UOM,               -- Vol.UoM [OIG_VOLUOM]
    NR_DECV,               -- Nr.decimals [OIG_NRDEC]
    NR_DECW,               -- Nr.decimals [OIG_NRDEC]
    VOLA_UOM,              -- Vol.UoM (amb.) [OIG_VOLA]
    VOLC_UOM,              -- Vol.UoM (corr.) [OIG_VOLC]
    OVLD_WRNG,             -- Overld.warng. [OIG_CHKOWE]
    OIG_DLNMCK,            -- Doc.seq.check [OIG_DLNMCK]
    SCHUND,                -- Check underdel. [OIG_SCHUND]
    SCHOVR,                -- Overdelivery [OIG_SCHOVR]
    LOAUND,                -- Check underdel. [OIG_LOAUND]
    LOAOVR,                -- Check overdel. [OIG_LOAOVR]
    DELUND,                -- Check underdel. [OIG_DELUND]
    DELOVR,                -- Check overdel. [OIG_DELOVR]
    EV_SEQ_UNI,            -- SeqNr (unique) [OIG_EVSEQU]
    EV_GROUP,              -- Event def.group [OIG_EVGRP]
    SHFT_MNT,              -- Shift mand. [OIG_SHFTMT]
    CHK_OVL,               -- Chk.overload [OIG_CHKOVL]
    VCLOSE,                -- Vehicle close [OIG_VCLOSE]
    VBALNC,                -- Vehicle balance [OIG_VBALNC]
    GLPST,                 -- Post gain/loss [OIG_GLPST]
    EXCH_SCH,              -- Exchange assign [OIG_EXCH]
    FFTYP,                 -- Del.fulfillment [OIA_FFTYP]
    EXGASS,                -- Purch.assg.exit [OIA_EXGASS]
    BWART,                 -- Movement Type [BWARTWE]
    VSART,                 -- Shipping Type [VSARTTR]
    EXCH_LOAD,             -- Exchange assign [OIG_EXCH]
    EXCH_CHECK,            -- Check exchange [OIG_EXCHCH]
    AUSTGASGN,             -- AutoStgAssign [OIG_ASTGAS]
    FKART,                 -- Ship. cost type [FKART_T]
    FRKRL,                 -- Header [FRKRL_KOP]
    FRKRL_STR,             -- Leg [FRKRL_STR]
    FRKRL_UMP,             -- Load trnsf.pnt [FRKRL_UMP]
    FRKRL_GRP,             -- Border cross.pt [FRKRL_GRP]
    FRKRL_VEH,             -- Vehicle [OIG_FRKRLV]
    SCLDTYPE,              -- Costing base [OIG_STYPE]
    CPL_CUSFNT,            -- CompPl.cus.fnt. [OIG_CPCUSF]
    NEW_COMP,              -- A comp. alloc. [OIG_NCOMP]
    CHGDOCS,               -- Change documents [OIG_CHGDOCS]
    PROLI,                 -- DG Mgmt Profile [ADGE_PROLI]
    DGTLOCK,               -- Block Ind. DG [ADGE_TLOCK]
    DGMDDAT,               -- Selection Date [ADGE_MDDAT]
    CONT_DG,               -- Contains DG [ADGE_NCDG]
    C_SHTYP,               -- Shipment Type [SHTYP]
    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]
    TM_TTRQ_HANDLE_H,      -- UUID [OINSC_TM_TTRQ_HANDLE]
    TM_SHIPMENT_COST_REL,  -- TM Shp. Cost. Rel. [OINSC_TM_SHIPMENT_COST_REL]
    PRIMARY KEY (CLIENT, SHNUMBER)
);

Learn More