OIJHCT01 SAP table for – OIL-TSW: Ticket Holding Table (Draft version 1) – OBSOLETE

Here we would like to draw your attention to OIJHCT01 table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIJHCT01 is a SAP standard transp table used for storing OIL-TSW: Ticket Holding Table (Draft version 1) – OBSOLETE related data in SAP. It comes under the package OIJ.

SAP OIJHCT01 table

Table OIJHCT01 technical data

TableOIJHCT01
Data storingOIL-TSW: Ticket Holding Table (Draft version 1) – OBSOLETE
ModuleIS-OIL
Sub ModuleIS-OIL-DS-TSW
SAP PackageOIJ
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIJHCT01 Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIJHCT01 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • TICKETNR : OIL-TSW: External ticket number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • LOCID : Location ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • TKT_YEAR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • TKT_MONTH : Calendar month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 2
  • STATUS : Nomination Item status
    Its data type is CHAR (Character String) with field length 1
  • SUBSTATUS : Nomination Item sub-status
    Its data type is CHAR (Character String) with field length 1
  • TKTSUBRC : OIL-TSW: Ticket process return code
    Its data type is CHAR (Character String) with field length 2
  • NOMNR : Nomination number
    Its data type is CHAR (Character String) with field length 20
  • NOMTK : Nomination (technical) Key
    Its data type is CHAR (Character String) with field length 20
  • NOMIT : Nomination Key Item
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • TICKETTYPE : Character Field Length = 10
    Its data type is CHAR (Character String) with field length 10
  • SITYP : Schedule type
    Its data type is CHAR (Character String) with field length 2
  • MVSCENARIO : TSW: Movement scenario number
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • VERSION : OIL-TSW: External ticket number
    Its data type is CHAR (Character String) with field length 20
  • CARRIER : Transport system Carrier
    Its data type is CHAR (Character String) with field length 10
  • SHIPPER : Shipper
    Its data type is CHAR (Character String) with field length 10
  • SUPPLIER : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • CONSIGNE : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • RECEIVER : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • VEHICLE : TD Vehicle Number
    Its data type is CHAR (Character String) with field length 10
  • SHTYPE : TD shipment type
    Its data type is CHAR (Character String) with field length 4
  • TPLST : Transportation planning point
    Its data type is CHAR (Character String) with field length 4
  • TSYST : Transport system
    Its data type is CHAR (Character String) with field length 10
  • CARRNAME : OIL-TSW: Common partner name
    Its data type is CHAR (Character String) with field length 35
  • SHIPPNAME : OIL-TSW: Common partner name
    Its data type is CHAR (Character String) with field length 35
  • SUPPNAME : OIL-TSW: Common partner name
    Its data type is CHAR (Character String) with field length 35
  • CONSINAME : OIL-TSW: Common partner name
    Its data type is CHAR (Character String) with field length 35
  • RECNAME : OIL-TSW: Common partner name
    Its data type is CHAR (Character String) with field length 35
  • TSNAM : OIL-TSW: Transport system name
    Its data type is CHAR (Character String) with field length 60
  • LOCNAM : Location name (used by system owner)
    Its data type is CHAR (Character String) with field length 60
  • VSTEL : Shipping Point/Receiving Point
    Its data type is CHAR (Character String) with field length 4
  • MENGE : Scheduled qty
    Its data type is QUAN (Quantity field) with field length 13
  • GROSQUAN : Scheduled qty
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • CHARG_O : Batch origin Location
    Its data type is CHAR (Character String) with field length 10
  • WERKS_O : Plant
    Its data type is CHAR (Character String) with field length 4
  • LGORT_O : Storage location
    Its data type is CHAR (Character String) with field length 4
  • CHARG_D : Batch destination Location
    Its data type is CHAR (Character String) with field length 10
  • WERKS_D : Plant
    Its data type is CHAR (Character String) with field length 4
  • LGORT_D : Storage location
    Its data type is CHAR (Character String) with field length 4
  • START_DATE : Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • START_TIME : Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • END_DATE : Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • END_TIME : Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • O_API_GRAV : Oil/Gas Test Density
    Its data type is FLTP (Floating point number) with field length 16
  • API_GRT_D : Oil/Gas Test Density
    Its data type is FLTP (Floating point number) with field length 16
  • TSTMP : Oil/Gas Test Temperature: Observed Density
    Its data type is FLTP (Floating point number) with field length 16
  • TSTEH : Test Temperature Unit (Density): Measurement
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TDICH : Oil/Gas Test Density
    Its data type is FLTP (Floating point number) with field length 16
  • DIS_MET_F : Field of length 16
    Its data type is CHAR (Character String) with field length 16
  • COM_COR_F : Field of length 16
    Its data type is CHAR (Character String) with field length 16
  • VOL_WATER : Field of length 16
    Its data type is CHAR (Character String) with field length 16
  • AVG_PR_PSI : Field of length 16
    Its data type is CHAR (Character String) with field length 16
  • PRS_COR_F : Field of length 16
    Its data type is CHAR (Character String) with field length 16
  • MTTMP : Oil/Gas Material Temperature: Observed Quantity
    Its data type is FLTP (Floating point number) with field length 16
  • AVG_TEMP : Oil/Gas Material Temperature: Observed Quantity
    Its data type is FLTP (Floating point number) with field length 16
  • MTTEH : Oil/Gas Material Temperature Unit: Observed Quantity
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TMP_COR_F : Field of length 16
    Its data type is CHAR (Character String) with field length 16
  • SHIPTONAME : Data Element Type CHAR Length 35
    Its data type is CHAR (Character String) with field length 35
  • TANKAGE : Location Partner
    Its data type is CHAR (Character String) with field length 10
  • TANKNAME : OIL-TSW: Common partner name
    Its data type is CHAR (Character String) with field length 35
  • TARIFF_NBR : Character Field Length = 10
    Its data type is CHAR (Character String) with field length 10
  • METER_NBR : TD meter number
    Its data type is CHAR (Character String) with field length 10
  • METER_FAC : Field of length 16
    Its data type is CHAR (Character String) with field length 16
  • BEGIN_READ : Time in CHAR Format
    Its data type is CHAR (Character String) with field length 6
  • END_READ : Time in CHAR Format
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : OIL-TSW: Standard status field set (TSW)
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • INTERN_GEN : Internally Generated Ticket Indicator
    Its data type is CHAR (Character String) with field length 1