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

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TSW (Application Component) Trader's and Scheduler's Workbench
     ⤷ OIJ (Package) TSW Traders and Schedulers Workbench

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIJHCT01	Table Relationship Diagram
Short Description	OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	TICKETNR	☑	OIJ_TKTNR	OIJ_TKTNR	CHAR	20	0	OIL-TSW: External ticket number	*
3	LOCID	☑	OIJ_LOCID	OIJ_LOCID	CHAR	10	0	Location ID	OIJLOC
4	TKT_YEAR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
5	TKT_MONTH	☑	OIJ_MONTH	AM_MONAT	NUMC	2	0	Calendar month
6	STATUS	☐	OIJ_ISTAT	OIJ_ISTAT	CHAR	1	0	Nomination Item status	OIJSTAT
7	SUBSTATUS	☐	OIJ_SSTAT	OIJ_SSTAT	CHAR	1	0	Nomination Item sub-status	OIJSUBSTAT
8	TKTSUBRC	☐	OIJ_TKTRC	OIJ_TKTRC	CHAR	2	0	OIL-TSW: Ticket process return code
9	NOMNR	☐	OIJ_NOMNR	OIJ_NOMNR	CHAR	20	0	Nomination number
10	NOMTK	☐	OIJ_NOMTK	OIJ_NOMTK	CHAR	20	0	Nomination (technical) Key	OIJNOMH
11	NOMIT	☐	OIJ_ITEM	OIJ_ITEM	NUMC	10	0	Nomination Key Item	OIJNOMI
12	TICKETTYPE	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
13	SITYP	☐	OIJ_SITYP	OIJ_SITYP	CHAR	2	0	Schedule type	TOIJ_EL_SITYPES
14	MVSCENARIO	☐	OIJ_MVSCEN	NUM02	NUMC	2	0	TSW: Movement scenario number
15	VERSION	☐	OIJ_TKTNR	OIJ_TKTNR	CHAR	20	0	OIL-TSW: External ticket number	*
16	CARRIER	☐	OIJ_CARRNR	LIFNR	CHAR	10	0	Transport system Carrier	LFA1
17	SHIPPER	☐	OIJ_SHIPNR	LIFNR	CHAR	10	0	Shipper	LFA1
18	SUPPLIER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
19	CONSIGNE	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
20	RECEIVER	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
21	VEHICLE	☐	OIG_VHLNMR	OIG_VHLNMR	CHAR	10	0	TD Vehicle Number	*
22	SHTYPE	☐	OIG_TDSTYP	OIG_TDSTYP	CHAR	4	0	TD shipment type	TOIGS
23	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
24	TSYST	☐	OIJ_TSYST	OIJ_TSYST	CHAR	10	0	Transport system	OIJTS
25	CARRNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
26	SHIPPNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
27	SUPPNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
28	CONSINAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
29	RECNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
30	TSNAM	☐	OIJ_TSNAM	OIJ_TSNAM	CHAR	60	0	OIL-TSW: Transport system name
31	LOCNAM	☐	OIJ_LOCNAM	OIJ_LOCNAM	CHAR	60	0	Location name (used by system owner)
32	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	TVST
33	MENGE	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
34	GROSQUAN	☐	OIJ_MENGE	MENG13	QUAN	13	3	Scheduled qty
35	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
36	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
37	CHARG_O	☐	OIJ_CHARGO	CHARG	CHAR	10	0	Batch origin Location	*
38	WERKS_O	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
39	LGORT_O	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
40	CHARG_D	☐	OIJ_CHARGD	CHARG	CHAR	10	0	Batch destination Location	MCH1
41	WERKS_D	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
42	LGORT_D	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
43	START_DATE	☐	DATUM	DATUM	DATS	8	0	Date
44	START_TIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
45	END_DATE	☐	DATUM	DATUM	DATS	8	0	Date
46	END_TIME	☐	UZEIT	UZEIT	TIMS	6	0	Time
47	O_API_GRAV	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
48	API_GRT_D	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
49	TSTMP	☐	OIB_TSTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Test Temperature: Observed Density
50	TSTEH	☐	OIB_TSTEH	MEINS	UNIT	3	0	Test Temperature Unit (Density): Measurement	T006
51	TDICH	☐	OIB_TDICH	OIB_DICHT	FLTP	16	16	Oil/Gas Test Density
52	DIS_MET_F	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
53	COM_COR_F	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
54	VOL_WATER	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
55	AVG_PR_PSI	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
56	PRS_COR_F	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
57	MTTMP	☐	OIB_MTTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Material Temperature: Observed Quantity
58	AVG_TEMP	☐	OIB_MTTMP	TEMP_VALUE	FLTP	16	16	Oil/Gas Material Temperature: Observed Quantity
59	MTTEH	☐	OIB_MTTEH	MEINS	UNIT	3	0	Oil/Gas Material Temperature Unit: Observed Quantity	T006
60	TMP_COR_F	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
61	SHIPTONAME	☐	CHAR35	CHAR35	CHAR	35	0	Data Element Type CHAR Length 35
62	TANKAGE	☐	OIJ_PARTNR	OIJ_PARTNR	CHAR	10	0	Location Partner
63	TANKNAME	☐	OIJ_PARNM	NAME	CHAR	35	0	OIL-TSW: Common partner name
64	TARIFF_NBR	☐	CHAR10	CHAR10	CHAR	10	0	Character Field Length = 10
65	METER_NBR	☐	OIG_MTR_NR	OIG_MTR_NR	CHAR	10	0	TD meter number
66	METER_FAC	☐	CHAR16	CHAR16	CHAR	16	0	Field of length 16
67	BEGIN_READ	☐	TIME	CHAR6	CHAR	6	0	Time in CHAR Format
68	END_READ	☐	TIME	CHAR6	CHAR	6	0	Time in CHAR Format
69	.INCLUDE	☐				0	0	OIL-TSW: Standard status field set (TSW)
70	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
71	ERZEIT	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
72	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
73	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
74	AEZEIT	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
75	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
76	BLOIND	☐	OIJ_BLOIND	XFELD	CHAR	1	0	Blocking indicator
77	DELIND	☐	OIJ_DELIND	XFELD	CHAR	1	0	Deletion indicator
78	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
79	INTERN_GEN	☐	OIJ_INTGEN	XFELD	CHAR	1	0	Internally Generated Ticket Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIJHCT01	CARRIER	LFA1	LIFNR
2	OIJHCT01	CHARG_D	MCH1	CHARG
3	OIJHCT01	LGORT_D	T001L	LGORT
4	OIJHCT01	LGORT_O	T001L	LGORT
5	OIJHCT01	LOCID	OIJLOC	LOCID
6	OIJHCT01	MANDT	T000	MANDT
7	OIJHCT01	MATNR	MARA	MATNR
8	OIJHCT01	MEINS	T006	MSEHI
9	OIJHCT01	MTTEH	T006	MSEHI
10	OIJHCT01	NOMIT	OIJNOMI	NOMIT
11	OIJHCT01	NOMTK	OIJNOMH	NOMTK
12	OIJHCT01	SHIPPER	LFA1	LIFNR
13	OIJHCT01	SHTYPE	TOIGS	SHTYP
14	OIJHCT01	SITYP	TOIJ_EL_SITYPES	SITYP
15	OIJHCT01	STATUS	OIJSTAT	STATUS
16	OIJHCT01	SUBSTATUS	OIJSUBSTAT	SUBSTATUS
17	OIJHCT01	TPLST	TTDS	TPLST
18	OIJHCT01	TSTEH	T006	MSEHI
19	OIJHCT01	TSYST	OIJTS	TSYST
20	OIJHCT01	VSTEL	TVST	VSTEL
21	OIJHCT01	WERKS_D	T001W	WERKS
22	OIJHCT01	WERKS_O	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in