SAP table ROIJ_EL_TICKET_DISP (OIL-TSW : Ticket display structure)

Field Description Data Type Length Decimals Checktable Data Element
OIJ_TICKET_ICON Icon for Ticket status CHAR 30 0 OIJ_TICKET_ICON_D
MANDT Client CLNT 3 0 T000 MANDT
TICKET_KEY OIL-TSW: Ticket key CHAR 20 0 OIJ_EL_TKT_KEY
TICKET_VERSION OIL-TSW: Ticket version NUMC 3 0 OIJ_EL_TKT_VERSION
TICKET_PURPOSE OIL-TSW: Ticket Purpose CHAR 1 0 OIJ_EL_TKT_PURPOSE
1 Field ticket
2 Correction
3 Final confirmation
4 Internally generated for posting
5 Reversal
TICKET_TYPE OIL-TSW: Ticket type CHAR 3 0 TOIJ_TKT_TYPE OIJ_EL_TKT_TYPE
TICKETNR OIL-TSW: External ticket number CHAR 20 0 * OIJ_TKTNR
TKTSUBRC OIL-TSW: Ticket process return code CHAR 2 0 OIJ_TKTRC
00 Ticket Actualization Process Completed
01 Nomination not found
02 Nomination item not found
03 Wrong Carrier
04 Carrier not found
05 Wrong Shipper
06 Shipper not found
07 Wrong Tankage
08 Tankage not found
09 Wrong Consignee
10 Consignee not found
11 Nomination Item Status Rejected
12 Nomination Item Status Complete
13 Nomination Item: Confirmation missing
14 Posting of ticket quantity would exceed scheduled quantitiy
15 Wrong Transport System
16 Transport system not found
17 Wrong Location
18 Location not found
19 Wrong Purchase order
1A Ticket corrupted
20 Purchase Order: Item number missing
21 Purchase order: Item quantity exceeds tolerance
22 Wrong Sales order
23 Sales order: Item number missing
24 Sales order: Item quantity exceeds tolerance
25 Error while Posting Shipping Notification
26 Error while Creating Shipment
27 Load confirmation posted
28 Reservation posted
29 Ticket: Nomination Number missing
30 Nomination Number not unique
31 Nomination Item not unique
32 Nomination Item: Copy not unique
33 Nomination Item: SITYP missing
34 Nomination Item: Wrong SITYP
35 Material Number missing
36 Wrong Material Number
37 Ticket: Quantity missing
38 Movement Scenario not found
39 Unit of Measure missing
40 Ticket: End Date missing
41 TD vehicle number missing in nomination
42 TD shipment Type missing in nomination
43 TD Transportation planning point missing in nomination
44 Plant and Storage Location for movement destination missing
45 Unit Conversion: required Fields not filled
46 Unit Conversion: Default values for material not found
47 Unit Conversion: Calculation Error
48 Other uncomplete similar Ticket found: complete this first
49 Plant and Storage Location for movement origin missing
50 Ticket saved - no validation performed
51 Error occurred in carrier ticket customer function.
52 Error while Posting Load Confirmation
53 Error while Posting Reservation
54 Error while Posting Delivery
55 Error while Posting Delivery Confirmation
56 Error while Update Nomination (Act. Qty.)
57 Error while Changing Shipment
58 Shipping notification posted
59 Shipment posted
60 Delivery posted
61 Delivery Confirmation posted
62 Nomination updated
63 Shipment Change posted
64 Sales Order : Shipping Point missing
65 Failure while Locking Nomination
69 Posting Date is not valid
70 Cannot actualize a ticket for a future date or time.
71 Purchase Order : Del. Date < Ticket End Date
72 Sales Order : Del. Date > Ticket End Date
73 Error while Posting Goods Receipt
74 Error while Posting Billing Document
75 Error while Create Ticket : Duplicate Record found
76 Error while actualizing. For details look up error log.
77 Nomination/Item currently locked by other user
78 Partially posted
80 Error while validating. For details look up error log.
87 Error while updating database table
95 Validation failed
96 Ticket abandonned by user
98 Ticket Validated and Saved
99 Initial
TPLST Transportation planning point CHAR 4 0 TTDS TPLST
TSYST Transport system CHAR 10 0 OIJTS OIJ_TSYST
IDOC_NUM IDoc number NUMC 16 0 EDI_DOCNUM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZEIT Time of creation TIMS 6 0 OI0_ERTIM
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZEIT Time of day the record was changed TIMS 6 0 OI0_AETIM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BLOIND Blocking indicator CHAR 1 0 OIJ_BLOIND
DELIND Deletion indicator CHAR 1 0 OIJ_DELIND
TKTSELECT Flag to Set Tickets Selectable CHAR 1 0 OIJ_TKTSELECT
CARRIER Transport system Carrier CHAR 10 0 * OIJ_CARRNR
CONSIGNE Consignee Partner CHAR 10 0 OIJ_CONSIGNEE
INSPECTOR Inspector CHAR 10 0 OIJ_INSPECTOR
SHIPPER Shipper CHAR 10 0 * OIJ_SHIPNR
SUPPLIER Location Partner CHAR 10 0 OIJ_PARTNR
TRADER Location Partner CHAR 10 0 OIJ_PARTNR
EXTTKTNR External Ticket Number CHAR 10 0 OIJ_RU_EXTTKTNR
TKTSTATUSRU Ticket Approval Status CHAR 1 0 OIJ_RU_TKT_STATUS
In preparation
A Approved
R Rejected
S Sent to carrier
CHANGENR Change Number NUMC 4 0 OIJ_RU_CHANGENR
DELIVERYTYP Delivery Type CHAR 2 0 OIJ_RU_DEL_TYP OIJ_RU_DELTYP
DISPATCHTYP Freight Shipment Type CHAR 2 0 OIJ_RU_DISP_TYP OIJ_RU_DISPTYP
SENDSPEED Delivery Speed CHAR 2 0 OIJ_RU_SEND_SPD OIJ_RU_SENDSPD
PAYMENTLOC Payment Location CHAR 2 0 OIJ_RU_PMT_LOC OIJ_RU_PMTLOC
PAYMENTLOCTYP Payment Location Type CHAR 1 0 OIJ_RU_PMTLOCTYP
D Point of destination
O Point of origin
PAYMENTTYP Payment Type CHAR 2 0 OIJ_RU_PMT_TYP OIJ_RU_PMTTYP
CARGOTYP Freight Loading Type CHAR 2 0 OIJ_RU_CARG_TYP OIJ_RU_CARGTYP
SCALETYPE Measurement Method CHAR 2 0 OIJ_RU_SCALETYP OIJ_RU_SCALE_TYPE
FREIGHT_VALUE Declared Value of Freight CURR 13 2 OIJ_RU_FREIGHT_VALUE
FREIGHT_WAERS Currency Key CUKY 5 0 TCURC WAERS
RESPPARTY Responsible Party for Loading CHAR 2 0 OIJ_RU_RESP_PRT OIJ_RU_RESPPRT
SEND_TGNL Sender TGNL Code CHAR 4 0 OIJ_RU_SEND_TGNL
RECV_TGNL Receiver TGNL Code CHAR 4 0 OIJ_RU_RECV_TGNL
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
DUMMY_TKTHDR_INCL_EEW_PS Data Element for Extension Fields: Sample NUMC 10 0 OIJ07_EXTN
NMT_AIF_GUID GUID for Integration Engine Objects RAW 16 0 SXMSGUID
TICKET_ITEM OIL-TSW: Ticket item number NUMC 6 0 OIJ_EL_TKT_POSNR
EXT_POSNR External position number CHAR 6 0 OIJ_EL_EXT_POS
STATUS Nomination Item status CHAR 1 0 OIJ_ISTAT
1 Planned
2 Scheduled
3 Accepted
4 Confirmed
5 Partially complete
6 Complete
7 Rejected
8 Dummy
9 Received
A Sent
B Checked
C Processed
SUBSTATUS Nomination Item sub-status CHAR 1 0 OIJ_SSTAT
1 Original
2 2nd run
3 3rd run
4 Positive
5 Negative
6 Complete
7 Part1
8 Part2
9 Part3
A Partially complete
B Complete
C Planned
D Scheduled
E Confirmed
F Rejected
SITYP Schedule type CHAR 2 0 OIJ_SITYP
MVSCENARIO TSW: Movement scenario number NUMC 2 0 OIJ_MVSCEN
NOMNR Nomination number CHAR 20 0 OIJ_NOMNR
NOMTK Nomination (technical) Key CHAR 20 0 OIJNOMH OIJ_NOMTK
NOMIT Nomination Key Item NUMC 10 0 OIJNOMI OIJ_ITEM
RECEIVER Location Partner CHAR 10 0 OIJ_PARTNR
LOCID Location ID CHAR 10 0 OIJLOC OIJ_LOCID
VEHICLE TD Vehicle Number CHAR 10 0 OIGV OIG_VHLNMR
MENGE Scheduled qty QUAN 13 3 OIJ_MENGE
GROSQUAN Scheduled qty QUAN 13 3 OIJ_MENGE
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MATNR Material Number CHAR 40 0 MARA MATNR
TANKAGE Tankage Partner CHAR 10 0 OIJ_TANKAGE
MTTMP Oil/Gas Material Temperature: Observed Quantity FLTP 16 16 OIB_MTTMP
MTTEH Oil/Gas Material Temperature Unit: Observed Quantity UNIT 3 0 T006 OIB_MTTEH
O_API_GRAV Oil/Gas Test Density FLTP 16 16 OIB_TDICH
API_GRT_D Oil/Gas Test Density FLTP 16 16 OIB_TDICH
TSTMP Oil/Gas Test Temperature: Observed Density FLTP 16 16 OIB_TSTMP
TSTEH Test Temperature Unit (Density): Measurement UNIT 3 0 T006 OIB_TSTEH
TDICH Oil/Gas Test Density FLTP 16 16 OIB_TDICH
BUDAT Posting Date in the Document DATS 8 0 BUDAT
CLOSE_NOMIT IS OIL TSW: Indicator close nomination CHAR 1 0 OIJ_EL_CLOSE_NOMIT
space
X Close nomination item
EVENTTYPE TSW event date type CHAR 16 0 OIJ_EVENTTYPE
EVENT_DATE OIL-TSW: Event date DATS 8 0 OIJ_EVENT_DATE
SHTYPE TD shipment type CHAR 4 0 OIG_TDSTYP
VSTEL Shipping Point / Receiving Point CHAR 4 0 VSTEL
CHARG_O Batch origin Location CHAR 10 0 OIJ_CHARGO
WERKS_O Plant CHAR 4 0 WERKS_D
LGORT_O Storage location CHAR 4 0 LGORT_D
CHARG_D Batch destination Location CHAR 10 0 OIJ_CHARGD
WERKS_D Plant CHAR 4 0 WERKS_D
LGORT_D Storage location CHAR 4 0 LGORT_D
TIME_ST_LOAD_STA Time at Which Data Was Created (Date and Time) CHAR 14 0 TMSTMP
TIME_ST_LOAD_END Time at Which Data Was Created (Date and Time) CHAR 14 0 TMSTMP
TIME_ST_LED_OT Time at Which Data Was Created (Date and Time) CHAR 14 0 TMSTMP

ROIJ_EL_TICKET_DISP foreign key relationships

Table Field Check Table Check Field
0 ROIJ_EL_TICKET_DISP CARGOTYP OIJ_RU_CARG_TYP Define Freight Loading Types MANDT
0 ROIJ_EL_TICKET_DISP CARGOTYP OIJ_RU_CARG_TYP Define Freight Loading Types CARGOTYP
1 ROIJ_EL_TICKET_DISP DELIVERYTYP OIJ_RU_DEL_TYP Define Delivery Types MANDT
1 ROIJ_EL_TICKET_DISP DELIVERYTYP OIJ_RU_DEL_TYP Define Delivery Types DELIVERYTYP
0 ROIJ_EL_TICKET_DISP DISPATCHTYP OIJ_RU_DISP_TYP Define Freight Shipment Types MANDT
0 ROIJ_EL_TICKET_DISP DISPATCHTYP OIJ_RU_DISP_TYP Define Freight Shipment Types DISPATCHTYP
1 ROIJ_EL_TICKET_DISP FREIGHT_WAERS TCURC Currency Codes MANDT
1 ROIJ_EL_TICKET_DISP FREIGHT_WAERS TCURC Currency Codes WAERS
0 ROIJ_EL_TICKET_DISP LOCID OIJLOC Location table MANDT
0 ROIJ_EL_TICKET_DISP LOCID OIJLOC Location table LOCID
1 ROIJ_EL_TICKET_DISP MATNR MARA General Material Data MANDT
1 ROIJ_EL_TICKET_DISP MATNR MARA General Material Data MATNR
0 ROIJ_EL_TICKET_DISP MEINS T006 Units of Measurement MANDT
0 ROIJ_EL_TICKET_DISP MEINS T006 Units of Measurement MSEHI
1 ROIJ_EL_TICKET_DISP MTTEH T006 Units of Measurement MANDT
0 ROIJ_EL_TICKET_DISP NOMIT OIJNOMI Nomination Item MANDT
0 ROIJ_EL_TICKET_DISP NOMIT OIJNOMI Nomination Item NOMTK
0 ROIJ_EL_TICKET_DISP NOMIT OIJNOMI Nomination Item NOMIT
1 ROIJ_EL_TICKET_DISP NOMTK OIJNOMH Nomination Header MANDT
1 ROIJ_EL_TICKET_DISP NOMTK OIJNOMH Nomination Header NOMTK
0 ROIJ_EL_TICKET_DISP PAYMENTLOC OIJ_RU_PMT_LOC Define Payment Locations MANDT
0 ROIJ_EL_TICKET_DISP PAYMENTLOC OIJ_RU_PMT_LOC Define Payment Locations PAYMENTLOC
1 ROIJ_EL_TICKET_DISP PAYMENTTYP OIJ_RU_PMT_TYP Define Payment Types MANDT
1 ROIJ_EL_TICKET_DISP PAYMENTTYP OIJ_RU_PMT_TYP Define Payment Types PAYMENTTYP
0 ROIJ_EL_TICKET_DISP RESPPARTY OIJ_RU_RESP_PRT Define Loading Responsibilities MANDT
0 ROIJ_EL_TICKET_DISP RESPPARTY OIJ_RU_RESP_PRT Define Loading Responsibilities RESPPARTY
1 ROIJ_EL_TICKET_DISP SCALETYPE OIJ_RU_SCALETYP Define Measurement Method MANDT
1 ROIJ_EL_TICKET_DISP SCALETYPE OIJ_RU_SCALETYP Define Measurement Method SCALE_TYPE
0 ROIJ_EL_TICKET_DISP SENDSPEED OIJ_RU_SEND_SPD Define Delivery Speed Values MANDT
0 ROIJ_EL_TICKET_DISP SENDSPEED OIJ_RU_SEND_SPD Define Delivery Speed Values SENDSPEED
1 ROIJ_EL_TICKET_DISP TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
0 ROIJ_EL_TICKET_DISP TSTEH T006 Units of Measurement MANDT
1 ROIJ_EL_TICKET_DISP TSYST OIJTS Transport system (IS-Oil TSW standard/core object ) MANDT
1 ROIJ_EL_TICKET_DISP TSYST OIJTS Transport system (IS-Oil TSW standard/core object ) TSYST
0 ROIJ_EL_TICKET_DISP VEHICLE OIGV TD Vehicle Header CLIENT
0 ROIJ_EL_TICKET_DISP VEHICLE OIGV TD Vehicle Header VEHICLE