OIJBER SAP table for – Berth Table

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

SAP OIJBER table

Table OIJBER technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BERID : Berth identifier
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • BERNAM : Freely-definable name for berth
    Its data type is CHAR (Character String) with field length 60
  • LIGHTER : Flag: Indicates if lightering is allowed at a berth
    Its data type is CHAR (Character String) with field length 1
  • EQUIP_NR : Equipment Number
    Its data type is CHAR (Character String) with field length 18
  • CP_GRP_ID : Compatibility group ID
    Its data type is CHAR (Character String) with field length 10
  • BERLEN : Length of Berth
    Its data type is QUAN (Quantity field) with field length 13
  • BERMAXDRFT : Maximum draft of a berth
    Its data type is QUAN (Quantity field) with field length 13
  • BERDEPLAT : Berth depth at LAT(Lowest Astronomical Tide)
    Its data type is QUAN (Quantity field) with field length 13
  • MINSHIPDWGHT : Minimum ship deadweight at berth
    Its data type is QUAN (Quantity field) with field length 13
  • WGT_UOM : TD weight unit of measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • DIM_UOM : TD dimension unit of measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • .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