GHO_IFLOT_EXT
Function location extension table
GHO_IFLOT_EXT is an SAP database table in S/4HANA. Function location extension table. It contains 193 fields. 55 CDS views read from this table.
CDS Views using this table (55)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_GHOProdnNtwkObjectDetail | view | from | EXTENSION | Production Network Object Details Extension |
| E_GHOProductionNetwork | view | from | EXTENSION | Production Network Extension |
| I_GHOFunctionalLocation | view_entity | from | BASIC | UOM Specific Functional Location |
| I_GhoIFlotExt_Db | view | from | BASIC | Functional Location |
| I_GhoMeasDocItem_Db | view | inner | BASIC | Measurement Document Item |
| I_GhoNetObj_Db | view | from | BASIC | Network Object Details and Description |
| UPO_INT_V_ALLOC_DATA | view | inner | UOM Alloc Data for a Run Id | |
| UPO_INT_V_WCVD_ALL | view | inner | List of Well Completion | |
| UPO_INT_V_WCVD_BLNK_NON_PD_REC | view | inner | Records For Blank Non Producing Commingled WC | |
| UPO_INT_V_WCVD_BLNK_PRD_RECORD | view | inner | Blank Operator and Producing Record for Well Completion | |
| UPO_INT_V_WCVD_NON_PRD | view | inner | List of WC which are not Producing and Operating | |
| UPO_INT_V_WCVD_OP_NON_PRD_REC | view | inner | Operator and Producing Count for Well Completion | |
| UPO_INT_V_WCVD_PRD | view | inner | List of WC which are marked as Producing and Operating | |
| UPO_INT_V_WCVD_PRD_RECORD | view | inner | Producing Record For Commingled Well Completion | |
| UPO_INT_V_WCVD_TOTAL_RECORD | view | inner | Total Records Well Completion Wise | |
| UPO_INT_WCVD_UOM | view | inner | Integration view for WCVD | |
| upot_int_v_get_org_level_data | view | inner | Get org level data | |
| UPOV_ALLOC_DATA | view | inner | UOM Alloc Data for a Run Id | |
| UPOV_ALLOC_RESULTS_DIM | view | inner | Allocation Results based on dimension | |
| UPOV_ALLOC_RESULTS_WC | view | inner | Allocation Result details per WC | |
| UPOV_GET_WC | view | from | Separate WC from STRNO | |
| UPOV_ME_MEDOC_UOM | view | inner | Measurement document header UOM Data | |
| UPOV_MEASDOC_DTL | view | inner | Measurement document Details | |
| UPOV_NET_ID_FOR_MP | view | inner | Retrieve Prod Network of an MP | |
| UPOV_NETOBJ_FROM_MODELING | view | inner | Network Obects from UOM Modeling | |
| UPOV_NETOBJ_WITH_STATUS | view | inner | Netobjects with Source Status | |
| UPOV_NETOBJS | view | from | Network Objects with Alternate Label | |
| UPOV_NETOBJS_NETWORK | view | inner | Network Objects with Network Details | |
| UPOV_NWOBJ_NAME_TYPE | view | from | NW Object Name - Alpha Numeric / Numeric | |
| UPOV_NWOBJ_NAME_TYPE | view | union | NW Object Name - Alpha Numeric / Numeric | |
| UPOV_PPN_DATED_BA | view | left_outer | PPA FOR DATED | |
| UPOV_PPN_MP_BA_UOM | view | left_outer | Event Detail Ref - Before/After data | |
| UPOV_PR_ALKEY_OBJ | view | from | Alternate Labelling for Network objects | |
| UPOV_PR_DN_UOM | view | from | Delivery Network(UOM) | |
| UPOV_PR_DNVD_UOM | view | inner | Delivery Network Variable Data_UOM | |
| UPOV_PR_LINKS_UOM | view | inner | Delivery networks from UOM | |
| UPOV_PR_MP_UOM | view | from | Measurement Point (UOM) | |
| UPOV_PR_MPVL_UOM | view | inner | Measurement Point Volumetric Data (UOM) | |
| UPOV_PR_N_DN_UOM | view | from | Node on a delivery Network UOM | |
| UPOV_PR_N_MP_UOM | view | from | Delivery Network Node: Measur_Pt(UOM) | |
| UPOV_PR_N_WC_UMO | view | from | Delivery Network Node: Well Comp(UOM) | |
| UPOV_PR_WC_UOM | view | from | UOM: Well Completion | |
| UPOV_PR_WC_UOM | view | inner | UOM: Well Completion | |
| UPOV_PR_WCDHH_UOM | view | inner | Downhole Commingled Well Completion UOM | |
| UPOV_PR_WCVD_UOM | view | left_outer | UOM: Well Completion Variable Data UOM | |
| UPOV_PR_WELL_UOM | view | from | UOM: Well | |
| UPOV_PR_WELLTEST_UOM | view | inner | Well Test UOM | |
| UPOV_PRODDATE_PNTZ | view | left_outer | Production Date in PN timezone | |
| UPOV_TRIM_FUNCLABEL_UOMWC | view | from | Trimmed Functional Location for Label WC | |
| UPOV_UOM_DATA | view | inner | UOM data for a Business Key | |
| UPOV_UOM_WCDPS | view | inner | Well Completion Daily Pressures (UOM) | |
| UPOV_WC_THEO_VALUE | view | inner | Theoretical Volume at Well Completion | |
| UPOV_WCDPS_MEAS_VALUE | view | inner | WCDPS - Choke Size and Tubing Pressure | |
| UPOV_WCDTR_WC_DATA | view | inner | Contains Well comp reason code data | |
| UPOV_WCDTR_WC_DATA | view | left_outer | Contains Well comp reason code data |
Fields (193)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | mandt | MANDT | |
| KEY | tplnr | TPLNR | |
| gho_netobj_type | GHO_NETOBJ_TYPE | ||
| gho_extenal_id | GHO_EXTENAL_ID | ||
| lgort_d | LGORT_D | ||
| system_id | GHO_MII_INSTANCE | ||
| gho_well_name | GHO_WELL_NAME | ||
| gho_wellname_alt | GHO_WELL_NAME_ALT | ||
| gho_conn_date | GHO_WELL_CONN_DATE | ||
| gho_compl_date | GHO_WELL_COMPL_DATE | ||
| well_type | GHO_WELL_TYPE | ||
| gho_plaband_date | GHO_WELL_PLUG_ABANDON_DATE | ||
| fld_sys_well_id | GHO_FLD_SYS_OBJ_ID | ||
| well_test_type | GHO_WTYPE | ||
| plnty | PLNTY | ||
| plnnr | PLNNR | ||
| plnal | PLNAL | ||
| auart | PM_AUFART | ||
| api_no | OIU_WLAPI | ||
| lcl_wl_no | UPO_UDM_LCL_WL_NO | ||
| qtr_1_no | OIU_QTR_1_NO | ||
| qtr_2_no | OIU_QTR_2_NO | ||
| section_no | OIU_SECTION_NO | ||
| twp_no | OIU_TWP_NO | ||
| twp_dir_cd | UPO_UDM_TWP_DIR_CD | ||
| rng_no | OIU_RNG_NO | ||
| rng_dir_cd | UPO_UDM_RNG_DIR_CD | ||
| mms_owner_cd | OIU_MMS_OWNER_FL | ||
| slot_no | OIU_SLOT_NO | ||
| gho_wc_ref_id | GHO_WC_REF_ID | ||
| gho_wc_name | GHO_WC_NAME | ||
| gho_wc_name_alt | GHO_WC_NAME_ALT | ||
| gho_wc_type | GHO_WC_TYPE | ||
| gho_wc_comp_date | DATUM | ||
| fld_sys_wc_id | GHO_FLD_SYS_OBJ_ID | ||
| commingld_wc_ind | GHO_COMMINGLED_WC_IND | ||
| wc_welltest_type | GHO_WTYPE | ||
| wc_plnty | PLNTY | ||
| wc_plnnr | PLNNR | ||
| wc_plnal | PLNAL | ||
| wc_auart | PM_AUFART | ||
| api_wc_no | OIU_API_WC_NO | ||
| regional_wl_no | OIU_LCL_WL_NO | ||
| api_sidt | OIUREP_API_SIDT | ||
| cbm_indicator | /PRA/CBM_INDICATOR | ||
| or1_or_lvl_1_no | OIUH_CHAR3_ORGLVL1 | ||
| or1_or_lvl_1_nm | OIUH_OR1_OR_LVL_1_NM | ||
| or2_or_lvl_2_no | OIUH_CHAR1_ORGLVL2 | ||
| or2_or_lvl_2_nm | OIUH_OR2_OR_LVL_2_NM | ||
| or3_or_lvl_3_no | OIUH_CHAR3_ORGLVL3 | ||
| or3_or_lvl_3_nm | OIUH_OR3_OR_LVL_3_NM | ||
| or4_or_lvl_4_no | OIUH_CHAR2_ORGLVL4 | ||
| or4_or_lvl_4_nm | OIUH_OR4_OR_LVL_4_NM | ||
| operators | OIU_OPERATOR | ||
| gho_wellclass_id | GHO_WELLCLASS_ID | ||
| gho_sub_addrnum | AD_ADDRNUM | ||
| gho_reservoir | GHO_RESERVOIR | ||
| gho_concession | GHO_CONCESSION | ||
| gho_platform | GHO_AGGREGATE_TYPE | ||
| gho_field | GHO_FIELD | ||
| gho_shore_ind | GHO_WELL_SHORE_IND | ||
| gho_mtr_descr | GHO_MTR_DESCR | ||
| gho_mtr_type | GHO_MTR_TYPE | ||
| gho_mtr_op_mode | GHO_MTR_OP_MODE | ||
| gho_mtr_desn_pre | GHO_MTR_DESN_PRE | ||
| gho_mtr_op_pre | GHO_MTR_OP_PRE | ||
| gho_mtr_desn_tem | GHO_MTR_DESN_TEMP | ||
| gho_mtr_op_temp | GHO_MTR_OP_TEMP | ||
| gho_mtr_lvr_from | GHO_MTR_LVR_FROM | ||
| gho_mtr_lvr_to | GHO_MTR_LVR_TO | ||
| gho_mtr_lqd_rat | GHO_MTR_LIQD_RATIO_FRAC | ||
| gho_mtr_vol_fra | GHO_MTR_VOL_FRA | ||
| gho_mtr_lqd_vol | GHO_MTR_LQD_VOL_FRAC | ||
| gho_mtr_dp_uom | GHO_MTR_DP_UOM | ||
| gho_mtr_dt_uom | GHO_MTR_DT_UOM | ||
| gho_mtr_op_uom | GHO_MTR_OP_UOM | ||
| gho_mtr_ot_uom | GHO_MTR_OT_UOM | ||
| gho_mtr_lvrf_uom | GHO_MTR_LVRF_UOM | ||
| gho_mtr_lvrt_uom | GHO_MTR_LVRT_UOM | ||
| gho_mtr_lqdratui | GHO_MTR_LIQD_RAT_UI | ||
| gho_mtr_lqdvolui | GHO_MTR_LQD_VOL_UI | ||
| gho_pump_descr | GHO_PUMP_DESCR | ||
| gho_pump_type | GHO_PUMP_TYPE | ||
| gho_pump_driver | GHO_PUMP_DRIVER | ||
| gho_pump_fluid | GHO_PUMP_FLUID | ||
| gho_pump_appl | GHO_PUMP_APPL | ||
| gho_pump_design | GHO_PUMP_DESIGN | ||
| gho_pump_pr | GHO_PUMP_POW_RATE | ||
| gho_pump_sp | GHO_PUMP_SUC_PRES | ||
| gho_pump_dp | GHO_PUMP_DIS_PRES | ||
| gho_pump_speed | GHO_PUMP_SPEED | ||
| gho_pump_pr_uom | MEINS | ||
| gho_pump_sp_uom | MEINS | ||
| gho_pump_dp_uom | MEINS | ||
| gho_pump_sd_uom | MEINS | ||
| gho_uos | GHO_SEP_UOS | ||
| gho_sep_dp | GHO_SEP_DESN_PREESURE | ||
| gho_sep_dp_uom | GHO_UOM | ||
| gho_sep_op | GHO_SEP_OPR_PREESURE | ||
| gho_sep_op_uom | GHO_UOM | ||
| gho_sep_dt | GHO_SEP_DESN_TEMP | ||
| gho_sep_dt_uom | GHO_UOM | ||
| gho_sep_ot | GHO_SEP_OPR_TEMP | ||
| gho_sep_ot_uom | GHO_UOM | ||
| choke_size_val | GHO_CHOKE_SIZE_VAL | ||
| choke_size_uom | GHO_CHOKE_SIZE_UOM | ||
| gho_comp_type | GHO_COMP_TYPE | ||
| gho_sp_first | GHO_COMP_SP_FIRST | ||
| gho_sp_f_uom | GHO_UOM | ||
| gho_sp_second | GHO_COMP_SP_SECOND | ||
| gho_sp_s_uom | GHO_UOM | ||
| gho_dp_first | GHO_COMP_DP_FIRST | ||
| gho_dp_f_uom | GHO_UOM | ||
| gho_dp_second | GHO_COMP_DP_SECOND | ||
| gho_dp_s_uom | GHO_UOM | ||
| gho_comp_dt | GHO_COMP_DT | ||
| gho_comp_dt_uom | GHO_UOM | ||
| gho_comp_power | GHO_COMP_POWER | ||
| gho_power_uom | GHO_UOM | ||
| gho_tb_type | GHO_TB_TYPE | ||
| gho_tb_dpr | GHO_TB_DPR | ||
| gho_tb_dpr_uom | GHO_TB_DPR_UOM | ||
| gho_tb_opr | GHO_TB_OPR | ||
| gho_tb_opr_uom | GHO_TB_OPR_UOM | ||
| gho_tb_spd | GHO_TB_SPD | ||
| gho_tb_spd_uom | GHO_TB_SPD_UOM | ||
| gho_tb_fl_type | GHO_TB_FL_TYPE | ||
| gho_ofs | GHO_OFS | ||
| gho_lfs | GHO_LFS | ||
| gho_lfs_uom | GHO_UOM | ||
| gho_pn_tz | GHO_PN_TZ | ||
| gho_pn_sbd | GHO_PN_START_BUS_DAY | ||
| gho_pn_nw_alloc | BOOLE_D | ||
| netid | NETID | ||
| operator | GHO_PE_OPERATOR | ||
| status_profile | GHO_DE_STAT_PROFILE_ID | ||
| audit_profile_id | GHO_DE_AUDIT_ID | ||
| chem_ana_level | GHO_ANALYSIS_LEVEL | ||
| user_status_profile | GHO_DE_USER_STATUS_PROFILE | ||
| seqnr | GHO_TANK_ID | ||
| tank_type | GHO_TANK_TYPE | ||
| gho_subsurf_ind | GHO_WELL_SUBSURFACE_IND | ||
| gho_elevation_re | GHO_ELEVATION_REF | ||
| gho_well_tvd | GHO_WELL_TVD | ||
| gho_perf_from | GHO_WC_PERF_FRM | ||
| gho_perf_to | GHO_WC_PERF_TO | ||
| gho_hgr_depth | GHO_WC_HGR_DPT | ||
| gho_shoe_depth | GHO_WC_SHOE_DPT | ||
| gho_elev_uom | GHO_UOM | ||
| gho_perf_uom | GHO_UOM | ||
| gho_pert_uom | GHO_UOM | ||
| gho_hgr_dep_uom | GHO_UOM | ||
| gho_shoe_dep_uom | GHO_UOM | ||
| gho_depth_uom | GHO_UOM | ||
| gho_well_tvd_uom | GHO_UOM | ||
| gho_grnd_ele | GHO_FLARE_ELEV | ||
| gho_ge_uom | GHO_UOM | ||
| gho_top_ele | GHO_FLARE_TOPELEV | ||
| gho_te_uom | GHO_UOM | ||
| gho_deh_type | GHO_DEH_TYPE | ||
| gho_deh_dsn_temp | GHO_DESN_TEMP | ||
| gho_deh_op_temp | GHO_OP_TEMP | ||
| gho_deh_dt_uom | GHO_DT_UOM | ||
| gho_deh_ot_uom | GHO_OT_UOM | ||
| gho_ht_config | GHO_HT_CONFIG | ||
| gho_ht_tmech | GHO_HT_TMECH | ||
| gho_ht_desn_temp | GHO_DESN_TEMP | ||
| gho_ht_op_temp | GHO_OP_TEMP | ||
| gho_ht_dt_uom | GHO_DT_UOM | ||
| gho_ht_ot_uom | GHO_OT_UOM | ||
| gho_pipe_dpre | GHO_PIPE_DESN_PRE | ||
| gho_pipe_dp_uom | GHO_PIPE_DP_UOM | ||
| gho_lpl | GHO_LPL | ||
| gho_len_uom | GHO_UOM | ||
| gho_indiameter | GHO_DIAM | ||
| gho_ind_uom | GHO_UOM | ||
| gho_outdiameter | GHO_DIAM | ||
| gho_outd_uom | GHO_UOM | ||
| gho_wallthick | GHO_WTHICK | ||
| gho_wt_uom | GHO_UOM | ||
| gho_pipematnr | GHO_PIPEMATNR | ||
| gho_mfold_dpre | GHO_MFOLD_DESN_PRE | ||
| gho_mfold_dp_uom | GHO_MFOLD_DP_UOM | ||
| gho_chain_ind | GHO_CHAIN_IND | ||
| gho_clstr_desc | GHO_CLSTR_DESC | ||
| gho_clstr_type | GHO_CLSTR_TYPE | ||
| gho_gen_type | GHO_GEN_TYPE | ||
| gho_termpt_ind | GHO_TERMPT_IND | ||
| sec_geo_loc | OIU_SEC_GEO_LOC | ||
| sec_geo_desc | OIU_SEC_GEO_DESC | ||
| pn_hierarchy | SETNAMENEW | ||
| reszn | OIU_RESZNID | ||
| name | OIU_ZONE_NAME |