OIJ_EL_DOC_MOT SAP table for – Oil TSW: TSW Relevance of order item

Here we would like to draw your attention to OIJ_EL_DOC_MOT 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). OIJ_EL_DOC_MOT is a SAP standard transp table used for storing Oil TSW: TSW Relevance of order item related data in SAP. It comes under the package OIJ_EL.

SAP OIJ_EL_DOC_MOT table

Table OIJ_EL_DOC_MOT technical data

TableOIJ_EL_DOC_MOT
Data storingOil TSW: TSW Relevance of order item
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ_EL
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJ_EL_DOC_MOT 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 OIJ_EL_DOC_MOT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • VBTYP : TSW Details document type
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • POSNR : Item number of the SD document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • KWMENG : Cumulative order quantity in sales units
    Its data type is QUAN (Quantity field) with field length 15
  • VRKME : Sales unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • TSYST : Transport system
    Its data type is CHAR (Character String) with field length 10
  • LOCID : Location ID
    Its data type is CHAR (Character String) with field length 10
  • EDATU : Schedule line date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TSWRELV : OIL TSW: TSW relevance flag
    Its data type is CHAR (Character String) with field length 1
  • CHARG : Batch / Valuation type
    Its data type is CHAR (Character String) with field length 10
  • RELV_TICKET : IS-Oil: Relevance type
    Its data type is CHAR (Character String) with field length 6
  • RELV_RUNDOWN : IS-Oil: Relevance type
    Its data type is CHAR (Character String) with field length 6
  • PLANLOC : Location ID
    Its data type is CHAR (Character String) with field length 10
  • REFVBELN : Sales and Distribution Document Number
    Its data type is CHAR (Character String) with field length 10
  • REFVBTYP : TSW Details document type
    Its data type is CHAR (Character String) with field length 1
  • DEALNO : OIL-TSW: Deal number (trading system)
    Its data type is CHAR (Character String) with field length 16
  • DEALGROUP : OIL-TSW: Deal group (trading system)
    Its data type is CHAR (Character String) with field length 16
  • DEALTYPE : OIL-TSW: Deal type (trading system)
    Its data type is CHAR (Character String) with field length 6
  • FROMDATE : OIL-TSW: Deal validity From date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • TODATE : OIL-TSW: Deal validity To date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EVENTTYPE : TSW event date type
    Its data type is CHAR (Character String) with field length 16
  • PR_BASIS : Pricing basis
    Its data type is CHAR (Character String) with field length 20
  • RING_TR : Ring trade identifier
    Its data type is CHAR (Character String) with field length 1
  • CO_CARR : Connecting carrier
    Its data type is CHAR (Character String) with field length 10
  • CO_SHIP : Connecting shipper
    Its data type is CHAR (Character String) with field length 10
  • ITBOTOL : Quantity tolerance over (percentage)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • ITBUTOL : Quantity tolerance under (%)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • UNLIMITED : Tolerance indicator
    Its data type is CHAR (Character String) with field length 1
  • DEV_FLAG : Amendment for quantity control
    Its data type is CHAR (Character String) with field length 1
  • DEV_MIN : Percentage quantity amendment (under).
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • DEV_MAX : Percentage quantity amendment (over)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • MASS_DEV : Group amendment allowed
    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
  • SITYP : Schedule type
    Its data type is CHAR (Character String) with field length 2