OIJHCT01

OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE | #obsolete | Component: Trader's and Scheduler's Workbench
Column Name Description
MANDT FK Client
TICKETNR OIL-TSW: External ticket number
LOCID FK Location ID
TKT_YEAR Fiscal Year
TKT_MONTH Calendar month Show values
Column Name Description
Column Name Description
📏 Base Unit of Measure (MEINS):
MENGE Scheduled qty
GROSQUAN Scheduled qty
Column Name Description
START_DATE Date
START_TIME Time
END_DATE Date
END_TIME Time
ERDAT Date on which the record was created
ERZEIT Time of creation
AEDAT Last Changed On
AEZEIT Time of day the record was changed
BUDAT Posting Date in the Document
Column Name Description
TKT_MONTH Calendar month Show values
TKTSUBRC OIL-TSW: Ticket process return code Show values
BLOIND Blocking indicator Show values
DELIND Deletion indicator Show values
TKTSELECT Flag to Set Tickets Selectable Show values
INTERN_GEN Internally Generated Ticket Indicator Show values
Column Name Description Domain name
NOMNR Nomination number OIJ_NOMNR
TICKETTYPE Character Field with Length 10 CHAR10
MVSCENARIO TSW: Movement scenario number NUM02
VERSION OIL-TSW: External ticket number OIJ_TKTNR
SUPPLIER Location Partner OIJ_PARTNR
CONSIGNE Location Partner OIJ_PARTNR
RECEIVER Location Partner OIJ_PARTNR
VEHICLE TD Vehicle Number OIG_VHLNMR
CARRNAME OIL-TSW: Common partner name NAME
SHIPPNAME OIL-TSW: Common partner name NAME
SUPPNAME OIL-TSW: Common partner name NAME
CONSINAME OIL-TSW: Common partner name NAME
RECNAME OIL-TSW: Common partner name NAME
TSNAM OIL-TSW: Transport system name OIJ_TSNAM
LOCNAM Location name (used by system owner) OIJ_LOCNAM
CHARG_O Batch origin Location CHARG
O_API_GRAV Oil/Gas Test Density OIB_DICHT
API_GRT_D Oil/Gas Test Density OIB_DICHT
TSTMP Oil/Gas Test Temperature: Observed Density TEMP_VALUE
TDICH Oil/Gas Test Density OIB_DICHT
DIS_MET_F Field of length 16 CHAR16
COM_COR_F Field of length 16 CHAR16
VOL_WATER Field of length 16 CHAR16
AVG_PR_PSI Field of length 16 CHAR16
PRS_COR_F Field of length 16 CHAR16
MTTMP Oil/Gas Material Temperature: Observed Quantity TEMP_VALUE
AVG_TEMP Oil/Gas Material Temperature: Observed Quantity TEMP_VALUE
TMP_COR_F Field of length 16 CHAR16
SHIPTONAME Data Element Type CHAR Length 35 CHAR35
TANKAGE Location Partner OIJ_PARTNR
TANKNAME OIL-TSW: Common partner name NAME
TARIFF_NBR Character Field with Length 10 CHAR10
METER_NBR TD meter number OIG_MTR_NR
METER_FAC Field of length 16 CHAR16
BEGIN_READ Time in CHAR Format CHAR6
END_READ Time in CHAR Format CHAR6
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
Master Data Relations Join Conditions
Transport system Carrier
  • OIJHCT01.MANDT == LFA1.MANDT
  • OIJHCT01.CARRIER == LFA1.LIFNR
Batch destination Location
  • Material Number
  • Client
  • Batch destination Location
  • OIJHCT01.MATNR == MCH1.MATNR
  • OIJHCT01.MANDT == MCH1.MANDT
  • OIJHCT01.CHARG_D == MCH1.CHARG
Storage location
  • Storage location
  • Client
  • Plant
  • OIJHCT01.LGORT_D == T001L.LGORT
  • OIJHCT01.MANDT == T001L.MANDT
  • OIJHCT01.WERKS_D == T001L.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • OIJHCT01.LGORT_O == T001L.LGORT
  • OIJHCT01.MANDT == T001L.MANDT
  • OIJHCT01.WERKS_O == T001L.WERKS
Location ID
  • OIJHCT01.MANDT == OIJLOC.MANDT
  • OIJHCT01.LOCID == OIJLOC.LOCID
Client OIJHCT01.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • OIJHCT01.MATNR == MARA.MATNR
  • OIJHCT01.MANDT == MARA.MANDT
Base Unit of Measure
  • OIJHCT01.MANDT == T006.MANDT
  • OIJHCT01.MEINS == T006.MSEHI
Oil/Gas Material Temperature Unit: Observed Quantity
  • OIJHCT01.MANDT == T006.MANDT
  • OIJHCT01.MTTEH == T006.MSEHI
Shipper
  • OIJHCT01.MANDT == LFA1.MANDT
  • OIJHCT01.SHIPPER == LFA1.LIFNR
TD shipment type
  • OIJHCT01.MANDT == TOIGS.CLIENT
  • OIJHCT01.SHTYPE == TOIGS.SHTYP
Schedule type
Nomination Item status
  • Nomination Item status
  • Client
  • ?
  • OIJHCT01.STATUS == OIJSTAT.STATUS
  • OIJHCT01.MANDT == OIJSTAT.MANDT
  • OIJHCT01.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
Nomination Item sub-status
  • Nomination Item status
  • Nomination Item sub-status
  • Client
  • ?
Transportation planning point
  • Transportation planning point
  • Client
  • OIJHCT01.TPLST == TTDS.TPLST
  • OIJHCT01.MANDT == TTDS.MANDT
Test Temperature Unit (Density): Measurement
  • OIJHCT01.MANDT == T006.MANDT
  • OIJHCT01.TSTEH == T006.MSEHI
Transport system
  • OIJHCT01.MANDT == OIJTS.MANDT
  • OIJHCT01.TSYST == OIJTS.TSYST
Shipping Point / Receiving Point
  • OIJHCT01.MANDT == TVST.MANDT
  • OIJHCT01.VSTEL == TVST.VSTEL
Plant
  • OIJHCT01.MANDT == T001W.MANDT
  • OIJHCT01.WERKS_D == T001W.WERKS
Plant
  • OIJHCT01.MANDT == T001W.MANDT
  • OIJHCT01.WERKS_O == T001W.WERKS