Which CDS Views use OIJ_EL_TICKET_I?

OIJ_EL_TICKET_I is used by 7 CDS view(s), including: E_NominationTicketItem, I_ACMUniversalTicketItem, I_NominationTicketItemFld, I_TicketErrorLogCheck, I_TicketItemFld, I_TicketKeyVH, OIJ07_TICKET_FEILDS.

How many fields does OIJ_EL_TICKET_I have?

OIJ_EL_TICKET_I has 94 fields. Key fields: mandt, ticket_key, ticket_item, ticket_version, ticket_purpose.

OIJ_EL_TICKET_I

Transparent Table Application Table

94 Fields 7 CDS Views

Universal ticket item table

OIJ_EL_TICKET_I is an SAP database table in S/4HANA. Universal ticket item table. It contains 94 fields. 7 CDS views read from this table.

CDS Views using this table (7)

View	Type	Join	VDM	Description
E_NominationTicketItem	view	from	EXTENSION	Extension View for TSW Ticket Item Table
I_ACMUniversalTicketItem	view	from	BASIC	Universal Ticket Item
I_NominationTicketItemFld	view	from	BASIC	Nomination Ticket Item Fields
I_TicketErrorLogCheck	view	left_outer	BASIC	Ticket Error Log Check
I_TicketItemFld	view	from	BASIC	Ticket Items Fields
I_TicketKeyVH	view	inner	BASIC	Ticket Key Value Help
OIJ07_TICKET_FEILDS	view	left_outer		CDS for ticket feilds from ticket item table

Fields (94)

Key	Field	Data Element	Description
KEY	mandt	MANDT	Client
KEY	ticket_key	OIJ_EL_TKT_KEY	Ticket key
KEY	ticket_item	OIJ_EL_TKT_POSNR	Item number
KEY	ticket_version	OIJ_EL_TKT_VERSION	Ticket version
KEY	ticket_purpose	OIJ_EL_TKT_PURPOSE	Ticket Purpose
	ext_posnr	OIJ_EL_EXT_POS	External pos.
	status	OIJ_ISTAT	Item status
	substatus	OIJ_SSTAT	Item sub-status
	sityp	OIJ_SITYP	Sched.type
	tktsubrc	OIJ_TKTRC	Return code
	mvscenario	OIJ_MVSCEN	Mvmt.scenario
	nomnr	OIJ_NOMNR	Nomination no.
	nomtk	OIJ_NOMTK	Nomination key
	nomit	OIJ_ITEM	Nom. key item
	receiver	OIJ_PARTNR	Loc.partner
	locid	OIJ_LOCID	Location ID
	tanknr	OIJ_BSEQNR	Tank seq. no.
	vehicle	OIG_VHLNMR	Vehicle Number
	menge	OIJ_MENGE	SchedQty
	grosquan	OIJ_MENGE	SchedQty
	meins	MEINS	Base Unit
	matnr	MATNR	Material
	tankage	OIJ_TANKAGE	Tankage partner
	supplier	OIJ_PARTNR	Loc.partner
	consigne	OIJ_CONSIGNEE	ConsigneePartnr
	agreed_qty	OIJ_AGGRDQTY	Agreed Qty.
	agreed_qty_uom	OIJ_LDUOM	LD Matrl. UOM
	ship_qty	OIJ_SHIPQTY	Ship Qty.
	ship_qty_uom	OIJ_LDUOM	LD Matrl. UOM
	mttmp	OIB_MTTMP	Mat.Temperature
	mtteh	OIB_MTTEH	Mat.Temp.Unit
	o_api_grav	OIB_TDICH	Test Density
	api_grt_d	OIB_TDICH	Test Density
	tstmp	OIB_TSTMP	Test Temp.
	tsteh	OIB_TSTEH	Test Temp.Unit
	tdich	OIB_TDICH	Test Density
	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
	budat	BUDAT	Posting Date
	close_nomit	OIJ_EL_CLOSE_NOMIT	Close nomination itm
	eventtype	OIJ_EVENTTYPE	Event date type
	event_date	OIJ_EVENT_DATE	Event date
	gmmnr	OII_GMMNR	Gen. meter no.
	o_itmstm	TIMESTAMP	Time Stamp
	o_metev	OII_METEV	Met. event type
	c_itmstm	TIMESTAMP	Time Stamp
	c_metev	OII_METEV	Met. event type
	stoprdg	OII_ENCOUN	End reading
	stm_quantity	OIJ_STM_QUANT	St.mt.Qty
	stm_uom	OIJ_STM_UOM	Stm.Uom
	socnr	OII_SOCNR	SOCSEG number
	o_dip_read	OIJ_O_DIP_READ	Open Dip
	o_dip_read_uom	OII_LENUN	Length UoM
	o_etmstm	OIB_TMSTM	Dip timestamp
	o_socev	OIB_DIP_EVENTKEY	Event key
	c_dip_read	OIJ_C_DIP_READ	CloseDip
	c_dip_read_uom	OII_LENUN	Length UoM
	c_etmstm	OIB_TMSTM	Dip timestamp
	c_socev	OIB_DIP_EVENTKEY	Event key
	stopdip	OII_TOTALHEIGHT	Total height
	stopdip_uom	OII_LENUN	Length UoM
	stp_gau_quan	OIJ_STG_QUAN	Stp.GaugeQty
	stp_gau_uom	OIJ_STG_UOM	Stp.Gau.Uom
	gau_quantity	OIJ_GAU_QUAN	GaugeQty
	gau_uom	OIJ_GAU_UOM	GaugeUoM
	shtype	OIG_TDSTYP	Bulk shipm.type
	vstel	VSTEL	Shipping Point
	charg_o	OIJ_CHARGO	Batch orig
	werks_o	WERKS_D	Plant
	lgort_o	LGORT_D	Location
	charg_d	OIJ_CHARGD	Batch dest.
	werks_d	WERKS_D	Plant
	lgort_d	LGORT_D	Location
	time_st_load_sta	TMSTMP	Creation Time
	time_st_load_end	TMSTMP	Creation Time
	time_st_led_ot	TMSTMP	Creation Time
	charg_d_create	OIJ_CHARG_D_C	Batch create
	oib_bltime	OIB_BLTIME	Posting time
	charg_l	OIJ_CHARGL	Batch load
	charg_l_create	OIJ_CHARG_L_C	Ld. Btch create
	shtyp	SHTYP	Shipment Type
	menge_par	OIJ_MENGE_PAR	SchedParQty
	unit_i_par	OIJ_UNIT_PAR	PUoM
	railcarqty	OIJ_RU_RAILQTY	No. of Railcars
	_dataaging	DATA_TEMPERATURE	Data Aging
	dummy_tktitm_incl_eew_ps	OIJ07_EXTN	Extension Field
	tm_ttrq_handle_i	OINSC_TM_TTRQ_HANDLE	UUID

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.

-- Universal ticket item table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE OIJ_EL_TICKET_I (
    MANDT,                     -- Client [MANDT]
    TICKET_KEY,                -- Ticket key [OIJ_EL_TKT_KEY]
    TICKET_ITEM,               -- Item number [OIJ_EL_TKT_POSNR]
    TICKET_VERSION,            -- Ticket version [OIJ_EL_TKT_VERSION]
    TICKET_PURPOSE,            -- Ticket Purpose [OIJ_EL_TKT_PURPOSE]
    EXT_POSNR,                 -- External pos. [OIJ_EL_EXT_POS]
    STATUS,                    -- Item status [OIJ_ISTAT]
    SUBSTATUS,                 -- Item sub-status [OIJ_SSTAT]
    SITYP,                     -- Sched.type [OIJ_SITYP]
    TKTSUBRC,                  -- Return code [OIJ_TKTRC]
    MVSCENARIO,                -- Mvmt.scenario [OIJ_MVSCEN]
    NOMNR,                     -- Nomination no. [OIJ_NOMNR]
    NOMTK,                     -- Nomination key [OIJ_NOMTK]
    NOMIT,                     -- Nom. key item [OIJ_ITEM]
    RECEIVER,                  -- Loc.partner [OIJ_PARTNR]
    LOCID,                     -- Location ID [OIJ_LOCID]
    TANKNR,                    -- Tank seq. no. [OIJ_BSEQNR]
    VEHICLE,                   -- Vehicle Number [OIG_VHLNMR]
    MENGE,                     -- SchedQty [OIJ_MENGE]
    GROSQUAN,                  -- SchedQty [OIJ_MENGE]
    MEINS,                     -- Base Unit [MEINS]
    MATNR,                     -- Material [MATNR]
    TANKAGE,                   -- Tankage partner [OIJ_TANKAGE]
    SUPPLIER,                  -- Loc.partner [OIJ_PARTNR]
    CONSIGNE,                  -- ConsigneePartnr [OIJ_CONSIGNEE]
    AGREED_QTY,                -- Agreed Qty. [OIJ_AGGRDQTY]
    AGREED_QTY_UOM,            -- LD Matrl. UOM [OIJ_LDUOM]
    SHIP_QTY,                  -- Ship Qty. [OIJ_SHIPQTY]
    SHIP_QTY_UOM,              -- LD Matrl. UOM [OIJ_LDUOM]
    MTTMP,                     -- Mat.Temperature [OIB_MTTMP]
    MTTEH,                     -- Mat.Temp.Unit [OIB_MTTEH]
    O_API_GRAV,                -- Test Density [OIB_TDICH]
    API_GRT_D,                 -- Test Density [OIB_TDICH]
    TSTMP,                     -- Test Temp. [OIB_TSTMP]
    TSTEH,                     -- Test Temp.Unit [OIB_TSTEH]
    TDICH,                     -- Test Density [OIB_TDICH]
    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]
    BUDAT,                     -- Posting Date [BUDAT]
    CLOSE_NOMIT,               -- Close nomination itm [OIJ_EL_CLOSE_NOMIT]
    EVENTTYPE,                 -- Event date type [OIJ_EVENTTYPE]
    EVENT_DATE,                -- Event date [OIJ_EVENT_DATE]
    GMMNR,                     -- Gen. meter no. [OII_GMMNR]
    O_ITMSTM,                  -- Time Stamp [TIMESTAMP]
    O_METEV,                   -- Met. event type [OII_METEV]
    C_ITMSTM,                  -- Time Stamp [TIMESTAMP]
    C_METEV,                   -- Met. event type [OII_METEV]
    STOPRDG,                   -- End reading [OII_ENCOUN]
    STM_QUANTITY,              -- St.mt.Qty [OIJ_STM_QUANT]
    STM_UOM,                   -- Stm.Uom [OIJ_STM_UOM]
    SOCNR,                     -- SOCSEG number [OII_SOCNR]
    O_DIP_READ,                -- Open Dip [OIJ_O_DIP_READ]
    O_DIP_READ_UOM,            -- Length UoM [OII_LENUN]
    O_ETMSTM,                  -- Dip timestamp [OIB_TMSTM]
    O_SOCEV,                   -- Event key [OIB_DIP_EVENTKEY]
    C_DIP_READ,                -- CloseDip [OIJ_C_DIP_READ]
    C_DIP_READ_UOM,            -- Length UoM [OII_LENUN]
    C_ETMSTM,                  -- Dip timestamp [OIB_TMSTM]
    C_SOCEV,                   -- Event key [OIB_DIP_EVENTKEY]
    STOPDIP,                   -- Total height [OII_TOTALHEIGHT]
    STOPDIP_UOM,               -- Length UoM [OII_LENUN]
    STP_GAU_QUAN,              -- Stp.GaugeQty [OIJ_STG_QUAN]
    STP_GAU_UOM,               -- Stp.Gau.Uom [OIJ_STG_UOM]
    GAU_QUANTITY,              -- GaugeQty [OIJ_GAU_QUAN]
    GAU_UOM,                   -- GaugeUoM [OIJ_GAU_UOM]
    SHTYPE,                    -- Bulk shipm.type [OIG_TDSTYP]
    VSTEL,                     -- Shipping Point [VSTEL]
    CHARG_O,                   -- Batch orig [OIJ_CHARGO]
    WERKS_O,                   -- Plant [WERKS_D]
    LGORT_O,                   -- Location [LGORT_D]
    CHARG_D,                   -- Batch dest. [OIJ_CHARGD]
    WERKS_D,                   -- Plant [WERKS_D]
    LGORT_D,                   -- Location [LGORT_D]
    TIME_ST_LOAD_STA,          -- Creation Time [TMSTMP]
    TIME_ST_LOAD_END,          -- Creation Time [TMSTMP]
    TIME_ST_LED_OT,            -- Creation Time [TMSTMP]
    CHARG_D_CREATE,            -- Batch create [OIJ_CHARG_D_C]
    OIB_BLTIME,                -- Posting time [OIB_BLTIME]
    CHARG_L,                   -- Batch load [OIJ_CHARGL]
    CHARG_L_CREATE,            -- Ld. Btch create [OIJ_CHARG_L_C]
    SHTYP,                     -- Shipment Type [SHTYP]
    MENGE_PAR,                 -- SchedParQty [OIJ_MENGE_PAR]
    UNIT_I_PAR,                -- PUoM [OIJ_UNIT_PAR]
    RAILCARQTY,                -- No. of Railcars [OIJ_RU_RAILQTY]
    _DATAAGING,                -- Data Aging [DATA_TEMPERATURE]
    DUMMY_TKTITM_INCL_EEW_PS,  -- Extension Field [OIJ07_EXTN]
    TM_TTRQ_HANDLE_I,          -- UUID [OINSC_TM_TTRQ_HANDLE]
    PRIMARY KEY (MANDT, TICKET_KEY, TICKET_ITEM, TICKET_VERSION, TICKET_PURPOSE)
);

Depth:

OIJ_EL_TICKET_I

CDS Views using this table (7)

Fields (94)

Learn More