GHO_IFLOT_EXT

Transparent Table Application Table

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)

ViewTypeJoinVDMDescription
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)

KeyField Data ElementDescription DomainTypeLength
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)
);