Which CDS Views use OIJ_EL_CP_LAYT?

OIJ_EL_CP_LAYT is used by 6 CDS view(s), including: I_FreightContractVH, I_TripOutbDeliveryItemTP, I_TripOutboundDelivery, I_TripOutboundDeliveryVH, I_TripPurchaseContractVH, I_TripSalesContractVH.

How many fields does OIJ_EL_CP_LAYT have?

OIJ_EL_CP_LAYT has 78 fields. Key fields: mandt, vbeln, vbtyp, posnr.

OIJ_EL_CP_LAYT

Transparent Table Application Table

78 Fields 6 CDS Views

Charter party and laytime and demurrage agreement

OIJ_EL_CP_LAYT is an SAP database table in S/4HANA. Charter party and laytime and demurrage agreement. It contains 78 fields. 6 CDS views read from this table.

CDS Views using this table (6)

View	Type	Join	VDM	Description
I_FreightContractVH	view	left_outer	BASIC	Value Help for Freight Contract
I_TripOutbDeliveryItemTP	view	left_outer	TRANSACTIONAL	Outbound Delivery Items
I_TripOutboundDelivery	view	left_outer	BASIC	Outbound Delivery details
I_TripOutboundDeliveryVH	view	left_outer	BASIC	Value Help for Outbound Delivery
I_TripPurchaseContractVH	view	left_outer	BASIC	Value Help for Purchase Contract
I_TripSalesContractVH	view	left_outer	BASIC	Value Help for Sales Contract

Fields (78)

Key	Field	Data Element	Description
KEY	mandt	MANDT	Client
KEY	vbeln	OIJ_EL_CPNO	Contract no.
KEY	vbtyp	OIJ_EL_VBTYP	TSW Det.Doc typ
KEY	posnr	OIJ_EL_POSNR	Item
	val_from	OIJ_EL_VALF	Valid from
	val_to	OIJ_EL_VALT	Valid to
	single_voy	OIJ_EL_SV	Single voyage
	vehicle	OIG_VHLNMR	Vehicle Number
	veh_type	OIG_VHLTYP	Vehicle type
	ld_start	OIJ_EL_LDS	Laydays start
	ld_end	OIJ_EL_LDE	Laydays end
	rd_start	OIJ_EL_RDS	Redeliv. start
	rd_end	OIJ_EL_RDE	Redeliv. end
	grades_no	OIJ_EL_GNO	Number grades
	route	OIJ_EL_ROUTE	Route
	speed	OIJ_EL_SPEED	Base speed
	min_speed	OIJ_EL_MINSP	Minimum speed
	max_speed	OIJ_EL_MAXSP	Maximum speed
	sp_uom	OIJ_EL_SPUOM	UoM speed
	min_quan	OIJ_EL_MINQU	Min. quantity
	quan_uom	OIJ_EL_QUUOM	Quantity UoM
	capacity	OIJ_EL_CAP	Cargo size
	cap_uom	OIJ_EL_CAPUOM	Capacity UoM
	tol_min	OIJ_EL_TMIN	Min. tolerance
	tol_max	OIJ_EL_TMAX	Max. tolerance
	pressure	OIJ_EL_PRESS	Man. pressure
	pres_uom	OIJ_EL_PRUOM	Pressure UoM
	bunker_l	OIJ_EL_BUL	Cons. laden
	cl_uom	OIJ_EL_CSUOM	Quan. UoM
	clt_uom	OIJ_EL_CLTUOM	Time UoM
	bunker_b	OIJ_EL_BUB	Cons. ballasted
	st_f_cons	OIJ_EL_STFC	Standby fuel
	st_d_cons	OIJ_EL_STDC	Standby diesel
	fuel_mg	OIJ_EL_BFUEL	Fuel mat. group
	dies_mg	OIJ_EL_BDIES	Dies. mat group
	decl	OIJ_EL_DECL	Declare ship by
	decl_qu	OIJ_EL_DEQU	Decl. Quantity
	lpa	OIJ_EL_LPA	Load port agent
	dpa	OIJ_EL_DPA	Dis. port agent
	cons_perc	OIJ_CONS_PERC	Bunker Cons.Perc.
	wp_event	OIJ_EL_WPEV	Window per. ev.
	lc_event	OIJ_EL_LCEV	Light. comm. ev
	lay_total	OIJ_EL_LAYTT	Total laytime
	dis_total	OIJ_EL_DIST	Discharge layt.
	lay_uom	OIJ_EL_LAYTUOM	Laytime UoM
	lay_quan	OIJ_EL_LAYQU	Layt. quantity
	l_qu_uom	OIJ_EL_QUUOM	Quantity UoM
	lay_min	OIJ_EL_LAYMIN	Min. laytime
	lm_uom	OIJ_EL_LAYTUOM	Laytime UoM
	timebar	OIJ_EL_TB	Timebar limit
	tb_uom	OIJ_EL_TBUOM	Timebar UoM
	tb_event	OIJ_EL_TBEV	Timebar start
	cond_type	OIJ_EL_DERA	Demurrage rate
	desp_ctype	OIJ_EL_DSRA	Despatch rate
	fact_type	OIJ_EL_DEFA	Calcul. factor
	rate_date	OIJ_EL_RADATE	Cond. rate date
	erdat	ERDAT	Created On
	erzeit	OI0_ERTIM	Created
	ernam	ERNAM	Created By
	aedat	AEDAT	Changed On
	aezeit	OI0_AETIM	Changed
	aenam	AENAM	Changed By
	bloind	OIJ_BLOIND	Blocking ind.
	delind	OIJ_DELIND	Deletion ind.
	tktselect	OIJ_TKTSELECT	Flag to Select Tkt
	servtype	OIJ_SERVTYPE	Service Type
	trantyp	OIJ_TRANTYP	Transaction Type
	priority	OIJ_CAPACITY	Capacity
	shipper	OIJ_EL_CSH	Con. shipper
	tsyst	OIJ_TSYST	Trans system
	rlocid	OIJ_LOCID	Location ID
	dlocid	OIJ_LOCID	Location ID
	mdq_quan	OIJ_EL_LAYQU	Layt. quantity
	mdq_uom	OIJ_EL_QUUOM	Quantity UoM
	mdqb	OIJ_EL_MDQB	MDQ PoV
	fuel_perc	OIJ_CONS_PERC	Bunker Cons.Perc.
	fuelb	OIJ_EL_FUELB	Fuel PoV
	_dataaging	DATA_TEMPERATURE	Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Charter party and laytime and demurrage agreement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ_EL_CP_LAYT (
    MANDT,       -- Client [MANDT]
    VBELN,       -- Contract no. [OIJ_EL_CPNO]
    VBTYP,       -- TSW Det.Doc typ [OIJ_EL_VBTYP]
    POSNR,       -- Item [OIJ_EL_POSNR]
    VAL_FROM,    -- Valid from [OIJ_EL_VALF]
    VAL_TO,      -- Valid to [OIJ_EL_VALT]
    SINGLE_VOY,  -- Single voyage [OIJ_EL_SV]
    VEHICLE,     -- Vehicle Number [OIG_VHLNMR]
    VEH_TYPE,    -- Vehicle type [OIG_VHLTYP]
    LD_START,    -- Laydays start [OIJ_EL_LDS]
    LD_END,      -- Laydays end [OIJ_EL_LDE]
    RD_START,    -- Redeliv. start [OIJ_EL_RDS]
    RD_END,      -- Redeliv. end [OIJ_EL_RDE]
    GRADES_NO,   -- Number grades [OIJ_EL_GNO]
    ROUTE,       -- Route [OIJ_EL_ROUTE]
    SPEED,       -- Base speed [OIJ_EL_SPEED]
    MIN_SPEED,   -- Minimum speed [OIJ_EL_MINSP]
    MAX_SPEED,   -- Maximum speed [OIJ_EL_MAXSP]
    SP_UOM,      -- UoM speed [OIJ_EL_SPUOM]
    MIN_QUAN,    -- Min. quantity [OIJ_EL_MINQU]
    QUAN_UOM,    -- Quantity UoM [OIJ_EL_QUUOM]
    CAPACITY,    -- Cargo size [OIJ_EL_CAP]
    CAP_UOM,     -- Capacity UoM [OIJ_EL_CAPUOM]
    TOL_MIN,     -- Min. tolerance [OIJ_EL_TMIN]
    TOL_MAX,     -- Max. tolerance [OIJ_EL_TMAX]
    PRESSURE,    -- Man. pressure [OIJ_EL_PRESS]
    PRES_UOM,    -- Pressure UoM [OIJ_EL_PRUOM]
    BUNKER_L,    -- Cons. laden [OIJ_EL_BUL]
    CL_UOM,      -- Quan. UoM [OIJ_EL_CSUOM]
    CLT_UOM,     -- Time UoM [OIJ_EL_CLTUOM]
    BUNKER_B,    -- Cons. ballasted [OIJ_EL_BUB]
    ST_F_CONS,   -- Standby fuel [OIJ_EL_STFC]
    ST_D_CONS,   -- Standby diesel [OIJ_EL_STDC]
    FUEL_MG,     -- Fuel mat. group [OIJ_EL_BFUEL]
    DIES_MG,     -- Dies. mat group [OIJ_EL_BDIES]
    DECL,        -- Declare ship by [OIJ_EL_DECL]
    DECL_QU,     -- Decl. Quantity [OIJ_EL_DEQU]
    LPA,         -- Load port agent [OIJ_EL_LPA]
    DPA,         -- Dis. port agent [OIJ_EL_DPA]
    CONS_PERC,   -- Bunker Cons.Perc. [OIJ_CONS_PERC]
    WP_EVENT,    -- Window per. ev. [OIJ_EL_WPEV]
    LC_EVENT,    -- Light. comm. ev [OIJ_EL_LCEV]
    LAY_TOTAL,   -- Total laytime [OIJ_EL_LAYTT]
    DIS_TOTAL,   -- Discharge layt. [OIJ_EL_DIST]
    LAY_UOM,     -- Laytime UoM [OIJ_EL_LAYTUOM]
    LAY_QUAN,    -- Layt. quantity [OIJ_EL_LAYQU]
    L_QU_UOM,    -- Quantity UoM [OIJ_EL_QUUOM]
    LAY_MIN,     -- Min. laytime [OIJ_EL_LAYMIN]
    LM_UOM,      -- Laytime UoM [OIJ_EL_LAYTUOM]
    TIMEBAR,     -- Timebar limit [OIJ_EL_TB]
    TB_UOM,      -- Timebar UoM [OIJ_EL_TBUOM]
    TB_EVENT,    -- Timebar start [OIJ_EL_TBEV]
    COND_TYPE,   -- Demurrage rate [OIJ_EL_DERA]
    DESP_CTYPE,  -- Despatch rate [OIJ_EL_DSRA]
    FACT_TYPE,   -- Calcul. factor [OIJ_EL_DEFA]
    RATE_DATE,   -- Cond. rate date [OIJ_EL_RADATE]
    ERDAT,       -- Created On [ERDAT]
    ERZEIT,      -- Created [OI0_ERTIM]
    ERNAM,       -- Created By [ERNAM]
    AEDAT,       -- Changed On [AEDAT]
    AEZEIT,      -- Changed [OI0_AETIM]
    AENAM,       -- Changed By [AENAM]
    BLOIND,      -- Blocking ind. [OIJ_BLOIND]
    DELIND,      -- Deletion ind. [OIJ_DELIND]
    TKTSELECT,   -- Flag to Select Tkt [OIJ_TKTSELECT]
    SERVTYPE,    -- Service Type [OIJ_SERVTYPE]
    TRANTYP,     -- Transaction Type [OIJ_TRANTYP]
    PRIORITY,    -- Capacity [OIJ_CAPACITY]
    SHIPPER,     -- Con. shipper [OIJ_EL_CSH]
    TSYST,       -- Trans system [OIJ_TSYST]
    RLOCID,      -- Location ID [OIJ_LOCID]
    DLOCID,      -- Location ID [OIJ_LOCID]
    MDQ_QUAN,    -- Layt. quantity [OIJ_EL_LAYQU]
    MDQ_UOM,     -- Quantity UoM [OIJ_EL_QUUOM]
    MDQB,        -- MDQ PoV [OIJ_EL_MDQB]
    FUEL_PERC,   -- Bunker Cons.Perc. [OIJ_CONS_PERC]
    FUELB,       -- Fuel PoV [OIJ_EL_FUELB]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, VBELN, VBTYP, POSNR)
);

Depth:

OIJ_EL_CP_LAYT

CDS Views using this table (6)

Fields (78)

Learn More