OIJ_EL_CP_LAYT SAP (Charter party and laytime and demurrage agreement) Table details
Dictionary Type: Table
Description: Charter party and laytime and demurrage agreement
Description: Charter party and laytime and demurrage agreement
ABAP Code to SELECT data from OIJ_EL_CP_LAYT
Related tables to OIJ_EL_CP_LAYT
Access table OIJ_EL_CP_LAYT
Related tables to OIJ_EL_CP_LAYT
Access table OIJ_EL_CP_LAYT
Table field list including key, data, relationships and ABAP select examples
OIJ_EL_CP_LAYT is a standard SAP Table which is used to store Charter party and laytime and demurrage agreement data and is available within R/3 SAP systems depending on the version and release level.
The OIJ_EL_CP_LAYT table consists of various fields, each holding specific information or linking keys about Charter party and laytime and demurrage agreement data available in SAP. These include VBELN (Freight contract number), VBTYP (TSW Details document type), POSNR (Contract item number), VAL_FROM (Validity period start date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIJ_EL_CP_LAYT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | Freight contract number | OIJ_EL_CPNO | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
VBTYP | TSW Details document type | OIJ_EL_VBTYP | CHAR | 1 | OIJ_EL_VBTYP | ||||
POSNR | Contract item number | OIJ_EL_POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
VAL_FROM | Validity period start date | OIJ_EL_VALF | DATS | 8 | DATUM | ||||
VAL_TO | Validity period end date | OIJ_EL_VALT | DATS | 8 | DATUM | ||||
SINGLE_VOY | Single voyage flag | OIJ_EL_SV | CHAR | 1 | XFELD | ||||
VEHICLE | TD Vehicle Number | OIG_VHLNMR | CHAR | 10 | OIGV | ALPHA | OIG_VHLNMR | OIV | |
VEH_TYPE | TD vehicle type | OIG_VHLTYP | CHAR | 4 | TOIGV | OIG_VHLTYP | OIE | ||
LD_START | Charter laydays start date | OIJ_EL_LDS | DATS | 8 | DATUM | ||||
LD_END | Charter laydays end date | OIJ_EL_LDE | DATS | 8 | DATUM | ||||
RD_START | Redelivery time start date | OIJ_EL_RDS | DATS | 8 | DATUM | ||||
RD_END | Redelivery time end date | OIJ_EL_RDE | DATS | 8 | DATUM | ||||
GRADES_NO | Number of product grades | OIJ_EL_GNO | NUMC | 2 | OIJ_NUMC2 | ||||
ROUTE | Route agreed in charter contract | OIJ_EL_ROUTE | CHAR | 6 | TVRO | ROUTE | |||
SPEED | Charter contract: base speed for voyage | OIJ_EL_SPEED | QUAN | 6(1) | OIJ_Q6_01 | ||||
MIN_SPEED | Charter contract: Minimum speed | OIJ_EL_MINSP | QUAN | 6(1) | OIJ_Q6_01 | ||||
MAX_SPEED | Charter contract: Maximum speed | OIJ_EL_MAXSP | QUAN | 6(1) | OIJ_Q6_01 | ||||
SP_UOM | Speed unit of measurement | OIJ_EL_SPUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
MIN_QUAN | Charter contract: Minimum transport quantity | OIJ_EL_MINQU | QUAN | 13(3) | MENG13 | ||||
QUAN_UOM | Unit of measurement for quantity | OIJ_EL_QUUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
CAPACITY | Charter contract: cargo size | OIJ_EL_CAP | QUAN | 13(3) | MENG13 | ||||
CAP_UOM | Unit of measurement for capacity | OIJ_EL_CAPUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
TOL_MIN | Cargo size tolerance - minimum | OIJ_EL_TMIN | DEC | 3(1) | PRZ21 | ||||
TOL_MAX | Cargo size tolerance - maximum | OIJ_EL_TMAX | DEC | 3(1) | PRZ21 | ||||
PRESSURE | Manifold pressure | OIJ_EL_PRESS | QUAN | 6(1) | OIJ_Q6_01 | ||||
PRES_UOM | Unit of measurement for pressure | OIJ_EL_PRUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
BUNKER_L | Bunker consumption laden | OIJ_EL_BUL | QUAN | 13(3) | MENG13 | ||||
CL_UOM | Quantity UoM for consumption | OIJ_EL_CSUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
CLT_UOM | Time UoM for consumption | OIJ_EL_CLTUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
BUNKER_B | Bunker consumption under ballast | OIJ_EL_BUB | QUAN | 13(3) | MENG13 | ||||
ST_F_CONS | Standby bunker fuel consumption | OIJ_EL_STFC | QUAN | 13(3) | MENG13 | ||||
ST_D_CONS | Standby bunker diesel consumption | OIJ_EL_STDC | QUAN | 13(3) | MENG13 | ||||
FUEL_MG | Bunker fuel material group | OIJ_EL_BFUEL | CHAR | 9 | T023 | MATKL | |||
DIES_MG | Bunker diesel material group | OIJ_EL_BDIES | CHAR | 9 | T023 | MATKL | |||
DECL | Declare flag: charterer or owner driven | OIJ_EL_DECL | CHAR | 1 | OIJ_EL_CHOW | ||||
DECL_QU | Declare flag: charterers or owners option | OIJ_EL_DEQU | CHAR | 1 | OIJ_EL_CHOW | ||||
LPA | Owner's or charterer's load port agent | OIJ_EL_LPA | CHAR | 1 | OIJ_EL_CHOW | ||||
DPA | Owner's or charterer's discharge port agent | OIJ_EL_DPA | CHAR | 1 | OIJ_EL_CHOW | ||||
CONS_PERC | OIL-TSW: Bunker Consumption Percentage for a Transp. System | OIJ_CONS_PERC | DEC | 4(2) | OIJ_CONS_PERC | ||||
WP_EVENT | Window period event | OIJ_EL_WPEV | CHAR | 4 | TOIGE | OIG_EVTYPE | |||
LC_EVENT | Lightering commencement event | OIJ_EL_LCEV | CHAR | 4 | TOIGE | OIG_EVTYPE | |||
LAY_TOTAL | Total allowed laytime | OIJ_EL_LAYTT | QUAN | 3 | OIJ_PERIOD | ||||
DIS_TOTAL | Total allowed discharge laytime | OIJ_EL_DIST | QUAN | 3 | OIJ_PERIOD | ||||
LAY_UOM | Unit of measurement for laytime | OIJ_EL_LAYTUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
LAY_QUAN | Quantity to which laytime is related | OIJ_EL_LAYQU | QUAN | 13(3) | MENG13 | ||||
L_QU_UOM | Unit of measurement for quantity | OIJ_EL_QUUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
LAY_MIN | Minimum laytime | OIJ_EL_LAYMIN | QUAN | 3 | OIJ_PERIOD | ||||
LM_UOM | Unit of measurement for laytime | OIJ_EL_LAYTUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
TIMEBAR | Timebar limit | OIJ_EL_TB | QUAN | 3 | OIJ_PERIOD | ||||
TB_UOM | Unit of measurement for timebar limit | OIJ_EL_TBUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
TB_EVENT | Timebar start event | OIJ_EL_TBEV | CHAR | 4 | TOIGE | OIG_EVTYPE | |||
COND_TYPE | Demurrage rate condition type | OIJ_EL_DERA | CHAR | 4 | T685 | KSCHL | |||
DESP_CTYPE | Despatch rate condition type | OIJ_EL_DSRA | CHAR | 4 | T685 | KSCHL | |||
FACT_TYPE | Calculation factor condition type | OIJ_EL_DEFA | CHAR | 4 | T685 | KSCHL | |||
RATE_DATE | Condition rate date determination | OIJ_EL_RADATE | CHAR | 6 | TOIJ_DET_DATE | OIJ_EL_RADATE | |||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZEIT | Time of creation | OI0_ERTIM | TIMS | 6 | UZEIT | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AEZEIT | Time of day the record was changed | OI0_AETIM | TIMS | 6 | UZEIT | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 1 | XFELD | ||||
DELIND | Deletion indicator | OIJ_DELIND | CHAR | 1 | XFELD | ||||
SERVTYPE | Field - Service Type | OIJ_SERVTYPE | CHAR | 15 | OIJ_SERVTYPE | ||||
TRANTYP | Transaction Type | OIJ_TRANTYP | CHAR | 5 | OIJ_TRANTYP | ||||
PRIORITY | Capacity | OIJ_CAPACITY | CHAR | 5 | OIJ_CAPACITY | ||||
SHIPPER | Connecting shipper | OIJ_EL_CSH | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
TSYST | Transport system | OIJ_TSYST | CHAR | 10 | Assigned to domain | OIJ_TSYST | OIW | ||
RLOCID | Location ID | OIJ_LOCID | CHAR | 10 | Assigned to domain | OIJ_LOCID | OIX | ||
DLOCID | Location ID | OIJ_LOCID | CHAR | 10 | Assigned to domain | OIJ_LOCID | OIX | ||
MDQ_QUAN | Quantity to which laytime is related | OIJ_EL_LAYQU | QUAN | 13(3) | MENG13 | ||||
MDQ_UOM | Unit of measurement for quantity | OIJ_EL_QUUOM | UNIT | 3 | T006 | CUNIT | MEINS | ||
MDQB | Field - Maximum Daily Quantity | OIJ_EL_MDQB | CHAR | 1 | OIJ_EL_MDQB | ||||
FUEL_PERC | OIL-TSW: Bunker Consumption Percentage for a Transp. System | OIJ_CONS_PERC | DEC | 4(2) | OIJ_CONS_PERC | ||||
FUELB | Fuel Basis | OIJ_EL_FUELB | CHAR | 1 | OIJ_EL_FUELB |
Key field | Non-key field |
How do I retrieve data from SAP table OIJ_EL_CP_LAYT using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIJ_EL_CP_LAYT to SELECT all data from the tableDATA: WA_OIJ_EL_CP_LAYT TYPE OIJ_EL_CP_LAYT.
SELECT SINGLE *
FROM OIJ_EL_CP_LAYT
INTO CORRESPONDING FIELDS OF WA_OIJ_EL_CP_LAYT
WHERE...
How to access SAP table OIJ_EL_CP_LAYT
Within an ECC or HANA version of SAP you can also view further information about OIJ_EL_CP_LAYT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects