TOIGS
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA