OIJ_EL_TICKET_H

Universal ticket table | #transactional | Component: Trader's and Scheduler's Workbench

🔑 Keys (4)
💰 Amounts (1)
∑ Quantities
📅 Dates (5)
☰ Categorical (7)
Other (16)
🔗 Relations (13)

Column Name	Description
MANDT FK	Client
TICKET_KEY	OIL-TSW: Ticket key
TICKET_VERSION	OIL-TSW: Ticket version
TICKET_PURPOSE	OIL-TSW: Ticket Purpose	Show values

Column Name	Description
💲 Currency Key (FREIGHT_WAERS):
FREIGHT_VALUE	Declared Value of Freight

Column Name	Description

Column Name	Description
ERDAT	Date on which the record was created
ERZEIT	Time of creation
AEDAT	Last Changed On
AEZEIT	Time of day the record was changed
_DATAAGING	Data Filter Value for Data Aging

Column Name	Description
TICKET_PURPOSE	OIL-TSW: Ticket Purpose	Show values
TKTSUBRC	OIL-TSW: Ticket process return code	Show values
BLOIND	Blocking indicator	Show values
DELIND	Deletion indicator	Show values
TKTSELECT	Flag to Set Tickets Selectable	Show values
TKTSTATUSRU	Ticket Approval Status	Show values
PAYMENTLOCTYP	Payment Location Type	Show values

Column Name	Description	Domain name
TICKETNR	OIL-TSW: External ticket number	OIJ_TKTNR
IDOC_NUM	IDoc number	EDI_DOCNUM
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
CARRIER	Transport system Carrier	LIFNR
CONSIGNE	Consignee Partner	OIJ_PARTNR
INSPECTOR	Inspector	OIJ_PARTNR
SHIPPER	Shipper	LIFNR
SUPPLIER	Location Partner	OIJ_PARTNR
TRADER	Location Partner	OIJ_PARTNR
EXTTKTNR	External Ticket Number	CHAR10
CHANGENR	Change Number	NUM04
SEND_TGNL	Sender TGNL Code	OIJ_RU_PAR_TGNL
RECV_TGNL	Receiver TGNL Code	OIJ_RU_PAR_TGNL
DUMMY_TKTHDR_INCL_EEW_PS	Data Element for Extension Fields: Sample	NUMC10
NMT_AIF_GUID	GUID for Integration Engine Objects	SYSUUID

Master Data Relations	Join Conditions
Freight Loading Type	`OIJ_EL_TICKET_H.MANDT == OIJ_RU_CARG_TYP.MANDT` `OIJ_EL_TICKET_H.CARGOTYP == OIJ_RU_CARG_TYP.CARGOTYP`
Delivery Type Delivery Type Client	`OIJ_EL_TICKET_H.DELIVERYTYP == OIJ_RU_DEL_TYP.DELIVERYTYP` `OIJ_EL_TICKET_H.MANDT == OIJ_RU_DEL_TYP.MANDT`
Freight Shipment Type	`OIJ_EL_TICKET_H.MANDT == OIJ_RU_DISP_TYP.MANDT` `OIJ_EL_TICKET_H.DISPATCHTYP == OIJ_RU_DISP_TYP.DISPATCHTYP`
Currency Key	`OIJ_EL_TICKET_H.MANDT == TCURC.MANDT` `OIJ_EL_TICKET_H.FREIGHT_WAERS == TCURC.WAERS`
Client	`OIJ_EL_TICKET_H.MANDT == T000.MANDT`
Payment Location	`OIJ_EL_TICKET_H.MANDT == OIJ_RU_PMT_LOC.MANDT` `OIJ_EL_TICKET_H.PAYMENTLOC == OIJ_RU_PMT_LOC.PAYMENTLOC`
Payment Type	`OIJ_EL_TICKET_H.MANDT == OIJ_RU_PMT_TYP.MANDT` `OIJ_EL_TICKET_H.PAYMENTTYP == OIJ_RU_PMT_TYP.PAYMENTTYP`
Responsible Party for Loading	`OIJ_EL_TICKET_H.MANDT == OIJ_RU_RESP_PRT.MANDT` `OIJ_EL_TICKET_H.RESPPARTY == OIJ_RU_RESP_PRT.RESPPARTY`
Measurement Method	`OIJ_EL_TICKET_H.MANDT == OIJ_RU_SCALETYP.MANDT` `OIJ_EL_TICKET_H.SCALETYPE == OIJ_RU_SCALETYP.SCALE_TYPE`
Delivery Speed	`OIJ_EL_TICKET_H.MANDT == OIJ_RU_SEND_SPD.MANDT` `OIJ_EL_TICKET_H.SENDSPEED == OIJ_RU_SEND_SPD.SENDSPEED`
OIL-TSW: Ticket type	`OIJ_EL_TICKET_H.MANDT == TOIJ_TKT_TYPE.CLIENT` `OIJ_EL_TICKET_H.TICKET_TYPE == TOIJ_TKT_TYPE.TKT_TYPE`
Transportation planning point Transportation planning point Client	`OIJ_EL_TICKET_H.TPLST == TTDS.TPLST` `OIJ_EL_TICKET_H.MANDT == TTDS.MANDT`
Transport system	`OIJ_EL_TICKET_H.MANDT == OIJTS.MANDT` `OIJ_EL_TICKET_H.TSYST == OIJTS.TSYST`