SAP ABAP Table GHO_IFLOT_EXT (Function location extension table)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   PP-PN-NO (Application Component) Network Objects
     APPL_GHO_NETOBJ_DB (Package) DB layer for Network objects
Basic Data
Table Category TRANSP    Transparent table 
Transparent table GHO_IFLOT_EXT   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 .INCLUDE       0   0   Well General Data  
8 GHO_WELL_NAME GHO_WELL_NAME GHO_WELL_NAME CHAR 32   0   Well Name  
9 GHO_WELLNAME_ALT GHO_WELL_NAME_ALT GHO_WELL_NAME_ALT CHAR 32   0   Alternative Well Name  
10 GHO_CONN_DATE GHO_WELL_CONN_DATE DATS DATS 8   0   Connection Date  
11 GHO_COMPL_DATE GHO_WELL_COMPL_DATE DATS DATS 8   0   Well Completion Date  
12 WELL_TYPE GHO_WELL_TYPE GHO_GEN_TYPE NUMC 3   0   Well Type  
13 GHO_PLABAND_DATE GHO_WELL_PLUG_ABANDON_DATE DATS DATS 8   0   Well Plug and Abandon Date  
14 FLD_SYS_WELL_ID GHO_FLD_SYS_OBJ_ID GHO_FLD_SYS_OBJ_ID CHAR 32   0   Field System Object ID  
15 WELL_TEST_TYPE GHO_WTYPE GHO_WTYPE CHAR 1   0   Well Test Type  
16 PLNTY PLNTY PLNTY CHAR 1   0   Task List Type *
17 PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
18 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
19 AUART PM_AUFART AUFART CHAR 4   0   Order Type for Maintenance Orders *
20 .INCLUDE       0   0    
21 GHO_WC_REF_ID GHO_WC_REF_ID TPLNR CHAR 30   0   Well Reference *
22 .INCLUDE       0   0   Well Completion General Data  
23 GHO_WC_NAME GHO_WC_NAME GHO_WELL_NAME CHAR 32   0   Well Completion Name  
24 GHO_WC_NAME_ALT GHO_WC_NAME_ALT GHO_WELL_NAME_ALT CHAR 32   0   Alternative Well Completion Name  
25 GHO_WC_TYPE GHO_WC_TYPE GHO_GEN_TYPE NUMC 3   0   Well Completion Type  
26 GHO_WC_COMP_DATE DATUM DATUM DATS 8   0   Date  
27 FLD_SYS_WC_ID GHO_FLD_SYS_OBJ_ID GHO_FLD_SYS_OBJ_ID CHAR 32   0   Field System Object ID  
28 COMMINGLD_WC_IND GHO_COMMINGLED_WC_IND BOOLEAN CHAR 1   0   Commingled Well Completion Indicator  
29 WC_WELLTEST_TYPE GHO_WTYPE GHO_WTYPE CHAR 1   0   Well Test Type  
30 WC_PLNTY PLNTY PLNTY CHAR 1   0   Task List Type *
31 WC_PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
32 WC_PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
33 WC_AUART PM_AUFART AUFART CHAR 4   0   Order Type for Maintenance Orders *
34 .INCLUDE       0   0    
35 GHO_SUB_ADDRNUM AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
36 .INCLUDE       0   0   Network Object Address  
37 GHO_RESERVOIR GHO_RESERVOIR GHO_PE_ID CHAR 40   0   Reservoir  
38 GHO_CONCESSION GHO_CONCESSION GHO_PE_ID CHAR 40   0   Concession  
39 GHO_PLATFORM GHO_AGGREGATE_TYPE GHO_AGGR_TYPE CHAR 40   0   Platform type  
40 GHO_FIELD GHO_FIELD GHO_PE_ID CHAR 40   0   Field  
41 .INCLUDE       0   0    
42 GHO_SHORE_IND GHO_WELL_SHORE_IND GHO_WELL_SHORE_IND CHAR 3   0   Well Shore Indicator  
43 .INCLUDE       0   0   Meter Identification / Technical Specification  
44 GHO_MTR_DESCR GHO_MTR_DESCR GHO_WC_DESCR CHAR 40   0   Meter Description  
45 GHO_MTR_TYPE GHO_MTR_TYPE GHO_GEN_TYPE NUMC 3   0   Meter Type  
46 GHO_MTR_OP_MODE GHO_MTR_OP_MODE GHO_WC_TYPE CHAR 50   0   Meter Operating Mode  
47 GHO_MTR_DESN_PRE GHO_MTR_DESN_PRE GHO_MTR_PRESSURE DEC 13   3   Meter Design Pressure  
48 GHO_MTR_OP_PRE GHO_MTR_OP_PRE GHO_MTR_PRESSURE DEC 13   3   Meter Operating Pressure  
49 GHO_MTR_DESN_TEM GHO_MTR_DESN_TEMP GHO_MTR_PRESSURE DEC 13   3   Meter Design Temperature  
50 GHO_MTR_OP_TEMP GHO_MTR_OP_TEMP GHO_MTR_PRESSURE DEC 13   3   Meter Operating Temperature  
51 GHO_MTR_LVR_FROM GHO_MTR_LVR_FROM GHO_MTR_PRESSURE DEC 13   3   Meter Liquid Viscosity Range From  
52 GHO_MTR_LVR_TO GHO_MTR_LVR_TO GHO_MTR_PRESSURE DEC 13   3   Meter Liquid Viscosity Range To  
53 GHO_MTR_LQD_RAT GHO_MTR_LIQD_RATIO_FRAC GHO_MTR_LIQD_RATIO_FRAC DEC 17   14   Meter Water / Liquid Ratio  
54 GHO_MTR_VOL_FRA GHO_MTR_VOL_FRA GHO_MTR_LIQD_RATIO NUMC 3   0   Meter Gas / Volume Fraction  
55 GHO_MTR_LQD_VOL GHO_MTR_LQD_VOL_FRAC GHO_MTR_LIQD_RATIO_FRAC DEC 17   14   Meter Liquid / Volume Fraction  
56 GHO_MTR_DP_UOM GHO_MTR_DP_UOM MEINS UNIT 3   0   Meter Design Pressure UoM *
57 GHO_MTR_DT_UOM GHO_MTR_DT_UOM MEINS UNIT 3   0   Meter Design Temperature UoM *
58 GHO_MTR_OP_UOM GHO_MTR_OP_UOM MEINS UNIT 3   0   Meter Operating Pressure UoM *
59 GHO_MTR_OT_UOM GHO_MTR_OT_UOM MEINS UNIT 3   0   Meter Operating Temperature UoM *
60 GHO_MTR_LVRF_UOM GHO_MTR_LVRF_UOM MEINS UNIT 3   0   Meter Liquid Viscosity Range From UoM *
61 GHO_MTR_LVRT_UOM GHO_MTR_LVRT_UOM MEINS UNIT 3   0   Meter Liquid Viscosity Range To UoM *
62 GHO_MTR_LQDRATUI GHO_MTR_LIQD_RAT_UI GHO_MTR_LIQD_RATIO_UI CHAR 17   0   Meter Water / Liquid Ratio for UI  
63 GHO_MTR_LQDVOLUI GHO_MTR_LQD_VOL_UI GHO_MTR_LIQD_RATIO_UI CHAR 17   0   Meter Liquid / Volume Fraction for UI  
64 .INCLUDE       0   0   Pump General Data  
65 GHO_PUMP_DESCR GHO_PUMP_DESCR GHO_WC_DESCR CHAR 40   0   Pump Description  
66 GHO_PUMP_TYPE GHO_PUMP_TYPE GHO_GEN_TYPE NUMC 3   0   Pump Type  
67 GHO_PUMP_DRIVER GHO_PUMP_DRIVER GHO_GEN_TYPE NUMC 3   0   Type of Driver  
68 GHO_PUMP_FLUID GHO_PUMP_FLUID GHO_GEN_TYPE NUMC 3   0   Fluid Handled  
69 GHO_PUMP_APPL GHO_PUMP_APPL GHO_GEN_TYPE NUMC 3   0   Application  
70 GHO_PUMP_DESIGN GHO_PUMP_DESIGN GHO_GEN_TYPE NUMC 3   0   Pump Design  
71 GHO_PUMP_PR GHO_PUMP_POW_RATE GHO_PUMP_POW_RATE NUMC 8   0   Power Rating  
72 GHO_PUMP_SP GHO_PUMP_SUC_PRES GHO_PUMP_POW_RATE NUMC 8   0   Suction Pressure  
73 GHO_PUMP_DP GHO_PUMP_DIS_PRES GHO_PUMP_POW_RATE NUMC 8   0   Discharge Pressure  
74 GHO_PUMP_SPEED GHO_PUMP_SPEED GHO_PUMP_SPEED NUMC 12   0   Pump Speed  
75 GHO_PUMP_PR_UOM MEINS MEINS UNIT 3   0   Base Unit of Measure *
76 GHO_PUMP_SP_UOM MEINS MEINS UNIT 3   0   Base Unit of Measure *
77 GHO_PUMP_DP_UOM MEINS MEINS UNIT 3   0   Base Unit of Measure *
78 GHO_PUMP_SD_UOM MEINS MEINS UNIT 3   0   Base Unit of Measure *
79 .INCLUDE       0   0   Separator Identification/ Tech. Specfications  
80 GHO_UOS GHO_SEP_UOS GHO_SEP_UOS CHAR 3   0   Use of Separator  
81 GHO_SEP_DP GHO_SEP_DESN_PREESURE GHO_PRESSURE9 DEC 9   3   Separator Design Pressure  
82 GHO_SEP_DP_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
83 GHO_SEP_OP GHO_SEP_OPR_PREESURE GHO_PRESSURE9 DEC 9   3   Operating Pressure  
84 GHO_SEP_OP_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
85 GHO_SEP_DT GHO_SEP_DESN_TEMP GHO_PRESSURE6 DEC 6   2   Separator Design Temperature  
86 GHO_SEP_DT_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
87 GHO_SEP_OT GHO_SEP_OPR_TEMP GHO_PRESSURE6 DEC 6   2   Operating Temperature  
88 GHO_SEP_OT_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
89 CHOKE_SIZE_VAL GHO_CHOKE_SIZE_VAL GHO_MEASMNT CHAR 30   0   Choke Size - Unit of Measure  
90 CHOKE_SIZE_UOM GHO_CHOKE_SIZE_UOM MEINS UNIT 3   0   Choke Size - Unit of Measure *
91 .INCLUDE       0   0   Compressor General Data  
92 GHO_COMP_TYPE GHO_COMP_TYPE GHO_GEN_TYPE NUMC 3   0   Compressor Type  
93 GHO_SP_FIRST GHO_COMP_SP_FIRST GHO_PRESSURE9 DEC 9   3   Suction Pressure 1st Stage  
94 GHO_SP_F_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
95 GHO_SP_SECOND GHO_COMP_SP_SECOND GHO_PRESSURE9 DEC 9   3   Suction Pressure 2nd Stage  
96 GHO_SP_S_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
97 GHO_DP_FIRST GHO_COMP_DP_FIRST GHO_PRESSURE9 DEC 9   3   Discharge Pressure 1st Stage  
98 GHO_DP_F_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
99 GHO_DP_SECOND GHO_COMP_DP_SECOND GHO_PRESSURE9 DEC 9   3   Discharge Pressure 2nd Stage  
100 GHO_DP_S_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
101 GHO_COMP_DT GHO_COMP_DT GHO_TEMP6 DEC 6   2   Discharge Temperature  
102 GHO_COMP_DT_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
103 GHO_COMP_POWER GHO_COMP_POWER   DEC 9   3   Compressor Power  
104 GHO_POWER_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
105 .INCLUDE       0   0   Turbine General Data  
106 GHO_TB_TYPE GHO_TB_TYPE GHO_GEN_TYPE NUMC 3   0   Turbine Type of Driven Unit  
107 GHO_TB_DPR GHO_TB_DPR   NUMC 10   0   Turbine Power Rating (Design)  
108 GHO_TB_DPR_UOM GHO_TB_DPR_UOM MEINS UNIT 3   0   Turbine Power Rating (Design) UoM *
109 GHO_TB_OPR GHO_TB_OPR   NUMC 10   0   Turbine Power Rating (Operating)  
110 GHO_TB_OPR_UOM GHO_TB_OPR_UOM MEINS UNIT 3   0   Power Rating (Operating) UoM *
111 GHO_TB_SPD GHO_TB_SPD   NUMC 10   0   Turbine Speed  
112 GHO_TB_SPD_UOM GHO_TB_SPD_UOM MEINS UNIT 3   0   Turbine Speed UoM *
113 GHO_TB_FL_TYPE GHO_TB_FL_TYPE GHO_GEN_TYPE NUMC 3   0   Turbine Fuel Type  
114 .INCLUDE       0   0   Flare Identification Data  
115 GHO_OFS GHO_OFS GHO_GEN_TYPE NUMC 3   0   Orientation of Flare Stack  
116 GHO_LFS GHO_LFS   DEC 10   3   Length of Flare Stack  
117 GHO_LFS_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
118 .INCLUDE       0   0   Production Network General Data  
119 GHO_PN_TZ GHO_PN_TZ TZNZONE CHAR 6   0   Production Network Time Zone *
120 GHO_PN_SBD GHO_PN_START_BUS_DAY   TIMS 6   0   Start of Business day  
121 GHO_PN_NW_ALLOC BOOLE_D BOOLE CHAR 1   0   Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')  
122 NETID NETID NETID CHAR 8   0   Network identification *
123 OPERATOR GHO_PE_OPERATOR GHO_PE_OPERATOR CHAR 40   0   Oil and Gas Entity Operator  
124 .INCLUDE       0   0   Tank General Data  
125 SEQNR GHO_TANK_ID GHO_TANK_ID CHAR 10   0   Tank ID  
126 TANK_TYPE GHO_TANK_TYPE GHO_GEN_TYPE NUMC 3   0   Tank Type  
127 .INCLUDE       0   0   Geoloc Extension structure  
128 GHO_SUBSURF_IND GHO_WELL_SUBSURFACE_IND BOOLEAN CHAR 1   0   Well Subsurface Indicator  
129 GHO_ELEVATION_RE GHO_ELEVATION_REF GHO_ELEVATION_REF CHAR 16   0   Elevation Reference  
130 GHO_WELL_TVD GHO_WELL_TVD GEOALT DEC 9   3   True Vertical Depth  
131 GHO_PERF_FROM GHO_WC_PERF_FRM GEOALT DEC 9   3   WC Perforation From  
132 GHO_PERF_TO GHO_WC_PERF_TO GEOALT DEC 9   3   WC Perforation To  
133 GHO_HGR_DEPTH GHO_WC_HGR_DPT GEOALT DEC 9   3   WC Hanger Depth  
134 GHO_SHOE_DEPTH GHO_WC_SHOE_DPT GEOALT DEC 9   3   WC Shoe Depth  
135 GHO_ELEV_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
136 GHO_PERF_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
137 GHO_PERT_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
138 GHO_HGR_DEP_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
139 GHO_SHOE_DEP_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
140 GHO_DEPTH_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
141 GHO_WELL_TVD_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
142 GHO_GRND_ELE GHO_FLARE_ELEV GEOALT DEC 9   3   Ground Elevation  
143 GHO_GE_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
144 GHO_TOP_ELE GHO_FLARE_TOPELEV GEOALT DEC 9   3   Top Elevation of Flare Stack  
145 GHO_TE_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
146 .INCLUDE       0   0   Dehydrator General Data  
147 GHO_DEH_TYPE GHO_DEH_TYPE GHO_GEN_TYPE NUMC 3   0   Dehydrator Type  
148 GHO_DEH_DSN_TEMP GHO_DESN_TEMP GHO_PRESSURE6 DEC 6   2   Design Temperature  
149 GHO_DEH_OP_TEMP GHO_OP_TEMP GHO_PRESSURE6 DEC 6   2   Operating Temperature  
150 GHO_DEH_DT_UOM GHO_DT_UOM MEINS UNIT 3   0   Design Temperature *
151 GHO_DEH_OT_UOM GHO_OT_UOM MEINS UNIT 3   0   Operating Temperature UoM *
152 .INCLUDE       0   0   Heater Treater General Data  
153 GHO_HT_CONFIG GHO_HT_CONFIG GHO_GEN_TYPE NUMC 3   0   Heater Treater Configuration  
154 GHO_HT_TMECH GHO_HT_TMECH GHO_GEN_TYPE NUMC 3   0   Heater Treater- Treater Mechanism  
155 GHO_HT_DESN_TEMP GHO_DESN_TEMP GHO_PRESSURE6 DEC 6   2   Design Temperature  
156 GHO_HT_OP_TEMP GHO_OP_TEMP GHO_PRESSURE6 DEC 6   2   Operating Temperature  
157 GHO_HT_DT_UOM GHO_DT_UOM MEINS UNIT 3   0   Design Temperature *
158 GHO_HT_OT_UOM GHO_OT_UOM MEINS UNIT 3   0   Operating Temperature UoM *
159 .INCLUDE       0   0   PipeLine General Data  
160 GHO_PIPE_DPRE GHO_PIPE_DESN_PRE GHO_PIPE_PRESSURE DEC 13   3   Pipeline Design Pressure  
161 GHO_PIPE_DP_UOM GHO_PIPE_DP_UOM MEINS UNIT 3   0   Pipeline Design Pressure UoM *
162 GHO_LPL GHO_LPL   DEC 10   3   Length of Pipeline  
163 GHO_LEN_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
164 GHO_INDIAMETER GHO_DIAM GHO_DIAM DEC 7   2   Pipeline Diameter  
165 GHO_IND_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
166 GHO_OUTDIAMETER GHO_DIAM GHO_DIAM DEC 7   2   Pipeline Diameter  
167 GHO_OUTD_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
168 GHO_WALLTHICK GHO_WTHICK GHO_DIAM DEC 7   2   Wall Thickness of Pipeline  
169 GHO_WT_UOM GHO_UOM MEINS UNIT 3   0   Unit of Measure *
170 GHO_PIPEMATNR GHO_PIPEMATNR GHO_PIPEMATNR CHAR 2   0   Pipeline Material *
171 .INCLUDE       0   0   Manoifold General Data  
172 GHO_MFOLD_DPRE GHO_MFOLD_DESN_PRE GHO_MFOLD_PRESSURE DEC 13   3   Manifold Design Pressure  
173 GHO_MFOLD_DP_UOM GHO_MFOLD_DP_UOM MEINS UNIT 3   0   Manifold Design Pressure UoM *
174 GHO_CHAIN_IND GHO_CHAIN_IND BOOLE CHAR 1   0   Netowrk Object Indicator to Allow Network Chaining  
175 .INCLUDE       0   0   New fields for cluster requirement  
176 .INCLUDE       0   0   Cluster General Data  
177 GHO_CLSTR_DESC GHO_CLSTR_DESC GHO_CLSTR_DESC CHAR 40   0   Cluster Description  
178 GHO_CLSTR_TYPE GHO_CLSTR_TYPE GHO_GEN_TYPE NUMC 3   0   Cluster Type  
179 .INCLUDE       0   0   Generic General Data  
180 GHO_GEN_TYPE GHO_GEN_TYPE GHO_GEN_TYPE NUMC 3   0   Generic Object Type  
181 .INCLUDE       0   0   General data Extension  
182 GHO_TERMPT_IND GHO_TERMPT_IND BOOLE CHAR 1   0   Termination Point  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 GHO_IFLOT_EXT GHO_NETOBJ_TYPE GHO_NETOBJ_TYP NETOBJ_TYPE KEY 1 N
2 GHO_IFLOT_EXT TPLNR IFLOT TPLNR 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in 605