SAP Table OIJ_EL_CP_LAYT
Charter party and laytime and demurrage agreement
OIJ_EL_CP_LAYT (Charter party and laytime and demurrage agreement) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OIJ_EL_CP_LAYT to other SAP tables.
OIJ_EL_CP_LAYT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||||||
| VBELN | Freight contract number | OIJ_EL_CPNO | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||
| VBTYP | TSW Details document type | OIJ_EL_VBTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| POSNR | Contract item number | OIJ_EL_POSNR | NUMC | 6 | 0 | |||||||||||||||||||||||||||||||
| VAL_FROM | Validity period start date | OIJ_EL_VALF | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| VAL_TO | Validity period end date | OIJ_EL_VALT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| SINGLE_VOY | Single voyage flag | OIJ_EL_SV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| VEHICLE | TD Vehicle Number | OIG_VHLNMR | OIGV | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||
| VEH_TYPE | TD vehicle type | OIG_VHLTYP | TOIGV | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||
| LD_START | Charter laydays start date | OIJ_EL_LDS | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| LD_END | Charter laydays end date | OIJ_EL_LDE | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| RD_START | Redelivery time start date | OIJ_EL_RDS | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| RD_END | Redelivery time end date | OIJ_EL_RDE | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| GRADES_NO | Number of product grades | OIJ_EL_GNO | NUMC | 2 | 0 | |||||||||||||||||||||||||||||||
| ROUTE | Route agreed in charter contract | OIJ_EL_ROUTE | TVRO | CHAR | 6 | 0 | ||||||||||||||||||||||||||||||
| SPEED | Charter contract: base speed for voyage | OIJ_EL_SPEED | QUAN | 6 | 1 | |||||||||||||||||||||||||||||||
| MIN_SPEED | Charter contract: Minimum speed | OIJ_EL_MINSP | QUAN | 6 | 1 | |||||||||||||||||||||||||||||||
| MAX_SPEED | Charter contract: Maximum speed | OIJ_EL_MAXSP | QUAN | 6 | 1 | |||||||||||||||||||||||||||||||
| SP_UOM | Speed unit of measurement | OIJ_EL_SPUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| MIN_QUAN | Charter contract: Minimum transport quantity | OIJ_EL_MINQU | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||
| QUAN_UOM | Unit of measurement for quantity | OIJ_EL_QUUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| CAPACITY | Charter contract: cargo size | OIJ_EL_CAP | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||
| CAP_UOM | Unit of measurement for capacity | OIJ_EL_CAPUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| TOL_MIN | Cargo size tolerance - minimum | OIJ_EL_TMIN | DEC | 3 | 1 | |||||||||||||||||||||||||||||||
| TOL_MAX | Cargo size tolerance - maximum | OIJ_EL_TMAX | DEC | 3 | 1 | |||||||||||||||||||||||||||||||
| PRESSURE | Manifold pressure | OIJ_EL_PRESS | QUAN | 6 | 1 | |||||||||||||||||||||||||||||||
| PRES_UOM | Unit of measurement for pressure | OIJ_EL_PRUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| BUNKER_L | Bunker consumption laden | OIJ_EL_BUL | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||
| CL_UOM | Quantity UoM for consumption | OIJ_EL_CSUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| CLT_UOM | Time UoM for consumption | OIJ_EL_CLTUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| BUNKER_B | Bunker consumption under ballast | OIJ_EL_BUB | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||
| ST_F_CONS | Standby bunker fuel consumption | OIJ_EL_STFC | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||
| ST_D_CONS | Standby bunker diesel consumption | OIJ_EL_STDC | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||
| FUEL_MG | Bunker fuel material group | OIJ_EL_BFUEL | T023 | CHAR | 9 | 0 | ||||||||||||||||||||||||||||||
| DIES_MG | Bunker diesel material group | OIJ_EL_BDIES | T023 | CHAR | 9 | 0 | ||||||||||||||||||||||||||||||
| DECL | Declare flag: charterer or owner driven | OIJ_EL_DECL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| DECL_QU | Declare flag: charterers or owners option | OIJ_EL_DEQU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| LPA | Owner's or charterer's load port agent | OIJ_EL_LPA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| DPA | Owner's or charterer's discharge port agent | OIJ_EL_DPA | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| CONS_PERC | OIL-TSW: Bunker Consumption Percentage for a Transp. System | OIJ_CONS_PERC | DEC | 4 | 2 | |||||||||||||||||||||||||||||||
| WP_EVENT | Window period event | OIJ_EL_WPEV | TOIGE | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||
| LC_EVENT | Lightering commencement event | OIJ_EL_LCEV | TOIGE | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||
| LAY_TOTAL | Total allowed laytime | OIJ_EL_LAYTT | QUAN | 3 | 0 | |||||||||||||||||||||||||||||||
| DIS_TOTAL | Total allowed discharge laytime | OIJ_EL_DIST | QUAN | 3 | 0 | |||||||||||||||||||||||||||||||
| LAY_UOM | Unit of measurement for laytime | OIJ_EL_LAYTUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| LAY_QUAN | Quantity to which laytime is related | OIJ_EL_LAYQU | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||
| L_QU_UOM | Unit of measurement for quantity | OIJ_EL_QUUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| LAY_MIN | Minimum laytime | OIJ_EL_LAYMIN | QUAN | 3 | 0 | |||||||||||||||||||||||||||||||
| LM_UOM | Unit of measurement for laytime | OIJ_EL_LAYTUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| TIMEBAR | Timebar limit | OIJ_EL_TB | QUAN | 3 | 0 | |||||||||||||||||||||||||||||||
| TB_UOM | Unit of measurement for timebar limit | OIJ_EL_TBUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| TB_EVENT | Timebar start event | OIJ_EL_TBEV | TOIGE | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||
| COND_TYPE | Demurrage rate condition type | OIJ_EL_DERA | T685 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||
| DESP_CTYPE | Despatch rate condition type | OIJ_EL_DSRA | T685 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||
| FACT_TYPE | Calculation factor condition type | OIJ_EL_DEFA | T685 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||
| RATE_DATE | Condition rate date determination | OIJ_EL_RADATE | TOIJ_DET_DATE | CHAR | 6 | 0 | ||||||||||||||||||||||||||||||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| ERZEIT | Time of creation | OI0_ERTIM | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||
| AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| AEZEIT | Time of day the record was changed | OI0_AETIM | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||
| BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| DELIND | Deletion indicator | OIJ_DELIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| SERVTYPE | Field - Service Type | OIJ_SERVTYPE | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||
| TRANTYP | Transaction Type | OIJ_TRANTYP | CHAR | 5 | 0 | |||||||||||||||||||||||||||||||
| PRIORITY | Capacity | OIJ_CAPACITY | CHAR | 5 | 0 | |||||||||||||||||||||||||||||||
| SHIPPER | Connecting shipper | OIJ_EL_CSH | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||
| TSYST | Transport system | OIJ_TSYST | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||
| RLOCID | Location ID | OIJ_LOCID | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||
| DLOCID | Location ID | OIJ_LOCID | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||
| MDQ_QUAN | Quantity to which laytime is related | OIJ_EL_LAYQU | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||
| MDQ_UOM | Unit of measurement for quantity | OIJ_EL_QUUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||
| MDQB | Field - Maximum Daily Quantity | OIJ_EL_MDQB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| FUEL_PERC | OIL-TSW: Bunker Consumption Percentage for a Transp. System | OIJ_CONS_PERC | DEC | 4 | 2 | |||||||||||||||||||||||||||||||
| FUELB | Fuel Basis | OIJ_EL_FUELB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
OIJ_EL_CP_LAYT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIJ_EL_CP_LAYT | CAP_UOM | OIJ_EL_CP_LAYT | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | CAP_UOM | OIJ_EL_CP_LAYT | CAP_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | CLT_UOM | OIJ_EL_CP_LAYT | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | CLT_UOM | OIJ_EL_CP_LAYT | CLT_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | CL_UOM | OIJ_EL_CP_LAYT | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | CL_UOM | OIJ_EL_CP_LAYT | CL_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | COND_TYPE | SYST | MANDT | T685 | Conditions: Types | MANDT |
| OIJ_EL_CP_LAYT | COND_TYPE | * | T685 | Conditions: Types | KVEWE | |
| OIJ_EL_CP_LAYT | COND_TYPE | * | T685 | Conditions: Types | KAPPL | |
| OIJ_EL_CP_LAYT | COND_TYPE | OIJ_EL_CP_LAYT | COND_TYPE | T685 | Conditions: Types | KSCHL |
| OIJ_EL_CP_LAYT | DESP_CTYPE | * | T685 | Conditions: Types | KVEWE | |
| OIJ_EL_CP_LAYT | DESP_CTYPE | * | T685 | Conditions: Types | KAPPL | |
| OIJ_EL_CP_LAYT | DESP_CTYPE | OIJ_EL_CP_LAYT | DESP_CTYPE | T685 | Conditions: Types | KSCHL |
| OIJ_EL_CP_LAYT | DESP_CTYPE | SYST | MANDT | T685 | Conditions: Types | MANDT |
| OIJ_EL_CP_LAYT | DIES_MG | OIJ_EL_CP_LAYT | MANDT | T023 | Material Groups | MANDT |
| OIJ_EL_CP_LAYT | DIES_MG | OIJ_EL_CP_LAYT | DIES_MG | T023 | Material Groups | MATKL |
| OIJ_EL_CP_LAYT | FACT_TYPE | * | T685 | Conditions: Types | KAPPL | |
| OIJ_EL_CP_LAYT | FACT_TYPE | OIJ_EL_CP_LAYT | FACT_TYPE | T685 | Conditions: Types | KSCHL |
| OIJ_EL_CP_LAYT | FACT_TYPE | SYST | MANDT | T685 | Conditions: Types | MANDT |
| OIJ_EL_CP_LAYT | FACT_TYPE | * | T685 | Conditions: Types | KVEWE | |
| OIJ_EL_CP_LAYT | FUEL_MG | OIJ_EL_CP_LAYT | FUEL_MG | T023 | Material Groups | MATKL |
| OIJ_EL_CP_LAYT | FUEL_MG | OIJ_EL_CP_LAYT | MANDT | T023 | Material Groups | MANDT |
| OIJ_EL_CP_LAYT | LAY_UOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | LAY_UOM | OIJ_EL_CP_LAYT | LAY_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | LC_EVENT | SYST | MANDT | TOIGE | TD Event Types | CLIENT |
| OIJ_EL_CP_LAYT | LC_EVENT | OIJ_EL_CP_LAYT | LC_EVENT | TOIGE | TD Event Types | TYPE |
| OIJ_EL_CP_LAYT | LM_UOM | OIJ_EL_CP_LAYT | LM_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | LM_UOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | L_QU_UOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | L_QU_UOM | OIJ_EL_CP_LAYT | L_QU_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | MANDT | OIJ_EL_CP_LAYT | MANDT | T000 | Clients | MANDT |
| OIJ_EL_CP_LAYT | MDQ_UOM | OIJ_EL_CP_LAYT | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | MDQ_UOM | OIJ_EL_CP_LAYT | MDQ_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | PRES_UOM | OIJ_EL_CP_LAYT | PRES_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | PRES_UOM | OIJ_EL_CP_LAYT | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | QUAN_UOM | OIJ_EL_CP_LAYT | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | QUAN_UOM | OIJ_EL_CP_LAYT | QUAN_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | RATE_DATE | OIJ_EL_CP_LAYT | RATE_DATE | TOIJ_DET_DATE | Rules for pricing date determination | DATE_RULE |
| OIJ_EL_CP_LAYT | ROUTE | OIJ_EL_CP_LAYT | MANDT | TVRO | Routes | MANDT |
| OIJ_EL_CP_LAYT | ROUTE | OIJ_EL_CP_LAYT | ROUTE | TVRO | Routes | ROUTE |
| OIJ_EL_CP_LAYT | SP_UOM | OIJ_EL_CP_LAYT | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | SP_UOM | OIJ_EL_CP_LAYT | SP_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | TB_EVENT | OIJ_EL_CP_LAYT | TB_EVENT | TOIGE | TD Event Types | TYPE |
| OIJ_EL_CP_LAYT | TB_EVENT | SYST | MANDT | TOIGE | TD Event Types | CLIENT |
| OIJ_EL_CP_LAYT | TB_UOM | SYST | MANDT | T006 | Units of Measurement | MANDT |
| OIJ_EL_CP_LAYT | TB_UOM | OIJ_EL_CP_LAYT | TB_UOM | T006 | Units of Measurement | MSEHI |
| OIJ_EL_CP_LAYT | VEHICLE | OIJ_EL_CP_LAYT | MANDT | OIGV | TD Vehicle Header | CLIENT |
| OIJ_EL_CP_LAYT | VEHICLE | OIJ_EL_CP_LAYT | VEHICLE | OIGV | TD Vehicle Header | VEHICLE |
| OIJ_EL_CP_LAYT | VEH_TYPE | OIJ_EL_CP_LAYT | MANDT | TOIGV | TD Vehicle Type | CLIENT |
| OIJ_EL_CP_LAYT | VEH_TYPE | OIJ_EL_CP_LAYT | VEH_TYPE | TOIGV | TD Vehicle Type | VEH_TYPE |
| OIJ_EL_CP_LAYT | WP_EVENT | SYST | MANDT | TOIGE | TD Event Types | CLIENT |
| OIJ_EL_CP_LAYT | WP_EVENT | OIJ_EL_CP_LAYT | WP_EVENT | TOIGE | TD Event Types | TYPE |
