OIJX SAP (TSW control record) Table details
Dictionary Type: Table
Description: TSW control record
Description: TSW control record
Table field list including key, data, relationships and ABAP select examples
OIJX is a standard SAP Table which is used to store TSW control record data and is available within R/3 SAP systems depending on the version and release level.
The OIJX table consists of various fields, each holding specific information or linking keys about TSW control record data available in SAP. These include TSWACT (OIL-TSW: TSW is active), PLSQCH (TSW: Flag to indicate changes in planning rel. data), ERDAT (Date on Which Record Was Created), ERZEIT (Time of creation).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIJX table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
TSWACT | OIL-TSW: TSW is active | OIJ_TSWACT | CHAR | 1 | XFELD | ||||
PLSQCH | TSW: Flag to indicate changes in planning rel. data | OIJ_PLSQCH | CHAR | 1 | XFELD | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZEIT | Time of creation | OI0_ERTIM | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZEIT | Time of day the record was changed | OI0_AETIM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 1 | XFELD | ||||
DELIND | Deletion indicator | OIJ_DELIND | CHAR | 1 | XFELD | ||||
CLSHIP | OIL TSW : Automatically close shipment flag | OIJ_CLSHIP | CHAR | 1 | XFELD | ||||
RDREAL | Real-time Stock Projection indicator | OIJ_REALTIME | CHAR | 1 | XFELD | ||||
EXTDET | External Details | OIJ_EXTDET | CHAR | 1 | XFELD | ||||
RDLOGIC | Stock Projection calculation logic identifier | OIJ_RDLOGIC | CHAR | 1 | OIJ_RDLOGIC | ||||
RDFCL | OIL-TSW: Corrective Rack forecast issue logic indicator | OIJ_RDFCL | CHAR | 1 | OIJ_RDFCL | ||||
RDPAST | Stock Projection Worksheet past days' inventory indicator | OIJ_RDPAST | CHAR | 1 | OIJ_RDPAST | ||||
RDNOMDAT | Nomination Stock Projection date indicator | OIJ_RDNOMDAT | CHAR | 1 | OIJ_RDNOMDAT | ||||
RDDISAG | Stock Projection disaggregation specifier | OIJ_RDDISAG | CHAR | 1 | OIJ_RDDISAG | ||||
SCHEDREL | OIL-TSW: Scheduling relevance check flag | OIJ_SCHEDREL | CHAR | 1 | XFELD | ||||
LOCCONTROL | OIL-TSW: Scheduling TSW Details location check flag | OIJ_LOCCONTROL | CHAR | 1 | OIJ_LOCCONTROL | ||||
NOMICU | OIL-TSW: Nomination item additional fields pop-up activation | OIJ_NOMICU | CHAR | 1 | XFELD | ||||
NOMHCU | OIL-TSW: Nomination header add. fields pop-up activation | OIJ_NOMHCU | CHAR | 1 | XFELD | ||||
MMOTCHK | OIL-TSW: Scheduling multiple MOT check | OIJ_MMOTCHK | CHAR | 1 | XFELD | ||||
LOCMATCU | OIL-TSW: Location/material add. fields screen activation | OIJ_LOCMATCU | CHAR | 1 | XFELD | ||||
TSMATCU | OIL-TSW: TransportSys/material add. fields screen activation | OIJ_TSMATCU | CHAR | 1 | XFELD | ||||
TSWDCHK | TSW check in SD / MM document transactions | OIJ_TSWDCHK | CHAR | 1 | XFELD | ||||
EXDETMOT | Transfer external details MoT to TSW multiple MoTs | OIJ_EXDETMOT | CHAR | 1 | XFELD | ||||
NOMDATCHK | Check scheduled date against the TSW Details date range | OIJ_NOMDATCHK | CHAR | 1 | XFELD | ||||
PLLOCFLAG | OIL TSW: Location valid on all assigned planning locations | OIJ_PLANFLAG | CHAR | 1 | XFELD | ||||
RDPLMICO | Plus/minus combined in the SPW | OIJ_RDPLMICO | CHAR | 1 | XFELD | ||||
RDMULT | All 'Multiple' items in the SPW drilled down/up | OIJ_RDMULT | CHAR | 1 | OIJ_RDMULT | OIJ_RDMULT | |||
RDDECS | Number of decimals in the SPW | OIJ_RDDECS | NUMC | 1 | OIJ_RDDECS | ||||
RDPHYS | OIL-TSW: Physical inventory in both columns | OIJ_RDPHYS | CHAR | 1 | XFELD | ||||
RDSTART | Stock Projection start day flag | OIJ_RDSTART | CHAR | 1 | OIJ_RDSTART | ||||
HEEL | Heel field name | OIJ_HEEL | CHAR | 30 | OIJ_HEEL | ||||
RDAUTOWL | Generate Stock Projection worklist automatically | OIJ_RDAUTOWL | CHAR | 1 | XFELD | ||||
RDREP | Use 'Report into inventory' functionality | OIJ_RDREP | CHAR | 1 | XFELD | ||||
CONSIDER_ROUTE | Consider Route | OIJ_CONS_ROUTE | CHAR | 1 | XFELD | ||||
RDTREE | Stock Projection object selection is based on ALV tree | OIJ_RDTREE | CHAR | 1 | XFELD | ||||
SPFLTVAL | Stock projection filter value for BADI | OIJ_SPFLTVAL | CHAR | 6 | OIJ_SP_FLTVAL | OIJ_SPFLTVAL | |||
SPDOCWHIF | Indicator: Ability to view/maintain documents in what-if pop | OIJ_SPDOCWHIF | CHAR | 1 | XFELD | ||||
ETA_EV_TYPE | Event Type for ETA | OIJ_ETA_EV_TYPE | CHAR | 4 | TOIGE | OIG_EVTYPE | |||
PS_SITYP_DMD | Default Schedule type for Pegging to Stock of Demand Items | OIJ_PS_SITYP | CHAR | 2 | TOIJ_EL_SITYPES | OIJ_SITYP | |||
PS_DOCIND_DMD | Reference document indicator for Pegging to Stock of Demand | OIJ_PS_DOCIND | CHAR | 1 | OIJ_DOCIND | ||||
PS_SITYP_SUP | Default Schedule type for Pegging to Stock of Supply Avails | OIJ_PS_SITYP_SUP | CHAR | 2 | TOIJ_EL_SITYPES | OIJ_SITYP | |||
PS_DOCIND_SUP | Reference document indicator for Pegging to Stock of Supply | OIJ_PS_DOCIND_SUP | CHAR | 1 | OIJ_DOCIND | ||||
BFDEPTH | Bifurcation Depth | OIJ_BFDEPTH | INT1 | 3 | INT1 | ||||
START_SEQ | Start of Sequence Number | OIJ_SESTART | NUMC | 5 | NUMC | ||||
INCRE_SEQ | Increment of Sequence Number | OIJ_SEINCRE | NUMC | 5 | NUMC | ||||
PRF_GRUPPE | Profile group (sort graphics profiles) | BCPRFGROUP | CHAR | 4 | TBCG | BCPRFGROUP | |||
PRF_NAME | Name of graphics profile | BCPRFNAME | CHAR | 12 | TBCG | CHAR12 | |||
PRF_INDEX | Profile index for the graphics profile | BCPRFINDEX | CHAR | 1 | TBCG | CHAR1 | |||
AMEND_MIN_QTY | Amendment quantity minimum | OIJ_AMEND_MIN_QTY | QUAN | 13(3) | MENG13 | ||||
AMEND_MIN_QTY_U | Amendment minimum quantity UOM | OIJ_AMEND_MIN_QTY_U | UNIT | 3 | T006 | CUNIT | MEINS | ||
LB_ROUTE_CHK_OBJ | LB Route check objects (Location / Transport system) | OIJ_LB_ROUTE_CHK_OBJ | CHAR | 2 | OIJ_LB_ROUTE_CHK_OBJ | ||||
LB_ROUTE_PUB | LB Publish with / without route | OIJ_LB_ROUTE_PUB | CHAR | 1 | OIJ_LB_ROUTE_PUB | ||||
DOCCO | Documents in TSW-SPW Are Consumed by Goods Movements | OIJ_DOCCO | CHAR | 1 | XFELD | ||||
SPAUTOFC | Generate Rack Forecast Automatically in Stock Projection | OIJ_SPAUTOFC | CHAR | 1 | XFELD | ||||
UPD_REFDOC | Reference Document Update | OIJ_UPD_SCHED_IND | CHAR | 1 | FLAG | ||||
GTS | Check on GTS (Global Trade Services) valid partners | OIJ_GTS | CHAR | 1 | XFELD | ||||
METER_RECON_FLAG | TSW-TD meter reconciliation flag | OIJ_METER_RECON_FLAG | CHAR | 1 | XFELD | ||||
LATELCK_3WP | 3WP LOCK STRATEGY | OIJ_3WP_LOCKSTRATEGY | CHAR | 1 | OIJ_3WP_LOCKSTRATEGY | OIJ_3WP_LOCKSTRATEGY |
Key field | Non-key field |
How do I retrieve data from SAP table OIJX using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIJX to SELECT all data from the tableDATA: WA_OIJX TYPE OIJX.
SELECT SINGLE *
FROM OIJX
INTO CORRESPONDING FIELDS OF WA_OIJX
WHERE...
How to access SAP table OIJX
Within an ECC or HANA version of SAP you can also view further information about OIJX and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects