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

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




ABAP Code to SELECT data from OIJHCT01
Related tables to OIJHCT01
Access table OIJHCT01




Table field list including key, data, relationships and ABAP select examples

OIJHCT01 is a standard SAP Table which is used to store OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE data and is available within R/3 SAP systems depending on the version and release level.

The OIJHCT01 table consists of various fields, each holding specific information or linking keys about OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE data available in SAP. These include TICKETNR (OIL-TSW: External ticket number), LOCID (Location ID), TKT_YEAR (Fiscal Year), TKT_MONTH (Calendar month).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIJHCT01 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
TICKETNROIL-TSW: External ticket number OIJ_TKTNRCHAR20Assigned to domainALPHAOIJ_TKTNROIU
LOCIDLocation ID OIJ_LOCIDCHAR10OIJLOCOIJ_LOCIDOIX
TKT_YEARFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
TKT_MONTHCalendar month OIJ_MONTHNUMC2AM_MONAT
STATUSNomination Item status OIJ_ISTATCHAR1OIJSTATOIJ_ISTAT
SUBSTATUSNomination Item sub-status OIJ_SSTATCHAR1OIJSUBSTATOIJ_SSTAT
TKTSUBRCOIL-TSW: Ticket process return code OIJ_TKTRCCHAR2OIJ_TKTRC
NOMNRNomination number OIJ_NOMNRCHAR20OIJ_NOMNROIO
NOMTKNomination (technical) Key OIJ_NOMTKCHAR20OIJNOMHALPHAOIJ_NOMTK
NOMITNomination Key Item OIJ_ITEMNUMC10OIJNOMIOIJ_ITEM
TICKETTYPECharacter Field Length = 10 CHAR10CHAR10CHAR10
SITYPSchedule type OIJ_SITYPCHAR2TOIJ_EL_SITYPESOIJ_SITYP
MVSCENARIOTSW: Movement scenario number OIJ_MVSCENNUMC2NUM02
VERSIONOIL-TSW: External ticket number OIJ_TKTNRCHAR20Assigned to domainALPHAOIJ_TKTNROIU
CARRIERTransport system Carrier OIJ_CARRNRCHAR10LFA1ALPHALIFNR
SHIPPERShipper OIJ_SHIPNRCHAR10LFA1ALPHALIFNR
SUPPLIERLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
CONSIGNELocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
RECEIVERLocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
VEHICLETD Vehicle Number OIG_VHLNMRCHAR10Assigned to domainALPHAOIG_VHLNMROIV
SHTYPETD shipment type OIG_TDSTYPCHAR4TOIGSOIG_TDSTYPOIC
TPLSTTransportation planning point TPLSTCHAR4TTDSTPLSTTDP
TSYSTTransport system OIJ_TSYSTCHAR10OIJTSOIJ_TSYSTOIW
CARRNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
SHIPPNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
SUPPNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
CONSINAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
RECNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
TSNAMOIL-TSW: Transport system name OIJ_TSNAMCHAR60OIJ_TSNAM
LOCNAMLocation name (used by system owner) OIJ_LOCNAMCHAR60OIJ_LOCNAM
VSTELShipping Point/Receiving Point VSTELCHAR4TVSTVSTELVST
MENGEScheduled qty OIJ_MENGEQUAN13(3) MENG13
GROSQUANScheduled qty OIJ_MENGEQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
CHARG_OBatch origin Location OIJ_CHARGOCHAR10Assigned to domainCHARG
WERKS_OPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORT_OStorage Location LGORT_DCHAR4T001LLGORTLAG
CHARG_DBatch destination Location OIJ_CHARGDCHAR10MCH1CHARG
WERKS_DPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORT_DStorage Location LGORT_DCHAR4T001LLGORTLAG
START_DATEDate DATUMDATS8DATUM
START_TIMETime UZEITTIMS6UZEIT
END_DATEDate DATUMDATS8DATUM
END_TIMETime UZEITTIMS6UZEIT
O_API_GRAVOil/Gas Test Density OIB_TDICHFLTP16(16) OIB_DICHT
API_GRT_DOil/Gas Test Density OIB_TDICHFLTP16(16) OIB_DICHT
TSTMPOil/Gas Test Temperature: Observed Density OIB_TSTMPFLTP16(16) TEMP_VALUE
TSTEHTest Temperature Unit (Density): Measurement OIB_TSTEHUNIT3T006CUNITMEINS
TDICHOil/Gas Test Density OIB_TDICHFLTP16(16) OIB_DICHT
DIS_MET_FField of length 16 CHAR16CHAR16CHAR16
COM_COR_FField of length 16 CHAR16CHAR16CHAR16
VOL_WATERField of length 16 CHAR16CHAR16CHAR16
AVG_PR_PSIField of length 16 CHAR16CHAR16CHAR16
PRS_COR_FField of length 16 CHAR16CHAR16CHAR16
MTTMPOil/Gas Material Temperature: Observed Quantity OIB_MTTMPFLTP16(16) TEMP_VALUE
AVG_TEMPOil/Gas Material Temperature: Observed Quantity OIB_MTTMPFLTP16(16) TEMP_VALUE
MTTEHOil/Gas Material Temperature Unit: Observed Quantity OIB_MTTEHUNIT3T006CUNITMEINS
TMP_COR_FField of length 16 CHAR16CHAR16CHAR16
SHIPTONAMEData Element Type CHAR Length 35 CHAR35CHAR35CHAR35
TANKAGELocation Partner OIJ_PARTNRCHAR10ALPHAOIJ_PARTNR
TANKNAMEOIL-TSW: Common partner name OIJ_PARNMCHAR35NAME
TARIFF_NBRCharacter Field Length = 10 CHAR10CHAR10CHAR10
METER_NBRTD meter number OIG_MTR_NRCHAR10ALPHAOIG_MTR_NR
METER_FACField of length 16 CHAR16CHAR16CHAR16
BEGIN_READTime in CHAR Format TIMECHAR6CHAR6
END_READTime in CHAR Format TIMECHAR6CHAR6
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZEITTime of creation OI0_ERTIMTIMS6UZEIT
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AEZEITTime of day the record was changed OI0_AETIMTIMS6UZEIT
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BLOINDBlocking indicator OIJ_BLOINDCHAR1XFELD
DELINDDeletion indicator OIJ_DELINDCHAR1XFELD
BUDATPosting Date in the Document BUDATDATS8DATUM
INTERN_GENInternally Generated Ticket Indicator OIJ_INTGENCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table OIJHCT01 using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIJHCT01 to SELECT all data from the table
DATA: WA_OIJHCT01 TYPE OIJHCT01.

SELECT SINGLE *
FROM OIJHCT01
INTO CORRESPONDING FIELDS OF WA_OIJHCT01
WHERE...

How to access SAP table OIJHCT01

Within an ECC or HANA version of SAP you can also view further information about OIJHCT01 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!