SAP Table OIJX

TSW control record

OIJX (TSW control record) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIJX to other SAP tables.

OIJX table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TSWACT OIL-TSW: TSW is active OIJ_TSWACT CHAR 1 0
X Yes
NULL No
PLSQCH TSW: Flag to indicate changes in planning rel. data OIJ_PLSQCH CHAR 1 0
X Yes
NULL No
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZEIT Time of creation OI0_ERTIM TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZEIT Time of day the record was changed OI0_AETIM TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BLOIND Blocking indicator OIJ_BLOIND CHAR 1 0
X Yes
NULL No
DELIND Deletion indicator OIJ_DELIND CHAR 1 0
X Yes
NULL No
CLSHIP OIL TSW : Automatically close shipment flag OIJ_CLSHIP CHAR 1 0
X Yes
NULL No
RDREAL Real-time Stock Projection indicator OIJ_REALTIME CHAR 1 0
X Yes
NULL No
EXTDET External Details OIJ_EXTDET CHAR 1 0
X Yes
NULL No
RDLOGIC Stock Projection calculation logic identifier OIJ_RDLOGIC CHAR 1 0
B 'Start day' - inventory
E 'Day end' - inventory
RDFCL OIL-TSW: Corrective Rack forecast issue logic indicator OIJ_RDFCL CHAR 1 0
O Rack forecast corrections overwrite the forecast
A Rack forecast corrections add to the forecast
RDPAST Stock Projection Worksheet past days' inventory indicator OIJ_RDPAST CHAR 1 0
B Column for past days what-if contains the SAP book figures
P Column for past days what-if contains the physical inventory
RDNOMDAT Nomination Stock Projection date indicator OIJ_RDNOMDAT CHAR 1 0
S Nomination on scheduled date
T Nomination on ticket end date
RDDISAG Stock Projection disaggregation specifier OIJ_RDDISAG CHAR 1 0
B SPW by batch
V SPW by valuation type
SCHEDREL OIL-TSW: Scheduling relevance check flag OIJ_SCHEDREL CHAR 1 0
X Yes
NULL No
LOCCONTROL OIL-TSW: Scheduling TSW Details location check flag OIJ_LOCCONTROL CHAR 1 0
NULL No check executed
P Check with document item plant. TSW Details ignored
L Check with TSW Details location
NOMICU OIL-TSW: Nomination item additional fields pop-up activation OIJ_NOMICU CHAR 1 0
X Yes
NULL No
NOMHCU OIL-TSW: Nomination header add. fields pop-up activation OIJ_NOMHCU CHAR 1 0
X Yes
NULL No
MMOTCHK OIL-TSW: Scheduling multiple MOT check OIJ_MMOTCHK CHAR 1 0
X Yes
NULL No
LOCMATCU OIL-TSW: Location/material add. fields screen activation OIJ_LOCMATCU CHAR 1 0
X Yes
NULL No
TSMATCU OIL-TSW: TransportSys/material add. fields screen activation OIJ_TSMATCU CHAR 1 0
X Yes
NULL No
TSWDCHK TSW check in SD / MM document transactions OIJ_TSWDCHK CHAR 1 0
X Yes
NULL No
EXDETMOT Transfer external details MoT to TSW multiple MoTs OIJ_EXDETMOT CHAR 1 0
X Yes
NULL No
NOMDATCHK Check scheduled date against the TSW Details date range OIJ_NOMDATCHK CHAR 1 0
X Yes
NULL No
PLLOCFLAG OIL TSW: Location valid on all assigned planning locations OIJ_PLANFLAG CHAR 1 0
X Yes
NULL No
RDPLMICO Plus/minus combined in the SPW OIJ_RDPLMICO CHAR 1 0
X Yes
NULL No
RDMULT All 'Multiple' items in the SPW drilled down/up OIJ_RDMULT CHAR 1 0
U Multiple Nom drilled UP
D Multiple Nom drilled DOWN
RDDECS Number of decimals in the SPW OIJ_RDDECS NUMC 1 0
RDPHYS OIL-TSW: Physical inventory in both columns OIJ_RDPHYS CHAR 1 0
X Yes
NULL No
RDSTART Stock Projection start day flag OIJ_RDSTART CHAR 1 0
1 SPW starts at TODAY minus Past days
2 SPW starts one day prior to latest phy inventory update date
HEEL Heel field name OIJ_HEEL CHAR 30 0
MININV Minimum inventory
SAFETY Safety level
SERVICE Service level
TARGET Target level
REORDER Reorder level
SFTLVL Preferred safety level
UNPUMP Unpumpable
RDAUTOWL Generate Stock Projection worklist automatically OIJ_RDAUTOWL CHAR 1 0
X Yes
NULL No
RDREP Use 'Report into inventory' functionality OIJ_RDREP CHAR 1 0
X Yes
NULL No
CONSIDER_ROUTE Consider Route OIJ_CONS_ROUTE CHAR 1 0
X Yes
NULL No
RDTREE Stock Projection object selection is based on ALV tree OIJ_RDTREE CHAR 1 0
X Yes
NULL No
SPFLTVAL Stock projection filter value for BADI OIJ_SPFLTVAL OIJ_SP_FLTVAL CHAR 6 0
SPDOCWHIF Indicator: Ability to view/maintain documents in what-if pop OIJ_SPDOCWHIF CHAR 1 0
X Yes
NULL No
ETA_EV_TYPE Event Type for ETA OIJ_ETA_EV_TYPE TOIGE CHAR 4 0
PS_SITYP_DMD Default Schedule type for Pegging to Stock of Demand Items OIJ_PS_SITYP TOIJ_EL_SITYPES CHAR 2 0
PS_DOCIND_DMD Reference document indicator for Pegging to Stock of Demand OIJ_PS_DOCIND CHAR 1 0
G Sales Contract
K Purchase Contract
P Purchase order
R Sales return
S Sales order
T Stock Transfer Order
X Plant-to-plant transfer
B Sales Quotation
Q Requisition document for SPW
U Stock Transfer Requisition
L Un Released Trading Contract -Purchase Order
M Un Released Trading Contract -Sales Order
N Un Released Trading Contract -Stock Transport Order
H Released Pre-Trading Contract-Purchase Order
I Released Pre-Trading Contract- Sales Order
J Released Pre-Trading Contract- Stock Transport Order
PS_SITYP_SUP Default Schedule type for Pegging to Stock of Supply Avails OIJ_PS_SITYP_SUP TOIJ_EL_SITYPES CHAR 2 0
PS_DOCIND_SUP Reference document indicator for Pegging to Stock of Supply OIJ_PS_DOCIND_SUP CHAR 1 0
G Sales Contract
K Purchase Contract
P Purchase order
R Sales return
S Sales order
T Stock Transfer Order
X Plant-to-plant transfer
B Sales Quotation
Q Requisition document for SPW
U Stock Transfer Requisition
L Un Released Trading Contract -Purchase Order
M Un Released Trading Contract -Sales Order
N Un Released Trading Contract -Stock Transport Order
H Released Pre-Trading Contract-Purchase Order
I Released Pre-Trading Contract- Sales Order
J Released Pre-Trading Contract- Stock Transport Order
BFDEPTH Bifurcation Depth OIJ_BFDEPTH INT1 3 0
START_SEQ Start of Sequence Number OIJ_SESTART NUMC 5 0
INCRE_SEQ Increment of Sequence Number OIJ_SEINCRE NUMC 5 0
PRF_GRUPPE Profile group (sort graphics profiles) BCPRFGROUP TBCG CHAR 4 0
PRF_NAME Name of graphics profile BCPRFNAME TBCG CHAR 12 0
PRF_INDEX Profile index for the graphics profile BCPRFINDEX TBCG CHAR 1 0
AMEND_MIN_QTY Amendment quantity minimum OIJ_AMEND_MIN_QTY QUAN 13 3
AMEND_MIN_QTY_U Amendment minimum quantity UOM OIJ_AMEND_MIN_QTY_U T006 UNIT 3 0
LB_ROUTE_CHK_OBJ LB Route check objects (Location / Transport system) OIJ_LB_ROUTE_CHK_OBJ CHAR 2 0
NULL Location and Transport system (Source and Destination)
T Transport system only (Source and Destination)
LB_ROUTE_PUB LB Publish with / without route OIJ_LB_ROUTE_PUB CHAR 1 0
DOCCO Documents in TSW-SPW Are Consumed by Goods Movements OIJ_DOCCO CHAR 1 0
X Yes
NULL No
SPAUTOFC Generate Rack Forecast Automatically in Stock Projection OIJ_SPAUTOFC CHAR 1 0
X Yes
NULL No
UPD_REFDOC Reference Document Update OIJ_UPD_SCHED_IND CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
GTS Check on GTS (Global Trade Services) valid partners OIJ_GTS CHAR 1 0
X Yes
NULL No
METER_RECON_FLAG TSW-TD meter reconciliation flag OIJ_METER_RECON_FLAG CHAR 1 0
X Yes
NULL No
LATELCK_3WP 3WP LOCK STRATEGY OIJ_3WP_LOCKSTRATEGY CHAR 1 0
NULL Early Lock
L Late Lock

OIJX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIJX AMEND_MIN_QTY_U OIJX MANDT T006 Units of Measurement MANDT
OIJX AMEND_MIN_QTY_U OIJX AMEND_MIN_QTY_U T006 Units of Measurement MSEHI
OIJX ETA_EV_TYPE OIJX MANDT TOIGE TD Event Types CLIENT
OIJX ETA_EV_TYPE OIJX ETA_EV_TYPE TOIGE TD Event Types TYPE
OIJX MANDT OIJX MANDT T000 Clients MANDT
OIJX PRF_GRUPPE OIJX PRF_GRUPPE TBCG Graphics profile of bar chart PRF_GRUPPE
OIJX PRF_GRUPPE OIJX PRF_NAME TBCG Graphics profile of bar chart PRF_NAME
OIJX PRF_GRUPPE OIJX PRF_INDEX TBCG Graphics profile of bar chart PRF_INDEX
OIJX PRF_GRUPPE SYST MANDT TBCG Graphics profile of bar chart MANDT
OIJX PRF_INDEX OIJX PRF_NAME TBCG Graphics profile of bar chart PRF_NAME
OIJX PRF_INDEX OIJX PRF_INDEX TBCG Graphics profile of bar chart PRF_INDEX
OIJX PRF_INDEX SYST MANDT TBCG Graphics profile of bar chart MANDT
OIJX PRF_INDEX OIJX PRF_GRUPPE TBCG Graphics profile of bar chart PRF_GRUPPE
OIJX PRF_NAME SYST MANDT TBCG Graphics profile of bar chart MANDT
OIJX PRF_NAME OIJX PRF_GRUPPE TBCG Graphics profile of bar chart PRF_GRUPPE
OIJX PRF_NAME OIJX PRF_NAME TBCG Graphics profile of bar chart PRF_NAME
OIJX PRF_NAME OIJX PRF_INDEX TBCG Graphics profile of bar chart PRF_INDEX
OIJX PS_SITYP_DMD OIJX MANDT TOIJ_EL_SITYPES TSW: Define valid sitypes CLIENT
OIJX PS_SITYP_DMD OIJX PS_SITYP_DMD TOIJ_EL_SITYPES TSW: Define valid sitypes SITYP
OIJX PS_SITYP_SUP OIJX PS_SITYP_SUP TOIJ_EL_SITYPES TSW: Define valid sitypes SITYP
OIJX PS_SITYP_SUP OIJX MANDT TOIJ_EL_SITYPES TSW: Define valid sitypes CLIENT
OIJX SPFLTVAL OIJX SPFLTVAL OIJ_SP_FLTVAL Stock projection filter values for BADI SPFLTVAL