OIJ_EL_TICKET_H - Universal ticket table
Universal ticket table information is stored in SAP table OIJ_EL_TICKET_H.
It is part of development package OIJ_EL in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Trader's and Scheduler's Workbench - Execution Layer".
It is part of development package OIJ_EL in software component IS-OIL-DS-TSW. This development package consists of objects that can be grouped under "TSW Trader's and Scheduler's Workbench - Execution Layer".
Fields for table OIJ_EL_TICKET_H
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| TICKET_KEY | OIL-TSW: Ticket key | X | OIJ_EL_TKT_KEY | CHAR | 40 | |
| TICKET_VERSION | OIL-TSW: Ticket version | X | OIJ_EL_TKT_VERSION | NUMC | 6 | |
| TICKET_PURPOSE | OIL-TSW: Ticket Purpose | X | OIJ_EL_TKT_PURPOSE | CHAR | 2 | |
| TICKET_TYPE | OIL-TSW: Ticket type | OIJ_EL_TKT_TYPE | CHAR | 6 | TOIJ_TKT_TYPE | |
| TICKETNR | OIL-TSW: External ticket number | OIJ_TKTNR | CHAR | 40 | ||
| TKTSUBRC | OIL-TSW: Ticket process return code | OIJ_TKTRC | CHAR | 4 | ||
| TPLST | Transportation planning point | TPLST | CHAR | 8 | TTDS | |
| TSYST | Transport system | OIJ_TSYST | CHAR | 20 | OIJTS | |
| IDOC_NUM | IDoc number | EDI_DOCNUM | NUMC | 32 | ||
| .INCLUDE | ROIJSTAT | 0 | ||||
| ERDAT | Date on which the record was created | ERDAT | DATS | 16 | ||
| ERZEIT | Time of creation | OI0_ERTIM | TIMS | 12 | ||
| ERNAM | Name of Person Responsible for Creating the Object | ERNAM | CHAR | 24 | ||
| AEDAT | Last Changed On | AEDAT | DATS | 16 | ||
| AEZEIT | Time of day the record was changed | OI0_AETIM | TIMS | 12 | ||
| AENAM | Name of Person Who Changed Object | AENAM | CHAR | 24 | ||
| BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 2 | ||
| DELIND | Deletion indicator | OIJ_DELIND | CHAR | 2 | ||
| TKTSELECT | Flag to Set Tickets Selectable | OIJ_TKTSELECT | CHAR | 2 | ||
| CARRIER | Transport system Carrier | OIJ_CARRNR | CHAR | 20 | ||
| CONSIGNE | Consignee Partner | OIJ_CONSIGNEE | CHAR | 20 | ||
| INSPECTOR | Inspector | OIJ_INSPECTOR | CHAR | 20 | ||
| SHIPPER | Shipper | OIJ_SHIPNR | CHAR | 20 | ||
| SUPPLIER | Location Partner | OIJ_PARTNR | CHAR | 20 | ||
| TRADER | Location Partner | OIJ_PARTNR | CHAR | 20 | ||
| .INCLUDE | ROIJTIC_RU_H | 0 | ||||
| EXTTKTNR | External Ticket Number | OIJ_RU_EXTTKTNR | CHAR | 20 | ||
| TKTSTATUSRU | Ticket Approval Status | OIJ_RU_TKT_STATUS | CHAR | 2 | ||
| CHANGENR | Change Number | OIJ_RU_CHANGENR | NUMC | 8 | ||
| DELIVERYTYP | Delivery Type | OIJ_RU_DELTYP | CHAR | 4 | OIJ_RU_DEL_TYP | |
| DISPATCHTYP | Freight Shipment Type | OIJ_RU_DISPTYP | CHAR | 4 | OIJ_RU_DISP_TYP | |
| SENDSPEED | Delivery Speed | OIJ_RU_SENDSPD | CHAR | 4 | OIJ_RU_SEND_SPD | |
| PAYMENTLOC | Payment Location | OIJ_RU_PMTLOC | CHAR | 4 | OIJ_RU_PMT_LOC | |
| PAYMENTLOCTYP | Payment Location Type | OIJ_RU_PMTLOCTYP | CHAR | 2 | ||
| PAYMENTTYP | Payment Type | OIJ_RU_PMTTYP | CHAR | 4 | OIJ_RU_PMT_TYP | |
| CARGOTYP | Freight Loading Type | OIJ_RU_CARGTYP | CHAR | 4 | OIJ_RU_CARG_TYP | |
| SCALETYPE | Measurement Method | OIJ_RU_SCALE_TYPE | CHAR | 4 | OIJ_RU_SCALETYP | |
| FREIGHT_VALUE | Declared Value of Freight | OIJ_RU_FREIGHT_VALUE | CURR | 7 | ||
| FREIGHT_WAERS | Currency Key | WAERS | CUKY | 10 | TCURC | |
| RESPPARTY | Responsible Party for Loading | OIJ_RU_RESPPRT | CHAR | 4 | OIJ_RU_RESP_PRT | |
| SEND_TGNL | Sender TGNL Code | OIJ_RU_SEND_TGNL | CHAR | 8 | ||
| RECV_TGNL | Receiver TGNL Code | OIJ_RU_RECV_TGNL | CHAR | 8 | ||
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 16 | ||
| .INCLUDE | TKTHDR_INCL_EEW_PS | 0 | ||||
| DUMMY_TKTHDR_INCL_EEW_PS | Data Element for Extension Fields: Sample | OIJ07_EXTN | NUMC | 20 | ||
| .INCLUDE | TKTHDR_INCL_NMT | 0 | ||||
| NMT_AIF_GUID | GUID for Integration Engine Objects | SXMSGUID | RAW | 16 |