OIJSDLOC SAP table for – OIL-TSW: Multiple sources/destinations of location

Here we would like to draw your attention to OIJSDLOC 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). OIJSDLOC is a SAP standard transp table used for storing OIL-TSW: Multiple sources/destinations of location related data in SAP. It comes under the package OIJ.

SAP OIJSDLOC table

Table OIJSDLOC technical data

TableOIJSDLOC
Data storingOIL-TSW: Multiple sources/destinations of location
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • LOCID : Location ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RTSYST : OIL-TSW: Reference Transport System
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • RLOCID : Reference Location ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • USAGEIND : OIL-TSW: Usage Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SDIND : OIL-TSW: Source or Destination
    Its data type is CHAR (Character String) with field length 1
  • DOCIND : Reference document indicator (PSX)
    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
  • QUOTA : Quota in Percentage
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • PRIORITY : OIL-TSW: Transfer priority
    Its data type is INT1 (Two-byte integer – Dictionry type INT2) with field length 3
  • LOCBALIND : Location Balance Indicator
    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