OIJLOC SAP table for – Location table

Here we would like to draw your attention to OIJLOC 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). OIJLOC is a SAP standard transp table used for storing Location table related data in SAP. It comes under the package OIJ.

SAP OIJLOC table

Table OIJLOC technical data

TableOIJLOC
Data storingLocation table
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJLOC 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 OIJLOC 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
  • LOCTYP : OIL-TSW: Location type
    Its data type is CHAR (Character String) with field length 4
  • LOCNAM : Location name (used by system owner)
    Its data type is CHAR (Character String) with field length 60
  • KNOTE : OIL-TSW: Transport connection point (node reference)
    Its data type is CHAR (Character String) with field length 10
  • PLANLOC : OIL-TSW: Planning location
    Its data type is CHAR (Character String) with field length 10
  • .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
  • RDACT : Stock Projection activation indicator
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Transport System / Location Rate Structure
  • MAXRATE : Maximum rate per period
    Its data type is QUAN (Quantity field) with field length 13
  • MINRATE : Minimum rate per period
    Its data type is QUAN (Quantity field) with field length 13
  • OPERATE : Operating rate per period
    Its data type is QUAN (Quantity field) with field length 13
  • RATEUOM : Rate unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • RATEPERD : Ttime unit of measurement for rate
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Transport System/ Location usage structure
  • MAXUSAGE : Maximum volume per period
    Its data type is QUAN (Quantity field) with field length 13
  • MINUSAGE : Minimum volume per period
    Its data type is QUAN (Quantity field) with field length 13
  • OPEUSAGE : Operating volume/ weight per period
    Its data type is QUAN (Quantity field) with field length 13
  • USAGEUOM : Usage unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • USAGEPERD : Time unit of measument for usage
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .INCLUDE : Marine scheduling flags on location
  • SS_RT : Measurement Comparison calculation routine type
    Its data type is CHAR (Character String) with field length 12
  • BSCHFLAG : Berth scheduling flag
    Its data type is CHAR (Character String) with field length 1
  • BSCHPERD : Berth scheduling period
    Its data type is QUAN (Quantity field) with field length 5
  • BSCHPUOM : Unit of measurement for berth scheduling period
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TANKAGG : Aggregate Tank Constraints
    Its data type is CHAR (Character String) with field length 1
  • PBLNR : Business location identifier (IS-Oil MRN)
    Its data type is CHAR (Character String) with field length 10