1. SAP Tutorial
  2. Oil & Gas

OIJX SAP table for – TSW control record

Here we would like to draw your attention to OIJX table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIJX is a SAP standard transp table used for storing TSW control record related data in SAP. It comes under the package OIJ.

SAP OIJX table

Table OIJX technical data

TableOIJX
Data storingTSW control record
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJX Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIJX table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TSWACT : OIL-TSW: TSW is active
    Its data type is CHAR (Character String) with field length 1
  • PLSQCH : TSW: Flag to indicate changes in planning rel. data
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : OIL-TSW: Standard status field set (TSW)
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • CLSHIP : OIL TSW : Automatically close shipment flag
    Its data type is CHAR (Character String) with field length 1
  • RDREAL : Real-time Stock Projection indicator
    Its data type is CHAR (Character String) with field length 1
  • EXTDET : External Details
    Its data type is CHAR (Character String) with field length 1
  • RDLOGIC : Stock Projection calculation logic identifier
    Its data type is CHAR (Character String) with field length 1
  • RDFCL : OIL-TSW: Corrective Rack forecast issue logic indicator
    Its data type is CHAR (Character String) with field length 1
  • RDPAST : Stock Projection Worksheet past days’ inventory indicator
    Its data type is CHAR (Character String) with field length 1
  • RDNOMDAT : Nomination Stock Projection date indicator
    Its data type is CHAR (Character String) with field length 1
  • RDDISAG : Stock Projection disaggregation specifier
    Its data type is CHAR (Character String) with field length 1
  • SCHEDREL : OIL-TSW: Scheduling relevance check flag
    Its data type is CHAR (Character String) with field length 1
  • LOCCONTROL : OIL-TSW: Scheduling TSW Details location check flag
    Its data type is CHAR (Character String) with field length 1
  • NOMICU : OIL-TSW: Nomination item additional fields pop-up activation
    Its data type is CHAR (Character String) with field length 1
  • NOMHCU : OIL-TSW: Nomination header add. fields pop-up activation
    Its data type is CHAR (Character String) with field length 1
  • MMOTCHK : OIL-TSW: Scheduling multiple MOT check
    Its data type is CHAR (Character String) with field length 1
  • LOCMATCU : OIL-TSW: Location/material add. fields screen activation
    Its data type is CHAR (Character String) with field length 1
  • TSMATCU : OIL-TSW: TransportSys/material add. fields screen activation
    Its data type is CHAR (Character String) with field length 1
  • TSWDCHK : TSW check in SD / MM document transactions
    Its data type is CHAR (Character String) with field length 1
  • EXDETMOT : Transfer external details MoT to TSW multiple MoTs
    Its data type is CHAR (Character String) with field length 1
  • NOMDATCHK : Check scheduled date against the TSW Details date range
    Its data type is CHAR (Character String) with field length 1
  • PLLOCFLAG : OIL TSW: Location valid on all assigned planning locations
    Its data type is CHAR (Character String) with field length 1
  • RDPLMICO : Plus/minus combined in the SPW
    Its data type is CHAR (Character String) with field length 1
  • RDMULT : All ‘Multiple’ items in the SPW drilled down/up
    Its data type is CHAR (Character String) with field length 1
  • RDDECS : Number of decimals in the SPW
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • RDPHYS : OIL-TSW: Physical inventory in both columns
    Its data type is CHAR (Character String) with field length 1
  • RDSTART : Stock Projection start day flag
    Its data type is CHAR (Character String) with field length 1
  • HEEL : Heel field name
    Its data type is CHAR (Character String) with field length 30
  • RDAUTOWL : Generate Stock Projection worklist automatically
    Its data type is CHAR (Character String) with field length 1
  • RDREP : Use ‘Report into inventory’ functionality
    Its data type is CHAR (Character String) with field length 1
  • CONSIDER_ROUTE : Consider Route
    Its data type is CHAR (Character String) with field length 1
  • RDTREE : Stock Projection object selection is based on ALV tree
    Its data type is CHAR (Character String) with field length 1
  • SPFLTVAL : Stock projection filter value for BADI
    Its data type is CHAR (Character String) with field length 6
  • SPDOCWHIF : Indicator: Ability to view/maintain documents in what-if pop
    Its data type is CHAR (Character String) with field length 1
  • ETA_EV_TYPE : Event Type for ETA
    Its data type is CHAR (Character String) with field length 4
  • PS_SITYP_DMD : Default Schedule type for Pegging to Stock of Demand Items
    Its data type is CHAR (Character String) with field length 2
  • PS_DOCIND_DMD : Reference document indicator for Pegging to Stock of Demand
    Its data type is CHAR (Character String) with field length 1
  • PS_SITYP_SUP : Default Schedule type for Pegging to Stock of Supply Avails
    Its data type is CHAR (Character String) with field length 2
  • PS_DOCIND_SUP : Reference document indicator for Pegging to Stock of Supply
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : OIL-TSW: Sequencing of Locations on a Transport System
  • BFDEPTH : Bifurcation Depth
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • START_SEQ : Start of Sequence Number
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • INCRE_SEQ : Increment of Sequence Number
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • .INCLUDE : Graph Profile
  • PRF_GRUPPE : Profile group (sort graphics profiles)
    Its data type is CHAR (Character String) with field length 4
  • PRF_NAME : Name of graphics profile
    Its data type is CHAR (Character String) with field length 12
  • PRF_INDEX : Profile index for the graphics profile
    Its data type is CHAR (Character String) with field length 1
  • AMEND_MIN_QTY : Amendment quantity minimum
    Its data type is QUAN (Quantity field) with field length 13
  • AMEND_MIN_QTY_U : Amendment minimum quantity UOM
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • LB_ROUTE_CHK_OBJ : LB Route check objects (Location / Transport system)
    Its data type is CHAR (Character String) with field length 2
  • LB_ROUTE_PUB : LB Publish with / without route
    Its data type is CHAR (Character String) with field length 1
  • DOCCO : Documents in TSW-SPW Are Consumed by Goods Movements
    Its data type is CHAR (Character String) with field length 1
  • SPAUTOFC : Generate Rack Forecast Automatically in Stock Projection
    Its data type is CHAR (Character String) with field length 1
  • UPD_REFDOC : Reference Document Update
    Its data type is CHAR (Character String) with field length 1
  • GTS : Check on GTS (Global Trade Services) valid partners
    Its data type is CHAR (Character String) with field length 1
  • METER_RECON_FLAG : TSW-TD meter reconciliation flag
    Its data type is CHAR (Character String) with field length 1

    • OIJX related tables

    • TOIJNOM_EV02T : Nomination event profile texts
    • TOIJ_NOM_QSFT : Nomination Quick Search Fields
    • OIJTE : TSW Ticket Events
    • TOIJ_SS_SETTINGS : Ship shore settings
    • OIJ_3WP_SS : 3WP Selection Screen BADI filter table
    • OIJEDIVNDR : Assign EDI account numbers to vendors
    • OIJRRTT : OIL-TSW: Partner role type texts
    • OIJ_NOM_CHK_G : Nomination validation groups
    • OIJNOMI_LDS : Load / Discharge scheduling for nominations
    • TOIJ_NOM_VIEWT : Stores description to nomination views (text table)
    • TOIJNOM_EV01T : Nomination Event type texts
    • OIJ_NOMMT_CHK_R : Check routines with multiple nominations
    • TOIJ_REF_DOC_UPD : OIL-TSW: Update of scheduled documents – Technical settings
    • OIJ_SIM_SCHED : obsolete table (will be cleaned up)
    • OIJ_TKT_CHK_G : Ticketing validation groups
    • OIJNOMI : Nomination Item
    • OIJ_CONS_TYPE : Time-Dependent Constraint Types
    • TOIJ_LAYT_RELV : Assign laytime filter to relevance type
    • TOIJUSAGET : OIL-TSW: Usage of Location Sources/Destinations text table
    • OIJTGTYP : OIL-TSW: Target stock calculation type

    OIJX related transaction codes under SAP package OIJ

    • S_SOG_81000083 : IMG activity: SIMG_OIJ_TSW_0005
    • S_SOG_81000087 : IMG activity: SIMG_OIJ_TSW_102
    • O4NC : Create Nomination
    • O4NVN : Change Nomination
    • O5TNR_OIJ_NOM : No. Range Maintnce: OIJNOM
    • S_SOG_81000068 : IMG activity: SIMG_OIJ_TSW_0013
    • S_SOG_81000113 : IMG activity: SIMG_OIJ_TSW_1115
    • O4BER : Number range maintenance: OIJ_BER
    • O4TB_RDALV : Stock Projection Worksheet
    • O5T9 : Maintain Condition Type – NOM
    • O4TEN : Ticket create new
    • S_SO5_65000254 : IMG activity: SIMG_TSW_0019
    • O4T5_TKT : Create records in cond table – TKT
    • O5TNR_NOM_COMM : Number range maintenance: OIJ_NOMCOM
    • S_SO7_65001269 : IMG activity: SIMG_OIJ_TSW_040
    • S_SO7_65001299 : IMG activity: SIMG_OIJ_TSW_052
    • O4RP1 : Create release profile
    • S_SO5_65000251 : IMG activity: SIMG_TSW_0017
    • O5T8 : Update fields in field catalog – NOM
    • S_SOG_81000071 : IMG activity: SIMG_OIJ_TSW_0012

    Related References

    Related Tutorials

    OIJDPFCSTS SAP table for – OIL-TSW: TSW APO DP Forecast settings

    OIJDPFCSTS table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW: TSW APO...

    OIJSTAT SAP table for – OIL-TSW : Status Table

    OIJSTAT table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW : Status...

    B445 SAP table for – OIL-TSW: Carrier

    B445 table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW: Carrier. See...

    OIJERRLOG SAP table for – TSW: Error log of create/change documents

    OIJERRLOG table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of TSW: Error log...

    OIJPLANWL SAP table for – OIJ-TSW: Worklist entries for planning

    OIJPLANWL table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIJ-TSW: Worklist entries...

    OIJRDPLAN SAP table for – OIL-TSW: Rundown planning proposal drill-down

    OIJRDPLAN table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW: Rundown planning...

    OIJRRA SAP table for – OIL-TSW: Partner roles

    OIJRRA table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of OIL-TSW: Partner roles....

    «
    »