OIJTS

Transparent Table Application Table
61 Fields 20 CDS Views

Transport system (IS-Oil TSW standard/core object )

OIJTS is an SAP database table in S/4HANA. Transport system (IS-Oil TSW standard/core object ). It contains 61 fields. 20 CDS views read from this table.

CDS Views using this table (20)

ViewTypeJoinVDMDescription
/dmbe/i_TransportSystem view from Transport System Basic CDS
I_NominationAnalysisPath view left_outer BASIC View for APF Nominations
I_NominationTransptSystVH view from BASIC cds for transport system value help
I_Oij06_Myeventss1_Object view left_outer BASIC Mass Change Events - events interface view
I_OIL_TransportSystem view_entity from BASIC Transport System
I_OilTransportSystem view from BASIC TSW Transport System
I_SourceNominationSchedPartner view inner BASIC I_SourceSchedulePartnerTP
I_SourceNominationScheduleTP view inner TRANSACTIONAL Source Schedule
I_VisualTransportSystemVH view from BASIC Visual Transport System
Oij05_GNominations view left_outer To fetch nominations
OIJ05_GSCHED view left_outer CDS for Global Sim in OIJ_SCHED
OIJ05_GSCHED_LO view left_outer CDS for Location Balancing Global Sim in OIJ_SCHED
OIJ05_ICSCHED view left_outer To fetch global simulation of type IC
Oij05_Nominations view left_outer To fetch nominations
Oij05_Oijgsched view left_outer CDSV for GSched
Oij05_Oijgsched_Sim view left_outer CDS View for Oij05_Oijgsched_Sim
Oij05_Oijsched view left_outer CDSV for OIJSCHED
Oij05_Oijsched_Sim view left_outer CDSV for OIJ05_SCHED_SIM
Oij05_Sched view left_outer CDS for OIJ_SCHED
OIJ09_SourceNominationSchedule view inner Source Schedule

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tsyst OIJ_TSYST Trans system
tsnam OIJ_TSNAM TS name
bookts OIJ_BOOKTS Book TS
vsart VERSART Shipping Type
vktra VKTRA Mode of Transp.
shtype OIG_TDSTYP Bulk shipm.type
vehid OIJ_DEFVEH Default veh.no.
tssuomv OIJ_TSUOMV UoM volume
tssuomm OIJ_TSUOMM UoM weight
cycperd OIJ_CYCDUR Cycle duration
cycpuom OIJ_CYDUOM UoM
carrier OIJ_CARRNR Carrier
werk OIJ_WERK Intr. plant
lgort OIJ_LGORT Intr.S.Loc
nommsk OIJ_NOMMSK Nom/batch mask
shipper OIJ_SHPPER Shipper
conltm OIJ_CONLTM Carr.lead time
conluom OIJ_CONTUM UoM
tplst TPLST TransportPlanPt
botol OIJ_BOTOL Over %
butol OIJ_BUTOL Under %
botolabs OIJ_TOLABO Abs.tol.qty.ovr
butolabs OIJ_TOLABS Abs.tol.Q under
bultoluom OIJ_TOLUOM Abs.tol.UoM
unlimited UEBTK Unlimited
balch OIJ_BALCH Balance check
cliplgort OIJ_CLIPLGORT Clipboard LGORT
shtyp SHTYP Shipment Type
erdat ERDAT Created On
erzeit OI0_ERTIM Created
ernam ERNAM Created By
aedat AEDAT Changed On
aezeit OI0_AETIM Changed
aenam AENAM Changed By
bloind OIJ_BLOIND Blocking ind.
delind OIJ_DELIND Deletion ind.
tktselect OIJ_TKTSELECT Flag to Select Tkt
kalsm OIJ_KALSM Output det.pr.
kappl OIJ_KAPPL AppforOutDeterm
kschl OIJ_KSCHL Output type
maxrate OIJ_MAXRATE Maximum rate
minrate OIJ_MINRATE Minimum rate
operate OIJ_OPERATE operating rate
rateuom OIJ_RATEUOM Rate unit
rateperd OIJ_RATEPERD Time UoM
seqind OIJ_TSSEQIND Loc seq index
maxusage OIJ_MAXUSAGE Max Volume
minusage OIJ_MINUSAGE Min Volume
usageuom OIJ_USAGEUOM Usage unit
usageperd OIJ_USAGEPERD Time UoM
pipe_batch OIJ_PIPE_BATCH Batch active
vel_avg OIJ_VEL_AVG Avg velocity
vel_max OIJ_VEL_MAX Max velocity
vel_min OIJ_VEL_MIN Min velocity
bustyp OIRA_RNBT Business type
vel_uom OIJ_VEL_UOM Velocity UoM
vel_uomt OIJ_VEL_UOMT Vel / Time
route_tolerance OIJ_ROUTE_TOLERANCE Route Tolerance
rdtsact OIJ_RDACT Loc SP Act
act_subitem OIJ_ACT_SUBITEM_FLAG Actualize Sub-Item

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.

-- Transport system (IS-Oil TSW standard/core object )
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJTS (
    MANDT,            -- Client [MANDT]
    TSYST,            -- Trans system [OIJ_TSYST]
    TSNAM,            -- TS name [OIJ_TSNAM]
    BOOKTS,           -- Book TS [OIJ_BOOKTS]
    VSART,            -- Shipping Type [VERSART]
    VKTRA,            -- Mode of Transp. [VKTRA]
    SHTYPE,           -- Bulk shipm.type [OIG_TDSTYP]
    VEHID,            -- Default veh.no. [OIJ_DEFVEH]
    TSSUOMV,          -- UoM volume [OIJ_TSUOMV]
    TSSUOMM,          -- UoM weight [OIJ_TSUOMM]
    CYCPERD,          -- Cycle duration [OIJ_CYCDUR]
    CYCPUOM,          -- UoM [OIJ_CYDUOM]
    CARRIER,          -- Carrier [OIJ_CARRNR]
    WERK,             -- Intr. plant [OIJ_WERK]
    LGORT,            -- Intr.S.Loc [OIJ_LGORT]
    NOMMSK,           -- Nom/batch mask [OIJ_NOMMSK]
    SHIPPER,          -- Shipper [OIJ_SHPPER]
    CONLTM,           -- Carr.lead time [OIJ_CONLTM]
    CONLUOM,          -- UoM [OIJ_CONTUM]
    TPLST,            -- TransportPlanPt [TPLST]
    BOTOL,            -- Over % [OIJ_BOTOL]
    BUTOL,            -- Under % [OIJ_BUTOL]
    BOTOLABS,         -- Abs.tol.qty.ovr [OIJ_TOLABO]
    BUTOLABS,         -- Abs.tol.Q under [OIJ_TOLABS]
    BULTOLUOM,        -- Abs.tol.UoM [OIJ_TOLUOM]
    UNLIMITED,        -- Unlimited [UEBTK]
    BALCH,            -- Balance check [OIJ_BALCH]
    CLIPLGORT,        -- Clipboard LGORT [OIJ_CLIPLGORT]
    SHTYP,            -- Shipment Type [SHTYP]
    ERDAT,            -- Created On [ERDAT]
    ERZEIT,           -- Created [OI0_ERTIM]
    ERNAM,            -- Created By [ERNAM]
    AEDAT,            -- Changed On [AEDAT]
    AEZEIT,           -- Changed [OI0_AETIM]
    AENAM,            -- Changed By [AENAM]
    BLOIND,           -- Blocking ind. [OIJ_BLOIND]
    DELIND,           -- Deletion ind. [OIJ_DELIND]
    TKTSELECT,        -- Flag to Select Tkt [OIJ_TKTSELECT]
    KALSM,            -- Output det.pr. [OIJ_KALSM]
    KAPPL,            -- AppforOutDeterm [OIJ_KAPPL]
    KSCHL,            -- Output type [OIJ_KSCHL]
    MAXRATE,          -- Maximum rate [OIJ_MAXRATE]
    MINRATE,          -- Minimum rate [OIJ_MINRATE]
    OPERATE,          -- operating rate [OIJ_OPERATE]
    RATEUOM,          -- Rate unit [OIJ_RATEUOM]
    RATEPERD,         -- Time UoM [OIJ_RATEPERD]
    SEQIND,           -- Loc seq index [OIJ_TSSEQIND]
    MAXUSAGE,         -- Max Volume [OIJ_MAXUSAGE]
    MINUSAGE,         -- Min Volume [OIJ_MINUSAGE]
    USAGEUOM,         -- Usage unit [OIJ_USAGEUOM]
    USAGEPERD,        -- Time UoM [OIJ_USAGEPERD]
    PIPE_BATCH,       -- Batch active [OIJ_PIPE_BATCH]
    VEL_AVG,          -- Avg velocity [OIJ_VEL_AVG]
    VEL_MAX,          -- Max velocity [OIJ_VEL_MAX]
    VEL_MIN,          -- Min velocity [OIJ_VEL_MIN]
    BUSTYP,           -- Business type [OIRA_RNBT]
    VEL_UOM,          -- Velocity UoM [OIJ_VEL_UOM]
    VEL_UOMT,         -- Vel / Time [OIJ_VEL_UOMT]
    ROUTE_TOLERANCE,  -- Route Tolerance [OIJ_ROUTE_TOLERANCE]
    RDTSACT,          -- Loc SP Act [OIJ_RDACT]
    ACT_SUBITEM,      -- Actualize Sub-Item [OIJ_ACT_SUBITEM_FLAG]
    PRIMARY KEY (MANDT, TSYST)
);

Learn More