1. SAP Tutorial
  2. Oil & Gas

OIJ_EL_CP_LAYT SAP table for – Charter party and laytime and demurrage agreement

Here we would like to draw your attention to OIJ_EL_CP_LAYT 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_CP_LAYT is a SAP standard transp table used for storing Charter party and laytime and demurrage agreement related data in SAP. It comes under the package OIJ_EL.

SAP OIJ_EL_CP_LAYT table

Table OIJ_EL_CP_LAYT technical data

TableOIJ_EL_CP_LAYT
Data storingCharter party and laytime and demurrage agreement
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_CP_LAYT 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_CP_LAYT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VBELN : Freight contract 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 : Contract item number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • VAL_FROM : Validity period start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VAL_TO : Validity period end date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SINGLE_VOY : Single voyage flag
    Its data type is CHAR (Character String) with field length 1
  • VEHICLE : TD Vehicle Number
    Its data type is CHAR (Character String) with field length 10
  • VEH_TYPE : TD vehicle type
    Its data type is CHAR (Character String) with field length 4
  • LD_START : Charter laydays start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LD_END : Charter laydays end date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RD_START : Redelivery time start date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RD_END : Redelivery time end date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GRADES_NO : Number of product grades
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ROUTE : Route agreed in charter contract
    Its data type is CHAR (Character String) with field length 6
  • SPEED : Charter contract: base speed for voyage
    Its data type is QUAN (Quantity field) with field length 6
  • MIN_SPEED : Charter contract: Minimum speed
    Its data type is QUAN (Quantity field) with field length 6
  • MAX_SPEED : Charter contract: Maximum speed
    Its data type is QUAN (Quantity field) with field length 6
  • SP_UOM : Speed unit of measurement
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MIN_QUAN : Charter contract: Minimum transport quantity
    Its data type is QUAN (Quantity field) with field length 13
  • QUAN_UOM : Unit of measurement for quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CAPACITY : Charter contract: cargo size
    Its data type is QUAN (Quantity field) with field length 13
  • CAP_UOM : Unit of measurement for capacity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TOL_MIN : Cargo size tolerance – minimum
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • TOL_MAX : Cargo size tolerance – maximum
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • PRESSURE : Manifold pressure
    Its data type is QUAN (Quantity field) with field length 6
  • PRES_UOM : Unit of measurement for pressure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BUNKER_L : Bunker consumption laden
    Its data type is QUAN (Quantity field) with field length 13
  • CL_UOM : Quantity UoM for consumption
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CLT_UOM : Time UoM for consumption
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • BUNKER_B : Bunker consumption under ballast
    Its data type is QUAN (Quantity field) with field length 13
  • ST_F_CONS : Standby bunker fuel consumption
    Its data type is QUAN (Quantity field) with field length 13
  • ST_D_CONS : Standby bunker diesel consumption
    Its data type is QUAN (Quantity field) with field length 13
  • FUEL_MG : Bunker fuel material group
    Its data type is CHAR (Character String) with field length 9
  • DIES_MG : Bunker diesel material group
    Its data type is CHAR (Character String) with field length 9
  • DECL : Declare flag: charterer or owner driven
    Its data type is CHAR (Character String) with field length 1
  • DECL_QU : Declare flag: charterers or owners option
    Its data type is CHAR (Character String) with field length 1
  • LPA : Owner’s or charterer’s load port agent
    Its data type is CHAR (Character String) with field length 1
  • DPA : Owner’s or charterer’s discharge port agent
    Its data type is CHAR (Character String) with field length 1
  • CONS_PERC : OIL-TSW: Bunker Consumption Percentage for a Transp. System
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 4
  • .INCLUDE : Contract laytime fields
  • WP_EVENT : Window period event
    Its data type is CHAR (Character String) with field length 4
  • LC_EVENT : Lightering commencement event
    Its data type is CHAR (Character String) with field length 4
  • LAY_TOTAL : Total allowed laytime
    Its data type is QUAN (Quantity field) with field length 3
  • DIS_TOTAL : Total allowed discharge laytime
    Its data type is QUAN (Quantity field) with field length 3
  • LAY_UOM : Unit of measurement for laytime
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • LAY_QUAN : Quantity to which laytime is related
    Its data type is QUAN (Quantity field) with field length 13
  • L_QU_UOM : Unit of measurement for quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • LAY_MIN : Minimum laytime
    Its data type is QUAN (Quantity field) with field length 3
  • LM_UOM : Unit of measurement for laytime
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TIMEBAR : Timebar limit
    Its data type is QUAN (Quantity field) with field length 3
  • TB_UOM : Unit of measurement for timebar limit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TB_EVENT : Timebar start event
    Its data type is CHAR (Character String) with field length 4
  • COND_TYPE : Demurrage rate condition type
    Its data type is CHAR (Character String) with field length 4
  • DESP_CTYPE : Despatch rate condition type
    Its data type is CHAR (Character String) with field length 4
  • FACT_TYPE : Calculation factor condition type
    Its data type is CHAR (Character String) with field length 4
  • RATE_DATE : Condition rate date determination
    Its data type is CHAR (Character String) with field length 6
  • .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

    • OIJ_EL_CP_LAYT related tables

    • OIJ_EL_DOC_EV : Rules for nomination events
    • OIJ_EL_DOC_MOT : Oil TSW: TSW Relevance of order item
    • OIJ_EL_EVT_TYPE : Event date types
    • OIJ_EL_CP_LAYT : Charter party and laytime and demurrage agreement
    • OIJ_EL_DEALGRTX : OIL-TSW: Deal group texts (trading system)
    • OIJ_EL_DEALTYPET : OIL-TSW: Deal type texts (trading system)
    • OIJ_EL_DOC_I_REF : Document item reference to nomination
    • TOIJ_EL_LAYT_INF : Default laytime terms for documents
    • TOIJ_EL_MVSCENT : TSW: Movement scenario descriptions
    • TOIJ_EL_INCOMP : IS-OIL TSW: Activate incompletion for sales and purchasing
    • OIJ_EL_DEALGROUP : OIL-TSW: Deal groups (trading system)
    • TOIJ_EL_PR_RT : Prorate Calculation Routine Type
    • OIJ_EL_DOC_H_REF : Oil TSW: Document header reference to nomination; not used
    • OIJ_EL_CP_LOC : Charter party contract: load and discharge locations
    • OIJ_EL_EVT_TYPET : Event date types – texts
    • TOIJ_EL_LAYT : Default Laytime Term Code
    • OIJ_EL_LAYT_EV : Laytime start and end events
    • TOIJ_EL_INC_F : IS-OIL TSW: specify incompletion fields
    • TOIJ_EL_MS_GROUP : Oil TSW: Assign function groups to movement scenarios
    • TOIJ_EL_DOC_SD : Choose screens for TSW details pop-up in SD contracts

    OIJ_EL_CP_LAYT related transaction codes under SAP package OIJ_EL

    • O4TSW_PD : Production data
    • O4TAPN : Automatically process nominations
    • O5V1 : Number range maintenance: OIJ_EL_TKT
    • O4TDG : OIL TSW: Maintain deal groups

    Related References

    Related Tutorials

    OIJ_EL_CP_LOC SAP table for – Charter party contract: load and discharge locations

    OIJ_EL_CP_LOC table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Charter party contract:...

    OIJ_EL_LAYT_INF SAP table for – Laytime terms

    OIJ_EL_LAYT_INF table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Laytime terms. See...

    OIJ_EL_LAYT_EV SAP table for – Laytime start and end events

    OIJ_EL_LAYT_EV table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Laytime start and...

    OIJ_EL_CP_PROD SAP table for – Charter contracts: products and product groups

    OIJ_EL_CP_PROD table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Charter contracts: products...

    OIJ_EL_DOC_I_REF SAP table for – Document item reference to nomination

    OIJ_EL_DOC_I_REF table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Document item reference...

    OIJ_EL_DOC_EV SAP table for – Rules for nomination events

    OIJ_EL_DOC_EV table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Rules for nomination...

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

    OIJ_EL_DOC_MOT table in SAP IS-OIL (Downstream in IS-OIL) module. This table is used for storing data of Oil TSW: TSW...

    «
    »