GHO_PRDENTY_TYPE - Table for Holding Oil and Gas Entity

Table for Holding Oil and Gas Entity information is stored in SAP table GHO_PRDENTY_TYPE.
It is part of development package APPL_GHO_PE_DB in software component IS-OIL-UOM-MD. This development package consists of objects that can be grouped under "Producing Entities: DB layer".

Fields for table GHO_PRDENTY_TYPE

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
GHO_PE_TYPE	Oil and Gas Entity Type	X	GHO_PE_TYPE	CHAR	20
GHO_PE_ID	Oil and Gas Entity ID	X	GHO_PE_ID	CHAR	80
DESCR	Oil and Gas Entity Description		GHO_PE_DESCR	CHAR	80
OPERATOR	Oil and Gas Entity Operator		GHO_PE_OPERATOR	CHAR	80
LESSOR	Oil and Gas Lessor		GHO_PE_LESSOR	CHAR	80
COUNTRY	Country/Region Key		LAND1	CHAR	6
REGION	Region (State, Province, County)		REGIO	CHAR	6
DEPTH_FROM	OGE: Depth of Reservoir		GHO_DR	DEC	6
UOM_FROM	Unit of Measure for Oil and Gas Entity		OPM_OGE_UOM	UNIT	6
DEPTH_TO	OGE: Depth of Reservoir		GHO_DR_TO	DEC	6
UOM_TO	Unit of Measure for Oil and Gas Entity		OPM_OGE_UOM	UNIT	6
ERDAT	Date on which the record was created		ERDAT	DATS	16
ERNAM	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
AEDAT	Last Changed On		AEDAT	DATS	16
AENAM	Name of Person Who Changed Object		AENAM	CHAR	24
LONGITUDE_UNIT	Text, 40 Characters Long		TEXT40	CHAR	80
LATITUDE	Geo location latitude		GEOLAT	DEC	8
LONGITUDE	Geo location longitude		GEOLON	DEC	8
LATITUDE_UNIT	Text, 40 Characters Long		TEXT40	CHAR	80
PLATFORM_TYPE	Aggregate		GHO_AGGREGATE_V	CHAR	80
.INCLUDE				UPOS_UDM_OG_ENTITY_PLTFRM_DATA	0
FIRST_PRD_DT	First production date		OIU_FIRST_PRD_DT	DATS	16
INSTL_DT	Installation Date		OIU_INST_DT	DATS	16
LATITUDE_DIR_CD	Latitude direction code		OIU_LAT_DIR_CD	CHAR	2
LNGITUDE_DIR_CD	Longitude Direction Code		OIU_LNG_DIR_CD	CHAR	2
ROTARY_TBL_ELV_U	Rotary Table Elevation Unit		OIU_RTE_U	UNIT	6	*
ROTARY_TBL_ELV	Rotary Table elevation		OIU_RTE	QUAN	7
OFFSHORE_CODE	Offshore code		OIU_OFFSHO_CD	CHAR	2	*
PLATFORM_GRP	Platform group		OIU_PF_GRP	CHAR	8	*
.INCLUDE				UPOS_UDM_OG_ENTITY_FIELD_DATA	0
MAJOR_PRODUCT_CD	Major product code		OIU_MAJPD_CD	CHAR	2
WATER_DEPTH	Water depth		OIU_WATR_DPH	QUAN	7
WATER_DPTH_UNIT	Water depth unit		OIU_WATR_DPH_U	UNIT	6	*
FIELD_GROUP	Field group		OIU_FL_GRP	CHAR	8	*