TOIGS

Transparent Table Customizing Table

TD Shipment Types

TOIGS is an SAP database table in S/4HANA. TD Shipment Types. It contains 68 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BulkShipmentType view from BASIC Bulk Shipment Type
I_OIL_BulkShipmentTypeVH view_entity from BASIC TD Shipment Types
I_SourceNominationSchedPartner view inner BASIC I_SourceSchedulePartnerTP
I_SourceNominationScheduleTP view left_outer TRANSACTIONAL Source Schedule

Fields (68)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY shtyp OIG_TDSTYP Bulk shipm.type
numki NUMKI NR of Int. Asst
numke NUMKE NR of Ext. Asst
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
sch_kalsm OIG_KALSMS OutputDet.proc.
load_kalsm OIG_KALSML OutputDet.proc.
del_kalsm OIG_KALSMD Output determ.
shv_kalsm OIG_KALSMV OutputDet.proc.
qty_from OIG_QTYFR Qty.from
qty_to OIG_QTYTO Qty to
chkovrdly OIG_CHKOVRDLY Chk overdelvy w/o cl
byp_inslc OIG_BYP_INSLC Bypass intr.sto.loc.
vclosel OIG_VCLOSEL Veh. close load
ev_group_si OIG_EVGRP Event def.group
chk_vnh OIG_CHK_VNH Update to TD shipmen

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 Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TOIGS (
    CLIENT,       -- Client [MANDT]
    SHTYP,        -- Bulk shipm.type [OIG_TDSTYP]
    NUMKI,        -- NR of Int. Asst [NUMKI]
    NUMKE,        -- NR of Ext. Asst [NUMKE]
    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]
    SCH_KALSM,    -- OutputDet.proc. [OIG_KALSMS]
    LOAD_KALSM,   -- OutputDet.proc. [OIG_KALSML]
    DEL_KALSM,    -- Output determ. [OIG_KALSMD]
    SHV_KALSM,    -- OutputDet.proc. [OIG_KALSMV]
    QTY_FROM,     -- Qty.from [OIG_QTYFR]
    QTY_TO,       -- Qty to [OIG_QTYTO]
    CHKOVRDLY,    -- Chk overdelvy w/o cl [OIG_CHKOVRDLY]
    BYP_INSLC,    -- Bypass intr.sto.loc. [OIG_BYP_INSLC]
    VCLOSEL,      -- Veh. close load [OIG_VCLOSEL]
    EV_GROUP_SI,  -- Event def.group [OIG_EVGRP]
    CHK_VNH,      -- Update to TD shipmen [OIG_CHK_VNH]
    PRIMARY KEY (CLIENT, SHTYP)
);