SAP ABAP Table ROXEE60123 (Function location extension table)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PP-PN-ANL (Application Component) Analytics
     ⤷ EA_GHO_ANL_CORE (Package) Analytics: Package for Core

Basic Data

Table Category	INTTAB	Structure
Structure	ROXEE60123	Table Relationship Diagram
Short Description	Function location extension table

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	*
2	TPLNR	☑	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
3	GHO_NETOBJ_TYPE	☐	GHO_NETOBJ_TYPE	GHO_NETOBJ_TYPE	CHAR	10	0	Network Object Type	GHO_NETOBJ_TYP
4	GHO_EXTENAL_ID	☐	GHO_EXTENAL_ID	GHO_EXTENAL_ID	CHAR	16	0	Unique External ID
5	LGORT_D	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
6	SYSTEM_ID	☐	GHO_MII_INSTANCE	GHO_MII_INSTANCE	CHAR	60	0	System ID
7	GHO_WELL_NAME	☐	GHO_WELL_NAME	GHO_WELL_NAME	CHAR	32	0	Well Name
8	GHO_WELLNAME_ALT	☐	GHO_WELL_NAME_ALT	GHO_WELL_NAME_ALT	CHAR	32	0	Alternative Well Name
9	GHO_CONN_DATE	☐	GHO_WELL_CONN_DATE	DATS	DATS	8	0	Connection Date
10	GHO_COMPL_DATE	☐	GHO_WELL_COMPL_DATE	DATS	DATS	8	0	Well Completion Date
11	WELL_TYPE	☐	GHO_WELL_TYPE	GHO_GEN_TYPE	NUMC	3	0	Well Type
12	GHO_PLABAND_DATE	☐	GHO_WELL_PLUG_ABANDON_DATE	DATS	DATS	8	0	Well Plug and Abandon Date
13	FLD_SYS_WELL_ID	☐	GHO_FLD_SYS_OBJ_ID	GHO_FLD_SYS_OBJ_ID	CHAR	32	0	Field System Object ID
14	WELL_TEST_TYPE	☐	GHO_WTYPE	GHO_WTYPE	CHAR	1	0	Well Test Type
15	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
16	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
17	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
18	AUART	☐	PM_AUFART	AUFART	CHAR	4	0	Order Type for Maintenance Orders	*
19	GHO_WC_REF_ID	☐	GHO_WC_REF_ID	TPLNR	CHAR	30	0	Well Reference	*
20	GHO_WC_NAME	☐	GHO_WC_NAME	GHO_WELL_NAME	CHAR	32	0	Well Completion Name
21	GHO_WC_NAME_ALT	☐	GHO_WC_NAME_ALT	GHO_WELL_NAME_ALT	CHAR	32	0	Alternative Well Completion Name
22	GHO_WC_TYPE	☐	GHO_WC_TYPE	GHO_GEN_TYPE	NUMC	3	0	Well Completion Type
23	GHO_WC_COMP_DATE	☐	DATUM	DATUM	DATS	8	0	Date
24	FLD_SYS_WC_ID	☐	GHO_FLD_SYS_OBJ_ID	GHO_FLD_SYS_OBJ_ID	CHAR	32	0	Field System Object ID
25	COMMINGLD_WC_IND	☐	GHO_COMMINGLED_WC_IND	BOOLEAN	CHAR	1	0	Commingled Well Completion Indicator
26	WC_WELLTEST_TYPE	☐	GHO_WTYPE	GHO_WTYPE	CHAR	1	0	Well Test Type
27	WC_PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
28	WC_PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
29	WC_PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
30	WC_AUART	☐	PM_AUFART	AUFART	CHAR	4	0	Order Type for Maintenance Orders	*
31	GHO_SUB_ADDRNUM	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
32	GHO_RESERVOIR	☐	GHO_RESERVOIR	GHO_PE_ID	CHAR	40	0	Reservoir
33	GHO_CONCESSION	☐	GHO_CONCESSION	GHO_PE_ID	CHAR	40	0	Concession
34	GHO_FIELD	☐	GHO_FIELD	GHO_PE_ID	CHAR	40	0	Field
35	GHO_SHORE_IND	☐	GHO_WELL_SHORE_IND	GHO_WELL_SHORE_IND	CHAR	3	0	Well Shore Indicator
36	GHO_MTR_DESCR	☐	GHO_MTR_DESCR	GHO_WC_DESCR	CHAR	40	0	Meter Description
37	GHO_MTR_TYPE	☐	GHO_MTR_TYPE	GHO_GEN_TYPE	NUMC	3	0	Meter Type
38	GHO_MTR_OP_MODE	☐	GHO_MTR_OP_MODE	GHO_WC_TYPE	CHAR	50	0	Meter Operating Mode
39	GHO_MTR_DESN_PRE	☐	GHO_MTR_DESN_PRE	GHO_MTR_PRESSURE	DEC	13	3	Meter Design Pressure
40	GHO_MTR_OP_PRE	☐	GHO_MTR_OP_PRE	GHO_MTR_PRESSURE	DEC	13	3	Meter Operating Pressure
41	GHO_MTR_DESN_TEM	☐	GHO_MTR_DESN_TEMP	GHO_MTR_PRESSURE	DEC	13	3	Meter Design Temperature
42	GHO_MTR_OP_TEMP	☐	GHO_MTR_OP_TEMP	GHO_MTR_PRESSURE	DEC	13	3	Meter Operating Temperature
43	GHO_MTR_LVR_FROM	☐	GHO_MTR_LVR_FROM	GHO_MTR_PRESSURE	DEC	13	3	Meter Liquid Viscosity Range From
44	GHO_MTR_LVR_TO	☐	GHO_MTR_LVR_TO	GHO_MTR_PRESSURE	DEC	13	3	Meter Liquid Viscosity Range To
45	GHO_MTR_LQD_RAT	☐	GHO_MTR_LIQD_RATIO_FRAC	GHO_MTR_LIQD_RATIO_FRAC	DEC	17	14	Meter Water / Liquid Ratio
46	GHO_MTR_VOL_FRA	☐	GHO_MTR_VOL_FRA	GHO_MTR_LIQD_RATIO	NUMC	3	0	Meter Gas / Volume Fraction
47	GHO_MTR_LQD_VOL	☐	GHO_MTR_LQD_VOL_FRAC	GHO_MTR_LIQD_RATIO_FRAC	DEC	17	14	Meter Liquid / Volume Fraction
48	GHO_MTR_DP_UOM	☐	GHO_MTR_DP_UOM	MEINS	UNIT	3	0	Meter Design Pressure UoM	*
49	GHO_MTR_DT_UOM	☐	GHO_MTR_DT_UOM	MEINS	UNIT	3	0	Meter Design Temperature UoM	*
50	GHO_MTR_OP_UOM	☐	GHO_MTR_OP_UOM	MEINS	UNIT	3	0	Meter Operating Pressure UoM	*
51	GHO_MTR_OT_UOM	☐	GHO_MTR_OT_UOM	MEINS	UNIT	3	0	Meter Operating Temperature UoM	*
52	GHO_MTR_LVRF_UOM	☐	GHO_MTR_LVRF_UOM	MEINS	UNIT	3	0	Meter Liquid Viscosity Range From UoM	*
53	GHO_MTR_LVRT_UOM	☐	GHO_MTR_LVRT_UOM	MEINS	UNIT	3	0	Meter Liquid Viscosity Range To UoM	*
54	GHO_MTR_LQDRATUI	☐	GHO_MTR_LIQD_RAT_UI	GHO_MTR_LIQD_RATIO_UI	CHAR	17	0	Meter Water / Liquid Ratio for UI
55	GHO_MTR_LQDVOLUI	☐	GHO_MTR_LQD_VOL_UI	GHO_MTR_LIQD_RATIO_UI	CHAR	17	0	Meter Liquid / Volume Fraction for UI
56	GHO_PUMP_DESCR	☐	GHO_PUMP_DESCR	GHO_WC_DESCR	CHAR	40	0	Pump Description
57	GHO_PUMP_TYPE	☐	GHO_PUMP_TYPE	GHO_GEN_TYPE	NUMC	3	0	Pump Type
58	GHO_PUMP_DRIVER	☐	GHO_PUMP_DRIVER	GHO_GEN_TYPE	NUMC	3	0	Type of Driver
59	GHO_PUMP_FLUID	☐	GHO_PUMP_FLUID	GHO_GEN_TYPE	NUMC	3	0	Fluid Handled
60	GHO_PUMP_APPL	☐	GHO_PUMP_APPL	GHO_GEN_TYPE	NUMC	3	0	Application
61	GHO_PUMP_DESIGN	☐	GHO_PUMP_DESIGN	GHO_GEN_TYPE	NUMC	3	0	Pump Design
62	GHO_PUMP_PR	☐	GHO_PUMP_POW_RATE	GHO_PUMP_POW_RATE	NUMC	8	0	Power Rating
63	GHO_PUMP_SP	☐	GHO_PUMP_SUC_PRES	GHO_PUMP_POW_RATE	NUMC	8	0	Suction Pressure
64	GHO_PUMP_DP	☐	GHO_PUMP_DIS_PRES	GHO_PUMP_POW_RATE	NUMC	8	0	Discharge Pressure
65	GHO_PUMP_SPEED	☐	GHO_PUMP_SPEED	GHO_PUMP_SPEED	NUMC	12	0	Pump Speed
66	GHO_PUMP_PR_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
67	GHO_PUMP_SP_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
68	GHO_PUMP_DP_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
69	GHO_PUMP_SD_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
70	GHO_UOS	☐	GHO_SEP_UOS	GHO_SEP_UOS	CHAR	3	0	Use of Separator
71	GHO_SEP_DP	☐	GHO_SEP_DESN_PREESURE	GHO_PRESSURE9	DEC	9	3	Separator Design Pressure
72	GHO_SEP_DP_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
73	GHO_SEP_OP	☐	GHO_SEP_OPR_PREESURE	GHO_PRESSURE9	DEC	9	3	Operating Pressure
74	GHO_SEP_OP_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
75	GHO_SEP_DT	☐	GHO_SEP_DESN_TEMP	GHO_PRESSURE6	DEC	6	2	Separator Design Temperature
76	GHO_SEP_DT_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
77	GHO_SEP_OT	☐	GHO_SEP_OPR_TEMP	GHO_PRESSURE6	DEC	6	2	Operating Temperature
78	GHO_SEP_OT_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
79	CHOKE_SIZE_VAL	☐	GHO_CHOKE_SIZE_VAL	GHO_MEASMNT	CHAR	30	0	Choke Size - Unit of Measure
80	CHOKE_SIZE_UOM	☐	GHO_CHOKE_SIZE_UOM	MEINS	UNIT	3	0	Choke Size - Unit of Measure	*
81	GHO_COMP_TYPE	☐	GHO_COMP_TYPE	GHO_GEN_TYPE	NUMC	3	0	Compressor Type
82	GHO_SP_FIRST	☐	GHO_COMP_SP_FIRST	GHO_PRESSURE9	DEC	9	3	Suction Pressure 1st Stage
83	GHO_SP_F_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
84	GHO_SP_SECOND	☐	GHO_COMP_SP_SECOND	GHO_PRESSURE9	DEC	9	3	Suction Pressure 2nd Stage
85	GHO_SP_S_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
86	GHO_DP_FIRST	☐	GHO_COMP_DP_FIRST	GHO_PRESSURE9	DEC	9	3	Discharge Pressure 1st Stage
87	GHO_DP_F_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
88	GHO_DP_SECOND	☐	GHO_COMP_DP_SECOND	GHO_PRESSURE9	DEC	9	3	Discharge Pressure 2nd Stage
89	GHO_DP_S_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
90	GHO_COMP_DT	☐	GHO_COMP_DT	GHO_TEMP6	DEC	6	2	Discharge Temperature
91	GHO_COMP_DT_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
92	GHO_COMP_POWER	☐	GHO_COMP_POWER		DEC	9	3	Compressor Power
93	GHO_POWER_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
94	GHO_TB_TYPE	☐	GHO_TB_TYPE	GHO_GEN_TYPE	NUMC	3	0	Turbine Type of Driven Unit
95	GHO_TB_DPR	☐	GHO_TB_DPR		NUMC	10	0	Turbine Power Rating (Design)
96	GHO_TB_DPR_UOM	☐	GHO_TB_DPR_UOM	MEINS	UNIT	3	0	Turbine Power Rating (Design) UoM	*
97	GHO_TB_OPR	☐	GHO_TB_OPR		NUMC	10	0	Turbine Power Rating (Operating)
98	GHO_TB_OPR_UOM	☐	GHO_TB_OPR_UOM	MEINS	UNIT	3	0	Power Rating (Operating) UoM	*
99	GHO_TB_SPD	☐	GHO_TB_SPD		NUMC	10	0	Turbine Speed
100	GHO_TB_SPD_UOM	☐	GHO_TB_SPD_UOM	MEINS	UNIT	3	0	Turbine Speed UoM	*
101	GHO_TB_FL_TYPE	☐	GHO_TB_FL_TYPE	GHO_GEN_TYPE	NUMC	3	0	Turbine Fuel Type
102	GHO_OFS	☐	GHO_OFS	GHO_GEN_TYPE	NUMC	3	0	Orientation of Flare Stack
103	GHO_LFS	☐	GHO_LFS		DEC	10	3	Length of Flare Stack
104	GHO_LFS_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
105	GHO_PN_TZ	☐	GHO_PN_TZ	TZNZONE	CHAR	6	0	Production Network Time Zone	*
106	GHO_PN_SBD	☐	GHO_PN_START_BUS_DAY		TIMS	6	0	Start of Business day
107	GHO_PN_NW_ALLOC	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
108	NETID	☐	NETID	NETID	CHAR	8	0	Network identification	*
109	OPERATOR	☐	GHO_PE_OPERATOR	GHO_PE_OPERATOR	CHAR	40	0	Oil and Gas Entity Operator
110	SEQNR	☐	GHO_TANK_ID	GHO_TANK_ID	CHAR	10	0	Tank ID
111	TANK_TYPE	☐	GHO_TANK_TYPE	GHO_GEN_TYPE	NUMC	3	0	Tank Type
112	GHO_SUBSURF_IND	☐	GHO_WELL_SUBSURFACE_IND	BOOLEAN	CHAR	1	0	Well Subsurface Indicator
113	GHO_ELEVATION_RE	☐	GHO_ELEVATION_REF	GHO_ELEVATION_REF	CHAR	16	0	Elevation Reference
114	GHO_WELL_TVD	☐	GHO_WELL_TVD	GEOALT	DEC	9	3	True Vertical Depth
115	GHO_PERF_FROM	☐	GHO_WC_PERF_FRM	GEOALT	DEC	9	3	WC Perforation From
116	GHO_PERF_TO	☐	GHO_WC_PERF_TO	GEOALT	DEC	9	3	WC Perforation To
117	GHO_HGR_DEPTH	☐	GHO_WC_HGR_DPT	GEOALT	DEC	9	3	WC Hanger Depth
118	GHO_SHOE_DEPTH	☐	GHO_WC_SHOE_DPT	GEOALT	DEC	9	3	WC Shoe Depth
119	GHO_ELEV_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
120	GHO_PERF_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
121	GHO_PERT_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
122	GHO_HGR_DEP_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
123	GHO_SHOE_DEP_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
124	GHO_DEPTH_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
125	GHO_WELL_TVD_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
126	GHO_DEH_TYPE	☐	GHO_DEH_TYPE	GHO_GEN_TYPE	NUMC	3	0	Dehydrator Type
127	GHO_DEH_DSN_TEMP	☐	GHO_DESN_TEMP	GHO_PRESSURE6	DEC	6	2	Design Temperature
128	GHO_DEH_OP_TEMP	☐	GHO_OP_TEMP	GHO_PRESSURE6	DEC	6	2	Operating Temperature
129	GHO_DEH_DT_UOM	☐	GHO_DT_UOM	MEINS	UNIT	3	0	Design Temperature	*
130	GHO_DEH_OT_UOM	☐	GHO_OT_UOM	MEINS	UNIT	3	0	Operating Temperature UoM	*
131	GHO_HT_CONFIG	☐	GHO_HT_CONFIG	GHO_GEN_TYPE	NUMC	3	0	Heater Treater Configuration
132	GHO_HT_TMECH	☐	GHO_HT_TMECH	GHO_GEN_TYPE	NUMC	3	0	Heater Treater- Treater Mechanism
133	GHO_HT_DESN_TEMP	☐	GHO_DESN_TEMP	GHO_PRESSURE6	DEC	6	2	Design Temperature
134	GHO_HT_OP_TEMP	☐	GHO_OP_TEMP	GHO_PRESSURE6	DEC	6	2	Operating Temperature
135	GHO_HT_DT_UOM	☐	GHO_DT_UOM	MEINS	UNIT	3	0	Design Temperature	*
136	GHO_HT_OT_UOM	☐	GHO_OT_UOM	MEINS	UNIT	3	0	Operating Temperature UoM	*
137	GHO_PIPE_DPRE	☐	GHO_PIPE_DESN_PRE	GHO_PIPE_PRESSURE	DEC	13	3	Pipeline Design Pressure
138	GHO_PIPE_DP_UOM	☐	GHO_PIPE_DP_UOM	MEINS	UNIT	3	0	Pipeline Design Pressure UoM	*
139	GHO_LPL	☐	GHO_LPL		DEC	10	3	Length of Pipeline
140	GHO_LEN_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
141	GHO_INDIAMETER	☐	GHO_DIAM	GHO_DIAM	DEC	7	2	Pipeline Diameter
142	GHO_IND_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
143	GHO_OUTDIAMETER	☐	GHO_DIAM	GHO_DIAM	DEC	7	2	Pipeline Diameter
144	GHO_OUTD_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
145	GHO_WALLTHICK	☐	GHO_WTHICK	GHO_DIAM	DEC	7	2	Wall Thickness of Pipeline
146	GHO_WT_UOM	☐	GHO_UOM	MEINS	UNIT	3	0	Unit of Measure	*
147	GHO_PIPEMATNR	☐	GHO_PIPEMATNR	GHO_PIPEMATNR	CHAR	2	0	Pipeline Material	*
148	GHO_MFOLD_DPRE	☐	GHO_MFOLD_DESN_PRE	GHO_MFOLD_PRESSURE	DEC	13	3	Manifold Design Pressure
149	GHO_MFOLD_DP_UOM	☐	GHO_MFOLD_DP_UOM	MEINS	UNIT	3	0	Manifold Design Pressure UoM	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROXEE60123	GHO_NETOBJ_TYPE	GHO_NETOBJ_TYP	NETOBJ_TYPE	KEY	1	N
2	ROXEE60123	TPLNR	IFLOT	TPLNR		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	606