GHO_IFLOT_EXT
Function location extension table
GHO_IFLOT_EXT is an SAP database table in S/4HANA. Function location extension table. It contains 12 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 (12)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | tplnr | tplnr | Functional loc. | |||
| gho_netobj_type | gho_netobj_type | Nw Obj Type | ||||
| gho_extenal_id | gho_extenal_id | External ID | ||||
| lgort_d | lgort_d | Location | ||||
| system_id | gho_mii_instance | System ID | ||||
| gho_wc_ref_id | gho_wc_ref_id | Well Reference | ||||
| gho_sub_addrnum | ad_addrnum | Address Number | ||||
| gho_shore_ind | gho_well_shore_ind | Shore Indicator | ||||
| choke_size_val | gho_choke_size_val | Unit of Measure | ||||
| choke_size_uom | gho_choke_size_uom | Unit of Measure | ||||
| gho_chain_ind | gho_chain_ind | Nw Chaining |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Function location extension table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GHO_IFLOT_EXT (
MANDT, -- Client [mandt]
TPLNR, -- Functional loc. [tplnr]
GHO_NETOBJ_TYPE, -- Nw Obj Type [gho_netobj_type]
GHO_EXTENAL_ID, -- External ID [gho_extenal_id]
LGORT_D, -- Location [lgort_d]
SYSTEM_ID, -- System ID [gho_mii_instance]
GHO_WC_REF_ID, -- Well Reference [gho_wc_ref_id]
GHO_SUB_ADDRNUM, -- Address Number [ad_addrnum]
GHO_SHORE_IND, -- Shore Indicator [gho_well_shore_ind]
CHOKE_SIZE_VAL, -- Unit of Measure [gho_choke_size_val]
CHOKE_SIZE_UOM, -- Unit of Measure [gho_choke_size_uom]
GHO_CHAIN_IND, -- Nw Chaining [gho_chain_ind]
PRIMARY KEY (MANDT, TPLNR)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA