OIJ_EL_TICKET_H SAP (Universal ticket table) Table details

Dictionary Type: Table
Description: Universal ticket table




ABAP Code to SELECT data from OIJ_EL_TICKET_H
Related tables to OIJ_EL_TICKET_H
Access table OIJ_EL_TICKET_H




Table field list including key, data, relationships and ABAP select examples

OIJ_EL_TICKET_H is a standard SAP Table which is used to store Universal ticket table data and is available within R/3 SAP systems depending on the version and release level.

The OIJ_EL_TICKET_H table consists of various fields, each holding specific information or linking keys about Universal ticket table data available in SAP. These include TICKET_KEY (OIL-TSW: Ticket key), TICKET_VERSION (OIL-TSW: Ticket version), TICKET_PURPOSE (OIL-TSW: Ticket Purpose), TICKET_TYPE (OIL-TSW: Ticket type).. 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_TICKET_H 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
MANDTClient MANDTCLNT3T000MANDT
TICKET_KEYOIL-TSW: Ticket key OIJ_EL_TKT_KEYCHAR20ALPHAOIJ_EL_TKT_KEY
TICKET_VERSIONOIL-TSW: Ticket version OIJ_EL_TKT_VERSIONNUMC3OIJ_EL_TKT_VERSIONOIJ_TKT_VERS
TICKET_PURPOSEOIL-TSW: Ticket Purpose OIJ_EL_TKT_PURPOSECHAR1OIJ_EL_TKT_PURPOSEOIJ_TKT_PURP
TICKET_TYPEOIL-TSW: Ticket type OIJ_EL_TKT_TYPECHAR3TOIJ_TKT_TYPEOIJ_EL_TKT_TYPEOIJ_TKT_TYPE
TICKETNROIL-TSW: External ticket number OIJ_TKTNRCHAR20Assigned to domainALPHAOIJ_TKTNROIU
TKTSUBRCOIL-TSW: Ticket process return code OIJ_TKTRCCHAR2OIJ_TKTRC
TPLSTTransportation planning point TPLSTCHAR4TTDSTPLSTTDP
TSYSTTransport system OIJ_TSYSTCHAR10OIJTSOIJ_TSYSTOIW
IDOC_NUMIDoc number EDI_DOCNUMNUMC16EDI_DOCNUMDCN
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZEITTime of creation OI0_ERTIMTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AEZEITTime of day the record was changed OI0_AETIMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BLOINDBlocking indicator OIJ_BLOINDCHAR1XFELD
DELINDDeletion indicator OIJ_DELINDCHAR1XFELD
CARRIERTransport system Carrier OIJ_CARRNRCHAR10Assigned to domainALPHALIFNR
CONSIGNEConsignee Partner OIJ_CONSIGNEECHAR10ALPHAOIJ_PARTNR
INSPECTORInspector OIJ_INSPECTORCHAR10ALPHAOIJ_PARTNR
SHIPPERShipper OIJ_SHIPNRCHAR10Assigned to domainALPHALIFNR
SUPPLIERLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
TRADERLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
EXTTKTNRExternal Ticket Number OIJ_RU_EXTTKTNRCHAR10CHAR10
TKTSTATUSRUTicket Approval Status OIJ_RU_TKT_STATUSCHAR1OIJ_RU_TKT_STATUS
CHANGENRChange Number OIJ_RU_CHANGENRNUMC4NUM04
DELIVERYTYPDelivery Type OIJ_RU_DELTYPCHAR2OIJ_RU_DEL_TYPCHAR2
DISPATCHTYPFreight Shipment Type OIJ_RU_DISPTYPCHAR2OIJ_RU_DISP_TYPCHAR2OIJ_RU_DT
SENDSPEEDDelivery Speed OIJ_RU_SENDSPDCHAR2OIJ_RU_SEND_SPDCHAR2
PAYMENTLOCPayment Location OIJ_RU_PMTLOCCHAR2OIJ_RU_PMT_LOCCHAR2
PAYMENTLOCTYPPayment Location Type OIJ_RU_PMTLOCTYPCHAR1OIJ_RU_PMTLOCTYP
PAYMENTTYPPayment Type OIJ_RU_PMTTYPCHAR2OIJ_RU_PMT_TYPCHAR2
CARGOTYPFreight Loading Type OIJ_RU_CARGTYPCHAR2OIJ_RU_CARG_TYPCHAR2
SCALETYPEMeasurement Method OIJ_RU_SCALE_TYPECHAR2OIJ_RU_SCALETYPCHAR2
FREIGHT_VALUEDeclared Value of Freight OIJ_RU_FREIGHT_VALUECURR13(2) WERT7
FREIGHT_WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
RESPPARTYResponsible Party for Loading OIJ_RU_RESPPRTCHAR2OIJ_RU_RESP_PRTCHAR2
SEND_TGNLSender TGNL Code OIJ_RU_SEND_TGNLCHAR4OIJ_RU_PAR_TGNL
RECV_TGNLReceiver TGNL Code OIJ_RU_RECV_TGNLCHAR4OIJ_RU_PAR_TGNL

Key field Non-key field



How do I retrieve data from SAP table OIJ_EL_TICKET_H using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIJ_EL_TICKET_H to SELECT all data from the table
DATA: WA_OIJ_EL_TICKET_H TYPE OIJ_EL_TICKET_H.

SELECT SINGLE *
FROM OIJ_EL_TICKET_H
INTO CORRESPONDING FIELDS OF WA_OIJ_EL_TICKET_H
WHERE...

How to access SAP table OIJ_EL_TICKET_H

Within an ECC or HANA version of SAP you can also view further information about OIJ_EL_TICKET_H and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!