SAP ABAP Table GHO_S_SP_OIL_AND_GAS_ENTITY (Oil and Gas Entity Complete Structure)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PP-PN (Application Component) Production Network
     ⤷ EA_GHO_PE_MDP (Package) Oil and Gas Entities: MDP Layer

Basic Data

Table Category	INTTAB	Structure
Structure	GHO_S_SP_OIL_AND_GAS_ENTITY	Table Relationship Diagram
Short Description	Oil and Gas Entity Complete Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Oil and Gas Header Structure
2	PE_TYPE	☐	GHO_PE_TYPE	GHO_PE_PETYPE	CHAR	10	0	Oil and Gas Entity Type
3	FIELD_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
4	CONCESSION_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
5	RESERVOIR_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
6	FIELD_CHG_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
7	CONCESSION_CHG_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
8	RESERVOIR_CHG_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
9	PLATFORM_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
10	PLATFORM_CHG_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
11	PE_ID	☐	GHO_PE_ID	GHO_PE_ID	CHAR	40	0	Oil and Gas Entity ID
12	DESCRIPTION	☐	GHO_PE_DESCR	GHO_PE_DESCR	CHAR	40	0	Oil and Gas Entity Description
13	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
14	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
15	OPERATOR	☐	GHO_PE_OPERATOR	GHO_PE_OPERATOR	CHAR	40	0	Oil and Gas Entity Operator
16	LESSOR	☐	GHO_PE_LESSOR		CHAR	40	0	Oil and Gas Lessor
17	DEPTH_FROM	☐	GHO_DR		DEC	10	3	OGE:Depth of Reservoir
18	UOM_FROM	☐	OPM_OGE_UOM	MEINS	UNIT	3	0	Unit of Measure for Oil and Gas Entity	*
19	DEPTH_TO	☐	GHO_DR		DEC	10	3	OGE:Depth of Reservoir
20	UOM_TO	☐	OPM_OGE_UOM	MEINS	UNIT	3	0	Unit of Measure for Oil and Gas Entity	*
21	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
22	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
23	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
24	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
25	OPERATOR_NAME	☐	GHO_OWNER_NAME		CHAR	80	0	Owner Name
26	LESSOR_NAME	☐	GHO_OWNER_NAME		CHAR	80	0	Owner Name
27	COUNTRY_DESC	☐	LANDX	TEXT15	CHAR	15	0	Country Name
28	REGION_DESC	☐	BEZEI	TEXT25	CHAR	25	0	Name of the controlling area
29	LONGITUDE	☐	GEOLON	GEOLONLAT	DEC	15	12	Geo location longitude
30	LONGITUDE_UNIT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
31	LATITUDE	☐	GEOLAT	GEOLONLAT	DEC	15	12	Geo location latitude
32	LATITUDE_UNIT	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
33	PLATFORM_TYPE	☐	GHO_AGGREGATE_V	GHO_PE_ID	CHAR	40	0	Aggregate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GHO_S_SP_OIL_AND_GAS_ENTITY	COUNTRY	T005	LAND1		1	CN
2	GHO_S_SP_OIL_AND_GAS_ENTITY	REGION	T005S	BLAND

History

Last changed by/on	SAP	20130529
SAP Release Created in	606