1. Home
  2. Resources
  3. SAP Tables
  4. OIJHCT01 - OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE

SAP Table OIJHCT01

OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE

OIJHCT01 (OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIJHCT01 to other SAP tables.

OIJHCT01 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TICKETNR OIL-TSW: External ticket number OIJ_TKTNR CHAR 20 0
LOCID Location ID OIJ_LOCID OIJLOC CHAR 10 0
TKT_YEAR Fiscal Year GJAHR NUMC 4 0
TKT_MONTH Calendar month OIJ_MONTH NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
STATUS Nomination Item status OIJ_ISTAT OIJSTAT CHAR 1 0
SUBSTATUS Nomination Item sub-status OIJ_SSTAT OIJSUBSTAT CHAR 1 0
TKTSUBRC OIL-TSW: Ticket process return code OIJ_TKTRC CHAR 2 0
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
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
1A Ticket corrupted
NOMNR Nomination number OIJ_NOMNR CHAR 20 0
NOMTK Nomination (technical) Key OIJ_NOMTK OIJNOMH CHAR 20 0
NOMIT Nomination Key Item OIJ_ITEM OIJNOMI NUMC 10 0
TICKETTYPE Character Field Length = 10 CHAR10 CHAR 10 0
SITYP Schedule type OIJ_SITYP TOIJ_EL_SITYPES CHAR 2 0
MVSCENARIO TSW: Movement scenario number OIJ_MVSCEN NUMC 2 0
VERSION OIL-TSW: External ticket number OIJ_TKTNR CHAR 20 0
CARRIER Transport system Carrier OIJ_CARRNR LFA1 CHAR 10 0
SHIPPER Shipper OIJ_SHIPNR LFA1 CHAR 10 0
SUPPLIER Location Partner OIJ_PARTNR CHAR 10 0
CONSIGNE Location Partner OIJ_PARTNR CHAR 10 0
RECEIVER Location Partner OIJ_PARTNR CHAR 10 0
VEHICLE TD Vehicle Number OIG_VHLNMR CHAR 10 0
SHTYPE TD shipment type OIG_TDSTYP TOIGS CHAR 4 0
TPLST Transportation planning point TPLST TTDS CHAR 4 0
TSYST Transport system OIJ_TSYST OIJTS CHAR 10 0
CARRNAME OIL-TSW: Common partner name OIJ_PARNM CHAR 35 0
SHIPPNAME OIL-TSW: Common partner name OIJ_PARNM CHAR 35 0
SUPPNAME OIL-TSW: Common partner name OIJ_PARNM CHAR 35 0
CONSINAME OIL-TSW: Common partner name OIJ_PARNM CHAR 35 0
RECNAME OIL-TSW: Common partner name OIJ_PARNM CHAR 35 0
TSNAM OIL-TSW: Transport system name OIJ_TSNAM CHAR 60 0
LOCNAM Location name (used by system owner) OIJ_LOCNAM CHAR 60 0
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
MENGE Scheduled qty OIJ_MENGE QUAN 13 3
GROSQUAN Scheduled qty OIJ_MENGE QUAN 13 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
CHARG_O Batch origin Location OIJ_CHARGO CHAR 10 0
WERKS_O Plant WERKS_D T001W CHAR 4 0
LGORT_O Storage Location LGORT_D T001L CHAR 4 0
CHARG_D Batch destination Location OIJ_CHARGD MCH1 CHAR 10 0
WERKS_D Plant WERKS_D T001W CHAR 4 0
LGORT_D Storage Location LGORT_D T001L CHAR 4 0
START_DATE Date DATUM DATS 8 0
START_TIME Time UZEIT TIMS 6 0
END_DATE Date DATUM DATS 8 0
END_TIME Time UZEIT TIMS 6 0
O_API_GRAV Oil/Gas Test Density OIB_TDICH FLTP 16 16
API_GRT_D Oil/Gas Test Density OIB_TDICH FLTP 16 16
TSTMP Oil/Gas Test Temperature: Observed Density OIB_TSTMP FLTP 16 16
TSTEH Test Temperature Unit (Density): Measurement OIB_TSTEH T006 UNIT 3 0
TDICH Oil/Gas Test Density OIB_TDICH FLTP 16 16
DIS_MET_F Field of length 16 CHAR16 CHAR 16 0
COM_COR_F Field of length 16 CHAR16 CHAR 16 0
VOL_WATER Field of length 16 CHAR16 CHAR 16 0
AVG_PR_PSI Field of length 16 CHAR16 CHAR 16 0
PRS_COR_F Field of length 16 CHAR16 CHAR 16 0
MTTMP Oil/Gas Material Temperature: Observed Quantity OIB_MTTMP FLTP 16 16
AVG_TEMP Oil/Gas Material Temperature: Observed Quantity OIB_MTTMP FLTP 16 16
MTTEH Oil/Gas Material Temperature Unit: Observed Quantity OIB_MTTEH T006 UNIT 3 0
TMP_COR_F Field of length 16 CHAR16 CHAR 16 0
SHIPTONAME Data Element Type CHAR Length 35 CHAR35 CHAR 35 0
TANKAGE Location Partner OIJ_PARTNR CHAR 10 0
TANKNAME OIL-TSW: Common partner name OIJ_PARNM CHAR 35 0
TARIFF_NBR Character Field Length = 10 CHAR10 CHAR 10 0
METER_NBR TD meter number OIG_MTR_NR CHAR 10 0
METER_FAC Field of length 16 CHAR16 CHAR 16 0
BEGIN_READ Time in CHAR Format TIME CHAR 6 0
END_READ Time in CHAR Format TIME CHAR 6 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZEIT Time of creation OI0_ERTIM TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AEZEIT Time of day the record was changed OI0_AETIM TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BLOIND Blocking indicator OIJ_BLOIND CHAR 1 0
X Yes
NULL No
DELIND Deletion indicator OIJ_DELIND CHAR 1 0
X Yes
NULL No
BUDAT Posting Date in the Document BUDAT DATS 8 0
INTERN_GEN Internally Generated Ticket Indicator OIJ_INTGEN CHAR 1 0
X Yes
NULL No

OIJHCT01 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIJHCT01 CARRIER OIJHCT01 MANDT LFA1 Vendor Master (General Section) MANDT
OIJHCT01 CARRIER OIJHCT01 CARRIER LFA1 Vendor Master (General Section) LIFNR
OIJHCT01 CHARG_D OIJHCT01 MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
OIJHCT01 CHARG_D OIJHCT01 CHARG_D MCH1 Batches (if Batch Management Cross-Plant) CHARG
OIJHCT01 CHARG_D OIJHCT01 MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
OIJHCT01 LGORT_D OIJHCT01 LGORT_D T001L Storage Locations LGORT
OIJHCT01 LGORT_D OIJHCT01 MANDT T001L Storage Locations MANDT
OIJHCT01 LGORT_D OIJHCT01 WERKS_D T001L Storage Locations WERKS
OIJHCT01 LGORT_O OIJHCT01 MANDT T001L Storage Locations MANDT
OIJHCT01 LGORT_O OIJHCT01 WERKS_O T001L Storage Locations WERKS
OIJHCT01 LGORT_O OIJHCT01 LGORT_O T001L Storage Locations LGORT
OIJHCT01 LOCID OIJHCT01 MANDT OIJLOC Location table MANDT
OIJHCT01 LOCID OIJHCT01 LOCID OIJLOC Location table LOCID
OIJHCT01 MANDT OIJHCT01 MANDT T000 Clients MANDT
OIJHCT01 MATNR OIJHCT01 MANDT MARA General Material Data MANDT
OIJHCT01 MATNR OIJHCT01 MATNR MARA General Material Data MATNR
OIJHCT01 MEINS OIJHCT01 MANDT T006 Units of Measurement MANDT
OIJHCT01 MEINS OIJHCT01 MEINS T006 Units of Measurement MSEHI
OIJHCT01 MTTEH OIJHCT01 MTTEH T006 Units of Measurement MSEHI
OIJHCT01 MTTEH OIJHCT01 MANDT T006 Units of Measurement MANDT
OIJHCT01 NOMIT OIJHCT01 MANDT OIJNOMI Nomination Item MANDT
OIJHCT01 NOMIT OIJHCT01 NOMTK OIJNOMI Nomination Item NOMTK
OIJHCT01 NOMIT OIJHCT01 NOMIT OIJNOMI Nomination Item NOMIT
OIJHCT01 NOMTK OIJHCT01 NOMTK OIJNOMH Nomination Header NOMTK
OIJHCT01 NOMTK OIJHCT01 MANDT OIJNOMH Nomination Header MANDT
OIJHCT01 SHIPPER OIJHCT01 MANDT LFA1 Vendor Master (General Section) MANDT
OIJHCT01 SHIPPER OIJHCT01 SHIPPER LFA1 Vendor Master (General Section) LIFNR
OIJHCT01 SHTYPE OIJHCT01 MANDT TOIGS TD Shipment Types CLIENT
OIJHCT01 SHTYPE OIJHCT01 SHTYPE TOIGS TD Shipment Types SHTYP
OIJHCT01 SITYP OIJHCT01 MANDT TOIJ_EL_SITYPES TSW: Define valid sitypes CLIENT
OIJHCT01 SITYP OIJHCT01 SITYP TOIJ_EL_SITYPES TSW: Define valid sitypes SITYP
OIJHCT01 STATUS OIJHCT01 STATUS OIJSTAT OIL-TSW : Status Table STATUS
OIJHCT01 STATUS OIJHCT01 MANDT OIJSTAT OIL-TSW : Status Table MANDT
OIJHCT01 STATUS 'OIJHCT01' OIJSTAT OIL-TSW : Status Table TABNAME
OIJHCT01 SUBSTATUS OIJHCT01 MANDT OIJSUBSTAT OIL-TSW : Substatus Table MANDT
OIJHCT01 SUBSTATUS 'OIJHCT01' OIJSUBSTAT OIL-TSW : Substatus Table TABNAME
OIJHCT01 SUBSTATUS OIJHCT01 STATUS OIJSUBSTAT OIL-TSW : Substatus Table STATUS
OIJHCT01 SUBSTATUS OIJHCT01 SUBSTATUS OIJSUBSTAT OIL-TSW : Substatus Table SUBSTATUS
OIJHCT01 TPLST OIJHCT01 MANDT TTDS Organizational Unit: Transportation Scheduling Point MANDT
OIJHCT01 TPLST OIJHCT01 TPLST TTDS Organizational Unit: Transportation Scheduling Point TPLST
OIJHCT01 TSTEH OIJHCT01 MANDT T006 Units of Measurement MANDT
OIJHCT01 TSTEH OIJHCT01 TSTEH T006 Units of Measurement MSEHI
OIJHCT01 TSYST OIJHCT01 MANDT OIJTS Transport system (IS-Oil TSW standard/core object ) MANDT
OIJHCT01 TSYST OIJHCT01 TSYST OIJTS Transport system (IS-Oil TSW standard/core object ) TSYST
OIJHCT01 VSTEL OIJHCT01 MANDT TVST Organizational Unit: Shipping Points MANDT
OIJHCT01 VSTEL OIJHCT01 VSTEL TVST Organizational Unit: Shipping Points VSTEL
OIJHCT01 WERKS_D OIJHCT01 MANDT T001W Plants/Branches MANDT
OIJHCT01 WERKS_D OIJHCT01 WERKS_D T001W Plants/Branches WERKS
OIJHCT01 WERKS_O OIJHCT01 MANDT T001W Plants/Branches MANDT
OIJHCT01 WERKS_O OIJHCT01 WERKS_O T001W Plants/Branches WERKS