GHO_PRDENTY_TYPE

Transparent Table Application Table
21 Fields 7 CDS Views

Table for Holding Oil and Gas Entity

GHO_PRDENTY_TYPE is an SAP database table in S/4HANA. Table for Holding Oil and Gas Entity. It contains 21 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_GHOProducingEntity view from BASIC Producing Entity
UPOV_PR_FLD_UOM view from Field UOM Data
UPOV_PR_PF_UOM view from UOM: Platform
UPOV_PR_RESZN view left_outer Reservoir Zone Identification
UPOV_PR_RESZN_UOM view from UOM: Reservoir Zone Identification
UPOV_RESERVOIR_UOM view from UOM: Reservoir
UPOV_TRIM_ONG_ENTITY_UOM view from Trimmed O&G Entity in UOM

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY gho_pe_type gho_pe_type Oil & Gas type
KEY gho_pe_id gho_pe_id Oil & Gas ID
descr gho_pe_descr Description
operator gho_pe_operator Operator
lessor gho_pe_lessor Lessor
country land1 Country/Reg.
region regio Region
depth_from gho_dr Depth From
uom_from opm_oge_uom Unit of Measurement
depth_to gho_dr_to Depth To
uom_to opm_oge_uom Unit of Measurement
erdat erdat Created On
ernam ernam Created By
aedat aedat Changed On
aenam aenam Changed By
longitude_unit text40 Name
latitude geolat Latitude
longitude geolon Longitude
latitude_unit text40 Name
platform_type gho_aggregate_v Aggregate

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.

-- Table for Holding Oil and Gas Entity
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE GHO_PRDENTY_TYPE (
    MANDT,           -- Client [mandt]
    GHO_PE_TYPE,     -- Oil & Gas type [gho_pe_type]
    GHO_PE_ID,       -- Oil & Gas ID [gho_pe_id]
    DESCR,           -- Description [gho_pe_descr]
    OPERATOR,        -- Operator [gho_pe_operator]
    LESSOR,          -- Lessor [gho_pe_lessor]
    COUNTRY,         -- Country/Reg. [land1]
    REGION,          -- Region [regio]
    DEPTH_FROM,      -- Depth From [gho_dr]
    UOM_FROM,        -- Unit of Measurement [opm_oge_uom]
    DEPTH_TO,        -- Depth To [gho_dr_to]
    UOM_TO,          -- Unit of Measurement [opm_oge_uom]
    ERDAT,           -- Created On [erdat]
    ERNAM,           -- Created By [ernam]
    AEDAT,           -- Changed On [aedat]
    AENAM,           -- Changed By [aenam]
    LONGITUDE_UNIT,  -- Name [text40]
    LATITUDE,        -- Latitude [geolat]
    LONGITUDE,       -- Longitude [geolon]
    LATITUDE_UNIT,   -- Name [text40]
    PLATFORM_TYPE,   -- Aggregate [gho_aggregate_v]
    PRIMARY KEY (MANDT, GHO_PE_TYPE, GHO_PE_ID)
);

Learn More