SAP ABAP Table OIJ_EL_CP_LAYT (Charter party and laytime and demurrage agreement)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ_EL (Package) TSW Trader's and Scheduler's Workbench - Execution Layer

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIJ_EL_CP_LAYT	Table Relationship Diagram
Short Description	Charter party and laytime and demurrage agreement

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	VBELN	☑	OIJ_EL_CPNO	VBELN	CHAR	10	0	Freight contract number	*
3	VBTYP	☑	OIJ_EL_VBTYP	OIJ_EL_VBTYP	CHAR	1	0	TSW Details document type
4	POSNR	☑	OIJ_EL_POSNR	POSNR	NUMC	6	0	Contract item number	*
5	VAL_FROM	☐	OIJ_EL_VALF	DATUM	DATS	8	0	Validity period start date
6	VAL_TO	☐	OIJ_EL_VALT	DATUM	DATS	8	0	Validity period end date
7	SINGLE_VOY	☐	OIJ_EL_SV	XFELD	CHAR	1	0	Single voyage flag
8	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	OIGV
9	VEH_TYPE	☐	OIG_VHLTYP	OIG_VHLTYP	CHAR	4	0	TD vehicle type	TOIGV
10	LD_START	☐	OIJ_EL_LDS	DATUM	DATS	8	0	Charter laydays start date
11	LD_END	☐	OIJ_EL_LDE	DATUM	DATS	8	0	Charter laydays end date
12	RD_START	☐	OIJ_EL_RDS	DATUM	DATS	8	0	Redelivery time start date
13	RD_END	☐	OIJ_EL_RDE	DATUM	DATS	8	0	Redelivery time end date
14	GRADES_NO	☐	OIJ_EL_GNO	OIJ_NUMC2	NUMC	2	0	Number of product grades
15	ROUTE	☐	OIJ_EL_ROUTE	ROUTE	CHAR	6	0	Route agreed in charter contract	TVRO
16	SPEED	☐	OIJ_EL_SPEED	OIJ_Q6_01	QUAN	6	1	Charter contract: base speed for voyage
17	MIN_SPEED	☐	OIJ_EL_MINSP	OIJ_Q6_01	QUAN	6	1	Charter contract: Minimum speed
18	MAX_SPEED	☐	OIJ_EL_MAXSP	OIJ_Q6_01	QUAN	6	1	Charter contract: Maximum speed
19	SP_UOM	☐	OIJ_EL_SPUOM	MEINS	UNIT	3	0	Speed unit of measurement	T006
20	MIN_QUAN	☐	OIJ_EL_MINQU	MENG13	QUAN	13	3	Charter contract: Minimum transport quantity
21	QUAN_UOM	☐	OIJ_EL_QUUOM	MEINS	UNIT	3	0	Unit of measurement for quantity	T006
22	CAPACITY	☐	OIJ_EL_CAP	MENG13	QUAN	13	3	Charter contract: cargo size
23	CAP_UOM	☐	OIJ_EL_CAPUOM	MEINS	UNIT	3	0	Unit of measurement for capacity	T006
24	TOL_MIN	☐	OIJ_EL_TMIN	PRZ21	DEC	3	1	Cargo size tolerance - minimum
25	TOL_MAX	☐	OIJ_EL_TMAX	PRZ21	DEC	3	1	Cargo size tolerance - maximum
26	PRESSURE	☐	OIJ_EL_PRESS	OIJ_Q6_01	QUAN	6	1	Manifold pressure
27	PRES_UOM	☐	OIJ_EL_PRUOM	MEINS	UNIT	3	0	Unit of measurement for pressure	T006
28	BUNKER_L	☐	OIJ_EL_BUL	MENG13	QUAN	13	3	Bunker consumption laden
29	CL_UOM	☐	OIJ_EL_CSUOM	MEINS	UNIT	3	0	Quantity UoM for consumption	T006
30	CLT_UOM	☐	OIJ_EL_CLTUOM	MEINS	UNIT	3	0	Time UoM for consumption	T006
31	BUNKER_B	☐	OIJ_EL_BUB	MENG13	QUAN	13	3	Bunker consumption under ballast
32	ST_F_CONS	☐	OIJ_EL_STFC	MENG13	QUAN	13	3	Standby bunker fuel consumption
33	ST_D_CONS	☐	OIJ_EL_STDC	MENG13	QUAN	13	3	Standby bunker diesel consumption
34	FUEL_MG	☐	OIJ_EL_BFUEL	MATKL	CHAR	9	0	Bunker fuel material group	T023
35	DIES_MG	☐	OIJ_EL_BDIES	MATKL	CHAR	9	0	Bunker diesel material group	T023
36	DECL	☐	OIJ_EL_DECL	OIJ_EL_CHOW	CHAR	1	0	Declare flag: charterer or owner driven
37	DECL_QU	☐	OIJ_EL_DEQU	OIJ_EL_CHOW	CHAR	1	0	Declare flag: charterers or owners option
38	LPA	☐	OIJ_EL_LPA	OIJ_EL_CHOW	CHAR	1	0	Owner's or charterer's load port agent
39	DPA	☐	OIJ_EL_DPA	OIJ_EL_CHOW	CHAR	1	0	Owner's or charterer's discharge port agent
40	CONS_PERC	☐	OIJ_CONS_PERC	OIJ_CONS_PERC	DEC	4	2	OIL-TSW: Bunker Consumption Percentage for a Transp. System
41	.INCLUDE	☐				0	0	Contract laytime fields
42	WP_EVENT	☐	OIJ_EL_WPEV	OIG_EVTYPE	CHAR	4	0	Window period event	TOIGE
43	LC_EVENT	☐	OIJ_EL_LCEV	OIG_EVTYPE	CHAR	4	0	Lightering commencement event	TOIGE
44	LAY_TOTAL	☐	OIJ_EL_LAYTT	OIJ_PERIOD	QUAN	3	0	Total allowed laytime
45	DIS_TOTAL	☐	OIJ_EL_DIST	OIJ_PERIOD	QUAN	3	0	Total allowed discharge laytime
46	LAY_UOM	☐	OIJ_EL_LAYTUOM	MEINS	UNIT	3	0	Unit of measurement for laytime	T006
47	LAY_QUAN	☐	OIJ_EL_LAYQU	MENG13	QUAN	13	3	Quantity to which laytime is related
48	L_QU_UOM	☐	OIJ_EL_QUUOM	MEINS	UNIT	3	0	Unit of measurement for quantity	T006
49	LAY_MIN	☐	OIJ_EL_LAYMIN	OIJ_PERIOD	QUAN	3	0	Minimum laytime
50	LM_UOM	☐	OIJ_EL_LAYTUOM	MEINS	UNIT	3	0	Unit of measurement for laytime	T006
51	TIMEBAR	☐	OIJ_EL_TB	OIJ_PERIOD	QUAN	3	0	Timebar limit
52	TB_UOM	☐	OIJ_EL_TBUOM	MEINS	UNIT	3	0	Unit of measurement for timebar limit	T006
53	TB_EVENT	☐	OIJ_EL_TBEV	OIG_EVTYPE	CHAR	4	0	Timebar start event	TOIGE
54	COND_TYPE	☐	OIJ_EL_DERA	KSCHL	CHAR	4	0	Demurrage rate condition type	T685
55	DESP_CTYPE	☐	OIJ_EL_DSRA	KSCHL	CHAR	4	0	Despatch rate condition type	T685
56	FACT_TYPE	☐	OIJ_EL_DEFA	KSCHL	CHAR	4	0	Calculation factor condition type	T685
57	RATE_DATE	☐	OIJ_EL_RADATE	OIJ_EL_RADATE	CHAR	6	0	Condition rate date determination	TOIJ_DET_DATE
58	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
59	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
60	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
61	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
62	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
63	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
64	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
65	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
66	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJ_EL_CP_LAYT	CAP_UOM	T006	MSEHI	KEY	C	CN
2	OIJ_EL_CP_LAYT	CLT_UOM	T006	MSEHI
3	OIJ_EL_CP_LAYT	CL_UOM	T006	MSEHI	KEY	C	CN
4	OIJ_EL_CP_LAYT	COND_TYPE	T685	KSCHL		C	CN
5	OIJ_EL_CP_LAYT	DESP_CTYPE	T685	KSCHL
6	OIJ_EL_CP_LAYT	DIES_MG	T023	MATKL	KEY	1	CN
7	OIJ_EL_CP_LAYT	FACT_TYPE	T685	KSCHL		C	CN
8	OIJ_EL_CP_LAYT	FUEL_MG	T023	MATKL	KEY	1	CN
9	OIJ_EL_CP_LAYT	LAY_UOM	T006	MSEHI	KEY	C	CN
10	OIJ_EL_CP_LAYT	LC_EVENT	TOIGE	TYPE	KEY	1	CN
11	OIJ_EL_CP_LAYT	LM_UOM	T006	MSEHI	KEY	C	CN
12	OIJ_EL_CP_LAYT	L_QU_UOM	T006	MSEHI	KEY	C	CN
13	OIJ_EL_CP_LAYT	MANDT	T000	MANDT	KEY	1	CN
14	OIJ_EL_CP_LAYT	PRES_UOM	T006	MSEHI	KEY	C	CN
15	OIJ_EL_CP_LAYT	QUAN_UOM	T006	MSEHI	KEY	C	CN
16	OIJ_EL_CP_LAYT	RATE_DATE	TOIJ_DET_DATE	DATE_RULE
17	OIJ_EL_CP_LAYT	ROUTE	TVRO	ROUTE	KEY	1	CN
18	OIJ_EL_CP_LAYT	SP_UOM	T006	MSEHI	KEY	C	CN
19	OIJ_EL_CP_LAYT	TB_EVENT	TOIGE	TYPE	KEY	1	CN
20	OIJ_EL_CP_LAYT	TB_UOM	T006	MSEHI	KEY	C	CN
21	OIJ_EL_CP_LAYT	VEHICLE	OIGV	VEHICLE	KEY	1	CN
22	OIJ_EL_CP_LAYT	VEH_TYPE	TOIGV	VEH_TYPE	KEY	1	CN
23	OIJ_EL_CP_LAYT	WP_EVENT	TOIGE	TYPE	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	46C