GHO_IFLOT_EXT - Function location extension table

Function location extension table information is stored in SAP table GHO_IFLOT_EXT.
It is part of development package APPL_GHO_NETOBJ_DB in software component IS-OIL-UOM-MD. This development package consists of objects that can be grouped under "DB layer for Network objects".

Fields for table GHO_IFLOT_EXT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
TPLNR	Functional Location	X	TPLNR	CHAR	60	IFLOT
GHO_NETOBJ_TYPE	Network Object Type		GHO_NETOBJ_TYPE	CHAR	20	GHO_NETOBJ_TYP
GHO_EXTENAL_ID	Unique External ID		GHO_EXTENAL_ID	CHAR	32
LGORT_D	Storage location		LGORT_D	CHAR	8
SYSTEM_ID	System ID		GHO_MII_INSTANCE	CHAR	120
.INCLUDE				GHO_S_WELL_GD	0
GHO_WELL_NAME	Well Name		GHO_WELL_NAME	CHAR	80
GHO_WELLNAME_ALT	Alternative Well Name		GHO_WELL_NAME_ALT	CHAR	80
GHO_CONN_DATE	Connection Date		GHO_WELL_CONN_DATE	DATS	16
GHO_COMPL_DATE	Well Completion Date		GHO_WELL_COMPL_DATE	DATS	16
WELL_TYPE	Well Type		GHO_WELL_TYPE	NUMC	6
GHO_PLABAND_DATE	Well Plug and Abandon Date		GHO_WELL_PLUG_ABANDON_DATE	DATS	16
FLD_SYS_WELL_ID	Field System Object ID		GHO_FLD_SYS_OBJ_ID	CHAR	64
WELL_TEST_TYPE	Well Test Type		GHO_WTYPE	CHAR	2
PLNTY	Task List Type		PLNTY	CHAR	2
PLNNR	Key for Task List Group		PLNNR	CHAR	16
PLNAL	Group Counter		PLNAL	CHAR	4
AUART	Order Type for Maintenance Orders		PM_AUFART	CHAR	8	*
.INCLUDE				CI_GHO_WELL	0
.INCLUDE	WELLDATA			UPOS_UDM_WELL_FIELDS	0
API_NO	API well number		OIU_WLAPI	CHAR	24
LCL_WL_NO	Regional Identifier		UPO_UDM_LCL_WL_NO	CHAR	30
QTR_1_NO	Quarter 1 Number		OIU_QTR_1_NO	CHAR	4
QTR_2_NO	Quarter 2 Number		OIU_QTR_2_NO	CHAR	4
SECTION_NO	Section Number		OIU_SECTION_NO	CHAR	6
TWP_NO	Township number		OIU_TWP_NO	CHAR	6
TWP_DIR_CD	Township direction code		UPO_UDM_TWP_DIR_CD	CHAR	2
RNG_NO	Range number		OIU_RNG_NO	CHAR	6
RNG_DIR_CD	Range Diection Code		UPO_UDM_RNG_DIR_CD	CHAR	2
MMS_OWNER_CD	MMS Ownership Code		OIU_MMS_OWNER_FL	CHAR	2
SLOT_NO	Slot Number (Base Meridian)		OIU_SLOT_NO	CHAR	10
GHO_WC_REF_ID	Well Reference		GHO_WC_REF_ID	CHAR	60
.INCLUDE				GHO_S_WC_GD	0
GHO_WC_NAME	Well Completion Name		GHO_WC_NAME	CHAR	80
GHO_WC_NAME_ALT	Alternative Well Completion Name		GHO_WC_NAME_ALT	CHAR	80
GHO_WC_TYPE	Well Completion Type		GHO_WC_TYPE	NUMC	6
GHO_WC_COMP_DATE	Date		DATUM	DATS	16
FLD_SYS_WC_ID	Field System Object ID		GHO_FLD_SYS_OBJ_ID	CHAR	64
COMMINGLD_WC_IND	Commingled Well Completion Indicator		GHO_COMMINGLED_WC_IND	CHAR	2
WC_WELLTEST_TYPE	Well Test Type		GHO_WTYPE	CHAR	2
WC_PLNTY	Task List Type		PLNTY	CHAR	2
WC_PLNNR	Key for Task List Group		PLNNR	CHAR	16
WC_PLNAL	Group Counter		PLNAL	CHAR	4
WC_AUART	Order Type for Maintenance Orders		PM_AUFART	CHAR	8	*
.INCLUDE				CI_GHO_WC	0
.INCLUDE				UPOS_UDM_WC_DATA	0
API_WC_NO	API well completion number		OIU_API_WC_NO	CHAR	6
REGIONAL_WL_NO	Local Well Number		OIU_LCL_WL_NO	CHAR	30
API_SIDT	Reg.Reporting - API Side Track		OIUREP_API_SIDT	CHAR	4
CBM_INDICATOR	Coal Bed Methane Indicator		/PRA/CBM_INDICATOR	CHAR	2
OR1_OR_LVL_1_NO	Org. Level 1 - Company		OIUH_CHAR3_ORGLVL1	CHAR	6	*
OR1_OR_LVL_1_NM	Name of highest organization level ( Compy Code)		OIUH_OR1_OR_LVL_1_NM	CHAR	80
OR2_OR_LVL_2_NO	Second-highest organization level number ( Company Code)		OIUH_CHAR1_ORGLVL2	CHAR	2
OR2_OR_LVL_2_NM	Name of second-highest organization level ( Compy Code)		OIUH_OR2_OR_LVL_2_NM	CHAR	28
OR3_OR_LVL_3_NO	Third-highest organization level number ( Company Code)		OIUH_CHAR3_ORGLVL3	CHAR	6
OR3_OR_LVL_3_NM	Name of third-highest organization level ( Compy Code)		OIUH_OR3_OR_LVL_3_NM	CHAR	28
OR4_OR_LVL_4_NO	Fourth-highest organization level number ( Company Code)		OIUH_CHAR2_ORGLVL4	CHAR	4
OR4_OR_LVL_4_NM	Name of fourth-highest organization level ( Compy Code)		OIUH_OR4_OR_LVL_4_NM	CHAR	28
OPERATORS	Operator		OIU_OPERATOR	CHAR	20	*
GHO_WELLCLASS_ID	Well Class ID		GHO_WELLCLASS_ID	CHAR	6
GHO_SUB_ADDRNUM	Address Number		AD_ADDRNUM	CHAR	20
.INCLUDE				GHO_S_NETOBJ_ADRC	0
GHO_RESERVOIR	Reservoir		GHO_RESERVOIR	CHAR	80
GHO_CONCESSION	Concession		GHO_CONCESSION	CHAR	80
GHO_PLATFORM	Platform Type		GHO_AGGREGATE_TYPE	CHAR	80
GHO_FIELD	Field		GHO_FIELD	CHAR	80
.INCLUDE				CI_NETOBJ_LOCATION	0
GHO_SHORE_IND	Well Shore Indicator		GHO_WELL_SHORE_IND	CHAR	6
.INCLUDE				GHO_S_MTR_GD	0
GHO_MTR_DESCR	Meter Description		GHO_MTR_DESCR	CHAR	80
GHO_MTR_TYPE	Meter Type		GHO_MTR_TYPE	NUMC	6
GHO_MTR_OP_MODE	Meter Operating Mode		GHO_MTR_OP_MODE	CHAR	100
GHO_MTR_DESN_PRE	Meter Design Pressure		GHO_MTR_DESN_PRE	DEC	7
GHO_MTR_OP_PRE	Meter Operating Pressure		GHO_MTR_OP_PRE	DEC	7
GHO_MTR_DESN_TEM	Meter Design Temperature		GHO_MTR_DESN_TEMP	DEC	7
GHO_MTR_OP_TEMP	Meter Operating Temperature		GHO_MTR_OP_TEMP	DEC	7
GHO_MTR_LVR_FROM	Meter Liquid Viscosity Range From		GHO_MTR_LVR_FROM	DEC	7
GHO_MTR_LVR_TO	Meter Liquid Viscosity Range To		GHO_MTR_LVR_TO	DEC	7
GHO_MTR_LQD_RAT	Meter Water / Liquid Ratio		GHO_MTR_LIQD_RATIO_FRAC	DEC	9
GHO_MTR_VOL_FRA	Meter Gas / Volume Fraction		GHO_MTR_VOL_FRA	NUMC	6
GHO_MTR_LQD_VOL	Meter Liquid / Volume Fraction		GHO_MTR_LQD_VOL_FRAC	DEC	9
GHO_MTR_DP_UOM	Meter Design Pressure UoM		GHO_MTR_DP_UOM	UNIT	6	*
GHO_MTR_DT_UOM	Meter Design Temperature UoM		GHO_MTR_DT_UOM	UNIT	6	*
GHO_MTR_OP_UOM	Meter Operating Pressure UoM		GHO_MTR_OP_UOM	UNIT	6	*
GHO_MTR_OT_UOM	Meter Operating Temperature UoM		GHO_MTR_OT_UOM	UNIT	6	*
GHO_MTR_LVRF_UOM	Meter Liquid Viscosity Range From UoM		GHO_MTR_LVRF_UOM	UNIT	6	*
GHO_MTR_LVRT_UOM	Meter Liquid Viscosity Range To UoM		GHO_MTR_LVRT_UOM	UNIT	6	*
GHO_MTR_LQDRATUI	Meter Water / Liquid Ratio for UI		GHO_MTR_LIQD_RAT_UI	CHAR	34
GHO_MTR_LQDVOLUI	Meter Liquid / Volume Fraction for UI		GHO_MTR_LQD_VOL_UI	CHAR	34
.INCLUDE				GHO_S_PUMP_GD	0
GHO_PUMP_DESCR	Pump Description		GHO_PUMP_DESCR	CHAR	80
GHO_PUMP_TYPE	Pump Type		GHO_PUMP_TYPE	NUMC	6
GHO_PUMP_DRIVER	Type of Driver		GHO_PUMP_DRIVER	NUMC	6
GHO_PUMP_FLUID	Fluid Handled		GHO_PUMP_FLUID	NUMC	6
GHO_PUMP_APPL	Application		GHO_PUMP_APPL	NUMC	6
GHO_PUMP_DESIGN	Pump Design		GHO_PUMP_DESIGN	NUMC	6
GHO_PUMP_PR	Power Rating		GHO_PUMP_POW_RATE	NUMC	16
GHO_PUMP_SP	Suction Pressure		GHO_PUMP_SUC_PRES	NUMC	16
GHO_PUMP_DP	Discharge Pressure		GHO_PUMP_DIS_PRES	NUMC	16
GHO_PUMP_SPEED	Pump Speed		GHO_PUMP_SPEED	NUMC	24
GHO_PUMP_PR_UOM	Base Unit of Measure		MEINS	UNIT	6	*
GHO_PUMP_SP_UOM	Base Unit of Measure		MEINS	UNIT	6	*
GHO_PUMP_DP_UOM	Base Unit of Measure		MEINS	UNIT	6	*
GHO_PUMP_SD_UOM	Base Unit of Measure		MEINS	UNIT	6	*
.INCLUDE				GHO_S_SEP_ITS	0
GHO_UOS	Use of Separator		GHO_SEP_UOS	CHAR	6
GHO_SEP_DP	Separator Design Pressure		GHO_SEP_DESN_PREESURE	DEC	5
GHO_SEP_DP_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_SEP_OP	Operating Pressure		GHO_SEP_OPR_PREESURE	DEC	5
GHO_SEP_OP_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_SEP_DT	Separator Design Temperature		GHO_SEP_DESN_TEMP	DEC	4
GHO_SEP_DT_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_SEP_OT	Operating Temperature		GHO_SEP_OPR_TEMP	DEC	4
GHO_SEP_OT_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
CHOKE_SIZE_VAL	Choke Size - Unit of Measure		GHO_CHOKE_SIZE_VAL	CHAR	60
CHOKE_SIZE_UOM	Choke Size - Unit of Measure		GHO_CHOKE_SIZE_UOM	UNIT	6
.INCLUDE				GHO_S_COMP_GD	0
GHO_COMP_TYPE	Compressor Type		GHO_COMP_TYPE	NUMC	6
GHO_SP_FIRST	Suction Pressure 1st Stage		GHO_COMP_SP_FIRST	DEC	5
GHO_SP_F_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_SP_SECOND	Suction Pressure 2nd Stage		GHO_COMP_SP_SECOND	DEC	5
GHO_SP_S_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_DP_FIRST	Discharge Pressure 1st Stage		GHO_COMP_DP_FIRST	DEC	5
GHO_DP_F_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_DP_SECOND	Discharge Pressure 2nd Stage		GHO_COMP_DP_SECOND	DEC	5
GHO_DP_S_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_COMP_DT	Discharge Temperature		GHO_COMP_DT	DEC	4
GHO_COMP_DT_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_COMP_POWER	Compressor Power		GHO_COMP_POWER	DEC	5
GHO_POWER_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
.INCLUDE				GHO_S_TB_GD	0
GHO_TB_TYPE	Turbine Type of Driven Unit		GHO_TB_TYPE	NUMC	6
GHO_TB_DPR	Turbine Power Rating (Design)		GHO_TB_DPR	NUMC	20
GHO_TB_DPR_UOM	Turbine Power Rating (Design) UoM		GHO_TB_DPR_UOM	UNIT	6	*
GHO_TB_OPR	Turbine Power Rating (Operating)		GHO_TB_OPR	NUMC	20
GHO_TB_OPR_UOM	Power Rating (Operating) UoM		GHO_TB_OPR_UOM	UNIT	6	*
GHO_TB_SPD	Turbine Speed		GHO_TB_SPD	NUMC	20
GHO_TB_SPD_UOM	Turbine Speed UoM		GHO_TB_SPD_UOM	UNIT	6	*
GHO_TB_FL_TYPE	Turbine Fuel Type		GHO_TB_FL_TYPE	NUMC	6
.INCLUDE				GHO_S_FLARE_GD	0
GHO_OFS	Orientation of Flare Stack		GHO_OFS	NUMC	6
GHO_LFS	Length of Flare Stack		GHO_LFS	DEC	6
GHO_LFS_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
.INCLUDE				GHO_S_PROD_NW_GD	0
GHO_PN_TZ	Production Network Time Zone		GHO_PN_TZ	CHAR	12	*
GHO_PN_SBD	Start of Business Day		GHO_PN_START_BUS_DAY	TIMS	12
GHO_PN_NW_ALLOC	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')		BOOLE_D	CHAR	2
NETID	Network identification		NETID	CHAR	16	*
OPERATOR	Oil and Gas Entity Operator		GHO_PE_OPERATOR	CHAR	80
.INCLUDE				GHO_S_SP_PROD_NW_GD_CI3	0
STATUS_PROFILE	Status Management Profile ID		GHO_DE_STAT_PROFILE_ID	CHAR	6
AUDIT_PROFILE_ID	Audit ID		GHO_DE_AUDIT_ID	CHAR	18
CHEM_ANA_LEVEL	Chemical Analysis Level for Capture Measurements		GHO_ANALYSIS_LEVEL	CHAR	10	*
USER_STATUS_PROFILE	GHO User Status Profile		GHO_DE_USER_STATUS_PROFILE	CHAR	16
.INCLUDE				GHO_S_TANK_GD	0
SEQNR	Tank ID		GHO_TANK_ID	CHAR	20
TANK_TYPE	Tank Type		GHO_TANK_TYPE	NUMC	6
.INCLUDE				GHO_S_GEOLOC	0
GHO_SUBSURF_IND	Well Subsurface Indicator		GHO_WELL_SUBSURFACE_IND	CHAR	2
GHO_ELEVATION_RE	Elevation Reference		GHO_ELEVATION_REF	CHAR	32
GHO_WELL_TVD	True Vertical Depth		GHO_WELL_TVD	DEC	5
GHO_PERF_FROM	WC Perforation From		GHO_WC_PERF_FRM	DEC	5
GHO_PERF_TO	WC Perforation To		GHO_WC_PERF_TO	DEC	5
GHO_HGR_DEPTH	WC Hanger Depth		GHO_WC_HGR_DPT	DEC	5
GHO_SHOE_DEPTH	WC Shoe Depth		GHO_WC_SHOE_DPT	DEC	5
GHO_ELEV_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_PERF_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_PERT_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_HGR_DEP_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_SHOE_DEP_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_DEPTH_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_WELL_TVD_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_GRND_ELE	Ground Elevation		GHO_FLARE_ELEV	DEC	7
GHO_GE_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_TOP_ELE	Top Elevation of Flare Stack		GHO_FLARE_TOPELEV	DEC	5
GHO_TE_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
.INCLUDE				GHO_S_DEH_GD	0
GHO_DEH_TYPE	Dehydrator Type		GHO_DEH_TYPE	NUMC	6
GHO_DEH_DSN_TEMP	Design Temperature		GHO_DESN_TEMP	DEC	4
GHO_DEH_OP_TEMP	Operating Temperature		GHO_OP_TEMP	DEC	4
GHO_DEH_DT_UOM	Design Temperature		GHO_DT_UOM	UNIT	6	*
GHO_DEH_OT_UOM	Operating Temperature UoM		GHO_OT_UOM	UNIT	6	*
.INCLUDE				GHO_S_HT_GD	0
GHO_HT_CONFIG	Heater Treater Configuration		GHO_HT_CONFIG	NUMC	6
GHO_HT_TMECH	Heater Treater- Treater Mechanism		GHO_HT_TMECH	NUMC	6
GHO_HT_DESN_TEMP	Design Temperature		GHO_DESN_TEMP	DEC	4
GHO_HT_OP_TEMP	Operating Temperature		GHO_OP_TEMP	DEC	4
GHO_HT_DT_UOM	Design Temperature		GHO_DT_UOM	UNIT	6	*
GHO_HT_OT_UOM	Operating Temperature UoM		GHO_OT_UOM	UNIT	6	*
.INCLUDE				GHO_S_PIPE_GD	0
GHO_PIPE_DPRE	Pipeline Design Pressure		GHO_PIPE_DESN_PRE	DEC	7
GHO_PIPE_DP_UOM	Pipeline Design Pressure UoM		GHO_PIPE_DP_UOM	UNIT	6	*
GHO_LPL	Length of Pipeline		GHO_LPL	DEC	6
GHO_LEN_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_INDIAMETER	Pipeline Diameter		GHO_DIAM	DEC	4
GHO_IND_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_OUTDIAMETER	Pipeline Diameter		GHO_DIAM	DEC	4
GHO_OUTD_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_WALLTHICK	Wall Thickness of Pipeline		GHO_WTHICK	DEC	4
GHO_WT_UOM	Unit of Measure		GHO_UOM	UNIT	6	*
GHO_PIPEMATNR	Pipeline Material		GHO_PIPEMATNR	CHAR	4	*
.INCLUDE				GHO_S_MFOLD_GD	0
GHO_MFOLD_DPRE	Manifold Design Pressure		GHO_MFOLD_DESN_PRE	DEC	7
GHO_MFOLD_DP_UOM	Manifold Design Pressure UoM		GHO_MFOLD_DP_UOM	UNIT	6	*
GHO_CHAIN_IND	Network Object Indicator to Allow Network Chaining		GHO_CHAIN_IND	CHAR	2
.INCLUDE				GHO_S_CI2_EXT	0
.INCLUDE				GHO_S_CLSTR_GD	0
GHO_CLSTR_DESC	Cluster Description		GHO_CLSTR_DESC	CHAR	80
GHO_CLSTR_TYPE	Cluster Type		GHO_CLSTR_TYPE	NUMC	6
.INCLUDE				GHO_S_GENERIC_GD	0
GHO_GEN_TYPE	Generic Object Type		GHO_GEN_TYPE	NUMC	6
.INCLUDE				GHO_S_GD_EXT	0
GHO_TERMPT_IND	Termination Point		GHO_TERMPT_IND	CHAR	2
.INCLUDE				UPOS_UDM_NETOBJ_GEO_LOC	0
SEC_GEO_LOC	Secondary geographic location		OIU_SEC_GEO_LOC	CHAR	6	UPOV_UDM_SEC_GEO
SEC_GEO_DESC	Secondary Geographical Location Description		OIU_SEC_GEO_DESC	CHAR	60
.INCLUDE				UPOS_UDM_PROD_NW_GD	0
PN_HIERARCHY	Set Name		SETNAMENEW	CHAR	48
.INCLUDE				UPOS_UDM_WC_RESV_ZONE	0
RESZN	Reservoir zone		OIU_RESZNID	CHAR	20	UPOT_UDM_RES_ZON
NAME	Zone name		OIU_ZONE_NAME	CHAR	70